{"current_page":1,"data":[{"id":12531018,"change_date":"2026-07-23 21:41:00","inspection_id":"88497038","dot_number":"572469","report_state":"MI","report_number":"POWEL04388","insp_date":"2026-07-23 00:00:00","insp_start_time":"0945","insp_end_time":"1017","registration_date":null,"region":"ED","ci_status_code":"C","location":"122","location_desc":"MI","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","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":"U","pen_cen_match":"I","final_status_date":"2026-07-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"3819933","transaction_code":"A","transaction_date":"2026-07-23 00:00:00","upload_date":"2026-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":"2026-07-23 21:41:00","snet_input_date":"2026-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-23 21:41:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-26T09:42:26.000000Z","updated_at":"2026-08-03T09:31:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22086300,"change_date":null,"inspection_id":"88497038","insp_unit_id":"sms-backfill-796473342-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC44635","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X0SJ131513","insp_unit_decal":null,"insp_unit_decal_number":"36679565","created_at":"2026-08-17T03:29:46.000000Z","updated_at":"2026-08-17T03:29:46.000000Z"},{"id":22089952,"change_date":null,"inspection_id":"88497038","insp_unit_id":"sms-backfill-796473342-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"D397668","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA06297B703045","insp_unit_decal":null,"insp_unit_decal_number":"36679566","created_at":"2026-08-17T03:29:46.000000Z","updated_at":"2026-08-17T03:29:46.000000Z"}]},{"id":11396129,"change_date":"2026-03-20 21:39:00","inspection_id":"87310970","dot_number":"572469","report_state":"KY","report_number":"CV44783109","insp_date":"2026-03-16 00:00:00","insp_start_time":"1445","insp_end_time":"1532","registration_date":"2026-03-20 00:00:00","region":"ET","ci_status_code":"C","location":"9812","location_desc":"LONDON","county_code_state":"KY","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"ERG ENVIRONMENTAL","shipping_paper_number":"108593","cargo_tank":null,"hazmat_placard_req":"N","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-03-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"128600","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":"2335317","transaction_code":"C","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-03-17 00:00:00","source_office":"2KYS001","mcmis_add_date":"2026-03-17 21:39:00","insp_carrier_name":"ERG ENVIRONMENTAL SERVICES","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-20T09:42:32.000000Z","updated_at":"2026-03-31T09:30:16.000000Z","inspection_violations":[{"id":20299476,"change_date":null,"inspection_id":"87310970","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"39375A3TAOL"},{"id":20299477,"change_date":null,"inspection_id":"87310970","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"39395A4EEUS"},{"id":20299478,"change_date":null,"inspection_id":"87310970","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":20329262,"change_date":null,"inspection_id":"87310970","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB89031","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X2MJ438149","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"},{"id":20335369,"change_date":null,"inspection_id":"87310970","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"28-27621","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D7AL412951","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":10348539,"change_date":"2025-12-04 21:37:00","inspection_id":"86476346","dot_number":"572469","report_state":"TN","report_number":"I030C30087","insp_date":"2025-12-02 00:00:00","insp_start_time":"1450","insp_end_time":"1517","registration_date":null,"region":"ES","ci_status_code":"C","location":"KNXWS","location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"ERG ENVIORNMENTAL","shipping_paper_number":"108241","cargo_tank":null,"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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-04 21:37: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":"2613686","transaction_code":"A","transaction_date":"2025-12-03 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":"2025-12-04 21:37:00","snet_input_date":"2025-12-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-04 21:37:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-07T10:31:10.000000Z","updated_at":"2025-12-08T10:30:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18751274,"change_date":null,"inspection_id":"86476346","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC01437","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD49X2MR452978","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18835902,"change_date":null,"inspection_id":"86476346","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":null,"insp_unit_license":"TPH9321","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A5328XS272221","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10056598,"change_date":"2025-10-28 21:40:00","inspection_id":"86169683","dot_number":"572469","report_state":"MI","report_number":"LAUEJ02035","insp_date":"2025-10-27 00:00:00","insp_start_time":"1350","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":"831","location_desc":"MACKINAC BRIDGE","county_code_state":"MI","county_code":"097","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":"N","pen_cen_match":null,"final_status_date":"2025-10-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1248030","transaction_code":"A","transaction_date":"2025-10-27 00:00:00","upload_date":"2025-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-28 21:40:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:02:03.000000Z","updated_at":"2025-11-01T10:02:03.000000Z","inspection_violations":[{"id":18484378,"change_date":null,"inspection_id":"86169683","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":18669705,"change_date":null,"inspection_id":"86169683","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC21039","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM7X2HM175918","insp_unit_decal":null,"insp_unit_decal_number":"35769245","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9845271,"change_date":"2025-10-03 21:39:00","inspection_id":"85946874","dot_number":"572469","report_state":"US","report_number":"1992000019","insp_date":"2025-10-02 00:00:00","insp_start_time":"1306","insp_end_time":"1331","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LASSALE MI","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ERG ENVIRONMENTAL SERVICES","shipping_paper_number":"5071825-A","cargo_tank":null,"hazmat_placard_req":"N","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-10-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2361107","transaction_code":"A","transaction_date":"2025-10-03 00:00:00","upload_date":"2025-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":"2025-10-03 21:39:00","snet_input_date":"2025-10-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-03 21:39:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-05T10:02:12.000000Z","updated_at":"2025-10-08T10:00:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18744968,"change_date":null,"inspection_id":"85946874","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC21039","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM7X2HM175918","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9439674,"change_date":"2025-08-18 21:39:00","inspection_id":"85521351","dot_number":"572469","report_state":"MI","report_number":"REBIM00316","insp_date":"2025-08-14 00:00:00","insp_start_time":"1222","insp_end_time":"1312","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SWARTZ CREEK REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"LG ENERGY SOLUTIONS","shipping_paper_number":"3081425B","cargo_tank":null,"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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"126600","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":"1236369","transaction_code":"A","transaction_date":"2025-08-14 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:45:58.000000Z","updated_at":"2025-08-23T10:45:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18739832,"change_date":null,"inspection_id":"85521351","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB89034","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X9MJ438147","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18823624,"change_date":null,"inspection_id":"85521351","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"E235911","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5V8VA5326AM001819","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9364325,"change_date":"2025-08-08 21:39:00","inspection_id":"85442044","dot_number":"572469","report_state":"MI","report_number":"BURGM06863","insp_date":"2025-08-07 00:00:00","insp_start_time":"1025","insp_end_time":"1104","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"LG ENERGY SOLUTION","shipping_paper_number":"3080725","cargo_tank":null,"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-08-08 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":"1235054","transaction_code":"A","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-08 21:39:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:14.000000Z","updated_at":"2025-08-12T10:44:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18661337,"change_date":null,"inspection_id":"85442044","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC44635","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X0SJ131513","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18822713,"change_date":null,"inspection_id":"85442044","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"TPH9321","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A5328XS272221","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9205399,"change_date":"2025-07-21 21:41:00","inspection_id":"85274847","dot_number":"572469","report_state":"MI","report_number":"ARCHH01259","insp_date":"2025-07-19 00:00:00","insp_start_time":"1330","insp_end_time":"1352","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B I75@ 4 MILE REST AREA","county_code_state":"MI","county_code":"039","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"MULT","cargo_tank":null,"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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"128600","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":"1231459","transaction_code":"A","transaction_date":"2025-07-19 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-21 21:41:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:31.000000Z","updated_at":"2025-07-25T10:45:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18737028,"change_date":null,"inspection_id":"85274847","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB89033","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X0MJ438148","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18820704,"change_date":null,"inspection_id":"85274847","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"E225341","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5V8VA53245M500902","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9077843,"change_date":"2025-07-07 21:40:00","inspection_id":"85140748","dot_number":"572469","report_state":"MI","report_number":"DELMT02028","insp_date":"2025-07-03 00:00:00","insp_start_time":"1505","insp_end_time":"1650","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":"HOLTEC","shipping_paper_number":"MULTIPLE","cargo_tank":null,"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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-07 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":"1","hazmat_oos_total":"0","snet_sequence_id":"1228942","transaction_code":"A","transaction_date":"2025-07-03 00:00:00","upload_date":"2025-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-07 21:40:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:34.000000Z","updated_at":"2025-07-11T10:44:34.000000Z","inspection_violations":[{"id":18459242,"change_date":null,"inspection_id":"85140748","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"516C1-HMPMC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"172516C1HMPMC"}],"inspection_per_units":[{"id":18657927,"change_date":null,"inspection_id":"85140748","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB89033","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X0MJ438148","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18819063,"change_date":null,"inspection_id":"85140748","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"E175785","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5V8VA532XAM00180","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9051817,"change_date":"2025-07-02 21:40:00","inspection_id":"85113219","dot_number":"572469","report_state":"MI","report_number":"ARCHH01253","insp_date":"2025-07-01 00:00:00","insp_start_time":"1230","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US31@JOHNSON RD","county_code_state":"MI","county_code":"047","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CLEAN FUELS","shipping_paper_number":"08063025A","cargo_tank":null,"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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"1228195","transaction_code":"A","transaction_date":"2025-07-01 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-02 21:40:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:24.000000Z","updated_at":"2025-07-07T10:07:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18735163,"change_date":null,"inspection_id":"85113219","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC10064","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD49X1NR106745","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18818701,"change_date":null,"inspection_id":"85113219","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"E805677","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GR1A0628LB209060","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7934568,"change_date":"2025-02-22 21:33:00","inspection_id":"83935061","dot_number":"572469","report_state":"OH","report_number":"1532000274","insp_date":"2025-02-19 00:00:00","insp_start_time":"1054","insp_end_time":"1206","registration_date":null,"region":"ES","ci_status_code":"C","location":"OTP MP","location_desc":"YOUNGSTOWN OH","county_code_state":"OH","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"019617865","cargo_tank":null,"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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-22 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","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":"1387186","transaction_code":"A","transaction_date":"2025-02-22 00:00:00","upload_date":"2025-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":"2025-02-22 21:33:00","snet_input_date":"2025-02-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-22 21:33:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:52.000000Z","updated_at":"2025-03-17T21:02:52.000000Z","inspection_violations":[{"id":18439571,"change_date":null,"inspection_id":"83935061","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":18642858,"change_date":null,"inspection_id":"83935061","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC01437","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD49X2MR452978","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18802628,"change_date":null,"inspection_id":"83935061","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"D665239","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV482D6CL638773","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7763640,"change_date":"2025-02-01 21:33:00","inspection_id":"83755641","dot_number":"572469","report_state":"OH","report_number":"1532000225","insp_date":"2025-01-29 00:00:00","insp_start_time":"0845","insp_end_time":"1015","registration_date":null,"region":"ES","ci_status_code":"C","location":"76AA","location_desc":"YOUNGSTOWN OH","county_code_state":"OH","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ERG ENVIRONMENTAL SERVICES","shipping_paper_number":"019618095","cargo_tank":null,"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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-01 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1312300","transaction_code":"A","transaction_date":"2025-02-01 00:00:00","upload_date":"2025-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":"2025-02-01 21:33:00","snet_input_date":"2025-01-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-01 21:33:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:30.000000Z","updated_at":"2025-03-17T20:59:30.000000Z","inspection_violations":[{"id":18436793,"change_date":null,"inspection_id":"83755641","insp_violation_id":null,"seq_no":null,"part_no":"177","part_no_section":"817E1-HMHC","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"177817E1HMHC"},{"id":18436794,"change_date":null,"inspection_id":"83755641","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":18640687,"change_date":null,"inspection_id":"83755641","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC01437","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD49X2MR452978","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18800239,"change_date":null,"inspection_id":"83755641","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"245876G","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV482V6BL370041","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5030445,"change_date":"2024-02-12 21:41:00","inspection_id":"80826714","dot_number":"572469","report_state":"MI","report_number":"JURKV02476","insp_date":"2024-02-09 00:00:00","insp_start_time":"0645","insp_end_time":"0707","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":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-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116300","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":"1164354","transaction_code":"A","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-12 21:41:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:23.000000Z","updated_at":"2025-03-17T20:02:23.000000Z","inspection_violations":[{"id":18386498,"change_date":null,"inspection_id":"80826714","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":18680215,"change_date":null,"inspection_id":"80826714","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC01437","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD49X2MR452978","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18758540,"change_date":null,"inspection_id":"80826714","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":null,"insp_unit_license":"D378361","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3BD2E9536XX445153","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4786127,"change_date":"2024-01-08 21:45:00","inspection_id":"80559357","dot_number":"572469","report_state":"MI","report_number":"PATTM04554","insp_date":"2024-01-08 00:00:00","insp_start_time":"0640","insp_end_time":"0700","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"075","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":"2024-01-08 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"1159868","transaction_code":"A","transaction_date":"2024-01-08 00:00:00","upload_date":"2024-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-08 21:45:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:38.000000Z","updated_at":"2025-03-17T19:57:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18676548,"change_date":null,"inspection_id":"80559357","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC01437","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD49X2MR452978","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4766060,"change_date":"2024-01-05 21:46:00","inspection_id":"80537345","dot_number":"572469","report_state":"MI","report_number":"GUTHG02497","insp_date":"2024-01-03 00:00:00","insp_start_time":"1733","insp_end_time":"1815","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"FWY SHOULDER","county_code_state":"MI","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-04 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"143100","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":"1159326","transaction_code":"C","transaction_date":"2024-01-03 00:00:00","upload_date":"2024-01-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-04 21:47:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:15.000000Z","updated_at":"2025-03-17T19:57:15.000000Z","inspection_violations":[{"id":18381738,"change_date":null,"inspection_id":"80537345","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLSWZ"}],"inspection_per_units":[{"id":18676243,"change_date":null,"inspection_id":"80537345","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC26261","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD40X2RR326429","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18754166,"change_date":null,"inspection_id":"80537345","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"ACRO","insp_unit_company":null,"insp_unit_license":"E265836","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1A9115345A1005031","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4685727,"change_date":"2023-12-21 21:39:00","inspection_id":"80449991","dot_number":"572469","report_state":"MI","report_number":"WILLD03080","insp_date":"2023-12-19 00:00:00","insp_start_time":"1340","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 & TELEGRAPH","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"407","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1158086","transaction_code":"A","transaction_date":"2023-12-19 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-21 21:39:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:45.000000Z","updated_at":"2025-03-17T19:55:45.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4519860,"change_date":"2023-11-29 21:42:00","inspection_id":"80267705","dot_number":"572469","report_state":"MI","report_number":"DETGT04516","insp_date":"2023-11-28 00:00:00","insp_start_time":"1435","insp_end_time":"1522","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":"CONSUMERS ENERGY","shipping_paper_number":"MID087050506","cargo_tank":null,"hazmat_placard_req":"N","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-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"1155024","transaction_code":"A","transaction_date":"2023-11-28 00:00:00","upload_date":"2023-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-29 21:42:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:15.000000Z","updated_at":"2025-03-17T19:52:15.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4391857,"change_date":"2023-11-09 21:41:00","inspection_id":"80126990","dot_number":"572469","report_state":"MI","report_number":"VANHJ03801","insp_date":"2023-11-08 00:00:00","insp_start_time":"1000","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"22 1\/2 MILE RD","county_code_state":"MI","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HIGH PERFORMANCE","shipping_paper_number":"16342174FLE","cargo_tank":"306","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-09 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":"1152919","transaction_code":"A","transaction_date":"2023-11-08 00:00:00","upload_date":"2023-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-09 21:41:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:53.000000Z","updated_at":"2025-03-17T19:49:53.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4034136,"change_date":"2023-09-22 21:39:00","inspection_id":"79730728","dot_number":"572469","report_state":"MI","report_number":"ESCOT02031","insp_date":"2023-09-21 00:00:00","insp_start_time":"0910","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"SB US-23@9MM","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S-C","shipping_paper_number":"090823B","cargo_tank":null,"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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-22 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":"1147196","transaction_code":"A","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-22 21:39:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:26.000000Z","updated_at":"2025-03-17T19:42:26.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4034148,"change_date":"2023-09-22 21:39:00","inspection_id":"79730741","dot_number":"572469","report_state":"MI","report_number":"ESCOT02034","insp_date":"2023-09-21 00:00:00","insp_start_time":"1215","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"NB US-23@5MM","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S-C","shipping_paper_number":"1HW091623-D","cargo_tank":null,"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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1147136","transaction_code":"A","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-22 21:39:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:26.000000Z","updated_at":"2025-03-17T19:42:26.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3858840,"change_date":"2023-08-29 21:42:00","inspection_id":"79535838","dot_number":"572469","report_state":"MI","report_number":"ZASTM01642","insp_date":"2023-08-29 00:00:00","insp_start_time":"1135","insp_end_time":"1156","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ TOLLS","county_code_state":"MI","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"MULTIPLE","cargo_tank":null,"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":"N","traffic_enf":"N","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":"119200","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":"1143231","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":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-29 21:42:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","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":[],"inspection_per_units":[]},{"id":3053519,"change_date":"2023-05-16 21:42:00","inspection_id":"78631179","dot_number":"572469","report_state":"MI","report_number":"BLAKD03813","insp_date":"2023-05-16 00:00:00","insp_start_time":"0615","insp_end_time":"0633","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"SB 75 @ LAPLAISANCE","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1126256","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-16 21:42:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:24.000000Z","updated_at":"2025-03-17T19:23:24.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2955792,"change_date":"2023-05-04 21:41:00","inspection_id":"78520511","dot_number":"572469","report_state":"OH","report_number":"1251009771","insp_date":"2023-05-03 00:00:00","insp_start_time":"0754","insp_end_time":"0838","registration_date":null,"region":"ET","ci_status_code":"C","location":"15580","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"155","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"ALBAR INDUSTRIES","shipping_paper_number":"017018277","cargo_tank":null,"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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-03 21:42: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":"1653916","transaction_code":"C","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-03 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-05-03 21:42:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN SUITE 200","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:25.000000Z","updated_at":"2025-03-17T19:21:25.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2818108,"change_date":"2023-04-17 21:41:00","inspection_id":"78364907","dot_number":"572469","report_state":"MI","report_number":"DAWDD02635","insp_date":"2023-04-14 00:00:00","insp_start_time":"1420","insp_end_time":"1441","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT INKSTER","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1122042","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":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-17 21:41:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","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":[],"inspection_per_units":[]},{"id":2114917,"change_date":"2023-01-11 21:42:00","inspection_id":"77563504","dot_number":"572469","report_state":"MI","report_number":"ARCHH00931","insp_date":"2023-01-10 00:00:00","insp_start_time":"1330","insp_end_time":"1404","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75@MM279","county_code_state":"MI","county_code":"137","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SOO MARINE SUPPLY","shipping_paper_number":"017289072","cargo_tank":null,"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":"N","traffic_enf":"N","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":"119200","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":"1108519","transaction_code":"A","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-11 21:42:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","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":[],"inspection_per_units":[]},{"id":1254573,"change_date":"2022-09-11 21:30:00","inspection_id":"76573564","dot_number":"572469","report_state":"MI","report_number":"GENTC02298","insp_date":"2022-09-09 00:00:00","insp_start_time":"1020","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB US-23 @ STONY CREEK RD","county_code_state":"MI","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ENVIRONMENTAL RECYCLING","shipping_paper_number":"09092022","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-11 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"128600","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":"1094218","transaction_code":"A","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-11 21:30:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:45.000000Z","updated_at":"2025-03-17T18:49:45.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":748568,"change_date":"2022-07-05 21:42:00","inspection_id":"75983744","dot_number":"572469","report_state":"MI","report_number":"CHESJ04357","insp_date":"2022-07-05 00:00:00","insp_start_time":"0730","insp_end_time":"0800","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E I-96 @ 8 MILE","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TRIBAR","shipping_paper_number":"016341913","cargo_tank":null,"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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"1082443","transaction_code":"A","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:53.000000Z","updated_at":"2025-03-17T18:40:53.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":627427,"change_date":"2022-06-16 21:43:00","inspection_id":"75840877","dot_number":"572469","report_state":"MI","report_number":"GENTC02140","insp_date":"2022-06-14 00:00:00","insp_start_time":"0935","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB US-23 @ BEMIS REST AREA","county_code_state":"MI","county_code":"161","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":"2022-06-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1079700","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-16 21:43:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:48.000000Z","updated_at":"2025-03-17T18:38:48.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":279895,"change_date":"2022-04-28 21:40:00","inspection_id":"75427219","dot_number":"572469","report_state":"OH","report_number":"3217300787","insp_date":"2022-04-28 00:00:00","insp_start_time":"1231","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE CR508","county_code_state":"OH","county_code":"095","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-04-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1594124","transaction_code":"A","transaction_date":"2022-04-28 00:00:00","upload_date":"2022-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00572469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-28 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-04-28 21:40:00","insp_carrier_name":"SQS INC","insp_carrier_street":"13040 MERRIMAN SUITE 200","insp_carrier_city":"LIVONIA","insp_carrier_state":"MI","insp_carrier_zip_code":"48150","insp_colonia":null,"docket_number":"829830","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:17.000000Z","updated_at":"2025-03-17T18:32:17.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/572469\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/572469\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/572469\/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\/572469\/inspections","per_page":100,"prev_page_url":null,"to":29,"total":29}