{"current_page":1,"data":[{"id":12402648,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","dot_number":"2115715","report_state":"MI","report_number":"BALLB05371","insp_date":"2026-07-09 00:00:00","insp_start_time":"1517","insp_end_time":"1630","registration_date":null,"region":"ED","ci_status_code":"C","location":"ROAD","location_desc":"MI","county_code_state":"MI","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"43140","viol_total":"13","oos_total":"6","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"6","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3720311","transaction_code":"A","transaction_date":"2026-07-09 00:00:00","upload_date":"2026-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02115715","upload_search_indicator":null,"census_search_date":"2026-07-09 21:42:00","snet_input_date":"2026-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-09 21:42:00","insp_carrier_name":"SC ENVIRONMENTAL SERVICES LLC","insp_carrier_street":"1234 WASHINGTON BLVD 5TH FLOOR","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-13T09:39:28.000000Z","updated_at":"2026-07-20T09:31:27.000000Z","inspection_violations":[{"id":21580861,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_violation_id":"275384510","seq_no":"2","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:56:03.000000Z","updated_at":"2026-07-20T09:45:35.000000Z","normalized_code":"3922SLLED"},{"id":21580862,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_violation_id":"275384511","seq_no":"3","part_no":"393","part_no_section":"40F-BNPB","insp_viol_unit":"1","insp_unit_id":"214520117","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-13T09:56:03.000000Z","updated_at":"2026-07-20T09:45:35.000000Z","normalized_code":"39340FBNPB"},{"id":21580863,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_violation_id":"275384512","seq_no":"4","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"214520117","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:56:03.000000Z","updated_at":"2026-07-20T09:45:35.000000Z","normalized_code":"39395A4EEUS"},{"id":21580864,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_violation_id":"275384513","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"214520117","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:56:03.000000Z","updated_at":"2026-07-20T09:45:35.000000Z","normalized_code":"39617CPI"},{"id":21580866,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_violation_id":"275384515","seq_no":"7","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"214520118","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:56:03.000000Z","updated_at":"2026-07-20T09:45:35.000000Z","normalized_code":"39617CPI"},{"id":21580867,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_violation_id":"275384516","seq_no":"8","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"214520118","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-13T09:56:03.000000Z","updated_at":"2026-07-20T09:45:35.000000Z","normalized_code":"3939ALTSI"},{"id":21580868,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_violation_id":"275384517","seq_no":"9","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"214520118","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:56:03.000000Z","updated_at":"2026-07-20T09:45:35.000000Z","normalized_code":"3939ALSLI"},{"id":21580869,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_violation_id":"275384518","seq_no":"10","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"214520118","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:56:03.000000Z","updated_at":"2026-07-20T09:45:35.000000Z","normalized_code":"3939ALRLI"},{"id":21580870,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_violation_id":"275384519","seq_no":"11","part_no":"393","part_no_section":"130B-CHVE","insp_viol_unit":"2","insp_unit_id":"214520118","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-13T09:56:03.000000Z","updated_at":"2026-07-20T09:45:35.000000Z","normalized_code":"393130BCHVE"},{"id":21580872,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_violation_id":"275384521","seq_no":"13","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"214520118","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-13T09:56:03.000000Z","updated_at":"2026-07-20T09:45:35.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":21580860,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_violation_id":"275384509","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:56:03.000000Z","updated_at":"2026-07-20T09:45:35.000000Z","normalized_code":"3922SLLSR"},{"id":21580865,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_violation_id":"275384514","seq_no":"6","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"214520117","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-13T09:56:03.000000Z","updated_at":"2026-07-20T09:45:35.000000Z","normalized_code":"393100BC"},{"id":21580871,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_violation_id":"275384520","seq_no":"12","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"214520118","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-13T09:56:03.000000Z","updated_at":"2026-07-20T09:45:35.000000Z","normalized_code":"39343DB"}],"inspection_per_units":[{"id":21545871,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_unit_id":"214520117","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NONE","insp_unit_license":"BD91333","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HT3GED49657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:51.000000Z","updated_at":"2026-07-20T09:03:06.000000Z"},{"id":21545872,"change_date":"2026-07-09 21:42:00","inspection_id":"88359781","insp_unit_id":"214520118","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"NONE","insp_unit_license":"E537046","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKC024284B084592","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:51.000000Z","updated_at":"2026-07-20T09:03:06.000000Z"}]},{"id":11238136,"change_date":"2026-02-26 21:41:00","inspection_id":"87150702","dot_number":"2115715","report_state":"MI","report_number":"POWED05730","insp_date":"2026-02-25 00:00:00","insp_start_time":"1255","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ VINING","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"1260771","transaction_code":"A","transaction_date":"2026-02-25 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02115715","upload_search_indicator":null,"census_search_date":"2026-02-26 21:41:00","snet_input_date":"2026-02-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-26 21:41:00","insp_carrier_name":"SC ENVIRONMENTAL SERVICES LLC","insp_carrier_street":"1234 WASHINGTON BLVD 5TH FLOOR","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-01T10:39:02.000000Z","updated_at":"2026-03-09T09:31:49.000000Z","inspection_violations":[{"id":18868992,"change_date":"2026-02-26 21:41:00","inspection_id":"87150702","insp_violation_id":"272056362","seq_no":"1","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4651049","created_at":"2026-03-01T10:56:46.000000Z","updated_at":"2026-03-09T09:44:41.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":19211202,"change_date":"2026-02-26 21:41:00","inspection_id":"87150702","insp_unit_id":"211855382","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"N\/A","insp_unit_license":"E771082","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L389TRD21221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:45.000000Z","updated_at":"2026-03-09T09:09:38.000000Z"},{"id":19211201,"change_date":"2026-02-26 21:41:00","inspection_id":"87150702","insp_unit_id":"211855381","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"SKMD","insp_unit_company":"NA","insp_unit_license":"BC57224","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGNBG1GDHK9919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:45.000000Z","updated_at":"2026-03-09T09:09:38.000000Z"}]},{"id":8549791,"change_date":"2025-05-05 21:40:00","inspection_id":"84582869","dot_number":"2115715","report_state":"MI","report_number":"NESBA02090","insp_date":"2025-05-02 00:00:00","insp_start_time":"1555","insp_end_time":"1625","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"150000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1220106","transaction_code":"A","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02115715","upload_search_indicator":null,"census_search_date":"2025-05-05 21:40:00","snet_input_date":"2025-05-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-05 21:40:00","insp_carrier_name":"SC ENVIRONMENTAL SERVICES LLC","insp_carrier_street":"1234 WASHINGTON BLVD 5TH FLOOR","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-08T10:03:43.000000Z","updated_at":"2025-05-09T10:23:28.000000Z","inspection_violations":[{"id":13547598,"change_date":"2025-05-05 21:40:00","inspection_id":"84582869","insp_violation_id":"266011835","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206647266","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:31.000000Z","normalized_code":"3922SLLSR"},{"id":13547600,"change_date":"2025-05-05 21:40:00","inspection_id":"84582869","insp_violation_id":"266011837","seq_no":"3","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"206647266","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:31.000000Z","normalized_code":"3939ALBL"},{"id":13547601,"change_date":"2025-05-05 21:40:00","inspection_id":"84582869","insp_violation_id":"266011838","seq_no":"4","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"206647266","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:31.000000Z","normalized_code":"39311A1CSURR"},{"id":13547599,"change_date":"2025-05-05 21:40:00","inspection_id":"84582869","insp_violation_id":"266011836","seq_no":"2","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"206647266","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:31.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":13904457,"change_date":"2025-05-05 21:40:00","inspection_id":"84582869","insp_unit_id":"206647266","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"19","insp_unit_license":"BA84206","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGNBG8GDHK9920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:57:09.000000Z","updated_at":"2025-05-09T10:04:06.000000Z"},{"id":13904458,"change_date":"2025-05-05 21:40:00","inspection_id":"84582869","insp_unit_id":"206647267","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"T957","insp_unit_license":"D969547","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3M486KR066957","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:57:09.000000Z","updated_at":"2025-05-09T10:04:06.000000Z"}]},{"id":8084302,"change_date":"2025-03-11 21:41:00","inspection_id":"84092483","dot_number":"2115715","report_state":"MI","report_number":"LITTJ05406","insp_date":"2025-03-07 00:00:00","insp_start_time":"1120","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-275 @ CHERRY HILL","county_code_state":"MI","county_code":"163","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":"2025-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1212371","transaction_code":"A","transaction_date":"2025-03-07 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02115715","upload_search_indicator":null,"census_search_date":"2025-03-11 21:41:00","snet_input_date":"2025-03-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"SC ENVIRONMENTAL SERVICES LLC","insp_carrier_street":"1234 WASHINGTON BLVD 5TH FLOOR","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[{"id":12633926,"change_date":"2025-03-11 21:41:00","inspection_id":"84092483","insp_violation_id":"264949246","seq_no":"1","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":13052411,"change_date":"2025-03-11 21:41:00","inspection_id":"84092483","insp_unit_id":"205736747","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NONE","insp_unit_license":"DF32318","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FT7W2BT6LEC63147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"},{"id":13052412,"change_date":"2025-03-11 21:41:00","inspection_id":"84092483","insp_unit_id":"205736748","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SURE","insp_unit_company":"NONE","insp_unit_license":"D783979","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5JW1D1620E2091980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"}]},{"id":4302659,"change_date":"2023-10-27 21:43:00","inspection_id":"80028242","dot_number":"2115715","report_state":"MI","report_number":"SAHIW01153","insp_date":"2023-10-27 00:00:00","insp_start_time":"1245","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB-I-94 @ BELLEVILLE REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CITY OF DETROIT","shipping_paper_number":"21-17177","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-10-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1151193","transaction_code":"A","transaction_date":"2023-10-27 00:00:00","upload_date":"2023-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02115715","upload_search_indicator":null,"census_search_date":"2023-10-27 21:43:00","snet_input_date":"2023-10-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-27 21:43:00","insp_carrier_name":"SC ENVIRONMENTAL SERVICES LLC","insp_carrier_street":"1234 WASHINGTON BLVD 5TH FLOOR","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:20.000000Z","updated_at":"2025-03-17T19:48:20.000000Z","inspection_violations":[{"id":6656116,"change_date":"2023-10-27 21:43:00","inspection_id":"80028242","insp_violation_id":"256090924","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197788226","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:02.000000Z","updated_at":"2025-03-17T21:38:02.000000Z","normalized_code":"3939A"},{"id":6656117,"change_date":"2023-10-27 21:43:00","inspection_id":"80028242","insp_violation_id":"256090925","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197788226","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:02.000000Z","updated_at":"2025-03-17T21:38:02.000000Z","normalized_code":"3939A"},{"id":6656118,"change_date":"2023-10-27 21:43:00","inspection_id":"80028242","insp_violation_id":"256090926","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197788226","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:02.000000Z","updated_at":"2025-03-17T21:38:02.000000Z","normalized_code":"3939A"},{"id":6656119,"change_date":"2023-10-27 21:43:00","inspection_id":"80028242","insp_violation_id":"256090927","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"197788226","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:02.000000Z","updated_at":"2025-03-17T21:38:02.000000Z","normalized_code":"39395F"},{"id":6656120,"change_date":"2023-10-27 21:43:00","inspection_id":"80028242","insp_violation_id":"256090928","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"3","insp_unit_id":"197788228","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:38:02.000000Z","updated_at":"2025-03-17T21:38:02.000000Z","normalized_code":"39375A3"},{"id":6656121,"change_date":"2023-10-27 21:43:00","inspection_id":"80028242","insp_violation_id":"256090929","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"3","insp_unit_id":"197788228","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:02.000000Z","updated_at":"2025-03-17T21:38:02.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6919868,"change_date":"2023-10-27 21:43:00","inspection_id":"80028242","insp_unit_id":"197788226","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"870","insp_unit_license":"BC75526","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X89J246901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:02.000000Z","updated_at":"2025-03-17T22:58:02.000000Z"},{"id":6919869,"change_date":"2023-10-27 21:43:00","inspection_id":"80028242","insp_unit_id":"197788227","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E771082","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L389TRD21221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:02.000000Z","updated_at":"2025-03-17T22:58:02.000000Z"},{"id":6919870,"change_date":"2023-10-27 21:43:00","inspection_id":"80028242","insp_unit_id":"197788228","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"E771081","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4D01953GF051505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:02.000000Z","updated_at":"2025-03-17T22:58:02.000000Z"}]},{"id":4013212,"change_date":"2023-09-20 21:39:00","inspection_id":"79707403","dot_number":"2115715","report_state":"MI","report_number":"SAHIW01069","insp_date":"2023-09-19 00:00:00","insp_start_time":"1320","insp_end_time":"1500","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB-I-94 @ BELLEVILLE REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CITY OF DETROIT","shipping_paper_number":"127203MI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"7","oos_total":"5","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1146680","transaction_code":"A","transaction_date":"2023-09-19 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02115715","upload_search_indicator":null,"census_search_date":"2023-09-20 21:39:00","snet_input_date":"2023-09-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-20 21:39:00","insp_carrier_name":"SC ENVIRONMENTAL SERVICES LLC","insp_carrier_street":"1234 WASHINGTON BLVD 5TH FLOOR","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:03.000000Z","updated_at":"2025-03-17T19:42:03.000000Z","inspection_violations":[{"id":6209188,"change_date":"2023-09-20 21:39:00","inspection_id":"79707403","insp_violation_id":"255373111","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":"X4280480","created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"3922"},{"id":6209189,"change_date":"2023-09-20 21:39:00","inspection_id":"79707403","insp_violation_id":"255373112","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197144181","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39375A3"},{"id":6209190,"change_date":"2023-09-20 21:39:00","inspection_id":"79707403","insp_violation_id":"255373113","seq_no":"3","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"197144181","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39345"},{"id":6209191,"change_date":"2023-09-20 21:39:00","inspection_id":"79707403","insp_violation_id":"255373114","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"197144181","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39395F"},{"id":6209192,"change_date":"2023-09-20 21:39:00","inspection_id":"79707403","insp_violation_id":"255373115","seq_no":"5","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"197144182","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4280480","created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39375A"},{"id":6209193,"change_date":"2023-09-20 21:39:00","inspection_id":"79707403","insp_violation_id":"255373116","seq_no":"6","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"197144182","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39375A3"},{"id":6209194,"change_date":"2023-09-20 21:39:00","inspection_id":"79707403","insp_violation_id":"255373117","seq_no":"7","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"197144182","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":6452936,"change_date":"2023-09-20 21:39:00","inspection_id":"79707403","insp_unit_id":"197144181","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"12","insp_unit_license":"BC57224","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGNBG1GDHK9919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:10.000000Z","updated_at":"2025-03-17T22:54:10.000000Z"},{"id":6452937,"change_date":"2023-09-20 21:39:00","inspection_id":"79707403","insp_unit_id":"197144182","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"T-957","insp_unit_license":"D969547","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3M486KR066957","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:10.000000Z","updated_at":"2025-03-17T22:54:10.000000Z"}]},{"id":3955298,"change_date":"2023-09-12 21:40:00","inspection_id":"79643180","dot_number":"2115715","report_state":"MI","report_number":"SAHIW01041","insp_date":"2023-09-11 00:00:00","insp_start_time":"1225","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB-I-94 @ BELLVILLE REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CITY OF DETROIT","shipping_paper_number":"22490","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"3","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1145547","transaction_code":"A","transaction_date":"2023-09-11 00:00:00","upload_date":"2023-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02115715","upload_search_indicator":null,"census_search_date":"2023-09-12 21:40:00","snet_input_date":"2023-09-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-12 21:40:00","insp_carrier_name":"SC ENVIRONMENTAL SERVICES LLC","insp_carrier_street":"1234 WASHINGTON BLVD 5TH FLOOR","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:51.000000Z","updated_at":"2025-03-17T19:40:51.000000Z","inspection_violations":[{"id":6115451,"change_date":"2023-09-12 21:40:00","inspection_id":"79643180","insp_violation_id":"255219332","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":"X4275346","created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"3922"},{"id":6115452,"change_date":"2023-09-12 21:40:00","inspection_id":"79643180","insp_violation_id":"255219333","seq_no":"2","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"197013984","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4275346","created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39347A"},{"id":6115453,"change_date":"2023-09-12 21:40:00","inspection_id":"79643180","insp_violation_id":"255219334","seq_no":"3","part_no":"393","part_no_section":"45(a)","insp_viol_unit":"1","insp_unit_id":"197013984","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39345A"}],"inspection_per_units":[{"id":6359812,"change_date":"2023-09-12 21:40:00","inspection_id":"79643180","insp_unit_id":"197013984","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"12","insp_unit_license":"BC57224","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGNBG1GDHK9919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:24.000000Z","updated_at":"2025-03-17T22:53:24.000000Z"},{"id":6359813,"change_date":"2023-09-12 21:40:00","inspection_id":"79643180","insp_unit_id":"197013985","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"T-957","insp_unit_license":"D969547","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3M486KR066957","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:24.000000Z","updated_at":"2025-03-17T22:53:24.000000Z"}]},{"id":3609358,"change_date":"2023-07-27 21:40:00","inspection_id":"79256847","dot_number":"2115715","report_state":"MI","report_number":"WATTR03470","insp_date":"2023-07-26 00:00:00","insp_start_time":"1223","insp_end_time":"1306","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MERRIMAN  RD","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":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-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"224000","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":"1136781","transaction_code":"A","transaction_date":"2023-07-26 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02115715","upload_search_indicator":null,"census_search_date":"2023-07-27 21:40:00","snet_input_date":"2023-07-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"SC ENVIRONMENTAL SERVICES LLC","insp_carrier_street":"1234 WASHINGTON BLVD 5TH FLOOR","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:13.000000Z","updated_at":"2025-03-17T19:34:13.000000Z","inspection_violations":[{"id":5566142,"change_date":"2023-07-27 21:40:00","inspection_id":"79256847","insp_violation_id":"254318103","seq_no":"1","part_no":"393","part_no_section":"93(b)","insp_viol_unit":"1","insp_unit_id":"196228252","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"39393B"},{"id":5566143,"change_date":"2023-07-27 21:40:00","inspection_id":"79256847","insp_violation_id":"254318104","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196228252","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3939A"},{"id":5566144,"change_date":"2023-07-27 21:40:00","inspection_id":"79256847","insp_violation_id":"254318105","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"3","insp_unit_id":"196228254","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5803193,"change_date":"2023-07-27 21:40:00","inspection_id":"79256847","insp_unit_id":"196228252","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"19","insp_unit_license":"BA84206","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGNBG8GDHK9920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:48.000000Z","updated_at":"2025-03-17T22:48:48.000000Z"},{"id":5803194,"change_date":"2023-07-27 21:40:00","inspection_id":"79256847","insp_unit_id":"196228253","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":"68887","insp_unit_license":"E800555","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2435PC068887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:48.000000Z","updated_at":"2025-03-17T22:48:48.000000Z"},{"id":5803195,"change_date":"2023-07-27 21:40:00","inspection_id":"79256847","insp_unit_id":"196228254","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MAC","insp_unit_company":"68888","insp_unit_license":"E800556","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2058PC068888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:48.000000Z","updated_at":"2025-03-17T22:48:48.000000Z"}]},{"id":2872916,"change_date":"2023-04-24 21:41:00","inspection_id":"78426767","dot_number":"2115715","report_state":"MI","report_number":"SAHIW00501","insp_date":"2023-04-21 00:00:00","insp_start_time":"1355","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB-I-275 @ M-14","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-24 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"122000","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":"1123133","transaction_code":"A","transaction_date":"2023-04-21 00:00:00","upload_date":"2023-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02115715","upload_search_indicator":null,"census_search_date":"2023-04-24 21:41:00","snet_input_date":"2023-04-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-24 21:41:00","insp_carrier_name":"SC ENVIRONMENTAL SERVICES LLC","insp_carrier_street":"1234 WASHINGTON BLVD 5TH FLOOR","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:42.000000Z","updated_at":"2025-03-17T19:19:42.000000Z","inspection_violations":[{"id":4409219,"change_date":"2023-04-24 21:41:00","inspection_id":"78426767","insp_violation_id":"252394160","seq_no":"1","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"194543979","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:35.000000Z","updated_at":"2025-03-17T21:27:35.000000Z","normalized_code":"393203C"}],"inspection_per_units":[{"id":4622403,"change_date":"2023-04-24 21:41:00","inspection_id":"78426767","insp_unit_id":"194543979","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"870","insp_unit_license":"BC75526","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X89J246901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:28.000000Z","updated_at":"2025-03-17T22:39:28.000000Z"},{"id":4622404,"change_date":"2023-04-24 21:41:00","inspection_id":"78426767","insp_unit_id":"194543980","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"NONE","insp_unit_license":"D969547","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3M486KR066957","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:28.000000Z","updated_at":"2025-03-17T22:39:28.000000Z"}]},{"id":2512890,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","dot_number":"2115715","report_state":"MI","report_number":"CHESJ04502","insp_date":"2023-03-02 00:00:00","insp_start_time":"1010","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRAND RIVER AVE @ WIXOM ROAD","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"188000","viol_total":"18","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"18","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1115905","transaction_code":"A","transaction_date":"2023-03-02 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02115715","upload_search_indicator":null,"census_search_date":"2023-03-06 21:40:00","snet_input_date":"2023-03-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-06 21:40:00","insp_carrier_name":"SC ENVIRONMENTAL SERVICES LLC","insp_carrier_street":"1234 WASHINGTON BLVD 5TH FLOOR","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:57.000000Z","updated_at":"2025-03-17T19:12:57.000000Z","inspection_violations":[{"id":3863663,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493734","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193723296","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39395A"},{"id":3863664,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493735","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193723296","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3963A1"},{"id":3863665,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493736","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193723297","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3939A"},{"id":3863666,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493737","seq_no":"3","part_no":"393","part_no_section":"207(d)","insp_viol_unit":"1","insp_unit_id":"193723296","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"393207D"},{"id":3863667,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493738","seq_no":"4","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"193723296","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"393209D"},{"id":3863668,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493739","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193723296","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39347E"},{"id":3863669,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493740","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"193723296","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39353B"},{"id":3863670,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493741","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193723296","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3963A1"},{"id":3863671,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493742","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"193723297","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39347E"},{"id":3863672,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493743","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"193723297","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39347E"},{"id":3863673,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493744","seq_no":"11","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"193723298","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39347E"},{"id":3863674,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493745","seq_no":"12","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"193723298","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39347E"},{"id":3863675,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493746","seq_no":"13","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"193723298","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39347E"},{"id":3863676,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493747","seq_no":"14","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"193723298","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39347E"},{"id":3863677,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493748","seq_no":"15","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"3","insp_unit_id":"193723298","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3939A"},{"id":3863678,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493749","seq_no":"16","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"193723298","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39347E"},{"id":3863679,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493750","seq_no":"17","part_no":"393","part_no_section":"11","insp_viol_unit":"3","insp_unit_id":"193723298","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39311"},{"id":3863680,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_violation_id":"251493751","seq_no":"18","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"3","insp_unit_id":"193723298","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4044418,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_unit_id":"193723296","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"357","insp_unit_license":"BC78325","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPADB0X96D652472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:59.000000Z","updated_at":"2025-03-17T22:34:59.000000Z"},{"id":4044419,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_unit_id":"193723297","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"NONE","insp_unit_license":"E771082","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1L389TRD21221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:59.000000Z","updated_at":"2025-03-17T22:34:59.000000Z"},{"id":4044420,"change_date":"2023-03-06 21:40:00","inspection_id":"78017486","insp_unit_id":"193723298","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"NONE","insp_unit_license":"E771081","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4D01953GF051505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:59.000000Z","updated_at":"2025-03-17T22:34:59.000000Z"}]},{"id":1677598,"change_date":"2022-11-04 21:38:00","inspection_id":"77062824","dot_number":"2115715","report_state":"MI","report_number":"WILLD02423","insp_date":"2022-11-03 00:00:00","insp_start_time":"1120","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 & I-275","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":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-11-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","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":"1101066","transaction_code":"A","transaction_date":"2022-11-03 00:00:00","upload_date":"2022-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02115715","upload_search_indicator":null,"census_search_date":"2022-11-04 21:38:00","snet_input_date":"2022-11-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-04 21:38:00","insp_carrier_name":"SC ENVIRONMENTAL SERVICES LLC","insp_carrier_street":"1234 WASHINGTON BLVD 5TH FLOOR","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:28.000000Z","updated_at":"2025-03-17T18:57:28.000000Z","inspection_violations":[{"id":2630505,"change_date":"2022-11-04 21:38:00","inspection_id":"77062824","insp_violation_id":"249445457","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":2698857,"change_date":"2022-11-04 21:38:00","inspection_id":"77062824","insp_unit_id":"191817139","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC63980","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGND1XFDGK0298","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:29.000000Z","updated_at":"2025-03-17T22:25:29.000000Z"},{"id":2698858,"change_date":"2022-11-04 21:38:00","inspection_id":"77062824","insp_unit_id":"191817140","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E022863","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3M486KR066814","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:29.000000Z","updated_at":"2025-03-17T22:25:29.000000Z"}]},{"id":1158897,"change_date":"2022-08-29 21:42:00","inspection_id":"76463101","dot_number":"2115715","report_state":"MI","report_number":"BACZM01612","insp_date":"2022-08-27 00:00:00","insp_start_time":"1037","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 SB @ COLDWATER RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-29 21:42: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":"1091637","transaction_code":"A","transaction_date":"2022-08-27 00:00:00","upload_date":"2022-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02115715","upload_search_indicator":null,"census_search_date":"2022-08-29 21:42:00","snet_input_date":"2022-08-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-29 21:42:00","insp_carrier_name":"SC ENVIRONMENTAL SERVICES LLC","insp_carrier_street":"1234 WASHINGTON BLVD 5TH FLOOR","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:58.000000Z","updated_at":"2025-03-17T18:47:58.000000Z","inspection_violations":[{"id":1836061,"change_date":"2022-08-29 21:42:00","inspection_id":"76463101","insp_violation_id":"248064093","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190596809","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:29.000000Z","updated_at":"2025-03-17T21:15:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1863281,"change_date":"2022-08-29 21:42:00","inspection_id":"76463101","insp_unit_id":"190596809","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC88478","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X6DJ347041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:49.000000Z","updated_at":"2025-03-17T22:19:49.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2115715\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2115715\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2115715\/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\/2115715\/inspections","per_page":100,"prev_page_url":null,"to":12,"total":12}