{"current_page":1,"data":[{"id":12281618,"change_date":"2026-06-25 21:51:00","inspection_id":"88241438","dot_number":"336827","report_state":"IA","report_number":"460L000104","insp_date":"2026-06-25 00:00:00","insp_start_time":"1145","insp_end_time":"1210","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"IA","county_code_state":"IA","county_code":"171","insp_level_id":"3","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":"U","pen_cen_match":"I","final_status_date":"2026-06-25 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3622894","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2026-06-25 21:51:00","snet_input_date":"2026-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-25 21:51:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-28T09:39:51.000000Z","updated_at":"2026-07-06T09:32:42.000000Z","inspection_violations":[{"id":21376988,"change_date":"2026-06-25 21:51:00","inspection_id":"88241438","insp_violation_id":"275128811","seq_no":"1","part_no":"392","part_no_section":"16-D","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-06-28T09:56:50.000000Z","updated_at":"2026-07-06T09:47:50.000000Z","normalized_code":"39216D"},{"id":21376989,"change_date":"2026-06-25 21:51:00","inspection_id":"88241438","insp_violation_id":"275128812","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"214287266","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-28T09:56:50.000000Z","updated_at":"2026-07-06T09:47:50.000000Z","normalized_code":"39021TB1MC"},{"id":21376990,"change_date":"2026-06-25 21:51:00","inspection_id":"88241438","insp_violation_id":"275128813","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"214287266","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-28T09:56:50.000000Z","updated_at":"2026-07-06T09:47:50.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":21325815,"change_date":"2026-06-25 21:51:00","inspection_id":"88241438","insp_unit_id":"214287266","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1","insp_unit_license":"8615167","insp_unit_license_state":"CO","insp_unit_vehicle_id_number":"3ALHC5DVXLDLZ075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:15:31.000000Z","updated_at":"2026-07-06T09:04:54.000000Z"}]},{"id":11711373,"change_date":"2026-04-21 21:39:00","inspection_id":"87638393","dot_number":"336827","report_state":"IA","report_number":"000P15VBPM","insp_date":"2026-04-13 00:00:00","insp_start_time":"0715","insp_end_time":"0745","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":"1","service_center":"MW","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1397198","transaction_code":"A","transaction_date":"2026-04-13 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2026-04-21 21:39:00","snet_input_date":"2026-04-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-04-21 21:39:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"506430398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:38:08.000000Z","updated_at":"2026-05-02T09:31:07.000000Z","inspection_violations":[{"id":20354531,"change_date":"2026-04-21 21:39:00","inspection_id":"87638393","insp_violation_id":"273754083","seq_no":"7","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213141659","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:46.000000Z","updated_at":"2026-05-02T09:43:31.000000Z","normalized_code":"39395F"},{"id":20354532,"change_date":"2026-04-21 21:39:00","inspection_id":"87638393","insp_violation_id":"273754084","seq_no":"8","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"213141659","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:46.000000Z","updated_at":"2026-05-02T09:43:31.000000Z","normalized_code":"39378"},{"id":20354525,"change_date":"2026-04-21 21:39:00","inspection_id":"87638393","insp_violation_id":"273754077","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213141659","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:46.000000Z","updated_at":"2026-05-02T09:43:31.000000Z","normalized_code":"3922RG"},{"id":20354526,"change_date":"2026-04-21 21:39:00","inspection_id":"87638393","insp_violation_id":"273754078","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"213141659","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:46.000000Z","updated_at":"2026-05-02T09:43:31.000000Z","normalized_code":"39617C"},{"id":20354527,"change_date":"2026-04-21 21:39:00","inspection_id":"87638393","insp_violation_id":"273754079","seq_no":"3","part_no":"392","part_no_section":"2IN","insp_viol_unit":"1","insp_unit_id":"213141659","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:46.000000Z","updated_at":"2026-05-02T09:43:31.000000Z","normalized_code":"3922IN"},{"id":20354528,"change_date":"2026-04-21 21:39:00","inspection_id":"87638393","insp_violation_id":"273754080","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213141659","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:46.000000Z","updated_at":"2026-05-02T09:43:31.000000Z","normalized_code":"3939"},{"id":20354530,"change_date":"2026-04-21 21:39:00","inspection_id":"87638393","insp_violation_id":"273754082","seq_no":"6","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"213141659","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:46.000000Z","updated_at":"2026-05-02T09:43:31.000000Z","normalized_code":"39395A"},{"id":20354529,"change_date":"2026-04-21 21:39:00","inspection_id":"87638393","insp_violation_id":"273754081","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213141659","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:46.000000Z","updated_at":"2026-05-02T09:43:31.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":20380125,"change_date":"2026-04-21 21:39:00","inspection_id":"87638393","insp_unit_id":"213141659","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"207","insp_unit_license":"OOH825","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALHCYCY7GDGX9770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:14:37.000000Z","updated_at":"2026-05-02T09:03:40.000000Z"}]},{"id":9791289,"change_date":"2025-09-26 21:40:00","inspection_id":"85890141","dot_number":"336827","report_state":"IA","report_number":"000P169BJ4","insp_date":"2025-09-25 00:00:00","insp_start_time":"0737","insp_end_time":"0817","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"MISC","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-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"79500","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1375724","transaction_code":"A","transaction_date":"2025-09-26 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-30T10:01:08.000000Z","updated_at":"2025-09-30T10:01:08.000000Z","inspection_violations":[{"id":16103101,"change_date":"2025-09-26 21:40:00","inspection_id":"85890141","insp_violation_id":"268949115","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1WIN25092508023","created_at":"2025-09-30T10:16:50.000000Z","updated_at":"2025-09-30T10:16:50.000000Z","normalized_code":"3922SLLEWA1"},{"id":16103102,"change_date":"2025-09-26 21:40:00","inspection_id":"85890141","insp_violation_id":"268949116","seq_no":"2","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-30T10:16:50.000000Z","updated_at":"2025-09-30T10:16:50.000000Z","normalized_code":"38323A2"},{"id":16103103,"change_date":"2025-09-26 21:40:00","inspection_id":"85890141","insp_violation_id":"268949117","seq_no":"3","part_no":"383","part_no_section":"71H","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:50.000000Z","updated_at":"2025-09-30T10:16:50.000000Z","normalized_code":"38371H"}],"inspection_per_units":[{"id":16226796,"change_date":"2025-09-26 21:40:00","inspection_id":"85890141","insp_unit_id":"209168607","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8402","insp_unit_license":"SME","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVMG3DV5SHVT8402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:44.000000Z","updated_at":"2025-09-30T09:45:44.000000Z"}]},{"id":9541501,"change_date":"2025-08-29 21:40:00","inspection_id":"85628560","dot_number":"336827","report_state":"MN","report_number":"1640000783","insp_date":"2025-08-22 00:00:00","insp_start_time":"0856","insp_end_time":"0919","registration_date":null,"region":"CD","ci_status_code":"C","location":"RDRVR","location_desc":"MOORHEAD MN","county_code_state":"MN","county_code":"027","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":"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":"56000","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":"2192720","transaction_code":"A","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2025-08-29 21:40:00","snet_input_date":"2025-08-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-29 21:40:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:27.000000Z","updated_at":"2025-09-06T10:42:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15748850,"change_date":"2025-08-29 21:40:00","inspection_id":"85628560","insp_unit_id":"208650563","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"108","insp_unit_license":"SME","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHBGAN74HM64401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:46.000000Z","updated_at":"2025-09-09T09:46:46.000000Z"}]},{"id":9769457,"change_date":"2025-09-24 21:42:00","inspection_id":"85867286","dot_number":"336827","report_state":"IA","report_number":"000P15NF4N","insp_date":"2025-08-19 00:00:00","insp_start_time":"0945","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":"013","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1375513","transaction_code":"A","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-08-19 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:15.000000Z","updated_at":"2025-09-28T10:00:38.000000Z","inspection_violations":[{"id":16057732,"change_date":"2025-09-24 21:42:00","inspection_id":"85867286","insp_violation_id":"268898547","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0LEE25081909522","created_at":"2025-09-27T10:17:05.000000Z","updated_at":"2025-09-28T10:16:02.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":16184813,"change_date":"2025-09-24 21:42:00","inspection_id":"85867286","insp_unit_id":"209125171","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"139","insp_unit_license":"EMN378","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDUF5GT3DEA05212","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:23.000000Z","updated_at":"2025-09-29T09:46:06.000000Z"}]},{"id":9432044,"change_date":"2025-08-17 21:33:00","inspection_id":"85513169","dot_number":"336827","report_state":"ND","report_number":"TR88007409","insp_date":"2025-08-15 00:00:00","insp_start_time":"0907","insp_end_time":"1040","registration_date":null,"region":"CD","ci_status_code":"C","location":"JMSTNE","location_desc":"JAMESTOWN ND","county_code_state":"ND","county_code":"093","insp_level_id":"1","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":"2025-08-17 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2139473","transaction_code":"A","transaction_date":"2025-08-16 00:00:00","upload_date":"2025-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2025-08-17 21:33:00","snet_input_date":"2025-08-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-17 21:33:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-20T10:44:48.000000Z","updated_at":"2025-08-23T10:45:18.000000Z","inspection_violations":[{"id":15349445,"change_date":"2025-08-17 21:33:00","inspection_id":"85513169","insp_violation_id":"268074055","seq_no":"4","part_no":"391","part_no_section":"11B5-LNCDLNVL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"0007465755","created_at":"2025-08-20T10:45:18.000000Z","updated_at":"2025-08-21T10:41:59.000000Z","normalized_code":"39111B5LNCDLNVL"},{"id":15349446,"change_date":"2025-08-17 21:33:00","inspection_id":"85513169","insp_violation_id":"268074056","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"208435422","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-20T10:45:18.000000Z","updated_at":"2025-08-21T10:41:59.000000Z","normalized_code":"39345B2BAIR"},{"id":15349447,"change_date":"2025-08-17 21:33:00","inspection_id":"85513169","insp_violation_id":"268074057","seq_no":"2","part_no":"393","part_no_section":"75B-TFV","insp_viol_unit":"1","insp_unit_id":"208435422","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-20T10:45:18.000000Z","updated_at":"2025-08-21T10:41:59.000000Z","normalized_code":"39375BTFV"},{"id":15349448,"change_date":"2025-08-17 21:33:00","inspection_id":"85513169","insp_violation_id":"268074058","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"208435422","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-20T10:45:18.000000Z","updated_at":"2025-08-21T10:41:59.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":15548717,"change_date":"2025-08-17 21:33:00","inspection_id":"85513169","insp_unit_id":"208435422","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"131","insp_unit_license":"EXEMPT","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC16HW08847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-20T09:45:22.000000Z","updated_at":"2025-08-21T09:45:14.000000Z"}]},{"id":9378229,"change_date":"2025-08-11 21:38:00","inspection_id":"85456597","dot_number":"336827","report_state":"SD","report_number":"5410001726","insp_date":"2025-08-11 00:00:00","insp_start_time":"1109","insp_end_time":"1137","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ELK POINT SD","county_code_state":"SD","county_code":"127","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"57000","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":"2113929","transaction_code":"A","transaction_date":"2025-08-11 00:00:00","upload_date":"2025-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2025-08-11 21:38:00","snet_input_date":"2025-08-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-11 21:38:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-14T10:42:26.000000Z","updated_at":"2025-08-15T10:43:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15452133,"change_date":"2025-08-11 21:38:00","inspection_id":"85456597","insp_unit_id":"208331109","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"OOH826","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYCYXGHGY9087","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:30.000000Z","updated_at":"2025-08-15T09:45:39.000000Z"}]},{"id":9331369,"change_date":"2025-08-05 21:38:00","inspection_id":"85407281","dot_number":"336827","report_state":"ND","report_number":"TR97002431","insp_date":"2025-08-04 00:00:00","insp_start_time":"1537","insp_end_time":"1559","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"LUDDEN ND","county_code_state":"ND","county_code":"021","insp_level_id":"3","service_center":"WE","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":"U","pen_cen_match":"I","final_status_date":"2025-08-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"2087255","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2025-08-05 21:38:00","snet_input_date":"2025-08-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-05 21:38:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-08T10:01:16.000000Z","updated_at":"2025-08-12T10:41:26.000000Z","inspection_violations":[{"id":15144943,"change_date":"2025-08-05 21:38:00","inspection_id":"85407281","insp_violation_id":"267843101","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":"7464113","created_at":"2025-08-08T10:44:44.000000Z","updated_at":"2025-08-09T10:44:07.000000Z","normalized_code":"3922SLLS3"},{"id":15144944,"change_date":"2025-08-05 21:38:00","inspection_id":"85407281","insp_violation_id":"267843102","seq_no":"2","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"746114","created_at":"2025-08-08T10:44:44.000000Z","updated_at":"2025-08-09T10:44:07.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":15368255,"change_date":"2025-08-05 21:38:00","inspection_id":"85407281","insp_unit_id":"208240906","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PSV745","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTMKAAN3AH279686","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-08T09:46:30.000000Z","updated_at":"2025-08-09T09:45:29.000000Z"}]},{"id":9188936,"change_date":"2025-07-18 21:40:00","inspection_id":"85257430","dot_number":"336827","report_state":"IA","report_number":"000P14WSKK","insp_date":"2025-07-17 00:00:00","insp_start_time":"0922","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US 169 NB 170 MM","county_code_state":"IA","county_code":"091","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MUNICIPAL PIPE TOOL COMPANY LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1367881","transaction_code":"A","transaction_date":"2025-07-18 00:00:00","upload_date":"2025-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2025-07-18 21:40:00","snet_input_date":"2025-07-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-07-18 21:40:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:36.000000Z","updated_at":"2025-07-22T10:45:14.000000Z","inspection_violations":[{"id":14843202,"change_date":"2025-07-18 21:40:00","inspection_id":"85257430","insp_violation_id":"267500829","seq_no":"1","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":"2025-07-21T10:46:17.000000Z","updated_at":"2025-07-22T10:46:32.000000Z","normalized_code":"3922SLLS2"},{"id":14843203,"change_date":"2025-07-18 21:40:00","inspection_id":"85257430","insp_violation_id":"267500830","seq_no":"2","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"207952991","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:46:17.000000Z","updated_at":"2025-07-22T10:46:32.000000Z","normalized_code":"3939H"}],"inspection_per_units":[{"id":15101492,"change_date":"2025-07-18 21:40:00","inspection_id":"85257430","insp_unit_id":"207952991","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"131","insp_unit_license":"SME","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC16HW08847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:36.000000Z","updated_at":"2025-07-22T09:45:54.000000Z"}]},{"id":8553576,"change_date":"2025-05-06 21:39:00","inspection_id":"84586800","dot_number":"336827","report_state":"MO","report_number":"W174004172","insp_date":"2025-05-05 00:00:00","insp_start_time":"0948","insp_end_time":"1058","registration_date":null,"region":"CD","ci_status_code":"C","location":"H2S","location_desc":"EAGLEVILLE MO","county_code_state":"MO","county_code":"081","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"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":"2025-05-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","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":"1687448","transaction_code":"A","transaction_date":"2025-05-06 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2025-05-06 21:39:00","snet_input_date":"2025-05-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-06 21:39:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-09T10:25:12.000000Z","updated_at":"2025-05-10T10:49:33.000000Z","inspection_violations":[{"id":13555748,"change_date":"2025-05-06 21:39:00","inspection_id":"84586800","insp_violation_id":"266021030","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"206654550","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T10:49:17.000000Z","updated_at":"2025-05-09T10:54:42.000000Z","normalized_code":"39395A4EEUS"},{"id":13555749,"change_date":"2025-05-06 21:39:00","inspection_id":"84586800","insp_violation_id":"266021031","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206654550","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T10:49:17.000000Z","updated_at":"2025-05-09T10:54:42.000000Z","normalized_code":"39347E"},{"id":13555750,"change_date":"2025-05-06 21:39:00","inspection_id":"84586800","insp_violation_id":"266021032","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"206654550","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T10:49:17.000000Z","updated_at":"2025-05-09T10:54:42.000000Z","normalized_code":"39353BB"},{"id":13555751,"change_date":"2025-05-06 21:39:00","inspection_id":"84586800","insp_violation_id":"266021033","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"206654550","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T10:49:17.000000Z","updated_at":"2025-05-09T10:54:42.000000Z","normalized_code":"3939ALCL"},{"id":13555752,"change_date":"2025-05-06 21:39:00","inspection_id":"84586800","insp_violation_id":"266021034","seq_no":"5","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T10:49:17.000000Z","updated_at":"2025-05-09T10:54:42.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":13911534,"change_date":"2025-05-06 21:39:00","inspection_id":"84586800","insp_unit_id":"206654550","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"133","insp_unit_license":"EAB938","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC67HX98839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:06:16.000000Z","updated_at":"2025-05-10T09:51:07.000000Z"}]},{"id":8259514,"change_date":"2025-04-01 21:39:00","inspection_id":"84276970","dot_number":"336827","report_state":"MO","report_number":"W174004128","insp_date":"2025-03-31 00:00:00","insp_start_time":"1042","insp_end_time":"1140","registration_date":null,"region":"CD","ci_status_code":"C","location":"H2S","location_desc":"EAGLEVILLE MO","county_code_state":"MO","county_code":"081","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"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":"2025-04-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"1537099","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2025-04-01 21:39:00","snet_input_date":"2025-03-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-01 21:39:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-04T10:20:33.000000Z","updated_at":"2025-04-06T10:17:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13366652,"change_date":"2025-04-01 21:39:00","inspection_id":"84276970","insp_unit_id":"206088344","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"203","insp_unit_license":"0JG959","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALHCYCY2HDJE6980","insp_unit_decal":"Y","insp_unit_decal_number":"34992069","created_at":"2025-04-04T10:02:37.000000Z","updated_at":"2025-04-05T09:49:19.000000Z"}]},{"id":7910757,"change_date":"2025-02-19 21:40:00","inspection_id":"83910133","dot_number":"336827","report_state":"IA","report_number":"000P131VS6","insp_date":"2025-02-18 00:00:00","insp_start_time":"1614","insp_end_time":"1635","registration_date":null,"region":"CT","ci_status_code":"C","location":"45","location_desc":"45 - HWY 218 NB MM 29 PILOT GR","county_code_state":"IA","county_code":"111","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MUNICIPAL PIPE TOOL COMPANY LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1350030","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2025-02-19 21:40:00","snet_input_date":"2025-02-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-02-19 21:40:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:23.000000Z","updated_at":"2025-03-17T21:02:23.000000Z","inspection_violations":[{"id":12358109,"change_date":"2025-02-19 21:40:00","inspection_id":"83910133","insp_violation_id":"264592827","seq_no":"1","part_no":"395","part_no_section":"8A-NON-ELD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"8GNA25021816182","created_at":"2025-03-17T22:06:19.000000Z","updated_at":"2025-03-17T22:06:19.000000Z","normalized_code":"3958ANONELD"},{"id":12358110,"change_date":"2025-02-19 21:40:00","inspection_id":"83910133","insp_violation_id":"264592828","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205402533","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:19.000000Z","updated_at":"2025-03-17T22:06:19.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":12769665,"change_date":"2025-02-19 21:40:00","inspection_id":"83910133","insp_unit_id":"205402533","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"133","insp_unit_license":"EAB938","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC67HX98839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:03.000000Z","updated_at":"2025-03-17T23:56:03.000000Z"}]},{"id":7838711,"change_date":"2025-02-11 21:39:00","inspection_id":"83834643","dot_number":"336827","report_state":"MO","report_number":"W102006700","insp_date":"2025-02-10 00:00:00","insp_start_time":"1026","insp_end_time":"1108","registration_date":null,"region":"CS","ci_status_code":"C","location":"A1N","location_desc":"PLATTE CITY MO","county_code_state":"MO","county_code":"165","insp_level_id":"2","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1347356","transaction_code":"A","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2025-02-11 21:39:00","snet_input_date":"2025-02-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-11 21:39:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:49.000000Z","updated_at":"2025-03-17T21:00:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12650898,"change_date":"2025-02-11 21:39:00","inspection_id":"83834643","insp_unit_id":"205262821","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"PAZ916","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDCX7HY25427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:45.000000Z","updated_at":"2025-03-17T23:54:45.000000Z"}]},{"id":7404846,"change_date":"2024-12-12 21:41:00","inspection_id":"83378777","dot_number":"336827","report_state":"IA","report_number":"000P14X5B6","insp_date":"2024-12-10 00:00:00","insp_start_time":"1630","insp_end_time":"1650","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US 65 S MM92","county_code_state":"IA","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MUNICIPAL PIPE TOOL COMPANY LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"1341489","transaction_code":"A","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2024-12-12 21:41:00","snet_input_date":"2024-12-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-12 21:41:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:44.000000Z","updated_at":"2025-03-17T20:50:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11945411,"change_date":"2024-12-12 21:41:00","inspection_id":"83378777","insp_unit_id":"204347383","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"141","insp_unit_license":"PAY188","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC97HY31011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:54.000000Z","updated_at":"2025-03-17T23:46:54.000000Z"}]},{"id":7115224,"change_date":"2024-11-04 21:40:00","inspection_id":"83073188","dot_number":"336827","report_state":"IA","report_number":"000P15JP5V","insp_date":"2024-11-01 00:00:00","insp_start_time":"1027","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"10","location_desc":"10 - I35 NB MM 30 OSCEOLA","county_code_state":"IA","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MUNICIPAL PIPE TOOL COMPANY","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1336106","transaction_code":"A","transaction_date":"2024-11-04 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2024-11-04 21:40:00","snet_input_date":"2024-11-01 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-11-04 21:40:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:18.000000Z","updated_at":"2025-03-17T20:44:18.000000Z","inspection_violations":[{"id":11111296,"change_date":"2024-11-04 21:40:00","inspection_id":"83073188","insp_violation_id":"262712563","seq_no":"1","part_no":"392","part_no_section":"2C","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:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3922C"},{"id":11111297,"change_date":"2024-11-04 21:40:00","inspection_id":"83073188","insp_violation_id":"262712564","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"203723728","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39311"},{"id":11111298,"change_date":"2024-11-04 21:40:00","inspection_id":"83073188","insp_violation_id":"262712565","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"203723728","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":11475826,"change_date":"2024-11-04 21:40:00","inspection_id":"83073188","insp_unit_id":"203723728","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"123","insp_unit_license":"LXN629","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC85HU48321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:54.000000Z","updated_at":"2025-03-17T23:41:54.000000Z"}]},{"id":7048838,"change_date":"2024-11-20 21:41:00","inspection_id":"83002745","dot_number":"336827","report_state":"KS","report_number":"HP92181737","insp_date":"2024-10-24 00:00:00","insp_start_time":"1045","insp_end_time":"1114","registration_date":"2024-11-20 00:00:00","region":"CT","ci_status_code":"C","location":"FR","location_desc":"FRANKLIN COUNTY - 059","county_code_state":"KS","county_code":"059","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19990","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1342694","transaction_code":"C","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2024-10-25 21:41:00","snet_input_date":"2024-10-24 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-10-25 21:41:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:01.000000Z","updated_at":"2025-03-17T20:43:01.000000Z","inspection_violations":[{"id":11001616,"change_date":"2024-11-20 21:41:00","inspection_id":"83002745","insp_violation_id":"262999292","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"203973743","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:59:23.000000Z","updated_at":"2025-03-17T21:59:23.000000Z","normalized_code":"393100BC"},{"id":11001617,"change_date":"2024-11-20 21:41:00","inspection_id":"83002745","insp_violation_id":"262999293","seq_no":"2","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"203973744","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:59:23.000000Z","updated_at":"2025-03-17T21:59:23.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":11368276,"change_date":"2024-11-20 21:41:00","inspection_id":"83002745","insp_unit_id":"203973743","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"192","insp_unit_license":"COM197","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C6UR5HJ9GG373472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:43.000000Z","updated_at":"2025-03-17T23:40:43.000000Z"},{"id":11368277,"change_date":"2024-11-20 21:41:00","inspection_id":"83002745","insp_unit_id":"203973744","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HHTC","insp_unit_company":"192T","insp_unit_license":"T8137","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JWTC2428JN505150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:43.000000Z","updated_at":"2025-03-17T23:40:43.000000Z"}]},{"id":6929085,"change_date":"2024-10-10 21:41:00","inspection_id":"82875373","dot_number":"336827","report_state":"ND","report_number":"MC08001692","insp_date":"2024-10-08 00:00:00","insp_start_time":"1202","insp_end_time":"1231","registration_date":null,"region":"MD","ci_status_code":"C","location":"BOWMAN","location_desc":"BOWMAN ND","county_code_state":"ND","county_code":"011","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MUNICIPAL PIPE TOOL","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-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","viol_total":"4","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":"932315","transaction_code":"A","transaction_date":"2024-10-10 00:00:00","upload_date":"2024-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2024-10-10 21:41:00","snet_input_date":"2024-10-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-10 21:41:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:38.000000Z","updated_at":"2025-03-17T20:40:38.000000Z","inspection_violations":[{"id":10800914,"change_date":"2024-10-10 21:41:00","inspection_id":"82875373","insp_violation_id":"262282433","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203349900","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:20.000000Z","updated_at":"2025-03-17T21:58:20.000000Z","normalized_code":"39347E"},{"id":10800915,"change_date":"2024-10-10 21:41:00","inspection_id":"82875373","insp_violation_id":"262282434","seq_no":"2","part_no":"395","part_no_section":"3(a)(3)(ii)","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:20.000000Z","updated_at":"2025-03-17T21:58:20.000000Z","normalized_code":"3953A3II"},{"id":10800916,"change_date":"2024-10-10 21:41:00","inspection_id":"82875373","insp_violation_id":"262282435","seq_no":"3","part_no":"395","part_no_section":"8(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:20.000000Z","updated_at":"2025-03-17T21:58:20.000000Z","normalized_code":"3958A"},{"id":10800917,"change_date":"2024-10-10 21:41:00","inspection_id":"82875373","insp_violation_id":"262282436","seq_no":"4","part_no":"395","part_no_section":"8(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:20.000000Z","updated_at":"2025-03-17T21:58:20.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":11175097,"change_date":"2024-10-10 21:41:00","inspection_id":"82875373","insp_unit_id":"203349900","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"108","insp_unit_license":"SME4401","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHBGAN74HM64401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:44.000000Z","updated_at":"2025-03-17T23:38:44.000000Z"}]},{"id":6910267,"change_date":"2024-10-08 21:41:00","inspection_id":"82855412","dot_number":"336827","report_state":"SD","report_number":"5430000920","insp_date":"2024-10-07 00:00:00","insp_start_time":"1120","insp_end_time":"1150","registration_date":null,"region":"CD","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"2","service_center":"WE","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":"2024-10-08 21:41: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":"924888","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2024-10-08 21:41:00","snet_input_date":"2024-10-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-08 21:41:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:14.000000Z","updated_at":"2025-03-17T20:40:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11144665,"change_date":"2024-10-08 21:41:00","inspection_id":"82855412","insp_unit_id":"203312352","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"111","insp_unit_license":"HS3893","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJA6AS53LK90302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:24.000000Z","updated_at":"2025-03-17T23:38:24.000000Z"},{"id":11144666,"change_date":"2024-10-08 21:41:00","inspection_id":"82855412","insp_unit_id":"203312353","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"156","insp_unit_license":"HS4093","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UYVS2535YU921604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:24.000000Z","updated_at":"2025-03-17T23:38:24.000000Z"}]},{"id":6711737,"change_date":"2024-09-12 21:42:00","inspection_id":"82644090","dot_number":"336827","report_state":"IA","report_number":"000P14WRWL","insp_date":"2024-09-10 00:00:00","insp_start_time":"1009","insp_end_time":"1040","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":"MUNICIPAL PIPE TOOL COMPANY LLC","shipping_paper_number":null,"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":null,"final_status_date":"2024-09-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"35590","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":"1329135","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":"00336827","upload_search_indicator":"M","census_search_date":"2024-09-12 21:42:00","snet_input_date":"2024-09-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-09-12 21:42:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:06.000000Z","updated_at":"2025-03-17T20:36:06.000000Z","inspection_violations":[{"id":10448099,"change_date":"2024-09-12 21:42:00","inspection_id":"82644090","insp_violation_id":"261766937","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202893409","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"39617C"},{"id":10448100,"change_date":"2024-09-12 21:42:00","inspection_id":"82644090","insp_violation_id":"261766938","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10822386,"change_date":"2024-09-12 21:42:00","inspection_id":"82644090","insp_unit_id":"202893408","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"173","insp_unit_license":"EEG763","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDNF6EC3GDA03970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:03.000000Z","updated_at":"2025-03-17T23:35:03.000000Z"},{"id":10822387,"change_date":"2024-09-12 21:42:00","inspection_id":"82644090","insp_unit_id":"202893409","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HANDH","insp_unit_company":"174","insp_unit_license":"CY5525","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"533TC2425GC252263","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:03.000000Z","updated_at":"2025-03-17T23:35:03.000000Z"}]},{"id":6658127,"change_date":"2024-09-05 21:43:00","inspection_id":"82587103","dot_number":"336827","report_state":"IA","report_number":"000TT6CH0V","insp_date":"2024-09-04 00:00:00","insp_start_time":"1426","insp_end_time":"1450","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MUNICIPAL PIPE TOOL COMPANY LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1328164","transaction_code":"A","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-09-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:54.000000Z","updated_at":"2025-03-17T20:34:54.000000Z","inspection_violations":[{"id":10360440,"change_date":"2024-09-05 21:43:00","inspection_id":"82587103","insp_violation_id":"261638243","seq_no":"1","part_no":"383","part_no_section":"71(h)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"38371H"}],"inspection_per_units":[{"id":10734745,"change_date":"2024-09-05 21:43:00","inspection_id":"82587103","insp_unit_id":"202781535","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"208","insp_unit_license":"OOH826","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYCYXGHGY9087","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:08.000000Z","updated_at":"2025-03-17T23:34:08.000000Z"}]},{"id":6585814,"change_date":"2024-08-28 21:42:00","inspection_id":"82509926","dot_number":"336827","report_state":"IA","report_number":"000P123D7W","insp_date":"2024-08-27 00:00:00","insp_start_time":"1048","insp_end_time":"1105","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HIGHWAY 122 EB","county_code_state":"IA","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MUNICIPAL PIPE TOOL COMPANY LLC","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19990","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1326990","transaction_code":"A","transaction_date":"2024-08-28 00:00:00","upload_date":"2024-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2024-08-28 21:42:00","snet_input_date":"2024-08-27 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-28 21:42:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:38.000000Z","updated_at":"2025-03-17T20:33:38.000000Z","inspection_violations":[{"id":10239080,"change_date":"2024-08-28 21:42:00","inspection_id":"82509926","insp_violation_id":"261464910","seq_no":"1","part_no":"392","part_no_section":"16(b)","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:55:32.000000Z","updated_at":"2025-03-17T21:55:32.000000Z","normalized_code":"39216B"},{"id":10239081,"change_date":"2024-08-28 21:42:00","inspection_id":"82509926","insp_violation_id":"261464911","seq_no":"2","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:32.000000Z","updated_at":"2025-03-17T21:55:32.000000Z","normalized_code":"39111B5"}],"inspection_per_units":[{"id":10617486,"change_date":"2024-08-28 21:42:00","inspection_id":"82509926","insp_unit_id":"202630977","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"170","insp_unit_license":"EAB765","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FT7W2B69GEA27818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"},{"id":10617487,"change_date":"2024-08-28 21:42:00","inspection_id":"82509926","insp_unit_id":"202630978","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HH","insp_unit_company":"2263","insp_unit_license":"CY5525","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"533TC2425GC252263","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"}]},{"id":6440305,"change_date":"2024-08-12 21:42:00","inspection_id":"82354995","dot_number":"336827","report_state":"MO","report_number":"W031005630","insp_date":"2024-08-12 00:00:00","insp_start_time":"1032","insp_end_time":"1108","registration_date":null,"region":"CD","ci_status_code":"C","location":"I-35","location_desc":"EAGLEVILLE MO","county_code_state":"MO","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"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-08-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"738102","transaction_code":"A","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2024-08-12 21:42:00","snet_input_date":"2024-08-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-12 21:42:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:38.000000Z","updated_at":"2025-03-17T20:30:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10380051,"change_date":"2024-08-12 21:42:00","inspection_id":"82354995","insp_unit_id":"202336341","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"131","insp_unit_license":"NOT REQUIRED","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC16HW08847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:36.000000Z","updated_at":"2025-03-17T23:30:36.000000Z"}]},{"id":6453243,"change_date":"2024-08-13 21:42:00","inspection_id":"82368797","dot_number":"336827","report_state":"MO","report_number":"W239007376","insp_date":"2024-08-12 00:00:00","insp_start_time":"1039","insp_end_time":"1107","registration_date":null,"region":"CD","ci_status_code":"C","location":"H2S","location_desc":"EAGLEVILLE MO","county_code_state":"MO","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"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":"U","pen_cen_match":"I","final_status_date":"2024-08-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"742486","transaction_code":"A","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2024-08-13 21:42:00","snet_input_date":"2024-08-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-13 21:42:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:43.000000Z","updated_at":"2025-03-17T20:30:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10401521,"change_date":"2024-08-13 21:42:00","inspection_id":"82368797","insp_unit_id":"202362255","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"154","insp_unit_license":"DAR118","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTMSAAR39H053744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:48.000000Z","updated_at":"2025-03-17T23:30:48.000000Z"}]},{"id":6327891,"change_date":"2024-07-29 21:41:00","inspection_id":"82234677","dot_number":"336827","report_state":"SD","report_number":"5880001517","insp_date":"2024-07-25 00:00:00","insp_start_time":"1007","insp_end_time":"1041","registration_date":null,"region":"CD","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","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-07-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"35590","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":"692411","transaction_code":"A","transaction_date":"2024-07-28 00:00:00","upload_date":"2024-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2024-07-29 21:41:00","snet_input_date":"2024-07-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-29 21:41:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","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":9824840,"change_date":"2024-07-29 21:41:00","inspection_id":"82234677","insp_violation_id":"260879271","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202108402","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"3922"},{"id":9824841,"change_date":"2024-07-29 21:41:00","inspection_id":"82234677","insp_violation_id":"260879272","seq_no":"2","part_no":"393","part_no_section":"207(c)","insp_viol_unit":"2","insp_unit_id":"202108403","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"393207C"},{"id":9824842,"change_date":"2024-07-29 21:41:00","inspection_id":"82234677","insp_violation_id":"260879273","seq_no":"3","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"202108403","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:53:32.000000Z","updated_at":"2025-03-17T21:53:32.000000Z","normalized_code":"39343D"}],"inspection_per_units":[{"id":10196591,"change_date":"2024-07-29 21:41:00","inspection_id":"82234677","insp_unit_id":"202108402","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"173","insp_unit_license":"EEG763","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDNF6EC3GDA03970","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":10196592,"change_date":"2024-07-29 21:41:00","inspection_id":"82234677","insp_unit_id":"202108403","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"H & H TRAI","insp_unit_company":null,"insp_unit_license":"CY5525","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"533TC2425GC252263","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":6176640,"change_date":"2024-07-09 21:43:00","inspection_id":"82072667","dot_number":"336827","report_state":"IA","report_number":"000P143P3X","insp_date":"2024-07-08 00:00:00","insp_start_time":"1120","insp_end_time":"1225","registration_date":null,"region":"CT","ci_status_code":"C","location":"28","location_desc":"28 - I80 WB MM 44 AVOCA","county_code_state":"IA","county_code":"155","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"FOAM","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1320160","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2024-07-09 21:43:00","snet_input_date":"2024-07-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-07-09 21:43:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:03.000000Z","updated_at":"2025-03-17T20:25:03.000000Z","inspection_violations":[{"id":9590962,"change_date":"2024-07-09 21:43:00","inspection_id":"82072667","insp_violation_id":"260541029","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9950293,"change_date":"2024-07-09 21:43:00","inspection_id":"82072667","insp_unit_id":"201797362","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"123","insp_unit_license":"LXN629","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC85HU48321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:08.000000Z","updated_at":"2025-03-17T23:26:08.000000Z"}]},{"id":6172784,"change_date":"2024-07-09 21:42:00","inspection_id":"82068508","dot_number":"336827","report_state":"SD","report_number":"5430000648","insp_date":"2024-07-06 00:00:00","insp_start_time":"1156","insp_end_time":"1227","registration_date":null,"region":"CD","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":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-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"638139","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2024-07-09 21:42:00","snet_input_date":"2024-07-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-09 21:42:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:01.000000Z","updated_at":"2025-03-17T20:25:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9944044,"change_date":"2024-07-09 21:42:00","inspection_id":"82068508","insp_unit_id":"201787472","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"EXEMPT","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTMKAAN3AH279686","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:02.000000Z","updated_at":"2025-03-17T23:26:02.000000Z"}]},{"id":5937716,"change_date":"2024-06-07 21:38:00","inspection_id":"81814787","dot_number":"336827","report_state":"IA","report_number":"000P11H5QX","insp_date":"2024-06-06 00:00:00","insp_start_time":"1044","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"63 AND HUDSON","county_code_state":"IA","county_code":"013","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1316064","transaction_code":"A","transaction_date":"2024-06-07 00:00:00","upload_date":"2024-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2024-06-07 21:38:00","snet_input_date":"2024-06-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-06-07 21:38:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:18.000000Z","updated_at":"2025-03-17T20:20:18.000000Z","inspection_violations":[{"id":9210354,"change_date":"2024-06-07 21:38:00","inspection_id":"81814787","insp_violation_id":"259964222","seq_no":"1","part_no":"392","part_no_section":"16(a)","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:50:32.000000Z","updated_at":"2025-03-17T21:50:32.000000Z","normalized_code":"39216A"},{"id":9210355,"change_date":"2024-06-07 21:38:00","inspection_id":"81814787","insp_violation_id":"259964223","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201284929","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:32.000000Z","updated_at":"2025-03-17T21:50:32.000000Z","normalized_code":"3922"},{"id":9210356,"change_date":"2024-06-07 21:38:00","inspection_id":"81814787","insp_violation_id":"259964224","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201284929","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:32.000000Z","updated_at":"2025-03-17T21:50:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9563847,"change_date":"2024-06-07 21:38:00","inspection_id":"81814787","insp_unit_id":"201284929","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"JQS953","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GBG5C1174F502035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:10.000000Z","updated_at":"2025-03-17T23:22:10.000000Z"}]},{"id":5741456,"change_date":"2024-05-14 21:41:00","inspection_id":"81601812","dot_number":"336827","report_state":"IA","report_number":"000P15V95T","insp_date":"2024-05-13 00:00:00","insp_start_time":"0845","insp_end_time":"0855","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 65 SB","county_code_state":"IA","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1312747","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2024-05-14 21:41:00","snet_input_date":"2024-05-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-05-14 21:41:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:38.000000Z","updated_at":"2025-03-17T20:16:38.000000Z","inspection_violations":[{"id":8887125,"change_date":"2024-05-14 21:41:00","inspection_id":"81601812","insp_violation_id":"259489393","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:01.000000Z","updated_at":"2025-03-17T21:49:01.000000Z","normalized_code":"3922"},{"id":8887126,"change_date":"2024-05-14 21:41:00","inspection_id":"81601812","insp_violation_id":"259489394","seq_no":"2","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6BRA24051308483","created_at":"2025-03-17T21:49:01.000000Z","updated_at":"2025-03-17T21:49:01.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":9247509,"change_date":"2024-05-14 21:41:00","inspection_id":"81601812","insp_unit_id":"200878312","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"169","insp_unit_license":"CY5290","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HSHXSBR17J636217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:03.000000Z","updated_at":"2025-03-17T23:19:03.000000Z"},{"id":9247510,"change_date":"2024-05-14 21:41:00","inspection_id":"81601812","insp_unit_id":"200878313","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"165","insp_unit_license":"DN8658","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UYVS25336U688108","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:03.000000Z","updated_at":"2025-03-17T23:19:03.000000Z"}]},{"id":5018784,"change_date":"2024-02-14 21:42:00","inspection_id":"80813969","dot_number":"336827","report_state":"IA","report_number":"000TT38VP4","insp_date":"2024-02-08 00:00:00","insp_start_time":"1402","insp_end_time":"1445","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"222 MM HWY 20 WB","county_code_state":"IA","county_code":"013","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MUNICIPAL PIPE TOOL COMPANY","shipping_paper_number":"AMES","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-02-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1302419","transaction_code":"C","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2024-02-09 21:41:00","snet_input_date":"2024-02-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-02-09 21:41:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:04.000000Z","updated_at":"2025-03-17T20:02:04.000000Z","inspection_violations":[{"id":7731894,"change_date":"2024-02-14 21:42:00","inspection_id":"80813969","insp_violation_id":"257839221","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199424940","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"3922"},{"id":7731895,"change_date":"2024-02-14 21:42:00","inspection_id":"80813969","insp_violation_id":"257839222","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7VAL24020814381","created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":8077779,"change_date":"2024-02-14 21:42:00","inspection_id":"80813969","insp_unit_id":"199424940","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"169","insp_unit_license":"CY5290","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HSHXSBR17J636217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:12.000000Z","updated_at":"2025-03-17T23:08:12.000000Z"},{"id":8077780,"change_date":"2024-02-14 21:42:00","inspection_id":"80813969","insp_unit_id":"199424941","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"156","insp_unit_license":"HS4093","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UYVS2535YU921604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:12.000000Z","updated_at":"2025-03-17T23:08:12.000000Z"}]},{"id":4815778,"change_date":"2024-01-16 21:45:00","inspection_id":"80591829","dot_number":"336827","report_state":"NE","report_number":"T478000424","insp_date":"2024-01-11 00:00:00","insp_start_time":"0745","insp_end_time":"0804","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 183, 143 FEET EAST O","county_code_state":"NE","county_code":"149","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MUNICIPAL PIPE TOOL COMPANY LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":null,"post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"779670","transaction_code":"C","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2024-01-16 21:45:00","snet_input_date":"2024-01-11 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-01-11 21:46:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"PO BOX 398","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"506430398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:04.000000Z","updated_at":"2025-03-17T19:58:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7748100,"change_date":"2024-01-16 21:45:00","inspection_id":"80591829","insp_unit_id":"198972541","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NOJ846","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC97HY31011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:14.000000Z","updated_at":"2025-03-17T23:05:14.000000Z"}]},{"id":2625443,"change_date":"2023-03-21 21:41:00","inspection_id":"78145530","dot_number":"336827","report_state":"MO","report_number":"W112006252","insp_date":"2023-03-20 00:00:00","insp_start_time":"1000","insp_end_time":"1039","registration_date":null,"region":"CT","ci_status_code":"C","location":"F70","location_desc":"I 70 @ 89 EXIT","county_code_state":"MO","county_code":"053","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"41920","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":"2064417","transaction_code":"A","transaction_date":"2023-03-21 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2023-03-21 21:41:00","snet_input_date":"2023-03-21 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-03-21 21:41:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"PO BOX 398","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:09.000000Z","updated_at":"2025-03-17T19:15:09.000000Z","inspection_violations":[{"id":4036426,"change_date":"2023-03-21 21:41:00","inspection_id":"78145530","insp_violation_id":"251781869","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"193982108","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":4226274,"change_date":"2023-03-21 21:41:00","inspection_id":"78145530","insp_unit_id":"193982107","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"113","insp_unit_license":"BJP312","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTMNAAM74H607937","insp_unit_decal":"Y","insp_unit_decal_number":"32378007","created_at":"2025-03-17T22:36:19.000000Z","updated_at":"2025-03-17T22:36:19.000000Z"},{"id":4226275,"change_date":"2023-03-21 21:41:00","inspection_id":"78145530","insp_unit_id":"193982108","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"FB0064","insp_unit_license":"FLA2336","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"4KNUT162XEL160620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:19.000000Z","updated_at":"2025-03-17T22:36:19.000000Z"}]},{"id":2396232,"change_date":"2023-02-17 21:39:00","inspection_id":"77884714","dot_number":"336827","report_state":"IA","report_number":"000TT8D9C3","insp_date":"2023-02-15 00:00:00","insp_start_time":"0858","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":"45","location_desc":"45 - HWY 218 NB MM 29 PILOT GR","county_code_state":"IA","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"OWN","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-02-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"1262996","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":"00336827","upload_search_indicator":"M","census_search_date":"2023-02-17 21:39:00","snet_input_date":"2023-02-15 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-02-17 21:39:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:45.000000Z","updated_at":"2025-03-17T19:10:45.000000Z","inspection_violations":[{"id":3689633,"change_date":"2023-02-17 21:39:00","inspection_id":"77884714","insp_violation_id":"251202772","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":"T12623021509025","created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":3855919,"change_date":"2023-02-17 21:39:00","inspection_id":"77884714","insp_unit_id":"193458129","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"145","insp_unit_license":"KBB311","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVACWDDX7HY00493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:37.000000Z","updated_at":"2025-03-17T22:33:37.000000Z"}]},{"id":2369376,"change_date":"2023-03-20 21:41:00","inspection_id":"77853953","dot_number":"336827","report_state":"KS","report_number":"HP04001536","insp_date":"2023-02-13 00:00:00","insp_start_time":"1030","insp_end_time":"1125","registration_date":null,"region":"CT","ci_status_code":"C","location":"RP","location_desc":"REPUBLIC COUNTY - 157 PORT","county_code_state":"KS","county_code":"157","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MUNICIPAL PIPE AND TOOL","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1279121","transaction_code":"C","transaction_date":"2023-03-20 00:00:00","upload_date":"2023-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2023-02-14 21:41:00","snet_input_date":"2023-02-13 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:20.000000Z","updated_at":"2025-03-17T19:10:20.000000Z","inspection_violations":[{"id":3648305,"change_date":"2023-03-20 21:41:00","inspection_id":"77853953","insp_violation_id":"251755314","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193956593","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3812687,"change_date":"2023-03-20 21:41:00","inspection_id":"77853953","insp_unit_id":"193956593","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"131","insp_unit_license":null,"insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC164W08847","insp_unit_decal":"Y","insp_unit_decal_number":"32383399","created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"}]},{"id":2316021,"change_date":"2023-02-07 21:40:00","inspection_id":"77792871","dot_number":"336827","report_state":"IA","report_number":"000TT8D9B7","insp_date":"2023-02-06 00:00:00","insp_start_time":"0703","insp_end_time":"0718","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218","county_code_state":"IA","county_code":"087","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MUNICIPAL PIPE TOOL CO LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"1261613","transaction_code":"A","transaction_date":"2023-02-07 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2023-02-07 21:40:00","snet_input_date":"2023-02-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-02-07 21:40:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:17.000000Z","updated_at":"2025-03-17T19:09:17.000000Z","inspection_violations":[{"id":3567148,"change_date":"2023-02-07 21:40:00","inspection_id":"77792871","insp_violation_id":"250994263","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":"T12623020607110","created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":3727576,"change_date":"2023-02-07 21:40:00","inspection_id":"77792871","insp_unit_id":"193273100","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"LUA698","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC97HY31011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:42.000000Z","updated_at":"2025-03-17T22:32:42.000000Z"}]},{"id":2273932,"change_date":"2023-02-01 21:41:00","inspection_id":"77745231","dot_number":"336827","report_state":"MO","report_number":"W095001017","insp_date":"2023-01-29 00:00:00","insp_start_time":"2125","insp_end_time":"2209","registration_date":null,"region":"CT","ci_status_code":"C","location":"A4S","location_desc":"HARRISONVILLE, SOUTH","county_code_state":"MO","county_code":"037","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2023-02-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2056238","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2023-02-01 21:41:00","snet_input_date":"2023-02-01 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-02-01 21:41:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"PO BOX 398","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:31.000000Z","updated_at":"2025-03-17T19:08:31.000000Z","inspection_violations":[{"id":3507987,"change_date":"2023-02-01 21:41:00","inspection_id":"77745231","insp_violation_id":"250890809","seq_no":"1","part_no":"383","part_no_section":"71(h)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:34.000000Z","updated_at":"2025-03-17T21:23:34.000000Z","normalized_code":"38371H"}],"inspection_per_units":[{"id":3660666,"change_date":"2023-02-01 21:41:00","inspection_id":"77745231","insp_unit_id":"193173871","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"62","insp_unit_license":"43533Z","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"3ALXFB004GDHF0627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:15.000000Z","updated_at":"2025-03-17T22:32:15.000000Z"}]},{"id":1314623,"change_date":"2022-09-19 21:39:00","inspection_id":"76643774","dot_number":"336827","report_state":"IA","report_number":"000P123C6V","insp_date":"2022-09-18 00:00:00","insp_start_time":"0738","insp_end_time":"0758","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HIGHWAY 20 WB","county_code_state":"IA","county_code":"187","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MUNICIPAL PIPE TOOL COMPANY","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1242683","transaction_code":"A","transaction_date":"2022-09-19 00:00:00","upload_date":"2022-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2022-09-19 21:39:00","snet_input_date":"2022-09-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-09-19 21:39:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:52.000000Z","updated_at":"2025-03-17T18:50:52.000000Z","inspection_violations":[{"id":2080096,"change_date":"2022-09-19 21:39:00","inspection_id":"76643774","insp_violation_id":"248498803","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:16:33.000000Z","updated_at":"2025-03-17T21:16:33.000000Z","normalized_code":"3922"},{"id":2080097,"change_date":"2022-09-19 21:39:00","inspection_id":"76643774","insp_violation_id":"248498804","seq_no":"2","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:33.000000Z","updated_at":"2025-03-17T21:16:33.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":2116436,"change_date":"2022-09-19 21:39:00","inspection_id":"76643774","insp_unit_id":"190971705","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"154","insp_unit_license":"DAR118","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTMSAAR39H053744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:31.000000Z","updated_at":"2025-03-17T22:21:31.000000Z"}]},{"id":1219480,"change_date":"2022-09-13 21:41:00","inspection_id":"76533331","dot_number":"336827","report_state":"SD","report_number":"002B014186","insp_date":"2022-09-06 00:00:00","insp_start_time":"1155","insp_end_time":"1236","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SIOUX FALLS PORT OF ENTRY","county_code_state":"SD","county_code":"099","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"MPT","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"626294","transaction_code":"C","transaction_date":"2022-09-13 00:00:00","upload_date":"2022-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2022-09-06 21:42:00","snet_input_date":"2022-09-06 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-09-06 21:42:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"PO BOX 398","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:02.000000Z","updated_at":"2025-03-17T18:49:02.000000Z","inspection_violations":[{"id":1931679,"change_date":"2022-09-13 21:41:00","inspection_id":"76533331","insp_violation_id":"248387964","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"B942599","created_at":"2025-03-17T21:15:54.000000Z","updated_at":"2025-03-17T21:15:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1962251,"change_date":"2022-09-13 21:41:00","inspection_id":"76533331","insp_unit_id":"190876666","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"117","insp_unit_license":"IS1353","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJA6AS54LM31354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:29.000000Z","updated_at":"2025-03-17T22:20:29.000000Z"},{"id":1962252,"change_date":"2022-09-13 21:41:00","inspection_id":"76533331","insp_unit_id":"190876667","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"165","insp_unit_license":"DN8658","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UYVS25336U688108","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:29.000000Z","updated_at":"2025-03-17T22:20:29.000000Z"}]},{"id":1170477,"change_date":"2022-08-30 21:40:00","inspection_id":"76476411","dot_number":"336827","report_state":"MO","report_number":"W012004775","insp_date":"2022-08-29 00:00:00","insp_start_time":"0938","insp_end_time":"1013","registration_date":null,"region":"CT","ci_status_code":"C","location":"H2S","location_desc":"I-35 EAGLEVILLE","county_code_state":"MO","county_code":"081","insp_level_id":"2","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":"2022-08-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2029486","transaction_code":"A","transaction_date":"2022-08-30 00:00:00","upload_date":"2022-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2022-08-30 21:40:00","snet_input_date":"2022-08-30 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-08-30 21:40:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"PO BOX 398","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:18.000000Z","updated_at":"2025-03-17T18:48:18.000000Z","inspection_violations":[{"id":1855352,"change_date":"2022-08-30 21:40:00","inspection_id":"76476411","insp_violation_id":"248095369","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:34.000000Z","updated_at":"2025-03-17T21:15:34.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":1882273,"change_date":"2022-08-30 21:40:00","inspection_id":"76476411","insp_unit_id":"190623352","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"133","insp_unit_license":"EAB938","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC67HX98839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:57.000000Z","updated_at":"2025-03-17T22:19:57.000000Z"}]},{"id":1146195,"change_date":"2022-08-26 21:40:00","inspection_id":"76448304","dot_number":"336827","report_state":"IA","report_number":"000TT6GX5T","insp_date":"2022-08-25 00:00:00","insp_start_time":"1245","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":"10","location_desc":"10 - I35 NB MM 30 OSCEOLA","county_code_state":"IA","county_code":"039","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":"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":null,"final_status_date":"2022-08-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1239239","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2022-08-26 21:40:00","snet_input_date":"2022-08-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-08-26 21:40:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:54.000000Z","updated_at":"2025-03-17T18:47:54.000000Z","inspection_violations":[{"id":1814229,"change_date":"2022-08-26 21:40:00","inspection_id":"76448304","insp_violation_id":"248027823","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190566788","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"39345B2"},{"id":1814230,"change_date":"2022-08-26 21:40:00","inspection_id":"76448304","insp_violation_id":"248027824","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190566788","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"3965B"},{"id":1814231,"change_date":"2022-08-26 21:40:00","inspection_id":"76448304","insp_violation_id":"248027825","seq_no":"3","part_no":"395","part_no_section":"8(f)(11)","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:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"3958F11"}],"inspection_per_units":[{"id":1842433,"change_date":"2022-08-26 21:40:00","inspection_id":"76448304","insp_unit_id":"190566788","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"81","insp_unit_license":"JUH250","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTHCAHR61H393222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:42.000000Z","updated_at":"2025-03-17T22:19:42.000000Z"}]},{"id":1096614,"change_date":"2022-08-22 21:42:00","inspection_id":"76390643","dot_number":"336827","report_state":"IA","report_number":"000TT6WZK4","insp_date":"2022-08-18 00:00:00","insp_start_time":"1654","insp_end_time":"1830","registration_date":null,"region":"CT","ci_status_code":"C","location":"14","location_desc":"14 - I29 NB MM 12 PERCIVAL","county_code_state":"IA","county_code":"071","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MUNICIPAL PIPE TOOL COMPANY LLC","shipping_paper_number":"MOTS","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":null,"final_status_date":"2022-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"23160","viol_total":"4","oos_total":"4","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1238442","transaction_code":"A","transaction_date":"2022-08-19 00:00:00","upload_date":"2022-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2022-08-22 21:42:00","snet_input_date":"2022-08-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-08-22 21:42:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:56.000000Z","updated_at":"2025-03-17T18:46:56.000000Z","inspection_violations":[{"id":1726610,"change_date":"2022-08-22 21:42:00","inspection_id":"76390643","insp_violation_id":"247879142","seq_no":"1","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"190451468","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"39341"},{"id":1726611,"change_date":"2022-08-22 21:42:00","inspection_id":"76390643","insp_violation_id":"247879143","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"190451469","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"39343"},{"id":1726612,"change_date":"2022-08-22 21:42:00","inspection_id":"76390643","insp_violation_id":"247879144","seq_no":"3","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"190451469","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"T30722081818222","created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"393207A"},{"id":1726613,"change_date":"2022-08-22 21:42:00","inspection_id":"76390643","insp_violation_id":"247879145","seq_no":"4","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":1763576,"change_date":"2022-08-22 21:42:00","inspection_id":"76390643","insp_unit_id":"190451468","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NONE","insp_unit_license":"EMN378","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDUF5GT3DEA05212","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:07.000000Z","updated_at":"2025-03-17T22:19:07.000000Z"},{"id":1763577,"change_date":"2022-08-22 21:42:00","inspection_id":"76390643","insp_unit_id":"190451469","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BOBCAT","insp_unit_company":"NONE","insp_unit_license":"ET8136","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"199402BCT1270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:07.000000Z","updated_at":"2025-03-17T22:19:07.000000Z"}]},{"id":1078797,"change_date":"2022-08-18 21:40:00","inspection_id":"76369689","dot_number":"336827","report_state":"MO","report_number":"W031004778","insp_date":"2022-08-15 00:00:00","insp_start_time":"0756","insp_end_time":"0824","registration_date":null,"region":"CT","ci_status_code":"C","location":"H2S","location_desc":"I-35 EAGLEVILLE","county_code_state":"MO","county_code":"081","insp_level_id":"2","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":"2022-08-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"2026849","transaction_code":"A","transaction_date":"2022-08-15 00:00:00","upload_date":"2022-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2022-08-18 21:40:00","snet_input_date":"2022-08-18 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-08-18 21:40:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"PO BOX 398","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:35.000000Z","updated_at":"2025-03-17T18:46:35.000000Z","inspection_violations":[{"id":1700589,"change_date":"2022-08-18 21:40:00","inspection_id":"76369689","insp_violation_id":"247832275","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190408506","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:57.000000Z","updated_at":"2025-03-17T21:14:57.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1735043,"change_date":"2022-08-18 21:40:00","inspection_id":"76369689","insp_unit_id":"190408506","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"EAB938","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC67HX98839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:57.000000Z","updated_at":"2025-03-17T22:18:57.000000Z"}]},{"id":997024,"change_date":"2022-08-09 21:41:00","inspection_id":"76274036","dot_number":"336827","report_state":"KS","report_number":"PD83560316","insp_date":"2022-08-08 00:00:00","insp_start_time":"1020","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":"JO","location_desc":"JOHNSON COUNTY - 091","county_code_state":"KS","county_code":"091","insp_level_id":"1","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":"Y","pen_cen_match":null,"final_status_date":"2022-08-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26500","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":"1259087","transaction_code":"A","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2022-08-09 21:41:00","snet_input_date":"2022-08-08 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-08-09 21:41:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643","insp_colonia":null,"docket_number":"0","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":[{"id":1570939,"change_date":"2022-08-09 21:41:00","inspection_id":"76274036","insp_violation_id":"247603091","seq_no":"1","part_no":"395","part_no_section":"8(k)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:23.000000Z","updated_at":"2025-03-17T21:14:23.000000Z","normalized_code":"3958K2"}],"inspection_per_units":[{"id":1604394,"change_date":"2022-08-09 21:41:00","inspection_id":"76274036","insp_unit_id":"190213017","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"173","insp_unit_license":"EEG763","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDNF6EC3GDA03970","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":943647,"change_date":"2022-08-05 21:40:00","inspection_id":"76211833","dot_number":"336827","report_state":"MO","report_number":"W031004766","insp_date":"2022-08-01 00:00:00","insp_start_time":"2035","insp_end_time":"2105","registration_date":null,"region":"CT","ci_status_code":"C","location":"H2S","location_desc":"I-35 EAGLEVILLE","county_code_state":"MO","county_code":"081","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","viol_total":"4","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2024382","transaction_code":"C","transaction_date":"2022-08-05 00:00:00","upload_date":"2022-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2022-08-02 21:40:00","snet_input_date":"2022-08-02 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-08-02 21:40:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"PO BOX 398","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:22.000000Z","updated_at":"2025-03-17T18:44:22.000000Z","inspection_violations":[{"id":1487984,"change_date":"2022-08-05 21:40:00","inspection_id":"76211833","insp_violation_id":"247545469","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190159518","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3922"},{"id":1487985,"change_date":"2022-08-05 21:40:00","inspection_id":"76211833","insp_violation_id":"247545470","seq_no":"2","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:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3958F1"},{"id":1487986,"change_date":"2022-08-05 21:40:00","inspection_id":"76211833","insp_violation_id":"247545471","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"190159519","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"39375A3"},{"id":1487987,"change_date":"2022-08-05 21:40:00","inspection_id":"76211833","insp_violation_id":"247545472","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"190159519","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":1519309,"change_date":"2022-08-05 21:40:00","inspection_id":"76211833","insp_unit_id":"190159518","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"EEG763","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDNF6EC3GDA03970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:33.000000Z","updated_at":"2025-03-17T22:17:33.000000Z"},{"id":1519310,"change_date":"2022-08-05 21:40:00","inspection_id":"76211833","insp_unit_id":"190159519","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"20","insp_unit_license":"ET8136","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"199402BCT1270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:33.000000Z","updated_at":"2025-03-17T22:17:33.000000Z"}]},{"id":883186,"change_date":"2022-07-25 21:39:00","inspection_id":"76140701","dot_number":"336827","report_state":"IA","report_number":"000TT6MV40","insp_date":"2022-07-25 00:00:00","insp_start_time":"0725","insp_end_time":"0752","registration_date":null,"region":"CT","ci_status_code":"C","location":"16","location_desc":"16 - I380 SB MM 53 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MUNICIPAL PIPE TOOL","shipping_paper_number":"SEWERLINER","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1234730","transaction_code":"A","transaction_date":"2022-07-25 00:00:00","upload_date":"2022-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2022-07-25 21:39:00","snet_input_date":"2022-07-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-07-25 21:39:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:21.000000Z","updated_at":"2025-03-17T18:43:21.000000Z","inspection_violations":[{"id":1389435,"change_date":"2022-07-25 21:39:00","inspection_id":"76140701","insp_violation_id":"247279685","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189939952","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"T23722072507443","created_at":"2025-03-17T21:13:33.000000Z","updated_at":"2025-03-17T21:13:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1421642,"change_date":"2022-07-25 21:39:00","inspection_id":"76140701","insp_unit_id":"189939952","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"117","insp_unit_license":"IS1353","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJA6AS54LM31354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:56.000000Z","updated_at":"2025-03-17T22:16:56.000000Z"},{"id":1421643,"change_date":"2022-07-25 21:39:00","inspection_id":"76140701","insp_unit_id":"189939953","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"153","insp_unit_license":"HS4093","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UYVS2535YU921604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:56.000000Z","updated_at":"2025-03-17T22:16:56.000000Z"}]},{"id":185214,"change_date":"2022-04-15 21:37:00","inspection_id":"75313902","dot_number":"336827","report_state":"IA","report_number":"000TT85DXN","insp_date":"2022-04-14 00:00:00","insp_start_time":"1100","insp_end_time":"1145","registration_date":null,"region":"CT","ci_status_code":"C","location":"10","location_desc":"10 - I35 NB MM 30 OSCEOLA","county_code_state":"IA","county_code":"039","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MUNICIPAL PIPE AND TOOL COMPANY LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-15 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1220213","transaction_code":"A","transaction_date":"2022-04-15 00:00:00","upload_date":"2022-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2022-04-15 21:37:00","snet_input_date":"2022-04-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-04-15 21:37:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"515 5TH STREET","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:50.000000Z","updated_at":"2025-03-17T18:30:50.000000Z","inspection_violations":[{"id":282102,"change_date":"2022-04-15 21:37:00","inspection_id":"75313902","insp_violation_id":"245185024","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"T10322041411324","created_at":"2025-03-17T21:08:22.000000Z","updated_at":"2025-03-17T21:08:22.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":299905,"change_date":"2022-04-15 21:37:00","inspection_id":"75313902","insp_unit_id":"188176243","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"154","insp_unit_license":"DAR118","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTMSAAR39H053744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:59.000000Z","updated_at":"2025-03-17T22:09:59.000000Z"}]},{"id":128928,"change_date":"2022-04-07 21:39:00","inspection_id":"75246571","dot_number":"336827","report_state":"MO","report_number":"W012004616","insp_date":"2022-04-06 00:00:00","insp_start_time":"1249","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":"H2S","location_desc":"I-35 EAGLEVILLE","county_code_state":"MO","county_code":"081","insp_level_id":"2","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":"2022-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2004862","transaction_code":"A","transaction_date":"2022-04-06 00:00:00","upload_date":"2022-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":null,"census_search_date":"2022-04-07 21:39:00","snet_input_date":"2022-04-07 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-04-07 21:39:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"PO BOX 398","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:49.000000Z","updated_at":"2025-03-17T18:29:49.000000Z","inspection_violations":[{"id":190715,"change_date":"2022-04-07 21:39:00","inspection_id":"75246571","insp_violation_id":"245026358","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188040805","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"3922"},{"id":190716,"change_date":"2022-04-07 21:39:00","inspection_id":"75246571","insp_violation_id":"245026359","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188040805","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":208886,"change_date":"2022-04-07 21:39:00","inspection_id":"75246571","insp_unit_id":"188040805","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"111","insp_unit_license":"HS3893","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJA6AS53LK90302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:28.000000Z","updated_at":"2025-03-17T22:09:28.000000Z"},{"id":208887,"change_date":"2022-04-07 21:39:00","inspection_id":"75246571","insp_unit_id":"188040806","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"158","insp_unit_license":"CA2755","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1UYVS25383U885402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:28.000000Z","updated_at":"2025-03-17T22:09:28.000000Z"}]},{"id":93737,"change_date":"2022-04-02 21:30:00","inspection_id":"75202669","dot_number":"336827","report_state":"MO","report_number":"A4S4005738","insp_date":"2022-03-31 00:00:00","insp_start_time":"1310","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":"A4S","location_desc":"HARRISONVILLE, SOUTH","county_code_state":"MO","county_code":"037","insp_level_id":"2","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":"2022-04-02 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"2003912","transaction_code":"A","transaction_date":"2022-04-02 00:00:00","upload_date":"2022-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00336827","upload_search_indicator":"M","census_search_date":"2022-04-02 21:30:00","snet_input_date":"2022-04-02 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-04-02 21:30:00","insp_carrier_name":"MUNICIPAL PIPE TOOL COMPANY LLC","insp_carrier_street":"PO BOX 398","insp_carrier_city":"HUDSON","insp_carrier_state":"IA","insp_carrier_zip_code":"50643-0398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:10.000000Z","updated_at":"2025-03-17T18:29:10.000000Z","inspection_violations":[{"id":138701,"change_date":"2022-04-02 21:30:00","inspection_id":"75202669","insp_violation_id":"244924023","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"187951247","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:42.000000Z","updated_at":"2025-03-17T21:07:42.000000Z","normalized_code":"3922"},{"id":138702,"change_date":"2022-04-02 21:30:00","inspection_id":"75202669","insp_violation_id":"244924024","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"187951247","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:42.000000Z","updated_at":"2025-03-17T21:07:42.000000Z","normalized_code":"3922"},{"id":138703,"change_date":"2022-04-02 21:30:00","inspection_id":"75202669","insp_violation_id":"244924025","seq_no":"3","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:07:42.000000Z","updated_at":"2025-03-17T21:07:42.000000Z","normalized_code":"3958F1"},{"id":138704,"change_date":"2022-04-02 21:30:00","inspection_id":"75202669","insp_violation_id":"244924026","seq_no":"4","part_no":"177","part_no_section":"817(a)","insp_viol_unit":"1","insp_unit_id":"187951247","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:42.000000Z","updated_at":"2025-03-17T21:07:42.000000Z","normalized_code":"177817A"}],"inspection_per_units":[{"id":152101,"change_date":"2022-04-02 21:30:00","inspection_id":"75202669","insp_unit_id":"187951247","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"KUC974","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FVHCYDC97HY31011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:09.000000Z","updated_at":"2025-03-17T22:09:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/336827\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/336827\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/336827\/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\/336827\/inspections","per_page":100,"prev_page_url":null,"to":47,"total":47}