{"current_page":1,"data":[{"id":11991469,"change_date":"2026-06-01 21:40:00","inspection_id":"87929313","dot_number":"3593267","report_state":"MI","report_number":"DEJOS02630","insp_date":"2026-05-21 00:00:00","insp_start_time":"1830","insp_end_time":"1905","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MOSCOW MDOT PIT #3000071","shipping_paper_number":"88265900","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-22 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3381119","transaction_code":"C","transaction_date":"2026-06-01 00:00:00","upload_date":"2026-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2026-05-22 21:37:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 21:37:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089-2010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:09.000000Z","updated_at":"2026-06-12T09:30:16.000000Z","inspection_violations":[{"id":20861687,"change_date":"2026-06-01 21:40:00","inspection_id":"87929313","insp_violation_id":"274615677","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:28.000000Z","updated_at":"2026-06-12T09:41:31.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":20846613,"change_date":"2026-06-01 21:40:00","inspection_id":"87929313","insp_unit_id":"213848611","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"962505","insp_unit_license":"RC45754","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X2SD712641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:07.000000Z","updated_at":"2026-06-12T09:01:15.000000Z"},{"id":20846614,"change_date":"2026-06-01 21:40:00","inspection_id":"87929313","insp_unit_id":"213848612","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"LEAD78-2603","insp_unit_license":"F296078","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2846TC087674","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:07.000000Z","updated_at":"2026-06-12T09:01:15.000000Z"},{"id":20846615,"change_date":"2026-06-01 21:40:00","inspection_id":"87929313","insp_unit_id":"213848613","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"PUP 78-2604","insp_unit_license":"F296079","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2542TC087675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:07.000000Z","updated_at":"2026-06-12T09:01:15.000000Z"}]},{"id":11952960,"change_date":"2026-05-18 21:40:00","inspection_id":"87888730","dot_number":"3593267","report_state":"MI","report_number":"SEYFE00436","insp_date":"2026-05-14 00:00:00","insp_start_time":"2000","insp_end_time":"2045","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NA","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3356949","transaction_code":"A","transaction_date":"2026-05-18 00:00:00","upload_date":"2026-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2026-05-18 21:40:00","snet_input_date":"2026-05-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-18 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089-2010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-21T09:41:11.000000Z","updated_at":"2026-05-29T09:31:06.000000Z","inspection_violations":[{"id":20789881,"change_date":"2026-05-18 21:40:00","inspection_id":"87888730","insp_violation_id":"274341481","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"213624476","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-21T10:02:28.000000Z","updated_at":"2026-05-29T09:41:55.000000Z","normalized_code":"3922SLLSR"},{"id":20789882,"change_date":"2026-05-18 21:40:00","inspection_id":"87888730","insp_violation_id":"274341482","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"213624475","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-21T10:02:28.000000Z","updated_at":"2026-05-29T09:41:55.000000Z","normalized_code":"3939ALHLI"},{"id":20789883,"change_date":"2026-05-18 21:40:00","inspection_id":"87888730","insp_violation_id":"274341483","seq_no":"3","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"213624475","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-21T10:02:28.000000Z","updated_at":"2026-05-29T09:41:55.000000Z","normalized_code":"39311A1LRR"},{"id":20789884,"change_date":"2026-05-18 21:40:00","inspection_id":"87888730","insp_violation_id":"274341484","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213624475","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-21T10:02:28.000000Z","updated_at":"2026-05-29T09:41:55.000000Z","normalized_code":"3922SLLSR"},{"id":20789885,"change_date":"2026-05-18 21:40:00","inspection_id":"87888730","insp_violation_id":"274341485","seq_no":"5","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"213624475","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-21T10:02:28.000000Z","updated_at":"2026-05-29T09:41:55.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":20783818,"change_date":"2026-05-18 21:40:00","inspection_id":"87888730","insp_unit_id":"213624476","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"NA","insp_unit_license":"F031012","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2846SC081680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-21T09:20:38.000000Z","updated_at":"2026-05-29T09:03:20.000000Z"},{"id":20783817,"change_date":"2026-05-18 21:40:00","inspection_id":"87888730","insp_unit_id":"213624475","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"NA","insp_unit_license":"RC46553","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X5NJ164625","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-21T09:20:38.000000Z","updated_at":"2026-05-29T09:03:20.000000Z"}]},{"id":11370281,"change_date":"2026-03-13 21:37:00","inspection_id":"87283894","dot_number":"3593267","report_state":"MI","report_number":"LULAN02939","insp_date":"2026-03-09 00:00:00","insp_start_time":"1935","insp_end_time":"2025","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B 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":"STONECO","shipping_paper_number":"68571550","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"144740","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":"1261846","transaction_code":"A","transaction_date":"2026-03-09 00:00:00","upload_date":"2026-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2026-03-13 21:37:00","snet_input_date":"2026-03-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-13 21:37:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-16T09:39:16.000000Z","updated_at":"2026-03-24T09:31:02.000000Z","inspection_violations":[{"id":19160415,"change_date":"2026-03-13 21:37:00","inspection_id":"87283894","insp_violation_id":"272391442","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"212124417","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-16T10:01:19.000000Z","updated_at":"2026-03-24T09:44:18.000000Z","normalized_code":"3922SLLSR"},{"id":19160416,"change_date":"2026-03-13 21:37:00","inspection_id":"87283894","insp_violation_id":"272391443","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4662200","created_at":"2026-03-16T10:01:19.000000Z","updated_at":"2026-03-24T09:44:18.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":19469081,"change_date":"2026-03-13 21:37:00","inspection_id":"87283894","insp_unit_id":"212124416","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"9625000","insp_unit_license":"RC46547","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X9SD712636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:16:58.000000Z","updated_at":"2026-03-24T09:04:34.000000Z"},{"id":19469082,"change_date":"2026-03-13 21:37:00","inspection_id":"87283894","insp_unit_id":"212124417","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":"87678","insp_unit_license":"F296082","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2843TC087678","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:16:58.000000Z","updated_at":"2026-03-24T09:04:34.000000Z"}]},{"id":10611231,"change_date":"2026-01-13 21:39:00","inspection_id":"86751103","dot_number":"3593267","report_state":"MI","report_number":"SHEPZ05501","insp_date":"2026-01-09 00:00:00","insp_start_time":"0725","insp_end_time":"0810","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":"STONE CO","shipping_paper_number":"88260367","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"224740","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":"1255992","transaction_code":"C","transaction_date":"2026-01-09 00:00:00","upload_date":"2026-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2026-01-09 21:39:00","snet_input_date":"2026-01-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-09 21:39:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-12T10:34:47.000000Z","updated_at":"2026-01-24T10:30:13.000000Z","inspection_violations":[{"id":17882451,"change_date":"2026-01-13 21:39:00","inspection_id":"86751103","insp_violation_id":"271167816","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4635962","created_at":"2026-01-16T10:41:47.000000Z","updated_at":"2026-01-24T10:30:27.000000Z","normalized_code":"3922SLLEWA3"}],"inspection_per_units":[{"id":17830340,"change_date":"2026-01-13 21:39:00","inspection_id":"86751103","insp_unit_id":"211052582","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":"78-2609","insp_unit_license":"F296084","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2841TC087680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:33.000000Z","updated_at":"2026-01-24T10:01:39.000000Z"},{"id":17830341,"change_date":"2026-01-13 21:39:00","inspection_id":"86751103","insp_unit_id":"211052583","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCOA","insp_unit_company":"78-2610","insp_unit_license":"F296085","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2548TC087681","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:33.000000Z","updated_at":"2026-01-24T10:01:39.000000Z"},{"id":17830339,"change_date":"2026-01-13 21:39:00","inspection_id":"86751103","insp_unit_id":"211052581","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"259601","insp_unit_license":"RC53635","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X1SD712646","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:33.000000Z","updated_at":"2026-01-24T10:01:39.000000Z"}]},{"id":10507551,"change_date":"2026-01-05 21:37:00","inspection_id":"86642635","dot_number":"3593267","report_state":"MI","report_number":"MATTB07101","insp_date":"2025-12-19 00:00:00","insp_start_time":"1705","insp_end_time":"1745","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"MONROE SCALE N\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"STONECO","shipping_paper_number":"68554238","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-12-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1254544","transaction_code":"C","transaction_date":"2025-12-19 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-12-23 21:38:00","snet_input_date":"2025-12-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-23 21:38:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-26T10:38:36.000000Z","updated_at":"2026-01-16T10:30:15.000000Z","inspection_violations":[{"id":17749927,"change_date":"2026-01-05 21:37:00","inspection_id":"86642635","insp_violation_id":"271015441","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-08T10:38:00.000000Z","updated_at":"2026-01-16T10:30:33.000000Z","normalized_code":"3922SLLEWA3"},{"id":17749928,"change_date":"2026-01-05 21:37:00","inspection_id":"86642635","insp_violation_id":"271015442","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4627825","created_at":"2026-01-08T10:38:00.000000Z","updated_at":"2026-01-16T10:30:33.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":17705477,"change_date":"2026-01-05 21:37:00","inspection_id":"86642635","insp_unit_id":"210914574","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"962206H","insp_unit_license":"RC46548","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X7NJ164626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-08T10:05:39.000000Z","updated_at":"2026-01-16T10:00:21.000000Z"},{"id":17705478,"change_date":"2026-01-05 21:37:00","inspection_id":"86642635","insp_unit_id":"210914575","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E965885","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2N487RR085682","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-08T10:05:39.000000Z","updated_at":"2026-01-16T10:00:21.000000Z"}]},{"id":10449424,"change_date":"2025-12-16 21:38:00","inspection_id":"86581885","dot_number":"3593267","report_state":"MI","report_number":"HOLLM04709","insp_date":"2025-12-15 00:00:00","insp_start_time":"0830","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"I-94 E\/B GRASS LAKE SCALE","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"88259974","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1253837","transaction_code":"A","transaction_date":"2025-12-15 00:00:00","upload_date":"2025-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-12-16 21:38:00","snet_input_date":"2025-12-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-16 21:38:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-19T10:31:54.000000Z","updated_at":"2025-12-27T10:30:55.000000Z","inspection_violations":[{"id":17527109,"change_date":"2025-12-16 21:38:00","inspection_id":"86581885","insp_violation_id":"270716150","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4627523","created_at":"2025-12-19T10:32:45.000000Z","updated_at":"2025-12-27T10:31:22.000000Z","normalized_code":"3922SLLEWG3"},{"id":17527110,"change_date":"2025-12-16 21:38:00","inspection_id":"86581885","insp_violation_id":"270716151","seq_no":"2","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"3","insp_unit_id":"210640029","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-19T10:32:45.000000Z","updated_at":"2025-12-27T10:31:22.000000Z","normalized_code":"39375GTAOW"}],"inspection_per_units":[{"id":17485768,"change_date":"2025-12-16 21:38:00","inspection_id":"86581885","insp_unit_id":"210640027","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC45222","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X4SD712642","insp_unit_decal":"Y","insp_unit_decal_number":"35767367","created_at":"2025-12-19T10:02:01.000000Z","updated_at":"2025-12-27T10:01:01.000000Z"},{"id":17485769,"change_date":"2025-12-16 21:38:00","inspection_id":"86581885","insp_unit_id":"210640028","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":null,"insp_unit_license":"F296076","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2842TC087672","insp_unit_decal":"Y","insp_unit_decal_number":"35767368","created_at":"2025-12-19T10:02:01.000000Z","updated_at":"2025-12-27T10:01:01.000000Z"},{"id":17485770,"change_date":"2025-12-16 21:38:00","inspection_id":"86581885","insp_unit_id":"210640029","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCOA","insp_unit_company":null,"insp_unit_license":"F296077","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2549TC087673","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-19T10:02:01.000000Z","updated_at":"2025-12-27T10:01:01.000000Z"}]},{"id":10363779,"change_date":"2025-12-05 21:43:00","inspection_id":"86492315","dot_number":"3593267","report_state":"MI","report_number":"WALKB03888","insp_date":"2025-12-04 00:00:00","insp_start_time":"1948","insp_end_time":"2002","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"I 94 @ RACE RD","county_code_state":"MI","county_code":"075","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":"2025-12-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1253011","transaction_code":"A","transaction_date":"2025-12-04 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-12-05 21:43:00","snet_input_date":"2025-12-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-05 21:43:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-08T10:32:05.000000Z","updated_at":"2025-12-09T10:31:19.000000Z","inspection_violations":[{"id":17353304,"change_date":"2025-12-05 21:43:00","inspection_id":"86492315","insp_violation_id":"270495072","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4627662","created_at":"2025-12-08T10:32:57.000000Z","updated_at":"2025-12-09T10:32:07.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":17322845,"change_date":"2025-12-05 21:43:00","inspection_id":"86492315","insp_unit_id":"210445046","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC46553","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X5NJ164625","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:09.000000Z","updated_at":"2025-12-09T10:01:33.000000Z"},{"id":17322846,"change_date":"2025-12-05 21:43:00","inspection_id":"86492315","insp_unit_id":"210445047","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F031008","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2844SC081676","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:09.000000Z","updated_at":"2025-12-09T10:01:33.000000Z"},{"id":17322847,"change_date":"2025-12-05 21:43:00","inspection_id":"86492315","insp_unit_id":"210445048","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F031009","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2540SC081677","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:09.000000Z","updated_at":"2025-12-09T10:01:33.000000Z"}]},{"id":10351640,"change_date":"2025-12-04 21:38:00","inspection_id":"86479581","dot_number":"3593267","report_state":"MI","report_number":"DELMT02370","insp_date":"2025-12-02 00:00:00","insp_start_time":"1905","insp_end_time":"1940","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":"TITAN PLANT","shipping_paper_number":"88259503","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1252641","transaction_code":"A","transaction_date":"2025-12-02 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-12-04 21:38:00","snet_input_date":"2025-12-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-04 21:38:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-07T10:31:44.000000Z","updated_at":"2025-12-08T10:31:09.000000Z","inspection_violations":[{"id":17328006,"change_date":"2025-12-04 21:38:00","inspection_id":"86479581","insp_violation_id":"270461752","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4623828","created_at":"2025-12-07T10:32:19.000000Z","updated_at":"2025-12-08T10:31:47.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":17299178,"change_date":"2025-12-04 21:38:00","inspection_id":"86479581","insp_unit_id":"210414236","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC51613","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40XXNF490189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:33.000000Z","updated_at":"2025-12-08T10:01:22.000000Z"},{"id":17299179,"change_date":"2025-12-04 21:38:00","inspection_id":"86479581","insp_unit_id":"210414237","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F031012","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2846SC081680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:33.000000Z","updated_at":"2025-12-08T10:01:22.000000Z"},{"id":17299180,"change_date":"2025-12-04 21:38:00","inspection_id":"86479581","insp_unit_id":"210414238","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F211423","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2547TC085288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:33.000000Z","updated_at":"2025-12-08T10:01:22.000000Z"}]},{"id":10297642,"change_date":"2025-12-01 21:39:00","inspection_id":"86423200","dot_number":"3593267","report_state":"MI","report_number":"LITTJ05643","insp_date":"2025-11-25 00:00:00","insp_start_time":"1320","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"MONROE SCALE N\/B","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SC","shipping_paper_number":"68551811","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"214000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1252032","transaction_code":"C","transaction_date":"2025-11-26 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-11-26 21:38:00","snet_input_date":"2025-11-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-26 21:38:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-29T10:31:40.000000Z","updated_at":"2025-12-05T10:30:51.000000Z","inspection_violations":[{"id":17255224,"change_date":"2025-12-01 21:39:00","inspection_id":"86423200","insp_violation_id":"270366970","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4626530","created_at":"2025-12-04T10:30:50.000000Z","updated_at":"2025-12-05T10:31:08.000000Z","normalized_code":"3922SLLEWA3"},{"id":17255225,"change_date":"2025-12-01 21:39:00","inspection_id":"86423200","insp_violation_id":"270366971","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"210329493","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-04T10:30:50.000000Z","updated_at":"2025-12-05T10:31:08.000000Z","normalized_code":"39345DB"},{"id":17255226,"change_date":"2025-12-01 21:39:00","inspection_id":"86423200","insp_violation_id":"270366972","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"210329493","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-04T10:30:50.000000Z","updated_at":"2025-12-05T10:31:08.000000Z","normalized_code":"39345DB"},{"id":17255227,"change_date":"2025-12-01 21:39:00","inspection_id":"86423200","insp_violation_id":"270366973","seq_no":"4","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"210329493","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-04T10:30:50.000000Z","updated_at":"2025-12-05T10:31:08.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":17255228,"change_date":"2025-12-01 21:39:00","inspection_id":"86423200","insp_violation_id":"270366974","seq_no":"5","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"3","insp_unit_id":"210329494","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-04T10:30:50.000000Z","updated_at":"2025-12-05T10:31:08.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":17227475,"change_date":"2025-12-01 21:39:00","inspection_id":"86423200","insp_unit_id":"210329492","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"962202","insp_unit_license":"RC46551","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X8NF490191","insp_unit_decal":"Y","insp_unit_decal_number":"35767929","created_at":"2025-12-04T10:00:35.000000Z","updated_at":"2025-12-05T10:01:01.000000Z"},{"id":17227476,"change_date":"2025-12-01 21:39:00","inspection_id":"86423200","insp_unit_id":"210329493","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":"78-2504","insp_unit_license":"F031010","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2848SC081678","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:35.000000Z","updated_at":"2025-12-05T10:01:01.000000Z"},{"id":17227477,"change_date":"2025-12-01 21:39:00","inspection_id":"86423200","insp_unit_id":"210329494","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCOA","insp_unit_company":"78-2505","insp_unit_license":"F031011","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2544SC081679","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:35.000000Z","updated_at":"2025-12-05T10:01:01.000000Z"}]},{"id":10200685,"change_date":"2025-12-04 21:38:00","inspection_id":"86321528","dot_number":"3593267","report_state":"MI","report_number":"CHAPP05088","insp_date":"2025-11-12 00:00:00","insp_start_time":"1449","insp_end_time":"1523","registration_date":null,"region":"ET","ci_status_code":"C","location":"115","location_desc":"LASALLE TWP","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"2","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"184000","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":"1250433","transaction_code":"C","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-11-14 21:40:00","snet_input_date":"2025-11-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-14 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:27.000000Z","updated_at":"2025-12-08T10:30:32.000000Z","inspection_violations":[{"id":17319985,"change_date":"2025-12-04 21:38:00","inspection_id":"86321528","insp_violation_id":"270461739","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:06.000000Z","updated_at":"2025-12-08T10:30:56.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":17290080,"change_date":"2025-12-04 21:38:00","inspection_id":"86321528","insp_unit_id":"210414211","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC45221","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X4SD712639","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:39.000000Z"},{"id":17290081,"change_date":"2025-12-04 21:38:00","inspection_id":"86321528","insp_unit_id":"210414212","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAIL","insp_unit_company":null,"insp_unit_license":"E171285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DA29D5L1110436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:39.000000Z"},{"id":17290082,"change_date":"2025-12-04 21:38:00","inspection_id":"86321528","insp_unit_id":"210414213","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E171286","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DA29D5L1110437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:39.000000Z"}]},{"id":10030650,"change_date":"2025-10-24 21:40:00","inspection_id":"86142395","dot_number":"3593267","report_state":"MI","report_number":"HOLLM04638","insp_date":"2025-10-23 00:00:00","insp_start_time":"1220","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"I-94 E\/B GRASS LAKE SCALE","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"88255531","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1247604","transaction_code":"A","transaction_date":"2025-10-23 00:00:00","upload_date":"2025-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-10-24 21:40:00","snet_input_date":"2025-10-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-24 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-27T10:01:53.000000Z","updated_at":"2025-10-28T10:01:11.000000Z","inspection_violations":[{"id":16591388,"change_date":"2025-10-24 21:40:00","inspection_id":"86142395","insp_violation_id":"269504327","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4612836","created_at":"2025-10-27T10:17:51.000000Z","updated_at":"2025-10-28T10:16:32.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":16664398,"change_date":"2025-10-24 21:40:00","inspection_id":"86142395","insp_unit_id":"209644803","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RC46159","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDTAPT3KN360797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-27T09:47:07.000000Z","updated_at":"2025-10-28T09:46:30.000000Z"},{"id":16664399,"change_date":"2025-10-24 21:40:00","inspection_id":"86142395","insp_unit_id":"209644804","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E371310","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3L383NR075258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-27T09:47:07.000000Z","updated_at":"2025-10-28T09:46:30.000000Z"}]},{"id":9911669,"change_date":"2025-10-10 21:40:00","inspection_id":"86016596","dot_number":"3593267","report_state":"MI","report_number":"DELMT02284","insp_date":"2025-10-10 00:00:00","insp_start_time":"1320","insp_end_time":"1355","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":"MOSCOW MDOT PIT","shipping_paper_number":"88253985","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1245770","transaction_code":"A","transaction_date":"2025-10-10 00:00:00","upload_date":"2025-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-10-10 21:40:00","snet_input_date":"2025-10-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-10 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-13T10:02:10.000000Z","updated_at":"2025-10-14T10:01:09.000000Z","inspection_violations":[{"id":16354219,"change_date":"2025-10-10 21:40:00","inspection_id":"86016596","insp_violation_id":"269233586","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4608294","created_at":"2025-10-13T10:18:12.000000Z","updated_at":"2025-10-14T10:16:49.000000Z","normalized_code":"3922SLLEWA1"},{"id":16354220,"change_date":"2025-10-10 21:40:00","inspection_id":"86016596","insp_violation_id":"269233587","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"209410924","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-13T10:18:12.000000Z","updated_at":"2025-10-14T10:16:49.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":16449282,"change_date":"2025-10-10 21:40:00","inspection_id":"86016596","insp_unit_id":"209410924","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC45754","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X2SD712641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-13T09:47:31.000000Z","updated_at":"2025-10-14T09:46:29.000000Z"},{"id":16449283,"change_date":"2025-10-10 21:40:00","inspection_id":"86016596","insp_unit_id":"209410925","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F031012","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2846SC081680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-13T09:47:31.000000Z","updated_at":"2025-10-14T09:46:29.000000Z"},{"id":16449284,"change_date":"2025-10-10 21:40:00","inspection_id":"86016596","insp_unit_id":"209410926","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F211423","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2547TC085288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-13T09:47:31.000000Z","updated_at":"2025-10-14T09:46:29.000000Z"}]},{"id":9911416,"change_date":"2025-10-22 21:39:00","inspection_id":"86016324","dot_number":"3593267","report_state":"MI","report_number":"PEIFM07640","insp_date":"2025-10-10 00:00:00","insp_start_time":"0025","insp_end_time":"0040","registration_date":null,"region":"ET","ci_status_code":"C","location":"142","location_desc":"MONROE SCALE S\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1245560","transaction_code":"C","transaction_date":"2025-10-10 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-10-10 21:40:00","snet_input_date":"2025-10-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-10 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-13T10:02:09.000000Z","updated_at":"2025-10-26T10:00:23.000000Z","inspection_violations":[{"id":16535540,"change_date":"2025-10-22 21:39:00","inspection_id":"86016324","insp_violation_id":"269451698","seq_no":"1","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":"2025-10-25T10:17:06.000000Z","updated_at":"2025-10-26T10:15:35.000000Z","normalized_code":"3922SLLED"}],"inspection_per_units":[{"id":16614615,"change_date":"2025-10-22 21:39:00","inspection_id":"86016324","insp_unit_id":"209600758","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"962506","insp_unit_license":"RC45222","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X4SD712642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:40.000000Z","updated_at":"2025-10-26T09:45:25.000000Z"},{"id":16614616,"change_date":"2025-10-22 21:39:00","inspection_id":"86016324","insp_unit_id":"209600759","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E965885","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2N487RR085682","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:40.000000Z","updated_at":"2025-10-26T09:45:25.000000Z"},{"id":16614617,"change_date":"2025-10-22 21:39:00","inspection_id":"86016324","insp_unit_id":"209600760","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E965886","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W2L482RR085683","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:40.000000Z","updated_at":"2025-10-26T09:45:25.000000Z"}]},{"id":9770979,"change_date":"2025-09-24 21:42:00","inspection_id":"85868902","dot_number":"3593267","report_state":"MI","report_number":"SHEPZ05340","insp_date":"2025-09-24 00:00:00","insp_start_time":"0655","insp_end_time":"0730","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":"KRONOS","shipping_paper_number":"88251741","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"224000","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":"1243100","transaction_code":"A","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:17.000000Z","updated_at":"2025-09-28T10:00:44.000000Z","inspection_violations":[{"id":16060143,"change_date":"2025-09-24 21:42:00","inspection_id":"85868902","insp_violation_id":"268901627","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4599153","created_at":"2025-09-27T10:17:08.000000Z","updated_at":"2025-09-28T10:16:11.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":16187403,"change_date":"2025-09-24 21:42:00","inspection_id":"85868902","insp_unit_id":"209128165","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"962508H","insp_unit_license":"RC45483","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X8SD712644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:24.000000Z","updated_at":"2025-09-29T09:46:13.000000Z"},{"id":16187404,"change_date":"2025-09-24 21:42:00","inspection_id":"85868902","insp_unit_id":"209128166","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":"782300","insp_unit_license":"E644807","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DA29D8P1110422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:24.000000Z","updated_at":"2025-09-29T09:46:13.000000Z"},{"id":16187405,"change_date":"2025-09-24 21:42:00","inspection_id":"85868902","insp_unit_id":"209128167","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"TRST","insp_unit_company":"782301","insp_unit_license":"E644808","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DA26D4P1110423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:24.000000Z","updated_at":"2025-09-29T09:46:13.000000Z"}]},{"id":9770956,"change_date":"2025-09-24 21:42:00","inspection_id":"85868877","dot_number":"3593267","report_state":"MI","report_number":"DIUBJ03737","insp_date":"2025-09-24 00:00:00","insp_start_time":"0125","insp_end_time":"0149","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-23 SB AT MM 3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1243093","transaction_code":"A","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:17.000000Z","updated_at":"2025-09-28T10:00:44.000000Z","inspection_violations":[{"id":16060106,"change_date":"2025-09-24 21:42:00","inspection_id":"85868877","insp_violation_id":"268901577","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4601594","created_at":"2025-09-27T10:17:08.000000Z","updated_at":"2025-09-28T10:16:11.000000Z","normalized_code":"3922SLLTCD"},{"id":16060107,"change_date":"2025-09-24 21:42:00","inspection_id":"85868877","insp_violation_id":"268901578","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"209128122","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:17:08.000000Z","updated_at":"2025-09-28T10:16:11.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16187362,"change_date":"2025-09-24 21:42:00","inspection_id":"85868877","insp_unit_id":"209128121","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"962506H","insp_unit_license":"RC45222","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X4SD712642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:24.000000Z","updated_at":"2025-09-29T09:46:13.000000Z"},{"id":16187363,"change_date":"2025-09-24 21:42:00","inspection_id":"85868877","insp_unit_id":"209128122","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":null,"insp_unit_license":"F031012","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2846SC081680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:24.000000Z","updated_at":"2025-09-29T09:46:13.000000Z"},{"id":16187364,"change_date":"2025-09-24 21:42:00","inspection_id":"85868877","insp_unit_id":"209128123","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCOA","insp_unit_company":null,"insp_unit_license":"F211423","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2547TC085288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:24.000000Z","updated_at":"2025-09-29T09:46:13.000000Z"}]},{"id":9770493,"change_date":"2025-10-02 21:42:00","inspection_id":"85868391","dot_number":"3593267","report_state":"MI","report_number":"DELMT02221","insp_date":"2025-09-23 00:00:00","insp_start_time":"1525","insp_end_time":"1620","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SULTAN CEMENT LLC","shipping_paper_number":"88251665","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"4","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1242352","transaction_code":"C","transaction_date":"2025-09-23 00:00:00","upload_date":"2025-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:16.000000Z","updated_at":"2025-10-05T10:01:39.000000Z","inspection_violations":[{"id":16193079,"change_date":"2025-10-02 21:42:00","inspection_id":"85868391","insp_violation_id":"269058184","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:27.000000Z","updated_at":"2025-10-05T10:17:27.000000Z","normalized_code":"3922SLLEWA1"},{"id":16193080,"change_date":"2025-10-02 21:42:00","inspection_id":"85868391","insp_violation_id":"269058185","seq_no":"2","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"209264544","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-05T10:17:27.000000Z","updated_at":"2025-10-05T10:17:27.000000Z","normalized_code":"3963A1BALR"},{"id":16193081,"change_date":"2025-10-02 21:42:00","inspection_id":"85868391","insp_violation_id":"269058186","seq_no":"3","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"209264545","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4601346","created_at":"2025-10-05T10:17:27.000000Z","updated_at":"2025-10-05T10:17:27.000000Z","normalized_code":"39345B2BHTD"},{"id":16193082,"change_date":"2025-10-02 21:42:00","inspection_id":"85868391","insp_violation_id":"269058187","seq_no":"4","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"3","insp_unit_id":"209264546","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-05T10:17:27.000000Z","updated_at":"2025-10-05T10:17:27.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":16306461,"change_date":"2025-10-02 21:42:00","inspection_id":"85868391","insp_unit_id":"209264544","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC46551","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X8NF490191","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:52.000000Z","updated_at":"2025-10-05T09:46:52.000000Z"},{"id":16306462,"change_date":"2025-10-02 21:42:00","inspection_id":"85868391","insp_unit_id":"209264545","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E616212","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DA29D9N1110152","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:52.000000Z","updated_at":"2025-10-05T09:46:52.000000Z"},{"id":16306463,"change_date":"2025-10-02 21:42:00","inspection_id":"85868391","insp_unit_id":"209264546","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E616213","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DA26D5N1110153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:52.000000Z","updated_at":"2025-10-05T09:46:52.000000Z"}]},{"id":9696033,"change_date":"2025-09-16 21:40:00","inspection_id":"85790374","dot_number":"3593267","report_state":"MI","report_number":"HOLLM04553","insp_date":"2025-09-15 00:00:00","insp_start_time":"0850","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"I-94 E\/B GRASS LAKE SCALE","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"88150354","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1241276","transaction_code":"A","transaction_date":"2025-09-15 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-09-16 21:40:00","snet_input_date":"2025-09-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-16 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:01:01.000000Z","updated_at":"2025-09-23T10:01:05.000000Z","inspection_violations":[{"id":15907911,"change_date":"2025-09-16 21:40:00","inspection_id":"85790374","insp_violation_id":"268729627","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4586751","created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:49.000000Z","normalized_code":"3922SLLEWA3"},{"id":15907912,"change_date":"2025-09-16 21:40:00","inspection_id":"85790374","insp_violation_id":"268729628","seq_no":"2","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"3","insp_unit_id":"208981151","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:49.000000Z","normalized_code":"39375GTAOW"}],"inspection_per_units":[{"id":16050565,"change_date":"2025-09-16 21:40:00","inspection_id":"85790374","insp_unit_id":"208981149","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC46555","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X0SD712637","insp_unit_decal":"Y","insp_unit_decal_number":"35457329","created_at":"2025-09-18T09:45:43.000000Z","updated_at":"2025-09-20T09:45:31.000000Z"},{"id":16050566,"change_date":"2025-09-16 21:40:00","inspection_id":"85790374","insp_unit_id":"208981150","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":null,"insp_unit_license":"F296076","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2842TC087672","insp_unit_decal":"Y","insp_unit_decal_number":"35457330","created_at":"2025-09-18T09:45:43.000000Z","updated_at":"2025-09-20T09:45:31.000000Z"},{"id":16050567,"change_date":"2025-09-16 21:40:00","inspection_id":"85790374","insp_unit_id":"208981151","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCOA","insp_unit_company":null,"insp_unit_license":"F296077","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2549TC087673","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:43.000000Z","updated_at":"2025-09-20T09:45:31.000000Z"}]},{"id":9696235,"change_date":"2025-09-16 21:40:00","inspection_id":"85790588","dot_number":"3593267","report_state":"MI","report_number":"DEJOS01952","insp_date":"2025-09-12 00:00:00","insp_start_time":"1340","insp_end_time":"1435","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRASS LAKE SCALES E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MOSCOW MDOT PIT","shipping_paper_number":"88250264","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"5","oos_total":"4","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1241402","transaction_code":"A","transaction_date":"2025-09-12 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-09-16 21:40:00","snet_input_date":"2025-09-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-16 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:01:01.000000Z","updated_at":"2025-09-23T10:01:06.000000Z","inspection_violations":[{"id":15908290,"change_date":"2025-09-16 21:40:00","inspection_id":"85790588","insp_violation_id":"268730116","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4597541","created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:51.000000Z","normalized_code":"3922SLLEWA3"},{"id":15908291,"change_date":"2025-09-16 21:40:00","inspection_id":"85790588","insp_violation_id":"268730117","seq_no":"2","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"3","insp_unit_id":"208981554","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4597541","created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:51.000000Z","normalized_code":"39375GTAOW"},{"id":15908292,"change_date":"2025-09-16 21:40:00","inspection_id":"85790588","insp_violation_id":"268730118","seq_no":"3","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"3","insp_unit_id":"208981554","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:51.000000Z","normalized_code":"39375GTAOW"},{"id":15908293,"change_date":"2025-09-16 21:40:00","inspection_id":"85790588","insp_violation_id":"268730119","seq_no":"4","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"3","insp_unit_id":"208981554","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:51.000000Z","normalized_code":"39375GTAOW"},{"id":15908294,"change_date":"2025-09-16 21:40:00","inspection_id":"85790588","insp_violation_id":"268730120","seq_no":"5","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"3","insp_unit_id":"208981554","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:51.000000Z","normalized_code":"39375GTAOW"}],"inspection_per_units":[{"id":16050902,"change_date":"2025-09-16 21:40:00","inspection_id":"85790588","insp_unit_id":"208981552","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"962506","insp_unit_license":"RC45222","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X4SD712642","insp_unit_decal":"Y","insp_unit_decal_number":"35457220","created_at":"2025-09-18T09:45:43.000000Z","updated_at":"2025-09-20T09:45:31.000000Z"},{"id":16050903,"change_date":"2025-09-16 21:40:00","inspection_id":"85790588","insp_unit_id":"208981553","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"LEAD","insp_unit_license":"F031012","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2846SC081680","insp_unit_decal":"Y","insp_unit_decal_number":"35457221","created_at":"2025-09-18T09:45:43.000000Z","updated_at":"2025-09-20T09:45:31.000000Z"},{"id":16050904,"change_date":"2025-09-16 21:40:00","inspection_id":"85790588","insp_unit_id":"208981554","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"782600 PUP","insp_unit_license":"F211423","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2547TC085288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:43.000000Z","updated_at":"2025-09-20T09:45:31.000000Z"}]},{"id":9669038,"change_date":"2025-09-12 21:49:00","inspection_id":"85762025","dot_number":"3593267","report_state":"MI","report_number":"ROBER00891","insp_date":"2025-09-11 00:00:00","insp_start_time":"1500","insp_end_time":"1548","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"MONROE SCALE N\/B","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HERCULES PLANT","shipping_paper_number":"68535388","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-12 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"224740","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":"1240904","transaction_code":"A","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-09-12 21:49:00","snet_input_date":"2025-09-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-12 21:49:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-16T10:48:15.000000Z","updated_at":"2025-09-16T10:48:15.000000Z","inspection_violations":[{"id":15845673,"change_date":"2025-09-12 21:49:00","inspection_id":"85762025","insp_violation_id":"268659263","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4553467","created_at":"2025-09-14T11:58:00.000000Z","updated_at":"2025-09-16T10:51:12.000000Z","normalized_code":"3922SLLEWG2"}],"inspection_per_units":[{"id":15993462,"change_date":"2025-09-12 21:49:00","inspection_id":"85762025","insp_unit_id":"208919773","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"962500","insp_unit_license":"RC46547","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X9SD712636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:58.000000Z","updated_at":"2025-09-16T09:56:03.000000Z"},{"id":15993463,"change_date":"2025-09-12 21:49:00","inspection_id":"85762025","insp_unit_id":"208919774","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"962500T1","insp_unit_license":"F211432","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2943PR082420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:58.000000Z","updated_at":"2025-09-16T09:56:03.000000Z"},{"id":15993464,"change_date":"2025-09-12 21:49:00","inspection_id":"85762025","insp_unit_id":"208919775","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"UNK","insp_unit_company":"962500T2","insp_unit_license":"E736231","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA264XPR082421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:58.000000Z","updated_at":"2025-09-16T09:56:03.000000Z"}]},{"id":9392154,"change_date":"2025-08-12 21:40:00","inspection_id":"85471188","dot_number":"3593267","report_state":"MI","report_number":"PEIFM07443","insp_date":"2025-08-12 00:00:00","insp_start_time":"0345","insp_end_time":"0405","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB AT 7 MM","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1235632","transaction_code":"A","transaction_date":"2025-08-12 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-08-12 21:40:00","snet_input_date":"2025-08-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-12 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-15T10:43:50.000000Z","updated_at":"2025-08-16T10:00:53.000000Z","inspection_violations":[{"id":15268992,"change_date":"2025-08-12 21:40:00","inspection_id":"85471188","insp_violation_id":"267981008","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4580392","created_at":"2025-08-15T10:45:52.000000Z","updated_at":"2025-08-16T10:44:09.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":15478021,"change_date":"2025-08-12 21:40:00","inspection_id":"85471188","insp_unit_id":"208358416","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC46553","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X5NJ164625","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:24.000000Z","updated_at":"2025-08-16T09:46:08.000000Z"},{"id":15478022,"change_date":"2025-08-12 21:40:00","inspection_id":"85471188","insp_unit_id":"208358417","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E371310","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3L383NR075258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:24.000000Z","updated_at":"2025-08-16T09:46:08.000000Z"},{"id":15478023,"change_date":"2025-08-12 21:40:00","inspection_id":"85471188","insp_unit_id":"208358418","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E371311","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W3H581NR075259","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:24.000000Z","updated_at":"2025-08-16T09:46:08.000000Z"}]},{"id":9237922,"change_date":"2025-07-24 21:41:00","inspection_id":"85309014","dot_number":"3593267","report_state":"MI","report_number":"DEJOS01768","insp_date":"2025-07-22 00:00:00","insp_start_time":"2140","insp_end_time":"2215","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRASS LAKE SCALES E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MOSCOW MDOT PIT","shipping_paper_number":"88244409","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1232176","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-07-24 21:41:00","snet_input_date":"2025-07-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-24 21:41:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:55.000000Z","updated_at":"2025-07-30T10:00:51.000000Z","inspection_violations":[{"id":14955878,"change_date":"2025-07-24 21:41:00","inspection_id":"85309014","insp_violation_id":"267628654","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4565763","created_at":"2025-07-27T10:44:15.000000Z","updated_at":"2025-07-28T10:48:51.000000Z","normalized_code":"3922SLLEWA2"},{"id":14955879,"change_date":"2025-07-24 21:41:00","inspection_id":"85309014","insp_violation_id":"267628655","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"208060223","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:15.000000Z","updated_at":"2025-07-28T10:48:51.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":15201143,"change_date":"2025-07-24 21:41:00","inspection_id":"85309014","insp_unit_id":"208060223","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"962502","insp_unit_license":"RC44700","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X2SD712638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:31.000000Z","updated_at":"2025-07-28T09:46:04.000000Z"},{"id":15201144,"change_date":"2025-07-24 21:41:00","inspection_id":"85309014","insp_unit_id":"208060224","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"81682 LEAD","insp_unit_license":"F031014","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA284XSC081682","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:31.000000Z","updated_at":"2025-07-28T09:46:04.000000Z"},{"id":15201145,"change_date":"2025-07-24 21:41:00","inspection_id":"85309014","insp_unit_id":"208060225","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"81683 PUP","insp_unit_license":"F031015","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2546SC081683","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:31.000000Z","updated_at":"2025-07-28T09:46:04.000000Z"}]},{"id":9092375,"change_date":"2025-07-09 09:31:00","inspection_id":"85156484","dot_number":"3593267","report_state":"MI","report_number":"DELMT02036","insp_date":"2025-07-08 00:00:00","insp_start_time":"2000","insp_end_time":"2055","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":"MOSCOW MDOT","shipping_paper_number":"88242481","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-07-09 09:31:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1229319","transaction_code":"A","transaction_date":"2025-07-08 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-07-09 09:31:00","snet_input_date":"2025-07-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-09 09:31:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-12T10:45:05.000000Z","updated_at":"2025-07-14T10:45:24.000000Z","inspection_violations":[{"id":14647082,"change_date":"2025-07-09 09:31:00","inspection_id":"85156484","insp_violation_id":"267274372","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4559180","created_at":"2025-07-13T10:48:43.000000Z","updated_at":"2025-07-13T10:48:43.000000Z","normalized_code":"3922SLLEWA1"},{"id":14647083,"change_date":"2025-07-09 09:31:00","inspection_id":"85156484","insp_violation_id":"267274373","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:48:43.000000Z","updated_at":"2025-07-13T10:48:43.000000Z","normalized_code":"3922SLLIFTA"},{"id":14647084,"change_date":"2025-07-09 09:31:00","inspection_id":"85156484","insp_violation_id":"267274374","seq_no":"3","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"3","insp_unit_id":"207758709","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:48:43.000000Z","updated_at":"2025-07-13T10:48:43.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":14950932,"change_date":"2025-07-09 09:31:00","inspection_id":"85156484","insp_unit_id":"207758707","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC45754","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X2SD712641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:45:16.000000Z","updated_at":"2025-07-13T09:45:16.000000Z"},{"id":14950933,"change_date":"2025-07-09 09:31:00","inspection_id":"85156484","insp_unit_id":"207758708","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E616233","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DA29D4N1110043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:45:16.000000Z","updated_at":"2025-07-13T09:45:16.000000Z"},{"id":14950934,"change_date":"2025-07-09 09:31:00","inspection_id":"85156484","insp_unit_id":"207758709","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E616234","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DA26D0N1110044","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:45:16.000000Z","updated_at":"2025-07-13T09:45:16.000000Z"}]},{"id":8921548,"change_date":"2025-06-17 21:41:00","inspection_id":"84975691","dot_number":"3593267","report_state":"MI","report_number":"DETGT05236","insp_date":"2025-06-16 00:00:00","insp_start_time":"1230","insp_end_time":"1251","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I94 @ CLEAR LAKE RD","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":"88239618","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-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1225797","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-06-17 21:41:00","snet_input_date":"2025-06-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-17 21:41:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-20T10:00:57.000000Z","updated_at":"2025-06-22T10:00:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18733632,"change_date":null,"inspection_id":"84975691","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC45754","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X2SD712641","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":18817053,"change_date":null,"inspection_id":"84975691","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E616233","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DA29D4N1110043","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":8873297,"change_date":"2025-06-11 21:42:00","inspection_id":"84924342","dot_number":"3593267","report_state":"MI","report_number":"SHEPZ05098","insp_date":"2025-06-09 00:00:00","insp_start_time":"1230","insp_end_time":"1315","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":"STONE CO","shipping_paper_number":"88238667","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212740","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":"1225034","transaction_code":"A","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-06-11 21:42:00","snet_input_date":"2025-06-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-11 21:42:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:01:01.000000Z","updated_at":"2025-06-15T10:00:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18655248,"change_date":null,"inspection_id":"84924342","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC46555","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X0SD712637","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":18816209,"change_date":null,"inspection_id":"84924342","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"E965885","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2N487RR085682","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":8796657,"change_date":"2025-06-02 21:39:00","inspection_id":"84843129","dot_number":"3593267","report_state":"MI","report_number":"SHEPZ05081","insp_date":"2025-05-30 00:00:00","insp_start_time":"1345","insp_end_time":"1450","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"224740","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1223668","transaction_code":"A","transaction_date":"2025-05-30 00:00:00","upload_date":"2025-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-06-02 21:39:00","snet_input_date":"2025-05-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-02 21:39:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-05T10:00:30.000000Z","updated_at":"2025-06-06T10:00:37.000000Z","inspection_violations":[{"id":18454170,"change_date":null,"inspection_id":"84843129","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45B2-B-AIR","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-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345B2BAIR"},{"id":18454171,"change_date":null,"inspection_id":"84843129","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A1-TEPBM","insp_viol_unit":"3","insp_unit_id":"3","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":"39375A1TEPBM"},{"id":18454172,"change_date":null,"inspection_id":"84843129","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LSLI","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":"3939ALSLI"},{"id":18454173,"change_date":null,"inspection_id":"84843129","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"3","insp_unit_id":"3","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":"3939ALSLIWR"},{"id":18454174,"change_date":null,"inspection_id":"84843129","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"3","insp_unit_id":"3","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":"3939ALTSI"},{"id":18454175,"change_date":null,"inspection_id":"84843129","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9ALTSIR","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":"3939ALTSIR"}],"inspection_per_units":[{"id":18731886,"change_date":null,"inspection_id":"84843129","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC46561","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X7RD690159","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":18815086,"change_date":null,"inspection_id":"84843129","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E344459","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3DG1N2986MG000229","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":8758590,"change_date":"2025-05-28 21:43:00","inspection_id":"84802827","dot_number":"3593267","report_state":"MI","report_number":"SHEPZ05067","insp_date":"2025-05-28 00:00:00","insp_start_time":"0710","insp_end_time":"0745","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":"SAC","shipping_paper_number":"88236779","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"236740","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":"1223253","transaction_code":"A","transaction_date":"2025-05-28 00:00:00","upload_date":"2025-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-05-28 21:43:00","snet_input_date":"2025-05-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-28 21:43:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-31T10:01:38.000000Z","updated_at":"2025-06-01T10:00:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18731442,"change_date":null,"inspection_id":"84802827","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC45755","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X6SD712643","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":18814593,"change_date":null,"inspection_id":"84802827","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E371310","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D3L383NR075258","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":8725324,"change_date":"2025-05-23 21:39:00","inspection_id":"84767663","dot_number":"3593267","report_state":"MI","report_number":"DAWDD03973","insp_date":"2025-05-22 00:00:00","insp_start_time":"0658","insp_end_time":"0801","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 AT NB I-75","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MOSCOW","shipping_paper_number":"88236340","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-23 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"152000","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":"1222656","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-05-23 21:39:00","snet_input_date":"2025-05-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-23 21:39:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-26T10:04:28.000000Z","updated_at":"2025-05-27T10:03:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18731026,"change_date":null,"inspection_id":"84767663","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC46553","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X5NJ164625","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":18814140,"change_date":null,"inspection_id":"84767663","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"E965830","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2N485RR085678","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":8645637,"change_date":"2025-05-15 21:43:00","inspection_id":"84683490","dot_number":"3593267","report_state":"MI","report_number":"HOLLM04356","insp_date":"2025-05-14 00:00:00","insp_start_time":"0915","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"I-94 W\/B GRASS LAKE SCALE","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"88235240","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"4","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1221594","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-05-15 21:43:00","snet_input_date":"2025-05-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-15 21:43:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-18T10:04:25.000000Z","updated_at":"2025-05-19T10:05:48.000000Z","inspection_violations":[{"id":18451576,"change_date":null,"inspection_id":"84683490","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"3","insp_unit_id":"3","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":"39345B2BAIR"},{"id":18451577,"change_date":null,"inspection_id":"84683490","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"3","insp_unit_id":"3","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":"3939ALSLIWR"},{"id":18451578,"change_date":null,"inspection_id":"84683490","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"3","insp_unit_id":"3","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":"3939ALTSI"}],"inspection_per_units":[{"id":18729987,"change_date":null,"inspection_id":"84683490","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC46553","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X5NJ164625","insp_unit_decal":null,"insp_unit_decal_number":"35167359","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18813071,"change_date":null,"inspection_id":"84683490","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E3965830","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2N485RR085678","insp_unit_decal":null,"insp_unit_decal_number":"35167360","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8631829,"change_date":"2025-05-14 21:42:00","inspection_id":"84668960","dot_number":"3593267","report_state":"MI","report_number":"WALKB03501","insp_date":"2025-05-13 00:00:00","insp_start_time":"1940","insp_end_time":"2050","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MOSCOW PITT","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"5","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1220940","transaction_code":"A","transaction_date":"2025-05-13 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-05-14 21:42:00","snet_input_date":"2025-05-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:05:19.000000Z","updated_at":"2025-05-18T10:06:02.000000Z","inspection_violations":[{"id":18451290,"change_date":null,"inspection_id":"84668960","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"207F-SDAS","insp_viol_unit":"1","insp_unit_id":"1","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":"393207FSDAS"},{"id":18451291,"change_date":null,"inspection_id":"84668960","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45D-B","insp_viol_unit":"3","insp_unit_id":"3","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":"39345DB"},{"id":18451292,"change_date":null,"inspection_id":"84668960","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"3","insp_unit_id":"3","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":"3963A1BALAC"}],"inspection_per_units":[{"id":18652060,"change_date":null,"inspection_id":"84668960","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC45222","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X4SD712642","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":18812860,"change_date":null,"inspection_id":"84668960","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"F211432","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2943PR082420","insp_unit_decal":null,"insp_unit_decal_number":"03517391","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8524078,"change_date":"2025-05-01 21:41:00","inspection_id":"84555666","dot_number":"3593267","report_state":"MI","report_number":"LULAN02642","insp_date":"2025-05-01 00:00:00","insp_start_time":"0000","insp_end_time":"0100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B I-94 @ BELLEVILLE RESTAREA","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1219901","transaction_code":"A","transaction_date":"2025-05-01 00:00:00","upload_date":"2025-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-05-01 21:41:00","snet_input_date":"2025-05-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-01 21:41:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-04T10:35:06.000000Z","updated_at":"2025-05-05T10:13:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18650591,"change_date":null,"inspection_id":"84555666","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC45754","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X2SD712641","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":18811252,"change_date":null,"inspection_id":"84555666","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E616233","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DA29D4N1110043","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":8168715,"change_date":"2025-03-20 21:42:00","inspection_id":"84181307","dot_number":"3593267","report_state":"MI","report_number":"SHEPZ04931","insp_date":"2025-03-19 00:00:00","insp_start_time":"0855","insp_end_time":"0925","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":"SULTAN CEMENT","shipping_paper_number":"8559","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"224740","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":"1214193","transaction_code":"A","transaction_date":"2025-03-19 00:00:00","upload_date":"2025-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-03-20 21:42:00","snet_input_date":"2025-03-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-20 21:42:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-23T10:52:26.000000Z","updated_at":"2025-03-24T10:26:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18723591,"change_date":null,"inspection_id":"84181307","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC46554","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40XXRD690155","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":18806026,"change_date":null,"inspection_id":"84181307","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"E647609","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3DG1N2982NG000410","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":7759518,"change_date":"2025-01-31 21:40:00","inspection_id":"83751298","dot_number":"3593267","report_state":"MI","report_number":"DELMT01748","insp_date":"2025-01-30 00:00:00","insp_start_time":"1455","insp_end_time":"1540","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":"SAC","shipping_paper_number":"400","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1208389","transaction_code":"A","transaction_date":"2025-01-30 00:00:00","upload_date":"2025-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-01-31 21:40:00","snet_input_date":"2025-01-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-31 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:12.000000Z","updated_at":"2025-03-17T20:59:12.000000Z","inspection_violations":[{"id":18436722,"change_date":null,"inspection_id":"83751298","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A1-TEPBM","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":"39375A1TEPBM"},{"id":18436723,"change_date":null,"inspection_id":"83751298","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"3","insp_unit_id":"3","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":"3939ALLPL"}],"inspection_per_units":[{"id":18718309,"change_date":null,"inspection_id":"83751298","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC45756","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X0SD712640","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":18800188,"change_date":null,"inspection_id":"83751298","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E616212","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DA29D9N1110152","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":7672245,"change_date":"2025-01-21 21:39:00","inspection_id":"83659724","dot_number":"3593267","report_state":"MI","report_number":"SHEPZ04825","insp_date":"2025-01-17 00:00:00","insp_start_time":"1025","insp_end_time":"1055","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":"SAC","shipping_paper_number":"016574","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"214000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1207225","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2025-01-21 21:39:00","snet_input_date":"2025-01-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-21 21:39:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:28.000000Z","updated_at":"2025-03-17T20:57:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18717142,"change_date":null,"inspection_id":"83659724","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC46561","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X7RD690159","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":18798922,"change_date":null,"inspection_id":"83659724","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"E673817","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3DG1N2985NG000370","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":7094654,"change_date":"2024-10-31 21:42:00","inspection_id":"83051239","dot_number":"3593267","report_state":"MI","report_number":"DELMT01579","insp_date":"2024-10-30 00:00:00","insp_start_time":"1735","insp_end_time":"1755","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B I94 NEAR AIRPORT RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SULTAN CEMENT LLC","shipping_paper_number":"68479872","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-10-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"185000","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":"1200193","transaction_code":"A","transaction_date":"2024-10-30 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2024-10-31 21:42:00","snet_input_date":"2024-10-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-31 21:42:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:53.000000Z","updated_at":"2025-03-17T20:43:53.000000Z","inspection_violations":[{"id":18426122,"change_date":null,"inspection_id":"83051239","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16-D","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":"39216D"}],"inspection_per_units":[{"id":18631384,"change_date":null,"inspection_id":"83051239","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD75365","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X0SD712637","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":18790046,"change_date":null,"inspection_id":"83051239","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"E965885","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2N487RR085682","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":7038750,"change_date":"2024-10-24 21:41:00","inspection_id":"82991978","dot_number":"3593267","report_state":"MI","report_number":"DELMT01564","insp_date":"2024-10-23 00:00:00","insp_start_time":"1820","insp_end_time":"1910","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":"OTTAWA LAKE QUARRY","shipping_paper_number":"68478126","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1199027","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2024-10-24 21:41:00","snet_input_date":"2024-10-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-24 21:41:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:41.000000Z","updated_at":"2025-03-17T20:42:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18630612,"change_date":null,"inspection_id":"82991978","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC71435","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X6NF490190","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":18789235,"change_date":null,"inspection_id":"82991978","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F031008","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2844SC081676","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":7003794,"change_date":"2024-10-21 21:41:00","inspection_id":"82954936","dot_number":"3593267","report_state":"MI","report_number":"DELMT01554","insp_date":"2024-10-18 00:00:00","insp_start_time":"1640","insp_end_time":"1715","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":"OTTAWA LAKE QUARRY","shipping_paper_number":"68476810","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1198757","transaction_code":"A","transaction_date":"2024-10-18 00:00:00","upload_date":"2024-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2024-10-21 21:41:00","snet_input_date":"2024-10-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-21 21:41:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:14.000000Z","updated_at":"2025-03-17T20:42:14.000000Z","inspection_violations":[{"id":18424539,"change_date":null,"inspection_id":"82954936","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"70D-CDTISD","insp_viol_unit":"D","insp_unit_id":null,"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":"39370DCDTISD"}],"inspection_per_units":[{"id":18630122,"change_date":null,"inspection_id":"82954936","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD95818","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X0SD712640","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":18788702,"change_date":null,"inspection_id":"82954936","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E616212","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DA29D9N1110152","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":6933579,"change_date":"2025-03-05 21:40:00","inspection_id":"82880256","dot_number":"3593267","report_state":"MI","report_number":"DIUBJ03345","insp_date":"2024-10-09 00:00:00","insp_start_time":"1800","insp_end_time":"1822","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-23 NB AT MM 21","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"STONECO","shipping_paper_number":"68474310","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-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1197663","transaction_code":"C","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2024-10-10 21:42:00","snet_input_date":"2024-10-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-10 21:42:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:40.000000Z","updated_at":"2025-03-17T20:40:40.000000Z","inspection_violations":[{"id":18423254,"change_date":null,"inspection_id":"82880256","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"82DUMT","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":"39282DUMT"}],"inspection_per_units":[{"id":18629174,"change_date":null,"inspection_id":"82880256","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD95833","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X6SD712643","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":18787622,"change_date":null,"inspection_id":"82880256","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F031014","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA284XSC081682","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":6891952,"change_date":"2024-10-04 21:40:00","inspection_id":"82835896","dot_number":"3593267","report_state":"MI","report_number":"DELMT01519","insp_date":"2024-10-03 00:00:00","insp_start_time":"1940","insp_end_time":"2010","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":"SAC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1197244","transaction_code":"A","transaction_date":"2024-10-03 00:00:00","upload_date":"2024-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2024-10-04 21:40:00","snet_input_date":"2024-10-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-04 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:49.000000Z","updated_at":"2025-03-17T20:39:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18706280,"change_date":null,"inspection_id":"82835896","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD95833","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X6SD712643","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":18786982,"change_date":null,"inspection_id":"82835896","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F031014","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA284XSC081682","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":6809011,"change_date":"2024-09-24 21:42:00","inspection_id":"82747924","dot_number":"3593267","report_state":"MI","report_number":"DEJOS01263","insp_date":"2024-09-23 00:00:00","insp_start_time":"2125","insp_end_time":"2200","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRASS LAKE SCALES E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MOSCOW MDOT PIT","shipping_paper_number":"88221726","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1195779","transaction_code":"A","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2024-09-24 21:42:00","snet_input_date":"2024-09-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-24 21:42:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:12.000000Z","updated_at":"2025-03-17T20:38:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18705129,"change_date":null,"inspection_id":"82747924","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC71435","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X6NF490190","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":18785787,"change_date":null,"inspection_id":"82747924","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F031008","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2844SC081676","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":6658434,"change_date":"2024-09-17 21:45:00","inspection_id":"82587428","dot_number":"3593267","report_state":"MI","report_number":"SAHIW02188","insp_date":"2024-09-04 00:00:00","insp_start_time":"2310","insp_end_time":"0005","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB--I-96 @ BUCHANAN ST","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ASH GROVE","shipping_paper_number":"S21430199","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"192000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1193670","transaction_code":"C","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-09-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:54.000000Z","updated_at":"2025-03-17T20:34:54.000000Z","inspection_violations":[{"id":18418406,"change_date":null,"inspection_id":"82587428","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"},{"id":18418407,"change_date":null,"inspection_id":"82587428","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"100(b)","insp_viol_unit":"3","insp_unit_id":"3","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":"393100B"}],"inspection_per_units":[{"id":18625478,"change_date":null,"inspection_id":"82587428","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD70486","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X8RD690154","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":18783607,"change_date":null,"inspection_id":"82587428","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GALLE","insp_unit_company":null,"insp_unit_license":"E965880","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3DG1N2986RG000349","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":6562973,"change_date":"2024-09-17 21:46:00","inspection_id":"82485746","dot_number":"3593267","report_state":"MI","report_number":"WALKB03007","insp_date":"2024-08-23 00:00:00","insp_start_time":"1440","insp_end_time":"1505","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":"CARRIER","shipping_paper_number":"88217876","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1191661","transaction_code":"C","transaction_date":"2024-08-23 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2024-08-26 21:42:00","snet_input_date":"2024-08-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-26 21:42:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:09.000000Z","updated_at":"2025-03-17T20:33:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18701817,"change_date":null,"inspection_id":"82485746","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD75365","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X0SD712637","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":18782166,"change_date":null,"inspection_id":"82485746","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"E965882","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2N483RR085680","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":6539070,"change_date":"2024-09-17 21:45:00","inspection_id":"82460196","dot_number":"3593267","report_state":"MI","report_number":"SHEPZ04571","insp_date":"2024-08-20 00:00:00","insp_start_time":"1005","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"STONE CO","shipping_paper_number":"88217191","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"214000","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":"1190987","transaction_code":"C","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2024-08-22 21:42:00","snet_input_date":"2024-08-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-22 21:42:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:24.000000Z","updated_at":"2025-03-17T20:32:24.000000Z","inspection_violations":[{"id":18415978,"change_date":null,"inspection_id":"82460196","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"207(f)","insp_viol_unit":"3","insp_unit_id":"3","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":"393207F"},{"id":18415979,"change_date":null,"inspection_id":"82460196","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"3","insp_unit_id":"3","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":"39375GLOAD"}],"inspection_per_units":[{"id":18623791,"change_date":null,"inspection_id":"82460196","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD95819","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X2SD712641","insp_unit_decal":null,"insp_unit_decal_number":"34300493","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18781819,"change_date":null,"inspection_id":"82460196","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E616233","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DA29D4N1110043","insp_unit_decal":null,"insp_unit_decal_number":"34300494","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6516286,"change_date":"2024-09-17 21:45:00","inspection_id":"82436009","dot_number":"3593267","report_state":"MI","report_number":"HOLLM03971","insp_date":"2024-08-16 00:00:00","insp_start_time":"0950","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"I-94 E\/B GRASS LAKE SCALE","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"15151","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1190728","transaction_code":"C","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2024-08-20 21:42:00","snet_input_date":"2024-08-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-20 21:42:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:00.000000Z","updated_at":"2025-03-17T20:32:00.000000Z","inspection_violations":[{"id":18415556,"change_date":null,"inspection_id":"82436009","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"3","insp_unit_id":"3","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":"39375GLOAD"}],"inspection_per_units":[{"id":18623487,"change_date":null,"inspection_id":"82436009","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD95818","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X0SD712640","insp_unit_decal":null,"insp_unit_decal_number":"34300441","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18781516,"change_date":null,"inspection_id":"82436009","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E759357","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2945PR082418","insp_unit_decal":null,"insp_unit_decal_number":"34300442","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6299466,"change_date":"2024-09-17 21:45:00","inspection_id":"82204295","dot_number":"3593267","report_state":"MI","report_number":"DETGT04807","insp_date":"2024-07-22 00:00:00","insp_start_time":"1405","insp_end_time":"1439","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":null,"shipping_paper_number":"88212905","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1187082","transaction_code":"C","transaction_date":"2024-07-22 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2024-07-24 21:42:00","snet_input_date":"2024-07-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-24 21:42:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:27.000000Z","updated_at":"2025-03-17T20:27:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18698269,"change_date":null,"inspection_id":"82204295","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC71433","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40XXNF490189","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":18778318,"change_date":null,"inspection_id":"82204295","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F031008","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2844SC081676","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":6250002,"change_date":"2024-07-18 21:40:00","inspection_id":"82151461","dot_number":"3593267","report_state":"MI","report_number":"HOLLM03920","insp_date":"2024-07-17 00:00:00","insp_start_time":"1510","insp_end_time":"1545","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"I-94 E\/B GRASS LAKE SCALE","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"82212434","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1186384","transaction_code":"A","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2024-07-18 21:40:00","snet_input_date":"2024-07-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:37.000000Z","updated_at":"2025-03-17T20:26:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18697600,"change_date":null,"inspection_id":"82151461","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC71433","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40XXNF490189","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":18777585,"change_date":null,"inspection_id":"82151461","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F031008","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2844SC081676","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":4703025,"change_date":"2023-12-26 21:40:00","inspection_id":"80468839","dot_number":"3593267","report_state":"MI","report_number":"RAMSB01726","insp_date":"2023-12-22 00:00:00","insp_start_time":"1640","insp_end_time":"1659","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 SB AT WARREN AVE","county_code_state":"MI","county_code":"163","insp_level_id":"2","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-12-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1158591","transaction_code":"A","transaction_date":"2023-12-22 00:00:00","upload_date":"2023-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2023-12-26 21:40:00","snet_input_date":"2023-12-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-26 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:08.000000Z","updated_at":"2025-03-17T19:56:08.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4612036,"change_date":"2023-12-12 21:41:00","inspection_id":"80369077","dot_number":"3593267","report_state":"MI","report_number":"KERSD00156","insp_date":"2023-12-11 00:00:00","insp_start_time":"1350","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 E\/B @ OAKWOOD","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":"MULTI","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-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"213000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1156912","transaction_code":"A","transaction_date":"2023-12-11 00:00:00","upload_date":"2023-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2023-12-12 21:41:00","snet_input_date":"2023-12-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-12 21:41:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:12.000000Z","updated_at":"2025-03-17T19:54:12.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3375468,"change_date":"2023-06-27 21:40:00","inspection_id":"78994063","dot_number":"3593267","report_state":"MI","report_number":"ROBER00709","insp_date":"2023-06-09 00:00:00","insp_start_time":"1715","insp_end_time":"1741","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"14TH ST AND HOWARD","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":"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-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64740","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":"1132328","transaction_code":"A","transaction_date":"2023-06-26 00:00:00","upload_date":"2023-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2023-06-27 21:40:00","snet_input_date":"2023-06-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-27 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:48.000000Z","updated_at":"2025-03-17T19:29:48.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3094380,"change_date":"2023-05-19 21:43:00","inspection_id":"78677029","dot_number":"3593267","report_state":"MI","report_number":"LITTJ04450","insp_date":"2023-05-18 00:00:00","insp_start_time":"1650","insp_end_time":"1720","registration_date":null,"region":"ET","ci_status_code":"C","location":"210R3","location_desc":"BELLEVILLE REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"210000","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":"1127036","transaction_code":"A","transaction_date":"2023-05-18 00:00:00","upload_date":"2023-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2023-05-19 21:43:00","snet_input_date":"2023-05-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-19 21:43:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:12.000000Z","updated_at":"2025-03-17T19:24:12.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3083617,"change_date":"2023-05-18 21:43:00","inspection_id":"78664990","dot_number":"3593267","report_state":"MI","report_number":"WILLD02755","insp_date":"2023-05-17 00:00:00","insp_start_time":"1525","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 E\/B & WYOMING","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":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-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"154000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1126650","transaction_code":"A","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2023-05-18 21:43:00","snet_input_date":"2023-05-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-18 21:43:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:09.000000Z","updated_at":"2025-03-17T19:24:09.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2910008,"change_date":"2023-04-27 21:43:00","inspection_id":"78469041","dot_number":"3593267","report_state":"MI","report_number":"LULAN01770","insp_date":"2023-04-27 00:00:00","insp_start_time":"0824","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-94 @ RAWSONVILLE","county_code_state":"MI","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1123741","transaction_code":"A","transaction_date":"2023-04-27 00:00:00","upload_date":"2023-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2023-04-27 21:43:00","snet_input_date":"2023-04-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-27 21:43:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:26.000000Z","updated_at":"2025-03-17T19:20:26.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2435979,"change_date":"2023-02-23 21:40:00","inspection_id":"77930173","dot_number":"3593267","report_state":"MI","report_number":"OMILJ03924","insp_date":"2023-02-21 00:00:00","insp_start_time":"1305","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 NB @ MM 24","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"STONECO","shipping_paper_number":"321387","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-02-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"216000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1114753","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2023-02-23 21:40:00","snet_input_date":"2023-02-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-23 21:40:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:28.000000Z","updated_at":"2025-03-17T19:11:28.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":978977,"change_date":"2022-08-07 21:31:00","inspection_id":"76253050","dot_number":"3593267","report_state":"MI","report_number":"LULAN01281","insp_date":"2022-08-06 00:00:00","insp_start_time":"0853","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B I-94 @ MICHIGAN","county_code_state":"MI","county_code":"161","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-07 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1087837","transaction_code":"A","transaction_date":"2022-08-06 00:00:00","upload_date":"2022-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2022-08-07 21:31:00","snet_input_date":"2022-08-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-07 21:31:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:49.000000Z","updated_at":"2025-03-17T18:44:49.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":934181,"change_date":"2022-08-01 21:39:00","inspection_id":"76200840","dot_number":"3593267","report_state":"MI","report_number":"LULAN01249","insp_date":"2022-07-28 00:00:00","insp_start_time":"0754","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-94 @ RAWSONVILLE","county_code_state":"MI","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"55072127","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-08-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1086114","transaction_code":"A","transaction_date":"2022-07-28 00:00:00","upload_date":"2022-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03593267","upload_search_indicator":null,"census_search_date":"2022-08-01 21:39:00","snet_input_date":"2022-07-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-01 21:39:00","insp_carrier_name":"DETROIT AGGREGATE LLC","insp_carrier_street":"12225 STEPHENS RD","insp_carrier_city":"WARREN","insp_carrier_state":"MI","insp_carrier_zip_code":"48089","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:05.000000Z","updated_at":"2025-03-17T18:44:05.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3593267\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3593267\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3593267\/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\/3593267\/inspections","per_page":100,"prev_page_url":null,"to":54,"total":54}