{"current_page":1,"data":[{"id":12445890,"change_date":"2026-07-28 21:41:00","inspection_id":"88405627","dot_number":"676883","report_state":"MT","report_number":"U262201784","insp_date":"2026-07-14 00:00:00","insp_start_time":"0844","insp_end_time":"0911","registration_date":"2026-07-28 00:00:00","region":"MD","ci_status_code":"C","location":"BILLWB","location_desc":"BILLINGS MT","county_code_state":"MT","county_code":"111","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","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":"2026-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","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":"3748763","transaction_code":"C","transaction_date":"2026-07-14 00:00:00","upload_date":"2026-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2026-07-14 21:41:00","snet_input_date":"2026-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-14 21:41:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-17T09:41:13.000000Z","updated_at":"2026-08-08T09:30:19.000000Z","inspection_violations":[{"id":21668129,"change_date":"2026-07-28 21:41:00","inspection_id":"88405627","insp_violation_id":"275775700","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"214851817","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-17T10:03:57.000000Z","updated_at":"2026-08-08T09:42:40.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":21618811,"change_date":"2026-07-28 21:41:00","inspection_id":"88405627","insp_unit_id":"214851817","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"7264","insp_unit_license":"PZB2327","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKZP4TX0SJ175434","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-17T09:19:17.000000Z","updated_at":"2026-08-08T09:01:11.000000Z"},{"id":21618812,"change_date":"2026-07-28 21:41:00","inspection_id":"88405627","insp_unit_id":"214851818","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"7361","insp_unit_license":"6432STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1N9DD5329KD175181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-17T09:19:17.000000Z","updated_at":"2026-08-08T09:01:11.000000Z"}]},{"id":12387472,"change_date":"2026-07-08 21:41:00","inspection_id":"88350766","dot_number":"676883","report_state":"IL","report_number":"4249490615","insp_date":"2026-07-06 00:00:00","insp_start_time":"1122","insp_end_time":"1204","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-55","county_code_state":"IL","county_code":"107","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED PIPING INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"2485108","transaction_code":"A","transaction_date":"2026-07-06 00:00:00","upload_date":"2026-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2026-07-08 21:41:00","snet_input_date":"2026-07-06 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-07-08 21:41:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"102683","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-11T09:39:47.000000Z","updated_at":"2026-07-19T09:31:26.000000Z","inspection_violations":[{"id":21555867,"change_date":"2026-07-08 21:41:00","inspection_id":"88350766","insp_violation_id":"275364535","seq_no":"1","part_no":"177","part_no_section":"823A","insp_viol_unit":"1","insp_unit_id":"214503723","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-11T09:57:16.000000Z","updated_at":"2026-07-19T09:43:46.000000Z","normalized_code":"177823A"},{"id":21555868,"change_date":"2026-07-08 21:41:00","inspection_id":"88350766","insp_violation_id":"275364536","seq_no":"2","part_no":"392","part_no_section":"2-SLLS2","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-07-11T09:57:16.000000Z","updated_at":"2026-07-19T09:43:46.000000Z","normalized_code":"3922SLLS2"},{"id":21555869,"change_date":"2026-07-08 21:41:00","inspection_id":"88350766","insp_violation_id":"275364537","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"214503723","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-11T09:57:16.000000Z","updated_at":"2026-07-19T09:43:46.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":21509253,"change_date":"2026-07-08 21:41:00","inspection_id":"88350766","insp_unit_id":"214503723","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"5679PZA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0W4HT4PEC45994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-11T09:16:01.000000Z","updated_at":"2026-07-19T09:03:06.000000Z"}]},{"id":10855761,"change_date":"2026-01-25 21:33:00","inspection_id":"86885056","dot_number":"676883","report_state":"WI","report_number":"2734003136","insp_date":"2026-01-22 00:00:00","insp_start_time":"1036","insp_end_time":"1058","registration_date":null,"region":"CS","ci_status_code":"C","location":"S72","location_desc":"SOUTH RANGE WI","county_code_state":"WI","county_code":"031","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"2026-01-25 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"37200","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":"2811019","transaction_code":"A","transaction_date":"2026-01-24 00:00:00","upload_date":"2026-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2026-01-25 21:33:00","snet_input_date":"2026-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-25 21:33:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-28T10:36:20.000000Z","updated_at":"2026-02-05T10:30:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18239799,"change_date":"2026-01-25 21:33:00","inspection_id":"86885056","insp_unit_id":"211279019","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7266","insp_unit_license":"YCH5056","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0W4HT7SED92237","insp_unit_decal":"Y","insp_unit_decal_number":"36127327","created_at":"2026-01-28T10:08:20.000000Z","updated_at":"2026-02-05T10:02:06.000000Z"},{"id":18239800,"change_date":"2026-01-25 21:33:00","inspection_id":"86885056","insp_unit_id":"211279020","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEHNKE ENT","insp_unit_company":"7600","insp_unit_license":"FLK1744","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"4L5SC2520NF062390","insp_unit_decal":"Y","insp_unit_decal_number":"36127328","created_at":"2026-01-28T10:08:20.000000Z","updated_at":"2026-02-05T10:02:06.000000Z"}]},{"id":9872650,"change_date":"2025-10-07 21:40:00","inspection_id":"85975670","dot_number":"676883","report_state":"IL","report_number":"0099001615","insp_date":"2025-09-30 00:00:00","insp_start_time":"0936","insp_end_time":"1015","registration_date":null,"region":"CD","ci_status_code":"C","location":"IDOT26","location_desc":"FRANKFORT IL","county_code_state":"IL","county_code":"199","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"UNITED PIPING INC","shipping_paper_number":"25710","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-10-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"47000","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":"2373902","transaction_code":"A","transaction_date":"2025-10-06 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2025-10-07 21:40:00","snet_input_date":"2025-09-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-07 21:40:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-10T10:02:13.000000Z","updated_at":"2025-10-11T10:00:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16377989,"change_date":"2025-10-07 21:40:00","inspection_id":"85975670","insp_unit_id":"209332676","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7258","insp_unit_license":"2505PZA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0W4HT7REC81553","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:40.000000Z","updated_at":"2025-10-11T09:45:25.000000Z"},{"id":16377990,"change_date":"2025-10-07 21:40:00","inspection_id":"85975670","insp_unit_id":"209332677","insp_unit_type_id":"7","insp_unit_number":"2","insp_unit_make":"UNITED TRA","insp_unit_company":"76*2","insp_unit_license":"FLK1747","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"7RXTE2026RA221378","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:40.000000Z","updated_at":"2025-10-11T09:45:25.000000Z"}]},{"id":9543823,"change_date":"2025-08-29 21:40:00","inspection_id":"85631024","dot_number":"676883","report_state":"ND","report_number":"TR88007449","insp_date":"2025-08-28 00:00:00","insp_start_time":"1330","insp_end_time":"1419","registration_date":null,"region":"CD","ci_status_code":"C","location":"FARGO","location_desc":"FARGO ND","county_code_state":"ND","county_code":"017","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"UNITED PIPING INC","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-08-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"166000","viol_total":"2","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":"2197536","transaction_code":"A","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2025-08-29 21:40:00","snet_input_date":"2025-08-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-29 21:40:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:29.000000Z","updated_at":"2025-09-06T10:42:29.000000Z","inspection_violations":[{"id":18469299,"change_date":null,"inspection_id":"85631024","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":15752611,"change_date":"2025-08-29 21:40:00","inspection_id":"85631024","insp_unit_id":"208654973","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"7264","insp_unit_license":"PZB2327","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKZP4TX0SJ175434","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:49.000000Z","updated_at":"2025-09-09T09:46:49.000000Z"},{"id":15752612,"change_date":"2025-08-29 21:40:00","inspection_id":"85631024","insp_unit_id":"208654974","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":"7079A","insp_unit_license":"568193","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"5MAPA48278A015344","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:49.000000Z","updated_at":"2025-09-09T09:46:49.000000Z"}]},{"id":9397372,"change_date":"2025-08-13 21:38:00","inspection_id":"85476618","dot_number":"676883","report_state":"MN","report_number":"1670000618","insp_date":"2025-08-06 00:00:00","insp_start_time":"1250","insp_end_time":"1320","registration_date":null,"region":"CD","ci_status_code":"C","location":"SGNAW","location_desc":"SAGINAW MN","county_code_state":"MN","county_code":"137","insp_level_id":"1","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":"2025-08-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","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":"2121375","transaction_code":"A","transaction_date":"2025-08-12 00:00:00","upload_date":"2025-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2025-08-13 21:38:00","snet_input_date":"2025-08-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-13 21:38:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-16T10:01:15.000000Z","updated_at":"2025-08-17T10:00:14.000000Z","inspection_violations":[{"id":15280760,"change_date":"2025-08-13 21:38:00","inspection_id":"85476618","insp_violation_id":"267995350","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"208368614","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-16T10:44:52.000000Z","updated_at":"2025-08-17T10:43:42.000000Z","normalized_code":"3965BL"},{"id":15280761,"change_date":"2025-08-13 21:38:00","inspection_id":"85476618","insp_violation_id":"267995351","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"208368614","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-16T10:44:52.000000Z","updated_at":"2025-08-17T10:43:42.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":15487071,"change_date":"2025-08-13 21:38:00","inspection_id":"85476618","insp_unit_id":"208368614","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"507222","insp_unit_license":"2601PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NKHHJ7X4FM424957","insp_unit_decal":"Y","insp_unit_decal_number":"35506764","created_at":"2025-08-16T09:46:32.000000Z","updated_at":"2025-08-17T09:45:18.000000Z"}]},{"id":9238100,"change_date":"2025-07-24 21:41:00","inspection_id":"85309205","dot_number":"676883","report_state":"MI","report_number":"JURKV03119","insp_date":"2025-07-23 00:00:00","insp_start_time":"1310","insp_end_time":"1338","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"013","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"125146031202","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":"2025-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"190000","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":"1231949","transaction_code":"A","transaction_date":"2025-07-23 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2025-07-24 21:41:00","snet_input_date":"2025-07-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-24 21:41:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:55.000000Z","updated_at":"2025-07-30T10:00:52.000000Z","inspection_violations":[{"id":14956261,"change_date":"2025-07-24 21:41:00","inspection_id":"85309205","insp_violation_id":"267629081","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"208060568","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:16.000000Z","updated_at":"2025-07-28T10:48:52.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":15201454,"change_date":"2025-07-24 21:41:00","inspection_id":"85309205","insp_unit_id":"208060568","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"7263","insp_unit_license":"PXB0358","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKZP4TXXFJ424960","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:32.000000Z","updated_at":"2025-07-28T09:46:05.000000Z"},{"id":15201455,"change_date":"2025-07-24 21:41:00","inspection_id":"85309205","insp_unit_id":"208060569","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"3562STR","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"13NE52306D3556764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:32.000000Z","updated_at":"2025-07-28T09:46:05.000000Z"}]},{"id":9136856,"change_date":"2025-07-14 21:40:00","inspection_id":"85202932","dot_number":"676883","report_state":"MN","report_number":"1617000689","insp_date":"2025-07-07 00:00:00","insp_start_time":"0949","insp_end_time":"1019","registration_date":null,"region":"CD","ci_status_code":"C","location":"SGNAW","location_desc":"SAGINAW MN","county_code_state":"MN","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","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-07-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"129999","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":"1986445","transaction_code":"A","transaction_date":"2025-07-13 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2025-07-14 21:40:00","snet_input_date":"2025-07-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-14 21:40:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:41.000000Z","updated_at":"2025-07-18T10:45:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15003805,"change_date":"2025-07-14 21:40:00","inspection_id":"85202932","insp_unit_id":"207846612","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"PAT9354","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKDDP9X0EJ417252","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:27.000000Z","updated_at":"2025-07-18T09:45:26.000000Z"},{"id":15003806,"change_date":"2025-07-14 21:40:00","inspection_id":"85202932","insp_unit_id":"207846613","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"9663STM","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1UYFS24826A989312","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:27.000000Z","updated_at":"2025-07-18T09:45:26.000000Z"}]},{"id":8549436,"change_date":"2025-05-05 21:40:00","inspection_id":"84582499","dot_number":"676883","report_state":"IA","report_number":"000P120DR5","insp_date":"2025-05-01 00:00:00","insp_start_time":"0943","insp_end_time":"1010","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":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"UNITED PIPING INC","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":"2025-05-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"30500","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":"1358671","transaction_code":"A","transaction_date":"2025-05-05 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":"M","census_search_date":"2025-05-05 21:40:00","snet_input_date":"2025-05-01 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-05-05 21:40:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-08T10:03:43.000000Z","updated_at":"2025-05-09T10:23:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13903838,"change_date":"2025-05-05 21:40:00","inspection_id":"84582499","insp_unit_id":"206646488","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7259","insp_unit_license":"0744PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0W4HT7REC82220","insp_unit_decal":"Y","insp_unit_decal_number":"35250735","created_at":"2025-05-08T09:56:48.000000Z","updated_at":"2025-05-09T10:03:36.000000Z"},{"id":13903839,"change_date":"2025-05-05 21:40:00","inspection_id":"84582499","insp_unit_id":"206646489","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AME","insp_unit_company":"6914","insp_unit_license":"FLK3329","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5N6200J29F1046914","insp_unit_decal":"Y","insp_unit_decal_number":"35250736","created_at":"2025-05-08T09:56:48.000000Z","updated_at":"2025-05-09T10:03:36.000000Z"}]},{"id":8517752,"change_date":"2025-05-01 21:40:00","inspection_id":"84548917","dot_number":"676883","report_state":"MN","report_number":"1617000623","insp_date":"2025-04-24 00:00:00","insp_start_time":"1141","insp_end_time":"1215","registration_date":null,"region":"CD","ci_status_code":"C","location":"CRLTNN","location_desc":"CLOQUET MN","county_code_state":"MN","county_code":"017","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","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-05-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"176000","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":"1667705","transaction_code":"A","transaction_date":"2025-05-01 00:00:00","upload_date":"2025-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2025-05-01 21:40:00","snet_input_date":"2025-04-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-01 21:40:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-04T10:34:24.000000Z","updated_at":"2025-05-05T10:10:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13847229,"change_date":"2025-05-01 21:40:00","inspection_id":"84548917","insp_unit_id":"206585170","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"PZB2327","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKZP4TX0SJ175434","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-04T10:16:36.000000Z","updated_at":"2025-05-05T09:49:53.000000Z"},{"id":13847230,"change_date":"2025-05-01 21:40:00","inspection_id":"84548917","insp_unit_id":"206585171","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"NEVI","insp_unit_company":null,"insp_unit_license":"6432STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1N9DD5329KD175181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-04T10:16:36.000000Z","updated_at":"2025-05-05T09:49:53.000000Z"}]},{"id":8425578,"change_date":"2025-04-21 21:39:00","inspection_id":"84451864","dot_number":"676883","report_state":"MN","report_number":"0585000572","insp_date":"2025-04-14 00:00:00","insp_start_time":"0852","insp_end_time":"0910","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WALKER MN","county_code_state":"MN","county_code":"021","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-21 21:39: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":"1621332","transaction_code":"A","transaction_date":"2025-04-21 00:00:00","upload_date":"2025-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2025-04-21 21:39:00","snet_input_date":"2025-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-21 21:39:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-24T10:02:24.000000Z","updated_at":"2025-04-26T10:22:05.000000Z","inspection_violations":[{"id":13297517,"change_date":"2025-04-21 21:39:00","inspection_id":"84451864","insp_violation_id":"265729602","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","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-04-24T10:19:31.000000Z","updated_at":"2025-04-25T10:31:51.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":13680596,"change_date":"2025-04-21 21:39:00","inspection_id":"84451864","insp_unit_id":"206406748","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"PZB0358","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKZP4TXXFJ424960","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:48:25.000000Z","updated_at":"2025-04-25T09:50:46.000000Z"},{"id":13680597,"change_date":"2025-04-21 21:39:00","inspection_id":"84451864","insp_unit_id":"206406749","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNP68000","insp_unit_company":null,"insp_unit_license":"0607STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1N9DD5327HF175452","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:48:25.000000Z","updated_at":"2025-04-25T09:50:47.000000Z"}]},{"id":7470337,"change_date":"2024-12-20 21:39:00","inspection_id":"83447604","dot_number":"676883","report_state":"MT","report_number":"U464000527","insp_date":"2024-12-19 00:00:00","insp_start_time":"1400","insp_end_time":"1426","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"FORSYTH MT","county_code_state":"MT","county_code":"087","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED PIPING INC","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-12-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","viol_total":"2","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":"1180110","transaction_code":"A","transaction_date":"2024-12-20 00:00:00","upload_date":"2024-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2024-12-20 21:39:00","snet_input_date":"2024-12-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-20 21:39:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:57.000000Z","updated_at":"2025-03-17T20:51:57.000000Z","inspection_violations":[{"id":11677181,"change_date":"2024-12-20 21:39:00","inspection_id":"83447604","insp_violation_id":"263599523","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"204499884","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:50.000000Z","updated_at":"2025-03-17T22:02:50.000000Z","normalized_code":"3939ALFTSI"},{"id":11677182,"change_date":"2024-12-20 21:39:00","inspection_id":"83447604","insp_violation_id":"263599524","seq_no":"2","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"1","insp_unit_id":"204499884","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:50.000000Z","updated_at":"2025-03-17T22:02:50.000000Z","normalized_code":"39522H4ELDBRODS"}],"inspection_per_units":[{"id":12051897,"change_date":"2024-12-20 21:39:00","inspection_id":"83447604","insp_unit_id":"204499884","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"7211","insp_unit_license":"PAL0609","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKDP4EX5CJ298218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:06.000000Z","updated_at":"2025-03-17T23:48:06.000000Z"},{"id":12051898,"change_date":"2024-12-20 21:39:00","inspection_id":"83447604","insp_unit_id":"204499885","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"304870","insp_unit_license":"STA9356","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1UYVS2530CU200325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:06.000000Z","updated_at":"2025-03-17T23:48:06.000000Z"}]},{"id":7203023,"change_date":"2024-11-15 21:42:00","inspection_id":"83166003","dot_number":"676883","report_state":"KY","report_number":"S205000656","insp_date":"2024-11-14 00:00:00","insp_start_time":"1437","insp_end_time":"1459","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PAINTSVILLE","county_code_state":"KY","county_code":"115","insp_level_id":"1","service_center":"SH","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":"2024-11-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"2255283","transaction_code":"A","transaction_date":"2024-11-15 00:00:00","upload_date":"2024-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":"M","census_search_date":"2024-11-15 21:42:00","snet_input_date":"2024-11-15 00:00:00","source_office":"2KYS001","mcmis_add_date":"2024-11-15 21:42:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","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":[],"inspection_per_units":[{"id":11618417,"change_date":"2024-11-15 21:42:00","inspection_id":"83166003","insp_unit_id":"203900727","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1595PZA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0W4HT6PEC45995","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:23.000000Z","updated_at":"2025-03-17T23:43:23.000000Z"},{"id":11618418,"change_date":"2024-11-15 21:42:00","inspection_id":"83166003","insp_unit_id":"203900728","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"CSM3028J","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"4ZEGP3629P1291442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:23.000000Z","updated_at":"2025-03-17T23:43:23.000000Z"}]},{"id":7122290,"change_date":"2024-11-05 21:38:00","inspection_id":"83080509","dot_number":"676883","report_state":"WA","report_number":"X851000729","insp_date":"2024-11-03 00:00:00","insp_start_time":"0948","insp_end_time":"1020","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC64","location_desc":"LIBERTY LAKE WA","county_code_state":"WA","county_code":"063","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"140000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1020674","transaction_code":"A","transaction_date":"2024-11-05 00:00:00","upload_date":"2024-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2024-11-05 21:38:00","snet_input_date":"2024-11-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-05 21:38:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:38.000000Z","updated_at":"2025-03-17T20:44:38.000000Z","inspection_violations":[{"id":11123157,"change_date":"2024-11-05 21:38:00","inspection_id":"83080509","insp_violation_id":"262729987","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"203738226","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:00.000000Z","updated_at":"2025-03-17T22:00:00.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":11487328,"change_date":"2024-11-05 21:38:00","inspection_id":"83080509","insp_unit_id":"203738226","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"7211","insp_unit_license":"PAL0609","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1XKDP4EX5CJ298218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:01.000000Z","updated_at":"2025-03-17T23:42:01.000000Z"},{"id":11487329,"change_date":"2024-11-05 21:38:00","inspection_id":"83080509","insp_unit_id":"203738227","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DOONAN TRA","insp_unit_company":"7730","insp_unit_license":"7150STT","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1D9BG502571609654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:01.000000Z","updated_at":"2025-03-17T23:42:01.000000Z"}]},{"id":7122102,"change_date":"2024-11-05 21:38:00","inspection_id":"83080310","dot_number":"676883","report_state":"MN","report_number":"1629000054","insp_date":"2024-10-29 00:00:00","insp_start_time":"1150","insp_end_time":"1230","registration_date":null,"region":"CD","ci_status_code":"C","location":"ERSKN","location_desc":"ERSKINE MN","county_code_state":"MN","county_code":"119","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"206000","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":"1020499","transaction_code":"A","transaction_date":"2024-11-05 00:00:00","upload_date":"2024-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2024-11-05 21:38:00","snet_input_date":"2024-10-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-05 21:38:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:38.000000Z","updated_at":"2025-03-17T20:44:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11487028,"change_date":"2024-11-05 21:38:00","inspection_id":"83080310","insp_unit_id":"203737908","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"PZB2327","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKZP4TX0SJ175434","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:01.000000Z","updated_at":"2025-03-17T23:42:01.000000Z"},{"id":11487029,"change_date":"2024-11-05 21:38:00","inspection_id":"83080310","insp_unit_id":"203737909","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":"7757","insp_unit_license":"5282STY","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"13N352308C3554312","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:01.000000Z","updated_at":"2025-03-17T23:42:01.000000Z"}]},{"id":7083328,"change_date":"2024-10-30 21:41:00","inspection_id":"83039239","dot_number":"676883","report_state":"MI","report_number":"WHEEA03666","insp_date":"2024-10-29 00:00:00","insp_start_time":"1010","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB","county_code_state":"MI","county_code":"021","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","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-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"30500","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":"1199888","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2024-10-30 21:41:00","snet_input_date":"2024-10-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-30 21:41:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:50.000000Z","updated_at":"2025-03-17T20:43:50.000000Z","inspection_violations":[{"id":11059045,"change_date":"2024-10-30 21:41:00","inspection_id":"83039239","insp_violation_id":"262641938","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","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:59:38.000000Z","updated_at":"2025-03-17T21:59:38.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":11423887,"change_date":"2024-10-30 21:41:00","inspection_id":"83039239","insp_unit_id":"203661029","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7244","insp_unit_license":"5026PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0W4HT6KEE91731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:17.000000Z","updated_at":"2025-03-17T23:41:17.000000Z"},{"id":11423888,"change_date":"2024-10-30 21:41:00","inspection_id":"83039239","insp_unit_id":"203661030","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNIT","insp_unit_company":null,"insp_unit_license":"CSK8593","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"7RXTE2026RA221378","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:17.000000Z","updated_at":"2025-03-17T23:41:17.000000Z"}]},{"id":6986225,"change_date":"2024-11-01 21:39:00","inspection_id":"82936210","dot_number":"676883","report_state":"ID","report_number":"3706005257","insp_date":"2024-10-17 00:00:00","insp_start_time":"1212","insp_end_time":"1248","registration_date":"2024-10-30 00:00:00","region":"PD","ci_status_code":"C","location":"HUETT","location_desc":"POST FALLS ID","county_code_state":"ID","county_code":"055","insp_level_id":"2","service_center":"WE","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-10-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"154000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"959170","transaction_code":"C","transaction_date":"2024-10-18 00:00:00","upload_date":"2024-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2024-10-18 21:41:00","snet_input_date":"2024-10-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-18 21:41:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:47.000000Z","updated_at":"2025-03-17T20:41:47.000000Z","inspection_violations":[{"id":10898935,"change_date":"2024-11-01 21:39:00","inspection_id":"82936210","insp_violation_id":"262681125","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"203696358","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:58:49.000000Z","updated_at":"2025-03-17T21:58:49.000000Z","normalized_code":"393100BC"},{"id":10898936,"change_date":"2024-11-01 21:39:00","inspection_id":"82936210","insp_violation_id":"262681126","seq_no":"2","part_no":"395","part_no_section":"3A3I-HOSPDIT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:49.000000Z","updated_at":"2025-03-17T21:58:49.000000Z","normalized_code":"3953A3IHOSPDIT"},{"id":10898937,"change_date":"2024-11-01 21:39:00","inspection_id":"82936210","insp_violation_id":"262681127","seq_no":"3","part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:49.000000Z","updated_at":"2025-03-17T21:58:49.000000Z","normalized_code":"39522GELDMFV"}],"inspection_per_units":[{"id":11268252,"change_date":"2024-11-01 21:39:00","inspection_id":"82936210","insp_unit_id":"203696357","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"PZB2327","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKZP4TX0SJ175434","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:37.000000Z","updated_at":"2025-03-17T23:39:37.000000Z"},{"id":11268253,"change_date":"2024-11-01 21:39:00","inspection_id":"82936210","insp_unit_id":"203696358","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"NEVILLE WE","insp_unit_company":null,"insp_unit_license":"0607STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1N9DD5327HF175452","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:37.000000Z","updated_at":"2025-03-17T23:39:37.000000Z"}]},{"id":6706968,"change_date":"2024-09-12 21:41:00","inspection_id":"82638968","dot_number":"676883","report_state":"WI","report_number":"2712001908","insp_date":"2024-09-09 00:00:00","insp_start_time":"0904","insp_end_time":"0942","registration_date":null,"region":"CD","ci_status_code":"C","location":"S16","location_desc":"STOUGHTON WI","county_code_state":"WI","county_code":"025","insp_level_id":"2","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-09-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"190000","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":"838243","transaction_code":"A","transaction_date":"2024-09-12 00:00:00","upload_date":"2024-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2024-09-12 21:41:00","snet_input_date":"2024-09-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-12 21:41:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:05.000000Z","updated_at":"2025-03-17T20:36:05.000000Z","inspection_violations":[{"id":10439853,"change_date":"2024-09-12 21:41:00","inspection_id":"82638968","insp_violation_id":"261754622","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":null,"created_at":"2025-03-17T21:56:31.000000Z","updated_at":"2025-03-17T21:56:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10814718,"change_date":"2024-09-12 21:41:00","inspection_id":"82638968","insp_unit_id":"202883497","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"7201","insp_unit_license":"PAN3409","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XPTP4EX0FD258430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:56.000000Z","updated_at":"2025-03-17T23:34:56.000000Z"},{"id":10814719,"change_date":"2024-09-12 21:41:00","inspection_id":"82638968","insp_unit_id":"202883498","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":"7776","insp_unit_license":"3562STR","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"13NE52306D3556764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:56.000000Z","updated_at":"2025-03-17T23:34:56.000000Z"}]},{"id":6538485,"change_date":"2024-08-22 21:42:00","inspection_id":"82459543","dot_number":"676883","report_state":"IA","report_number":"000P132ZG4","insp_date":"2024-08-21 00:00:00","insp_start_time":"1255","insp_end_time":"1310","registration_date":null,"region":"CT","ci_status_code":"C","location":"16","location_desc":"16 - I380 SB MM 53 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"TOOLS","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-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"42500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1326203","transaction_code":"A","transaction_date":"2024-08-22 00:00:00","upload_date":"2024-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":"M","census_search_date":"2024-08-22 21:42:00","snet_input_date":"2024-08-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-22 21:42:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:24.000000Z","updated_at":"2025-03-17T20:32:24.000000Z","inspection_violations":[{"id":10157157,"change_date":"2024-08-22 21:42:00","inspection_id":"82459543","insp_violation_id":"261348959","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"202534505","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":10540458,"change_date":"2024-08-22 21:42:00","inspection_id":"82459543","insp_unit_id":"202534504","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7255","insp_unit_license":"0497PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0W4HT4PEC45994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:11.000000Z","updated_at":"2025-03-17T23:32:11.000000Z"},{"id":10540459,"change_date":"2024-08-22 21:42:00","inspection_id":"82459543","insp_unit_id":"202534505","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HMDE","insp_unit_company":null,"insp_unit_license":"9445CTU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"46UFU3023L1223382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:11.000000Z","updated_at":"2025-03-17T23:32:11.000000Z"}]},{"id":6328781,"change_date":"2024-07-29 21:41:00","inspection_id":"82235660","dot_number":"676883","report_state":"MN","report_number":"1673000237","insp_date":"2024-07-23 00:00:00","insp_start_time":"0927","insp_end_time":"0957","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ERSKINE MN","county_code_state":"MN","county_code":"119","insp_level_id":"3","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-07-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"110000","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":"693349","transaction_code":"A","transaction_date":"2024-07-29 00:00:00","upload_date":"2024-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2024-07-29 21:41:00","snet_input_date":"2024-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-29 21:41:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:15.000000Z","updated_at":"2025-03-17T20:28:15.000000Z","inspection_violations":[{"id":9826591,"change_date":"2024-07-29 21:41:00","inspection_id":"82235660","insp_violation_id":"260881428","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":null,"created_at":"2025-03-17T21:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10198020,"change_date":"2024-07-29 21:41:00","inspection_id":"82235660","insp_unit_id":"202110023","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"7218","insp_unit_license":"PAV0141","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1NPXGGGG50D227448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:37.000000Z","updated_at":"2025-03-17T23:28:37.000000Z"},{"id":10198021,"change_date":"2024-07-29 21:41:00","inspection_id":"82235660","insp_unit_id":"202110024","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"NEVILLE","insp_unit_company":"7726","insp_unit_license":"0607STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1N9DD5327HF175452","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:37.000000Z","updated_at":"2025-03-17T23:28:37.000000Z"}]},{"id":5985720,"change_date":"2024-06-13 21:42:00","inspection_id":"81867012","dot_number":"676883","report_state":"MI","report_number":"AKERT00251","insp_date":"2024-06-07 00:00:00","insp_start_time":"1319","insp_end_time":"1348","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M46 & AMBLE RD","county_code_state":"MI","county_code":"117","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":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"34980","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":"1182393","transaction_code":"A","transaction_date":"2024-06-07 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:27.000000Z","updated_at":"2025-03-17T20:21:27.000000Z","inspection_violations":[{"id":9285729,"change_date":"2024-06-13 21:42:00","inspection_id":"81867012","insp_violation_id":"260072296","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201383191","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"3922"},{"id":9285730,"change_date":"2024-06-13 21:42:00","inspection_id":"81867012","insp_violation_id":"260072297","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201383192","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"3922"},{"id":9285731,"change_date":"2024-06-13 21:42:00","inspection_id":"81867012","insp_violation_id":"260072298","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201383192","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"3922"},{"id":9285732,"change_date":"2024-06-13 21:42:00","inspection_id":"81867012","insp_violation_id":"260072299","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201383192","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"3939A"},{"id":9285733,"change_date":"2024-06-13 21:42:00","inspection_id":"81867012","insp_violation_id":"260072300","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"201383192","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9641399,"change_date":"2024-06-13 21:42:00","inspection_id":"81867012","insp_unit_id":"201383191","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7244","insp_unit_license":"5026PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0W4HT6KEE91731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"},{"id":9641400,"change_date":"2024-06-13 21:42:00","inspection_id":"81867012","insp_unit_id":"201383192","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOW M","insp_unit_company":null,"insp_unit_license":"CSK8545","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"4KNUT2024FL162508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"}]},{"id":5889006,"change_date":"2024-06-05 21:41:00","inspection_id":"81761594","dot_number":"676883","report_state":"MT","report_number":"U757300191","insp_date":"2024-05-29 00:00:00","insp_start_time":"0940","insp_end_time":"1011","registration_date":"2024-06-05 00:00:00","region":"MD","ci_status_code":"C","location":"BILLBN","location_desc":"BILLINGS MT","county_code_state":"MT","county_code":"111","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"UNITED PIPE INC","shipping_paper_number":"19922","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-06-01 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"52300","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":"530776","transaction_code":"C","transaction_date":"2024-06-01 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2024-06-01 21:31:00","snet_input_date":"2024-05-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-01 21:31:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:28.000000Z","updated_at":"2025-03-17T20:19:28.000000Z","inspection_violations":[{"id":9130492,"change_date":"2024-06-05 21:41:00","inspection_id":"81761594","insp_violation_id":"259911305","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"201239981","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":9484947,"change_date":"2024-06-05 21:41:00","inspection_id":"81761594","insp_unit_id":"201239981","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"7218","insp_unit_license":"PAV0141","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1NPXGGGG50D227448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:23.000000Z","updated_at":"2025-03-17T23:21:23.000000Z"},{"id":9484948,"change_date":"2024-06-05 21:41:00","inspection_id":"81761594","insp_unit_id":"201239982","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"7361","insp_unit_license":"6432STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1N9DD5329KD175181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:23.000000Z","updated_at":"2025-03-17T23:21:23.000000Z"}]},{"id":5671320,"change_date":"2024-05-06 21:42:00","inspection_id":"81525722","dot_number":"676883","report_state":"MT","report_number":"U623000433","insp_date":"2024-04-30 00:00:00","insp_start_time":"0844","insp_end_time":"0906","registration_date":null,"region":"MD","ci_status_code":"C","location":"BILLBN","location_desc":"BILLINGS INSPECTION BARN WB","county_code_state":"MT","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NA","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-06 21:42:00","post_acc_ind":"N","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":"455309","transaction_code":"A","transaction_date":"2024-05-06 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2024-05-06 21:42:00","snet_input_date":"2024-04-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-06 21:42:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:06.000000Z","updated_at":"2025-03-17T20:15:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9134589,"change_date":"2024-05-06 21:42:00","inspection_id":"81525722","insp_unit_id":"200731470","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"2496STC","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1S12E9482PD362889","insp_unit_decal":"Y","insp_unit_decal_number":"3404376","created_at":"2025-03-17T23:17:59.000000Z","updated_at":"2025-03-17T23:17:59.000000Z"},{"id":9134590,"change_date":"2024-05-06 21:42:00","inspection_id":"81525722","insp_unit_id":"200731471","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"7211","insp_unit_license":"PAL0609","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKDP4EX5CJ298218","insp_unit_decal":"Y","insp_unit_decal_number":"34040375","created_at":"2025-03-17T23:17:59.000000Z","updated_at":"2025-03-17T23:17:59.000000Z"}]},{"id":4632594,"change_date":"2023-12-14 21:43:00","inspection_id":"80391689","dot_number":"676883","report_state":"MN","report_number":"0AGD000266","insp_date":"2023-12-13 00:00:00","insp_start_time":"1654","insp_end_time":"1713","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CARLTON WEIGH STATION","county_code_state":"MN","county_code":"017","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-12-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"30500","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":"1426033","transaction_code":"A","transaction_date":"2023-12-13 00:00:00","upload_date":"2023-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2023-12-14 21:43:00","snet_input_date":"2023-12-14 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-12-14 21:43:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:34.000000Z","updated_at":"2025-03-17T19:54:34.000000Z","inspection_violations":[{"id":7159978,"change_date":"2023-12-14 21:43:00","inspection_id":"80391689","insp_violation_id":"256888628","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:33.000000Z","updated_at":"2025-03-17T21:40:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7451071,"change_date":"2023-12-14 21:43:00","inspection_id":"80391689","insp_unit_id":"198511508","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1594PZA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0W4HT2PEC45993","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"},{"id":7451072,"change_date":"2023-12-14 21:43:00","inspection_id":"80391689","insp_unit_id":"198511509","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AME","insp_unit_company":null,"insp_unit_license":"5605CMT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5N6200J25C1036568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"}]},{"id":4632629,"change_date":"2023-12-14 21:43:00","inspection_id":"80391727","dot_number":"676883","report_state":"MN","report_number":"0AGG000126","insp_date":"2023-12-13 00:00:00","insp_start_time":"1723","insp_end_time":"1755","registration_date":null,"region":"CT","ci_status_code":"C","location":"ERSKN","location_desc":"ERSKINE WEIGH SCALE","county_code_state":"MN","county_code":"119","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","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":"N","pen_cen_match":"I","final_status_date":"2023-12-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","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":"1426009","transaction_code":"A","transaction_date":"2023-12-13 00:00:00","upload_date":"2023-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2023-12-14 21:43:00","snet_input_date":"2023-12-14 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-12-14 21:43:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:34.000000Z","updated_at":"2025-03-17T19:54:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7451129,"change_date":"2023-12-14 21:43:00","inspection_id":"80391727","insp_unit_id":"198511573","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"7211","insp_unit_license":"PAL0609","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKDP4EX5CJ298218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"},{"id":7451130,"change_date":"2023-12-14 21:43:00","inspection_id":"80391727","insp_unit_id":"198511574","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"4399STM","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5DMFABTBX1M000464","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"}]},{"id":4139891,"change_date":"2023-10-06 21:39:00","inspection_id":"79848190","dot_number":"676883","report_state":"IN","report_number":"6562008810","insp_date":"2023-10-02 00:00:00","insp_start_time":"1604","insp_end_time":"1653","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"VALPARAISO IN","county_code_state":"IN","county_code":"127","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"UNITED PIPE","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":"U","pen_cen_match":"I","final_status_date":"2023-10-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"178000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"64371","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2023-10-06 21:39:00","snet_input_date":"2023-10-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-06 21:39:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:30.000000Z","updated_at":"2025-03-17T19:44:30.000000Z","inspection_violations":[{"id":6408151,"change_date":"2023-10-06 21:39:00","inspection_id":"79848190","insp_violation_id":"255692240","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3922SLLED"},{"id":6408152,"change_date":"2023-10-06 21:39:00","inspection_id":"79848190","insp_violation_id":"255692241","seq_no":"2","part_no":"393","part_no_section":"110B3-C","insp_viol_unit":"2","insp_unit_id":"197428401","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"393110B3C"},{"id":6408153,"change_date":"2023-10-06 21:39:00","inspection_id":"79848190","insp_violation_id":"255692242","seq_no":"3","part_no":"393","part_no_section":"110B3-C","insp_viol_unit":"2","insp_unit_id":"197428401","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"393110B3C"},{"id":6408154,"change_date":"2023-10-06 21:39:00","inspection_id":"79848190","insp_violation_id":"255692243","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"197428400","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"000180196987","created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":6656787,"change_date":"2023-10-06 21:39:00","inspection_id":"79848190","insp_unit_id":"197428400","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"R627964","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDP4TX7PF241810","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:50.000000Z","updated_at":"2025-03-17T22:55:50.000000Z"},{"id":6656788,"change_date":"2023-10-06 21:39:00","inspection_id":"79848190","insp_unit_id":"197428401","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORSEY TRA","insp_unit_company":null,"insp_unit_license":"146289T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"5JYFB482XKED11060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:50.000000Z","updated_at":"2025-03-17T22:55:50.000000Z"}]},{"id":3500619,"change_date":"2023-07-18 21:42:00","inspection_id":"79134942","dot_number":"676883","report_state":"IN","report_number":"6162010768","insp_date":"2023-07-07 00:00:00","insp_start_time":"1130","insp_end_time":"1200","registration_date":"2023-07-18 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"CR 600 W SB AT CR 100 N","county_code_state":"IN","county_code":"127","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"UNITED PIPING INC","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-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"188000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2196725","transaction_code":"C","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":"M","census_search_date":"2023-07-13 21:42:00","snet_input_date":"2023-07-11 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-07-13 21:42:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:25.000000Z","updated_at":"2025-03-17T19:32:25.000000Z","inspection_violations":[{"id":5396591,"change_date":"2023-07-18 21:42:00","inspection_id":"79134942","insp_violation_id":"254124726","seq_no":"1","part_no":"393","part_no_section":"110","insp_viol_unit":"2","insp_unit_id":"196058661","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"393110"}],"inspection_per_units":[{"id":5628864,"change_date":"2023-07-18 21:42:00","inspection_id":"79134942","insp_unit_id":"196058661","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"164C276","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TKJ05331LY072055","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":5628865,"change_date":"2023-07-18 21:42:00","inspection_id":"79134942","insp_unit_id":"196058662","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1813","insp_unit_license":"R641037","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDP4TX2PF241813","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":3354211,"change_date":"2023-06-23 21:40:00","inspection_id":"78970449","dot_number":"676883","report_state":"WI","report_number":"2360007080","insp_date":"2023-06-22 00:00:00","insp_start_time":"1240","insp_end_time":"1318","registration_date":null,"region":"CT","ci_status_code":"C","location":"S72","location_desc":"SUPERIOR SWEF","county_code_state":"WI","county_code":"031","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"PRIVATE","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-06-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"898164","transaction_code":"A","transaction_date":"2023-06-23 00:00:00","upload_date":"2023-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":"M","census_search_date":"2023-06-23 21:40:00","snet_input_date":"2023-06-23 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-06-23 21:40:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:23.000000Z","updated_at":"2025-03-17T19:29:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5392153,"change_date":"2023-06-23 21:40:00","inspection_id":"78970449","insp_unit_id":"195650254","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"607250","insp_unit_license":"PAT9354","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XKDDP9X0EJ417252","insp_unit_decal":"Y","insp_unit_decal_number":"32746795","created_at":"2025-03-17T22:45:32.000000Z","updated_at":"2025-03-17T22:45:32.000000Z"},{"id":5392154,"change_date":"2023-06-23 21:40:00","inspection_id":"78970449","insp_unit_id":"195650255","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"7055A","insp_unit_license":"658112","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1GRDM96255M701982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:32.000000Z","updated_at":"2025-03-17T22:45:32.000000Z"}]},{"id":3357945,"change_date":"2023-06-24 21:31:00","inspection_id":"78974554","dot_number":"676883","report_state":"IN","report_number":"6162010715","insp_date":"2023-06-20 00:00:00","insp_start_time":"1044","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 30 WB AT COOLWOOD","county_code_state":"IN","county_code":"127","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-24 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"2194716","transaction_code":"A","transaction_date":"2023-06-21 00:00:00","upload_date":"2023-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":"M","census_search_date":"2023-06-24 21:31:00","snet_input_date":"2023-06-21 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-06-24 21:31:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:24.000000Z","updated_at":"2025-03-17T19:29:24.000000Z","inspection_violations":[{"id":5178871,"change_date":"2023-06-24 21:31:00","inspection_id":"78974554","insp_violation_id":"253683846","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":null,"created_at":"2025-03-17T21:31:01.000000Z","updated_at":"2025-03-17T21:31:01.000000Z","normalized_code":"3922"},{"id":5178872,"change_date":"2023-06-24 21:31:00","inspection_id":"78974554","insp_violation_id":"253683847","seq_no":"2","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":"000180974413","created_at":"2025-03-17T21:31:01.000000Z","updated_at":"2025-03-17T21:31:01.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5398223,"change_date":"2023-06-24 21:31:00","inspection_id":"78974554","insp_unit_id":"195658767","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1810","insp_unit_license":"R627964","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDP4TX7PF241810","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:35.000000Z","updated_at":"2025-03-17T22:45:35.000000Z"},{"id":5398224,"change_date":"2023-06-24 21:31:00","inspection_id":"78974554","insp_unit_id":"195658768","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"N5227","insp_unit_license":"146289T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"5JYFB482XKED11060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:35.000000Z","updated_at":"2025-03-17T22:45:35.000000Z"}]},{"id":3192911,"change_date":"2023-09-08 21:41:00","inspection_id":"78788359","dot_number":"676883","report_state":"IN","report_number":"6162010669","insp_date":"2023-05-31 00:00:00","insp_start_time":"1515","insp_end_time":"1536","registration_date":"2023-09-07 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"US 30 EB AT STURDY RD","county_code_state":"IN","county_code":"127","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-01 21:42: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":"2191912","transaction_code":"C","transaction_date":"2023-06-01 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":"M","census_search_date":"2023-06-01 21:42:00","snet_input_date":"2023-06-01 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-06-01 21:42:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:07.000000Z","updated_at":"2025-03-17T19:26:07.000000Z","inspection_violations":[{"id":4918109,"change_date":"2023-09-08 21:41:00","inspection_id":"78788359","insp_violation_id":"255162909","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":"000180263459","created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5135592,"change_date":"2023-09-08 21:41:00","inspection_id":"78788359","insp_unit_id":"196966948","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1810","insp_unit_license":"R627964","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDP4TX7PF241810","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:29.000000Z","updated_at":"2025-03-17T22:43:29.000000Z"},{"id":5135593,"change_date":"2023-09-08 21:41:00","inspection_id":"78788359","insp_unit_id":"196966949","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":null,"insp_unit_license":"146289T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"5JYFB482XKED11060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:29.000000Z","updated_at":"2025-03-17T22:43:29.000000Z"}]},{"id":2988187,"change_date":"2023-05-08 21:42:00","inspection_id":"78557389","dot_number":"676883","report_state":"IL","report_number":"4039540574","insp_date":"2023-05-02 00:00:00","insp_start_time":"1030","insp_end_time":"1147","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"US RT 52","county_code_state":"IL","county_code":"093","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":"N","pen_cen_match":null,"final_status_date":"2023-05-08 21:42:00","post_acc_ind":"Y","gross_comb_veh_wt":"16500","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":"2242939","transaction_code":"A","transaction_date":"2023-05-02 00:00:00","upload_date":"2023-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2023-05-08 21:42:00","snet_input_date":"2023-05-02 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-05-08 21:42:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"102683","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:15.000000Z","updated_at":"2025-03-17T19:22:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4807426,"change_date":"2023-05-08 21:42:00","inspection_id":"78557389","insp_unit_id":"194802548","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"N\/A","insp_unit_license":"5027PRA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FD0W4HT8KEE91732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:52.000000Z","updated_at":"2025-03-17T22:40:52.000000Z"}]},{"id":2398016,"change_date":"2023-02-17 21:39:00","inspection_id":"77886738","dot_number":"676883","report_state":"MN","report_number":"0AEU000021","insp_date":"2023-02-17 00:00:00","insp_start_time":"0810","insp_end_time":"0850","registration_date":null,"region":"CT","ci_status_code":"C","location":"SGNAW","location_desc":"SAGINAW WEIGH SCALE","county_code_state":"MN","county_code":"137","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26500","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":"1373009","transaction_code":"A","transaction_date":"2023-02-17 00:00:00","upload_date":"2023-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2023-02-17 21:39:00","snet_input_date":"2023-02-17 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-02-17 21:39:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:46.000000Z","updated_at":"2025-03-17T19:10:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3859047,"change_date":"2023-02-17 21:39:00","inspection_id":"77886738","insp_unit_id":"193462551","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7243","insp_unit_license":"4897PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0W4HT4KEE91730","insp_unit_decal":"Y","insp_unit_decal_number":"32374882","created_at":"2025-03-17T22:33:38.000000Z","updated_at":"2025-03-17T22:33:38.000000Z"},{"id":3859048,"change_date":"2023-02-17 21:39:00","inspection_id":"77886738","insp_unit_id":"193462552","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"8797CTL","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"43YDC26228C066084","insp_unit_decal":"Y","insp_unit_decal_number":"32374883","created_at":"2025-03-17T22:33:38.000000Z","updated_at":"2025-03-17T22:33:38.000000Z"}]},{"id":1891078,"change_date":"2022-12-07 21:40:00","inspection_id":"77307505","dot_number":"676883","report_state":"WI","report_number":"2405011479","insp_date":"2022-12-05 00:00:00","insp_start_time":"0924","insp_end_time":"0950","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"STH 35","county_code_state":"WI","county_code":"013","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2022-12-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","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":"879638","transaction_code":"A","transaction_date":"2022-12-07 00:00:00","upload_date":"2022-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":"M","census_search_date":"2022-12-07 21:40:00","snet_input_date":"2022-12-07 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-12-07 21:40:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:30.000000Z","updated_at":"2025-03-17T19:01:30.000000Z","inspection_violations":[{"id":2941706,"change_date":"2022-12-07 21:40:00","inspection_id":"77307505","insp_violation_id":"249968603","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"192305224","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:02.000000Z","updated_at":"2025-03-17T21:21:02.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":3043607,"change_date":"2022-12-07 21:40:00","inspection_id":"77307505","insp_unit_id":"192305223","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7218","insp_unit_license":"PAV0141","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1NPXGGGG50D227448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:50.000000Z","updated_at":"2025-03-17T22:27:50.000000Z"},{"id":3043608,"change_date":"2022-12-07 21:40:00","inspection_id":"77307505","insp_unit_id":"192305224","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"7757","insp_unit_license":"5282STY","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"13N352308C3554312","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:50.000000Z","updated_at":"2025-03-17T22:27:50.000000Z"}]},{"id":1870563,"change_date":"2022-12-05 21:40:00","inspection_id":"77283992","dot_number":"676883","report_state":"WI","report_number":"2628004385","insp_date":"2022-12-02 00:00:00","insp_start_time":"1546","insp_end_time":"1559","registration_date":null,"region":"CT","ci_status_code":"C","location":"15(16)","location_desc":"SUPERIOR (TOWN)","county_code_state":"WI","county_code":"031","insp_level_id":"3","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":"2022-12-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"88040","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":"879441","transaction_code":"A","transaction_date":"2022-12-05 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":"M","census_search_date":"2022-12-05 21:40:00","snet_input_date":"2022-12-05 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-12-05 21:40:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:07.000000Z","updated_at":"2025-03-17T19:01:07.000000Z","inspection_violations":[{"id":2911995,"change_date":"2022-12-05 21:40:00","inspection_id":"77283992","insp_violation_id":"249916445","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192258379","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3010638,"change_date":"2022-12-05 21:40:00","inspection_id":"77283992","insp_unit_id":"192258379","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"2716PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1NKDX4TX3EJ401829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:37.000000Z","updated_at":"2025-03-17T22:27:37.000000Z"}]},{"id":1729562,"change_date":"2022-11-14 21:42:00","inspection_id":"77122620","dot_number":"676883","report_state":"MN","report_number":"0ADI002061","insp_date":"2022-11-14 00:00:00","insp_start_time":"1028","insp_end_time":"1046","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"MIDWAY","county_code_state":"MN","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2022-11-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"78350","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":"1360984","transaction_code":"A","transaction_date":"2022-11-14 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2022-11-14 21:42:00","snet_input_date":"2022-11-14 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-11-14 21:42:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:33.000000Z","updated_at":"2025-03-17T18:58:33.000000Z","inspection_violations":[{"id":2707524,"change_date":"2022-11-14 21:42:00","inspection_id":"77122620","insp_violation_id":"249571726","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191932538","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2782548,"change_date":"2022-11-14 21:42:00","inspection_id":"77122620","insp_unit_id":"191932538","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"8861PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1NKZX4EX2MJ449050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:02.000000Z","updated_at":"2025-03-17T22:26:02.000000Z"}]},{"id":1542659,"change_date":"2022-10-18 21:40:00","inspection_id":"76907736","dot_number":"676883","report_state":"MN","report_number":"00XY007924","insp_date":"2022-10-18 00:00:00","insp_start_time":"1025","insp_end_time":"1109","registration_date":null,"region":"CT","ci_status_code":"C","location":"CRLTN","location_desc":"CARLTON","county_code_state":"MN","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","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":"2022-10-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1356738","transaction_code":"A","transaction_date":"2022-10-18 00:00:00","upload_date":"2022-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2022-10-18 21:40:00","snet_input_date":"2022-10-18 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-10-18 21:40:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:10.000000Z","updated_at":"2025-03-17T18:55:10.000000Z","inspection_violations":[{"id":2427113,"change_date":"2022-10-18 21:40:00","inspection_id":"76907736","insp_violation_id":"249099205","seq_no":"1","part_no":"391","part_no_section":"49(j)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"39149J"}],"inspection_per_units":[{"id":2482514,"change_date":"2022-10-18 21:40:00","inspection_id":"76907736","insp_unit_id":"191503283","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7109","insp_unit_license":"YBL2396","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0X5HT3EEB28648","insp_unit_decal":"Y","insp_unit_decal_number":"32018602","created_at":"2025-03-17T22:24:01.000000Z","updated_at":"2025-03-17T22:24:01.000000Z"}]},{"id":1542084,"change_date":"2022-10-18 21:40:00","inspection_id":"76907074","dot_number":"676883","report_state":"IL","report_number":"4180700594","insp_date":"2022-10-17 00:00:00","insp_start_time":"0739","insp_end_time":"0743","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-80","county_code_state":"IL","county_code":"197","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":"2022-10-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"102000","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":"2205219","transaction_code":"A","transaction_date":"2022-10-17 00:00:00","upload_date":"2022-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2022-10-18 21:40:00","snet_input_date":"2022-10-17 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-10-18 21:40:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"102683","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:10.000000Z","updated_at":"2025-03-17T18:55:10.000000Z","inspection_violations":[{"id":2426353,"change_date":"2022-10-18 21:40:00","inspection_id":"76907074","insp_violation_id":"249097793","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":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2481515,"change_date":"2022-10-18 21:40:00","inspection_id":"76907074","insp_unit_id":"191501653","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"194808","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XKZD49X5FJ424901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:01.000000Z","updated_at":"2025-03-17T22:24:01.000000Z"},{"id":2481516,"change_date":"2022-10-18 21:40:00","inspection_id":"76907074","insp_unit_id":"191501654","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"653792","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"UNK","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:01.000000Z","updated_at":"2025-03-17T22:24:01.000000Z"}]},{"id":1496658,"change_date":"2022-10-12 21:41:00","inspection_id":"76854893","dot_number":"676883","report_state":"IA","report_number":"000TT6LD13","insp_date":"2022-10-11 00:00:00","insp_start_time":"0944","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 63","county_code_state":"IA","county_code":"051","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED PIPE","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":"2022-10-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"128600","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":"1246426","transaction_code":"A","transaction_date":"2022-10-12 00:00:00","upload_date":"2022-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":"M","census_search_date":"2022-10-12 21:41:00","snet_input_date":"2022-10-11 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-10-12 21:41:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:10.000000Z","updated_at":"2025-03-17T18:54:10.000000Z","inspection_violations":[{"id":2354639,"change_date":"2022-10-12 21:41:00","inspection_id":"76854893","insp_violation_id":"248978562","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:47.000000Z","updated_at":"2025-03-17T21:17:47.000000Z","normalized_code":"3922"},{"id":2354640,"change_date":"2022-10-12 21:41:00","inspection_id":"76854893","insp_violation_id":"248978563","seq_no":"2","part_no":"395","part_no_section":"24(c)(2)(iii)","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:17:47.000000Z","updated_at":"2025-03-17T21:17:47.000000Z","normalized_code":"39524C2III"}],"inspection_per_units":[{"id":2408686,"change_date":"2022-10-12 21:41:00","inspection_id":"76854893","insp_unit_id":"191398748","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7209","insp_unit_license":"PAL6440","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XP5DB0X36D880663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:30.000000Z","updated_at":"2025-03-17T22:23:30.000000Z"},{"id":2408687,"change_date":"2022-10-12 21:41:00","inspection_id":"76854893","insp_unit_id":"191398749","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"NEVI","insp_unit_company":"7726","insp_unit_license":"0607STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1N9DD5327HF175452","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:30.000000Z","updated_at":"2025-03-17T22:23:30.000000Z"}]},{"id":1458409,"change_date":"2022-10-06 21:40:00","inspection_id":"76810481","dot_number":"676883","report_state":"IA","report_number":"000TT8BQB3","insp_date":"2022-10-05 00:00:00","insp_start_time":"0800","insp_end_time":"0824","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 2 WB AND K AVE","county_code_state":"IA","county_code":"145","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"EMPTY","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"34480","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":"1245727","transaction_code":"A","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":"M","census_search_date":"2022-10-06 21:40:00","snet_input_date":"2022-10-05 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-10-06 21:40:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:28.000000Z","updated_at":"2025-03-17T18:53:28.000000Z","inspection_violations":[{"id":2295928,"change_date":"2022-10-06 21:40:00","inspection_id":"76810481","insp_violation_id":"248877076","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3922"},{"id":2295929,"change_date":"2022-10-06 21:40:00","inspection_id":"76810481","insp_violation_id":"248877077","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191309918","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2347754,"change_date":"2022-10-06 21:40:00","inspection_id":"76810481","insp_unit_id":"191309917","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7199","insp_unit_license":"0206PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0W5HTXDEB54116","insp_unit_decal":"Y","insp_unit_decal_number":"32040321","created_at":"2025-03-17T22:23:05.000000Z","updated_at":"2025-03-17T22:23:05.000000Z"},{"id":2347755,"change_date":"2022-10-06 21:40:00","inspection_id":"76810481","insp_unit_id":"191309918","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWMTRL","insp_unit_company":"2404","insp_unit_license":"6941CTA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"4KNUT2023FL162404","insp_unit_decal":"Y","insp_unit_decal_number":"32040322","created_at":"2025-03-17T22:23:05.000000Z","updated_at":"2025-03-17T22:23:05.000000Z"}]},{"id":1325264,"change_date":"2022-09-28 21:40:00","inspection_id":"76655920","dot_number":"676883","report_state":"KY","report_number":"CV44373504","insp_date":"2022-09-19 00:00:00","insp_start_time":"1230","insp_end_time":"1325","registration_date":"2022-09-28 00:00:00","region":"CT","ci_status_code":"C","location":"9814","location_desc":"KUTTAWA","county_code_state":"KY","county_code":"143","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"UNITED PIPING INC","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-09-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2122598","transaction_code":"C","transaction_date":"2022-09-20 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":"M","census_search_date":"2022-09-20 21:41:00","snet_input_date":"2022-09-20 00:00:00","source_office":"2KYS001","mcmis_add_date":"2022-09-20 21:41:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:12.000000Z","updated_at":"2025-03-17T18:51:12.000000Z","inspection_violations":[{"id":2097250,"change_date":"2022-09-28 21:40:00","inspection_id":"76655920","insp_violation_id":"248692126","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":null,"created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"3922"},{"id":2097251,"change_date":"2022-09-28 21:40:00","inspection_id":"76655920","insp_violation_id":"248692127","seq_no":"2","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"2","insp_unit_id":"191140410","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"39347A"},{"id":2097252,"change_date":"2022-09-28 21:40:00","inspection_id":"76655920","insp_violation_id":"248692128","seq_no":"3","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"2","insp_unit_id":"191140410","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"39347A"},{"id":2097253,"change_date":"2022-09-28 21:40:00","inspection_id":"76655920","insp_violation_id":"248692129","seq_no":"4","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"2","insp_unit_id":"191140410","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"39347A"},{"id":2097254,"change_date":"2022-09-28 21:40:00","inspection_id":"76655920","insp_violation_id":"248692130","seq_no":"5","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"2","insp_unit_id":"191140410","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"39347A"},{"id":2097255,"change_date":"2022-09-28 21:40:00","inspection_id":"76655920","insp_violation_id":"248692131","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"191140410","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":"ED19087","created_at":"2025-03-17T21:16:34.000000Z","updated_at":"2025-03-17T21:16:34.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2133252,"change_date":"2022-09-28 21:40:00","inspection_id":"76655920","insp_unit_id":"191140409","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7201","insp_unit_license":"PAN3409","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XPTP4EX0FD258430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:36.000000Z","updated_at":"2025-03-17T22:21:36.000000Z"},{"id":2133253,"change_date":"2022-09-28 21:40:00","inspection_id":"76655920","insp_unit_id":"191140410","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"0607STT","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1N9DD5327HF175452","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:36.000000Z","updated_at":"2025-03-17T22:21:36.000000Z"}]},{"id":1239571,"change_date":"2022-09-08 21:38:00","inspection_id":"76556365","dot_number":"676883","report_state":"MN","report_number":"0ADI001948","insp_date":"2022-09-08 00:00:00","insp_start_time":"0956","insp_end_time":"1022","registration_date":null,"region":"CT","ci_status_code":"C","location":"HRMTN","location_desc":"HERMANTOWN","county_code_state":"MN","county_code":"137","insp_level_id":"1","service_center":"MW","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2022-09-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","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":"1349329","transaction_code":"A","transaction_date":"2022-09-08 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2022-09-08 21:38:00","snet_input_date":"2022-09-08 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-09-08 21:38:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:23.000000Z","updated_at":"2025-03-17T18:49:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1994778,"change_date":"2022-09-08 21:38:00","inspection_id":"76556365","insp_unit_id":"190788598","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7167","insp_unit_license":"0203PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD9W4HT2FEA60025","insp_unit_decal":"Y","insp_unit_decal_number":"31703493","created_at":"2025-03-17T22:20:42.000000Z","updated_at":"2025-03-17T22:20:42.000000Z"},{"id":1994779,"change_date":"2022-09-08 21:38:00","inspection_id":"76556365","insp_unit_id":"190788599","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"8757CTL","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"43YDC26228C066084","insp_unit_decal":"Y","insp_unit_decal_number":"31703494","created_at":"2025-03-17T22:20:42.000000Z","updated_at":"2025-03-17T22:20:42.000000Z"}]},{"id":1113381,"change_date":"2022-08-23 21:41:00","inspection_id":"76409936","dot_number":"676883","report_state":"MN","report_number":"0AEA001284","insp_date":"2022-08-22 00:00:00","insp_start_time":"1637","insp_end_time":"1747","registration_date":null,"region":"CT","ci_status_code":"C","location":"SGNAW","location_desc":"SAGINAW WEIGH SCALE","county_code_state":"MN","county_code":"137","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1346281","transaction_code":"A","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2022-08-23 21:41:00","snet_input_date":"2022-08-23 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-08-23 21:41:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:15.000000Z","updated_at":"2025-03-17T18:47:15.000000Z","inspection_violations":[{"id":1754728,"change_date":"2022-08-23 21:41:00","inspection_id":"76409936","insp_violation_id":"247926282","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190490222","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:10.000000Z","updated_at":"2025-03-17T21:15:10.000000Z","normalized_code":"39345B2"},{"id":1754729,"change_date":"2022-08-23 21:41:00","inspection_id":"76409936","insp_violation_id":"247926283","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190490222","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:10.000000Z","updated_at":"2025-03-17T21:15:10.000000Z","normalized_code":"39345B2"},{"id":1754730,"change_date":"2022-08-23 21:41:00","inspection_id":"76409936","insp_violation_id":"247926284","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"190490223","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:10.000000Z","updated_at":"2025-03-17T21:15:10.000000Z","normalized_code":"39345B2"},{"id":1754731,"change_date":"2022-08-23 21:41:00","inspection_id":"76409936","insp_violation_id":"247926285","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"190490223","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:10.000000Z","updated_at":"2025-03-17T21:15:10.000000Z","normalized_code":"39347E"},{"id":1754732,"change_date":"2022-08-23 21:41:00","inspection_id":"76409936","insp_violation_id":"247926286","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"190490223","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:10.000000Z","updated_at":"2025-03-17T21:15:10.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":1790442,"change_date":"2022-08-23 21:41:00","inspection_id":"76409936","insp_unit_id":"190490222","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7215","insp_unit_license":"PAK9662","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XPHDB9X97N648841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:19.000000Z","updated_at":"2025-03-17T22:19:19.000000Z"},{"id":1790443,"change_date":"2022-08-23 21:41:00","inspection_id":"76409936","insp_unit_id":"190490223","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"7361","insp_unit_license":"6432STU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1N9DD5329KD175181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:19.000000Z","updated_at":"2025-03-17T22:19:19.000000Z"}]},{"id":996160,"change_date":"2022-09-08 21:38:00","inspection_id":"76273026","dot_number":"676883","report_state":"IL","report_number":"4181600005","insp_date":"2022-08-08 00:00:00","insp_start_time":"1005","insp_end_time":"1018","registration_date":null,"region":"CT","ci_status_code":"C","location":"010","location_desc":"010 - CHICAGO HEIGHTS-US30 @TO","county_code_state":"IL","county_code":"031","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":"N","pen_cen_match":null,"final_status_date":"2022-08-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"30500","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":"2186226","transaction_code":"C","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2022-08-09 21:41:00","snet_input_date":"2022-08-08 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-08-09 21:41:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"102683","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:08.000000Z","updated_at":"2025-03-17T18:45:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1602901,"change_date":"2022-09-08 21:38:00","inspection_id":"76273026","insp_unit_id":"190787228","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"4897PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0W4HT4KEE91730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:06.000000Z","updated_at":"2025-03-17T22:18:06.000000Z"},{"id":1602902,"change_date":"2022-09-08 21:38:00","inspection_id":"76273026","insp_unit_id":"190787229","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AME","insp_unit_company":null,"insp_unit_license":"4897PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5N6200J27C1033994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:06.000000Z","updated_at":"2025-03-17T22:18:06.000000Z"}]},{"id":749182,"change_date":"2022-07-05 21:42:00","inspection_id":"75984455","dot_number":"676883","report_state":"MN","report_number":"0ADI001812","insp_date":"2022-07-05 00:00:00","insp_start_time":"0944","insp_end_time":"1017","registration_date":null,"region":"CT","ci_status_code":"C","location":"DLTH","location_desc":"DULUTH","county_code_state":"MN","county_code":"137","insp_level_id":"1","service_center":"MW","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"34980","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1337036","transaction_code":"A","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2022-07-05 21:42:00","snet_input_date":"2022-07-05 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:53.000000Z","updated_at":"2025-03-17T18:40:53.000000Z","inspection_violations":[{"id":1179432,"change_date":"2022-07-05 21:42:00","inspection_id":"75984455","insp_violation_id":"246886412","seq_no":"1","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"189601734","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"39341"},{"id":1179433,"change_date":"2022-07-05 21:42:00","inspection_id":"75984455","insp_violation_id":"246886413","seq_no":"2","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"189601734","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"393203"}],"inspection_per_units":[{"id":1204647,"change_date":"2022-07-05 21:42:00","inspection_id":"75984455","insp_unit_id":"189601733","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"9420CTU","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"4KNUT2025EL160491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:34.000000Z","updated_at":"2025-03-17T22:15:34.000000Z"},{"id":1204648,"change_date":"2022-07-05 21:42:00","inspection_id":"75984455","insp_unit_id":"189601734","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7198","insp_unit_license":"0749PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0X4HT7DEB05592","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:34.000000Z","updated_at":"2025-03-17T22:15:34.000000Z"}]},{"id":605094,"change_date":"2022-06-14 21:42:00","inspection_id":"75814471","dot_number":"676883","report_state":"MN","report_number":"00VM007376","insp_date":"2022-06-14 00:00:00","insp_start_time":"0945","insp_end_time":"1020","registration_date":null,"region":"CT","ci_status_code":"C","location":"SGNAW","location_desc":"SAGINAW WEIGH SCALE","county_code_state":"MN","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-06-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"88040","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":"1333817","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":null,"census_search_date":"2022-06-14 21:42:00","snet_input_date":"2022-06-14 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-06-14 21:42:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:25.000000Z","updated_at":"2025-03-17T18:38:25.000000Z","inspection_violations":[{"id":949798,"change_date":"2022-06-14 21:42:00","inspection_id":"75814471","insp_violation_id":"246447492","seq_no":"1","part_no":"395","part_no_section":"8(f)(1)","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:11:27.000000Z","updated_at":"2025-03-17T21:11:27.000000Z","normalized_code":"3958F1"},{"id":949799,"change_date":"2022-06-14 21:42:00","inspection_id":"75814471","insp_violation_id":"246447493","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189236535","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:27.000000Z","updated_at":"2025-03-17T21:11:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":972751,"change_date":"2022-06-14 21:42:00","inspection_id":"75814471","insp_unit_id":"189236535","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"2716PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1NKDX4TX3EJ401829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:11.000000Z","updated_at":"2025-03-17T22:14:11.000000Z"}]},{"id":473059,"change_date":"2022-05-24 21:43:00","inspection_id":"75657239","dot_number":"676883","report_state":"MO","report_number":"SLC5001141","insp_date":"2022-05-23 00:00:00","insp_start_time":"1008","insp_end_time":"1052","registration_date":null,"region":"CT","ci_status_code":"C","location":"C21","location_desc":"TESSON FERRY\/KENNERLY RD","county_code_state":"MO","county_code":"189","insp_level_id":"1","service_center":"MW","census_source_id":"4","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":"Y","pen_cen_match":"I","final_status_date":"2022-05-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"31500","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":"2013141","transaction_code":"A","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00676883","upload_search_indicator":"M","census_search_date":"2022-05-24 21:43:00","snet_input_date":"2022-05-24 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-05-24 21:43:00","insp_carrier_name":"UNITED PIPING INC","insp_carrier_street":"4510 AIRPORT RD","insp_carrier_city":"DULUTH","insp_carrier_state":"MN","insp_carrier_zip_code":"55811","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:59.000000Z","updated_at":"2025-03-17T18:35:59.000000Z","inspection_violations":[{"id":748374,"change_date":"2022-05-24 21:43:00","inspection_id":"75657239","insp_violation_id":"246040404","seq_no":"1","part_no":"393","part_no_section":"70(d)(8)","insp_viol_unit":"2","insp_unit_id":"188885427","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"39370D8"}],"inspection_per_units":[{"id":760652,"change_date":"2022-05-24 21:43:00","inspection_id":"75657239","insp_unit_id":"188885426","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"307247","insp_unit_license":"5029PRA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FD0W4HT1KEE91734","insp_unit_decal":"Y","insp_unit_decal_number":"31398692","created_at":"2025-03-17T22:12:53.000000Z","updated_at":"2025-03-17T22:12:53.000000Z"},{"id":760653,"change_date":"2022-05-24 21:43:00","inspection_id":"75657239","insp_unit_id":"188885427","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WELL","insp_unit_company":"7773","insp_unit_license":"7597CTE","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"575200J28HH329082","insp_unit_decal":"Y","insp_unit_decal_number":"31398693","created_at":"2025-03-17T22:12:53.000000Z","updated_at":"2025-03-17T22:12:53.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/676883\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/676883\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/676883\/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\/676883\/inspections","per_page":100,"prev_page_url":null,"to":46,"total":46}