{"current_page":1,"data":[{"id":11721855,"change_date":"2026-04-22 21:39:00","inspection_id":"87649428","dot_number":"227892","report_state":"IA","report_number":"000P14HZN3","insp_date":"2026-04-15 00:00:00","insp_start_time":"0838","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"MAIN ST BRANDON IA","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARGILL","shipping_paper_number":"300","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1398312","transaction_code":"A","transaction_date":"2026-04-22 00:00:00","upload_date":"2026-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00227892","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-04-15 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-04-22 21:39:00","insp_carrier_name":"HARNEY OIL","insp_carrier_street":"806-10 1ST AVE","insp_carrier_city":"CORALVILLE","insp_carrier_state":"IA","insp_carrier_zip_code":"52241","insp_colonia":null,"docket_number":"171942","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:39:44.000000Z","updated_at":"2026-05-03T09:31:11.000000Z","inspection_violations":[{"id":20377766,"change_date":"2026-04-22 21:39:00","inspection_id":"87649428","insp_violation_id":"273781354","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"213162517","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:58:52.000000Z","updated_at":"2026-05-03T09:42:57.000000Z","normalized_code":"39617C"},{"id":20377764,"change_date":"2026-04-22 21:39:00","inspection_id":"87649428","insp_violation_id":"273781352","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213162516","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:58:52.000000Z","updated_at":"2026-05-03T09:42:57.000000Z","normalized_code":"3922RG"},{"id":20377765,"change_date":"2026-04-22 21:39:00","inspection_id":"87649428","insp_violation_id":"273781353","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"213162517","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:58:52.000000Z","updated_at":"2026-05-03T09:42:57.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":20397197,"change_date":"2026-04-22 21:39:00","inspection_id":"87649428","insp_unit_id":"213162516","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"NA","insp_unit_license":"LM4377","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALXA7009EDFU6516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:17:15.000000Z","updated_at":"2026-05-03T09:04:07.000000Z"},{"id":20397198,"change_date":"2026-04-22 21:39:00","inspection_id":"87649428","insp_unit_id":"213162517","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"NA","insp_unit_license":"JA4437","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5HTSA452XP7119355","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:17:15.000000Z","updated_at":"2026-05-03T09:04:07.000000Z"}]},{"id":8631339,"change_date":"2025-05-14 21:42:00","inspection_id":"84668443","dot_number":"227892","report_state":"IA","report_number":"000P15VB26","insp_date":"2025-05-13 00:00:00","insp_start_time":"1420","insp_end_time":"1510","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 151 NB WALFORD","county_code_state":"IA","county_code":"011","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN","shipping_paper_number":"2019530","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1360036","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00227892","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-05-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"HARNEY OIL","insp_carrier_street":"806-10 1ST AVE","insp_carrier_city":"CORALVILLE","insp_carrier_state":"IA","insp_carrier_zip_code":"52241","insp_colonia":null,"docket_number":"171942","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-17T10:05:17.000000Z","updated_at":"2025-05-18T10:05:55.000000Z","inspection_violations":[{"id":13725654,"change_date":"2025-05-14 21:42:00","inspection_id":"84668443","insp_violation_id":"266219235","seq_no":"1","part_no":"392","part_no_section":"2MI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:26:59.000000Z","updated_at":"2025-05-18T10:33:23.000000Z","normalized_code":"3922MI"},{"id":13725655,"change_date":"2025-05-14 21:42:00","inspection_id":"84668443","insp_violation_id":"266219236","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"206855931","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:26:59.000000Z","updated_at":"2025-05-18T10:33:23.000000Z","normalized_code":"3922RG"},{"id":13725656,"change_date":"2025-05-14 21:42:00","inspection_id":"84668443","insp_violation_id":"266219237","seq_no":"3","part_no":"392","part_no_section":"2AU","insp_viol_unit":"1","insp_unit_id":"206855930","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:26:59.000000Z","updated_at":"2025-05-18T10:33:23.000000Z","normalized_code":"3922AU"},{"id":13725657,"change_date":"2025-05-14 21:42:00","inspection_id":"84668443","insp_violation_id":"266219238","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"206855931","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:26:59.000000Z","updated_at":"2025-05-18T10:33:23.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":14094123,"change_date":"2025-05-14 21:42:00","inspection_id":"84668443","insp_unit_id":"206855930","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"28","insp_unit_license":"LM4377","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALXA7009EDFU6516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:13.000000Z","updated_at":"2025-05-18T09:51:29.000000Z"},{"id":14094124,"change_date":"2025-05-14 21:42:00","inspection_id":"84668443","insp_unit_id":"206855931","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"22","insp_unit_license":"JA4437","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5HTSA452XP7119355","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:13.000000Z","updated_at":"2025-05-18T09:51:29.000000Z"}]},{"id":7154687,"change_date":"2024-11-08 21:40:00","inspection_id":"83114787","dot_number":"227892","report_state":"IA","report_number":"000P1213BS","insp_date":"2024-11-07 00:00:00","insp_start_time":"1200","insp_end_time":"1225","registration_date":null,"region":"CT","ci_status_code":"C","location":"16","location_desc":"16 - I380 SB MM 53 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARGILL","shipping_paper_number":"IB1470471005","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1336761","transaction_code":"A","transaction_date":"2024-11-08 00:00:00","upload_date":"2024-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00227892","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-11-07 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-11-08 21:40:00","insp_carrier_name":"HARNEY OIL","insp_carrier_street":"806-10 1ST AVE","insp_carrier_city":"CORALVILLE","insp_carrier_state":"IA","insp_carrier_zip_code":"52241","insp_colonia":null,"docket_number":"171942","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:09.000000Z","updated_at":"2025-03-17T20:45:09.000000Z","inspection_violations":[{"id":11176887,"change_date":"2024-11-08 21:40:00","inspection_id":"83114787","insp_violation_id":"262806976","seq_no":"1","part_no":"393","part_no_section":"11TT","insp_viol_unit":"1","insp_unit_id":"203803120","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:13.000000Z","updated_at":"2025-03-17T22:00:13.000000Z","normalized_code":"39311TT"},{"id":11176888,"change_date":"2024-11-08 21:40:00","inspection_id":"83114787","insp_violation_id":"262806977","seq_no":"2","part_no":"393","part_no_section":"45B2","insp_viol_unit":"1","insp_unit_id":"203803120","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:13.000000Z","updated_at":"2025-03-17T22:00:13.000000Z","normalized_code":"39345B2"},{"id":11176889,"change_date":"2024-11-08 21:40:00","inspection_id":"83114787","insp_violation_id":"262806978","seq_no":"3","part_no":"393","part_no_section":"45B2","insp_viol_unit":"1","insp_unit_id":"203803120","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:13.000000Z","updated_at":"2025-03-17T22:00:13.000000Z","normalized_code":"39345B2"},{"id":11176890,"change_date":"2024-11-08 21:40:00","inspection_id":"83114787","insp_violation_id":"262806979","seq_no":"4","part_no":"393","part_no_section":"45B2","insp_viol_unit":"1","insp_unit_id":"203803120","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:13.000000Z","updated_at":"2025-03-17T22:00:13.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":11539670,"change_date":"2024-11-08 21:40:00","inspection_id":"83114787","insp_unit_id":"203803120","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"14","insp_unit_license":"KS7361","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALXA7003EDFU2199","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:33.000000Z","updated_at":"2025-03-17T23:42:33.000000Z"},{"id":11539671,"change_date":"2024-11-08 21:40:00","inspection_id":"83114787","insp_unit_id":"203803121","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"9","insp_unit_license":"GF4054","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5HTAM442697H74963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:33.000000Z","updated_at":"2025-03-17T23:42:33.000000Z"}]},{"id":6348299,"change_date":"2024-07-30 21:44:00","inspection_id":"82256500","dot_number":"227892","report_state":"IA","report_number":"000P15NCS4","insp_date":"2024-07-30 00:00:00","insp_start_time":"0649","insp_end_time":"0700","registration_date":null,"region":"CT","ci_status_code":"C","location":"16","location_desc":"16 - I380 SB MM 53 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARGILL BIODIESEL","shipping_paper_number":"IFBD24072545","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1322986","transaction_code":"A","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00227892","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-07-30 21:44:00","insp_carrier_name":"HARNEY OIL","insp_carrier_street":"806-10 1ST AVE","insp_carrier_city":"CORALVILLE","insp_carrier_state":"IA","insp_carrier_zip_code":"52241","insp_colonia":null,"docket_number":"171942","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:41.000000Z","updated_at":"2025-03-17T20:28:41.000000Z","inspection_violations":[{"id":9855669,"change_date":"2024-07-30 21:44:00","inspection_id":"82256500","insp_violation_id":"260922056","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202149554","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:39.000000Z","updated_at":"2025-03-17T21:53:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10229942,"change_date":"2024-07-30 21:44:00","inspection_id":"82256500","insp_unit_id":"202149554","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"12","insp_unit_license":"GG8381","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJGEDV7CLBR7170","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:57.000000Z","updated_at":"2025-03-17T23:28:57.000000Z"},{"id":10229943,"change_date":"2024-07-30 21:44:00","inspection_id":"82256500","insp_unit_id":"202149555","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"22","insp_unit_license":"JA4437","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5HTSA452XP7119355","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:57.000000Z","updated_at":"2025-03-17T23:28:57.000000Z"}]},{"id":3081177,"change_date":"2023-05-18 21:43:00","inspection_id":"78662171","dot_number":"227892","report_state":"IA","report_number":"000TT6JHK4","insp_date":"2023-05-17 00:00:00","insp_start_time":"1130","insp_end_time":"1200","registration_date":null,"region":"CT","ci_status_code":"C","location":"15","location_desc":"15 - I380 NB MM 51 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAGELLAN","shipping_paper_number":"1896611","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1275836","transaction_code":"A","transaction_date":"2023-05-18 00:00:00","upload_date":"2023-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00227892","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-05-18 21:43:00","insp_carrier_name":"HARNEY OIL","insp_carrier_street":"806-10 1ST AVE","insp_carrier_city":"CORALVILLE","insp_carrier_state":"IA","insp_carrier_zip_code":"52241","insp_colonia":null,"docket_number":"171942","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:08.000000Z","updated_at":"2025-03-17T19:24:08.000000Z","inspection_violations":[{"id":4734912,"change_date":"2023-05-18 21:43:00","inspection_id":"78662171","insp_violation_id":"252920134","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195009747","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"3939A"},{"id":4734913,"change_date":"2023-05-18 21:43:00","inspection_id":"78662171","insp_violation_id":"252920135","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195009747","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"3963A1"},{"id":4734914,"change_date":"2023-05-18 21:43:00","inspection_id":"78662171","insp_violation_id":"252920136","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195009747","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":4956285,"change_date":"2023-05-18 21:43:00","inspection_id":"78662171","insp_unit_id":"195009747","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"14","insp_unit_license":"BK0494","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALXA7003EDFU2199","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:05.000000Z","updated_at":"2025-03-17T22:42:05.000000Z"},{"id":4956286,"change_date":"2023-05-18 21:43:00","inspection_id":"78662171","insp_unit_id":"195009748","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"9","insp_unit_license":"GF4054","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5HTAM442697H74963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:05.000000Z","updated_at":"2025-03-17T22:42:05.000000Z"}]},{"id":883158,"change_date":"2022-07-25 21:39:00","inspection_id":"76140665","dot_number":"227892","report_state":"IA","report_number":"000TT71SC9","insp_date":"2022-07-22 00:00:00","insp_start_time":"1339","insp_end_time":"1401","registration_date":null,"region":"CT","ci_status_code":"C","location":"16","location_desc":"16 - I380 SB MM 53 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARGILL","shipping_paper_number":"IB147861010","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1234659","transaction_code":"A","transaction_date":"2022-07-25 00:00:00","upload_date":"2022-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00227892","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-22 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-07-25 21:39:00","insp_carrier_name":"HARNEY OIL","insp_carrier_street":"806-10 1ST AVE","insp_carrier_city":"CORALVILLE","insp_carrier_state":"IA","insp_carrier_zip_code":"52241","insp_colonia":null,"docket_number":"171942","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:21.000000Z","updated_at":"2025-03-17T18:43:21.000000Z","inspection_violations":[{"id":1389376,"change_date":"2022-07-25 21:39:00","inspection_id":"76140665","insp_violation_id":"247279589","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3922"},{"id":1389377,"change_date":"2022-07-25 21:39:00","inspection_id":"76140665","insp_violation_id":"247279590","seq_no":"2","part_no":"383","part_no_section":"71(h)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"38371H"},{"id":1389378,"change_date":"2022-07-25 21:39:00","inspection_id":"76140665","insp_violation_id":"247279591","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189939889","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1421593,"change_date":"2022-07-25 21:39:00","inspection_id":"76140665","insp_unit_id":"189939889","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"GG8381","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJGEDV7CLBR7170","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:56.000000Z","updated_at":"2025-03-17T22:16:56.000000Z"},{"id":1421594,"change_date":"2022-07-25 21:39:00","inspection_id":"76140665","insp_unit_id":"189939890","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"AU3734","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5HTAM442047H67967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:56.000000Z","updated_at":"2025-03-17T22:16:56.000000Z"}]},{"id":626833,"change_date":"2022-06-16 21:43:00","inspection_id":"75840159","dot_number":"227892","report_state":"IA","report_number":"000TT7CQBC","insp_date":"2022-06-15 00:00:00","insp_start_time":"1025","insp_end_time":"1105","registration_date":null,"region":"CT","ci_status_code":"C","location":"15","location_desc":"15 - I380 NB MM 51 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAGELLAN","shipping_paper_number":"1837454","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1229257","transaction_code":"A","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00227892","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-15 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-06-16 21:43:00","insp_carrier_name":"HARNEY OIL","insp_carrier_street":"806-10 1ST AVE","insp_carrier_city":"CORALVILLE","insp_carrier_state":"IA","insp_carrier_zip_code":"52241","insp_colonia":null,"docket_number":"171942","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:47.000000Z","updated_at":"2025-03-17T18:38:47.000000Z","inspection_violations":[{"id":982897,"change_date":"2022-06-16 21:43:00","inspection_id":"75840159","insp_violation_id":"246513837","seq_no":"1","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"189292770","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"39375B"},{"id":982898,"change_date":"2022-06-16 21:43:00","inspection_id":"75840159","insp_violation_id":"246513838","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"189292771","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":1007445,"change_date":"2022-06-16 21:43:00","inspection_id":"75840159","insp_unit_id":"189292770","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"14","insp_unit_license":"BK0494","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALXA7003EDFU2199","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:23.000000Z","updated_at":"2025-03-17T22:14:23.000000Z"},{"id":1007446,"change_date":"2022-06-16 21:43:00","inspection_id":"75840159","insp_unit_id":"189292771","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"9","insp_unit_license":"GF4054","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5HTAM442697H74963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:23.000000Z","updated_at":"2025-03-17T22:14:23.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/227892\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/227892\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/227892\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/227892\/inspections","per_page":100,"prev_page_url":null,"to":7,"total":7}