{"current_page":1,"data":[{"id":12732788,"change_date":"2026-08-14 21:41:00","inspection_id":"88702973","dot_number":"347899","report_state":"MI","report_number":"MOREM06643","insp_date":"2026-08-14 00:00:00","insp_start_time":"1437","insp_end_time":"1456","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"037","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":"U","pen_cen_match":"I","final_status_date":"2026-08-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"184000","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":"3987523","transaction_code":"A","transaction_date":"2026-08-14 00:00:00","upload_date":"2026-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2026-08-14 21:41:00","snet_input_date":"2026-08-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-14 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706-5345","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-17T09:40:12.000000Z","updated_at":"2026-08-17T09:40:12.000000Z","inspection_violations":[{"id":22165473,"change_date":"2026-08-14 21:41:00","inspection_id":"88702973","insp_violation_id":"276137427","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":"X4749729","created_at":"2026-08-17T09:58:45.000000Z","updated_at":"2026-08-17T09:58:45.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":22101983,"change_date":"2026-08-14 21:41:00","inspection_id":"88702973","insp_unit_id":"215161336","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"120","insp_unit_license":"BB42151","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X6GD360235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-17T09:16:25.000000Z","updated_at":"2026-08-17T09:16:25.000000Z"},{"id":22101984,"change_date":"2026-08-14 21:41:00","inspection_id":"88702973","insp_unit_id":"215161337","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"118","insp_unit_license":"E221293","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z889MR073911","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-17T09:16:25.000000Z","updated_at":"2026-08-17T09:16:25.000000Z"}]},{"id":12557554,"change_date":"2026-07-27 21:39:00","inspection_id":"88524908","dot_number":"347899","report_state":"MI","report_number":"KALIE00547","insp_date":"2026-07-27 00:00:00","insp_start_time":"1050","insp_end_time":"1135","registration_date":null,"region":"ED","ci_status_code":"C","location":"122","location_desc":"MI","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"3843910","transaction_code":"A","transaction_date":"2026-07-27 00:00:00","upload_date":"2026-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2026-07-27 21:39:00","snet_input_date":"2026-07-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-27 21:39:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706-5345","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-30T09:40:00.000000Z","updated_at":"2026-08-07T09:30:40.000000Z","inspection_violations":[{"id":21862674,"change_date":"2026-07-27 21:39:00","inspection_id":"88524908","insp_violation_id":"275751775","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"214833987","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-30T09:58:39.000000Z","updated_at":"2026-08-07T09:41:08.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":21805027,"change_date":"2026-07-27 21:39:00","inspection_id":"88524908","insp_unit_id":"214833987","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"136","insp_unit_license":"BD73873","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X6SD723755","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-30T09:17:22.000000Z","updated_at":"2026-08-07T09:01:57.000000Z"},{"id":21805028,"change_date":"2026-07-27 21:39:00","inspection_id":"88524908","insp_unit_id":"214833988","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"123T","insp_unit_license":"E672647","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z887PR081297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-30T09:17:22.000000Z","updated_at":"2026-08-07T09:01:57.000000Z"}]},{"id":12400414,"change_date":"2026-07-09 21:42:00","inspection_id":"88357435","dot_number":"347899","report_state":"MI","report_number":"BOHNE01834","insp_date":"2026-07-09 00:00:00","insp_start_time":"1216","insp_end_time":"1249","registration_date":null,"region":"ED","ci_status_code":"C","location":"212","location_desc":"MI","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"26-0827","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"3718150","transaction_code":"A","transaction_date":"2026-07-09 00:00:00","upload_date":"2026-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2026-07-09 21:42:00","snet_input_date":"2026-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-09 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706-5345","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-13T09:39:22.000000Z","updated_at":"2026-07-20T09:31:10.000000Z","inspection_violations":[{"id":21577007,"change_date":"2026-07-09 21:42:00","inspection_id":"88357435","insp_violation_id":"275379905","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"214516286","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:55:55.000000Z","updated_at":"2026-07-20T09:45:05.000000Z","normalized_code":"3939ALIL"},{"id":21577008,"change_date":"2026-07-09 21:42:00","inspection_id":"88357435","insp_violation_id":"275379906","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"214516286","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:55:55.000000Z","updated_at":"2026-07-20T09:45:05.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":21542347,"change_date":"2026-07-09 21:42:00","inspection_id":"88357435","insp_unit_id":"214516285","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"135","insp_unit_license":"BD73860","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X4SD723754","insp_unit_decal":"Y","insp_unit_decal_number":"36680458","created_at":"2026-07-13T09:16:45.000000Z","updated_at":"2026-07-20T09:02:38.000000Z"},{"id":21542348,"change_date":"2026-07-09 21:42:00","inspection_id":"88357435","insp_unit_id":"214516286","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"D950797","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z880KR066732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:45.000000Z","updated_at":"2026-07-20T09:02:38.000000Z"}]},{"id":12324448,"change_date":"2026-06-30 21:40:00","inspection_id":"88282561","dot_number":"347899","report_state":"MI","report_number":"GRAHA01363","insp_date":"2026-06-30 00:00:00","insp_start_time":"1104","insp_end_time":"1135","registration_date":null,"region":"ED","ci_status_code":"C","location":"REST","location_desc":"MI","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"3654469","transaction_code":"A","transaction_date":"2026-06-30 00:00:00","upload_date":"2026-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2026-06-30 21:40:00","snet_input_date":"2026-06-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-30 21:40:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706-5345","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-03T09:41:25.000000Z","updated_at":"2026-07-11T09:30:55.000000Z","inspection_violations":[{"id":21450309,"change_date":"2026-06-30 21:40:00","inspection_id":"88282561","insp_violation_id":"275222642","seq_no":"1","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"214371881","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-03T10:02:29.000000Z","updated_at":"2026-07-11T09:41:15.000000Z","normalized_code":"3965BHWSL"}],"inspection_per_units":[{"id":21404697,"change_date":"2026-06-30 21:40:00","inspection_id":"88282561","insp_unit_id":"214371881","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"118","insp_unit_license":"BB42154","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X9GD335426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:18:04.000000Z","updated_at":"2026-07-11T09:02:08.000000Z"},{"id":21404698,"change_date":"2026-06-30 21:40:00","inspection_id":"88282561","insp_unit_id":"214371882","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"110","insp_unit_license":"D950711","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z887KR066730","insp_unit_decal":"Y","insp_unit_decal_number":"36396167","created_at":"2026-07-05T09:18:04.000000Z","updated_at":"2026-07-11T09:02:08.000000Z"}]},{"id":12222942,"change_date":"2026-06-18 21:41:00","inspection_id":"88180793","dot_number":"347899","report_state":"MI","report_number":"DAWDD04590","insp_date":"2026-06-18 00:00:00","insp_start_time":"0903","insp_end_time":"0929","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NORTHERN CONCRETE PIPE INC","shipping_paper_number":"SO261141","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"3571839","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2026-06-18 21:41:00","snet_input_date":"2026-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706-5345","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-21T09:43:38.000000Z","updated_at":"2026-06-29T09:30:59.000000Z","inspection_violations":[{"id":21273987,"change_date":"2026-06-18 21:41:00","inspection_id":"88180793","insp_violation_id":"274994075","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:02.000000Z","updated_at":"2026-06-29T09:42:51.000000Z","normalized_code":"3922SLLEWA2"},{"id":21273988,"change_date":"2026-06-18 21:41:00","inspection_id":"88180793","insp_violation_id":"274994076","seq_no":"2","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"214173360","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:02.000000Z","updated_at":"2026-06-29T09:42:51.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":21227642,"change_date":"2026-06-18 21:41:00","inspection_id":"88180793","insp_unit_id":"214173359","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"128","insp_unit_license":"BC43539","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X3MD733808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:28.000000Z","updated_at":"2026-06-29T09:01:59.000000Z"},{"id":21227643,"change_date":"2026-06-18 21:41:00","inspection_id":"88180793","insp_unit_id":"214173360","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"109","insp_unit_license":"D541991","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z883HR059556","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:28.000000Z","updated_at":"2026-06-29T09:01:59.000000Z"}]},{"id":11057135,"change_date":"2026-02-05 21:39:00","inspection_id":"86967202","dot_number":"347899","report_state":"MI","report_number":"LYDEC04553","insp_date":"2026-02-04 00:00:00","insp_start_time":"1811","insp_end_time":"1834","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1258114","transaction_code":"A","transaction_date":"2026-02-04 00:00:00","upload_date":"2026-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2026-02-05 21:39:00","snet_input_date":"2026-02-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-05 21:39:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-08T10:37:22.000000Z","updated_at":"2026-02-16T10:30:55.000000Z","inspection_violations":[{"id":18504799,"change_date":"2026-02-05 21:39:00","inspection_id":"86967202","insp_violation_id":"271618676","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211463272","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-02-08T10:50:38.000000Z","updated_at":"2026-02-16T10:40:18.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":18852336,"change_date":"2026-02-05 21:39:00","inspection_id":"86967202","insp_unit_id":"211463273","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"62","insp_unit_license":"E610029","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z8869RJ43730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-08T10:14:17.000000Z","updated_at":"2026-02-16T10:04:19.000000Z"},{"id":18852335,"change_date":"2026-02-05 21:39:00","inspection_id":"86967202","insp_unit_id":"211463272","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"133","insp_unit_license":"BD50671","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40XXRD89873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-08T10:14:17.000000Z","updated_at":"2026-02-16T10:04:19.000000Z"}]},{"id":10507598,"change_date":"2026-01-05 21:37:00","inspection_id":"86642684","dot_number":"347899","report_state":"MI","report_number":"FOXMA01742","insp_date":"2025-12-23 00:00:00","insp_start_time":"0700","insp_end_time":"0725","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SARANAC REST AREA","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS 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":null,"final_status_date":"2025-12-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1254511","transaction_code":"C","transaction_date":"2025-12-23 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-12-23 21:38:00","snet_input_date":"2025-12-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-23 21:38:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-26T10:38:36.000000Z","updated_at":"2026-01-16T10:30:16.000000Z","inspection_violations":[{"id":17749983,"change_date":"2026-01-05 21:37:00","inspection_id":"86642684","insp_violation_id":"271015407","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"1","insp_unit_id":"210914538","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-08T10:38:00.000000Z","updated_at":"2026-01-16T10:30:33.000000Z","normalized_code":"3922SLLTL"},{"id":17749984,"change_date":"2026-01-05 21:37:00","inspection_id":"86642684","insp_violation_id":"271015408","seq_no":"2","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"2","insp_unit_id":"210914539","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-08T10:38:00.000000Z","updated_at":"2026-01-16T10:30:33.000000Z","normalized_code":"393104F3C"}],"inspection_per_units":[{"id":17705556,"change_date":"2026-01-05 21:37:00","inspection_id":"86642684","insp_unit_id":"210914538","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BD73859","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X2SD723753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-08T10:05:39.000000Z","updated_at":"2026-01-16T10:00:21.000000Z"},{"id":17705557,"change_date":"2026-01-05 21:37:00","inspection_id":"86642684","insp_unit_id":"210914539","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E182716","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z889FR052737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-08T10:05:39.000000Z","updated_at":"2026-01-16T10:00:21.000000Z"}]},{"id":10297660,"change_date":"2025-12-04 21:38:00","inspection_id":"86423218","dot_number":"347899","report_state":"MI","report_number":"FOXMA01714","insp_date":"2025-11-26 00:00:00","insp_start_time":"0705","insp_end_time":"0735","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-96 AT MM 79","county_code_state":"MI","county_code":"067","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":"N","pen_cen_match":null,"final_status_date":"2025-11-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1251949","transaction_code":"C","transaction_date":"2025-11-26 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-11-26 21:38:00","snet_input_date":"2025-11-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-26 21:38:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-29T10:31:40.000000Z","updated_at":"2025-12-08T10:30:44.000000Z","inspection_violations":[{"id":17323538,"change_date":"2025-12-04 21:38:00","inspection_id":"86423218","insp_violation_id":"270460462","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"210413203","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-12-07T10:32:12.000000Z","updated_at":"2025-12-08T10:31:19.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":17293071,"change_date":"2025-12-04 21:38:00","inspection_id":"86423218","insp_unit_id":"210413202","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BD73859","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X2SD723753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:28.000000Z","updated_at":"2025-12-08T10:00:53.000000Z"},{"id":17293072,"change_date":"2025-12-04 21:38:00","inspection_id":"86423218","insp_unit_id":"210413203","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E182716","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z889FR052737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:28.000000Z","updated_at":"2025-12-08T10:00:53.000000Z"}]},{"id":10056618,"change_date":"2025-10-28 21:40:00","inspection_id":"86169703","dot_number":"347899","report_state":"MI","report_number":"POWED05508","insp_date":"2025-10-27 00:00:00","insp_start_time":"1310","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CONCORDIA CONTRACTING","shipping_paper_number":"9403","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"220480","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":"1247945","transaction_code":"A","transaction_date":"2025-10-27 00:00:00","upload_date":"2025-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-10-28 21:40:00","snet_input_date":"2025-10-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-28 21:40:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:02:03.000000Z","updated_at":"2025-11-01T10:02:03.000000Z","inspection_violations":[{"id":16647687,"change_date":"2025-10-28 21:40:00","inspection_id":"86169703","insp_violation_id":"269567646","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4609620","created_at":"2025-10-31T10:18:06.000000Z","updated_at":"2025-11-01T10:16:45.000000Z","normalized_code":"3922SLLEWA2"},{"id":16647688,"change_date":"2025-10-28 21:40:00","inspection_id":"86169703","insp_violation_id":"269567647","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209698120","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:06.000000Z","updated_at":"2025-11-01T10:16:45.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":16713642,"change_date":"2025-10-28 21:40:00","inspection_id":"86169703","insp_unit_id":"209698120","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"125","insp_unit_license":"BC13458","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X7LD643687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-31T09:47:12.000000Z","updated_at":"2025-11-01T09:46:23.000000Z"},{"id":16713643,"change_date":"2025-10-28 21:40:00","inspection_id":"86169703","insp_unit_id":"209698121","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"56","insp_unit_license":"E182715","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKB050874B067113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-31T09:47:12.000000Z","updated_at":"2025-11-01T09:46:23.000000Z"}]},{"id":9986754,"change_date":"2025-10-20 21:39:00","inspection_id":"86096310","dot_number":"347899","report_state":"MI","report_number":"MALOK00362","insp_date":"2025-10-17 00:00:00","insp_start_time":"0830","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SC","shipping_paper_number":"SO-25-2248","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"0","hazmat_oos_total":"0","snet_sequence_id":"1246679","transaction_code":"A","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-10-20 21:39:00","snet_input_date":"2025-10-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-20 21:39:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-23T10:00:42.000000Z","updated_at":"2025-10-24T10:01:01.000000Z","inspection_violations":[{"id":16500514,"change_date":"2025-10-20 21:39:00","inspection_id":"86096310","insp_violation_id":"269401167","seq_no":"1","part_no":"393","part_no_section":"124C-CCP","insp_viol_unit":"2","insp_unit_id":"209557582","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-10-23T10:15:59.000000Z","updated_at":"2025-10-24T10:16:36.000000Z","normalized_code":"393124CCCP"},{"id":16500515,"change_date":"2025-10-20 21:39:00","inspection_id":"86096310","insp_violation_id":"269401168","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:15:59.000000Z","updated_at":"2025-10-24T10:16:36.000000Z","normalized_code":"3922SLLEWA1"},{"id":16500516,"change_date":"2025-10-20 21:39:00","inspection_id":"86096310","insp_violation_id":"269401169","seq_no":"3","part_no":"393","part_no_section":"104F4-C","insp_viol_unit":"2","insp_unit_id":"209557582","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:15:59.000000Z","updated_at":"2025-10-24T10:16:36.000000Z","normalized_code":"393104F4C"},{"id":16500517,"change_date":"2025-10-20 21:39:00","inspection_id":"86096310","insp_violation_id":"269401170","seq_no":"4","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"209557581","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:15:59.000000Z","updated_at":"2025-10-24T10:16:36.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":16583665,"change_date":"2025-10-20 21:39:00","inspection_id":"86096310","insp_unit_id":"209557581","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD05497","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X8PD871204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:45.000000Z","updated_at":"2025-10-24T09:46:15.000000Z"},{"id":16583666,"change_date":"2025-10-20 21:39:00","inspection_id":"86096310","insp_unit_id":"209557582","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"D118022","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1HZ880FR052738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:45.000000Z","updated_at":"2025-10-24T09:46:15.000000Z"}]},{"id":9838308,"change_date":"2025-10-02 21:42:00","inspection_id":"85939578","dot_number":"347899","report_state":"MI","report_number":"JURKV03227","insp_date":"2025-10-01 00:00:00","insp_start_time":"0850","insp_end_time":"0934","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1244394","transaction_code":"A","transaction_date":"2025-10-01 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-10-02 21:42:00","snet_input_date":"2025-10-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-02 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-05T10:01:55.000000Z","updated_at":"2025-10-05T10:01:55.000000Z","inspection_violations":[{"id":16200023,"change_date":"2025-10-02 21:42:00","inspection_id":"85939578","insp_violation_id":"269058848","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"1","insp_unit_id":"209265155","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4592119","created_at":"2025-10-05T10:17:39.000000Z","updated_at":"2025-10-05T10:17:39.000000Z","normalized_code":"3922SLLED"}],"inspection_per_units":[{"id":16314528,"change_date":"2025-10-02 21:42:00","inspection_id":"85939578","insp_unit_id":"209265155","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"130","insp_unit_license":"BD05498","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40XXPD871205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:59.000000Z","updated_at":"2025-10-05T09:46:59.000000Z"},{"id":16314529,"change_date":"2025-10-02 21:42:00","inspection_id":"85939578","insp_unit_id":"209265156","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"125T","insp_unit_license":"E826661","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z880PR081299","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:59.000000Z","updated_at":"2025-10-05T09:46:59.000000Z"}]},{"id":9707401,"change_date":"2025-09-17 21:40:00","inspection_id":"85802466","dot_number":"347899","report_state":"MI","report_number":"NEWCJ00673","insp_date":"2025-09-17 00:00:00","insp_start_time":"0950","insp_end_time":"1003","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I96 WB @ 79MM","county_code_state":"MI","county_code":"067","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"40901","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-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1241769","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-09-17 21:40:00","snet_input_date":"2025-09-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-17 21:40:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:48.000000Z","updated_at":"2025-09-23T10:01:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16070891,"change_date":"2025-09-17 21:40:00","inspection_id":"85802466","insp_unit_id":"209003390","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"130","insp_unit_license":"BD05498","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40XXPD871205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:50.000000Z","updated_at":"2025-09-21T09:45:33.000000Z"},{"id":16070892,"change_date":"2025-09-17 21:40:00","inspection_id":"85802466","insp_unit_id":"209003391","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E826661","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z880PR081299","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:50.000000Z","updated_at":"2025-09-21T09:45:33.000000Z"}]},{"id":9807775,"change_date":"2025-10-02 21:42:00","inspection_id":"85907623","dot_number":"347899","report_state":"MI","report_number":"JURKV03180","insp_date":"2025-08-26 00:00:00","insp_start_time":"0925","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"224137481802","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1243819","transaction_code":"C","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-09-29 21:39:00","snet_input_date":"2025-08-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-29 21:39:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-02T10:00:23.000000Z","updated_at":"2025-10-05T10:01:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16307597,"change_date":"2025-10-02 21:42:00","inspection_id":"85907623","insp_unit_id":"209264278","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"116","insp_unit_license":"RB23299","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X4ED244836","insp_unit_decal":"Y","insp_unit_decal_number":"35455491","created_at":"2025-10-05T09:46:54.000000Z","updated_at":"2025-10-05T09:46:54.000000Z"},{"id":16307598,"change_date":"2025-10-02 21:42:00","inspection_id":"85907623","insp_unit_id":"209264279","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"114","insp_unit_license":"D950798","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z882KR066733","insp_unit_decal":"Y","insp_unit_decal_number":"35455492","created_at":"2025-10-05T09:46:54.000000Z","updated_at":"2025-10-05T09:46:54.000000Z"}]},{"id":9414793,"change_date":"2025-08-14 21:40:00","inspection_id":"85494983","dot_number":"347899","report_state":"MI","report_number":"BESSJ01295","insp_date":"2025-08-13 00:00:00","insp_start_time":"0735","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB US-23 @ NORTHFIELD REST ARE","county_code_state":"MI","county_code":"161","insp_level_id":"2","service_center":"MW","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1236130","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-08-14 21:40:00","snet_input_date":"2025-08-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-14 21:40:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-17T10:01:22.000000Z","updated_at":"2025-08-20T10:44:10.000000Z","inspection_violations":[{"id":15314414,"change_date":"2025-08-14 21:40:00","inspection_id":"85494983","insp_violation_id":"268032888","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4569779","created_at":"2025-08-17T10:45:24.000000Z","updated_at":"2025-08-18T10:44:13.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":15518844,"change_date":"2025-08-14 21:40:00","inspection_id":"85494983","insp_unit_id":"208402528","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"133","insp_unit_license":"BD50671","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40XXRD89873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:28.000000Z","updated_at":"2025-08-18T09:46:03.000000Z"},{"id":15518845,"change_date":"2025-08-14 21:40:00","inspection_id":"85494983","insp_unit_id":"208402529","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"N\/A","insp_unit_license":"E610029","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z8869RJ43730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:28.000000Z","updated_at":"2025-08-18T09:46:04.000000Z"}]},{"id":9414837,"change_date":"2025-08-14 21:40:00","inspection_id":"85495031","dot_number":"347899","report_state":"MI","report_number":"STREJ01839","insp_date":"2025-08-13 00:00:00","insp_start_time":"0825","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"350P3","location_desc":"I75 S\/B @ CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","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":"2025-08-14 21:40: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":"1236198","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-08-14 21:40:00","snet_input_date":"2025-08-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-14 21:40:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-17T10:01:22.000000Z","updated_at":"2025-08-20T10:44:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15518910,"change_date":"2025-08-14 21:40:00","inspection_id":"85495031","insp_unit_id":"208402611","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"M1","insp_unit_license":"BB26821","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP2HJ7X4JM466568","insp_unit_decal":"Y","insp_unit_decal_number":"35455481","created_at":"2025-08-17T09:46:28.000000Z","updated_at":"2025-08-18T09:46:04.000000Z"}]},{"id":9364435,"change_date":"2025-08-08 21:39:00","inspection_id":"85442164","dot_number":"347899","report_state":"MI","report_number":"MCGEJ03641","insp_date":"2025-08-07 00:00:00","insp_start_time":"1005","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I75 NB @ MM254","county_code_state":"MI","county_code":"039","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"770000","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":"1234636","transaction_code":"A","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-08-08 21:39:00","snet_input_date":"2025-08-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-08 21:39:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:14.000000Z","updated_at":"2025-08-12T10:44:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15428295,"change_date":"2025-08-08 21:39:00","inspection_id":"85442164","insp_unit_id":"208305761","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"135","insp_unit_license":"BD73860","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X4SD723754","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:26.000000Z","updated_at":"2025-08-12T09:45:57.000000Z"},{"id":15428296,"change_date":"2025-08-08 21:39:00","inspection_id":"85442164","insp_unit_id":"208305762","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E221293","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z889MR07391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:26.000000Z","updated_at":"2025-08-12T09:45:57.000000Z"}]},{"id":9364555,"change_date":"2025-08-08 21:39:00","inspection_id":"85442292","dot_number":"347899","report_state":"MI","report_number":"GENTC03113","insp_date":"2025-08-07 00:00:00","insp_start_time":"0909","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-75 @ MM 218","county_code_state":"MI","county_code":"129","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1235179","transaction_code":"A","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-08-08 21:39:00","snet_input_date":"2025-08-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-08 21:39:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:14.000000Z","updated_at":"2025-08-12T10:44:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15428491,"change_date":"2025-08-08 21:39:00","inspection_id":"85442292","insp_unit_id":"208305983","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BB42152","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X7GD335425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:26.000000Z","updated_at":"2025-08-12T09:45:57.000000Z"},{"id":15428492,"change_date":"2025-08-08 21:39:00","inspection_id":"85442292","insp_unit_id":"208305984","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EASU","insp_unit_company":null,"insp_unit_license":"D950710","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z889KR066731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:26.000000Z","updated_at":"2025-08-12T09:45:57.000000Z"}]},{"id":9123723,"change_date":"2025-07-11 21:39:00","inspection_id":"85189084","dot_number":"347899","report_state":"MI","report_number":"SEYFE00097","insp_date":"2025-07-10 00:00:00","insp_start_time":"0835","insp_end_time":"0844","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 @ WIXOM RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1230003","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:04.000000Z","updated_at":"2025-07-16T10:44:45.000000Z","inspection_violations":[{"id":14709188,"change_date":"2025-07-11 21:39:00","inspection_id":"85189084","insp_violation_id":"267347716","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"207821933","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"3939ALRLI"},{"id":14709189,"change_date":"2025-07-11 21:39:00","inspection_id":"85189084","insp_violation_id":"267347717","seq_no":"2","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"207821933","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"3939ALBL"},{"id":14709190,"change_date":"2025-07-11 21:39:00","inspection_id":"85189084","insp_violation_id":"267347718","seq_no":"3","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"207821933","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":14979826,"change_date":"2025-07-11 21:39:00","inspection_id":"85189084","insp_unit_id":"207821933","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"115","insp_unit_license":"BE17901","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X2ED244835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:07.000000Z","updated_at":"2025-07-15T09:45:49.000000Z"},{"id":14979827,"change_date":"2025-07-11 21:39:00","inspection_id":"85189084","insp_unit_id":"207821934","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"55","insp_unit_license":"F281057","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKB050854B067112","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:07.000000Z","updated_at":"2025-07-15T09:45:49.000000Z"}]},{"id":9123786,"change_date":"2025-07-11 21:39:00","inspection_id":"85189149","dot_number":"347899","report_state":"MI","report_number":"REBIM00302","insp_date":"2025-07-09 00:00:00","insp_start_time":"1231","insp_end_time":"1321","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NORTHERN CONCRETE PIPE","shipping_paper_number":"2317766","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-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1230075","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:04.000000Z","updated_at":"2025-07-16T10:44:45.000000Z","inspection_violations":[{"id":14709316,"change_date":"2025-07-11 21:39:00","inspection_id":"85189149","insp_violation_id":"267347854","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"207822052","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"39395A4EEUS"},{"id":14709317,"change_date":"2025-07-11 21:39:00","inspection_id":"85189149","insp_violation_id":"267347855","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"207822052","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"3939ALHLI"},{"id":14709318,"change_date":"2025-07-11 21:39:00","inspection_id":"85189149","insp_violation_id":"267347856","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"207822053","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"3939ALCL"},{"id":14709319,"change_date":"2025-07-11 21:39:00","inspection_id":"85189149","insp_violation_id":"267347857","seq_no":"4","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"207822052","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":14979938,"change_date":"2025-07-11 21:39:00","inspection_id":"85189149","insp_unit_id":"207822052","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"121","insp_unit_license":"BB42153","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X8GD360236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:07.000000Z","updated_at":"2025-07-15T09:45:49.000000Z"},{"id":14979939,"change_date":"2025-07-11 21:39:00","inspection_id":"85189149","insp_unit_id":"207822053","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"109","insp_unit_license":"D541991","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z883HR059556","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:07.000000Z","updated_at":"2025-07-15T09:45:49.000000Z"}]},{"id":9092446,"change_date":"2025-07-09 09:31:00","inspection_id":"85156563","dot_number":"347899","report_state":"MI","report_number":"JURKV03081","insp_date":"2025-07-08 00:00:00","insp_start_time":"1010","insp_end_time":"1043","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BAY CITY REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"125145568202","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-09 09:31:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1229323","transaction_code":"A","transaction_date":"2025-07-08 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-07-09 09:31:00","snet_input_date":"2025-07-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-09 09:31:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-12T10:45:05.000000Z","updated_at":"2025-07-14T10:45:24.000000Z","inspection_violations":[{"id":14647242,"change_date":"2025-07-09 09:31:00","inspection_id":"85156563","insp_violation_id":"267274571","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"207758856","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:48:43.000000Z","updated_at":"2025-07-13T10:48:43.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":14922828,"change_date":"2025-07-09 09:31:00","inspection_id":"85156563","insp_unit_id":"207758856","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"132","insp_unit_license":"BD50636","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X8RD898731","insp_unit_decal":"Y","insp_unit_decal_number":"35455581","created_at":"2025-07-12T09:45:40.000000Z","updated_at":"2025-07-13T09:45:17.000000Z"},{"id":14922829,"change_date":"2025-07-09 09:31:00","inspection_id":"85156563","insp_unit_id":"207758857","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E221292","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z880MR073912","insp_unit_decal":"Y","insp_unit_decal_number":"35455582","created_at":"2025-07-12T09:45:40.000000Z","updated_at":"2025-07-13T09:45:17.000000Z"}]},{"id":9090078,"change_date":"2025-07-08 21:38:00","inspection_id":"85153534","dot_number":"347899","report_state":"MI","report_number":"KAATZ00590","insp_date":"2025-07-07 00:00:00","insp_start_time":"1411","insp_end_time":"1512","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"SWARTZ CREEK REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","pen_cen_match":null,"final_status_date":"2025-07-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1229225","transaction_code":"A","transaction_date":"2025-07-07 00:00:00","upload_date":"2025-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-07-08 21:38:00","snet_input_date":"2025-07-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-08 21:38:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:50.000000Z","updated_at":"2025-07-12T10:44:56.000000Z","inspection_violations":[{"id":14641278,"change_date":"2025-07-08 21:38:00","inspection_id":"85153534","insp_violation_id":"267266506","seq_no":"1","part_no":"393","part_no_section":"48A-BLMCBAD","insp_viol_unit":"2","insp_unit_id":"207753082","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-11T10:47:13.000000Z","updated_at":"2025-07-13T10:48:36.000000Z","normalized_code":"39348ABLMCBAD"},{"id":14641279,"change_date":"2025-07-08 21:38:00","inspection_id":"85153534","insp_violation_id":"267266507","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"207753082","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-11T10:47:13.000000Z","updated_at":"2025-07-13T10:48:36.000000Z","normalized_code":"39345DB"},{"id":14641280,"change_date":"2025-07-08 21:38:00","inspection_id":"85153534","insp_violation_id":"267266508","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"207753082","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-11T10:47:13.000000Z","updated_at":"2025-07-13T10:48:36.000000Z","normalized_code":"39345DB"},{"id":14641281,"change_date":"2025-07-08 21:38:00","inspection_id":"85153534","insp_violation_id":"267266509","seq_no":"4","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"207753082","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-11T10:47:13.000000Z","updated_at":"2025-07-13T10:48:36.000000Z","normalized_code":"39355EB"},{"id":14641282,"change_date":"2025-07-08 21:38:00","inspection_id":"85153534","insp_violation_id":"267266510","seq_no":"5","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"207753081","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-11T10:47:13.000000Z","updated_at":"2025-07-13T10:48:36.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":14918063,"change_date":"2025-07-08 21:38:00","inspection_id":"85153534","insp_unit_id":"207753081","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"BD27621","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X7ED244832","insp_unit_decal":"Y","insp_unit_decal_number":"35455617","created_at":"2025-07-11T09:46:36.000000Z","updated_at":"2025-07-12T09:45:36.000000Z"},{"id":14918064,"change_date":"2025-07-08 21:38:00","inspection_id":"85153534","insp_unit_id":"207753082","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"110","insp_unit_license":"D950711","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z887KR066730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-11T09:46:36.000000Z","updated_at":"2025-07-12T09:45:36.000000Z"}]},{"id":8702284,"change_date":"2025-05-21 21:42:00","inspection_id":"84743250","dot_number":"347899","report_state":"MI","report_number":"WARRJ02776","insp_date":"2025-05-20 00:00:00","insp_start_time":"0950","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WOODBURRY REST AREA(I69 WB)","county_code_state":"MI","county_code":"155","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/A\/C","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":"2025-05-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1222150","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2025-05-21 21:42:00","snet_input_date":"2025-05-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-24T10:04:24.000000Z","updated_at":"2025-05-25T10:06:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14220665,"change_date":"2025-05-21 21:42:00","inspection_id":"84743250","insp_unit_id":"206992365","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"112","insp_unit_license":"BD27623","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X9ED244833","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:50.000000Z","updated_at":"2025-05-25T09:52:10.000000Z"},{"id":14220666,"change_date":"2025-05-21 21:42:00","inspection_id":"84743250","insp_unit_id":"206992366","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"D950798","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z882KR066733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:50.000000Z","updated_at":"2025-05-25T09:52:10.000000Z"}]},{"id":6913083,"change_date":"2024-10-08 21:42:00","inspection_id":"82858414","dot_number":"347899","report_state":"MI","report_number":"BACZM02510","insp_date":"2024-10-07 00:00:00","insp_start_time":"0910","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 SB @ WILSON RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"PER224137778502","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","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":"1197332","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2024-10-08 21:42:00","snet_input_date":"2024-10-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[{"id":10772192,"change_date":"2024-10-08 21:42:00","inspection_id":"82858414","insp_violation_id":"262245152","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"203318888","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:10.000000Z","updated_at":"2025-03-17T21:58:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11149329,"change_date":"2024-10-08 21:42:00","inspection_id":"82858414","insp_unit_id":"203318887","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"89","insp_unit_license":"RB88230","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X07J174867","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:27.000000Z","updated_at":"2025-03-17T23:38:27.000000Z"},{"id":11149330,"change_date":"2024-10-08 21:42:00","inspection_id":"82858414","insp_unit_id":"203318888","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"64","insp_unit_license":"C051375","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKJ04532XB037590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:27.000000Z","updated_at":"2025-03-17T23:38:27.000000Z"}]},{"id":6818400,"change_date":"2024-09-25 21:41:00","inspection_id":"82757915","dot_number":"347899","report_state":"MI","report_number":"EVANT02649","insp_date":"2024-09-24 00:00:00","insp_start_time":"1100","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"B&D TOWING","county_code_state":"MI","county_code":"009","insp_level_id":"4","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":"N","pen_cen_match":null,"final_status_date":"2024-09-25 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"194000","viol_total":"7","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":"1196092","transaction_code":"A","transaction_date":"2024-09-24 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:15.000000Z","updated_at":"2025-03-17T20:38:15.000000Z","inspection_violations":[{"id":10617740,"change_date":"2024-09-25 21:41:00","inspection_id":"82757915","insp_violation_id":"262030866","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"203128221","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"39395A"},{"id":10617741,"change_date":"2024-09-25 21:41:00","inspection_id":"82757915","insp_violation_id":"262030867","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203128222","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"3939A"},{"id":10617742,"change_date":"2024-09-25 21:41:00","inspection_id":"82757915","insp_violation_id":"262030868","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203128222","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"3939A"},{"id":10617743,"change_date":"2024-09-25 21:41:00","inspection_id":"82757915","insp_violation_id":"262030869","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203128222","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"3939A"},{"id":10617744,"change_date":"2024-09-25 21:41:00","inspection_id":"82757915","insp_violation_id":"262030870","seq_no":"5","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"203128222","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"39345D"},{"id":10617745,"change_date":"2024-09-25 21:41:00","inspection_id":"82757915","insp_violation_id":"262030871","seq_no":"6","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"203128222","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"393207F"},{"id":10617746,"change_date":"2024-09-25 21:41:00","inspection_id":"82757915","insp_violation_id":"262030872","seq_no":"7","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203128222","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":10995334,"change_date":"2024-09-25 21:41:00","inspection_id":"82757915","insp_unit_id":"203128221","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"128","insp_unit_license":"BC43539","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X3MD733808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"},{"id":10995335,"change_date":"2024-09-25 21:41:00","inspection_id":"82757915","insp_unit_id":"203128222","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EASU","insp_unit_company":null,"insp_unit_license":"E849363","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z882GR056484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"}]},{"id":6680292,"change_date":"2024-09-17 21:45:00","inspection_id":"82610767","dot_number":"347899","report_state":"MI","report_number":"ELDEH00637","insp_date":"2024-09-06 00:00:00","insp_start_time":"0745","insp_end_time":"0845","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75NB @ LINWOOD RA","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"38216","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"182000","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":"1193830","transaction_code":"C","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2024-09-09 21:40:00","snet_input_date":"2024-09-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:37.000000Z","updated_at":"2025-03-17T20:35:37.000000Z","inspection_violations":[{"id":10396628,"change_date":"2024-09-17 21:45:00","inspection_id":"82610767","insp_violation_id":"261861501","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:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"3922"},{"id":10396629,"change_date":"2024-09-17 21:45:00","inspection_id":"82610767","insp_violation_id":"261861502","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202977405","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10770906,"change_date":"2024-09-17 21:45:00","inspection_id":"82610767","insp_unit_id":"202977405","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"116","insp_unit_license":"RB23299","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X4ED244836","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"},{"id":10770907,"change_date":"2024-09-17 21:45:00","inspection_id":"82610767","insp_unit_id":"202977406","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"114","insp_unit_license":"D950798","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z882KR066733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"}]},{"id":6370056,"change_date":"2024-09-17 21:45:00","inspection_id":"82279772","dot_number":"347899","report_state":"MI","report_number":"DOWEM02819","insp_date":"2024-08-01 00:00:00","insp_start_time":"0720","insp_end_time":"0800","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I75 NB @ MM 268","county_code_state":"MI","county_code":"039","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"40022","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1188604","transaction_code":"C","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2024-08-01 21:41:00","snet_input_date":"2024-08-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-01 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:06.000000Z","updated_at":"2025-03-17T20:29:06.000000Z","inspection_violations":[{"id":9889038,"change_date":"2024-09-17 21:45:00","inspection_id":"82279772","insp_violation_id":"261861173","seq_no":"1","part_no":"393","part_no_section":"124","insp_viol_unit":"2","insp_unit_id":"202977179","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"393124"},{"id":9889039,"change_date":"2024-09-17 21:45:00","inspection_id":"82279772","insp_violation_id":"261861174","seq_no":"2","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"202977179","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"393104F3"},{"id":9889040,"change_date":"2024-09-17 21:45:00","inspection_id":"82279772","insp_violation_id":"261861175","seq_no":"3","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"202977179","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"393104F3"},{"id":9889041,"change_date":"2024-09-17 21:45:00","inspection_id":"82279772","insp_violation_id":"261861176","seq_no":"4","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"202977179","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"393104F3"},{"id":9889042,"change_date":"2024-09-17 21:45:00","inspection_id":"82279772","insp_violation_id":"261861177","seq_no":"5","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"202977179","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"393104F3"},{"id":9889043,"change_date":"2024-09-17 21:45:00","inspection_id":"82279772","insp_violation_id":"261861178","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"202977179","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10265282,"change_date":"2024-09-17 21:45:00","inspection_id":"82279772","insp_unit_id":"202977178","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"131","insp_unit_license":"BD05499","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X1PD871206","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:21.000000Z","updated_at":"2025-03-17T23:29:21.000000Z"},{"id":10265283,"change_date":"2024-09-17 21:45:00","inspection_id":"82279772","insp_unit_id":"202977179","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"101`","insp_unit_license":"E610028","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z882FR052739","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:21.000000Z","updated_at":"2025-03-17T23:29:21.000000Z"}]},{"id":6008183,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","dot_number":"347899","report_state":"MI","report_number":"PENNJ00883","insp_date":"2024-06-17 00:00:00","insp_start_time":"1200","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"REED CITY WASTE WATER TREATMENT","shipping_paper_number":"37449","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","viol_total":"14","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1182927","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2024-06-17 21:44:00","snet_input_date":"2024-06-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-17 21:44:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:51.000000Z","updated_at":"2025-03-17T20:21:51.000000Z","inspection_violations":[{"id":9321190,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128366","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201433305","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"3963A1"},{"id":9321191,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128367","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"201433306","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39345D"},{"id":9321192,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128368","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"201433306","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39347E"},{"id":9321193,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128369","seq_no":"4","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"201433306","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39345D"},{"id":9321194,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128370","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"201433306","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39353B"},{"id":9321195,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128371","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"201433306","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39347E"},{"id":9321196,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128372","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"201433306","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39347E"},{"id":9321197,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128373","seq_no":"8","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201433306","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"3929A"},{"id":9321198,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128374","seq_no":"9","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"201433306","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"393104F3"},{"id":9321199,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128375","seq_no":"10","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"201433306","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"393104F3"},{"id":9321200,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128376","seq_no":"11","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"201433306","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"393104F3"},{"id":9321201,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128377","seq_no":"12","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"201433306","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"393104F3"},{"id":9321202,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128378","seq_no":"13","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"201433306","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"393104F3"},{"id":9321203,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_violation_id":"260128379","seq_no":"14","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201433306","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":9677080,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_unit_id":"201433305","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"122","insp_unit_license":"BB42155","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40XXGD360237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"},{"id":9677081,"change_date":"2024-06-17 21:44:00","inspection_id":"81891357","insp_unit_id":"201433306","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E182716","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z889FR052737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"}]},{"id":5885615,"change_date":"2024-05-31 21:39:00","inspection_id":"81757910","dot_number":"347899","report_state":"MI","report_number":"BRACG01009","insp_date":"2024-05-30 00:00:00","insp_start_time":"0756","insp_end_time":"0818","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"201000","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":"1180528","transaction_code":"A","transaction_date":"2024-05-30 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2024-05-31 21:39:00","snet_input_date":"2024-05-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-31 21:39:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:26.000000Z","updated_at":"2025-03-17T20:19:26.000000Z","inspection_violations":[{"id":9124863,"change_date":"2024-05-31 21:39:00","inspection_id":"81757910","insp_violation_id":"259835184","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:50:07.000000Z","updated_at":"2025-03-17T21:50:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9479457,"change_date":"2024-05-31 21:39:00","inspection_id":"81757910","insp_unit_id":"201175048","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"129","insp_unit_license":"BD05497","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X8PD871204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:19.000000Z","updated_at":"2025-03-17T23:21:19.000000Z"},{"id":9479458,"change_date":"2024-05-31 21:39:00","inspection_id":"81757910","insp_unit_id":"201175049","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EASU","insp_unit_company":"100","insp_unit_license":"E516586","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1HZ880FR052738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:19.000000Z","updated_at":"2025-03-17T23:21:19.000000Z"}]},{"id":5768132,"change_date":"2024-05-16 21:41:00","inspection_id":"81630720","dot_number":"347899","report_state":"MI","report_number":"JURKV02603","insp_date":"2024-05-16 00:00:00","insp_start_time":"0820","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CLIO REST AREA","county_code_state":"MI","county_code":"049","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1178957","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2024-05-16 21:41:00","snet_input_date":"2024-05-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-16 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:05.000000Z","updated_at":"2025-03-17T20:17:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9290625,"change_date":"2024-05-16 21:41:00","inspection_id":"81630720","insp_unit_id":"200932583","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"110","insp_unit_license":"BD27622","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X5ED244831","insp_unit_decal":"Y","insp_unit_decal_number":"33974321","created_at":"2025-03-17T23:19:30.000000Z","updated_at":"2025-03-17T23:19:30.000000Z"},{"id":9290626,"change_date":"2024-05-16 21:41:00","inspection_id":"81630720","insp_unit_id":"200932584","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"D950711","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z887KR066730","insp_unit_decal":"Y","insp_unit_decal_number":"33974322","created_at":"2025-03-17T23:19:30.000000Z","updated_at":"2025-03-17T23:19:30.000000Z"}]},{"id":5767947,"change_date":"2024-05-16 21:41:00","inspection_id":"81630518","dot_number":"347899","report_state":"MI","report_number":"FROSR00800","insp_date":"2024-05-15 00:00:00","insp_start_time":"1215","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 SB @ REST AREA (M84)","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"1178806","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2024-05-16 21:41:00","snet_input_date":"2024-05-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-16 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:05.000000Z","updated_at":"2025-03-17T20:17:05.000000Z","inspection_violations":[{"id":8928629,"change_date":"2024-05-16 21:41:00","inspection_id":"81630518","insp_violation_id":"259549005","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200932221","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"3922"},{"id":8928630,"change_date":"2024-05-16 21:41:00","inspection_id":"81630518","insp_violation_id":"259549006","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200932221","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:12.000000Z","updated_at":"2025-03-17T21:49:12.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":9290311,"change_date":"2024-05-16 21:41:00","inspection_id":"81630518","insp_unit_id":"200932221","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"126","insp_unit_license":"BC13458","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X9LD643688","insp_unit_decal":"Y","insp_unit_decal_number":"33976211","created_at":"2025-03-17T23:19:30.000000Z","updated_at":"2025-03-17T23:19:30.000000Z"}]},{"id":5607891,"change_date":"2024-04-26 21:39:00","inspection_id":"81456547","dot_number":"347899","report_state":"MI","report_number":"WARRJ02530","insp_date":"2024-04-24 00:00:00","insp_start_time":"1525","insp_end_time":"1620","registration_date":null,"region":"ET","ci_status_code":"C","location":"350R2","location_desc":"DODGE RD REST AREA (I-75 NB)","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1175868","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2024-04-26 21:39:00","snet_input_date":"2024-04-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-26 21:39:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:52.000000Z","updated_at":"2025-03-17T20:13:52.000000Z","inspection_violations":[{"id":8670129,"change_date":"2024-04-26 21:39:00","inspection_id":"81456547","insp_violation_id":"259167590","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3922"},{"id":8670130,"change_date":"2024-04-26 21:39:00","inspection_id":"81456547","insp_violation_id":"259167591","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200598653","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3922"},{"id":8670131,"change_date":"2024-04-26 21:39:00","inspection_id":"81456547","insp_violation_id":"259167592","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200598654","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39347E"},{"id":8670132,"change_date":"2024-04-26 21:39:00","inspection_id":"81456547","insp_violation_id":"259167593","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200598654","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":9033159,"change_date":"2024-04-26 21:39:00","inspection_id":"81456547","insp_unit_id":"200598653","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"116","insp_unit_license":"RB23299","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X4ED244836","insp_unit_decal":"Y","insp_unit_decal_number":"33974497","created_at":"2025-03-17T23:17:03.000000Z","updated_at":"2025-03-17T23:17:03.000000Z"},{"id":9033160,"change_date":"2024-04-26 21:39:00","inspection_id":"81456547","insp_unit_id":"200598654","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"B565921","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKB050846M066850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:03.000000Z","updated_at":"2025-03-17T23:17:03.000000Z"}]},{"id":5576233,"change_date":"2024-04-23 21:41:00","inspection_id":"81422062","dot_number":"347899","report_state":"MI","report_number":"BESSJ00525","insp_date":"2024-04-23 00:00:00","insp_start_time":"1315","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-275 @ CANTON REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","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":"N","pen_cen_match":null,"final_status_date":"2024-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1175255","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2024-04-23 21:41:00","snet_input_date":"2024-04-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-23 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:10.000000Z","updated_at":"2025-03-17T20:13:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8982326,"change_date":"2024-04-23 21:41:00","inspection_id":"81422062","insp_unit_id":"200530891","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"BD27621","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X7ED244832","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"},{"id":8982327,"change_date":"2024-04-23 21:41:00","inspection_id":"81422062","insp_unit_id":"200530892","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"N\/A","insp_unit_license":"D950798","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z882KR066733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"}]},{"id":5482476,"change_date":"2024-04-10 21:42:00","inspection_id":"81320045","dot_number":"347899","report_state":"MI","report_number":"POWEL03574","insp_date":"2024-04-09 00:00:00","insp_start_time":"1045","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"37636","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"1172781","transaction_code":"A","transaction_date":"2024-04-09 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2024-04-10 21:42:00","snet_input_date":"2024-04-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-10 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:29.000000Z","updated_at":"2025-03-17T20:11:29.000000Z","inspection_violations":[{"id":8466004,"change_date":"2024-04-10 21:42:00","inspection_id":"81320045","insp_violation_id":"258858570","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:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8831456,"change_date":"2024-04-10 21:42:00","inspection_id":"81320045","insp_unit_id":"200336106","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"88","insp_unit_license":"BC26897","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X97J174866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:09.000000Z","updated_at":"2025-03-17T23:15:09.000000Z"},{"id":8831457,"change_date":"2024-04-10 21:42:00","inspection_id":"81320045","insp_unit_id":"200336107","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"63","insp_unit_license":"E040398","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z8889RJ43731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:09.000000Z","updated_at":"2025-03-17T23:15:09.000000Z"}]},{"id":5277587,"change_date":"2024-03-13 21:42:00","inspection_id":"81096175","dot_number":"347899","report_state":"MI","report_number":"KELLC02025","insp_date":"2024-03-12 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75NB @ 4 MILE REST AREA","county_code_state":"MI","county_code":"039","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"164000","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":"1168747","transaction_code":"A","transaction_date":"2024-03-12 00:00:00","upload_date":"2024-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2024-03-13 21:42:00","snet_input_date":"2024-03-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-13 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:07.000000Z","updated_at":"2025-03-17T20:07:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8498594,"change_date":"2024-03-13 21:42:00","inspection_id":"81096175","insp_unit_id":"199894119","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"120","insp_unit_license":"BB42151","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X6GD360235","insp_unit_decal":"Y","insp_unit_decal_number":"33685918","created_at":"2025-03-17T23:12:00.000000Z","updated_at":"2025-03-17T23:12:00.000000Z"},{"id":8498595,"change_date":"2024-03-13 21:42:00","inspection_id":"81096175","insp_unit_id":"199894120","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"125T","insp_unit_license":"E826661","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z880PR081299","insp_unit_decal":"Y","insp_unit_decal_number":"33685919","created_at":"2025-03-17T23:12:00.000000Z","updated_at":"2025-03-17T23:12:00.000000Z"}]},{"id":5189571,"change_date":"2024-03-01 21:40:00","inspection_id":"80999957","dot_number":"347899","report_state":"MI","report_number":"DAWDD03379","insp_date":"2024-02-29 00:00:00","insp_start_time":"0859","insp_end_time":"0928","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NORTHERN CONCRETE PIPE INC","shipping_paper_number":"36575","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-03-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1167221","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2024-03-01 21:40:00","snet_input_date":"2024-02-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-01 21:40:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:21.000000Z","updated_at":"2025-03-17T20:05:21.000000Z","inspection_violations":[{"id":7997851,"change_date":"2024-03-01 21:40:00","inspection_id":"80999957","insp_violation_id":"258153861","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:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8356040,"change_date":"2024-03-01 21:40:00","inspection_id":"80999957","insp_unit_id":"199711045","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"121","insp_unit_license":"BB42153","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X8GD360236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:43.000000Z","updated_at":"2025-03-17T23:10:43.000000Z"},{"id":8356041,"change_date":"2024-03-01 21:40:00","inspection_id":"80999957","insp_unit_id":"199711046","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"NONE","insp_unit_license":"E221287","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z887MR073910","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:43.000000Z","updated_at":"2025-03-17T23:10:43.000000Z"}]},{"id":4284156,"change_date":"2023-10-25 21:42:00","inspection_id":"80007697","dot_number":"347899","report_state":"MI","report_number":"HICKG02370","insp_date":"2023-10-24 00:00:00","insp_start_time":"1330","insp_end_time":"1355","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","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-10-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"154000","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":"1150734","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2023-10-25 21:42:00","snet_input_date":"2023-10-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-25 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:50.000000Z","updated_at":"2025-03-17T19:47:50.000000Z","inspection_violations":[{"id":6626398,"change_date":"2023-10-25 21:42:00","inspection_id":"80007697","insp_violation_id":"256041679","seq_no":"1","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197745629","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:37:56.000000Z","updated_at":"2025-03-17T21:37:56.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":6890027,"change_date":"2023-10-25 21:42:00","inspection_id":"80007697","insp_unit_id":"197745628","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"191","insp_unit_license":"BD05499","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X1PD871206","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:47.000000Z","updated_at":"2025-03-17T22:57:47.000000Z"},{"id":6890028,"change_date":"2023-10-25 21:42:00","inspection_id":"80007697","insp_unit_id":"197745629","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E610028","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z882FR052739","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:47.000000Z","updated_at":"2025-03-17T22:57:47.000000Z"}]},{"id":3823964,"change_date":"2023-08-30 21:44:00","inspection_id":"79496682","dot_number":"347899","report_state":"MI","report_number":"HOULD03611","insp_date":"2023-08-23 00:00:00","insp_start_time":"1440","insp_end_time":"1521","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DODGE RD RA @ I-75NB","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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-08-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1142317","transaction_code":"C","transaction_date":"2023-08-23 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2023-08-24 21:41:00","snet_input_date":"2023-08-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-24 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:29.000000Z","updated_at":"2025-03-17T19:38:29.000000Z","inspection_violations":[{"id":5903440,"change_date":"2023-08-30 21:44:00","inspection_id":"79496682","insp_violation_id":"254984860","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196813997","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39311"},{"id":5903441,"change_date":"2023-08-30 21:44:00","inspection_id":"79496682","insp_violation_id":"254984861","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196813997","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6148136,"change_date":"2023-08-30 21:44:00","inspection_id":"79496682","insp_unit_id":"196813996","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"104","insp_unit_license":"E640905","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z882FR052742","insp_unit_decal":"Y","insp_unit_decal_number":"33028752","created_at":"2025-03-17T22:51:39.000000Z","updated_at":"2025-03-17T22:51:39.000000Z"},{"id":6148137,"change_date":"2023-08-30 21:44:00","inspection_id":"79496682","insp_unit_id":"196813997","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"118","insp_unit_license":"BB42154","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X9GD335426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:39.000000Z","updated_at":"2025-03-17T22:51:39.000000Z"}]},{"id":3802884,"change_date":"2023-08-30 21:45:00","inspection_id":"79473184","dot_number":"347899","report_state":"MI","report_number":"WILLD02949","insp_date":"2023-08-22 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"2","location_desc":"PONTIAC SCALES","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","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":"1141982","transaction_code":"C","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2023-08-22 21:43:00","snet_input_date":"2023-08-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-22 21:43:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:01.000000Z","updated_at":"2025-03-17T19:38:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6114453,"change_date":"2023-08-30 21:45:00","inspection_id":"79473184","insp_unit_id":"196817772","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BB42151","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X6GD360235","insp_unit_decal":"Y","insp_unit_decal_number":"33031418","created_at":"2025-03-17T22:51:21.000000Z","updated_at":"2025-03-17T22:51:21.000000Z"},{"id":6114454,"change_date":"2023-08-30 21:45:00","inspection_id":"79473184","insp_unit_id":"196817773","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E221292","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z880MR073912","insp_unit_decal":"Y","insp_unit_decal_number":"33031419","created_at":"2025-03-17T22:51:21.000000Z","updated_at":"2025-03-17T22:51:21.000000Z"}]},{"id":3653790,"change_date":"2023-08-29 21:42:00","inspection_id":"79306552","dot_number":"347899","report_state":"MI","report_number":"ELDEH00254","insp_date":"2023-08-01 00:00:00","insp_start_time":"0810","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75SB @ BAY CITY REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"31353","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-08-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","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":"1138166","transaction_code":"C","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2023-08-02 21:41:00","snet_input_date":"2023-08-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-02 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:57.000000Z","updated_at":"2025-03-17T19:34:57.000000Z","inspection_violations":[{"id":5632723,"change_date":"2023-08-29 21:42:00","inspection_id":"79306552","insp_violation_id":"254953616","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196788840","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5875016,"change_date":"2023-08-29 21:42:00","inspection_id":"79306552","insp_unit_id":"196788840","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"BD27621","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X7ED244832","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"},{"id":5875017,"change_date":"2023-08-29 21:42:00","inspection_id":"79306552","insp_unit_id":"196788841","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"D950798","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z882KR066733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"}]},{"id":3212797,"change_date":"2023-06-05 21:42:00","inspection_id":"78810768","dot_number":"347899","report_state":"MI","report_number":"BRACG00897","insp_date":"2023-06-02 00:00:00","insp_start_time":"1125","insp_end_time":"1203","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"181000","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":"1129074","transaction_code":"A","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2023-06-05 21:42:00","snet_input_date":"2023-06-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-05 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:30.000000Z","updated_at":"2025-03-17T19:26:30.000000Z","inspection_violations":[{"id":4949882,"change_date":"2023-06-05 21:42:00","inspection_id":"78810768","insp_violation_id":"253284006","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195317464","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:02.000000Z","updated_at":"2025-03-17T21:30:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5166899,"change_date":"2023-06-05 21:42:00","inspection_id":"78810768","insp_unit_id":"195317464","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"115","insp_unit_license":"RB23298","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X2ED244835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:43.000000Z","updated_at":"2025-03-17T22:43:43.000000Z"},{"id":5166900,"change_date":"2023-06-05 21:42:00","inspection_id":"78810768","insp_unit_id":"195317465","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"2","insp_unit_license":"E836415","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKB050854B067109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:43.000000Z","updated_at":"2025-03-17T22:43:43.000000Z"}]},{"id":2944238,"change_date":"2023-05-02 21:40:00","inspection_id":"78507493","dot_number":"347899","report_state":"MI","report_number":"MALIK01715","insp_date":"2023-05-01 00:00:00","insp_start_time":"1445","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B 23 MILE RD @ SCHOENHERR RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1124339","transaction_code":"A","transaction_date":"2023-05-01 00:00:00","upload_date":"2023-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2023-05-02 21:40:00","snet_input_date":"2023-05-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-02 21:40:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:21.000000Z","updated_at":"2025-03-17T19:21:21.000000Z","inspection_violations":[{"id":4520221,"change_date":"2023-05-02 21:40:00","inspection_id":"78507493","insp_violation_id":"252570046","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4737350,"change_date":"2023-05-02 21:40:00","inspection_id":"78507493","insp_unit_id":"194703070","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"112","insp_unit_license":"BD27623","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X9ED244833","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:21.000000Z","updated_at":"2025-03-17T22:40:21.000000Z"},{"id":4737351,"change_date":"2023-05-02 21:40:00","inspection_id":"78507493","insp_unit_id":"194703071","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"56","insp_unit_license":"E182715","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKB050874B067113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:21.000000Z","updated_at":"2025-03-17T22:40:21.000000Z"}]},{"id":2578008,"change_date":"2023-03-14 21:42:00","inspection_id":"78091708","dot_number":"347899","report_state":"MI","report_number":"JURKV02103","insp_date":"2023-03-13 00:00:00","insp_start_time":"1100","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1117264","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2023-03-14 21:42:00","snet_input_date":"2023-03-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-14 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:08.000000Z","updated_at":"2025-03-17T19:14:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4149346,"change_date":"2023-03-14 21:42:00","inspection_id":"78091708","insp_unit_id":"193872495","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"110","insp_unit_license":"BD27622","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X5ED244831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:44.000000Z","updated_at":"2025-03-17T22:35:44.000000Z"},{"id":4149347,"change_date":"2023-03-14 21:42:00","inspection_id":"78091708","insp_unit_id":"193872496","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"D950711","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z887KR066730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:44.000000Z","updated_at":"2025-03-17T22:35:44.000000Z"}]},{"id":2456536,"change_date":"2023-02-27 21:41:00","inspection_id":"77953401","dot_number":"347899","report_state":"MI","report_number":"POWEL03043","insp_date":"2023-02-24 00:00:00","insp_start_time":"1115","insp_end_time":"1134","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"27219","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"1115221","transaction_code":"A","transaction_date":"2023-02-24 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2023-02-27 21:41:00","snet_input_date":"2023-02-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-27 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:49.000000Z","updated_at":"2025-03-17T19:11:49.000000Z","inspection_violations":[{"id":3780349,"change_date":"2023-02-27 21:41:00","inspection_id":"77953401","insp_violation_id":"251351580","seq_no":"1","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"193594313","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:49.000000Z","updated_at":"2025-03-17T21:24:49.000000Z","normalized_code":"393104F3"}],"inspection_per_units":[{"id":3953229,"change_date":"2023-02-27 21:41:00","inspection_id":"77953401","insp_unit_id":"193594312","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"AC78437","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X7ED244832","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:18.000000Z","updated_at":"2025-03-17T22:34:18.000000Z"},{"id":3953230,"change_date":"2023-02-27 21:41:00","inspection_id":"77953401","insp_unit_id":"193594313","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E610029","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z8869RJ43730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:18.000000Z","updated_at":"2025-03-17T22:34:18.000000Z"}]},{"id":2369768,"change_date":"2023-02-14 21:41:00","inspection_id":"77854392","dot_number":"347899","report_state":"MI","report_number":"DISCD02110","insp_date":"2023-02-14 00:00:00","insp_start_time":"1024","insp_end_time":"1102","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRANDVILLE","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"152000","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":"1113745","transaction_code":"A","transaction_date":"2023-02-14 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2023-02-14 21:41:00","snet_input_date":"2023-02-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","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":3649017,"change_date":"2023-02-14 21:41:00","inspection_id":"77854392","insp_violation_id":"251130912","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193395190","insp_violation_category_id":"30","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":"3922"},{"id":3649018,"change_date":"2023-02-14 21:41:00","inspection_id":"77854392","insp_violation_id":"251130913","seq_no":"2","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"193395190","insp_violation_category_id":"25","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":"393104F3"}],"inspection_per_units":[{"id":3813362,"change_date":"2023-02-14 21:41:00","inspection_id":"77854392","insp_unit_id":"193395189","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"128","insp_unit_license":"BC43539","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X3MD733808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"},{"id":3813363,"change_date":"2023-02-14 21:41:00","inspection_id":"77854392","insp_unit_id":"193395190","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"105","insp_unit_license":"D243759","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z882GR056484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"}]},{"id":2369548,"change_date":"2023-02-14 21:41:00","inspection_id":"77854149","dot_number":"347899","report_state":"MI","report_number":"BACZM01816","insp_date":"2023-02-13 00:00:00","insp_start_time":"1049","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 SB @ LAKE RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","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":"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":"1113533","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2023-02-14 21:41:00","snet_input_date":"2023-02-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","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":[],"inspection_per_units":[{"id":3812983,"change_date":"2023-02-14 21:41:00","inspection_id":"77854149","insp_unit_id":"193394759","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BB26821","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP2HJ7X4JM466568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"}]},{"id":2286034,"change_date":"2023-02-02 21:42:00","inspection_id":"77758999","dot_number":"347899","report_state":"MI","report_number":"POWED03971","insp_date":"2023-02-01 00:00:00","insp_start_time":"1240","insp_end_time":"1305","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"30971","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"218340","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":"1111893","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2023-02-02 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-02 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:51.000000Z","updated_at":"2025-03-17T19:08:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3679182,"change_date":"2023-02-02 21:42:00","inspection_id":"77758999","insp_unit_id":"193200992","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"118","insp_unit_license":"BB42154","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X9GD335426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:21.000000Z","updated_at":"2025-03-17T22:32:21.000000Z"},{"id":3679183,"change_date":"2023-02-02 21:42:00","inspection_id":"77758999","insp_unit_id":"193200993","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"N\/A","insp_unit_license":"B565921","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1TKB050846M066850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:21.000000Z","updated_at":"2025-03-17T22:32:21.000000Z"}]},{"id":2234957,"change_date":"2023-01-26 21:42:00","inspection_id":"77700931","dot_number":"347899","report_state":"MI","report_number":"FLOHC00438","insp_date":"2023-01-25 00:00:00","insp_start_time":"0850","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M115 @ LAKE STATION AVE","county_code_state":"MI","county_code":"035","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":"N","pen_cen_match":null,"final_status_date":"2023-01-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"191984","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":"1110870","transaction_code":"A","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2023-01-26 21:42:00","snet_input_date":"2023-01-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-26 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:46.000000Z","updated_at":"2025-03-17T19:07:46.000000Z","inspection_violations":[{"id":3452560,"change_date":"2023-01-26 21:42:00","inspection_id":"77700931","insp_violation_id":"250798739","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:19.000000Z","updated_at":"2025-03-17T21:23:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3597424,"change_date":"2023-01-26 21:42:00","inspection_id":"77700931","insp_unit_id":"193084299","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"84","insp_unit_license":"BB42149","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X85J100805","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:48.000000Z","updated_at":"2025-03-17T22:31:48.000000Z"},{"id":3597425,"change_date":"2023-01-26 21:42:00","inspection_id":"77700931","insp_unit_id":"193084300","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E672647","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z887PR081297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:48.000000Z","updated_at":"2025-03-17T22:31:48.000000Z"}]},{"id":2038254,"change_date":"2022-12-29 21:40:00","inspection_id":"77475602","dot_number":"347899","report_state":"MI","report_number":"COPEK01812","insp_date":"2022-12-29 00:00:00","insp_start_time":"0825","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ OLD SCALES","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","shipping_paper_number":"33548","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-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1107287","transaction_code":"A","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-12-29 21:40:00","snet_input_date":"2022-12-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-29 21:40:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:04.000000Z","updated_at":"2025-03-17T19:04:04.000000Z","inspection_violations":[{"id":3158424,"change_date":"2022-12-29 21:40:00","inspection_id":"77475602","insp_violation_id":"250317368","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192632557","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:56.000000Z","updated_at":"2025-03-17T21:21:56.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3278842,"change_date":"2022-12-29 21:40:00","inspection_id":"77475602","insp_unit_id":"192632556","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"119","insp_unit_license":"BB42150","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X4GD360234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:28.000000Z","updated_at":"2025-03-17T22:29:28.000000Z"},{"id":3278843,"change_date":"2022-12-29 21:40:00","inspection_id":"77475602","insp_unit_id":"192632557","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAIL","insp_unit_company":"5","insp_unit_license":"E182714","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKB050854B067112","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:28.000000Z","updated_at":"2025-03-17T22:29:28.000000Z"}]},{"id":1903151,"change_date":"2022-12-08 21:41:00","inspection_id":"77321027","dot_number":"347899","report_state":"MI","report_number":"POWEL02915","insp_date":"2022-12-06 00:00:00","insp_start_time":"0755","insp_end_time":"0826","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"34213","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"1104687","transaction_code":"A","transaction_date":"2022-12-06 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-12-08 21:41:00","snet_input_date":"2022-12-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-08 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:49.000000Z","updated_at":"2025-03-17T19:01:49.000000Z","inspection_violations":[{"id":2960190,"change_date":"2022-12-08 21:41:00","inspection_id":"77321027","insp_violation_id":"249996186","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:21:06.000000Z","updated_at":"2025-03-17T21:21:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3062729,"change_date":"2022-12-08 21:41:00","inspection_id":"77321027","insp_unit_id":"192330588","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"88","insp_unit_license":"BC26897","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X97J174866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:58.000000Z","updated_at":"2025-03-17T22:27:58.000000Z"},{"id":3062730,"change_date":"2022-12-08 21:41:00","inspection_id":"77321027","insp_unit_id":"192330589","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"63","insp_unit_license":"E040398","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z8889RJ43731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:58.000000Z","updated_at":"2025-03-17T22:27:58.000000Z"}]},{"id":1807239,"change_date":"2022-11-23 21:40:00","inspection_id":"77211631","dot_number":"347899","report_state":"MI","report_number":"LARSE02981","insp_date":"2022-11-22 00:00:00","insp_start_time":"0940","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"31263","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1102908","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-11-23 21:40:00","snet_input_date":"2022-11-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:58.000000Z","updated_at":"2025-03-17T18:59:58.000000Z","inspection_violations":[{"id":2825973,"change_date":"2022-11-23 21:40:00","inspection_id":"77211631","insp_violation_id":"249768991","seq_no":"7","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"192111175","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39345"},{"id":2825974,"change_date":"2022-11-23 21:40:00","inspection_id":"77211631","insp_violation_id":"249768992","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192111175","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3922"},{"id":2825975,"change_date":"2022-11-23 21:40:00","inspection_id":"77211631","insp_violation_id":"249768993","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192111174","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4142916","created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39375A3"},{"id":2825976,"change_date":"2022-11-23 21:40:00","inspection_id":"77211631","insp_violation_id":"249768994","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"192111174","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39375C"},{"id":2825977,"change_date":"2022-11-23 21:40:00","inspection_id":"77211631","insp_violation_id":"249768995","seq_no":"3","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"192111174","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39375B"},{"id":2825978,"change_date":"2022-11-23 21:40:00","inspection_id":"77211631","insp_violation_id":"249768996","seq_no":"4","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"192111174","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39375B"},{"id":2825979,"change_date":"2022-11-23 21:40:00","inspection_id":"77211631","insp_violation_id":"249768997","seq_no":"5","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"192111174","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39375B"},{"id":2825980,"change_date":"2022-11-23 21:40:00","inspection_id":"77211631","insp_violation_id":"249768998","seq_no":"6","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"192111174","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39375B"}],"inspection_per_units":[{"id":2907116,"change_date":"2022-11-23 21:40:00","inspection_id":"77211631","insp_unit_id":"192111174","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"110","insp_unit_license":"AC92404","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X5ED244831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"},{"id":2907117,"change_date":"2022-11-23 21:40:00","inspection_id":"77211631","insp_unit_id":"192111175","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"D950711","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z887KR066730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"}]},{"id":1677497,"change_date":"2022-11-04 21:38:00","inspection_id":"77062708","dot_number":"347899","report_state":"MI","report_number":"MCGEJ02616","insp_date":"2022-11-03 00:00:00","insp_start_time":"1430","insp_end_time":"1446","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I75 SB @ 4 MILE RD","county_code_state":"MI","county_code":"039","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","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":"N","pen_cen_match":null,"final_status_date":"2022-11-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1101232","transaction_code":"A","transaction_date":"2022-11-03 00:00:00","upload_date":"2022-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-11-04 21:38:00","snet_input_date":"2022-11-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-04 21:38:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:28.000000Z","updated_at":"2025-03-17T18:57:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2698690,"change_date":"2022-11-04 21:38:00","inspection_id":"77062708","insp_unit_id":"191816942","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"127","insp_unit_license":"BC43540","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X1MD733807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:29.000000Z","updated_at":"2025-03-17T22:25:29.000000Z"},{"id":2698691,"change_date":"2022-11-04 21:38:00","inspection_id":"77062708","insp_unit_id":"191816943","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"102","insp_unit_license":"E182717","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z889FR052740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:29.000000Z","updated_at":"2025-03-17T22:25:29.000000Z"}]},{"id":1466817,"change_date":"2022-10-07 21:39:00","inspection_id":"76820258","dot_number":"347899","report_state":"MI","report_number":"POWEL02841","insp_date":"2022-10-06 00:00:00","insp_start_time":"1215","insp_end_time":"1235","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"33457","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"1097640","transaction_code":"A","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-10-07 21:39:00","snet_input_date":"2022-10-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-07 21:39:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:46.000000Z","updated_at":"2025-03-17T18:53:46.000000Z","inspection_violations":[{"id":2310082,"change_date":"2022-10-07 21:39:00","inspection_id":"76820258","insp_violation_id":"248899903","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:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2361462,"change_date":"2022-10-07 21:39:00","inspection_id":"76820258","insp_unit_id":"191329543","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"126","insp_unit_license":"BC13458","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X7LD643687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:11.000000Z","updated_at":"2025-03-17T22:23:11.000000Z"},{"id":2361463,"change_date":"2022-10-07 21:39:00","inspection_id":"76820258","insp_unit_id":"191329544","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"56","insp_unit_license":"E182715","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKB050874B067113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:11.000000Z","updated_at":"2025-03-17T22:23:11.000000Z"}]},{"id":1254583,"change_date":"2022-09-11 21:30:00","inspection_id":"76573578","dot_number":"347899","report_state":"MI","report_number":"LARSE02897","insp_date":"2022-09-09 00:00:00","insp_start_time":"1420","insp_end_time":"1445","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NORTHERN CONCRETE PIPE","shipping_paper_number":"31251","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-11 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1094003","transaction_code":"A","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-09-11 21:30:00","snet_input_date":"2022-09-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-11 21:30:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:45.000000Z","updated_at":"2025-03-17T18:49:45.000000Z","inspection_violations":[{"id":1986324,"change_date":"2022-09-11 21:30:00","inspection_id":"76573578","insp_violation_id":"248325774","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":"X4116155","created_at":"2025-03-17T21:16:09.000000Z","updated_at":"2025-03-17T21:16:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2019393,"change_date":"2022-09-11 21:30:00","inspection_id":"76573578","insp_unit_id":"190824464","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"127","insp_unit_license":"BC43540","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X1MD733807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:52.000000Z","updated_at":"2025-03-17T22:20:52.000000Z"},{"id":2019394,"change_date":"2022-09-11 21:30:00","inspection_id":"76573578","insp_unit_id":"190824465","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"99","insp_unit_license":"E182716","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z889FR052737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:52.000000Z","updated_at":"2025-03-17T22:20:52.000000Z"}]},{"id":1248782,"change_date":"2022-09-09 21:38:00","inspection_id":"76566911","dot_number":"347899","report_state":"MI","report_number":"KOCHJ00898","insp_date":"2022-09-08 00:00:00","insp_start_time":"1320","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75NB\/RATHBUN RD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","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":"1093887","transaction_code":"A","transaction_date":"2022-09-08 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-09-09 21:38:00","snet_input_date":"2022-09-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-09 21:38:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:43.000000Z","updated_at":"2025-03-17T18:49:43.000000Z","inspection_violations":[{"id":1976504,"change_date":"2022-09-09 21:38:00","inspection_id":"76566911","insp_violation_id":"248309028","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2009693,"change_date":"2022-09-09 21:38:00","inspection_id":"76566911","insp_unit_id":"190810586","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"110","insp_unit_license":"AC92404","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X5ED244831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:48.000000Z","updated_at":"2025-03-17T22:20:48.000000Z"},{"id":2009694,"change_date":"2022-09-09 21:38:00","inspection_id":"76566911","insp_unit_id":"190810587","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"NA","insp_unit_license":"D950711","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z887KR066730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:48.000000Z","updated_at":"2025-03-17T22:20:48.000000Z"}]},{"id":1159201,"change_date":"2022-08-29 21:42:00","inspection_id":"76463458","dot_number":"347899","report_state":"MI","report_number":"ROBER00634","insp_date":"2022-08-26 00:00:00","insp_start_time":"1220","insp_end_time":"1251","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"32559","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"154000","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":"1091577","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-08-29 21:42:00","snet_input_date":"2022-08-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-29 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:58.000000Z","updated_at":"2025-03-17T18:47:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1863797,"change_date":"2022-08-29 21:42:00","inspection_id":"76463458","insp_unit_id":"190597468","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"86","insp_unit_license":"BB79530","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X96J122796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:49.000000Z","updated_at":"2025-03-17T22:19:49.000000Z"},{"id":1863798,"change_date":"2022-08-29 21:42:00","inspection_id":"76463458","insp_unit_id":"190597469","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"T86","insp_unit_license":"D201969","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FE0508XY1019781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:49.000000Z","updated_at":"2025-03-17T22:19:49.000000Z"}]},{"id":1098233,"change_date":"2022-08-22 21:42:00","inspection_id":"76392533","dot_number":"347899","report_state":"MI","report_number":"POWEL02747","insp_date":"2022-08-18 00:00:00","insp_start_time":"1055","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"31034","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"1090041","transaction_code":"A","transaction_date":"2022-08-18 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-08-22 21:42:00","snet_input_date":"2022-08-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-22 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:57.000000Z","updated_at":"2025-03-17T18:46:57.000000Z","inspection_violations":[{"id":1728925,"change_date":"2022-08-22 21:42:00","inspection_id":"76392533","insp_violation_id":"247883483","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:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1766391,"change_date":"2022-08-22 21:42:00","inspection_id":"76392533","insp_unit_id":"190455207","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"112","insp_unit_license":"AC78444","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X9ED244833","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:09.000000Z","updated_at":"2025-03-17T22:19:09.000000Z"},{"id":1766392,"change_date":"2022-08-22 21:42:00","inspection_id":"76392533","insp_unit_id":"190455208","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"34","insp_unit_license":"E182712","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FE05088V1016163","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:09.000000Z","updated_at":"2025-03-17T22:19:09.000000Z"}]},{"id":1035283,"change_date":"2022-08-29 21:42:00","inspection_id":"76318657","dot_number":"347899","report_state":"MI","report_number":"POWEL02743","insp_date":"2022-08-12 00:00:00","insp_start_time":"1225","insp_end_time":"1254","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"1089087","transaction_code":"C","transaction_date":"2022-08-12 00:00:00","upload_date":"2022-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-08-15 21:38:00","snet_input_date":"2022-08-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-15 21:38:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:51.000000Z","updated_at":"2025-03-17T18:45:51.000000Z","inspection_violations":[{"id":1630229,"change_date":"2022-08-29 21:42:00","inspection_id":"76318657","insp_violation_id":"248063153","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:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1666196,"change_date":"2022-08-29 21:42:00","inspection_id":"76318657","insp_unit_id":"190596074","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"124","insp_unit_license":"BB26878","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X7JD481265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:30.000000Z","updated_at":"2025-03-17T22:18:30.000000Z"},{"id":1666197,"change_date":"2022-08-29 21:42:00","inspection_id":"76318657","insp_unit_id":"190596075","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"D243849","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z884GR056485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:30.000000Z","updated_at":"2025-03-17T22:18:30.000000Z"}]},{"id":1035483,"change_date":"2022-08-29 21:42:00","inspection_id":"76318893","dot_number":"347899","report_state":"MI","report_number":"BRADD00714","insp_date":"2022-08-12 00:00:00","insp_start_time":"0800","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I96 EB AT SARANAC REST AREA","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"30400","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"164000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1089217","transaction_code":"C","transaction_date":"2022-08-12 00:00:00","upload_date":"2022-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-08-15 21:38:00","snet_input_date":"2022-08-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-15 21:38:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:51.000000Z","updated_at":"2025-03-17T18:45:51.000000Z","inspection_violations":[{"id":1630647,"change_date":"2022-08-29 21:42:00","inspection_id":"76318893","insp_violation_id":"248062652","seq_no":"1","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"190595603","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"X4090310","created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"3929A2"},{"id":1630648,"change_date":"2022-08-29 21:42:00","inspection_id":"76318893","insp_violation_id":"248062653","seq_no":"2","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"190595603","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"393104F3"},{"id":1630649,"change_date":"2022-08-29 21:42:00","inspection_id":"76318893","insp_violation_id":"248062654","seq_no":"3","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"190595603","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"393110B"}],"inspection_per_units":[{"id":1666547,"change_date":"2022-08-29 21:42:00","inspection_id":"76318893","insp_unit_id":"190595602","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"90","insp_unit_license":"BA02626","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X27J174868","insp_unit_decal":"Y","insp_unit_decal_number":"31658030","created_at":"2025-03-17T22:18:30.000000Z","updated_at":"2025-03-17T22:18:30.000000Z"},{"id":1666548,"change_date":"2022-08-29 21:42:00","inspection_id":"76318893","insp_unit_id":"190595603","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"102","insp_unit_license":"E182717","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z889FR052740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:30.000000Z","updated_at":"2025-03-17T22:18:30.000000Z"}]},{"id":873215,"change_date":"2022-07-22 21:40:00","inspection_id":"76129182","dot_number":"347899","report_state":"MI","report_number":"MALIK01200","insp_date":"2022-07-21 00:00:00","insp_start_time":"0910","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"221109093602","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-22 21:40: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":"1085259","transaction_code":"A","transaction_date":"2022-07-21 00:00:00","upload_date":"2022-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-07-22 21:40:00","snet_input_date":"2022-07-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-22 21:40:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:03.000000Z","updated_at":"2025-03-17T18:43:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1405761,"change_date":"2022-07-22 21:40:00","inspection_id":"76129182","insp_unit_id":"189917232","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"110","insp_unit_license":"AC92404","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X5ED244831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:50.000000Z","updated_at":"2025-03-17T22:16:50.000000Z"},{"id":1405762,"change_date":"2022-07-22 21:40:00","inspection_id":"76129182","insp_unit_id":"189917233","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"110","insp_unit_license":"D950711","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z887KR066730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:50.000000Z","updated_at":"2025-03-17T22:16:50.000000Z"}]},{"id":660496,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","dot_number":"347899","report_state":"MI","report_number":"SCIBA01924","insp_date":"2022-06-17 00:00:00","insp_start_time":"0915","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","viol_total":"17","oos_total":"7","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"17","vehicle_oos_total":"7","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1080855","transaction_code":"A","transaction_date":"2022-06-17 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:28.000000Z","updated_at":"2025-03-17T18:39:28.000000Z","inspection_violations":[{"id":1039147,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620899","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"189379826","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"3963A1"},{"id":1039148,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620900","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"189379826","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"39345D"},{"id":1039149,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620901","seq_no":"3","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"189379825","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"393209D"},{"id":1039150,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620902","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189379825","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"3963A1"},{"id":1039151,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620903","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189379825","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"39345B2"},{"id":1039152,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620904","seq_no":"6","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189379826","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"3929A"},{"id":1039153,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620905","seq_no":"7","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"189379826","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"393110B"},{"id":1039154,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620906","seq_no":"8","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"189379826","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"393110B"},{"id":1039155,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620907","seq_no":"9","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"189379826","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"393104F3"},{"id":1039156,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620908","seq_no":"10","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"189379826","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"393104F3"},{"id":1039157,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620909","seq_no":"11","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"189379826","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"393104F3"},{"id":1039158,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620910","seq_no":"12","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"189379826","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"393104F3"},{"id":1039159,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620911","seq_no":"13","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"189379826","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"393104F3"},{"id":1039160,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620912","seq_no":"14","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189379826","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"3929A"},{"id":1039161,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620913","seq_no":"15","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"189379825","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"3965B"},{"id":1039162,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620914","seq_no":"16","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"189379826","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"393207A"},{"id":1039163,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_violation_id":"246620915","seq_no":"17","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"2","insp_unit_id":"189379826","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"39375A2"}],"inspection_per_units":[{"id":1061606,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_unit_id":"189379825","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"122","insp_unit_license":"BB42155","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40XXGD360237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:44.000000Z","updated_at":"2025-03-17T22:14:44.000000Z"},{"id":1061607,"change_date":"2022-06-21 21:42:00","inspection_id":"75880059","insp_unit_id":"189379826","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"99","insp_unit_license":"E182716","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z889FR052737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:44.000000Z","updated_at":"2025-03-17T22:14:44.000000Z"}]},{"id":660490,"change_date":"2022-06-21 21:42:00","inspection_id":"75880053","dot_number":"347899","report_state":"MI","report_number":"SCIBA01922","insp_date":"2022-06-16 00:00:00","insp_start_time":"1010","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"641","location_desc":"IONIA SCALE E\/B","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1080550","transaction_code":"A","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:28.000000Z","updated_at":"2025-03-17T18:39:28.000000Z","inspection_violations":[{"id":1039131,"change_date":"2022-06-21 21:42:00","inspection_id":"75880053","insp_violation_id":"246620882","seq_no":"1","part_no":"393","part_no_section":"124","insp_viol_unit":"2","insp_unit_id":"189379816","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"393124"},{"id":1039132,"change_date":"2022-06-21 21:42:00","inspection_id":"75880053","insp_violation_id":"246620883","seq_no":"2","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189379816","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"3929A"},{"id":1039133,"change_date":"2022-06-21 21:42:00","inspection_id":"75880053","insp_violation_id":"246620884","seq_no":"3","part_no":"393","part_no_section":"47(b)","insp_viol_unit":"2","insp_unit_id":"189379816","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"39347B"},{"id":1039134,"change_date":"2022-06-21 21:42:00","inspection_id":"75880053","insp_violation_id":"246620885","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"189379816","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"39353B"},{"id":1039135,"change_date":"2022-06-21 21:42:00","inspection_id":"75880053","insp_violation_id":"246620886","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189379816","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"39347E"},{"id":1039136,"change_date":"2022-06-21 21:42:00","inspection_id":"75880053","insp_violation_id":"246620887","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189379816","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"39347E"},{"id":1039137,"change_date":"2022-06-21 21:42:00","inspection_id":"75880053","insp_violation_id":"246620888","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189379816","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"39347E"},{"id":1039138,"change_date":"2022-06-21 21:42:00","inspection_id":"75880053","insp_violation_id":"246620889","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"189379816","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"39345B2"},{"id":1039139,"change_date":"2022-06-21 21:42:00","inspection_id":"75880053","insp_violation_id":"246620890","seq_no":"9","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189379815","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":1061597,"change_date":"2022-06-21 21:42:00","inspection_id":"75880053","insp_unit_id":"189379815","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"90","insp_unit_license":"BA02626","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X27J174868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:44.000000Z","updated_at":"2025-03-17T22:14:44.000000Z"},{"id":1061598,"change_date":"2022-06-21 21:42:00","inspection_id":"75880053","insp_unit_id":"189379816","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"D201969","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FE0508XY1019781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:44.000000Z","updated_at":"2025-03-17T22:14:44.000000Z"}]},{"id":515537,"change_date":"2022-06-09 21:42:00","inspection_id":"75707835","dot_number":"347899","report_state":"MI","report_number":"BRACG00782","insp_date":"2022-05-27 00:00:00","insp_start_time":"0652","insp_end_time":"0708","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116","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":"1077374","transaction_code":"C","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-05-31 21:41:00","snet_input_date":"2022-05-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-31 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:43.000000Z","updated_at":"2025-03-17T18:36:43.000000Z","inspection_violations":[{"id":817380,"change_date":"2022-06-09 21:42:00","inspection_id":"75707835","insp_violation_id":"246330064","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:10:52.000000Z","updated_at":"2025-03-17T21:10:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":829694,"change_date":"2022-06-09 21:42:00","inspection_id":"75707835","insp_unit_id":"189142968","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"52000","insp_unit_license":"BA02613","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X0ED244834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:19.000000Z","updated_at":"2025-03-17T22:13:19.000000Z"},{"id":829695,"change_date":"2022-06-09 21:42:00","inspection_id":"75707835","insp_unit_id":"189142969","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"129000","insp_unit_license":"E610029","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z8869RJ43730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:19.000000Z","updated_at":"2025-03-17T22:13:19.000000Z"}]},{"id":482442,"change_date":"2022-06-09 21:42:00","inspection_id":"75668416","dot_number":"347899","report_state":"MI","report_number":"KIRKB03454","insp_date":"2022-05-24 00:00:00","insp_start_time":"0740","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MDOT BRIGHTON MAINT GARAGE","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"31856","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"192000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1076982","transaction_code":"C","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-05-25 21:42:00","snet_input_date":"2022-05-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-25 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:17.000000Z","updated_at":"2025-03-17T18:36:17.000000Z","inspection_violations":[{"id":762997,"change_date":"2022-06-09 21:42:00","inspection_id":"75668416","insp_violation_id":"246335376","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189146813","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4053313","created_at":"2025-03-17T21:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"3922"},{"id":762998,"change_date":"2022-06-09 21:42:00","inspection_id":"75668416","insp_violation_id":"246335377","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"189146813","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"3965B"},{"id":762999,"change_date":"2022-06-09 21:42:00","inspection_id":"75668416","insp_violation_id":"246335378","seq_no":"3","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"189146813","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"393203A"}],"inspection_per_units":[{"id":775824,"change_date":"2022-06-09 21:42:00","inspection_id":"75668416","insp_unit_id":"189146813","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"91","insp_unit_license":"AC78428","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPAD40X66N634730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:58.000000Z","updated_at":"2025-03-17T22:12:58.000000Z"},{"id":775825,"change_date":"2022-06-09 21:42:00","inspection_id":"75668416","insp_unit_id":"189146814","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"63","insp_unit_license":"E040398","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z8889RJ43731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:58.000000Z","updated_at":"2025-03-17T22:12:58.000000Z"}]},{"id":482593,"change_date":"2022-06-09 21:42:00","inspection_id":"75668586","dot_number":"347899","report_state":"MI","report_number":"BRACG00781","insp_date":"2022-05-24 00:00:00","insp_start_time":"1302","insp_end_time":"1317","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"161000","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":"1076860","transaction_code":"C","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-05-25 21:42:00","snet_input_date":"2022-05-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-25 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:17.000000Z","updated_at":"2025-03-17T18:36:17.000000Z","inspection_violations":[{"id":763233,"change_date":"2022-06-09 21:42:00","inspection_id":"75668586","insp_violation_id":"246330063","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:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":776091,"change_date":"2022-06-09 21:42:00","inspection_id":"75668586","insp_unit_id":"189142966","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"115","insp_unit_license":"RB23298","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X2ED244835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:58.000000Z","updated_at":"2025-03-17T22:12:58.000000Z"},{"id":776092,"change_date":"2022-06-09 21:42:00","inspection_id":"75668586","insp_unit_id":"189142967","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"2","insp_unit_license":"B565922","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKB050866M066851","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:58.000000Z","updated_at":"2025-03-17T22:12:58.000000Z"}]},{"id":194137,"change_date":"2022-06-09 21:42:00","inspection_id":"75324534","dot_number":"347899","report_state":"MI","report_number":"ROLLJ01761","insp_date":"2022-04-14 00:00:00","insp_start_time":"0813","insp_end_time":"0821","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"16 RD WB @ 41 1\/2 RD","county_code_state":"MI","county_code":"165","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"31038","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","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":"1072203","transaction_code":"C","transaction_date":"2022-04-14 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-04-18 21:41:00","snet_input_date":"2022-04-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-18 21:41:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:53.000000Z","updated_at":"2025-03-17T18:30:53.000000Z","inspection_violations":[{"id":296448,"change_date":"2022-06-09 21:42:00","inspection_id":"75324534","insp_violation_id":"246340735","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189151803","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4043309","created_at":"2025-03-17T21:08:23.000000Z","updated_at":"2025-03-17T21:08:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":314528,"change_date":"2022-06-09 21:42:00","inspection_id":"75324534","insp_unit_id":"189151803","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"117","insp_unit_license":"BB42152","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X7GD335425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:04.000000Z","updated_at":"2025-03-17T22:10:04.000000Z"},{"id":314529,"change_date":"2022-06-09 21:42:00","inspection_id":"75324534","insp_unit_id":"189151804","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"101","insp_unit_license":"E610028","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z882FR052739","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:04.000000Z","updated_at":"2025-03-17T22:10:04.000000Z"}]},{"id":62045,"change_date":"2022-03-29 21:42:00","inspection_id":"75164252","dot_number":"347899","report_state":"MI","report_number":"POWEL02522","insp_date":"2022-03-28 00:00:00","insp_start_time":"1010","insp_end_time":"1039","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"97283","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"1069514","transaction_code":"A","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00347899","upload_search_indicator":null,"census_search_date":"2022-03-29 21:42:00","snet_input_date":"2022-03-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-29 21:42:00","insp_carrier_name":"NORTHERN CONCRETE PIPE INC","insp_carrier_street":"401 KELTON ST","insp_carrier_city":"BAY CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"48706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:45.000000Z","updated_at":"2025-03-17T18:28:45.000000Z","inspection_violations":[{"id":89125,"change_date":"2022-03-29 21:42:00","inspection_id":"75164252","insp_violation_id":"244834029","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:07:31.000000Z","updated_at":"2025-03-17T21:07:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":100776,"change_date":"2022-03-29 21:42:00","inspection_id":"75164252","insp_unit_id":"187872777","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"114","insp_unit_license":"BA02613","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X0ED244834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"},{"id":100777,"change_date":"2022-03-29 21:42:00","inspection_id":"75164252","insp_unit_id":"187872778","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"62","insp_unit_license":"E610029","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1H5Z8869RJ43730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/347899\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/347899\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/347899\/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\/347899\/inspections","per_page":100,"prev_page_url":null,"to":66,"total":66}