{"current_page":1,"data":[{"id":9165980,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","dot_number":"2167478","report_state":"MI","report_number":"MCKEN00091","insp_date":"2025-07-15 00:00:00","insp_start_time":"0905","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EBELS GENERAL STORE","county_code_state":"MI","county_code":"133","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"45490","viol_total":"11","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1230629","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2025-07-16 21:41:00","snet_input_date":"2025-07-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-16 21:41:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-19T10:42:41.000000Z","updated_at":"2025-07-21T10:42:37.000000Z","inspection_violations":[{"id":14796345,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","insp_violation_id":"267446718","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"207905502","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:51.000000Z","updated_at":"2025-07-21T10:44:51.000000Z","normalized_code":"39617CPI"},{"id":14796346,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","insp_violation_id":"267446719","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"207905503","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:51.000000Z","updated_at":"2025-07-21T10:44:51.000000Z","normalized_code":"39617CPI"},{"id":14796347,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","insp_violation_id":"267446720","seq_no":"3","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"207905503","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:51.000000Z","updated_at":"2025-07-21T10:44:51.000000Z","normalized_code":"39343DBMA"},{"id":14796348,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","insp_violation_id":"267446721","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"207905503","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:51.000000Z","updated_at":"2025-07-21T10:44:51.000000Z","normalized_code":"3939ALIL"},{"id":14796349,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","insp_violation_id":"267446722","seq_no":"5","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"207905503","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:51.000000Z","updated_at":"2025-07-21T10:44:51.000000Z","normalized_code":"39343DB"},{"id":14796350,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","insp_violation_id":"267446723","seq_no":"6","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"2","insp_unit_id":"207905503","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:51.000000Z","updated_at":"2025-07-21T10:44:51.000000Z","normalized_code":"393104F3C"},{"id":14796351,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","insp_violation_id":"267446724","seq_no":"7","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"207905503","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:51.000000Z","updated_at":"2025-07-21T10:44:51.000000Z","normalized_code":"39348ABIHE"},{"id":14796352,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","insp_violation_id":"267446725","seq_no":"8","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"207905503","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:51.000000Z","updated_at":"2025-07-21T10:44:51.000000Z","normalized_code":"39348ABIHE"},{"id":14796353,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","insp_violation_id":"267446726","seq_no":"9","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"207905503","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:51.000000Z","updated_at":"2025-07-21T10:44:51.000000Z","normalized_code":"39348ABIHE"},{"id":14796354,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","insp_violation_id":"267446727","seq_no":"10","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"207905503","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:51.000000Z","updated_at":"2025-07-21T10:44:51.000000Z","normalized_code":"39348ABIHE"},{"id":14796355,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","insp_violation_id":"267446728","seq_no":"11","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"207905503","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:51.000000Z","updated_at":"2025-07-21T10:44:51.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":15057921,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","insp_unit_id":"207905502","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHITE","insp_unit_license":"BD87967","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD0W5HT7KEF24760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-19T09:46:19.000000Z","updated_at":"2025-07-20T09:46:00.000000Z"},{"id":15057922,"change_date":"2025-07-16 21:41:00","inspection_id":"85233336","insp_unit_id":"207905503","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"BLK","insp_unit_license":"E001388","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1L9PU1725HG423959","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-19T09:46:19.000000Z","updated_at":"2025-07-20T09:46:00.000000Z"}]},{"id":8816369,"change_date":"2025-06-04 21:41:00","inspection_id":"84864053","dot_number":"2167478","report_state":"MI","report_number":"FRIZS03254","insp_date":"2025-06-03 00:00:00","insp_start_time":"1810","insp_end_time":"1832","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"RANSOM RD @ WASHINGTON RD","county_code_state":"MI","county_code":"057","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1224017","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2025-06-04 21:41:00","snet_input_date":"2025-06-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-07T10:01:07.000000Z","updated_at":"2025-06-09T10:00:38.000000Z","inspection_violations":[{"id":14109224,"change_date":"2025-06-04 21:41:00","inspection_id":"84864053","insp_violation_id":"266662013","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-07T10:16:56.000000Z","updated_at":"2025-06-08T10:17:41.000000Z","normalized_code":"3922SLLS4"},{"id":14109225,"change_date":"2025-06-04 21:41:00","inspection_id":"84864053","insp_violation_id":"266662014","seq_no":"2","part_no":"391","part_no_section":"41A-MCPVI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4522760F","created_at":"2025-06-07T10:16:56.000000Z","updated_at":"2025-06-08T10:17:41.000000Z","normalized_code":"39141AMCPVI"},{"id":14109226,"change_date":"2025-06-04 21:41:00","inspection_id":"84864053","insp_violation_id":"266662015","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4522760","created_at":"2025-06-07T10:16:56.000000Z","updated_at":"2025-06-08T10:17:41.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14432469,"change_date":"2025-06-04 21:41:00","inspection_id":"84864053","insp_unit_id":"207224787","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC56919","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD8W3HT7KEC83645","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:16.000000Z","updated_at":"2025-06-08T09:45:53.000000Z"},{"id":14432470,"change_date":"2025-06-04 21:41:00","inspection_id":"84864053","insp_unit_id":"207224788","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LARO","insp_unit_company":null,"insp_unit_license":"E806377","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1L9LPUT19MH280488","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:16.000000Z","updated_at":"2025-06-08T09:45:53.000000Z"}]},{"id":8415811,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","dot_number":"2167478","report_state":"MI","report_number":"FRIZS03233","insp_date":"2025-04-17 00:00:00","insp_start_time":"0815","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N. SAGINAW RD @ COMMUNITY CHUR","county_code_state":"MI","county_code":"111","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"2025-04-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32600","viol_total":"13","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1218115","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2025-04-18 21:40:00","snet_input_date":"2025-04-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-18 21:40:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-21T10:26:13.000000Z","updated_at":"2025-04-23T10:03:22.000000Z","inspection_violations":[{"id":13278790,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_violation_id":"265707631","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"206388494","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4514961","created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:31:00.000000Z","normalized_code":"39617CPI"},{"id":13278791,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_violation_id":"265707632","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"206388494","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:31:00.000000Z","normalized_code":"39395A4EEUS"},{"id":13278792,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_violation_id":"265707633","seq_no":"3","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"206388494","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:31:00.000000Z","normalized_code":"39311A1LIL"},{"id":13278793,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_violation_id":"265707634","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"206388495","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:31:00.000000Z","normalized_code":"39617CPI"},{"id":13278794,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_violation_id":"265707635","seq_no":"5","part_no":"393","part_no_section":"11A1-LSML","insp_viol_unit":"2","insp_unit_id":"206388495","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:31:00.000000Z","normalized_code":"39311A1LSML"},{"id":13278795,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_violation_id":"265707636","seq_no":"6","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"206388495","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:31:00.000000Z","normalized_code":"3939ALLPL"},{"id":13278796,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_violation_id":"265707637","seq_no":"7","part_no":"393","part_no_section":"205C-WR","insp_viol_unit":"2","insp_unit_id":"206388495","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:31:00.000000Z","normalized_code":"393205CWR"},{"id":13278797,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_violation_id":"265707638","seq_no":"8","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"206388495","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:31:00.000000Z","normalized_code":"39348ABIBD"},{"id":13278798,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_violation_id":"265707639","seq_no":"9","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"206388495","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:31:00.000000Z","normalized_code":"39348ABIBD"},{"id":13278799,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_violation_id":"265707640","seq_no":"10","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"206388495","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:31:00.000000Z","normalized_code":"39348ABIBD"},{"id":13278800,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_violation_id":"265707641","seq_no":"11","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"206388495","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:31:00.000000Z","normalized_code":"39348ABIBD"},{"id":13278801,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_violation_id":"265707642","seq_no":"12","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"206388495","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4514961","created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:31:00.000000Z","normalized_code":"3963A1BOS"},{"id":13278802,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_violation_id":"265707643","seq_no":"13","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"2","insp_unit_id":"206388495","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:31:00.000000Z","normalized_code":"39311A1LIL"}],"inspection_per_units":[{"id":13664185,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_unit_id":"206388494","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD41480","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4HT4GEB70179","insp_unit_decal":"Y","insp_unit_decal_number":"0","created_at":"2025-04-21T10:15:55.000000Z","updated_at":"2025-04-22T10:02:19.000000Z"},{"id":13664186,"change_date":"2025-04-18 21:40:00","inspection_id":"84441499","insp_unit_id":"206388495","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ECLN","insp_unit_company":null,"insp_unit_license":"F008070","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"42EDPKP2XY1001461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:15:55.000000Z","updated_at":"2025-04-22T10:02:19.000000Z"}]},{"id":8227617,"change_date":"2025-03-27 21:41:00","inspection_id":"84243292","dot_number":"2167478","report_state":"MI","report_number":"HINCA00638","insp_date":"2025-03-25 00:00:00","insp_start_time":"1625","insp_end_time":"1640","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"E\/B M-32 @ MURNER RD","county_code_state":"MI","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16900","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":"1214932","transaction_code":"A","transaction_date":"2025-03-25 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2025-03-27 21:41:00","snet_input_date":"2025-03-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-27 21:41:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-30T10:38:35.000000Z","updated_at":"2025-03-31T10:30:30.000000Z","inspection_violations":[{"id":12908845,"change_date":"2025-03-27 21:41:00","inspection_id":"84243292","insp_violation_id":"265290192","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"206025961","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:51:03.000000Z","updated_at":"2025-03-31T10:51:31.000000Z","normalized_code":"3939ALTSI"},{"id":12908846,"change_date":"2025-03-27 21:41:00","inspection_id":"84243292","insp_violation_id":"265290193","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"206025960","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:51:03.000000Z","updated_at":"2025-03-31T10:51:31.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":13308967,"change_date":"2025-03-27 21:41:00","inspection_id":"84243292","insp_unit_id":"206025961","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUAS","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1L9PU1018JG423204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:25:05.000000Z","updated_at":"2025-03-31T10:05:04.000000Z"},{"id":13308966,"change_date":"2025-03-27 21:41:00","inspection_id":"84243292","insp_unit_id":"206025960","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"DF08619","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FT7W2B67DEA58027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:25:05.000000Z","updated_at":"2025-03-31T10:05:04.000000Z"}]},{"id":8034870,"change_date":"2025-03-05 21:40:00","inspection_id":"84040462","dot_number":"2167478","report_state":"MI","report_number":"BACZM02629","insp_date":"2025-03-04 00:00:00","insp_start_time":"1245","insp_end_time":"1310","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ DODGE RD","county_code_state":"MI","county_code":"049","insp_level_id":"1","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"30500","viol_total":"9","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1211912","transaction_code":"A","transaction_date":"2025-03-04 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2025-03-05 21:40:00","snet_input_date":"2025-03-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:58.000000Z","updated_at":"2025-03-17T21:04:58.000000Z","inspection_violations":[{"id":12556298,"change_date":"2025-03-05 21:40:00","inspection_id":"84040462","insp_violation_id":"264849347","seq_no":"1","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"205642013","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"3929A2C"},{"id":12556299,"change_date":"2025-03-05 21:40:00","inspection_id":"84040462","insp_violation_id":"264849348","seq_no":"2","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"205642014","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"39343DBMA"},{"id":12556300,"change_date":"2025-03-05 21:40:00","inspection_id":"84040462","insp_violation_id":"264849349","seq_no":"3","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"205642014","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"3963A1BOS"},{"id":12556301,"change_date":"2025-03-05 21:40:00","inspection_id":"84040462","insp_violation_id":"264849350","seq_no":"4","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"205642014","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"39348ABIHE"},{"id":12556302,"change_date":"2025-03-05 21:40:00","inspection_id":"84040462","insp_violation_id":"264849351","seq_no":"5","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"205642014","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"39348ABIHE"},{"id":12556303,"change_date":"2025-03-05 21:40:00","inspection_id":"84040462","insp_violation_id":"264849352","seq_no":"6","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"205642014","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"39348ABIHE"},{"id":12556304,"change_date":"2025-03-05 21:40:00","inspection_id":"84040462","insp_violation_id":"264849353","seq_no":"7","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"205642014","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"39348ABIHE"},{"id":12556305,"change_date":"2025-03-05 21:40:00","inspection_id":"84040462","insp_violation_id":"264849354","seq_no":"8","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"205642014","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"3939ALRLI"},{"id":12556306,"change_date":"2025-03-05 21:40:00","inspection_id":"84040462","insp_violation_id":"264849355","seq_no":"9","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"205642014","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":12971734,"change_date":"2025-03-05 21:40:00","inspection_id":"84040462","insp_unit_id":"205642013","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD41480","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4HT4GEB70179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:18.000000Z","updated_at":"2025-03-17T23:58:18.000000Z"},{"id":12971735,"change_date":"2025-03-05 21:40:00","inspection_id":"84040462","insp_unit_id":"205642014","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HURS","insp_unit_company":null,"insp_unit_license":"F117067","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H9T32223S1057329","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:18.000000Z","updated_at":"2025-03-17T23:58:18.000000Z"}]},{"id":6490243,"change_date":"2024-09-17 21:45:00","inspection_id":"82408371","dot_number":"2167478","report_state":"MI","report_number":"KLEIN03565","insp_date":"2024-08-14 00:00:00","insp_start_time":"0940","insp_end_time":"1034","registration_date":null,"region":"ET","ci_status_code":"C","location":"591","location_desc":"MIDLINK DR NEAR SPRINKLE RD","county_code_state":"MI","county_code":"077","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SA 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":"2024-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"43500","viol_total":"5","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1190442","transaction_code":"C","transaction_date":"2024-08-14 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2024-08-16 21:39:00","snet_input_date":"2024-08-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:35.000000Z","updated_at":"2025-03-17T20:31:35.000000Z","inspection_violations":[{"id":10077196,"change_date":"2024-09-17 21:45:00","inspection_id":"82408371","insp_violation_id":"261866986","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202981203","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4423994","created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"3922"},{"id":10077197,"change_date":"2024-09-17 21:45:00","inspection_id":"82408371","insp_violation_id":"261866987","seq_no":"2","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"202981203","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"3929A2"},{"id":10077198,"change_date":"2024-09-17 21:45:00","inspection_id":"82408371","insp_violation_id":"261866988","seq_no":"3","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"202981204","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"393104F3"},{"id":10077199,"change_date":"2024-09-17 21:45:00","inspection_id":"82408371","insp_violation_id":"261866989","seq_no":"4","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"202981204","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"X4423994","created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"393130"},{"id":10077200,"change_date":"2024-09-17 21:45:00","inspection_id":"82408371","insp_violation_id":"261866990","seq_no":"5","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":10461947,"change_date":"2024-09-17 21:45:00","inspection_id":"82408371","insp_unit_id":"202981203","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC56920","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD0W5HTXJEB42060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:23.000000Z","updated_at":"2025-03-17T23:31:23.000000Z"},{"id":10461948,"change_date":"2024-09-17 21:45:00","inspection_id":"82408371","insp_unit_id":"202981204","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BENKH","insp_unit_company":null,"insp_unit_license":"F005065","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4L5SC2921RF069333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:23.000000Z","updated_at":"2025-03-17T23:31:23.000000Z"}]},{"id":6220323,"change_date":"2024-09-16 21:43:00","inspection_id":"82119490","dot_number":"2167478","report_state":"MI","report_number":"FROSR00824","insp_date":"2024-07-11 00:00:00","insp_start_time":"1215","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ DODGE RD","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"30500","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1185269","transaction_code":"C","transaction_date":"2024-07-11 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2024-07-15 21:41:00","snet_input_date":"2024-07-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:09.000000Z","updated_at":"2025-03-17T20:26:09.000000Z","inspection_violations":[{"id":9661242,"change_date":"2024-09-16 21:43:00","inspection_id":"82119490","insp_violation_id":"261825981","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202945649","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"39348A"},{"id":9661243,"change_date":"2024-09-16 21:43:00","inspection_id":"82119490","insp_violation_id":"261825982","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"202945649","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"3963A1"},{"id":9661244,"change_date":"2024-09-16 21:43:00","inspection_id":"82119490","insp_violation_id":"261825983","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202945649","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"3939A"},{"id":9661245,"change_date":"2024-09-16 21:43:00","inspection_id":"82119490","insp_violation_id":"261825984","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202945649","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"3939A"},{"id":9661246,"change_date":"2024-09-16 21:43:00","inspection_id":"82119490","insp_violation_id":"261825985","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202945649","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"3939A"},{"id":9661247,"change_date":"2024-09-16 21:43:00","inspection_id":"82119490","insp_violation_id":"261825986","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202945649","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"39348A"},{"id":9661248,"change_date":"2024-09-16 21:43:00","inspection_id":"82119490","insp_violation_id":"261825987","seq_no":"5","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202945649","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"39348A"},{"id":9661249,"change_date":"2024-09-16 21:43:00","inspection_id":"82119490","insp_violation_id":"261825988","seq_no":"6","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202945649","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":10021764,"change_date":"2024-09-16 21:43:00","inspection_id":"82119490","insp_unit_id":"202945648","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD41480","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4HT4GEB70179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"},{"id":10021765,"change_date":"2024-09-16 21:43:00","inspection_id":"82119490","insp_unit_id":"202945649","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HURS","insp_unit_company":null,"insp_unit_license":"F117067","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H9T32223S1057329","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"}]},{"id":6103588,"change_date":"2024-06-28 21:39:00","inspection_id":"81993998","dot_number":"2167478","report_state":"MI","report_number":"EVANT02522","insp_date":"2024-06-27 00:00:00","insp_start_time":"1250","insp_end_time":"1305","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"THUMM RD NEAR DOBLESKI RD","county_code_state":"MI","county_code":"009","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"24800","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":"1183975","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2024-06-28 21:39:00","snet_input_date":"2024-06-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-28 21:39:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:44.000000Z","updated_at":"2025-03-17T20:23:44.000000Z","inspection_violations":[{"id":9473287,"change_date":"2024-06-28 21:39:00","inspection_id":"81993998","insp_violation_id":"260374247","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":9830885,"change_date":"2024-06-28 21:39:00","inspection_id":"81993998","insp_unit_id":"201646478","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"DE71390","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FT8W3B69EEA61247","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"},{"id":9830886,"change_date":"2024-06-28 21:39:00","inspection_id":"81993998","insp_unit_id":"201646479","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FORCE","insp_unit_company":null,"insp_unit_license":"F040474","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5NHUFA425RN072892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"}]},{"id":3845434,"change_date":"2023-08-30 21:45:00","inspection_id":"79520886","dot_number":"2167478","report_state":"MI","report_number":"PRIED02448","insp_date":"2023-08-25 00:00:00","insp_start_time":"0938","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US10 @ DEER LAKE","county_code_state":"MI","county_code":"085","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"30500","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1142847","transaction_code":"C","transaction_date":"2023-08-25 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2023-08-28 21:42:00","snet_input_date":"2023-08-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-28 21:42:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:54.000000Z","updated_at":"2025-03-17T19:38:54.000000Z","inspection_violations":[{"id":5939305,"change_date":"2023-08-30 21:45:00","inspection_id":"79520886","insp_violation_id":"254988047","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4265269","created_at":"2025-03-17T21:34:41.000000Z","updated_at":"2025-03-17T21:34:41.000000Z","normalized_code":"38323A2"},{"id":5939306,"change_date":"2023-08-30 21:45:00","inspection_id":"79520886","insp_violation_id":"254988048","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:41.000000Z","updated_at":"2025-03-17T21:34:41.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":6182642,"change_date":"2023-08-30 21:45:00","inspection_id":"79520886","insp_unit_id":"196816512","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD41480","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4HT4GEB70179","insp_unit_decal":"Y","insp_unit_decal_number":"33031764","created_at":"2025-03-17T22:51:56.000000Z","updated_at":"2025-03-17T22:51:56.000000Z"},{"id":6182643,"change_date":"2023-08-30 21:45:00","inspection_id":"79520886","insp_unit_id":"196816513","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BUTE","insp_unit_company":null,"insp_unit_license":"D056908","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1BUD18206N1009391","insp_unit_decal":"Y","insp_unit_decal_number":"33031768","created_at":"2025-03-17T22:51:56.000000Z","updated_at":"2025-03-17T22:51:56.000000Z"}]},{"id":3609681,"change_date":"2023-07-27 21:40:00","inspection_id":"79257218","dot_number":"2167478","report_state":"MI","report_number":"MCGEJ02918","insp_date":"2023-07-26 00:00:00","insp_start_time":"1618","insp_end_time":"1702","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"US127 SB @ N HIGGINS LAKE RD","county_code_state":"MI","county_code":"143","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":"2023-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1137245","transaction_code":"A","transaction_date":"2023-07-26 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2023-07-27 21:40:00","snet_input_date":"2023-07-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:13.000000Z","updated_at":"2025-03-17T19:34:13.000000Z","inspection_violations":[{"id":5566836,"change_date":"2023-07-27 21:40:00","inspection_id":"79257218","insp_violation_id":"254318972","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196228888","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3922"},{"id":5566837,"change_date":"2023-07-27 21:40:00","inspection_id":"79257218","insp_violation_id":"254318973","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196228888","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3939A"},{"id":5566838,"change_date":"2023-07-27 21:40:00","inspection_id":"79257218","insp_violation_id":"254318974","seq_no":"3","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"196228888","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"39351"}],"inspection_per_units":[{"id":5803717,"change_date":"2023-07-27 21:40:00","inspection_id":"79257218","insp_unit_id":"196228888","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BA13890","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTSCABN9VH486964","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:48.000000Z","updated_at":"2025-03-17T22:48:48.000000Z"}]},{"id":3304218,"change_date":"2023-06-16 21:40:00","inspection_id":"78914245","dot_number":"2167478","report_state":"MI","report_number":"DOWEM02433","insp_date":"2023-06-15 00:00:00","insp_start_time":"1015","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US131 NEAR M72","county_code_state":"MI","county_code":"079","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-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"29600","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":"1130578","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2023-06-16 21:40:00","snet_input_date":"2023-06-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-16 21:40:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:30.000000Z","updated_at":"2025-03-17T19:28:30.000000Z","inspection_violations":[{"id":5095424,"change_date":"2023-06-16 21:40:00","inspection_id":"78914245","insp_violation_id":"253552950","seq_no":"1","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"1","insp_unit_id":"195540910","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:40.000000Z","updated_at":"2025-03-17T21:30:40.000000Z","normalized_code":"39019B2"},{"id":5095425,"change_date":"2023-06-16 21:40:00","inspection_id":"78914245","insp_violation_id":"253552951","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195540910","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4236862","created_at":"2025-03-17T21:30:40.000000Z","updated_at":"2025-03-17T21:30:40.000000Z","normalized_code":"3922"},{"id":5095426,"change_date":"2023-06-16 21:40:00","inspection_id":"78914245","insp_violation_id":"253552952","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195540910","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:40.000000Z","updated_at":"2025-03-17T21:30:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5312201,"change_date":"2023-06-16 21:40:00","inspection_id":"78914245","insp_unit_id":"195540910","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"BC20120","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDE5E11X3F506752","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"},{"id":5312202,"change_date":"2023-06-16 21:40:00","inspection_id":"78914245","insp_unit_id":"195540911","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WOLV","insp_unit_company":null,"insp_unit_license":"E702428","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5BXH1CZ32NJ052660","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"}]},{"id":2799555,"change_date":"2023-04-13 21:43:00","inspection_id":"78343709","dot_number":"2167478","report_state":"MI","report_number":"FROSR00725","insp_date":"2023-04-13 00:00:00","insp_start_time":"1135","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M46 EB @ FORDNEY","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":"2023-04-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"4","oos_total":"2","driver_viol_total":"4","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1121761","transaction_code":"A","transaction_date":"2023-04-13 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2023-04-13 21:43:00","snet_input_date":"2023-04-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-13 21:43:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:08.000000Z","updated_at":"2025-03-17T19:18:08.000000Z","inspection_violations":[{"id":4296302,"change_date":"2023-04-13 21:43:00","inspection_id":"78343709","insp_violation_id":"252210823","seq_no":"1","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4188768","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"39111B5"},{"id":4296303,"change_date":"2023-04-13 21:43:00","inspection_id":"78343709","insp_violation_id":"252210824","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4188768","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"39141A"},{"id":4296304,"change_date":"2023-04-13 21:43:00","inspection_id":"78343709","insp_violation_id":"252210825","seq_no":"3","part_no":"392","part_no_section":"82(a)(1)","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:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"39282A1"},{"id":4296305,"change_date":"2023-04-13 21:43:00","inspection_id":"78343709","insp_violation_id":"252210826","seq_no":"4","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":4505769,"change_date":"2023-04-13 21:43:00","inspection_id":"78343709","insp_unit_id":"194375747","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"BC20120","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDE5E11X3F506752","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:32.000000Z","updated_at":"2025-03-17T22:38:32.000000Z"}]},{"id":1284618,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","dot_number":"2167478","report_state":"MI","report_number":"DOWEM02249","insp_date":"2022-09-14 00:00:00","insp_start_time":"1000","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M32 @ APPLEBEES","county_code_state":"MI","county_code":"137","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-09-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"39560","viol_total":"16","oos_total":"9","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"15","vehicle_oos_total":"8","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1094643","transaction_code":"A","transaction_date":"2022-09-14 00:00:00","upload_date":"2022-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2022-09-14 21:40:00","snet_input_date":"2022-09-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-14 21:40:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:26.000000Z","updated_at":"2025-03-17T18:50:26.000000Z","inspection_violations":[{"id":2032298,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408101","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4121583","created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"39141A1"},{"id":2032299,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408102","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"190896296","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"39021TB"},{"id":2032300,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408103","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190896296","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"39617C"},{"id":2032301,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408104","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190896296","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"39395A"},{"id":2032302,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408105","seq_no":"5","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"190896296","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"39395F"},{"id":2032303,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408106","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190896296","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4121583","created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"3922"},{"id":2032304,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408107","seq_no":"7","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"190896297","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4121583","created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"39375A"},{"id":2032305,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408108","seq_no":"8","part_no":"393","part_no_section":"75(f)","insp_viol_unit":"2","insp_unit_id":"190896297","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"39375F"},{"id":2032306,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408109","seq_no":"9","part_no":"393","part_no_section":"75(f)","insp_viol_unit":"2","insp_unit_id":"190896297","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"39375F"},{"id":2032307,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408110","seq_no":"10","part_no":"393","part_no_section":"75(f)","insp_viol_unit":"2","insp_unit_id":"190896297","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"39375F"},{"id":2032308,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408111","seq_no":"11","part_no":"393","part_no_section":"75(f)","insp_viol_unit":"2","insp_unit_id":"190896297","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"39375F"},{"id":2032309,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408112","seq_no":"12","part_no":"393","part_no_section":"75(f)","insp_viol_unit":"2","insp_unit_id":"190896297","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"39375F"},{"id":2032310,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408113","seq_no":"13","part_no":"393","part_no_section":"75(f)","insp_viol_unit":"2","insp_unit_id":"190896297","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"39375F"},{"id":2032311,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408114","seq_no":"14","part_no":"393","part_no_section":"75(f)","insp_viol_unit":"2","insp_unit_id":"190896297","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"39375F"},{"id":2032312,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408115","seq_no":"15","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"190896297","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"393130"},{"id":2032313,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_violation_id":"248408116","seq_no":"16","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190896297","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2067784,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_unit_id":"190896296","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC56917","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD0W5HT8LED98961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:11.000000Z","updated_at":"2025-03-17T22:21:11.000000Z"},{"id":2067785,"change_date":"2022-09-14 21:40:00","inspection_id":"76608374","insp_unit_id":"190896297","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ROAD","insp_unit_company":null,"insp_unit_license":"E672920","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"46UFU4023N1260439","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:11.000000Z","updated_at":"2025-03-17T22:21:11.000000Z"}]},{"id":255684,"change_date":"2022-06-09 21:42:00","inspection_id":"75398365","dot_number":"2167478","report_state":"MI","report_number":"ETPJN01107","insp_date":"2022-04-25 00:00:00","insp_start_time":"0939","insp_end_time":"0959","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"MI","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"45490","viol_total":"7","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1073446","transaction_code":"C","transaction_date":"2022-04-25 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02167478","upload_search_indicator":null,"census_search_date":"2022-04-26 21:41:00","snet_input_date":"2022-04-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-26 21:41:00","insp_carrier_name":"NC UNDERGROUND LLC","insp_carrier_street":"20720 GRATIOT ROAD","insp_carrier_city":"MERRILL","insp_carrier_state":"MI","insp_carrier_zip_code":"48637","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:55.000000Z","updated_at":"2025-03-17T18:31:55.000000Z","inspection_violations":[{"id":392096,"change_date":"2022-06-09 21:42:00","inspection_id":"75398365","insp_violation_id":"246332613","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"5297","created_at":"2025-03-17T21:08:54.000000Z","updated_at":"2025-03-17T21:08:54.000000Z","normalized_code":"38323A2"},{"id":392097,"change_date":"2022-06-09 21:42:00","inspection_id":"75398365","insp_violation_id":"246332614","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189144906","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:54.000000Z","updated_at":"2025-03-17T21:08:54.000000Z","normalized_code":"39617C"},{"id":392098,"change_date":"2022-06-09 21:42:00","inspection_id":"75398365","insp_violation_id":"246332615","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189144906","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:54.000000Z","updated_at":"2025-03-17T21:08:54.000000Z","normalized_code":"3939A"},{"id":392099,"change_date":"2022-06-09 21:42:00","inspection_id":"75398365","insp_violation_id":"246332616","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189144905","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:54.000000Z","updated_at":"2025-03-17T21:08:54.000000Z","normalized_code":"39617C"},{"id":392100,"change_date":"2022-06-09 21:42:00","inspection_id":"75398365","insp_violation_id":"246332617","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189144905","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:54.000000Z","updated_at":"2025-03-17T21:08:54.000000Z","normalized_code":"3939A"},{"id":392101,"change_date":"2022-06-09 21:42:00","inspection_id":"75398365","insp_violation_id":"246332618","seq_no":"6","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"189144905","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:54.000000Z","updated_at":"2025-03-17T21:08:54.000000Z","normalized_code":"39021TA"},{"id":392102,"change_date":"2022-06-09 21:42:00","inspection_id":"75398365","insp_violation_id":"246332619","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189144905","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:54.000000Z","updated_at":"2025-03-17T21:08:54.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":413937,"change_date":"2022-06-09 21:42:00","inspection_id":"75398365","insp_unit_id":"189144905","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC56926","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD0W5HT2JEC68235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:44.000000Z","updated_at":"2025-03-17T22:10:44.000000Z"},{"id":413938,"change_date":"2022-06-09 21:42:00","inspection_id":"75398365","insp_unit_id":"189144906","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"E086159","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"7JEPU1727KG000610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:44.000000Z","updated_at":"2025-03-17T22:10:44.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2167478\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2167478\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2167478\/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\/2167478\/inspections","per_page":100,"prev_page_url":null,"to":14,"total":14}