{"current_page":1,"data":[{"id":11494318,"change_date":"2026-03-27 21:39:00","inspection_id":"87414018","dot_number":"1540424","report_state":"OH","report_number":"3258000484","insp_date":"2026-03-25 00:00:00","insp_start_time":"1518","insp_end_time":"1533","registration_date":null,"region":"ED","ci_status_code":"C","location":"BG R\/S","location_desc":"BOWLING GREEN OH","county_code_state":"OH","county_code":"173","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ASAHIKASEI","shipping_paper_number":"81183783","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3075060","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":"2026-03-27 21:39:00","snet_input_date":"2026-03-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-27 21:39:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:31.000000Z","updated_at":"2026-04-07T09:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19691091,"change_date":"2026-03-27 21:39:00","inspection_id":"87414018","insp_unit_id":"212369441","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"RB98272","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDR8MSMV0467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:14.000000Z","updated_at":"2026-04-07T09:06:27.000000Z"},{"id":19691092,"change_date":"2026-03-27 21:39:00","inspection_id":"87414018","insp_unit_id":"212369442","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"UNIT-5376268","insp_unit_license":"E870013","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532K5RS053020","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:14.000000Z","updated_at":"2026-04-07T09:06:27.000000Z"}]},{"id":11150150,"change_date":"2026-03-06 21:42:00","inspection_id":"87064737","dot_number":"1540424","report_state":"MI","report_number":"STUDM00790","insp_date":"2026-02-13 00:00:00","insp_start_time":"1540","insp_end_time":"1620","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB FOWLERVILLE SCALE","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ACF","shipping_paper_number":"0205705","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1259293","transaction_code":"C","transaction_date":"2026-02-13 00:00:00","upload_date":"2026-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-17 21:39:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-20T10:37:50.000000Z","updated_at":"2026-03-17T09:30:32.000000Z","inspection_violations":[{"id":19020924,"change_date":"2026-03-06 21:42:00","inspection_id":"87064737","insp_violation_id":"272250175","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOLTIS","insp_viol_unit":"2","insp_unit_id":"212012963","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-09T10:08:23.000000Z","updated_at":"2026-03-17T09:40:59.000000Z","normalized_code":"39375A3TAOLTIS"}],"inspection_per_units":[{"id":19342555,"change_date":"2026-03-06 21:42:00","inspection_id":"87064737","insp_unit_id":"212012962","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"1034","insp_unit_license":"RC28587","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWDR4RLUY8555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:20.000000Z","updated_at":"2026-03-17T09:02:40.000000Z"},{"id":19342556,"change_date":"2026-03-06 21:42:00","inspection_id":"87064737","insp_unit_id":"212012963","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"526034","insp_unit_license":"3223908","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1DWA532XMSA46034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:20.000000Z","updated_at":"2026-03-17T09:02:40.000000Z"}]},{"id":10910200,"change_date":"2026-02-03 21:38:00","inspection_id":"86941975","dot_number":"1540424","report_state":"IN","report_number":"8322005954","insp_date":"2026-01-28 00:00:00","insp_start_time":"0635","insp_end_time":"0714","registration_date":null,"region":"ES","ci_status_code":"C","location":"UNK","location_desc":"FREMONT IN","county_code_state":"IN","county_code":"151","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RED GOLD","shipping_paper_number":"2042213","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-02-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"2838405","transaction_code":"A","transaction_date":"2026-02-02 00:00:00","upload_date":"2026-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":"2026-02-03 21:38:00","snet_input_date":"2026-01-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-03 21:38:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-06T10:35:10.000000Z","updated_at":"2026-02-14T10:30:06.000000Z","inspection_violations":[{"id":18275485,"change_date":"2026-02-03 21:38:00","inspection_id":"86941975","insp_violation_id":"271559603","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","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-02-06T10:45:22.000000Z","updated_at":"2026-02-14T10:37:58.000000Z","normalized_code":"3922SLLTCD"},{"id":18275486,"change_date":"2026-02-03 21:38:00","inspection_id":"86941975","insp_violation_id":"271559604","seq_no":"2","part_no":"392","part_no_section":"2-SLTFC","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-02-06T10:45:22.000000Z","updated_at":"2026-02-14T10:37:58.000000Z","normalized_code":"3922SLTFC"}],"inspection_per_units":[{"id":18347257,"change_date":"2026-02-03 21:38:00","inspection_id":"86941975","insp_unit_id":"211406483","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"1033","insp_unit_license":"RC11753","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWDR8NLNN4048","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-06T10:09:19.000000Z","updated_at":"2026-02-14T10:04:41.000000Z"},{"id":18347258,"change_date":"2026-02-03 21:38:00","inspection_id":"86941975","insp_unit_id":"211406484","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":"520783","insp_unit_license":"5262474","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1DW1A5324RBB46783","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-06T10:09:19.000000Z","updated_at":"2026-02-14T10:04:41.000000Z"}]},{"id":9323070,"change_date":"2025-08-04 21:39:00","inspection_id":"85398692","dot_number":"1540424","report_state":"MI","report_number":"DELMT02099","insp_date":"2025-07-31 00:00:00","insp_start_time":"1915","insp_end_time":"1945","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":"FIBRE CONVERTERS","shipping_paper_number":"341519","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-04 21:39: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":"1233904","transaction_code":"A","transaction_date":"2025-07-31 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-04 21:39:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:52.000000Z","updated_at":"2025-08-08T10:00:44.000000Z","inspection_violations":[{"id":15128046,"change_date":"2025-08-04 21:39:00","inspection_id":"85398692","insp_violation_id":"267824194","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4573265","created_at":"2025-08-07T10:45:37.000000Z","updated_at":"2025-08-08T10:43:53.000000Z","normalized_code":"3922SLLEWA3"}],"inspection_per_units":[{"id":15353921,"change_date":"2025-08-04 21:39:00","inspection_id":"85398692","insp_unit_id":"208225571","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RB98272","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDR8MSMV0467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:31.000000Z","updated_at":"2025-08-08T09:45:54.000000Z"},{"id":15353922,"change_date":"2025-08-04 21:39:00","inspection_id":"85398692","insp_unit_id":"208225572","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"D815109","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"13N1532C7J1523425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:31.000000Z","updated_at":"2025-08-08T09:45:54.000000Z"}]},{"id":7174717,"change_date":"2024-11-12 21:42:00","inspection_id":"83136115","dot_number":"1540424","report_state":"MI","report_number":"KIRKB04773","insp_date":"2024-11-07 00:00:00","insp_start_time":"1400","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-96 & US-23","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1201167","transaction_code":"A","transaction_date":"2024-11-07 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-12 21:42:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:36.000000Z","updated_at":"2025-03-17T20:45:36.000000Z","inspection_violations":[{"id":11209122,"change_date":"2024-11-12 21:42:00","inspection_id":"83136115","insp_violation_id":"262849061","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":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":11572585,"change_date":"2024-11-12 21:42:00","inspection_id":"83136115","insp_unit_id":"203842196","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"1034","insp_unit_license":"RC28587","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWDR4RLUY8555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"},{"id":11572586,"change_date":"2024-11-12 21:42:00","inspection_id":"83136115","insp_unit_id":"203842197","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"526034","insp_unit_license":"3223908","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1DW1A532XMSA46034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"}]},{"id":6813674,"change_date":"2024-10-04 21:39:00","inspection_id":"82752854","dot_number":"1540424","report_state":"IN","report_number":"8557005520","insp_date":"2024-09-24 00:00:00","insp_start_time":"0445","insp_end_time":"0525","registration_date":null,"region":"ED","ci_status_code":"C","location":"2269S","location_desc":"WARREN IN","county_code_state":"IN","county_code":"069","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ALUMINUM INSIGHTS","shipping_paper_number":"5561","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":"2024-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"882984","transaction_code":"C","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:13.000000Z","updated_at":"2025-03-17T20:38:13.000000Z","inspection_violations":[{"id":10610929,"change_date":"2024-10-04 21:39:00","inspection_id":"82752854","insp_violation_id":"262189733","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203270816","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"3922"},{"id":10610930,"change_date":"2024-10-04 21:39:00","inspection_id":"82752854","insp_violation_id":"262189734","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":"198505093","created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10987773,"change_date":"2024-10-04 21:39:00","inspection_id":"82752854","insp_unit_id":"203270816","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"232936","insp_unit_license":"3405719","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR7RN391368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:48.000000Z","updated_at":"2025-03-17T23:36:48.000000Z"},{"id":10987774,"change_date":"2024-10-04 21:39:00","inspection_id":"82752854","insp_unit_id":"203270817","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":"2029","insp_unit_license":"D612691","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"13N1532C1J1523422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:48.000000Z","updated_at":"2025-03-17T23:36:48.000000Z"}]},{"id":6815035,"change_date":"2024-09-25 21:41:00","inspection_id":"82754314","dot_number":"1540424","report_state":"IN","report_number":"5417008590","insp_date":"2024-09-19 00:00:00","insp_start_time":"1305","insp_end_time":"1400","registration_date":null,"region":"CD","ci_status_code":"C","location":"1394E","location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"G&W ELECTRIC","shipping_paper_number":"91478","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-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"884184","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:14.000000Z","updated_at":"2025-03-17T20:38:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10989946,"change_date":"2024-09-25 21:41:00","inspection_id":"82754314","insp_unit_id":"203120994","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1030","insp_unit_license":"RB98272","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDR8MSMV0467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:48.000000Z","updated_at":"2025-03-17T23:36:48.000000Z"},{"id":10989947,"change_date":"2024-09-25 21:41:00","inspection_id":"82754314","insp_unit_id":"203120995","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":"2037","insp_unit_license":"D815109","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"13N1532C7J1523425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:48.000000Z","updated_at":"2025-03-17T23:36:48.000000Z"}]},{"id":6769143,"change_date":"2024-09-19 21:42:00","inspection_id":"82705185","dot_number":"1540424","report_state":"IL","report_number":"3998321997","insp_date":"2024-09-18 00:00:00","insp_start_time":"0825","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":"033","location_desc":"033 - WILLIAMSVILLE - I-55 S\/B","county_code_state":"IL","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"GW INDUSTRIES","shipping_paper_number":"2425007","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-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2357863","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-18 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:20.000000Z","updated_at":"2025-03-17T20:37:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10915568,"change_date":"2024-09-19 21:42:00","inspection_id":"82705185","insp_unit_id":"203028686","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1030","insp_unit_license":"RB98272","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDR8MSMV0467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:05.000000Z","updated_at":"2025-03-17T23:36:05.000000Z"},{"id":10915569,"change_date":"2024-09-19 21:42:00","inspection_id":"82705185","insp_unit_id":"203028687","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"UNKNOWN","insp_unit_license":"D815109","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"13N1532C7J1523425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:05.000000Z","updated_at":"2025-03-17T23:36:05.000000Z"}]},{"id":6680175,"change_date":"2024-09-17 21:45:00","inspection_id":"82610642","dot_number":"1540424","report_state":"MI","report_number":"DEJOS01230","insp_date":"2024-09-05 00:00:00","insp_start_time":"1645","insp_end_time":"1705","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 E\/B @ SARGENT RD","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WEST MICHIGAN FARMS","shipping_paper_number":"2409939","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1194122","transaction_code":"C","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:36.000000Z","updated_at":"2025-03-17T20:35:36.000000Z","inspection_violations":[{"id":10396325,"change_date":"2024-09-17 21:45:00","inspection_id":"82610642","insp_violation_id":"261860527","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:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10770692,"change_date":"2024-09-17 21:45:00","inspection_id":"82610642","insp_unit_id":"202976694","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1030","insp_unit_license":"RB98272","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDR8MSMV0467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"},{"id":10770693,"change_date":"2024-09-17 21:45:00","inspection_id":"82610642","insp_unit_id":"202976695","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"D815109","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"13N1532C7J1523425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"}]},{"id":6220791,"change_date":"2024-09-16 21:43:00","inspection_id":"82120001","dot_number":"1540424","report_state":"MI","report_number":"ROLLJ02527","insp_date":"2024-07-11 00:00:00","insp_start_time":"1020","insp_end_time":"1116","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ 4 MILE REST AREA","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"T24-1247","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-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1185398","transaction_code":"C","transaction_date":"2024-07-11 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:09.000000Z","updated_at":"2025-03-17T20:26:09.000000Z","inspection_violations":[{"id":9662253,"change_date":"2024-09-16 21:43:00","inspection_id":"82120001","insp_violation_id":"261826514","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202946097","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4409072","created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"3922"},{"id":9662254,"change_date":"2024-09-16 21:43:00","inspection_id":"82120001","insp_violation_id":"261826515","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202946098","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"39347E"},{"id":9662255,"change_date":"2024-09-16 21:43:00","inspection_id":"82120001","insp_violation_id":"261826516","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"202946098","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":10022570,"change_date":"2024-09-16 21:43:00","inspection_id":"82120001","insp_unit_id":"202946097","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1027","insp_unit_license":"RB90459","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGEDR7CSBN0780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"},{"id":10022571,"change_date":"2024-09-16 21:43:00","inspection_id":"82120001","insp_unit_id":"202946098","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"2041","insp_unit_license":"E736225","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRDM0629DH717749","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"}]},{"id":6046785,"change_date":"2024-06-26 21:43:00","inspection_id":"81932917","dot_number":"1540424","report_state":"MI","report_number":"MCCLC02693","insp_date":"2024-06-20 00:00:00","insp_start_time":"1545","insp_end_time":"1623","registration_date":null,"region":"ET","ci_status_code":"C","location":"531","location_desc":"E\/B NEW BUFFALO SCALE","county_code_state":"MI","county_code":"021","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"166208","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"119757","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":"1183445","transaction_code":"C","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-21 21:39:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:36.000000Z","updated_at":"2025-03-17T20:22:36.000000Z","inspection_violations":[{"id":9379489,"change_date":"2024-06-26 21:43:00","inspection_id":"81932917","insp_violation_id":"260328531","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:51:21.000000Z","updated_at":"2025-03-17T21:51:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9739002,"change_date":"2024-06-26 21:43:00","inspection_id":"81932917","insp_unit_id":"201606485","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"IHC","insp_unit_company":"232936","insp_unit_license":"3405719","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR7RN391368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:53.000000Z","updated_at":"2025-03-17T23:23:53.000000Z"},{"id":9739003,"change_date":"2024-06-26 21:43:00","inspection_id":"81932917","insp_unit_id":"201606486","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONT","insp_unit_company":"2029","insp_unit_license":"D612691","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"13N1532C1J1523422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:53.000000Z","updated_at":"2025-03-17T23:23:53.000000Z"}]},{"id":4333253,"change_date":"2023-11-01 21:43:00","inspection_id":"80061991","dot_number":"1540424","report_state":"MI","report_number":"JURKV02383","insp_date":"2023-10-31 00:00:00","insp_start_time":"1215","insp_end_time":"1238","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"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":"CORTEVA AGRISCIENCE","shipping_paper_number":"IMPACT2023SH","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-11-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"123950","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":"1151696","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-01 21:43:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:45.000000Z","updated_at":"2025-03-17T19:48:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6968716,"change_date":"2023-11-01 21:43:00","inspection_id":"80061991","insp_unit_id":"197859313","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1018","insp_unit_license":"RB48981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJA6CK97LX18875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:29.000000Z","updated_at":"2025-03-17T22:58:29.000000Z"},{"id":6968717,"change_date":"2023-11-01 21:43:00","inspection_id":"80061991","insp_unit_id":"197859314","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":null,"insp_unit_license":"DA4798","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1LH825VH2D1C19925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:29.000000Z","updated_at":"2025-03-17T22:58:29.000000Z"}]},{"id":3674563,"change_date":"2023-08-29 21:42:00","inspection_id":"79330198","dot_number":"1540424","report_state":"MI","report_number":"LULAN01928","insp_date":"2023-08-03 00:00:00","insp_start_time":"1425","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"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-08-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1138226","transaction_code":"C","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:19.000000Z","updated_at":"2025-03-17T19:35:19.000000Z","inspection_violations":[{"id":5664027,"change_date":"2023-08-29 21:42:00","inspection_id":"79330198","insp_violation_id":"254955280","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:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5907848,"change_date":"2023-08-29 21:42:00","inspection_id":"79330198","insp_unit_id":"196790171","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"3405719","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR7RN391368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:40.000000Z","updated_at":"2025-03-17T22:49:40.000000Z"},{"id":5907849,"change_date":"2023-08-29 21:42:00","inspection_id":"79330198","insp_unit_id":"196790172","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"E736225","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRDM0629DH717749","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:40.000000Z","updated_at":"2025-03-17T22:49:40.000000Z"}]},{"id":3107154,"change_date":"2023-05-22 21:41:00","inspection_id":"78691379","dot_number":"1540424","report_state":"MI","report_number":"VANHJ03551","insp_date":"2023-05-19 00:00:00","insp_start_time":"1000","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":"591","location_desc":"COLDWATER SCALE","county_code_state":"MI","county_code":"023","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"OHIO LOGISTICS","shipping_paper_number":"7089564TLG","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1127162","transaction_code":"A","transaction_date":"2023-05-19 00:00:00","upload_date":"2023-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-22 21:41:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:34.000000Z","updated_at":"2025-03-17T19:24:34.000000Z","inspection_violations":[{"id":4779296,"change_date":"2023-05-22 21:41:00","inspection_id":"78691379","insp_violation_id":"252988586","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"195067178","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":4997655,"change_date":"2023-05-22 21:41:00","inspection_id":"78691379","insp_unit_id":"195067178","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1030","insp_unit_license":"RB98272","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDR8MSMV0467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:24.000000Z","updated_at":"2025-03-17T22:42:24.000000Z"},{"id":4997656,"change_date":"2023-05-22 21:41:00","inspection_id":"78691379","insp_unit_id":"195067179","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"530748","insp_unit_license":"D663019","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5321JBA00748","insp_unit_decal":"Y","insp_unit_decal_number":"32661365","created_at":"2025-03-17T22:42:24.000000Z","updated_at":"2025-03-17T22:42:24.000000Z"}]},{"id":2910006,"change_date":"2023-04-27 21:43:00","inspection_id":"78469039","dot_number":"1540424","report_state":"MI","report_number":"LULAN01768","insp_date":"2023-04-26 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-94 @ RAWSONVILLE","county_code_state":"MI","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MEANSII","shipping_paper_number":"80166816","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1123657","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":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-27 21:43:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","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":4464286,"change_date":"2023-04-27 21:43:00","inspection_id":"78469039","insp_violation_id":"252483667","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":"X4203004","created_at":"2025-03-17T21:27:50.000000Z","updated_at":"2025-03-17T21:27:50.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4681644,"change_date":"2023-04-27 21:43:00","inspection_id":"78469039","insp_unit_id":"194626687","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RA67838","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJA6AS44LM29210","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":4681645,"change_date":"2023-04-27 21:43:00","inspection_id":"78469039","insp_unit_id":"194626688","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"D663018","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5320JBA00823","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":2491995,"change_date":"2023-03-02 21:41:00","inspection_id":"77993759","dot_number":"1540424","report_state":"MI","report_number":"LARSE03069","insp_date":"2023-03-01 00:00:00","insp_start_time":"1115","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"FROM 22 MILE RD","county_code_state":"MI","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1115589","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-02 21:41:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:32.000000Z","updated_at":"2025-03-17T19:12:32.000000Z","inspection_violations":[{"id":3833076,"change_date":"2023-03-02 21:41:00","inspection_id":"77993759","insp_violation_id":"251442757","seq_no":"1","part_no":"392","part_no_section":"22(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4177412","created_at":"2025-03-17T21:25:00.000000Z","updated_at":"2025-03-17T21:25:00.000000Z","normalized_code":"39222B"}],"inspection_per_units":[{"id":4010009,"change_date":"2023-03-02 21:41:00","inspection_id":"77993759","insp_unit_id":"193675170","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1027","insp_unit_license":"RB90459","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGEDR7CSBN0780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:45.000000Z","updated_at":"2025-03-17T22:34:45.000000Z"},{"id":4010010,"change_date":"2023-03-02 21:41:00","inspection_id":"77993759","insp_unit_id":"193675171","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"530823","insp_unit_license":"D663018","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5320JBA00823","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:45.000000Z","updated_at":"2025-03-17T22:34:45.000000Z"}]},{"id":2114921,"change_date":"2023-01-11 21:42:00","inspection_id":"77563509","dot_number":"1540424","report_state":"MI","report_number":"HICKG01998","insp_date":"2023-01-11 00:00:00","insp_start_time":"0800","insp_end_time":"0815","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B I-96 @ MM 110","county_code_state":"MI","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PAPERTECH","shipping_paper_number":"TN03869","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-01-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1108449","transaction_code":"A","transaction_date":"2023-01-11 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-11 21:42:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:33.000000Z","updated_at":"2025-03-17T19:05:33.000000Z","inspection_violations":[{"id":3274411,"change_date":"2023-01-11 21:42:00","inspection_id":"77563509","insp_violation_id":"250507129","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3403800,"change_date":"2023-01-11 21:42:00","inspection_id":"77563509","insp_unit_id":"192809960","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1062","insp_unit_license":"RB84957","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGEDV7DLFF0536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:23.000000Z","updated_at":"2025-03-17T22:30:23.000000Z"},{"id":3403801,"change_date":"2023-01-11 21:42:00","inspection_id":"77563509","insp_unit_id":"192809961","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"522569","insp_unit_license":"3314606","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1DW1A5326NSA62569","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:23.000000Z","updated_at":"2025-03-17T22:30:23.000000Z"}]},{"id":1842892,"change_date":"2022-11-30 21:40:00","inspection_id":"77252254","dot_number":"1540424","report_state":"MI","report_number":"MOREM04474","insp_date":"2022-11-29 00:00:00","insp_start_time":"0844","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GREEN ROAD 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":"MICHIGAN POLYMER RECLAIM","shipping_paper_number":"22140&22147","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1103753","transaction_code":"A","transaction_date":"2022-11-29 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-30 21:40:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:42.000000Z","updated_at":"2025-03-17T19:00:42.000000Z","inspection_violations":[{"id":2874458,"change_date":"2022-11-30 21:40:00","inspection_id":"77252254","insp_violation_id":"249850663","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":"X4148770","created_at":"2025-03-17T21:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"3922"},{"id":2874459,"change_date":"2022-11-30 21:40:00","inspection_id":"77252254","insp_violation_id":"249850664","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:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2965107,"change_date":"2022-11-30 21:40:00","inspection_id":"77252254","insp_unit_id":"192192793","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"1033","insp_unit_license":"RC11753","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWDR8NLNN4048","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:18.000000Z","updated_at":"2025-03-17T22:27:18.000000Z"},{"id":2965108,"change_date":"2022-11-30 21:40:00","inspection_id":"77252254","insp_unit_id":"192192794","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"E318175","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A532XGB690246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:18.000000Z","updated_at":"2025-03-17T22:27:18.000000Z"}]},{"id":1248335,"change_date":"2022-09-09 21:38:00","inspection_id":"76566389","dot_number":"1540424","report_state":"IN","report_number":"5508007805","insp_date":"2022-09-08 00:00:00","insp_start_time":"0931","insp_end_time":"1012","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US30 EB","county_code_state":"IN","county_code":"089","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2022-09-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2147932","transaction_code":"A","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-09 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-09-09 21:38:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:43.000000Z","updated_at":"2025-03-17T18:49:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2008927,"change_date":"2022-09-09 21:38:00","inspection_id":"76566389","insp_unit_id":"190809440","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1027","insp_unit_license":"RB90459","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGEDR7CSBN0780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:48.000000Z","updated_at":"2025-03-17T22:20:48.000000Z"},{"id":2008928,"change_date":"2022-09-09 21:38:00","inspection_id":"76566389","insp_unit_id":"190809441","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"2034","insp_unit_license":"D814110","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5321JBA00944","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:48.000000Z","updated_at":"2025-03-17T22:20:48.000000Z"}]},{"id":1216741,"change_date":"2022-09-06 21:42:00","inspection_id":"76530127","dot_number":"1540424","report_state":"MI","report_number":"STUDM00538","insp_date":"2022-09-02 00:00:00","insp_start_time":"1220","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M21\/TALLMAN RD","county_code_state":"MI","county_code":"037","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1092777","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-06 21:42:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:01.000000Z","updated_at":"2025-03-17T18:49:01.000000Z","inspection_violations":[{"id":1927342,"change_date":"2022-09-06 21:42:00","inspection_id":"76530127","insp_violation_id":"248224698","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:15:54.000000Z","updated_at":"2025-03-17T21:15:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1957446,"change_date":"2022-09-06 21:42:00","inspection_id":"76530127","insp_unit_id":"190734943","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"297365","insp_unit_license":"3238497","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDR5NSNT9188","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:27.000000Z","updated_at":"2025-03-17T22:20:27.000000Z"},{"id":1957447,"change_date":"2022-09-06 21:42:00","inspection_id":"76530127","insp_unit_id":"190734944","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"526034","insp_unit_license":"3223908","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1DW1A532XMSA46034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:27.000000Z","updated_at":"2025-03-17T22:20:27.000000Z"}]},{"id":680303,"change_date":"2022-06-23 21:40:00","inspection_id":"75903186","dot_number":"1540424","report_state":"IN","report_number":"7177001610","insp_date":"2022-06-22 00:00:00","insp_start_time":"1240","insp_end_time":"1306","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SR265 EB @ 11MM","county_code_state":"IN","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"DANA CORPORATION","shipping_paper_number":"070918","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":"I","final_status_date":"2022-06-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122500","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":"2135182","transaction_code":"A","transaction_date":"2022-06-23 00:00:00","upload_date":"2022-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-23 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-06-23 21:40:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:47.000000Z","updated_at":"2025-03-17T18:39:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1093101,"change_date":"2022-06-23 21:40:00","inspection_id":"75903186","insp_unit_id":"189427839","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1032","insp_unit_license":"RC04565","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHLDVXNDND4582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:55.000000Z","updated_at":"2025-03-17T22:14:55.000000Z"},{"id":1093102,"change_date":"2022-06-23 21:40:00","inspection_id":"75903186","insp_unit_id":"189427840","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"D647879","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5321JBA00927","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:55.000000Z","updated_at":"2025-03-17T22:14:55.000000Z"}]},{"id":488550,"change_date":"2022-05-26 21:42:00","inspection_id":"75675764","dot_number":"1540424","report_state":"TN","report_number":"TESE000399","insp_date":"2022-05-24 00:00:00","insp_start_time":"1037","insp_end_time":"1046","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"INTERSTATE","county_code_state":"TN","county_code":"093","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"FOUNDERS BREWING CO","shipping_paper_number":"100734","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1575398","transaction_code":"A","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-26 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-05-26 21:42:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:19.000000Z","updated_at":"2025-03-17T18:36:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":785520,"change_date":"2022-05-26 21:42:00","inspection_id":"75675764","insp_unit_id":"188926784","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"D663019","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5321JBA00748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:02.000000Z","updated_at":"2025-03-17T22:13:02.000000Z"},{"id":785521,"change_date":"2022-05-26 21:42:00","inspection_id":"75675764","insp_unit_id":"188926785","insp_unit_type_id":"11","insp_unit_number":"2","insp_unit_make":"FRHT","insp_unit_company":"030","insp_unit_license":"RB98272","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDR8MSMV0467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:02.000000Z","updated_at":"2025-03-17T22:13:02.000000Z"}]},{"id":418566,"change_date":"2022-05-18 21:43:00","inspection_id":"75592196","dot_number":"1540424","report_state":"TN","report_number":"BBAA035503","insp_date":"2022-05-18 00:00:00","insp_start_time":"0824","insp_end_time":"0844","registration_date":null,"region":"ET","ci_status_code":"C","location":"SCALES","location_desc":"THP1 KNOX SCALES WEST","county_code_state":"TN","county_code":"093","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"WATERVILLE PLANT","shipping_paper_number":"7101641935","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122500","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":"1573050","transaction_code":"A","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01540424","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-18 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-05-18 21:43:00","insp_carrier_name":"MERCHANT EXCAVATING INC","insp_carrier_street":"4040 N STATE ROAD","insp_carrier_city":"ALMA","insp_carrier_state":"MI","insp_carrier_zip_code":"48801","insp_colonia":null,"docket_number":"729124","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:50.000000Z","updated_at":"2025-03-17T18:34:50.000000Z","inspection_violations":[{"id":655035,"change_date":"2022-05-18 21:43:00","inspection_id":"75592196","insp_violation_id":"245876942","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188756964","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:10:04.000000Z","updated_at":"2025-03-17T21:10:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":675516,"change_date":"2022-05-18 21:43:00","inspection_id":"75592196","insp_unit_id":"188756964","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1032","insp_unit_license":"RC04565","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHLDVXNDND4582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:21.000000Z","updated_at":"2025-03-17T22:12:21.000000Z"},{"id":675517,"change_date":"2022-05-18 21:43:00","inspection_id":"75592196","insp_unit_id":"188756965","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"2030","insp_unit_license":"D647879","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5321JBA00927","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:21.000000Z","updated_at":"2025-03-17T22:12:21.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1540424\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1540424\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1540424\/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\/1540424\/inspections","per_page":100,"prev_page_url":null,"to":23,"total":23}