{"current_page":1,"data":[{"id":11943445,"change_date":"2026-05-17 21:34:00","inspection_id":"87878674","dot_number":"1718885","report_state":"OH","report_number":"1251001257","insp_date":"2026-05-15 00:00:00","insp_start_time":"1104","insp_end_time":"1134","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LORDSTOWN OH","county_code_state":"OH","county_code":"155","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ADM","shipping_paper_number":"212044","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":"U","pen_cen_match":"I","final_status_date":"2026-05-17 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3347770","transaction_code":"A","transaction_date":"2026-05-16 00:00:00","upload_date":"2026-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":"2026-05-17 21:34:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-17 21:34:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-20T09:41:07.000000Z","updated_at":"2026-05-28T09:30:04.000000Z","inspection_violations":[{"id":20772970,"change_date":"2026-05-17 21:34:00","inspection_id":"87878674","insp_violation_id":"274319803","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-05-20T10:02:05.000000Z","updated_at":"2026-05-28T09:39:27.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":20768426,"change_date":"2026-05-17 21:34:00","inspection_id":"87878674","insp_unit_id":"213606469","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"333","insp_unit_license":"FY7821","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNSCR66C214732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-20T09:17:14.000000Z","updated_at":"2026-05-28T09:01:39.000000Z"},{"id":20768427,"change_date":"2026-05-17 21:34:00","inspection_id":"87878674","insp_unit_id":"213606470","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"449","insp_unit_license":"LH8631","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TDH42228DB139742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-20T09:17:14.000000Z","updated_at":"2026-05-28T09:01:39.000000Z"}]},{"id":11717783,"change_date":"2026-04-22 21:39:00","inspection_id":"87645122","dot_number":"1718885","report_state":"MO","report_number":"W164001550","insp_date":"2026-04-21 00:00:00","insp_start_time":"1019","insp_end_time":"1110","registration_date":null,"region":"CD","ci_status_code":"C","location":"H2S","location_desc":"EAGLEVILLE MO","county_code_state":"MO","county_code":"081","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"DIVERSIFIED ING","shipping_paper_number":"2026-202","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"8","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3194108","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":"2026-04-22 21:39:00","snet_input_date":"2026-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-22 21:39:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:39:10.000000Z","updated_at":"2026-05-03T09:30:33.000000Z","inspection_violations":[{"id":20370932,"change_date":"2026-04-22 21:39:00","inspection_id":"87645122","insp_violation_id":"273771637","seq_no":"8","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"213154382","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:42.000000Z","updated_at":"2026-05-03T09:41:50.000000Z","normalized_code":"3939ALTSIR"},{"id":20370933,"change_date":"2026-04-22 21:39:00","inspection_id":"87645122","insp_violation_id":"273771638","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","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":"2026-04-27T09:57:42.000000Z","updated_at":"2026-05-03T09:41:50.000000Z","normalized_code":"3922SLLEWA1"},{"id":20370934,"change_date":"2026-04-22 21:39:00","inspection_id":"87645122","insp_violation_id":"273771639","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"213154382","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:42.000000Z","updated_at":"2026-05-03T09:41:50.000000Z","normalized_code":"39345DB"},{"id":20370935,"change_date":"2026-04-22 21:39:00","inspection_id":"87645122","insp_violation_id":"273771640","seq_no":"3","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"1","insp_unit_id":"213154382","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:42.000000Z","updated_at":"2026-05-03T09:41:50.000000Z","normalized_code":"39348ABIBD"},{"id":20370936,"change_date":"2026-04-22 21:39:00","inspection_id":"87645122","insp_violation_id":"273771641","seq_no":"4","part_no":"393","part_no_section":"48A-BLMACBD","insp_viol_unit":"1","insp_unit_id":"213154382","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:42.000000Z","updated_at":"2026-05-03T09:41:50.000000Z","normalized_code":"39348ABLMACBD"},{"id":20370937,"change_date":"2026-04-22 21:39:00","inspection_id":"87645122","insp_violation_id":"273771642","seq_no":"5","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"213154382","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:42.000000Z","updated_at":"2026-05-03T09:41:50.000000Z","normalized_code":"3939ALHLI"},{"id":20370938,"change_date":"2026-04-22 21:39:00","inspection_id":"87645122","insp_violation_id":"273771643","seq_no":"6","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"213154382","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:42.000000Z","updated_at":"2026-05-03T09:41:50.000000Z","normalized_code":"3939ALRLI"},{"id":20370939,"change_date":"2026-04-22 21:39:00","inspection_id":"87645122","insp_violation_id":"273771644","seq_no":"7","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"213154382","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:42.000000Z","updated_at":"2026-05-03T09:41:50.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":20390649,"change_date":"2026-04-22 21:39:00","inspection_id":"87645122","insp_unit_id":"213154382","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"325","insp_unit_license":"FW7144","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPHD49X7DD194604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:16:15.000000Z","updated_at":"2026-05-03T09:03:14.000000Z"},{"id":20390650,"change_date":"2026-04-22 21:39:00","inspection_id":"87645122","insp_unit_id":"213154383","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TIMPTE","insp_unit_company":"450","insp_unit_license":"LH8753","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TDH40026GB153473","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:16:15.000000Z","updated_at":"2026-05-03T09:03:14.000000Z"}]},{"id":11398500,"change_date":"2026-03-17 21:39:00","inspection_id":"87313432","dot_number":"1718885","report_state":"IA","report_number":"000P14RQTZ","insp_date":"2026-03-13 00:00:00","insp_start_time":"1210","insp_end_time":"1230","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 1 AND 92 INTERSECTION","county_code_state":"IA","county_code":"183","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORMAN PUMPING","shipping_paper_number":null,"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":"2026-03-17 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1393874","transaction_code":"A","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-03-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-03-17 21:39:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-20T09:42:35.000000Z","updated_at":"2026-03-28T09:31:19.000000Z","inspection_violations":[{"id":19214376,"change_date":"2026-03-17 21:39:00","inspection_id":"87313432","insp_violation_id":"272453348","seq_no":"1","part_no":"392","part_no_section":"2-INAT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-20T10:03:43.000000Z","updated_at":"2026-03-28T09:46:49.000000Z","normalized_code":"3922INAT"}],"inspection_per_units":[{"id":19521254,"change_date":"2026-03-17 21:39:00","inspection_id":"87313432","insp_unit_id":"212182616","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"LR0003","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EH3EN153549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:28.000000Z","updated_at":"2026-03-28T09:05:36.000000Z"},{"id":19521255,"change_date":"2026-03-17 21:39:00","inspection_id":"87313432","insp_unit_id":"212182617","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRENNER","insp_unit_company":null,"insp_unit_license":"JT0957","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"10BFU7212JF008970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:28.000000Z","updated_at":"2026-03-28T09:05:36.000000Z"}]},{"id":11204009,"change_date":"2026-02-23 21:38:00","inspection_id":"87115035","dot_number":"1718885","report_state":"IA","report_number":"000P123Q8H","insp_date":"2026-02-20 00:00:00","insp_start_time":"1234","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":"45","location_desc":"45 - HWY 218 NB MM 29 PILOT GR","county_code_state":"IA","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"QUINCY FARM PRODUCTS","shipping_paper_number":"230012","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":"2026-02-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1391308","transaction_code":"A","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-02-20 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-02-23 21:38:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-26T10:36:57.000000Z","updated_at":"2026-03-06T10:30:36.000000Z","inspection_violations":[{"id":18785848,"change_date":"2026-02-23 21:38:00","inspection_id":"87115035","insp_violation_id":"271955807","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","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":"2026-02-26T10:50:44.000000Z","updated_at":"2026-03-06T10:40:49.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":19132296,"change_date":"2026-02-23 21:38:00","inspection_id":"87115035","insp_unit_id":"211764700","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"331","insp_unit_license":"FX9353","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2XPXD49X9GM337966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:12.000000Z","updated_at":"2026-03-06T10:03:14.000000Z"},{"id":19132297,"change_date":"2026-02-23 21:38:00","inspection_id":"87115035","insp_unit_id":"211764701","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TIMP","insp_unit_company":"457","insp_unit_license":"LW8833","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TDH43022MB167853","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:12.000000Z","updated_at":"2026-03-06T10:03:14.000000Z"}]},{"id":10812780,"change_date":"2026-01-20 21:40:00","inspection_id":"86839968","dot_number":"1718885","report_state":"KS","report_number":"HP93514629","insp_date":"2026-01-16 00:00:00","insp_start_time":"1204","insp_end_time":"1255","registration_date":null,"region":"CT","ci_status_code":"C","location":"#58","location_desc":"BELLEVILLE M.C.I.S. #58","county_code_state":"KS","county_code":"157","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARGILL","shipping_paper_number":"2019679115","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1386854","transaction_code":"A","transaction_date":"2026-01-16 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-16 00:00:00","source_office":"3KSS001","mcmis_add_date":"2026-01-20 21:40:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-23T10:36:26.000000Z","updated_at":"2026-01-31T10:30:50.000000Z","inspection_violations":[{"id":18073647,"change_date":"2026-01-20 21:40:00","inspection_id":"86839968","insp_violation_id":"271307024","seq_no":"2","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"211182962","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-23T10:42:39.000000Z","updated_at":"2026-01-31T10:38:00.000000Z","normalized_code":"3939ALFTSI"},{"id":18073646,"change_date":"2026-01-20 21:40:00","inspection_id":"86839968","insp_violation_id":"271307023","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"211182962","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-23T10:42:39.000000Z","updated_at":"2026-01-31T10:38:00.000000Z","normalized_code":"3939ALFTSI"},{"id":18073648,"change_date":"2026-01-20 21:40:00","inspection_id":"86839968","insp_violation_id":"271307025","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211182962","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-23T10:42:39.000000Z","updated_at":"2026-01-31T10:38:00.000000Z","normalized_code":"39360C"},{"id":18073649,"change_date":"2026-01-20 21:40:00","inspection_id":"86839968","insp_violation_id":"271307026","seq_no":"4","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"211182962","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-23T10:42:39.000000Z","updated_at":"2026-01-31T10:38:00.000000Z","normalized_code":"3939ALRLI"},{"id":18073650,"change_date":"2026-01-20 21:40:00","inspection_id":"86839968","insp_violation_id":"271307027","seq_no":"5","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"211182963","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-01-23T10:42:39.000000Z","updated_at":"2026-01-31T10:38:00.000000Z","normalized_code":"3939ALTSI"},{"id":18073651,"change_date":"2026-01-20 21:40:00","inspection_id":"86839968","insp_violation_id":"271307028","seq_no":"6","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"211182963","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-01-23T10:42:39.000000Z","updated_at":"2026-01-31T10:38:00.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":18158376,"change_date":"2026-01-20 21:40:00","inspection_id":"86839968","insp_unit_id":"211182962","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"334","insp_unit_license":"FY7822","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNSCR16C214735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:22.000000Z","updated_at":"2026-01-31T10:03:21.000000Z"},{"id":18158377,"change_date":"2026-01-20 21:40:00","inspection_id":"86839968","insp_unit_id":"211182963","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TIMP","insp_unit_company":"448","insp_unit_license":"KV5468","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TDH42228LB166860","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:22.000000Z","updated_at":"2026-01-31T10:03:21.000000Z"}]},{"id":10363676,"change_date":"2025-12-05 21:43:00","inspection_id":"86492206","dot_number":"1718885","report_state":"IA","report_number":"000P169N9J","insp_date":"2025-12-04 00:00:00","insp_start_time":"2000","insp_end_time":"2025","registration_date":null,"region":"CT","ci_status_code":"C","location":"01","location_desc":"01 - I80 WB MM 151 MITCHELLVIL","county_code_state":"IA","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ADM","shipping_paper_number":"480467","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":"2025-12-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1383021","transaction_code":"A","transaction_date":"2025-12-05 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-12-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-12-05 21:43:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-08T10:32:05.000000Z","updated_at":"2025-12-09T10:31:18.000000Z","inspection_violations":[{"id":17353127,"change_date":"2025-12-05 21:43:00","inspection_id":"86492206","insp_violation_id":"270494855","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"210444826","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:56.000000Z","updated_at":"2025-12-09T10:32:06.000000Z","normalized_code":"3922RG"},{"id":17353128,"change_date":"2025-12-05 21:43:00","inspection_id":"86492206","insp_violation_id":"270494856","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2TAY25120420170","created_at":"2025-12-08T10:32:56.000000Z","updated_at":"2025-12-09T10:32:06.000000Z","normalized_code":"3922SLLEWA1"},{"id":17353129,"change_date":"2025-12-05 21:43:00","inspection_id":"86492206","insp_violation_id":"270494857","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2TAY25120420172","created_at":"2025-12-08T10:32:56.000000Z","updated_at":"2025-12-09T10:32:06.000000Z","normalized_code":"3922SLLEWG1"},{"id":17353130,"change_date":"2025-12-05 21:43:00","inspection_id":"86492206","insp_violation_id":"270494858","seq_no":"4","part_no":"390","part_no_section":"21TB","insp_viol_unit":"1","insp_unit_id":"210444826","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:56.000000Z","updated_at":"2025-12-09T10:32:06.000000Z","normalized_code":"39021TB"},{"id":17353131,"change_date":"2025-12-05 21:43:00","inspection_id":"86492206","insp_violation_id":"270494859","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"210444827","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:56.000000Z","updated_at":"2025-12-09T10:32:06.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":17322659,"change_date":"2025-12-05 21:43:00","inspection_id":"86492206","insp_unit_id":"210444827","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TIMP","insp_unit_company":"1T","insp_unit_license":"MB8426","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TDH42224JB160440","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:09.000000Z","updated_at":"2025-12-09T10:01:32.000000Z"},{"id":17322658,"change_date":"2025-12-05 21:43:00","inspection_id":"86492206","insp_unit_id":"210444826","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"306","insp_unit_license":"FY2245","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCHAER7YC066818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:09.000000Z","updated_at":"2025-12-09T10:01:32.000000Z"}]},{"id":10292015,"change_date":"2025-11-26 21:37:00","inspection_id":"86417305","dot_number":"1718885","report_state":"SD","report_number":"HP72000049","insp_date":"2025-11-19 00:00:00","insp_start_time":"0818","insp_end_time":"0841","registration_date":null,"region":"CS","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NORMAN PUMPING","shipping_paper_number":"69635","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":"U","pen_cen_match":"I","final_status_date":"2025-11-26 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2588890","transaction_code":"A","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-11-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":"2025-11-26 21:37:00","snet_input_date":"2025-11-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-26 21:37:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-29T10:31:24.000000Z","updated_at":"2025-11-30T10:30:17.000000Z","inspection_violations":[{"id":17212835,"change_date":"2025-11-26 21:37:00","inspection_id":"86417305","insp_violation_id":"270303006","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-11-29T10:32:22.000000Z","updated_at":"2025-11-30T10:30:25.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":17184932,"change_date":"2025-11-26 21:37:00","inspection_id":"86417305","insp_unit_id":"210271224","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"333","insp_unit_license":"FY7821","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNSCR66C214732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-29T10:01:32.000000Z","updated_at":"2025-11-30T10:00:18.000000Z"},{"id":17184933,"change_date":"2025-11-26 21:37:00","inspection_id":"86417305","insp_unit_id":"210271225","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"449","insp_unit_license":"LH8631","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TDH42228DB139742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-29T10:01:32.000000Z","updated_at":"2025-11-30T10:00:18.000000Z"}]},{"id":9642194,"change_date":"2025-09-10 21:40:00","inspection_id":"85733816","dot_number":"1718885","report_state":"MO","report_number":"W174004342","insp_date":"2025-09-10 00:00:00","insp_start_time":"0654","insp_end_time":"0740","registration_date":null,"region":"CD","ci_status_code":"C","location":"H2S","location_desc":"EAGLEVILLE MO","county_code_state":"MO","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARGILL INCORPERATED","shipping_paper_number":"IF0323647001","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-10 21:40: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2247105","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":"2025-09-10 21:40:00","snet_input_date":"2025-09-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-10 21:40:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:34.000000Z","updated_at":"2025-09-13T10:47:34.000000Z","inspection_violations":[{"id":15782067,"change_date":"2025-09-10 21:40:00","inspection_id":"85733816","insp_violation_id":"268578734","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","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-09-13T10:50:36.000000Z","updated_at":"2025-09-14T11:55:45.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":15931390,"change_date":"2025-09-10 21:40:00","inspection_id":"85733816","insp_unit_id":"208848262","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"306","insp_unit_license":"FY2245","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCHAER7YC066818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:22.000000Z","updated_at":"2025-09-13T10:00:22.000000Z"},{"id":15931391,"change_date":"2025-09-10 21:40:00","inspection_id":"85733816","insp_unit_id":"208848263","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TIMPTE, IN","insp_unit_company":"2890","insp_unit_license":"LW8833","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TDH43022MB167853","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:22.000000Z","updated_at":"2025-09-13T10:00:22.000000Z"}]},{"id":9344493,"change_date":"2025-08-06 21:40:00","inspection_id":"85421153","dot_number":"1718885","report_state":"KS","report_number":"PD83740507","insp_date":"2025-08-05 00:00:00","insp_start_time":"2002","insp_end_time":"2030","registration_date":null,"region":"CT","ci_status_code":"C","location":"DG","location_desc":"DOUGLAS COUNTY - 045","county_code_state":"KS","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"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":"Y","pen_cen_match":null,"final_status_date":"2025-08-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1370367","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-05 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-08-06 21:40:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:22.000000Z","updated_at":"2025-08-12T10:42:22.000000Z","inspection_violations":[{"id":15171337,"change_date":"2025-08-06 21:40:00","inspection_id":"85421153","insp_violation_id":"267872367","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"208266877","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-09T10:45:19.000000Z","updated_at":"2025-08-10T10:44:00.000000Z","normalized_code":"39021TB2DOT"},{"id":15171338,"change_date":"2025-08-06 21:40:00","inspection_id":"85421153","insp_violation_id":"267872368","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"208266877","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-09T10:45:19.000000Z","updated_at":"2025-08-10T10:44:00.000000Z","normalized_code":"39021TB1MC"},{"id":15171339,"change_date":"2025-08-06 21:40:00","inspection_id":"85421153","insp_violation_id":"267872369","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"208266877","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-09T10:45:19.000000Z","updated_at":"2025-08-10T10:44:00.000000Z","normalized_code":"39395A1"},{"id":15171340,"change_date":"2025-08-06 21:40:00","inspection_id":"85421153","insp_violation_id":"267872370","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"208266877","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-09T10:45:19.000000Z","updated_at":"2025-08-10T10:44:00.000000Z","normalized_code":"39395F"},{"id":15171341,"change_date":"2025-08-06 21:40:00","inspection_id":"85421153","insp_violation_id":"267872371","seq_no":"5","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"208266877","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-09T10:45:19.000000Z","updated_at":"2025-08-10T10:44:00.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":15392527,"change_date":"2025-08-06 21:40:00","inspection_id":"85421153","insp_unit_id":"208266877","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"PUM413","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C7WRTCL1KG543477","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-09T09:46:21.000000Z","updated_at":"2025-08-10T09:45:58.000000Z"}]},{"id":9185233,"change_date":"2025-07-18 21:39:00","inspection_id":"85253598","dot_number":"1718885","report_state":"MT","report_number":"U493600749","insp_date":"2025-07-15 00:00:00","insp_start_time":"1215","insp_end_time":"1238","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"BUTTE MT","county_code_state":"MT","county_code":"093","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GLOBAL HARVEST","shipping_paper_number":null,"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":"U","pen_cen_match":"I","final_status_date":"2025-07-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2010163","transaction_code":"A","transaction_date":"2025-07-18 00:00:00","upload_date":"2025-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":"2025-07-18 21:39:00","snet_input_date":"2025-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-18 21:39:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:31.000000Z","updated_at":"2025-07-22T10:44:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15095034,"change_date":"2025-07-18 21:39:00","inspection_id":"85253598","insp_unit_id":"207945546","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"FY2245","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCHAER7YC066818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:33.000000Z","updated_at":"2025-07-22T09:45:30.000000Z"},{"id":15095035,"change_date":"2025-07-18 21:39:00","inspection_id":"85253598","insp_unit_id":"207945547","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TIMPTE","insp_unit_company":null,"insp_unit_license":"LH8753","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TDH40026GB153473","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:33.000000Z","updated_at":"2025-07-22T09:45:30.000000Z"}]},{"id":8932219,"change_date":"2025-06-18 21:41:00","inspection_id":"84987419","dot_number":"1718885","report_state":"KS","report_number":"HP04002824","insp_date":"2025-06-17 00:00:00","insp_start_time":"1310","insp_end_time":"1340","registration_date":null,"region":"CT","ci_status_code":"C","location":"CD","location_desc":"CLOUD COUNTY - 029","county_code_state":"KS","county_code":"029","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CENTRAL SALT","shipping_paper_number":"461163","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":"2025-06-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1364920","transaction_code":"A","transaction_date":"2025-06-17 00:00:00","upload_date":"2025-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-17 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-06-18 21:41:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-22T10:01:06.000000Z","updated_at":"2025-06-22T10:01:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14638833,"change_date":"2025-06-18 21:41:00","inspection_id":"84987419","insp_unit_id":"207451371","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"333","insp_unit_license":"FY7821","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNSCR66C214732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:21.000000Z","updated_at":"2025-06-22T09:46:21.000000Z"},{"id":14638834,"change_date":"2025-06-18 21:41:00","inspection_id":"84987419","insp_unit_id":"207451372","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TIMP","insp_unit_company":null,"insp_unit_license":"LH8631","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TDH42228DB139742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:21.000000Z","updated_at":"2025-06-22T09:46:21.000000Z"}]},{"id":8489965,"change_date":"2025-04-29 21:48:00","inspection_id":"84519541","dot_number":"1718885","report_state":"MO","report_number":"W174004165","insp_date":"2025-04-25 00:00:00","insp_start_time":"0901","insp_end_time":"1020","registration_date":null,"region":"CD","ci_status_code":"C","location":"H2S","location_desc":"EAGLEVILLE MO","county_code_state":"MO","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ADM","shipping_paper_number":"262693","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1644336","transaction_code":"A","transaction_date":"2025-04-27 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":"2025-04-29 21:48:00","snet_input_date":"2025-04-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-29 21:48:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T10:26:42.000000Z","updated_at":"2025-05-02T13:49:44.000000Z","inspection_violations":[{"id":13430611,"change_date":"2025-04-29 21:48:00","inspection_id":"84519541","insp_violation_id":"265877848","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA1","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-05-02T10:56:49.000000Z","updated_at":"2025-05-02T11:16:03.000000Z","normalized_code":"3922SLLEWA1"},{"id":13430612,"change_date":"2025-04-29 21:48:00","inspection_id":"84519541","insp_violation_id":"265877849","seq_no":"4","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T10:56:49.000000Z","updated_at":"2025-05-02T11:16:03.000000Z","normalized_code":"3958A"},{"id":13430613,"change_date":"2025-04-29 21:48:00","inspection_id":"84519541","insp_violation_id":"265877850","seq_no":"5","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"206531705","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T10:56:49.000000Z","updated_at":"2025-05-02T11:16:03.000000Z","normalized_code":"39311A1CSLRR"},{"id":13430614,"change_date":"2025-04-29 21:48:00","inspection_id":"84519541","insp_violation_id":"265877851","seq_no":"6","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"206531705","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T10:56:49.000000Z","updated_at":"2025-05-02T11:16:03.000000Z","normalized_code":"39395A1"},{"id":13430615,"change_date":"2025-04-29 21:48:00","inspection_id":"84519541","insp_violation_id":"265877852","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"206531705","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T10:56:49.000000Z","updated_at":"2025-05-02T11:16:03.000000Z","normalized_code":"39345B2BAIR"},{"id":13430616,"change_date":"2025-04-29 21:48:00","inspection_id":"84519541","insp_violation_id":"265877853","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"206531706","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T10:56:49.000000Z","updated_at":"2025-05-02T11:16:03.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":13798283,"change_date":"2025-04-29 21:48:00","inspection_id":"84519541","insp_unit_id":"206531705","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"329","insp_unit_license":"FX8986","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPWD49XXDD206820","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:13:17.000000Z","updated_at":"2025-05-03T10:04:14.000000Z"},{"id":13798284,"change_date":"2025-04-29 21:48:00","inspection_id":"84519541","insp_unit_id":"206531706","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILSON TRA","insp_unit_company":"44319","insp_unit_license":"JL8652","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4WW4432A6J7715076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:13:17.000000Z","updated_at":"2025-05-03T10:04:14.000000Z"}]},{"id":8286922,"change_date":"2025-04-03 21:41:00","inspection_id":"84305777","dot_number":"1718885","report_state":"IA","report_number":"000P13J9X5","insp_date":"2025-04-02 00:00:00","insp_start_time":"1302","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":"45","location_desc":"45 - HWY 218 NB MM 29 PILOT GR","county_code_state":"IA","county_code":"111","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"EMPTY","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":"2025-04-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1355349","transaction_code":"A","transaction_date":"2025-04-03 00:00:00","upload_date":"2025-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-04-02 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-04-03 21:41:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:24:59.000000Z","updated_at":"2025-04-07T10:19:45.000000Z","inspection_violations":[{"id":13027572,"change_date":"2025-04-03 21:41:00","inspection_id":"84305777","insp_violation_id":"265423118","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"206140303","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:52:09.000000Z","updated_at":"2025-04-07T10:39:32.000000Z","normalized_code":"39311TL"},{"id":13027573,"change_date":"2025-04-03 21:41:00","inspection_id":"84305777","insp_violation_id":"265423119","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"206140303","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7RAM25040213215","created_at":"2025-04-05T10:52:09.000000Z","updated_at":"2025-04-07T10:39:32.000000Z","normalized_code":"39395A"},{"id":13027574,"change_date":"2025-04-03 21:41:00","inspection_id":"84305777","insp_violation_id":"265423120","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"206140303","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:52:09.000000Z","updated_at":"2025-04-07T10:39:33.000000Z","normalized_code":"39311"},{"id":13027575,"change_date":"2025-04-03 21:41:00","inspection_id":"84305777","insp_violation_id":"265423121","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"206140304","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:52:09.000000Z","updated_at":"2025-04-07T10:39:33.000000Z","normalized_code":"3939"},{"id":13027576,"change_date":"2025-04-03 21:41:00","inspection_id":"84305777","insp_violation_id":"265423122","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"206140304","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:52:09.000000Z","updated_at":"2025-04-07T10:39:33.000000Z","normalized_code":"3939"},{"id":13027577,"change_date":"2025-04-03 21:41:00","inspection_id":"84305777","insp_violation_id":"265423123","seq_no":"6","part_no":"396","part_no_section":"9D2","insp_viol_unit":"1","insp_unit_id":"206140303","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-05T10:52:09.000000Z","updated_at":"2025-04-07T10:39:33.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":13428096,"change_date":"2025-04-03 21:41:00","inspection_id":"84305777","insp_unit_id":"206140303","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"318","insp_unit_license":"VF3168","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW09Y5EM036164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-06T10:12:03.000000Z","updated_at":"2025-04-07T10:00:58.000000Z"},{"id":13428597,"change_date":"2025-04-03 21:41:00","inspection_id":"84305777","insp_unit_id":"206140304","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"742","insp_unit_license":"JT0822","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"H36031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-06T10:12:21.000000Z","updated_at":"2025-04-07T10:00:58.000000Z"}]},{"id":8276689,"change_date":"2025-04-02 21:41:00","inspection_id":"84295076","dot_number":"1718885","report_state":"IA","report_number":"000P12DZTL","insp_date":"2025-03-29 00:00:00","insp_start_time":"1710","insp_end_time":"1800","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"EB HWY 30 \/ WILLIAMS BLVD","county_code_state":"IA","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","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":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"7","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1354881","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-29 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:51.000000Z","updated_at":"2025-04-06T10:23:51.000000Z","inspection_violations":[{"id":13007558,"change_date":"2025-04-02 21:41:00","inspection_id":"84295076","insp_violation_id":"265400747","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7THA25032917484","created_at":"2025-04-04T11:07:46.000000Z","updated_at":"2025-04-05T10:42:22.000000Z","normalized_code":"39216"},{"id":13007559,"change_date":"2025-04-02 21:41:00","inspection_id":"84295076","insp_violation_id":"265400748","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"206120987","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-04T11:07:46.000000Z","updated_at":"2025-04-05T10:42:22.000000Z","normalized_code":"39395A"},{"id":13007560,"change_date":"2025-04-02 21:41:00","inspection_id":"84295076","insp_violation_id":"265400749","seq_no":"3","part_no":"393","part_no_section":"45B2","insp_viol_unit":"1","insp_unit_id":"206120987","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-04T11:07:46.000000Z","updated_at":"2025-04-05T10:42:22.000000Z","normalized_code":"39345B2"},{"id":13007561,"change_date":"2025-04-02 21:41:00","inspection_id":"84295076","insp_violation_id":"265400750","seq_no":"4","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"1","insp_unit_id":"206120987","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-04T11:07:46.000000Z","updated_at":"2025-04-05T10:42:22.000000Z","normalized_code":"3939ALSLIWR"},{"id":13007562,"change_date":"2025-04-02 21:41:00","inspection_id":"84295076","insp_violation_id":"265400751","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"206120987","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-04T11:07:46.000000Z","updated_at":"2025-04-05T10:42:22.000000Z","normalized_code":"39311"},{"id":13007563,"change_date":"2025-04-02 21:41:00","inspection_id":"84295076","insp_violation_id":"265400752","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206120987","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-04T11:07:46.000000Z","updated_at":"2025-04-05T10:42:22.000000Z","normalized_code":"3939"},{"id":13007564,"change_date":"2025-04-02 21:41:00","inspection_id":"84295076","insp_violation_id":"265400753","seq_no":"7","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"206120988","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-04T11:07:46.000000Z","updated_at":"2025-04-05T10:42:22.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":13397571,"change_date":"2025-04-02 21:41:00","inspection_id":"84295076","insp_unit_id":"206120988","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"742","insp_unit_license":"JT0822","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"H36031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:12:24.000000Z","updated_at":"2025-04-06T09:59:59.000000Z"},{"id":13397570,"change_date":"2025-04-02 21:41:00","inspection_id":"84295076","insp_unit_id":"206120987","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"318","insp_unit_license":"VF3168","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW09Y5EM036164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:12:24.000000Z","updated_at":"2025-04-06T09:59:59.000000Z"}]},{"id":8155329,"change_date":"2025-03-19 21:41:00","inspection_id":"84167212","dot_number":"1718885","report_state":"IA","report_number":"000P11BC6N","insp_date":"2025-03-18 00:00:00","insp_start_time":"0725","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I80EB WILTON","county_code_state":"IA","county_code":"031","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORMAN PUMPING LLC","shipping_paper_number":null,"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":"2025-03-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1353285","transaction_code":"A","transaction_date":"2025-03-19 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-03-19 21:41:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-22T10:33:44.000000Z","updated_at":"2025-03-23T10:48:07.000000Z","inspection_violations":[{"id":12766253,"change_date":"2025-03-19 21:41:00","inspection_id":"84167212","insp_violation_id":"265125136","seq_no":"1","part_no":"392","part_no_section":"2LC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9SMI25031807302","created_at":"2025-03-22T10:49:11.000000Z","updated_at":"2025-03-22T11:05:06.000000Z","normalized_code":"3922LC"},{"id":12766254,"change_date":"2025-03-19 21:41:00","inspection_id":"84167212","insp_violation_id":"265125137","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"205879096","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T10:49:11.000000Z","updated_at":"2025-03-22T11:05:06.000000Z","normalized_code":"3922RG"},{"id":12766255,"change_date":"2025-03-19 21:41:00","inspection_id":"84167212","insp_violation_id":"265125138","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"205879095","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T10:49:11.000000Z","updated_at":"2025-03-22T11:05:06.000000Z","normalized_code":"39617C"},{"id":12766256,"change_date":"2025-03-19 21:41:00","inspection_id":"84167212","insp_violation_id":"265125139","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"205879096","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T10:49:11.000000Z","updated_at":"2025-03-22T11:05:06.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":13175248,"change_date":"2025-03-19 21:41:00","inspection_id":"84167212","insp_unit_id":"205879095","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"321","insp_unit_license":"FT4717","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDD40X4CJ331631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:05:55.000000Z","updated_at":"2025-03-23T10:01:29.000000Z"},{"id":13175249,"change_date":"2025-03-19 21:41:00","inspection_id":"84167212","insp_unit_id":"205879096","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TSC","insp_unit_company":"0016","insp_unit_license":"HG2581","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1T9TB4B77RT380016","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:05:55.000000Z","updated_at":"2025-03-23T10:01:29.000000Z"}]},{"id":8055943,"change_date":"2025-03-11 21:40:00","inspection_id":"84062473","dot_number":"1718885","report_state":"IA","report_number":"000P1269LR","insp_date":"2025-03-06 00:00:00","insp_start_time":"1045","insp_end_time":"1218","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARGILL","shipping_paper_number":"00009695670","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":"2025-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"9","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1351885","transaction_code":"C","transaction_date":"2025-03-07 00:00:00","upload_date":"2025-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-03-07 21:39:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:26.000000Z","updated_at":"2025-03-17T21:05:26.000000Z","inspection_violations":[{"id":12590958,"change_date":"2025-03-11 21:40:00","inspection_id":"84062473","insp_violation_id":"264946876","seq_no":"9","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"205734883","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:37.000000Z","updated_at":"2025-03-17T22:07:37.000000Z","normalized_code":"3939"},{"id":12590959,"change_date":"2025-03-11 21:40:00","inspection_id":"84062473","insp_violation_id":"264946877","seq_no":"1","part_no":"393","part_no_section":"203C","insp_viol_unit":"1","insp_unit_id":"205734882","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:37.000000Z","updated_at":"2025-03-17T22:07:37.000000Z","normalized_code":"393203C"},{"id":12590960,"change_date":"2025-03-11 21:40:00","inspection_id":"84062473","insp_violation_id":"264946878","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"205734882","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9RIP25030611585","created_at":"2025-03-17T22:07:37.000000Z","updated_at":"2025-03-17T22:07:37.000000Z","normalized_code":"39395A"},{"id":12590961,"change_date":"2025-03-11 21:40:00","inspection_id":"84062473","insp_violation_id":"264946879","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"205734882","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:07:37.000000Z","updated_at":"2025-03-17T22:07:37.000000Z","normalized_code":"39375A3TAOL"},{"id":12590962,"change_date":"2025-03-11 21:40:00","inspection_id":"84062473","insp_violation_id":"264946880","seq_no":"4","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"205734882","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:37.000000Z","updated_at":"2025-03-17T22:07:37.000000Z","normalized_code":"3963A1"},{"id":12590963,"change_date":"2025-03-11 21:40:00","inspection_id":"84062473","insp_violation_id":"264946881","seq_no":"5","part_no":"396","part_no_section":"3A1","insp_viol_unit":"2","insp_unit_id":"205734883","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:37.000000Z","updated_at":"2025-03-17T22:07:37.000000Z","normalized_code":"3963A1"},{"id":12590964,"change_date":"2025-03-11 21:40:00","inspection_id":"84062473","insp_violation_id":"264946882","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"205734883","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:37.000000Z","updated_at":"2025-03-17T22:07:37.000000Z","normalized_code":"39347E"},{"id":12590965,"change_date":"2025-03-11 21:40:00","inspection_id":"84062473","insp_violation_id":"264946883","seq_no":"7","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"205734883","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:37.000000Z","updated_at":"2025-03-17T22:07:37.000000Z","normalized_code":"39353B"},{"id":12590966,"change_date":"2025-03-11 21:40:00","inspection_id":"84062473","insp_violation_id":"264946884","seq_no":"8","part_no":"396","part_no_section":"3A1-LC","insp_viol_unit":"2","insp_unit_id":"205734883","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:37.000000Z","updated_at":"2025-03-17T22:07:37.000000Z","normalized_code":"3963A1LC"}],"inspection_per_units":[{"id":13006286,"change_date":"2025-03-11 21:40:00","inspection_id":"84062473","insp_unit_id":"205734882","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"334","insp_unit_license":"FY7822","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNSCR16C214735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:42.000000Z","updated_at":"2025-03-17T23:58:42.000000Z"},{"id":13006287,"change_date":"2025-03-11 21:40:00","inspection_id":"84062473","insp_unit_id":"205734883","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"402","insp_unit_license":"IP0324","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1TBFYA58A248215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:42.000000Z","updated_at":"2025-03-17T23:58:42.000000Z"}]},{"id":7553335,"change_date":"2025-01-06 21:39:00","inspection_id":"83534752","dot_number":"1718885","report_state":"NY","report_number":"SPA3020438","insp_date":"2024-12-30 00:00:00","insp_start_time":"1309","insp_end_time":"1355","registration_date":null,"region":"ES","ci_status_code":"C","location":"60308M","location_desc":"FRIENDSHIP NY","county_code_state":"NY","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"WENGER FEEDS","shipping_paper_number":"0056180","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":"U","pen_cen_match":"I","final_status_date":"2025-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1218954","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":"2025-01-06 21:39:00","snet_input_date":"2024-12-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-06 21:39:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:55.000000Z","updated_at":"2025-03-17T20:54:55.000000Z","inspection_violations":[{"id":11806377,"change_date":"2025-01-06 21:39:00","inspection_id":"83534752","insp_violation_id":"263766348","seq_no":"1","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:32.000000Z","updated_at":"2025-03-17T22:03:32.000000Z","normalized_code":"3958A"},{"id":11806378,"change_date":"2025-01-06 21:39:00","inspection_id":"83534752","insp_violation_id":"263766349","seq_no":"2","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:32.000000Z","updated_at":"2025-03-17T22:03:32.000000Z","normalized_code":"3958A"},{"id":11806379,"change_date":"2025-01-06 21:39:00","inspection_id":"83534752","insp_violation_id":"263766350","seq_no":"3","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:32.000000Z","updated_at":"2025-03-17T22:03:32.000000Z","normalized_code":"3958A"},{"id":11806380,"change_date":"2025-01-06 21:39:00","inspection_id":"83534752","insp_violation_id":"263766351","seq_no":"4","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:32.000000Z","updated_at":"2025-03-17T22:03:32.000000Z","normalized_code":"3958A"},{"id":11806381,"change_date":"2025-01-06 21:39:00","inspection_id":"83534752","insp_violation_id":"263766352","seq_no":"5","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:32.000000Z","updated_at":"2025-03-17T22:03:32.000000Z","normalized_code":"3958A"},{"id":11806382,"change_date":"2025-01-06 21:39:00","inspection_id":"83534752","insp_violation_id":"263766353","seq_no":"6","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:32.000000Z","updated_at":"2025-03-17T22:03:32.000000Z","normalized_code":"3958A"},{"id":11806383,"change_date":"2025-01-06 21:39:00","inspection_id":"83534752","insp_violation_id":"263766354","seq_no":"7","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:32.000000Z","updated_at":"2025-03-17T22:03:32.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":12187238,"change_date":"2025-01-06 21:39:00","inspection_id":"83534752","insp_unit_id":"204661244","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"332","insp_unit_license":"FY4101","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NPXGGGG30D267902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:32.000000Z","updated_at":"2025-03-17T23:49:32.000000Z"},{"id":12187239,"change_date":"2025-01-06 21:39:00","inspection_id":"83534752","insp_unit_id":"204661245","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TIMPTE","insp_unit_company":"LH8631","insp_unit_license":"LH8631","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TDH42228DB139742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:32.000000Z","updated_at":"2025-03-17T23:49:32.000000Z"}]},{"id":7508442,"change_date":"2024-12-27 21:38:00","inspection_id":"83487655","dot_number":"1718885","report_state":"IA","report_number":"000P15FB77","insp_date":"2024-12-24 00:00:00","insp_start_time":"1347","insp_end_time":"1424","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"37 - I29 SB MM 132 SALIX","county_code_state":"IA","county_code":"193","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NORMAN PUMPING","shipping_paper_number":"EMPTY","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-12-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1343338","transaction_code":"A","transaction_date":"2024-12-27 00:00:00","upload_date":"2024-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-12-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-27 21:38:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:41.000000Z","updated_at":"2025-03-17T20:52:41.000000Z","inspection_violations":[{"id":11733680,"change_date":"2024-12-27 21:38:00","inspection_id":"83487655","insp_violation_id":"263670519","seq_no":"1","part_no":"395","part_no_section":"8F01","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:09.000000Z","updated_at":"2025-03-17T22:03:09.000000Z","normalized_code":"3958F01"}],"inspection_per_units":[{"id":12112888,"change_date":"2024-12-27 21:38:00","inspection_id":"83487655","insp_unit_id":"204571466","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"334","insp_unit_license":"FY7822","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNSCR16C214735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:43.000000Z","updated_at":"2025-03-17T23:48:43.000000Z"},{"id":12112889,"change_date":"2024-12-27 21:38:00","inspection_id":"83487655","insp_unit_id":"204571467","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TIMP","insp_unit_company":"LH8631","insp_unit_license":"LH8631","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TDH42228DB139742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:43.000000Z","updated_at":"2025-03-17T23:48:43.000000Z"}]},{"id":7204270,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","dot_number":"1718885","report_state":"IA","report_number":"000P12XHXJ","insp_date":"2024-11-13 00:00:00","insp_start_time":"1237","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 151","county_code_state":"IA","county_code":"061","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORMAN PUMPING LLC","shipping_paper_number":"MANURE","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"11","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1337505","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-11-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-11-15 21:42:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:25.000000Z","updated_at":"2025-03-17T20:46:25.000000Z","inspection_violations":[{"id":11258326,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","insp_violation_id":"262919847","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203903036","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"3922RG"},{"id":11258327,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","insp_violation_id":"262919848","seq_no":"2","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"203903036","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"39311TL"},{"id":11258328,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","insp_violation_id":"262919849","seq_no":"3","part_no":"393","part_no_section":"45DLPC","insp_viol_unit":"1","insp_unit_id":"203903036","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"39345DLPC"},{"id":11258329,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","insp_violation_id":"262919850","seq_no":"4","part_no":"393","part_no_section":"11LR","insp_viol_unit":"2","insp_unit_id":"203903037","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"39311LR"},{"id":11258330,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","insp_violation_id":"262919851","seq_no":"5","part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"203903036","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"3939T"},{"id":11258331,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","insp_violation_id":"262919852","seq_no":"6","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"203903036","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"3939TS"},{"id":11258332,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","insp_violation_id":"262919853","seq_no":"7","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"203903036","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"3939ALSLI"},{"id":11258333,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","insp_violation_id":"262919854","seq_no":"8","part_no":"393","part_no_section":"45A-AJS","insp_viol_unit":"1","insp_unit_id":"203903036","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"39345AAJS"},{"id":11258334,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","insp_violation_id":"262919855","seq_no":"9","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"203903037","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"3922RG"},{"id":11258335,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","insp_violation_id":"262919856","seq_no":"10","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"203903036","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"39378"},{"id":11258336,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","insp_violation_id":"262919857","seq_no":"11","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"203903037","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":11620456,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","insp_unit_id":"203903036","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"304","insp_unit_license":"FJ1809","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDDR9XXWR763940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:26.000000Z","updated_at":"2025-03-17T23:43:26.000000Z"},{"id":11620457,"change_date":"2024-11-15 21:42:00","inspection_id":"83167320","insp_unit_id":"203903037","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TERMINAL","insp_unit_company":"NA","insp_unit_license":"HG2579","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1T9TD4B74TT380010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:26.000000Z","updated_at":"2025-03-17T23:43:26.000000Z"}]},{"id":7173541,"change_date":"2024-11-12 21:41:00","inspection_id":"83134863","dot_number":"1718885","report_state":"IA","report_number":"000P16D862","insp_date":"2024-11-10 00:00:00","insp_start_time":"1015","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NORMAN PUMPING","shipping_paper_number":"SELF","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-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"1336939","transaction_code":"A","transaction_date":"2024-11-12 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-11-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-11-12 21:41:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:36.000000Z","updated_at":"2025-03-17T20:45:36.000000Z","inspection_violations":[{"id":11207185,"change_date":"2024-11-12 21:41:00","inspection_id":"83134863","insp_violation_id":"262846815","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"203839916","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"39360C"},{"id":11207186,"change_date":"2024-11-12 21:41:00","inspection_id":"83134863","insp_violation_id":"262846816","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"203839916","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"39378"},{"id":11207187,"change_date":"2024-11-12 21:41:00","inspection_id":"83134863","insp_violation_id":"262846817","seq_no":"3","part_no":"395","part_no_section":"8F01","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"3958F01"},{"id":11207188,"change_date":"2024-11-12 21:41:00","inspection_id":"83134863","insp_violation_id":"262846818","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"203839916","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":11570530,"change_date":"2024-11-12 21:41:00","inspection_id":"83134863","insp_unit_id":"203839916","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"325","insp_unit_license":"FW7144","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPHD49X7DD194604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"},{"id":11570531,"change_date":"2024-11-12 21:41:00","inspection_id":"83134863","insp_unit_id":"203839917","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JAYCO","insp_unit_company":null,"insp_unit_license":"JZ3501","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UJBJ02M2116D0177","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"}]},{"id":7181593,"change_date":"2024-11-13 21:39:00","inspection_id":"83143353","dot_number":"1718885","report_state":"MN","report_number":"1630000050","insp_date":"2024-11-06 00:00:00","insp_start_time":"1150","insp_end_time":"1210","registration_date":null,"region":"CS","ci_status_code":"C","location":"FLSCL","location_desc":"FOREST LAKE MN","county_code_state":"MN","county_code":"003","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"106400","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1046866","transaction_code":"A","transaction_date":"2024-11-13 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":"2024-11-13 21:39:00","snet_input_date":"2024-11-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-13 21:39:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:58.000000Z","updated_at":"2025-03-17T20:45:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11583621,"change_date":"2024-11-13 21:39:00","inspection_id":"83143353","insp_unit_id":"203855464","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"FJ1809","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDDR9XXWR763940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:01.000000Z","updated_at":"2025-03-17T23:43:01.000000Z"},{"id":11583622,"change_date":"2024-11-13 21:39:00","inspection_id":"83143353","insp_unit_id":"203855465","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PUMPING","insp_unit_company":null,"insp_unit_license":"HG2579","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1T9TD4B74TT380010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:01.000000Z","updated_at":"2025-03-17T23:43:01.000000Z"}]},{"id":7167106,"change_date":"2024-11-12 21:40:00","inspection_id":"83127982","dot_number":"1718885","report_state":"MN","report_number":"1665000428","insp_date":"2024-11-05 00:00:00","insp_start_time":"1421","insp_end_time":"1431","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"RICE MN","county_code_state":"MN","county_code":"009","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","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":"U","pen_cen_match":"I","final_status_date":"2024-11-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1043628","transaction_code":"A","transaction_date":"2024-11-12 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":"2024-11-12 21:40:00","snet_input_date":"2024-11-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-12 21:40:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:34.000000Z","updated_at":"2025-03-17T20:45:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11560309,"change_date":"2024-11-12 21:40:00","inspection_id":"83127982","insp_unit_id":"203827238","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":"303","insp_unit_license":"FJ2037","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDDB9X95J088909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:49.000000Z","updated_at":"2025-03-17T23:42:49.000000Z"},{"id":11560310,"change_date":"2024-11-12 21:40:00","inspection_id":"83127982","insp_unit_id":"203827239","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"161","insp_unit_license":"KS6793","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HLA3A7B9R7H57160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:49.000000Z","updated_at":"2025-03-17T23:42:49.000000Z"}]},{"id":7163101,"change_date":"2024-11-11 21:33:00","inspection_id":"83123725","dot_number":"1718885","report_state":"MN","report_number":"1662000454","insp_date":"2024-11-04 00:00:00","insp_start_time":"1036","insp_end_time":"1101","registration_date":null,"region":"CS","ci_status_code":"C","location":"FLSCL","location_desc":"FOREST LAKE MN","county_code_state":"MN","county_code":"003","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"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":"U","pen_cen_match":"I","final_status_date":"2024-11-11 21:33: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1040028","transaction_code":"A","transaction_date":"2024-11-11 00:00:00","upload_date":"2024-11-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":"2024-11-11 21:33:00","snet_input_date":"2024-11-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-11 21:33:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:32.000000Z","updated_at":"2025-03-17T20:45:32.000000Z","inspection_violations":[{"id":11190591,"change_date":"2024-11-11 21:33:00","inspection_id":"83123725","insp_violation_id":"262824457","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"203819515","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:18.000000Z","updated_at":"2025-03-17T22:00:18.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":11553645,"change_date":"2024-11-11 21:33:00","inspection_id":"83123725","insp_unit_id":"203819515","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"8354","insp_unit_license":"FV5715","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDD40X8EJ418354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:43.000000Z","updated_at":"2025-03-17T23:42:43.000000Z"},{"id":11553646,"change_date":"2024-11-11 21:33:00","inspection_id":"83123725","insp_unit_id":"203819516","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRENNER TA","insp_unit_company":"736","insp_unit_license":"LH8577","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"10BFB72369F0C1753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:43.000000Z","updated_at":"2025-03-17T23:42:43.000000Z"}]},{"id":7048205,"change_date":"2024-10-25 21:41:00","inspection_id":"83002059","dot_number":"1718885","report_state":"IA","report_number":"000P14RPTT","insp_date":"2024-10-24 00:00:00","insp_start_time":"1824","insp_end_time":"1845","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"OASIS AVE WINFIELD","county_code_state":"IA","county_code":"087","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"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":"2024-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","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":"1334730","transaction_code":"A","transaction_date":"2024-10-25 00:00:00","upload_date":"2024-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-10-25 21:41:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:01.000000Z","updated_at":"2025-03-17T20:43:01.000000Z","inspection_violations":[{"id":11000768,"change_date":"2024-10-25 21:41:00","inspection_id":"83002059","insp_violation_id":"262562815","seq_no":"1","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"203591772","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:23.000000Z","updated_at":"2025-03-17T21:59:23.000000Z","normalized_code":"3939TS"},{"id":11000769,"change_date":"2024-10-25 21:41:00","inspection_id":"83002059","insp_violation_id":"262562816","seq_no":"2","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"203591772","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:23.000000Z","updated_at":"2025-03-17T21:59:23.000000Z","normalized_code":"39311TU"},{"id":11000770,"change_date":"2024-10-25 21:41:00","inspection_id":"83002059","insp_violation_id":"262562817","seq_no":"3","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"203591772","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:23.000000Z","updated_at":"2025-03-17T21:59:23.000000Z","normalized_code":"39311TL"}],"inspection_per_units":[{"id":11367214,"change_date":"2024-10-25 21:41:00","inspection_id":"83002059","insp_unit_id":"203591772","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"316","insp_unit_license":"FR0223","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW09Y1CM024090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:42.000000Z","updated_at":"2025-03-17T23:40:42.000000Z"},{"id":11367215,"change_date":"2024-10-25 21:41:00","inspection_id":"83002059","insp_unit_id":"203591773","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"2","insp_unit_license":"VF4839","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K44128S7731201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:42.000000Z","updated_at":"2025-03-17T23:40:42.000000Z"}]},{"id":6611406,"change_date":"2024-08-30 21:40:00","inspection_id":"82537384","dot_number":"1718885","report_state":"IA","report_number":"000P13PH72","insp_date":"2024-08-29 00:00:00","insp_start_time":"0825","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ADC AURORA ORGANIC DAIRY CORP","shipping_paper_number":"1151048 MILK","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-08-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1327422","transaction_code":"A","transaction_date":"2024-08-30 00:00:00","upload_date":"2024-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-08-29 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-30 21:40:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:04.000000Z","updated_at":"2025-03-17T20:34:04.000000Z","inspection_violations":[{"id":10280735,"change_date":"2024-08-30 21:40:00","inspection_id":"82537384","insp_violation_id":"261526166","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":"1TIN24082908320","created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"3922"},{"id":10280736,"change_date":"2024-08-30 21:40:00","inspection_id":"82537384","insp_violation_id":"261526167","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202685400","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39345B2"},{"id":10280737,"change_date":"2024-08-30 21:40:00","inspection_id":"82537384","insp_violation_id":"261526168","seq_no":"3","part_no":"395","part_no_section":"8(k)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"3958K2"}],"inspection_per_units":[{"id":10659191,"change_date":"2024-08-30 21:40:00","inspection_id":"82537384","insp_unit_id":"202685400","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"333","insp_unit_license":"FY7821","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNSCR66C214732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:22.000000Z","updated_at":"2025-03-17T23:33:22.000000Z"},{"id":10659192,"change_date":"2024-08-30 21:40:00","inspection_id":"82537384","insp_unit_id":"202685401","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANG","insp_unit_company":"R53177","insp_unit_license":"CZ2131","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"527SR5323HM010494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:22.000000Z","updated_at":"2025-03-17T23:33:22.000000Z"}]},{"id":6456703,"change_date":"2024-08-13 21:42:00","inspection_id":"82372473","dot_number":"1718885","report_state":"IA","report_number":"000P1271B8","insp_date":"2024-08-09 00:00:00","insp_start_time":"1645","insp_end_time":"1731","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169 NB & HWY 20","county_code_state":"IA","county_code":"187","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"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":"2024-08-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1324629","transaction_code":"A","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-08-09 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-13 21:42:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:44.000000Z","updated_at":"2025-03-17T20:30:44.000000Z","inspection_violations":[{"id":10026787,"change_date":"2024-08-13 21:42:00","inspection_id":"82372473","insp_violation_id":"261166426","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"3922"},{"id":10026788,"change_date":"2024-08-13 21:42:00","inspection_id":"82372473","insp_violation_id":"261166427","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202369767","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:32.000000Z","updated_at":"2025-03-17T21:54:32.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10407014,"change_date":"2024-08-13 21:42:00","inspection_id":"82372473","insp_unit_id":"202369767","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"316","insp_unit_license":"FR0223","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW09Y1CM024090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:51.000000Z","updated_at":"2025-03-17T23:30:51.000000Z"},{"id":10407015,"change_date":"2024-08-13 21:42:00","inspection_id":"82372473","insp_unit_id":"202369768","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"740","insp_unit_license":"IW9137","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1V9SV4223FB150326","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:51.000000Z","updated_at":"2025-03-17T23:30:51.000000Z"}]},{"id":5950926,"change_date":"2024-06-10 21:43:00","inspection_id":"81829147","dot_number":"1718885","report_state":"KS","report_number":"HP03795236","insp_date":"2024-06-06 00:00:00","insp_start_time":"1402","insp_end_time":"1433","registration_date":null,"region":"CT","ci_status_code":"C","location":"#26A","location_desc":"SOUTH HAVEN M.C.I.S. #26A","county_code_state":"KS","county_code":"191","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"KOCH","shipping_paper_number":"00620000106354","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-06-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1327095","transaction_code":"A","transaction_date":"2024-06-06 00:00:00","upload_date":"2024-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-06 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-06-10 21:43:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:41.000000Z","updated_at":"2025-03-17T20:20:41.000000Z","inspection_violations":[{"id":9231826,"change_date":"2024-06-10 21:43:00","inspection_id":"81829147","insp_violation_id":"259995117","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:38.000000Z","updated_at":"2025-03-17T21:50:38.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":9585287,"change_date":"2024-06-10 21:43:00","inspection_id":"81829147","insp_unit_id":"201312183","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"402","insp_unit_license":"IP0324","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1TBFYA58A248215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:24.000000Z","updated_at":"2025-03-17T23:22:24.000000Z"},{"id":9585288,"change_date":"2024-06-10 21:43:00","inspection_id":"81829147","insp_unit_id":"201312184","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"325","insp_unit_license":"FW7144","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPHD49X7DD194604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:24.000000Z","updated_at":"2025-03-17T23:22:24.000000Z"}]},{"id":5896771,"change_date":"2024-06-17 21:43:00","inspection_id":"81770347","dot_number":"1718885","report_state":"IA","report_number":"000P10C3N2","insp_date":"2024-05-31 00:00:00","insp_start_time":"1116","insp_end_time":"1302","registration_date":null,"region":"CT","ci_status_code":"C","location":"01","location_desc":"01 - I80 WB MM 151 MITCHELLVIL","county_code_state":"IA","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ZYLSTRA COMMODITIES","shipping_paper_number":"2024465","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-06-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1315471","transaction_code":"C","transaction_date":"2024-06-14 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-05-31 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-06-03 21:42:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:30.000000Z","updated_at":"2025-03-17T20:19:30.000000Z","inspection_violations":[{"id":9143568,"change_date":"2024-06-17 21:43:00","inspection_id":"81770347","insp_violation_id":"260121974","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"201428618","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"39375A3"},{"id":9143569,"change_date":"2024-06-17 21:43:00","inspection_id":"81770347","insp_violation_id":"260121975","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201428618","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"3965B"},{"id":9143570,"change_date":"2024-06-17 21:43:00","inspection_id":"81770347","insp_violation_id":"260121976","seq_no":"3","part_no":"393","part_no_section":"43(a)","insp_viol_unit":"1","insp_unit_id":"201428618","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"39343A"},{"id":9143571,"change_date":"2024-06-17 21:43:00","inspection_id":"81770347","insp_violation_id":"260121977","seq_no":"4","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"2","insp_unit_id":"201428619","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"39347A"},{"id":9143572,"change_date":"2024-06-17 21:43:00","inspection_id":"81770347","insp_violation_id":"260121978","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201428618","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"39347E"},{"id":9143573,"change_date":"2024-06-17 21:43:00","inspection_id":"81770347","insp_violation_id":"260121979","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201428618","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"39353B"},{"id":9143574,"change_date":"2024-06-17 21:43:00","inspection_id":"81770347","insp_violation_id":"260121980","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201428618","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9497702,"change_date":"2024-06-17 21:43:00","inspection_id":"81770347","insp_unit_id":"201428618","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"312","insp_unit_license":"FS5910","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP7DB9X87D662294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:32.000000Z","updated_at":"2025-03-17T23:21:32.000000Z"},{"id":9497703,"change_date":"2024-06-17 21:43:00","inspection_id":"81770347","insp_unit_id":"201428619","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TIMPTE","insp_unit_company":"1026","insp_unit_license":"JZ3663","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1TDH42228DB139742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:32.000000Z","updated_at":"2025-03-17T23:21:32.000000Z"}]},{"id":5773380,"change_date":"2024-05-17 21:39:00","inspection_id":"81636362","dot_number":"1718885","report_state":"AR","report_number":"5270000133","insp_date":"2024-05-16 00:00:00","insp_start_time":"1110","insp_end_time":"1206","registration_date":null,"region":"CD","ci_status_code":"C","location":"70\/GRE","location_desc":"GREENS CHAPEL WEIGH PAD","county_code_state":"AR","county_code":"133","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"GREEN PLAINS","shipping_paper_number":"260777","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":"U","pen_cen_match":"I","final_status_date":"2024-05-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"489104","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":"2024-05-17 21:39:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-17 21:39:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:07.000000Z","updated_at":"2025-03-17T20:17:07.000000Z","inspection_violations":[{"id":8938823,"change_date":"2024-05-17 21:39:00","inspection_id":"81636362","insp_violation_id":"259563059","seq_no":"1","part_no":"390","part_no_section":"21T(b)(2)","insp_viol_unit":"1","insp_unit_id":"200943008","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"~W004079","created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39021TB2"},{"id":8938824,"change_date":"2024-05-17 21:39:00","inspection_id":"81636362","insp_violation_id":"259563060","seq_no":"2","part_no":"395","part_no_section":"8(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"~W004079","created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"3958A"},{"id":8938825,"change_date":"2024-05-17 21:39:00","inspection_id":"81636362","insp_violation_id":"259563061","seq_no":"3","part_no":"395","part_no_section":"8(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":9298932,"change_date":"2024-05-17 21:39:00","inspection_id":"81636362","insp_unit_id":"200943008","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"306","insp_unit_license":"FY2245","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCHAER7YC066818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:33.000000Z","updated_at":"2025-03-17T23:19:33.000000Z"},{"id":9298933,"change_date":"2024-05-17 21:39:00","inspection_id":"81636362","insp_unit_id":"200943009","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TIMPTE, IN","insp_unit_company":"6860","insp_unit_license":"36L7XM","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1TDH42228LB166860","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:33.000000Z","updated_at":"2025-03-17T23:19:33.000000Z"}]},{"id":5378044,"change_date":"2024-03-27 21:41:00","inspection_id":"81205611","dot_number":"1718885","report_state":"MO","report_number":"W031005464","insp_date":"2024-03-25 00:00:00","insp_start_time":"1054","insp_end_time":"1139","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"EAGLEVILLE MO","county_code_state":"MO","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"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":"U","pen_cen_match":"I","final_status_date":"2024-03-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"351050","transaction_code":"A","transaction_date":"2024-03-27 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":"2024-03-27 21:41:00","snet_input_date":"2024-03-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-27 21:41:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:06.000000Z","updated_at":"2025-03-17T20:09:06.000000Z","inspection_violations":[{"id":8300786,"change_date":"2024-03-27 21:41:00","inspection_id":"81205611","insp_violation_id":"258606327","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"200107479","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:12.000000Z","updated_at":"2025-03-17T21:46:12.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":8661382,"change_date":"2024-03-27 21:41:00","inspection_id":"81205611","insp_unit_id":"200107479","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"324","insp_unit_license":"FW3255","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDD40X5EJ418358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:34.000000Z","updated_at":"2025-03-17T23:13:34.000000Z"},{"id":8661383,"change_date":"2024-03-27 21:41:00","inspection_id":"81205611","insp_unit_id":"200107480","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"724","insp_unit_license":"JL8586","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMS34226S1015763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:34.000000Z","updated_at":"2025-03-17T23:13:34.000000Z"}]},{"id":3811448,"change_date":"2023-11-14 21:41:00","inspection_id":"79482734","dot_number":"1718885","report_state":"OK","report_number":"P113154701","insp_date":"2023-08-23 00:00:00","insp_start_time":"0751","insp_end_time":"0812","registration_date":"2023-11-14 00:00:00","region":"CT","ci_status_code":"C","location":"66169","location_desc":"US 169 @ NS 4070","county_code_state":"OK","county_code":"131","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"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":"2023-08-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"720368","transaction_code":"C","transaction_date":"2023-08-23 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-08-23 21:40:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:04.000000Z","updated_at":"2025-03-17T19:38:04.000000Z","inspection_violations":[{"id":5880874,"change_date":"2023-11-14 21:41:00","inspection_id":"79482734","insp_violation_id":"256385428","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":6128084,"change_date":"2023-11-14 21:41:00","inspection_id":"79482734","insp_unit_id":"198053669","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"318","insp_unit_license":"VF3168","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW09Y5EM036164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:29.000000Z","updated_at":"2025-03-17T22:51:29.000000Z"},{"id":6128085,"change_date":"2023-11-14 21:41:00","inspection_id":"79482734","insp_unit_id":"198053670","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"742","insp_unit_license":"JT0822","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"H36031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:29.000000Z","updated_at":"2025-03-17T22:51:29.000000Z"}]},{"id":3576624,"change_date":"2023-07-24 21:42:00","inspection_id":"79220123","dot_number":"1718885","report_state":"OK","report_number":"P113154640","insp_date":"2023-07-24 00:00:00","insp_start_time":"0713","insp_end_time":"0754","registration_date":null,"region":"CT","ci_status_code":"C","location":"66169","location_desc":"US 169 @ NS 4060","county_code_state":"OK","county_code":"131","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"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":"2023-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"123000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"717354","transaction_code":"A","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-24 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:35.000000Z","updated_at":"2025-03-17T19:33:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5750563,"change_date":"2023-07-24 21:42:00","inspection_id":"79220123","insp_unit_id":"196153443","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"322","insp_unit_license":"FV5715","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDD40X8EJ418354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:24.000000Z","updated_at":"2025-03-17T22:48:24.000000Z"},{"id":5750564,"change_date":"2023-07-24 21:42:00","inspection_id":"79220123","insp_unit_id":"196153444","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":"736","insp_unit_license":"IE4890","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"10BFB72369F0C1753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:24.000000Z","updated_at":"2025-03-17T22:48:24.000000Z"}]},{"id":3499398,"change_date":"2023-08-01 21:41:00","inspection_id":"79133533","dot_number":"1718885","report_state":"OK","report_number":"K300181205","insp_date":"2023-07-12 00:00:00","insp_start_time":"0835","insp_end_time":"0908","registration_date":"2023-07-31 00:00:00","region":"CT","ci_status_code":"C","location":"66169","location_desc":"US 169 \/ S 4090 RD","county_code_state":"OK","county_code":"131","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"TULSA WASTEWATER","shipping_paper_number":"NONE","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":"2023-07-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117987","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":"716164","transaction_code":"C","transaction_date":"2023-07-13 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-12 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-07-13 21:42:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:08.000000Z","updated_at":"2025-03-17T19:32:08.000000Z","inspection_violations":[{"id":5395234,"change_date":"2023-08-01 21:41:00","inspection_id":"79133533","insp_violation_id":"254395310","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39216A"},{"id":5395235,"change_date":"2023-08-01 21:41:00","inspection_id":"79133533","insp_violation_id":"254395311","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196299272","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39395A"},{"id":5395236,"change_date":"2023-08-01 21:41:00","inspection_id":"79133533","insp_violation_id":"254395312","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"196299273","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39345B2"},{"id":5395237,"change_date":"2023-08-01 21:41:00","inspection_id":"79133533","insp_violation_id":"254395313","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"196299273","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":5626769,"change_date":"2023-08-01 21:41:00","inspection_id":"79133533","insp_unit_id":"196299272","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"303","insp_unit_license":"FJ2037","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDDB9X95J088909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:25.000000Z","updated_at":"2025-03-17T22:47:25.000000Z"},{"id":5626770,"change_date":"2023-08-01 21:41:00","inspection_id":"79133533","insp_unit_id":"196299273","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"732","insp_unit_license":"HG2581","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1T9TB4B77RT380016","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:25.000000Z","updated_at":"2025-03-17T22:47:25.000000Z"}]},{"id":3499401,"change_date":"2023-07-13 21:42:00","inspection_id":"79133536","dot_number":"1718885","report_state":"OK","report_number":"K300181208","insp_date":"2023-07-12 00:00:00","insp_start_time":"1512","insp_end_time":"1535","registration_date":null,"region":"CT","ci_status_code":"C","location":"66169","location_desc":"US 169 \/ S 4060 RD","county_code_state":"OK","county_code":"131","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","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":"2023-07-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"716156","transaction_code":"A","transaction_date":"2023-07-13 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-12 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-07-13 21:42:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:08.000000Z","updated_at":"2025-03-17T19:32:08.000000Z","inspection_violations":[{"id":5395241,"change_date":"2023-07-13 21:42:00","inspection_id":"79133536","insp_violation_id":"254036967","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"195978639","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39395F"},{"id":5395242,"change_date":"2023-07-13 21:42:00","inspection_id":"79133536","insp_violation_id":"254036968","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"195978639","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":5626773,"change_date":"2023-07-13 21:42:00","inspection_id":"79133536","insp_unit_id":"195978639","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"328","insp_unit_license":"VF4477","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9TH5DN564632","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:25.000000Z","updated_at":"2025-03-17T22:47:25.000000Z"},{"id":5626774,"change_date":"2023-07-13 21:42:00","inspection_id":"79133536","insp_unit_id":"195978640","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":"729","insp_unit_license":"JT0957","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"10BFU7212JF008970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:25.000000Z","updated_at":"2025-03-17T22:47:25.000000Z"}]},{"id":3479604,"change_date":"2023-07-11 21:42:00","inspection_id":"79111388","dot_number":"1718885","report_state":"OH","report_number":"3235009816","insp_date":"2023-07-10 00:00:00","insp_start_time":"1537","insp_end_time":"1658","registration_date":null,"region":"ET","ci_status_code":"C","location":"097","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"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":"I","final_status_date":"2023-07-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1666686","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-11 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-07-11 21:42:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:45.000000Z","updated_at":"2025-03-17T19:31:45.000000Z","inspection_violations":[{"id":5364674,"change_date":"2023-07-11 21:42:00","inspection_id":"79111388","insp_violation_id":"253988681","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195935512","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3939A"},{"id":5364675,"change_date":"2023-07-11 21:42:00","inspection_id":"79111388","insp_violation_id":"253988682","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"195935511","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"39021TB"},{"id":5364676,"change_date":"2023-07-11 21:42:00","inspection_id":"79111388","insp_violation_id":"253988683","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"195935511","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":5595250,"change_date":"2023-07-11 21:42:00","inspection_id":"79111388","insp_unit_id":"195935511","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"323","insp_unit_license":"FV5716","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDD40X3EJ418357","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:11.000000Z","updated_at":"2025-03-17T22:47:11.000000Z"},{"id":5595251,"change_date":"2023-07-11 21:42:00","inspection_id":"79111388","insp_unit_id":"195935512","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"728","insp_unit_license":"JZ3591","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1H4T04227GK015708","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:11.000000Z","updated_at":"2025-03-17T22:47:11.000000Z"}]},{"id":3412198,"change_date":"2023-06-30 21:40:00","inspection_id":"79035395","dot_number":"1718885","report_state":"OK","report_number":"K300181183","insp_date":"2023-06-30 00:00:00","insp_start_time":"1455","insp_end_time":"1514","registration_date":null,"region":"CT","ci_status_code":"C","location":"66169","location_desc":"US 169 \/ S 4090 RD","county_code_state":"OK","county_code":"131","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"NONE","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":"2023-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"715175","transaction_code":"A","transaction_date":"2023-06-30 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-30 21:40:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:35.000000Z","updated_at":"2025-03-17T19:30:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5485995,"change_date":"2023-06-30 21:40:00","inspection_id":"79035395","insp_unit_id":"195779409","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"318","insp_unit_license":"VF3168","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AW09Y5EM036164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:17.000000Z","updated_at":"2025-03-17T22:46:17.000000Z"},{"id":5485996,"change_date":"2023-06-30 21:40:00","inspection_id":"79035395","insp_unit_id":"195779410","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"742","insp_unit_license":"JT0822","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"H36031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:17.000000Z","updated_at":"2025-03-17T22:46:17.000000Z"}]},{"id":3364698,"change_date":"2023-06-26 21:41:00","inspection_id":"78982088","dot_number":"1718885","report_state":"IL","report_number":"4036610252","insp_date":"2023-06-26 00:00:00","insp_start_time":"1047","insp_end_time":"1103","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-74","county_code_state":"IL","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TYSON FRESH MEATS INC.","shipping_paper_number":"072H23037","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":"2023-06-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"94000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2254705","transaction_code":"A","transaction_date":"2023-06-26 00:00:00","upload_date":"2023-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-26 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-06-26 21:41:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:44.000000Z","updated_at":"2025-03-17T19:29:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5408731,"change_date":"2023-06-26 21:41:00","inspection_id":"78982088","insp_unit_id":"195673299","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PET","insp_unit_company":"312","insp_unit_license":"FS5910","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP7DB9X87D662294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:40.000000Z","updated_at":"2025-03-17T22:45:40.000000Z"},{"id":5408732,"change_date":"2023-06-26 21:41:00","inspection_id":"78982088","insp_unit_id":"195673300","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"R53177","insp_unit_license":"4993KP","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"527SR5323HM010494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:40.000000Z","updated_at":"2025-03-17T22:45:40.000000Z"}]},{"id":3333923,"change_date":"2023-09-01 21:39:00","inspection_id":"78947542","dot_number":"1718885","report_state":"KS","report_number":"HP00270079","insp_date":"2023-06-20 00:00:00","insp_start_time":"1105","insp_end_time":"1210","registration_date":"2023-09-01 00:00:00","region":"CT","ci_status_code":"C","location":"OT","location_desc":"OTTAWA COUNTY - 143","county_code_state":"KS","county_code":"143","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"DILLON'S","shipping_paper_number":"406279","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":"2023-09-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1292986","transaction_code":"C","transaction_date":"2023-09-01 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":"2023-09-01 21:39:00","snet_input_date":"2023-06-20 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-06-21 21:42:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:56.000000Z","updated_at":"2025-03-17T19:28:56.000000Z","inspection_violations":[{"id":5139941,"change_date":"2023-09-01 21:39:00","inspection_id":"78947542","insp_violation_id":"255045111","seq_no":"1","part_no":"395","part_no_section":"8(k)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:51.000000Z","updated_at":"2025-03-17T21:30:51.000000Z","normalized_code":"3958K2"}],"inspection_per_units":[{"id":5360006,"change_date":"2023-09-01 21:39:00","inspection_id":"78947542","insp_unit_id":"196864951","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"306","insp_unit_license":"FT1811","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCHAER7YC066818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:18.000000Z","updated_at":"2025-03-17T22:45:18.000000Z"},{"id":5360007,"change_date":"2023-09-01 21:39:00","inspection_id":"78947542","insp_unit_id":"196864952","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5324","insp_unit_license":"FR8876","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UYVS2538GU617360","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:18.000000Z","updated_at":"2025-03-17T22:45:18.000000Z"}]},{"id":1144834,"change_date":"2022-08-26 21:40:00","inspection_id":"76446673","dot_number":"1718885","report_state":"KY","report_number":"0S14300972","insp_date":"2022-08-25 00:00:00","insp_start_time":"1900","insp_end_time":"1945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CORBIN","county_code_state":"KY","county_code":"235","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"KAISER PICKLES","shipping_paper_number":"18120970","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-08-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2118027","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-26 00:00:00","source_office":"2KYS001","mcmis_add_date":"2022-08-26 21:40:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:53.000000Z","updated_at":"2025-03-17T18:47:53.000000Z","inspection_violations":[{"id":1812688,"change_date":"2022-08-26 21:40:00","inspection_id":"76446673","insp_violation_id":"248025091","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"EB96720","created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1840150,"change_date":"2022-08-26 21:40:00","inspection_id":"76446673","insp_unit_id":"190563479","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"312","insp_unit_license":"FS5910","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP7DB9X87D662294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:41.000000Z","updated_at":"2025-03-17T22:19:41.000000Z"},{"id":1840151,"change_date":"2022-08-26 21:40:00","inspection_id":"76446673","insp_unit_id":"190563480","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5324","insp_unit_license":"FR8876","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UYVS2538GU617360","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:41.000000Z","updated_at":"2025-03-17T22:19:41.000000Z"}]},{"id":739166,"change_date":"2022-07-01 21:38:00","inspection_id":"75972625","dot_number":"1718885","report_state":"IA","report_number":"000TT6MV2J","insp_date":"2022-07-01 00:00:00","insp_start_time":"0721","insp_end_time":"0755","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":"POET","shipping_paper_number":"2530353","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-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"116987","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1231808","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-01 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:35.000000Z","updated_at":"2025-03-17T18:40:35.000000Z","inspection_violations":[{"id":1163789,"change_date":"2022-07-01 21:38:00","inspection_id":"75972625","insp_violation_id":"246857122","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":"T23722070107480","created_at":"2025-03-17T21:12:27.000000Z","updated_at":"2025-03-17T21:12:27.000000Z","normalized_code":"3922"},{"id":1163790,"change_date":"2022-07-01 21:38:00","inspection_id":"75972625","insp_violation_id":"246857123","seq_no":"2","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":"T23722070107500","created_at":"2025-03-17T21:12:27.000000Z","updated_at":"2025-03-17T21:12:27.000000Z","normalized_code":"3922"},{"id":1163791,"change_date":"2022-07-01 21:38:00","inspection_id":"75972625","insp_violation_id":"246857124","seq_no":"3","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:12:27.000000Z","updated_at":"2025-03-17T21:12:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1187766,"change_date":"2022-07-01 21:38:00","inspection_id":"75972625","insp_unit_id":"189575376","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"303","insp_unit_license":"FJ2037","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDDB9X95J088909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:28.000000Z","updated_at":"2025-03-17T22:15:28.000000Z"},{"id":1187767,"change_date":"2022-07-01 21:38:00","inspection_id":"75972625","insp_unit_id":"189575377","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WSTI","insp_unit_company":"315","insp_unit_license":"D2608","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5DN154426FB000761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:28.000000Z","updated_at":"2025-03-17T22:15:28.000000Z"}]},{"id":575405,"change_date":"2022-06-10 21:40:00","inspection_id":"75778448","dot_number":"1718885","report_state":"SD","report_number":"HP10703714","insp_date":"2022-06-07 00:00:00","insp_start_time":"1627","insp_end_time":"1658","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WEBSTER","county_code_state":"SD","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"DEMKOTA RANCH BEEF","shipping_paper_number":"82344","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":"I","final_status_date":"2022-06-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"619180","transaction_code":"C","transaction_date":"2022-06-10 00:00:00","upload_date":"2022-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-09 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-06-09 21:43:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:48.000000Z","updated_at":"2025-03-17T18:37:48.000000Z","inspection_violations":[{"id":900781,"change_date":"2022-06-10 21:40:00","inspection_id":"75778448","insp_violation_id":"246376432","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"B879115-HP","created_at":"2025-03-17T21:11:16.000000Z","updated_at":"2025-03-17T21:11:16.000000Z","normalized_code":"39216A"},{"id":900782,"change_date":"2022-06-10 21:40:00","inspection_id":"75778448","insp_violation_id":"246376433","seq_no":"2","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:11:16.000000Z","updated_at":"2025-03-17T21:11:16.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":925502,"change_date":"2022-06-10 21:40:00","inspection_id":"75778448","insp_unit_id":"189179355","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"312","insp_unit_license":"FS5910","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP7DB9X87D662294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:54.000000Z","updated_at":"2025-03-17T22:13:54.000000Z"},{"id":925503,"change_date":"2022-06-10 21:40:00","inspection_id":"75778448","insp_unit_id":"189179356","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R53210","insp_unit_license":"0002STW","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA062XJW115073","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:54.000000Z","updated_at":"2025-03-17T22:13:54.000000Z"}]},{"id":514214,"change_date":"2022-05-31 21:41:00","inspection_id":"75706252","dot_number":"1718885","report_state":"IL","report_number":"3976370250","insp_date":"2022-05-05 00:00:00","insp_start_time":"1725","insp_end_time":"1808","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-80","county_code_state":"IL","county_code":"031","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"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-05-31 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2173904","transaction_code":"A","transaction_date":"2022-05-05 00:00:00","upload_date":"2022-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-05 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-05-31 21:41:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:43.000000Z","updated_at":"2025-03-17T18:36:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":827488,"change_date":"2022-05-31 21:41:00","inspection_id":"75706252","insp_unit_id":"188988796","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"FS5910","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP7DB9C87D662294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:18.000000Z","updated_at":"2025-03-17T22:13:18.000000Z"},{"id":827489,"change_date":"2022-05-31 21:41:00","inspection_id":"75706252","insp_unit_id":"188988797","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"0002STW","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA062XJW115073","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:18.000000Z","updated_at":"2025-03-17T22:13:18.000000Z"}]},{"id":70898,"change_date":"2022-03-30 21:40:00","inspection_id":"75174869","dot_number":"1718885","report_state":"IA","report_number":"000TT6DVDK","insp_date":"2022-03-29 00:00:00","insp_start_time":"1347","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"RIVERSIDE RD \/ AMES","county_code_state":"IA","county_code":"169","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CITY OF AMES - BRAD WILSON","shipping_paper_number":"NONE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"129987","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":"1217709","transaction_code":"A","transaction_date":"2022-03-30 00:00:00","upload_date":"2022-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01718885","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-03-29 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-03-30 21:40:00","insp_carrier_name":"NORMAN PUMPING LLC","insp_carrier_street":"1770 180TH ST","insp_carrier_city":"WASHINGTON","insp_carrier_state":"IA","insp_carrier_zip_code":"52353","insp_colonia":null,"docket_number":"633257","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:48.000000Z","updated_at":"2025-03-17T18:28:48.000000Z","inspection_violations":[{"id":103888,"change_date":"2022-03-30 21:40:00","inspection_id":"75174869","insp_violation_id":"244860316","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"187895264","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:35.000000Z","updated_at":"2025-03-17T21:07:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":115059,"change_date":"2022-03-30 21:40:00","inspection_id":"75174869","insp_unit_id":"187895263","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"303","insp_unit_license":"FJ2037","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKDDB9X95J088909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:56.000000Z","updated_at":"2025-03-17T22:08:56.000000Z"},{"id":115060,"change_date":"2022-03-30 21:40:00","inspection_id":"75174869","insp_unit_id":"187895264","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HMDE","insp_unit_company":"1","insp_unit_license":"GG6674","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1YPFS44378P002431","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:56.000000Z","updated_at":"2025-03-17T22:08:56.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1718885\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1718885\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1718885\/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\/1718885\/inspections","per_page":100,"prev_page_url":null,"to":43,"total":43}