{"current_page":1,"data":[{"id":12683721,"change_date":"2026-08-10 21:41:00","inspection_id":"88657478","dot_number":"3851764","report_state":"MI","report_number":"BESSJ01628","insp_date":"2026-08-10 00:00:00","insp_start_time":"1550","insp_end_time":"1625","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"8000","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":"3950289","transaction_code":"A","transaction_date":"2026-08-10 00:00:00","upload_date":"2026-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2026-08-10 21:41:00","snet_input_date":"2026-08-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-10 21:41:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HWY","insp_carrier_city":"IRA","insp_carrier_state":"MI","insp_carrier_zip_code":"48023-1221","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-13T09:40:30.000000Z","updated_at":"2026-08-16T09:36:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22013903,"change_date":"2026-08-10 21:41:00","inspection_id":"88657478","insp_unit_id":"215075914","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"247-15","insp_unit_license":"B03133","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4EX7FJ464890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-13T09:18:16.000000Z","updated_at":"2026-08-16T09:12:31.000000Z"}]},{"id":12664051,"change_date":"2026-08-07 21:40:00","inspection_id":"88636815","dot_number":"3851764","report_state":"MI","report_number":"BARTT05607","insp_date":"2026-08-07 00:00:00","insp_start_time":"0741","insp_end_time":"0802","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"087","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"196000","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":"3932365","transaction_code":"A","transaction_date":"2026-08-07 00:00:00","upload_date":"2026-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2026-08-07 21:40:00","snet_input_date":"2026-08-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-07 21:40:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HWY","insp_carrier_city":"IRA","insp_carrier_state":"MI","insp_carrier_zip_code":"48023-1221","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-11T09:42:04.000000Z","updated_at":"2026-08-16T09:34:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21981264,"change_date":"2026-08-07 21:40:00","inspection_id":"88636815","insp_unit_id":"215038715","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"203-20","insp_unit_license":"BC46528","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXP4EX6LD712094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-10T09:19:53.000000Z","updated_at":"2026-08-16T09:08:14.000000Z"},{"id":21981265,"change_date":"2026-08-07 21:40:00","inspection_id":"88636815","insp_unit_id":"215038716","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"TRKG","insp_unit_company":null,"insp_unit_license":"E243595","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKR00518DM078381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-10T09:19:53.000000Z","updated_at":"2026-08-16T09:08:14.000000Z"}]},{"id":12124436,"change_date":"2026-06-09 10:49:00","inspection_id":"88070134","dot_number":"3851764","report_state":"MI","report_number":"MOREM06474","insp_date":"2026-06-08 00:00:00","insp_start_time":"0555","insp_end_time":"0826","registration_date":null,"region":"ES","ci_status_code":"C","location":"122","location_desc":"MI","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-09 10:49:00","post_acc_ind":"N","gross_comb_veh_wt":"164600","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":"3490289","transaction_code":"A","transaction_date":"2026-06-08 00:00:00","upload_date":"2026-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2026-06-09 10:49:00","snet_input_date":"2026-06-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-09 10:49:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"51001","created_at":"2026-06-12T09:39:42.000000Z","updated_at":"2026-06-20T09:30:49.000000Z","inspection_violations":[{"id":21101350,"change_date":"2026-06-09 10:49:00","inspection_id":"88070134","insp_violation_id":"274756764","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213964526","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:57:53.000000Z","updated_at":"2026-06-19T09:43:37.000000Z","normalized_code":"39347E"},{"id":21101351,"change_date":"2026-06-09 10:49:00","inspection_id":"88070134","insp_violation_id":"274756765","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213964526","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:57:53.000000Z","updated_at":"2026-06-19T09:43:37.000000Z","normalized_code":"39347E"},{"id":21101353,"change_date":"2026-06-09 10:49:00","inspection_id":"88070134","insp_violation_id":"274756767","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"213964527","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-12T09:57:53.000000Z","updated_at":"2026-06-19T09:43:37.000000Z","normalized_code":"39375A3TAOL"},{"id":21101352,"change_date":"2026-06-09 10:49:00","inspection_id":"88070134","insp_violation_id":"274756766","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"213964526","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:57:53.000000Z","updated_at":"2026-06-19T09:43:37.000000Z","normalized_code":"39353BB"},{"id":21101354,"change_date":"2026-06-09 10:49:00","inspection_id":"88070134","insp_violation_id":"274756768","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"213964527","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4710547","created_at":"2026-06-12T09:57:53.000000Z","updated_at":"2026-06-19T09:43:37.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":21065323,"change_date":"2026-06-09 10:49:00","inspection_id":"88070134","insp_unit_id":"213964526","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"96-08","insp_unit_license":"BE26825","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPWDBEXX8D762447","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:01.000000Z","updated_at":"2026-06-20T09:02:06.000000Z"},{"id":21065324,"change_date":"2026-06-09 10:49:00","inspection_id":"88070134","insp_unit_id":"213964527","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PRESV","insp_unit_company":"VT-6K-13-SS","insp_unit_license":"E967052","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9S25384D1005011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:01.000000Z","updated_at":"2026-06-20T09:02:06.000000Z"}]},{"id":11963130,"change_date":"2026-05-19 21:40:00","inspection_id":"87899399","dot_number":"3851764","report_state":"MI","report_number":"MOREM06436","insp_date":"2026-05-19 00:00:00","insp_start_time":"1405","insp_end_time":"1455","registration_date":null,"region":"ES","ci_status_code":"C","location":"122","location_desc":"MI","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3362854","transaction_code":"A","transaction_date":"2026-05-19 00:00:00","upload_date":"2026-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2026-05-19 21:40:00","snet_input_date":"2026-05-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-19 21:40:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"51001","created_at":"2026-05-22T09:41:13.000000Z","updated_at":"2026-05-30T09:30:54.000000Z","inspection_violations":[{"id":20808815,"change_date":"2026-05-19 21:40:00","inspection_id":"87899399","insp_violation_id":"274367350","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"213645248","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:34.000000Z","updated_at":"2026-05-30T09:41:22.000000Z","normalized_code":"3922SLL"},{"id":20808816,"change_date":"2026-05-19 21:40:00","inspection_id":"87899399","insp_violation_id":"274367351","seq_no":"2","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"213645249","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-22T10:01:34.000000Z","updated_at":"2026-05-30T09:41:22.000000Z","normalized_code":"3939ALSLIWR"},{"id":20808817,"change_date":"2026-05-19 21:40:00","inspection_id":"87899399","insp_violation_id":"274367352","seq_no":"3","part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"2","insp_unit_id":"213645249","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-22T10:01:34.000000Z","updated_at":"2026-05-30T09:41:22.000000Z","normalized_code":"393134BCRHLC"},{"id":20808818,"change_date":"2026-05-19 21:40:00","inspection_id":"87899399","insp_violation_id":"274367353","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"213645249","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:34.000000Z","updated_at":"2026-05-30T09:41:22.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":20800447,"change_date":"2026-05-19 21:40:00","inspection_id":"87899399","insp_unit_id":"213645248","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"220-18","insp_unit_license":"BC64987","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X8JJ200396","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-22T09:21:47.000000Z","updated_at":"2026-05-30T09:03:07.000000Z"},{"id":20800448,"change_date":"2026-05-19 21:40:00","inspection_id":"87899399","insp_unit_id":"213645249","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DUNRI","insp_unit_company":"RO-97","insp_unit_license":"D555107","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1D9R03849VC232423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-22T09:21:47.000000Z","updated_at":"2026-05-30T09:03:07.000000Z"}]},{"id":11892842,"change_date":"2026-05-13 21:41:00","inspection_id":"87831114","dot_number":"3851764","report_state":"MI","report_number":"DELMT02641","insp_date":"2026-05-12 00:00:00","insp_start_time":"1515","insp_end_time":"1600","registration_date":null,"region":"ES","ci_status_code":"C","location":"131","location_desc":"MI","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MOSCOW","shipping_paper_number":"88264601","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-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"197000","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":"3308225","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2026-05-13 21:41:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-13 21:41:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:48.000000Z","updated_at":"2026-05-24T09:30:42.000000Z","inspection_violations":[{"id":20686482,"change_date":"2026-05-13 21:41:00","inspection_id":"87831114","insp_violation_id":"274217108","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:58:46.000000Z","updated_at":"2026-05-24T09:43:44.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":20677380,"change_date":"2026-05-13 21:41:00","inspection_id":"87831114","insp_unit_id":"213518406","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BD29107","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X0NF471313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:13:26.000000Z","updated_at":"2026-05-24T09:03:43.000000Z"},{"id":20677381,"change_date":"2026-05-13 21:41:00","inspection_id":"87831114","insp_unit_id":"213518407","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"E944332","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2L385NR075961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:13:26.000000Z","updated_at":"2026-05-24T09:03:43.000000Z"},{"id":20677382,"change_date":"2026-05-13 21:41:00","inspection_id":"87831114","insp_unit_id":"213518408","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"E944331","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W2H583NR075962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:13:26.000000Z","updated_at":"2026-05-24T09:03:43.000000Z"}]},{"id":11501286,"change_date":"2026-03-27 21:40:00","inspection_id":"87421404","dot_number":"3851764","report_state":"MI","report_number":"BARTT05400","insp_date":"2026-03-25 00:00:00","insp_start_time":"1341","insp_end_time":"1358","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/BI69@MORRIS","county_code_state":"MI","county_code":"087","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":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1264351","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2026-03-27 21:40:00","snet_input_date":"2026-03-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:45.000000Z","updated_at":"2026-04-07T09:32:30.000000Z","inspection_violations":[{"id":19420693,"change_date":"2026-03-27 21:40:00","inspection_id":"87421404","insp_violation_id":"272692630","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4662071","created_at":"2026-03-30T10:20:07.000000Z","updated_at":"2026-04-07T09:48:47.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":19703198,"change_date":"2026-03-27 21:40:00","inspection_id":"87421404","insp_unit_id":"212384840","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD46137","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPCXPEX9PD857954","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:25.000000Z","updated_at":"2026-04-07T09:08:54.000000Z"}]},{"id":11399109,"change_date":"2026-03-17 21:39:00","inspection_id":"87314057","dot_number":"3851764","report_state":"MI","report_number":"BARTT05376","insp_date":"2026-03-17 00:00:00","insp_start_time":"1303","insp_end_time":"1321","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/BI69@LAKE NEPESSING","county_code_state":"MI","county_code":"087","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":"2026-03-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1262730","transaction_code":"A","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2026-03-17 21:39:00","snet_input_date":"2026-03-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-17 21:39:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-20T09:42:39.000000Z","updated_at":"2026-03-28T09:31:26.000000Z","inspection_violations":[{"id":19215683,"change_date":"2026-03-17 21:39:00","inspection_id":"87314057","insp_violation_id":"272455124","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-20T10:03:46.000000Z","updated_at":"2026-03-28T09:47:00.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":19522320,"change_date":"2026-03-17 21:39:00","inspection_id":"87314057","insp_unit_id":"212183930","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"190-13","insp_unit_license":"BC80280","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPTX7EX9DD176091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:29.000000Z","updated_at":"2026-03-28T09:05:45.000000Z"}]},{"id":11057062,"change_date":"2026-02-05 21:39:00","inspection_id":"86967124","dot_number":"3851764","report_state":"MI","report_number":"HUFFR00383","insp_date":"2026-02-04 00:00:00","insp_start_time":"1335","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US23 @ 13MM","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1258142","transaction_code":"A","transaction_date":"2026-02-04 00:00:00","upload_date":"2026-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2026-02-05 21:39:00","snet_input_date":"2026-02-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-05 21:39:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-08T10:37:22.000000Z","updated_at":"2026-02-16T10:30:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18852209,"change_date":"2026-02-05 21:39:00","inspection_id":"86967124","insp_unit_id":"211463134","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"232-22","insp_unit_license":"BC80241","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXP4EX1ND769550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-08T10:14:16.000000Z","updated_at":"2026-02-16T10:04:18.000000Z"},{"id":18852210,"change_date":"2026-02-05 21:39:00","inspection_id":"86967124","insp_unit_id":"211463135","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"LB27522","insp_unit_license":"E607105","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKJ05743NM108275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-08T10:14:16.000000Z","updated_at":"2026-02-16T10:04:18.000000Z"}]},{"id":10438546,"change_date":"2025-12-15 21:39:00","inspection_id":"86570544","dot_number":"3851764","report_state":"MI","report_number":"LEONP00623","insp_date":"2025-12-12 00:00:00","insp_start_time":"0755","insp_end_time":"0806","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"MI","county_code":"159","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1253687","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":"03851764","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":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-18T10:30:43.000000Z","updated_at":"2025-12-26T10:30:56.000000Z","inspection_violations":[{"id":17505225,"change_date":"2025-12-15 21:39:00","inspection_id":"86570544","insp_violation_id":"270690086","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:30:57.000000Z","updated_at":"2025-12-26T10:31:39.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":17462824,"change_date":"2025-12-15 21:39:00","inspection_id":"86570544","insp_unit_id":"210614272","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC46565","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDLP0XOCR329665","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:36.000000Z","updated_at":"2025-12-26T10:01:04.000000Z"}]},{"id":9838552,"change_date":"2025-10-02 21:42:00","inspection_id":"85939840","dot_number":"3851764","report_state":"MI","report_number":"MOREM06152","insp_date":"2025-09-30 00:00:00","insp_start_time":"1255","insp_end_time":"1355","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HOLT REST AREA","county_code_state":"MI","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HEIDELBERG MATERIALS","shipping_paper_number":"1755079385","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"222000","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":"1244227","transaction_code":"A","transaction_date":"2025-09-30 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2025-10-02 21:42:00","snet_input_date":"2025-09-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-02 21:42:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"51001","created_at":"2025-10-05T10:01:55.000000Z","updated_at":"2025-10-05T10:01:55.000000Z","inspection_violations":[{"id":16200563,"change_date":"2025-10-02 21:42:00","inspection_id":"85939840","insp_violation_id":"269059469","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4602023","created_at":"2025-10-05T10:17:40.000000Z","updated_at":"2025-10-05T10:17:40.000000Z","normalized_code":"3922SLLEWG1"}],"inspection_per_units":[{"id":16314951,"change_date":"2025-10-02 21:42:00","inspection_id":"85939840","insp_unit_id":"209265636","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"296-25","insp_unit_license":"BD20606","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD40X8SR173965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:59.000000Z","updated_at":"2025-10-05T09:46:59.000000Z"},{"id":16314952,"change_date":"2025-10-02 21:42:00","inspection_id":"85939840","insp_unit_id":"209265637","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"DP-9546-AA","insp_unit_license":"F038151","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA3155SC076690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:59.000000Z","updated_at":"2025-10-05T09:46:59.000000Z"},{"id":16314953,"change_date":"2025-10-02 21:42:00","inspection_id":"85939840","insp_unit_id":"209265638","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"DP-9546-AB","insp_unit_license":"F038152","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2034SC076691","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:59.000000Z","updated_at":"2025-10-05T09:46:59.000000Z"}]},{"id":9807659,"change_date":"2025-10-02 21:42:00","inspection_id":"85907497","dot_number":"3851764","report_state":"MI","report_number":"SHEPZ05350","insp_date":"2025-09-26 00:00:00","insp_start_time":"0940","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"VALICOR ENVIRONMENTAL","shipping_paper_number":"21480275","cargo_tank":"412","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","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":"1243623","transaction_code":"C","transaction_date":"2025-09-26 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2025-09-29 21:39:00","snet_input_date":"2025-09-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-29 21:39:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-02T10:00:23.000000Z","updated_at":"2025-10-05T10:01:44.000000Z","inspection_violations":[{"id":16193795,"change_date":"2025-10-02 21:42:00","inspection_id":"85907497","insp_violation_id":"269057135","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4600656","created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":16307395,"change_date":"2025-10-02 21:42:00","inspection_id":"85907497","insp_unit_id":"209263807","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"149-16","insp_unit_license":"BC05420","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPXGGGG20D317852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:54.000000Z","updated_at":"2025-10-05T09:46:54.000000Z"},{"id":16307396,"change_date":"2025-10-02 21:42:00","inspection_id":"85907497","insp_unit_id":"209263808","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PRESV","insp_unit_company":null,"insp_unit_license":"F262184","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9S2538X81005004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:54.000000Z","updated_at":"2025-10-05T09:46:54.000000Z"}]},{"id":9730119,"change_date":"2025-09-19 21:39:00","inspection_id":"85826223","dot_number":"3851764","report_state":"MI","report_number":"CORBJ00278","insp_date":"2025-09-18 00:00:00","insp_start_time":"0830","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AA GRANGE HALL","shipping_paper_number":"33176726","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"213000","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":"1242293","transaction_code":"A","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2025-09-19 21:39:00","snet_input_date":"2025-09-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-19 21:39:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:45.000000Z","updated_at":"2025-09-23T10:02:45.000000Z","inspection_violations":[{"id":15975848,"change_date":"2025-09-19 21:39:00","inspection_id":"85826223","insp_violation_id":"268808626","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:18:30.000000Z","updated_at":"2025-09-23T10:16:30.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":16113128,"change_date":"2025-09-19 21:39:00","inspection_id":"85826223","insp_unit_id":"209049029","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCOA","insp_unit_company":"N\/A","insp_unit_license":"F251351","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2059TC086345","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:05.000000Z","updated_at":"2025-09-23T09:46:06.000000Z"},{"id":16113129,"change_date":"2025-09-19 21:39:00","inspection_id":"85826223","insp_unit_id":"209049030","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"279-24","insp_unit_license":"BD96064","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X8RD682220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:05.000000Z","updated_at":"2025-09-23T09:46:06.000000Z"},{"id":16113130,"change_date":"2025-09-19 21:39:00","inspection_id":"85826223","insp_unit_id":"209049031","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":"N\/A","insp_unit_license":"F251350","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2538TC086344","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:05.000000Z","updated_at":"2025-09-23T09:46:06.000000Z"}]},{"id":9696200,"change_date":"2025-09-16 21:40:00","inspection_id":"85790548","dot_number":"3851764","report_state":"MI","report_number":"HADZM04899","insp_date":"2025-09-12 00:00:00","insp_start_time":"1645","insp_end_time":"1720","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-75 @ MM9","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1241443","transaction_code":"A","transaction_date":"2025-09-12 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2025-09-16 21:40:00","snet_input_date":"2025-09-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-16 21:40:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:01:01.000000Z","updated_at":"2025-09-23T10:01:06.000000Z","inspection_violations":[{"id":15908222,"change_date":"2025-09-16 21:40:00","inspection_id":"85790548","insp_violation_id":"268730029","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"208981474","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:51.000000Z","normalized_code":"39395A1"},{"id":15908223,"change_date":"2025-09-16 21:40:00","inspection_id":"85790548","insp_violation_id":"268730030","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"208981474","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:51.000000Z","normalized_code":"3939ALHLI"},{"id":15908224,"change_date":"2025-09-16 21:40:00","inspection_id":"85790548","insp_violation_id":"268730031","seq_no":"3","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"208981474","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:51.000000Z","normalized_code":"39360D"},{"id":15908225,"change_date":"2025-09-16 21:40:00","inspection_id":"85790548","insp_violation_id":"268730032","seq_no":"4","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"208981475","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:51.000000Z","normalized_code":"393100BC"},{"id":15908226,"change_date":"2025-09-16 21:40:00","inspection_id":"85790548","insp_violation_id":"268730033","seq_no":"5","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"208981475","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:51.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":16050840,"change_date":"2025-09-16 21:40:00","inspection_id":"85790548","insp_unit_id":"208981474","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"214-20","insp_unit_license":"BE41240","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC1YLE76LF253118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:43.000000Z","updated_at":"2025-09-20T09:45:31.000000Z"},{"id":16050841,"change_date":"2025-09-16 21:40:00","inspection_id":"85790548","insp_unit_id":"208981475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ROAD","insp_unit_company":"TAG144-23","insp_unit_license":"E869720","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"46UFU1424P1265144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:43.000000Z","updated_at":"2025-09-20T09:45:31.000000Z"}]},{"id":9515707,"change_date":"2025-08-27 21:39:00","inspection_id":"85601144","dot_number":"3851764","report_state":"OH","report_number":"0634000078","insp_date":"2025-08-25 00:00:00","insp_start_time":"0909","insp_end_time":"0950","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NEVADA OH","county_code_state":"OH","county_code":"175","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ML CHARTIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2181068","transaction_code":"A","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2025-08-27 21:39:00","snet_input_date":"2025-08-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-27 21:39:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-05T10:47:05.000000Z","updated_at":"2025-09-06T10:41:01.000000Z","inspection_violations":[{"id":15525485,"change_date":"2025-08-27 21:39:00","inspection_id":"85601144","insp_violation_id":"268271714","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208600789","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:50:06.000000Z","updated_at":"2025-09-06T10:43:46.000000Z","normalized_code":"39617CPI"},{"id":15525486,"change_date":"2025-08-27 21:39:00","inspection_id":"85601144","insp_violation_id":"268271715","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208600790","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:50:06.000000Z","updated_at":"2025-09-06T10:43:46.000000Z","normalized_code":"39617CPI"},{"id":15525487,"change_date":"2025-08-27 21:39:00","inspection_id":"85601144","insp_violation_id":"268271716","seq_no":"3","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:50:06.000000Z","updated_at":"2025-09-06T10:43:46.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":15702902,"change_date":"2025-08-27 21:39:00","inspection_id":"85601144","insp_unit_id":"208600789","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"214-20","insp_unit_license":"DD77236","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC1YLE76LF253118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:31.000000Z","updated_at":"2025-09-09T09:45:09.000000Z"},{"id":15702903,"change_date":"2025-08-27 21:39:00","inspection_id":"85601144","insp_unit_id":"208600790","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"856-25","insp_unit_license":"F243314","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"46UDD1429S1123856","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:31.000000Z","updated_at":"2025-09-09T09:45:09.000000Z"}]},{"id":8873385,"change_date":"2025-06-11 21:42:00","inspection_id":"84924434","dot_number":"3851764","report_state":"MI","report_number":"BURGM06730","insp_date":"2025-06-10 00:00:00","insp_start_time":"0945","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SCOTT RD","county_code_state":"MI","county_code":"037","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SCHLEGEL","shipping_paper_number":"FH02004315","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"214000","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":"1224774","transaction_code":"A","transaction_date":"2025-06-10 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2025-06-11 21:42:00","snet_input_date":"2025-06-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-11 21:42:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:01:01.000000Z","updated_at":"2025-06-15T10:00:40.000000Z","inspection_violations":[{"id":14217648,"change_date":"2025-06-11 21:42:00","inspection_id":"84924434","insp_violation_id":"266785655","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4538423","created_at":"2025-06-14T10:16:36.000000Z","updated_at":"2025-06-17T10:17:44.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":14533134,"change_date":"2025-06-11 21:42:00","inspection_id":"84924434","insp_unit_id":"207334677","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"26423","insp_unit_license":"BD46138","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X3PD855848","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:10.000000Z","updated_at":"2025-06-15T09:45:56.000000Z"},{"id":14533135,"change_date":"2025-06-11 21:42:00","inspection_id":"84924434","insp_unit_id":"207334678","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"DP9541AA","insp_unit_license":"E714282","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2536PR082490","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:10.000000Z","updated_at":"2025-06-15T09:45:56.000000Z"},{"id":14533136,"change_date":"2025-06-11 21:42:00","inspection_id":"84924434","insp_unit_id":"207334679","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"TRLR","insp_unit_company":"DP9541AB","insp_unit_license":"E714283","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1950PR082491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:10.000000Z","updated_at":"2025-06-15T09:45:56.000000Z"}]},{"id":8558885,"change_date":"2025-05-06 21:40:00","inspection_id":"84592338","dot_number":"3851764","report_state":"MI","report_number":"ROBEJ00673","insp_date":"2025-05-05 00:00:00","insp_start_time":"1045","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"30TH AVE AT 15 MILE RD","county_code_state":"MI","county_code":"107","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":"2025-05-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1220178","transaction_code":"A","transaction_date":"2025-05-05 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2025-05-06 21:40:00","snet_input_date":"2025-05-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-06 21:40:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-09T10:26:05.000000Z","updated_at":"2025-05-10T10:51:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13921345,"change_date":"2025-05-06 21:40:00","inspection_id":"84592338","insp_unit_id":"206665055","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"RED","insp_unit_license":"BB50053","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB3YSE79RF193870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:13:57.000000Z","updated_at":"2025-05-10T10:01:49.000000Z"}]},{"id":8512987,"change_date":"2025-04-30 21:52:00","inspection_id":"84544048","dot_number":"3851764","report_state":"MI","report_number":"DEJOS01573","insp_date":"2025-04-28 00:00:00","insp_start_time":"1525","insp_end_time":"1605","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRASS LAKE SCALES E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"88233509","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-30 21:52:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1219541","transaction_code":"A","transaction_date":"2025-04-28 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2025-04-30 21:52:00","snet_input_date":"2025-04-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:51:09.000000Z","updated_at":"2025-05-04T10:40:18.000000Z","inspection_violations":[{"id":13475559,"change_date":"2025-04-30 21:52:00","inspection_id":"84544048","insp_violation_id":"265929721","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4523042","created_at":"2025-05-02T11:42:17.000000Z","updated_at":"2025-05-03T11:17:22.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":13838925,"change_date":"2025-04-30 21:52:00","inspection_id":"84544048","insp_unit_id":"206575983","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"263-23","insp_unit_license":"BD46139","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X1PD855847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:24:56.000000Z","updated_at":"2025-05-04T10:12:55.000000Z"},{"id":13838926,"change_date":"2025-04-30 21:52:00","inspection_id":"84544048","insp_unit_id":"206575984","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":"SP-9542-AA","insp_unit_license":"E714284","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA253XPR082492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:24:56.000000Z","updated_at":"2025-05-04T10:12:55.000000Z"},{"id":13838927,"change_date":"2025-04-30 21:52:00","inspection_id":"84544048","insp_unit_id":"206575985","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"TRST","insp_unit_company":"DP-9542-AB","insp_unit_license":"E714285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1954PR082493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:24:56.000000Z","updated_at":"2025-05-04T10:12:55.000000Z"}]},{"id":8513005,"change_date":"2025-04-30 21:52:00","inspection_id":"84544068","dot_number":"3851764","report_state":"MI","report_number":"DEJOS01574","insp_date":"2025-04-28 00:00:00","insp_start_time":"1610","insp_end_time":"1640","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRASS LAKE SCALES E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"88233510","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-30 21:52:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1219420","transaction_code":"A","transaction_date":"2025-04-28 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2025-04-30 21:52:00","snet_input_date":"2025-04-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:51:09.000000Z","updated_at":"2025-05-04T10:40:18.000000Z","inspection_violations":[{"id":13475632,"change_date":"2025-04-30 21:52:00","inspection_id":"84544068","insp_violation_id":"265929808","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4523653","created_at":"2025-05-02T11:42:17.000000Z","updated_at":"2025-05-03T11:17:24.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":13838958,"change_date":"2025-04-30 21:52:00","inspection_id":"84544068","insp_unit_id":"206576021","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"276-24","insp_unit_license":"BD88761","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X7RR343055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:25:12.000000Z","updated_at":"2025-05-04T10:12:56.000000Z"},{"id":13838959,"change_date":"2025-04-30 21:52:00","inspection_id":"84544068","insp_unit_id":"206576022","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"DP-9545-AA","insp_unit_license":"F038153","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2530SC080861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:25:12.000000Z","updated_at":"2025-05-04T10:12:56.000000Z"},{"id":13838960,"change_date":"2025-04-30 21:52:00","inspection_id":"84544068","insp_unit_id":"206576023","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"DP-9545-AB","insp_unit_license":"F038154","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1955SC080862","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:25:12.000000Z","updated_at":"2025-05-04T10:12:56.000000Z"}]},{"id":8468476,"change_date":"2025-04-25 21:36:00","inspection_id":"84497023","dot_number":"3851764","report_state":"MI","report_number":"LULAN02627","insp_date":"2025-04-23 00:00:00","insp_start_time":"1245","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B US-23 @ PONTIAC TRAIL","county_code_state":"MI","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNK","shipping_paper_number":"88233138","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-04-25 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1218875","transaction_code":"A","transaction_date":"2025-04-23 00:00:00","upload_date":"2025-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2025-04-25 21:36:00","snet_input_date":"2025-04-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-25 21:36:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-28T10:14:20.000000Z","updated_at":"2025-04-29T10:02:33.000000Z","inspection_violations":[{"id":13386906,"change_date":"2025-04-25 21:36:00","inspection_id":"84497023","insp_violation_id":"265828777","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4515173","created_at":"2025-04-28T10:35:51.000000Z","updated_at":"2025-04-29T10:23:41.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":13759104,"change_date":"2025-04-25 21:36:00","inspection_id":"84497023","insp_unit_id":"206489766","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"263-23","insp_unit_license":"BD46139","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X1PD855847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-28T10:04:44.000000Z","updated_at":"2025-04-29T09:56:26.000000Z"},{"id":13759105,"change_date":"2025-04-25 21:36:00","inspection_id":"84497023","insp_unit_id":"206489767","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E714285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1954PR082493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-28T10:04:44.000000Z","updated_at":"2025-04-29T09:56:26.000000Z"}]},{"id":8415694,"change_date":"2025-04-18 21:40:00","inspection_id":"84441377","dot_number":"3851764","report_state":"MI","report_number":"MOREM05833","insp_date":"2025-04-17 00:00:00","insp_start_time":"1326","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DEWITT REST AREA","county_code_state":"MI","county_code":"037","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"TOEBE 496&127","shipping_paper_number":"FH02001979","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":"Y","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":"222000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1218135","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":"03851764","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":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-21T10:26:12.000000Z","updated_at":"2025-04-23T10:03:21.000000Z","inspection_violations":[{"id":13278538,"change_date":"2025-04-18 21:40:00","inspection_id":"84441377","insp_violation_id":"265707305","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4519596","created_at":"2025-04-20T11:14:02.000000Z","updated_at":"2025-04-22T10:30:37.000000Z","normalized_code":"3922SLLSOA"},{"id":13278539,"change_date":"2025-04-18 21:40:00","inspection_id":"84441377","insp_violation_id":"265707306","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4519596","created_at":"2025-04-20T11:14:02.000000Z","updated_at":"2025-04-22T10:30:37.000000Z","normalized_code":"3922SLLEWA2"},{"id":13278540,"change_date":"2025-04-18 21:40:00","inspection_id":"84441377","insp_violation_id":"265707307","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:14:02.000000Z","updated_at":"2025-04-22T10:30:37.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":13663971,"change_date":"2025-04-18 21:40:00","inspection_id":"84441377","insp_unit_id":"206388248","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"256-23","insp_unit_license":"BD47584","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X2PF236446","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:15:55.000000Z","updated_at":"2025-04-22T10:02:16.000000Z"},{"id":13663972,"change_date":"2025-04-18 21:40:00","inspection_id":"84441377","insp_unit_id":"206388249","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"DP-9539AA","insp_unit_license":"E871157","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA243XKC045116","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:15:55.000000Z","updated_at":"2025-04-22T10:02:16.000000Z"},{"id":13663973,"change_date":"2025-04-18 21:40:00","inspection_id":"84441377","insp_unit_id":"206388250","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"DP9539-AB","insp_unit_license":"E808945","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2034KC045117","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:15:55.000000Z","updated_at":"2025-04-22T10:02:16.000000Z"}]},{"id":8121815,"change_date":"2025-03-14 21:41:00","inspection_id":"84131933","dot_number":"3851764","report_state":"MI","report_number":"BEAMW04231","insp_date":"2025-03-13 00:00:00","insp_start_time":"1430","insp_end_time":"1504","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 N @ ENFORCEMENT SITE","county_code_state":"MI","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NO BOL","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"92400","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":"1213181","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2025-03-14 21:41:00","snet_input_date":"2025-03-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-14 21:41:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:07:03.000000Z","updated_at":"2025-03-17T21:07:03.000000Z","inspection_violations":[{"id":12700045,"change_date":"2025-03-14 21:41:00","inspection_id":"84131933","insp_violation_id":"265051245","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"205812371","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:14.000000Z","updated_at":"2025-03-17T22:08:14.000000Z","normalized_code":"39617CPI"},{"id":12700046,"change_date":"2025-03-14 21:41:00","inspection_id":"84131933","insp_violation_id":"265051246","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"205812371","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4488123","created_at":"2025-03-17T22:08:14.000000Z","updated_at":"2025-03-17T22:08:14.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":13113471,"change_date":"2025-03-14 21:41:00","inspection_id":"84131933","insp_unit_id":"205812371","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"234-18","insp_unit_license":"BC77645","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPCL40X3JD484774","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:58.000000Z","updated_at":"2025-03-17T23:59:58.000000Z"}]},{"id":7895207,"change_date":"2025-02-18 21:39:00","inspection_id":"83893903","dot_number":"3851764","report_state":"MI","report_number":"BACZM02612","insp_date":"2025-02-17 00:00:00","insp_start_time":"1313","insp_end_time":"1325","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ LAKE RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1210212","transaction_code":"A","transaction_date":"2025-02-17 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2025-02-18 21:39:00","snet_input_date":"2025-02-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-18 21:39:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:01.000000Z","updated_at":"2025-03-17T21:02:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12744012,"change_date":"2025-02-18 21:39:00","inspection_id":"83893903","insp_unit_id":"205373092","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BC46530","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2AG11C56M042854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:47.000000Z","updated_at":"2025-03-17T23:55:47.000000Z"}]},{"id":7038690,"change_date":"2024-10-24 21:41:00","inspection_id":"82991915","dot_number":"3851764","report_state":"MI","report_number":"BARTT04644","insp_date":"2024-10-22 00:00:00","insp_start_time":"1240","insp_end_time":"1257","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/BI69@BURT","county_code_state":"MI","county_code":"147","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"197500","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":"1199150","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-10-24 21:41:00","snet_input_date":"2024-10-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-24 21:41:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:41.000000Z","updated_at":"2025-03-17T20:42:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11351861,"change_date":"2024-10-24 21:41:00","inspection_id":"82991915","insp_unit_id":"203573528","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"232-22","insp_unit_license":"BC80241","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXP4EX1ND769550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"},{"id":11351862,"change_date":"2024-10-24 21:41:00","inspection_id":"82991915","insp_unit_id":"203573529","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRKG","insp_unit_company":"LB-275-22","insp_unit_license":"E607105","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKJ05743NM108275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"}]},{"id":6853217,"change_date":"2024-09-30 21:41:00","inspection_id":"82794759","dot_number":"3851764","report_state":"MI","report_number":"RICKE00268","insp_date":"2024-09-26 00:00:00","insp_start_time":"1430","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"N\/B M-66 & RHOBY RD","county_code_state":"MI","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"DTE ENERGY","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-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1196298","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:01.000000Z","updated_at":"2025-03-17T20:39:01.000000Z","inspection_violations":[{"id":10673944,"change_date":"2024-09-30 21:41:00","inspection_id":"82794759","insp_violation_id":"262104331","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"3922"},{"id":10673945,"change_date":"2024-09-30 21:41:00","inspection_id":"82794759","insp_violation_id":"262104332","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"203195080","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"39378"},{"id":10673946,"change_date":"2024-09-30 21:41:00","inspection_id":"82794759","insp_violation_id":"262104333","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"203195081","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":11051781,"change_date":"2024-09-30 21:41:00","inspection_id":"82794759","insp_unit_id":"203195080","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"161-17","insp_unit_license":"BA56588","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPXGGGG30D415028","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:27.000000Z","updated_at":"2025-03-17T23:37:27.000000Z"},{"id":11051782,"change_date":"2024-09-30 21:41:00","inspection_id":"82794759","insp_unit_id":"203195081","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DUNWR","insp_unit_company":"RO-97","insp_unit_license":"D555107","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1D9R03849VC232423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:27.000000Z","updated_at":"2025-03-17T23:37:27.000000Z"}]},{"id":6759071,"change_date":"2024-09-18 21:42:00","inspection_id":"82694426","dot_number":"3851764","report_state":"MI","report_number":"HOLLM04012","insp_date":"2024-09-17 00:00:00","insp_start_time":"1040","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"I-94 E\/B GRASS LAKE SCALE","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1195395","transaction_code":"A","transaction_date":"2024-09-17 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-09-18 21:42:00","snet_input_date":"2024-09-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-18 21:42:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:59.000000Z","updated_at":"2025-03-17T20:36:59.000000Z","inspection_violations":[{"id":10524799,"change_date":"2024-09-18 21:42:00","inspection_id":"82694426","insp_violation_id":"261897653","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10899249,"change_date":"2024-09-18 21:42:00","inspection_id":"82694426","insp_unit_id":"203008475","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BD88761","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X7RR343055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:52.000000Z","updated_at":"2025-03-17T23:35:52.000000Z"},{"id":10899250,"change_date":"2024-09-18 21:42:00","inspection_id":"82694426","insp_unit_id":"203008476","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F038153","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2530SC080861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:52.000000Z","updated_at":"2025-03-17T23:35:52.000000Z"},{"id":10899251,"change_date":"2024-09-18 21:42:00","inspection_id":"82694426","insp_unit_id":"203008477","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F038154","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1955SC080862","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:52.000000Z","updated_at":"2025-03-17T23:35:52.000000Z"}]},{"id":6749146,"change_date":"2024-09-17 21:46:00","inspection_id":"82683751","dot_number":"3851764","report_state":"MI","report_number":"WARRJ02663","insp_date":"2024-09-16 00:00:00","insp_start_time":"1650","insp_end_time":"1705","registration_date":null,"region":"ET","ci_status_code":"C","location":"350P4","location_desc":"SWARTZ CREEK REST AREA(I69 EB)","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-17 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1195287","transaction_code":"A","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-09-17 21:46:00","snet_input_date":"2024-09-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-17 21:46:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:56.000000Z","updated_at":"2025-03-17T20:36:56.000000Z","inspection_violations":[{"id":10508937,"change_date":"2024-09-17 21:46:00","inspection_id":"82683751","insp_violation_id":"261873824","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:53.000000Z","updated_at":"2025-03-17T21:56:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10883025,"change_date":"2024-09-17 21:46:00","inspection_id":"82683751","insp_unit_id":"202987065","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"13207","insp_unit_license":"BC63233","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDLB0X97R169293","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:43.000000Z","updated_at":"2025-03-17T23:35:43.000000Z"}]},{"id":6335982,"change_date":"2024-09-17 21:46:00","inspection_id":"82243345","dot_number":"3851764","report_state":"MI","report_number":"WARRJ02629","insp_date":"2024-07-26 00:00:00","insp_start_time":"1505","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WOODBURRY REST AREA(I69 WB)","county_code_state":"MI","county_code":"155","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1187888","transaction_code":"C","transaction_date":"2024-07-26 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-07-29 21:42:00","snet_input_date":"2024-07-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-29 21:42:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:17.000000Z","updated_at":"2025-03-17T20:28:17.000000Z","inspection_violations":[{"id":9836607,"change_date":"2024-09-17 21:46:00","inspection_id":"82243345","insp_violation_id":"261873445","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"2","insp_unit_id":"202986718","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":10209650,"change_date":"2024-09-17 21:46:00","inspection_id":"82243345","insp_unit_id":"202986717","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"14916","insp_unit_license":"BC05420","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPXGGGG20D317852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:43.000000Z","updated_at":"2025-03-17T23:28:43.000000Z"},{"id":10209651,"change_date":"2024-09-17 21:46:00","inspection_id":"82243345","insp_unit_id":"202986718","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DUNR","insp_unit_company":"R095","insp_unit_license":"D572087","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1D9R0383XSC232361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:43.000000Z","updated_at":"2025-03-17T23:28:43.000000Z"}]},{"id":6143078,"change_date":"2024-07-03 21:40:00","inspection_id":"82036523","dot_number":"3851764","report_state":"MI","report_number":"BURGM06133","insp_date":"2024-07-02 00:00:00","insp_start_time":"1210","insp_end_time":"1256","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SCOTT RD","county_code_state":"MI","county_code":"037","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SCHLEGEL","shipping_paper_number":"1109141","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"138500","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":"1184456","transaction_code":"A","transaction_date":"2024-07-02 00:00:00","upload_date":"2024-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-07-03 21:40:00","snet_input_date":"2024-07-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-03 21:40:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:34.000000Z","updated_at":"2025-03-17T20:24:34.000000Z","inspection_violations":[{"id":9535984,"change_date":"2024-07-03 21:40:00","inspection_id":"82036523","insp_violation_id":"260463072","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4399100","created_at":"2025-03-17T21:52:07.000000Z","updated_at":"2025-03-17T21:52:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9895174,"change_date":"2024-07-03 21:40:00","inspection_id":"82036523","insp_unit_id":"201728136","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"127-14","insp_unit_license":"BC56662","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPXGGGG90D230238","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:34.000000Z","updated_at":"2025-03-17T23:25:34.000000Z"},{"id":9895175,"change_date":"2024-07-03 21:40:00","inspection_id":"82036523","insp_unit_id":"201728137","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"DP9524-S","insp_unit_license":"E789979","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3M48XGR053734","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:34.000000Z","updated_at":"2025-03-17T23:25:34.000000Z"}]},{"id":5847007,"change_date":"2024-05-28 21:42:00","inspection_id":"81716257","dot_number":"3851764","report_state":"TN","report_number":"I033940018","insp_date":"2024-05-22 00:00:00","insp_start_time":"1537","insp_end_time":"1555","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CLEVELAND TN","county_code_state":"TN","county_code":"011","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"ML CHARTER EXCAVATING INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"40225","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":"519226","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-05-28 21:42:00","snet_input_date":"2024-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-28 21:42:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:39.000000Z","updated_at":"2025-03-17T20:18:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9417017,"change_date":"2024-05-28 21:42:00","inspection_id":"81716257","insp_unit_id":"201093523","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"BD47673","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPVH07X9AD798387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:44.000000Z","updated_at":"2025-03-17T23:20:44.000000Z"},{"id":9417018,"change_date":"2024-05-28 21:42:00","inspection_id":"81716257","insp_unit_id":"201093524","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MYCO INDUS","insp_unit_company":null,"insp_unit_license":"E808944","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M9BA5034PB817206","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:44.000000Z","updated_at":"2025-03-17T23:20:44.000000Z"}]},{"id":5744791,"change_date":"2024-05-14 21:42:00","inspection_id":"81605496","dot_number":"3851764","report_state":"MI","report_number":"SHEPZ04366","insp_date":"2024-05-14 00:00:00","insp_start_time":"0645","insp_end_time":"0745","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MICHIGAN PAVING","shipping_paper_number":"1150000658","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1178305","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-05-14 21:42:00","snet_input_date":"2024-05-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-14 21:42:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:40.000000Z","updated_at":"2025-03-17T20:16:40.000000Z","inspection_violations":[{"id":8889819,"change_date":"2024-05-14 21:42:00","inspection_id":"81605496","insp_violation_id":"259493866","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4372515","created_at":"2025-03-17T21:49:01.000000Z","updated_at":"2025-03-17T21:49:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9253036,"change_date":"2024-05-14 21:42:00","inspection_id":"81605496","insp_unit_id":"200884994","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"263-23","insp_unit_license":"BD46139","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X1PD855847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:07.000000Z","updated_at":"2025-03-17T23:19:07.000000Z"},{"id":9253037,"change_date":"2024-05-14 21:42:00","inspection_id":"81605496","insp_unit_id":"200884995","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":"DP-9542-AA","insp_unit_license":"E714284","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA253XPR082492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:07.000000Z","updated_at":"2025-03-17T23:19:07.000000Z"},{"id":9253038,"change_date":"2024-05-14 21:42:00","inspection_id":"81605496","insp_unit_id":"200884996","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"TRST","insp_unit_company":"DP-9542-AB","insp_unit_license":"E714285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1954PR082493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:07.000000Z","updated_at":"2025-03-17T23:19:07.000000Z"}]},{"id":5755663,"change_date":"2024-05-15 21:43:00","inspection_id":"81617255","dot_number":"3851764","report_state":"MI","report_number":"LINEM00441","insp_date":"2024-05-14 00:00:00","insp_start_time":"1250","insp_end_time":"1339","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"STONE CO","shipping_paper_number":"115355","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"208450","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1178519","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-05-15 21:43:00","snet_input_date":"2024-05-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-15 21:43:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:43.000000Z","updated_at":"2025-03-17T20:16:43.000000Z","inspection_violations":[{"id":8907969,"change_date":"2024-05-15 21:43:00","inspection_id":"81617255","insp_violation_id":"259518904","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4376368","created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"},{"id":8907970,"change_date":"2024-05-15 21:43:00","inspection_id":"81617255","insp_violation_id":"259518905","seq_no":"2","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"200906552","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"393104F3"}],"inspection_per_units":[{"id":9270464,"change_date":"2024-05-15 21:43:00","inspection_id":"81617255","insp_unit_id":"200906551","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"127-14","insp_unit_license":"BC56662","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPXGGGG90D230238","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:18.000000Z","updated_at":"2025-03-17T23:19:18.000000Z"},{"id":9270465,"change_date":"2024-05-15 21:43:00","inspection_id":"81617255","insp_unit_id":"200906552","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HOLE","insp_unit_company":"LB-08","insp_unit_license":"C068825","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"12HDM615X8N601123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:18.000000Z","updated_at":"2025-03-17T23:19:18.000000Z"}]},{"id":5656756,"change_date":"2024-05-02 21:43:00","inspection_id":"81509792","dot_number":"3851764","report_state":"MI","report_number":"DOWEM02738","insp_date":"2024-05-01 00:00:00","insp_start_time":"1150","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M32 NEAR HERRON PARK AND RIDE","county_code_state":"MI","county_code":"007","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","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":"1176785","transaction_code":"A","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-05-02 21:43:00","snet_input_date":"2024-05-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-02 21:43:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:45.000000Z","updated_at":"2025-03-17T20:14:45.000000Z","inspection_violations":[{"id":8749807,"change_date":"2024-05-02 21:43:00","inspection_id":"81509792","insp_violation_id":"259285095","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4364267","created_at":"2025-03-17T21:48:19.000000Z","updated_at":"2025-03-17T21:48:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9111250,"change_date":"2024-05-02 21:43:00","inspection_id":"81509792","insp_unit_id":"200701001","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"159-17","insp_unit_license":"BA80702","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X8HD413230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:47.000000Z","updated_at":"2025-03-17T23:17:47.000000Z"},{"id":9111251,"change_date":"2024-05-02 21:43:00","inspection_id":"81509792","insp_unit_id":"200701002","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E343202","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3M481NR076199","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:47.000000Z","updated_at":"2025-03-17T23:17:47.000000Z"}]},{"id":5576071,"change_date":"2024-04-23 21:41:00","inspection_id":"81421883","dot_number":"3851764","report_state":"MI","report_number":"MOREM05200","insp_date":"2024-04-22 00:00:00","insp_start_time":"1705","insp_end_time":"1820","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"IRP LOT CROWNER BILLWOOD","county_code_state":"MI","county_code":"045","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"78350","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1175041","transaction_code":"A","transaction_date":"2024-04-22 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-04-23 21:41:00","snet_input_date":"2024-04-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-23 21:41:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:10.000000Z","updated_at":"2025-03-17T20:13:10.000000Z","inspection_violations":[{"id":8618141,"change_date":"2024-04-23 21:41:00","inspection_id":"81421883","insp_violation_id":"259082579","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"3922"},{"id":8618142,"change_date":"2024-04-23 21:41:00","inspection_id":"81421883","insp_violation_id":"259082580","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200530579","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"39347E"},{"id":8618143,"change_date":"2024-04-23 21:41:00","inspection_id":"81421883","insp_violation_id":"259082581","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200530579","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"39353B"},{"id":8618144,"change_date":"2024-04-23 21:41:00","inspection_id":"81421883","insp_violation_id":"259082582","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"200530579","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"39395F"},{"id":8618145,"change_date":"2024-04-23 21:41:00","inspection_id":"81421883","insp_violation_id":"259082583","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200530579","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8982060,"change_date":"2024-04-23 21:41:00","inspection_id":"81421883","insp_unit_id":"200530579","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"180-11","insp_unit_license":"BB70906","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDX0EX1BJ279375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"}]},{"id":5491315,"change_date":"2024-04-11 21:41:00","inspection_id":"81329679","dot_number":"3851764","report_state":"MI","report_number":"DETGT04679","insp_date":"2024-04-10 00:00:00","insp_start_time":"1330","insp_end_time":"1447","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","viol_total":"7","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1173160","transaction_code":"A","transaction_date":"2024-04-10 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-04-11 21:41:00","snet_input_date":"2024-04-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-11 21:41:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:32.000000Z","updated_at":"2025-03-17T20:11:32.000000Z","inspection_violations":[{"id":8480720,"change_date":"2024-04-11 21:41:00","inspection_id":"81329679","insp_violation_id":"258883023","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4354965","created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3922"},{"id":8480721,"change_date":"2024-04-11 21:41:00","inspection_id":"81329679","insp_violation_id":"258883024","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200356312","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3939A"},{"id":8480722,"change_date":"2024-04-11 21:41:00","inspection_id":"81329679","insp_violation_id":"258883025","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200356312","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3939A"},{"id":8480723,"change_date":"2024-04-11 21:41:00","inspection_id":"81329679","insp_violation_id":"258883026","seq_no":"4","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"200356312","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39319"},{"id":8480724,"change_date":"2024-04-11 21:41:00","inspection_id":"81329679","insp_violation_id":"258883027","seq_no":"5","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"200356312","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39319"},{"id":8480725,"change_date":"2024-04-11 21:41:00","inspection_id":"81329679","insp_violation_id":"258883028","seq_no":"6","part_no":"393","part_no_section":"25(f)","insp_viol_unit":"1","insp_unit_id":"200356312","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39325F"},{"id":8480726,"change_date":"2024-04-11 21:41:00","inspection_id":"81329679","insp_violation_id":"258883029","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"200356312","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":8845550,"change_date":"2024-04-11 21:41:00","inspection_id":"81329679","insp_unit_id":"200356312","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"149-16","insp_unit_license":"BC05420","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPXGGGG20D317852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"},{"id":8845551,"change_date":"2024-04-11 21:41:00","inspection_id":"81329679","insp_unit_id":"200356313","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DUNR","insp_unit_company":"RO95","insp_unit_license":"D572082","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1D9R0383XSC232361","insp_unit_decal":"Y","insp_unit_decal_number":"33973942","created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"}]},{"id":5472114,"change_date":"2024-04-09 21:41:00","inspection_id":"81308498","dot_number":"3851764","report_state":"MI","report_number":"ELDEH00435","insp_date":"2024-04-08 00:00:00","insp_start_time":"0815","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75NB @ SAFE ENFORCEMENT SITE","county_code_state":"MI","county_code":"145","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":"2024-04-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"196000","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":"1172683","transaction_code":"A","transaction_date":"2024-04-08 00:00:00","upload_date":"2024-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-04-09 21:41:00","snet_input_date":"2024-04-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-09 21:41:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:10.000000Z","updated_at":"2025-03-17T20:11:10.000000Z","inspection_violations":[{"id":8448916,"change_date":"2024-04-09 21:41:00","inspection_id":"81308498","insp_violation_id":"258832734","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:55.000000Z","updated_at":"2025-03-17T21:46:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8814396,"change_date":"2024-04-09 21:41:00","inspection_id":"81308498","insp_unit_id":"200313867","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"203-20","insp_unit_license":"BC46528","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXP4EX6LD712094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:58.000000Z","updated_at":"2025-03-17T23:14:58.000000Z"},{"id":8814397,"change_date":"2024-04-09 21:41:00","inspection_id":"81308498","insp_unit_id":"200313868","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRKG","insp_unit_company":"LB-239-13","insp_unit_license":"C580513","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKR00510DM019972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:58.000000Z","updated_at":"2025-03-17T23:14:58.000000Z"}]},{"id":5287079,"change_date":"2024-03-14 21:41:00","inspection_id":"81106538","dot_number":"3851764","report_state":"MI","report_number":"MALIK02244","insp_date":"2024-03-14 00:00:00","insp_start_time":"0925","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B VAN DYKE AVE @ MARTIN RD","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1168950","transaction_code":"A","transaction_date":"2024-03-14 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-03-14 21:41:00","snet_input_date":"2024-03-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-14 21:41:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:28.000000Z","updated_at":"2025-03-17T20:07:28.000000Z","inspection_violations":[{"id":8152449,"change_date":"2024-03-14 21:41:00","inspection_id":"81106538","insp_violation_id":"258383999","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199914476","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8514073,"change_date":"2024-03-14 21:41:00","inspection_id":"81106538","insp_unit_id":"199914476","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"161-17","insp_unit_license":"BA56588","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPXGGGG30D415028","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:09.000000Z","updated_at":"2025-03-17T23:12:09.000000Z"},{"id":8514074,"change_date":"2024-03-14 21:41:00","inspection_id":"81106538","insp_unit_id":"199914477","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PINNA","insp_unit_company":"FE-0051-10","insp_unit_license":"C195764","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"AL1634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:09.000000Z","updated_at":"2025-03-17T23:12:09.000000Z"}]},{"id":5009743,"change_date":"2024-02-08 21:43:00","inspection_id":"80804058","dot_number":"3851764","report_state":"MI","report_number":"BARTT04190","insp_date":"2024-02-07 00:00:00","insp_start_time":"1110","insp_end_time":"1128","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/BI69@MILLER","county_code_state":"MI","county_code":"147","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1163703","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-02-08 21:43:00","snet_input_date":"2024-02-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-08 21:43:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:01.000000Z","updated_at":"2025-03-17T20:02:01.000000Z","inspection_violations":[{"id":7717051,"change_date":"2024-02-08 21:43:00","inspection_id":"80804058","insp_violation_id":"257739548","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199336686","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:15.000000Z","updated_at":"2025-03-17T21:43:15.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":8063334,"change_date":"2024-02-08 21:43:00","inspection_id":"80804058","insp_unit_id":"199336686","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"232-22","insp_unit_license":"BC80241","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXP4EX1ND769550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:04.000000Z","updated_at":"2025-03-17T23:08:04.000000Z"}]},{"id":4955311,"change_date":"2024-02-01 21:43:00","inspection_id":"80744453","dot_number":"3851764","report_state":"MI","report_number":"BALLB04465","insp_date":"2024-01-31 00:00:00","insp_start_time":"1300","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"PALMS @ ST CLAIR","county_code_state":"MI","county_code":"147","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"1162588","transaction_code":"A","transaction_date":"2024-01-31 00:00:00","upload_date":"2024-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2024-02-01 21:43:00","snet_input_date":"2024-01-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-01 21:43:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:52.000000Z","updated_at":"2025-03-17T20:00:52.000000Z","inspection_violations":[{"id":7632048,"change_date":"2024-02-01 21:43:00","inspection_id":"80744453","insp_violation_id":"257613815","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:42:51.000000Z","updated_at":"2025-03-17T21:42:51.000000Z","normalized_code":"39141A"},{"id":7632049,"change_date":"2024-02-01 21:43:00","inspection_id":"80744453","insp_violation_id":"257613816","seq_no":"2","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":null,"created_at":"2025-03-17T21:42:51.000000Z","updated_at":"2025-03-17T21:42:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7974925,"change_date":"2024-02-01 21:43:00","inspection_id":"80744453","insp_unit_id":"199222509","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NONE","insp_unit_license":"BB50053","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD0W4GT4CED00133","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:16.000000Z","updated_at":"2025-03-17T23:07:16.000000Z"}]},{"id":4061916,"change_date":"2023-09-26 21:43:00","inspection_id":"79761625","dot_number":"3851764","report_state":"MI","report_number":"ZAPF000052","insp_date":"2023-09-25 00:00:00","insp_start_time":"1430","insp_end_time":"1522","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MILLER DRIVE\/35TH ST","county_code_state":"MI","county_code":"077","insp_level_id":"2","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":"2023-09-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","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":"1147453","transaction_code":"A","transaction_date":"2023-09-25 00:00:00","upload_date":"2023-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2023-09-26 21:43:00","snet_input_date":"2023-09-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-26 21:43:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:09.000000Z","updated_at":"2025-03-17T19:43:09.000000Z","inspection_violations":[{"id":6288034,"change_date":"2023-09-26 21:43:00","inspection_id":"79761625","insp_violation_id":"255496742","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197250452","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4285318","created_at":"2025-03-17T21:36:20.000000Z","updated_at":"2025-03-17T21:36:20.000000Z","normalized_code":"3922"},{"id":6288035,"change_date":"2023-09-26 21:43:00","inspection_id":"79761625","insp_violation_id":"255496743","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197250452","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:20.000000Z","updated_at":"2025-03-17T21:36:20.000000Z","normalized_code":"3922"},{"id":6288036,"change_date":"2023-09-26 21:43:00","inspection_id":"79761625","insp_violation_id":"255496744","seq_no":"3","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"197250452","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:20.000000Z","updated_at":"2025-03-17T21:36:20.000000Z","normalized_code":"39375G"}],"inspection_per_units":[{"id":6530857,"change_date":"2023-09-26 21:43:00","inspection_id":"79761625","insp_unit_id":"197250452","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC63239","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPTX7EX1ED176104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:49.000000Z","updated_at":"2025-03-17T22:54:49.000000Z"}]},{"id":3858872,"change_date":"2023-08-29 21:42:00","inspection_id":"79535873","dot_number":"3851764","report_state":"MI","report_number":"BARTT04004","insp_date":"2023-08-29 00:00:00","insp_start_time":"0845","insp_end_time":"0907","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/BI69@HADLEY","county_code_state":"MI","county_code":"087","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1143330","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2023-08-29 21:42:00","snet_input_date":"2023-08-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-29 21:42:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:58.000000Z","updated_at":"2025-03-17T19:38:58.000000Z","inspection_violations":[{"id":5960308,"change_date":"2023-08-29 21:42:00","inspection_id":"79535873","insp_violation_id":"254954152","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4265586","created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"39216A"},{"id":5960309,"change_date":"2023-08-29 21:42:00","inspection_id":"79535873","insp_violation_id":"254954153","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"196789226","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"39021TB"},{"id":5960310,"change_date":"2023-08-29 21:42:00","inspection_id":"79535873","insp_violation_id":"254954154","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196789227","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6203901,"change_date":"2023-08-29 21:42:00","inspection_id":"79535873","insp_unit_id":"196789226","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"215-18","insp_unit_license":"BC67287","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X8JJ200401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:07.000000Z","updated_at":"2025-03-17T22:52:07.000000Z"},{"id":6203902,"change_date":"2023-08-29 21:42:00","inspection_id":"79535873","insp_unit_id":"196789227","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"0","insp_unit_license":"B944778","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"AF1383707","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:07.000000Z","updated_at":"2025-03-17T22:52:07.000000Z"}]},{"id":3746395,"change_date":"2023-08-30 21:44:00","inspection_id":"79410085","dot_number":"3851764","report_state":"MI","report_number":"FRIZS02802","insp_date":"2023-08-14 00:00:00","insp_start_time":"1451","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MCEWAN DR @ WINIFRED ST","county_code_state":"MI","county_code":"035","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S \/ C","shipping_paper_number":"E23W3S0328","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"199040","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":"1140298","transaction_code":"C","transaction_date":"2023-08-14 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2023-08-15 21:43:00","snet_input_date":"2023-08-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-15 21:43:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:53.000000Z","updated_at":"2025-03-17T19:36:53.000000Z","inspection_violations":[{"id":5776731,"change_date":"2023-08-30 21:44:00","inspection_id":"79410085","insp_violation_id":"254984144","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:44.000000Z","updated_at":"2025-03-17T21:33:44.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":6023864,"change_date":"2023-08-30 21:44:00","inspection_id":"79410085","insp_unit_id":"196813539","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"225-21","insp_unit_license":"BD41099","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X7MF461117","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:37.000000Z","updated_at":"2025-03-17T22:50:37.000000Z"},{"id":6023865,"change_date":"2023-08-30 21:44:00","inspection_id":"79410085","insp_unit_id":"196813540","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"LB 239-13","insp_unit_license":"E109986","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKJ05337DM078239","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:37.000000Z","updated_at":"2025-03-17T22:50:37.000000Z"}]},{"id":3323247,"change_date":"2023-06-20 21:41:00","inspection_id":"78935619","dot_number":"3851764","report_state":"MI","report_number":"SCSJB00394","insp_date":"2023-06-19 00:00:00","insp_start_time":"1245","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"COUNTY ROAD COMM MARYSVILLE","county_code_state":"MI","county_code":"147","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-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1131113","transaction_code":"A","transaction_date":"2023-06-19 00:00:00","upload_date":"2023-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2023-06-20 21:41:00","snet_input_date":"2023-06-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-20 21:41:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:53.000000Z","updated_at":"2025-03-17T19:28:53.000000Z","inspection_violations":[{"id":5125598,"change_date":"2023-06-20 21:41:00","inspection_id":"78935619","insp_violation_id":"253599481","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23TS02467","created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"3922"},{"id":5125599,"change_date":"2023-06-20 21:41:00","inspection_id":"78935619","insp_violation_id":"253599482","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23TS02467","created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5342216,"change_date":"2023-06-20 21:41:00","inspection_id":"78935619","insp_unit_id":"195582409","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BC80280","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPTX7EX9DD176091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:08.000000Z","updated_at":"2025-03-17T22:45:08.000000Z"}]},{"id":3023495,"change_date":"2023-05-11 21:42:00","inspection_id":"78597290","dot_number":"3851764","report_state":"MI","report_number":"DELMT00491","insp_date":"2023-05-09 00:00:00","insp_start_time":"1435","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ANGELO LAFRATE CONSTRUCTION","shipping_paper_number":"32285463","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-05-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1125456","transaction_code":"A","transaction_date":"2023-05-09 00:00:00","upload_date":"2023-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2023-05-11 21:42:00","snet_input_date":"2023-05-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-11 21:42:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:58.000000Z","updated_at":"2025-03-17T19:22:58.000000Z","inspection_violations":[{"id":4643449,"change_date":"2023-05-11 21:42:00","inspection_id":"78597290","insp_violation_id":"252774668","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4864197,"change_date":"2023-05-11 21:42:00","inspection_id":"78597290","insp_unit_id":"194881585","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"149-16","insp_unit_license":"BC05420","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPXGGGG20D317852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:19.000000Z","updated_at":"2025-03-17T22:41:19.000000Z"},{"id":4864198,"change_date":"2023-05-11 21:42:00","inspection_id":"78597290","insp_unit_id":"194881586","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"DP-9537-AA","insp_unit_license":"E455787","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2433JC042019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:19.000000Z","updated_at":"2025-03-17T22:41:19.000000Z"},{"id":4864199,"change_date":"2023-05-11 21:42:00","inspection_id":"78597290","insp_unit_id":"194881587","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"DP-9537-AB","insp_unit_license":"E871156","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2032JC042020","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:19.000000Z","updated_at":"2025-03-17T22:41:19.000000Z"}]},{"id":3000970,"change_date":"2023-05-09 21:42:00","inspection_id":"78571726","dot_number":"3851764","report_state":"MI","report_number":"SAHIW00580","insp_date":"2023-05-08 00:00:00","insp_start_time":"1450","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB-I-75 @ DIX-TOLEDO RD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"154600","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":"1125361","transaction_code":"A","transaction_date":"2023-05-08 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2023-05-09 21:42:00","snet_input_date":"2023-05-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-09 21:42:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:34.000000Z","updated_at":"2025-03-17T19:22:34.000000Z","inspection_violations":[{"id":4607869,"change_date":"2023-05-09 21:42:00","inspection_id":"78571726","insp_violation_id":"252715747","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:28.000000Z","updated_at":"2025-03-17T21:28:28.000000Z","normalized_code":"3922"},{"id":4607870,"change_date":"2023-05-09 21:42:00","inspection_id":"78571726","insp_violation_id":"252715748","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:28.000000Z","updated_at":"2025-03-17T21:28:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4828402,"change_date":"2023-05-09 21:42:00","inspection_id":"78571726","insp_unit_id":"194830939","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"96-08","insp_unit_license":"BB90759","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPWDBEXX8D762447","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:02.000000Z","updated_at":"2025-03-17T22:41:02.000000Z"},{"id":4828403,"change_date":"2023-05-09 21:42:00","inspection_id":"78571726","insp_unit_id":"194830940","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E808795","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3M488CRF46423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:02.000000Z","updated_at":"2025-03-17T22:41:02.000000Z"}]},{"id":2910227,"change_date":"2023-04-27 21:43:00","inspection_id":"78469280","dot_number":"3851764","report_state":"MI","report_number":"NESBA00417","insp_date":"2023-04-26 00:00:00","insp_start_time":"1205","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"203000","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":"1123970","transaction_code":"A","transaction_date":"2023-04-26 00:00:00","upload_date":"2023-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2023-04-27 21:43:00","snet_input_date":"2023-04-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-27 21:43:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:26.000000Z","updated_at":"2025-03-17T19:20:26.000000Z","inspection_violations":[{"id":4464718,"change_date":"2023-04-27 21:43:00","inspection_id":"78469280","insp_violation_id":"252484222","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4196124","created_at":"2025-03-17T21:27:50.000000Z","updated_at":"2025-03-17T21:27:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4682009,"change_date":"2023-04-27 21:43:00","inspection_id":"78469280","insp_unit_id":"194627114","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"229-22","insp_unit_license":"BD29107","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X0NF471313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:55.000000Z","updated_at":"2025-03-17T22:39:55.000000Z"},{"id":4682010,"change_date":"2023-04-27 21:43:00","inspection_id":"78469280","insp_unit_id":"194627115","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"DP-9536AA","insp_unit_license":"E343286","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2L385NR075961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:55.000000Z","updated_at":"2025-03-17T22:39:55.000000Z"},{"id":4682011,"change_date":"2023-04-27 21:43:00","inspection_id":"78469280","insp_unit_id":"194627116","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EADU","insp_unit_company":"DP-9536AB","insp_unit_license":"E343285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W2H583NR075962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:55.000000Z","updated_at":"2025-03-17T22:39:55.000000Z"}]},{"id":2852366,"change_date":"2023-04-20 21:42:00","inspection_id":"78403564","dot_number":"3851764","report_state":"MI","report_number":"DETGT04172","insp_date":"2023-04-19 00:00:00","insp_start_time":"1440","insp_end_time":"1612","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"17000185","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-04-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"9","oos_total":"5","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1122628","transaction_code":"A","transaction_date":"2023-04-19 00:00:00","upload_date":"2023-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2023-04-20 21:42:00","snet_input_date":"2023-04-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-20 21:42:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:18.000000Z","updated_at":"2025-03-17T19:19:18.000000Z","inspection_violations":[{"id":4376068,"change_date":"2023-04-20 21:42:00","inspection_id":"78403564","insp_violation_id":"252342813","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4202954","created_at":"2025-03-17T21:27:25.000000Z","updated_at":"2025-03-17T21:27:25.000000Z","normalized_code":"3922"},{"id":4376069,"change_date":"2023-04-20 21:42:00","inspection_id":"78403564","insp_violation_id":"252342814","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:25.000000Z","updated_at":"2025-03-17T21:27:25.000000Z","normalized_code":"3922"},{"id":4376070,"change_date":"2023-04-20 21:42:00","inspection_id":"78403564","insp_violation_id":"252342815","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"194498273","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4202954","created_at":"2025-03-17T21:27:25.000000Z","updated_at":"2025-03-17T21:27:25.000000Z","normalized_code":"39375A3"},{"id":4376071,"change_date":"2023-04-20 21:42:00","inspection_id":"78403564","insp_violation_id":"252342816","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"194498273","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:25.000000Z","updated_at":"2025-03-17T21:27:25.000000Z","normalized_code":"39375A3"},{"id":4376072,"change_date":"2023-04-20 21:42:00","inspection_id":"78403564","insp_violation_id":"252342817","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"194498273","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:25.000000Z","updated_at":"2025-03-17T21:27:25.000000Z","normalized_code":"39375A3"},{"id":4376073,"change_date":"2023-04-20 21:42:00","inspection_id":"78403564","insp_violation_id":"252342818","seq_no":"6","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"2","insp_unit_id":"194498273","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:25.000000Z","updated_at":"2025-03-17T21:27:25.000000Z","normalized_code":"39347D"},{"id":4376074,"change_date":"2023-04-20 21:42:00","inspection_id":"78403564","insp_violation_id":"252342819","seq_no":"7","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"194498273","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:25.000000Z","updated_at":"2025-03-17T21:27:25.000000Z","normalized_code":"393207A"},{"id":4376075,"change_date":"2023-04-20 21:42:00","inspection_id":"78403564","insp_violation_id":"252342820","seq_no":"8","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"3","insp_unit_id":"194498274","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:25.000000Z","updated_at":"2025-03-17T21:27:25.000000Z","normalized_code":"39347D"},{"id":4376076,"change_date":"2023-04-20 21:42:00","inspection_id":"78403564","insp_violation_id":"252342821","seq_no":"9","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"3","insp_unit_id":"194498274","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:25.000000Z","updated_at":"2025-03-17T21:27:25.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":4589875,"change_date":"2023-04-20 21:42:00","inspection_id":"78403564","insp_unit_id":"194498272","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"149-16","insp_unit_license":"BC05420","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPXGGGG20D317852","insp_unit_decal":"Y","insp_unit_decal_number":"32660409","created_at":"2025-03-17T22:39:11.000000Z","updated_at":"2025-03-17T22:39:11.000000Z"},{"id":4589876,"change_date":"2023-04-20 21:42:00","inspection_id":"78403564","insp_unit_id":"194498273","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"9530A","insp_unit_license":"E221295","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3M48XMR073560","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:11.000000Z","updated_at":"2025-03-17T22:39:11.000000Z"},{"id":4589877,"change_date":"2023-04-20 21:42:00","inspection_id":"78403564","insp_unit_id":"194498274","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":"9530B","insp_unit_license":"E221296","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W3L488MR073561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:11.000000Z","updated_at":"2025-03-17T22:39:11.000000Z"}]},{"id":2818139,"change_date":"2023-04-17 21:41:00","inspection_id":"78364940","dot_number":"3851764","report_state":"MI","report_number":"DELMT00448","insp_date":"2023-04-14 00:00:00","insp_start_time":"1800","insp_end_time":"1840","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ANGELO INAFRATE CONSTRUCTION","shipping_paper_number":"17000106","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-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1122191","transaction_code":"A","transaction_date":"2023-04-14 00:00:00","upload_date":"2023-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2023-04-17 21:41:00","snet_input_date":"2023-04-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-17 21:41:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:34.000000Z","updated_at":"2025-03-17T19:18:34.000000Z","inspection_violations":[{"id":4324180,"change_date":"2023-04-17 21:41:00","inspection_id":"78364940","insp_violation_id":"252259797","seq_no":"1","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"3","insp_unit_id":"194422335","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"39375G"},{"id":4324181,"change_date":"2023-04-17 21:41:00","inspection_id":"78364940","insp_violation_id":"252259798","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4535716,"change_date":"2023-04-17 21:41:00","inspection_id":"78364940","insp_unit_id":"194422333","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"264-23","insp_unit_license":"BD46138","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X3PD85584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:46.000000Z","updated_at":"2025-03-17T22:38:46.000000Z"},{"id":4535717,"change_date":"2023-04-17 21:41:00","inspection_id":"78364940","insp_unit_id":"194422334","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"DP9530SA","insp_unit_license":"E221295","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3M48XMR073560","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:46.000000Z","updated_at":"2025-03-17T22:38:46.000000Z"},{"id":4535718,"change_date":"2023-04-17 21:41:00","inspection_id":"78364940","insp_unit_id":"194422335","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":"DP953OSB","insp_unit_license":"E221296","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W3L488MR073561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:46.000000Z","updated_at":"2025-03-17T22:38:46.000000Z"}]},{"id":2645930,"change_date":"2023-03-23 21:43:00","inspection_id":"78168617","dot_number":"3851764","report_state":"MI","report_number":"HICKG02112","insp_date":"2023-03-22 00:00:00","insp_start_time":"1200","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-52 @ GRAND RIVER AVE","county_code_state":"MI","county_code":"065","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":"2023-03-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1119076","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2023-03-23 21:43:00","snet_input_date":"2023-03-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-23 21:43:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:31.000000Z","updated_at":"2025-03-17T19:15:31.000000Z","inspection_violations":[{"id":4066865,"change_date":"2023-03-23 21:43:00","inspection_id":"78168617","insp_violation_id":"251833808","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"39216A"},{"id":4066866,"change_date":"2023-03-23 21:43:00","inspection_id":"78168617","insp_violation_id":"251833809","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194031431","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"3922"},{"id":4066867,"change_date":"2023-03-23 21:43:00","inspection_id":"78168617","insp_violation_id":"251833810","seq_no":"3","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:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":4259472,"change_date":"2023-03-23 21:43:00","inspection_id":"78168617","insp_unit_id":"194031431","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"141-05","insp_unit_license":"BD05023","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMAAL35H103185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:33.000000Z","updated_at":"2025-03-17T22:36:33.000000Z"}]},{"id":2625034,"change_date":"2023-03-21 21:41:00","inspection_id":"78145067","dot_number":"3851764","report_state":"MI","report_number":"REBIM00223","insp_date":"2023-03-21 00:00:00","insp_start_time":"1000","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 94 NORTHBOUND REST AREA","county_code_state":"MI","county_code":"147","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":"2023-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1118746","transaction_code":"A","transaction_date":"2023-03-21 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2023-03-21 21:41:00","snet_input_date":"2023-03-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-21 21:41:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:09.000000Z","updated_at":"2025-03-17T19:15:09.000000Z","inspection_violations":[{"id":4035768,"change_date":"2023-03-21 21:41:00","inspection_id":"78145067","insp_violation_id":"251780934","seq_no":"1","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193981260","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"3929A"},{"id":4035769,"change_date":"2023-03-21 21:41:00","inspection_id":"78145067","insp_violation_id":"251780935","seq_no":"2","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"1","insp_unit_id":"193981260","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"393207F"},{"id":4035770,"change_date":"2023-03-21 21:41:00","inspection_id":"78145067","insp_violation_id":"251780936","seq_no":"3","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":4225561,"change_date":"2023-03-21 21:41:00","inspection_id":"78145067","insp_unit_id":"193981260","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"147-15","insp_unit_license":"BA15670","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP2HJ7X7FM274584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:19.000000Z","updated_at":"2025-03-17T22:36:19.000000Z"}]},{"id":2524499,"change_date":"2023-03-07 21:41:00","inspection_id":"78030611","dot_number":"3851764","report_state":"MI","report_number":"BARTC02174","insp_date":"2023-03-07 00:00:00","insp_start_time":"0900","insp_end_time":"0917","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"VANDERMUILLEN","county_code_state":"MI","county_code":"113","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1116329","transaction_code":"A","transaction_date":"2023-03-07 00:00:00","upload_date":"2023-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03851764","upload_search_indicator":null,"census_search_date":"2023-03-07 21:41:00","snet_input_date":"2023-03-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-07 21:41:00","insp_carrier_name":"M L CHARTIER EXCAVATING INC","insp_carrier_street":"9195 MARINE CITY HIGHWAY","insp_carrier_city":"FAIR HAVEN","insp_carrier_state":"MI","insp_carrier_zip_code":"48023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:18.000000Z","updated_at":"2025-03-17T19:13:18.000000Z","inspection_violations":[{"id":3881218,"change_date":"2023-03-07 21:41:00","inspection_id":"78030611","insp_violation_id":"251520954","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4063279,"change_date":"2023-03-07 21:41:00","inspection_id":"78030611","insp_unit_id":"193748753","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"226-15","insp_unit_license":"BC67286","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX7EX8FJ462938","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:07.000000Z","updated_at":"2025-03-17T22:35:07.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3851764\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3851764\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3851764\/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\/3851764\/inspections","per_page":100,"prev_page_url":null,"to":50,"total":50}