{"current_page":1,"data":[{"id":12532577,"change_date":"2026-07-23 21:41:00","inspection_id":"88498698","dot_number":"1407528","report_state":"MI","report_number":"ZAPFA01157","insp_date":"2026-07-23 00:00:00","insp_start_time":"1320","insp_end_time":"1435","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"013","insp_level_id":"1","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":"U","pen_cen_match":"I","final_status_date":"2026-07-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"79995","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3822172","transaction_code":"A","transaction_date":"2026-07-23 00:00:00","upload_date":"2026-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01407528","upload_search_indicator":null,"census_search_date":"2026-07-23 21:41:00","snet_input_date":"2026-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-23 21:41:00","insp_carrier_name":"NORTHERN UTILITY INC","insp_carrier_street":"10262 S POINT 75 ROAD","insp_carrier_city":"RAPID RIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-26T09:42:28.000000Z","updated_at":"2026-08-03T09:31:25.000000Z","inspection_violations":[{"id":21816830,"change_date":"2026-07-23 21:41:00","inspection_id":"88498698","insp_violation_id":"275694263","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"214786446","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-26T10:04:38.000000Z","updated_at":"2026-08-03T09:43:19.000000Z","normalized_code":"39617CPI"},{"id":21816831,"change_date":"2026-07-23 21:41:00","inspection_id":"88498698","insp_violation_id":"275694264","seq_no":"2","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"1","insp_unit_id":"214786446","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-26T10:04:38.000000Z","updated_at":"2026-08-03T09:43:19.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":21816833,"change_date":"2026-07-23 21:41:00","inspection_id":"88498698","insp_violation_id":"275694266","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"214786446","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-26T10:04:38.000000Z","updated_at":"2026-08-03T09:43:19.000000Z","normalized_code":"39353BB"},{"id":21816834,"change_date":"2026-07-23 21:41:00","inspection_id":"88498698","insp_violation_id":"275694267","seq_no":"5","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"214786446","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-26T10:04:38.000000Z","updated_at":"2026-08-03T09:43:19.000000Z","normalized_code":"39345DB"},{"id":21816835,"change_date":"2026-07-23 21:41:00","inspection_id":"88498698","insp_violation_id":"275694268","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"214786447","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-26T10:04:38.000000Z","updated_at":"2026-08-03T09:43:19.000000Z","normalized_code":"39617CPI"},{"id":21816836,"change_date":"2026-07-23 21:41:00","inspection_id":"88498698","insp_violation_id":"275694269","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"214786447","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-26T10:04:38.000000Z","updated_at":"2026-08-03T09:43:19.000000Z","normalized_code":"3922SLLSR"},{"id":21816837,"change_date":"2026-07-23 21:41:00","inspection_id":"88498698","insp_violation_id":"275694270","seq_no":"8","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"214786447","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-26T10:04:38.000000Z","updated_at":"2026-08-03T09:43:19.000000Z","normalized_code":"3939ALIL"},{"id":21816838,"change_date":"2026-07-23 21:41:00","inspection_id":"88498698","insp_violation_id":"275694271","seq_no":"9","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"214786447","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-26T10:04:38.000000Z","updated_at":"2026-08-03T09:43:19.000000Z","normalized_code":"3939ALSLI"},{"id":21816839,"change_date":"2026-07-23 21:41:00","inspection_id":"88498698","insp_violation_id":"275694272","seq_no":"10","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"214786447","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-26T10:04:38.000000Z","updated_at":"2026-08-03T09:43:19.000000Z","normalized_code":"3939ALTSI"},{"id":21816832,"change_date":"2026-07-23 21:41:00","inspection_id":"88498698","insp_violation_id":"275694265","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"214786446","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-26T10:04:38.000000Z","updated_at":"2026-08-03T09:43:19.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":21763449,"change_date":"2026-07-23 21:41:00","inspection_id":"88498698","insp_unit_id":"214786446","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB92308","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2HSCNAPR76C306369","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-26T09:20:24.000000Z","updated_at":"2026-08-03T09:05:46.000000Z"},{"id":21763450,"change_date":"2026-07-23 21:41:00","inspection_id":"88498698","insp_unit_id":"214786447","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"D062706","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"112H5V305TL046331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-26T09:20:24.000000Z","updated_at":"2026-08-03T09:05:46.000000Z"}]},{"id":12498107,"change_date":"2026-07-20 21:39:00","inspection_id":"88461783","dot_number":"1407528","report_state":"MI","report_number":"HINCA01183","insp_date":"2026-07-20 00:00:00","insp_start_time":"0955","insp_end_time":"1005","registration_date":null,"region":"ED","ci_status_code":"C","location":"ROAD","location_desc":"MI","county_code_state":"MI","county_code":"103","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":"U","pen_cen_match":"I","final_status_date":"2026-07-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25200","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3793882","transaction_code":"A","transaction_date":"2026-07-20 00:00:00","upload_date":"2026-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01407528","upload_search_indicator":null,"census_search_date":"2026-07-20 21:39:00","snet_input_date":"2026-07-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-20 21:39:00","insp_carrier_name":"NORTHERN UTILITY INC","insp_carrier_street":"10262 S POINT 75 ROAD","insp_carrier_city":"RAPID RIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-23T09:41:16.000000Z","updated_at":"2026-07-31T09:30:54.000000Z","inspection_violations":[{"id":21757094,"change_date":"2026-07-20 21:39:00","inspection_id":"88461783","insp_violation_id":"275614535","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4728753","created_at":"2026-07-23T10:01:33.000000Z","updated_at":"2026-07-31T09:43:07.000000Z","normalized_code":"39141APC"},{"id":21757095,"change_date":"2026-07-20 21:39:00","inspection_id":"88461783","insp_violation_id":"275614536","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"2","insp_unit_id":"214715363","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-23T10:01:33.000000Z","updated_at":"2026-07-31T09:43:07.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":21706048,"change_date":"2026-07-20 21:39:00","inspection_id":"88461783","insp_unit_id":"214715362","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BD07591","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4KYC83GF160221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-23T09:17:42.000000Z","updated_at":"2026-07-31T09:02:12.000000Z"},{"id":21706049,"change_date":"2026-07-20 21:39:00","inspection_id":"88461783","insp_unit_id":"214715363","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E582066","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HZBF1621KLAK1127","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-23T09:17:42.000000Z","updated_at":"2026-07-31T09:02:12.000000Z"}]},{"id":11847421,"change_date":"2026-05-07 21:39:00","inspection_id":"87783279","dot_number":"1407528","report_state":"MI","report_number":"LAUEJ02297","insp_date":"2026-05-07 00:00:00","insp_start_time":"0705","insp_end_time":"0755","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"153","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"78800","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3277718","transaction_code":"A","transaction_date":"2026-05-07 00:00:00","upload_date":"2026-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01407528","upload_search_indicator":null,"census_search_date":"2026-05-07 21:39:00","snet_input_date":"2026-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-07 21:39:00","insp_carrier_name":"NORTHERN UTILITY INC","insp_carrier_street":"10262 S POINT 75 ROAD","insp_carrier_city":"RAPID RIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-10T09:39:31.000000Z","updated_at":"2026-05-18T09:30:44.000000Z","inspection_violations":[{"id":20605105,"change_date":"2026-05-07 21:39:00","inspection_id":"87783279","insp_violation_id":"274104865","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"213427855","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:30.000000Z","updated_at":"2026-05-18T09:41:42.000000Z","normalized_code":"3939ALIL"},{"id":20605106,"change_date":"2026-05-07 21:39:00","inspection_id":"87783279","insp_violation_id":"274104866","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"213427855","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:30.000000Z","updated_at":"2026-05-18T09:41:42.000000Z","normalized_code":"3939ALRLI"},{"id":20605107,"change_date":"2026-05-07 21:39:00","inspection_id":"87783279","insp_violation_id":"274104867","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"213427855","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:30.000000Z","updated_at":"2026-05-18T09:41:42.000000Z","normalized_code":"39617CPI"},{"id":20605108,"change_date":"2026-05-07 21:39:00","inspection_id":"87783279","insp_violation_id":"274104868","seq_no":"4","part_no":"393","part_no_section":"130C-CHVE","insp_viol_unit":"2","insp_unit_id":"213427855","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-05-10T09:58:30.000000Z","updated_at":"2026-05-18T09:41:42.000000Z","normalized_code":"393130CCHVE"},{"id":20605109,"change_date":"2026-05-07 21:39:00","inspection_id":"87783279","insp_violation_id":"274104869","seq_no":"5","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"213427855","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:30.000000Z","updated_at":"2026-05-18T09:41:42.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":20603192,"change_date":"2026-05-07 21:39:00","inspection_id":"87783279","insp_unit_id":"213427854","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC39640","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2HSCNAPR87C360006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:46.000000Z","updated_at":"2026-05-18T09:03:04.000000Z"},{"id":20603193,"change_date":"2026-05-07 21:39:00","inspection_id":"87783279","insp_unit_id":"213427855","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"E404746","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"112H8V3217L073248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:46.000000Z","updated_at":"2026-05-18T09:03:04.000000Z"}]},{"id":11849883,"change_date":"2026-05-07 21:40:00","inspection_id":"87785913","dot_number":"1407528","report_state":"MI","report_number":"BROWP03054","insp_date":"2026-05-07 00:00:00","insp_start_time":"0710","insp_end_time":"0740","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"041","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"23200","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3279986","transaction_code":"A","transaction_date":"2026-05-07 00:00:00","upload_date":"2026-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01407528","upload_search_indicator":null,"census_search_date":"2026-05-07 21:40:00","snet_input_date":"2026-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-07 21:40:00","insp_carrier_name":"NORTHERN UTILITY INC","insp_carrier_street":"10262 S POINT 75 ROAD","insp_carrier_city":"RAPID RIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-10T09:39:34.000000Z","updated_at":"2026-05-18T09:31:01.000000Z","inspection_violations":[{"id":20608609,"change_date":"2026-05-07 21:40:00","inspection_id":"87785913","insp_violation_id":"274110346","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:47.000000Z","updated_at":"2026-05-18T09:42:18.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":20606938,"change_date":"2026-05-07 21:40:00","inspection_id":"87785913","insp_unit_id":"213432651","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"NIAG","insp_unit_company":null,"insp_unit_license":"E191875","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1N91R1219KN339027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:52.000000Z","updated_at":"2026-05-18T09:03:27.000000Z"},{"id":20606939,"change_date":"2026-05-07 21:40:00","inspection_id":"87785913","insp_unit_id":"213432652","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"BD59344","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GD421C89FF113918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:52.000000Z","updated_at":"2026-05-18T09:03:27.000000Z"}]},{"id":10438437,"change_date":"2025-12-15 21:39:00","inspection_id":"86570430","dot_number":"1407528","report_state":"MI","report_number":"AHOBL01312","insp_date":"2025-12-12 00:00:00","insp_start_time":"0955","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M35\/CR RN","county_code_state":"MI","county_code":"103","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25200","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1253751","transaction_code":"A","transaction_date":"2025-12-12 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01407528","upload_search_indicator":null,"census_search_date":"2025-12-15 21:39:00","snet_input_date":"2025-12-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-15 21:39:00","insp_carrier_name":"NORTHERN UTILITY INC","insp_carrier_street":"10262 S POINT 75 ROAD","insp_carrier_city":"RAPID RIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-18T10:30:42.000000Z","updated_at":"2025-12-26T10:30:55.000000Z","inspection_violations":[{"id":17505051,"change_date":"2025-12-15 21:39:00","inspection_id":"86570430","insp_violation_id":"270689898","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:30:56.000000Z","updated_at":"2025-12-26T10:31:37.000000Z","normalized_code":"3922SLLS3"},{"id":17505052,"change_date":"2025-12-15 21:39:00","inspection_id":"86570430","insp_violation_id":"270689899","seq_no":"2","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":null,"created_at":"2025-12-18T10:30:56.000000Z","updated_at":"2025-12-26T10:31:37.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":17462643,"change_date":"2025-12-15 21:39:00","inspection_id":"86570430","insp_unit_id":"210614072","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BD26235","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4KVEY1KF146323","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:36.000000Z","updated_at":"2025-12-26T10:01:03.000000Z"},{"id":17462644,"change_date":"2025-12-15 21:39:00","inspection_id":"86570430","insp_unit_id":"210614073","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LARO","insp_unit_company":null,"insp_unit_license":"E738365","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1L9LPUT2XNH280641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:36.000000Z","updated_at":"2025-12-26T10:01:03.000000Z"}]},{"id":9971932,"change_date":"2025-10-17 21:39:00","inspection_id":"86080619","dot_number":"1407528","report_state":"MI","report_number":"LARSC00136","insp_date":"2025-10-16 00:00:00","insp_start_time":"1440","insp_end_time":"1520","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ECONO FOODS PARKING LOT","county_code_state":"MI","county_code":"103","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"1246507","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01407528","upload_search_indicator":null,"census_search_date":"2025-10-17 21:39:00","snet_input_date":"2025-10-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-17 21:39:00","insp_carrier_name":"NORTHERN UTILITY INC","insp_carrier_street":"10262 S POINT 75 ROAD","insp_carrier_city":"RAPID RIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"MI","created_at":"2025-10-20T10:01:55.000000Z","updated_at":"2025-10-21T10:00:50.000000Z","inspection_violations":[{"id":16472292,"change_date":"2025-10-17 21:39:00","inspection_id":"86080619","insp_violation_id":"269368559","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:58.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":16557450,"change_date":"2025-10-17 21:39:00","inspection_id":"86080619","insp_unit_id":"209528867","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC39640","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2HSCNAPR87C360006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:47:06.000000Z","updated_at":"2025-10-21T09:46:09.000000Z"},{"id":16557451,"change_date":"2025-10-17 21:39:00","inspection_id":"86080619","insp_unit_id":"209528868","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNPUB","insp_unit_company":null,"insp_unit_license":"E404747","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"16JF02124X1032563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:47:06.000000Z","updated_at":"2025-10-21T09:46:09.000000Z"}]},{"id":8702334,"change_date":"2025-05-21 21:42:00","inspection_id":"84743303","dot_number":"1407528","report_state":"MI","report_number":"AHOBL01224","insp_date":"2025-05-21 00:00:00","insp_start_time":"1022","insp_end_time":"1032","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 41\/M28","county_code_state":"MI","county_code":"013","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"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":"18200","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":"1222344","transaction_code":"A","transaction_date":"2025-05-21 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01407528","upload_search_indicator":null,"census_search_date":"2025-05-21 21:42:00","snet_input_date":"2025-05-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"NORTHERN UTILITY INC","insp_carrier_street":"10262 S POINT 75 ROAD","insp_carrier_city":"RAPID RIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49878","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:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14220752,"change_date":"2025-05-21 21:42:00","inspection_id":"84743303","insp_unit_id":"206992463","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BC32923","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB7KZB63AF128766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:50.000000Z","updated_at":"2025-05-25T09:52:11.000000Z"},{"id":14220753,"change_date":"2025-05-21 21:42:00","inspection_id":"84743303","insp_unit_id":"206992464","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E191874","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1N91R1210KN339028","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:50.000000Z","updated_at":"2025-05-25T09:52:11.000000Z"}]},{"id":7593696,"change_date":"2025-01-14 21:55:00","inspection_id":"83577157","dot_number":"1407528","report_state":"MI","report_number":"BROWP02277","insp_date":"2025-01-09 00:00:00","insp_start_time":"0825","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-2 E\/B & KELLY ROAD","county_code_state":"MI","county_code":"153","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":"2025-01-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1206302","transaction_code":"C","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01407528","upload_search_indicator":null,"census_search_date":"2025-01-10 21:40:00","snet_input_date":"2025-01-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-10 21:40:00","insp_carrier_name":"NORTHERN UTILITY INC","insp_carrier_street":"10262 S POINT 75 ROAD","insp_carrier_city":"RAPID RIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:43.000000Z","updated_at":"2025-03-17T20:55:43.000000Z","inspection_violations":[{"id":11870273,"change_date":"2025-01-14 21:55:00","inspection_id":"83577157","insp_violation_id":"263994772","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"204827663","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3922SLLUCR"},{"id":11870274,"change_date":"2025-01-14 21:55:00","inspection_id":"83577157","insp_violation_id":"263994773","seq_no":"2","part_no":"392","part_no_section":"2-INAT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3922INAT"},{"id":11870275,"change_date":"2025-01-14 21:55:00","inspection_id":"83577157","insp_violation_id":"263994774","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"204827664","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3939ALIL"},{"id":11870276,"change_date":"2025-01-14 21:55:00","inspection_id":"83577157","insp_violation_id":"263994775","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204827663","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"39617CPI"},{"id":11870277,"change_date":"2025-01-14 21:55:00","inspection_id":"83577157","insp_violation_id":"263994776","seq_no":"5","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"204827663","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3939ALTSIR"},{"id":11870278,"change_date":"2025-01-14 21:55:00","inspection_id":"83577157","insp_violation_id":"263994777","seq_no":"6","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"204827664","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":12252615,"change_date":"2025-01-14 21:55:00","inspection_id":"83577157","insp_unit_id":"204827663","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB92308","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2HSCNAPR76C306369","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:14.000000Z","updated_at":"2025-03-17T23:50:14.000000Z"},{"id":12252616,"change_date":"2025-01-14 21:55:00","inspection_id":"83577157","insp_unit_id":"204827664","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUCON","insp_unit_company":null,"insp_unit_license":"E981607","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1L9PU2028EG423403","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:14.000000Z","updated_at":"2025-03-17T23:50:14.000000Z"}]},{"id":7174299,"change_date":"2024-11-12 21:42:00","inspection_id":"83135677","dot_number":"1407528","report_state":"MI","report_number":"BYARC01280","insp_date":"2024-11-07 00:00:00","insp_start_time":"1346","insp_end_time":"1405","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M28 \/ US141","county_code_state":"MI","county_code":"013","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26700","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1201149","transaction_code":"A","transaction_date":"2024-11-07 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01407528","upload_search_indicator":null,"census_search_date":"2024-11-12 21:42:00","snet_input_date":"2024-11-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-12 21:42:00","insp_carrier_name":"NORTHERN UTILITY INC","insp_carrier_street":"10262 S POINT 75 ROAD","insp_carrier_city":"RAPID RIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:36.000000Z","updated_at":"2025-03-17T20:45:36.000000Z","inspection_violations":[{"id":11208338,"change_date":"2024-11-12 21:42:00","inspection_id":"83135677","insp_violation_id":"262848186","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"3922SLLS3"},{"id":11208339,"change_date":"2024-11-12 21:42:00","inspection_id":"83135677","insp_violation_id":"262848187","seq_no":"2","part_no":"391","part_no_section":"41A1-MCOOS","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-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"39141A1MCOOS"}],"inspection_per_units":[{"id":11571866,"change_date":"2024-11-12 21:42:00","inspection_id":"83135677","insp_unit_id":"203841420","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"BD79602","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3C7WRNAL7FG544816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"},{"id":11571867,"change_date":"2024-11-12 21:42:00","inspection_id":"83135677","insp_unit_id":"203841421","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALUM","insp_unit_company":null,"insp_unit_license":"D645362","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5JX1C1223HE207485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"}]},{"id":6632016,"change_date":"2024-09-17 21:46:00","inspection_id":"82559421","dot_number":"1407528","report_state":"MI","report_number":"WERNR01324","insp_date":"2024-08-28 00:00:00","insp_start_time":"1119","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"POWER SCALE","county_code_state":"MI","county_code":"109","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-09-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19750","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":"1192783","transaction_code":"C","transaction_date":"2024-08-28 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01407528","upload_search_indicator":null,"census_search_date":"2024-09-03 21:42:00","snet_input_date":"2024-08-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-03 21:42:00","insp_carrier_name":"NORTHERN UTILITY","insp_carrier_street":"10262 S POINT 75 ROAD","insp_carrier_city":"RAPID RIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:28.000000Z","updated_at":"2025-03-17T20:34:28.000000Z","inspection_violations":[{"id":10315555,"change_date":"2024-09-17 21:46:00","inspection_id":"82559421","insp_violation_id":"261873449","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202986723","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"3939A"},{"id":10315556,"change_date":"2024-09-17 21:46:00","inspection_id":"82559421","insp_violation_id":"261873450","seq_no":"2","part_no":"393","part_no_section":"25(f)","insp_viol_unit":"2","insp_unit_id":"202986723","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"39325F"},{"id":10315557,"change_date":"2024-09-17 21:46:00","inspection_id":"82559421","insp_violation_id":"261873451","seq_no":"3","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"202986723","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"393205C"},{"id":10315558,"change_date":"2024-09-17 21:46:00","inspection_id":"82559421","insp_violation_id":"261873452","seq_no":"4","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"202986723","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":10692403,"change_date":"2024-09-17 21:46:00","inspection_id":"82559421","insp_unit_id":"202986722","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"BD59344","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GD421C89FF113918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"},{"id":10692404,"change_date":"2024-09-17 21:46:00","inspection_id":"82559421","insp_unit_id":"202986723","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"B581548","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"D791641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"}]},{"id":3043552,"change_date":"2023-05-15 21:42:00","inspection_id":"78619903","dot_number":"1407528","report_state":"MI","report_number":"STOLJ00580","insp_date":"2023-05-10 00:00:00","insp_start_time":"1853","insp_end_time":"1952","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 2 @ RIVER RD","county_code_state":"MI","county_code":"153","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"2023-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"13025","viol_total":"6","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1125862","transaction_code":"A","transaction_date":"2023-05-10 00:00:00","upload_date":"2023-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01407528","upload_search_indicator":null,"census_search_date":"2023-05-15 21:42:00","snet_input_date":"2023-05-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-15 21:42:00","insp_carrier_name":"NORTHERN UTILITY","insp_carrier_street":"10262 S POINT 75 ROAD","insp_carrier_city":"RAPID RIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:21.000000Z","updated_at":"2025-03-17T19:23:21.000000Z","inspection_violations":[{"id":4674922,"change_date":"2023-05-15 21:42:00","inspection_id":"78619903","insp_violation_id":"252828183","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4192096","created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"3922"},{"id":4674923,"change_date":"2023-05-15 21:42:00","inspection_id":"78619903","insp_violation_id":"252828184","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:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"39141A"},{"id":4674924,"change_date":"2023-05-15 21:42:00","inspection_id":"78619903","insp_violation_id":"252828185","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"194928116","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"39021TB"},{"id":4674925,"change_date":"2023-05-15 21:42:00","inspection_id":"78619903","insp_violation_id":"252828186","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194928116","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"39395A"},{"id":4674926,"change_date":"2023-05-15 21:42:00","inspection_id":"78619903","insp_violation_id":"252828187","seq_no":"5","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"194928116","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"39395F"},{"id":4674927,"change_date":"2023-05-15 21:42:00","inspection_id":"78619903","insp_violation_id":"252828188","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194928116","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4896203,"change_date":"2023-05-15 21:42:00","inspection_id":"78619903","insp_unit_id":"194928116","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"NONE","insp_unit_license":"BC72550","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC5KZC88DZ205573","insp_unit_decal":"Y","insp_unit_decal_number":"32662479","created_at":"2025-03-17T22:41:36.000000Z","updated_at":"2025-03-17T22:41:36.000000Z"}]},{"id":748450,"change_date":"2022-07-05 21:42:00","inspection_id":"75983615","dot_number":"1407528","report_state":"MI","report_number":"BYARC00620","insp_date":"2022-07-01 00:00:00","insp_start_time":"1309","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US41 \/ MILLER-RADFORD LOT","county_code_state":"MI","county_code":"103","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"78000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1082686","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01407528","upload_search_indicator":null,"census_search_date":"2022-07-05 21:42:00","snet_input_date":"2022-07-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"NORTHERN UTILITY","insp_carrier_street":"10262 S POINT 75 ROAD","insp_carrier_city":"RAPID RIVER","insp_carrier_state":"MI","insp_carrier_zip_code":"49878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:53.000000Z","updated_at":"2025-03-17T18:40:53.000000Z","inspection_violations":[{"id":1177915,"change_date":"2022-07-05 21:42:00","inspection_id":"75983615","insp_violation_id":"246884485","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189600228","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"3939A"},{"id":1177916,"change_date":"2022-07-05 21:42:00","inspection_id":"75983615","insp_violation_id":"246884486","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189600228","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"3939A"},{"id":1177917,"change_date":"2022-07-05 21:42:00","inspection_id":"75983615","insp_violation_id":"246884487","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189600229","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"3939A"},{"id":1177918,"change_date":"2022-07-05 21:42:00","inspection_id":"75983615","insp_violation_id":"246884488","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189600228","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":1203408,"change_date":"2022-07-05 21:42:00","inspection_id":"75983615","insp_unit_id":"189600228","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"AD01567","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSFMAER8YN061134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:34.000000Z","updated_at":"2025-03-17T22:15:34.000000Z"},{"id":1203409,"change_date":"2022-07-05 21:42:00","inspection_id":"75983615","insp_unit_id":"189600229","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"D062706","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"112H5V305TL046331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:34.000000Z","updated_at":"2025-03-17T22:15:34.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1407528\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1407528\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1407528\/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\/1407528\/inspections","per_page":100,"prev_page_url":null,"to":12,"total":12}