{"current_page":1,"data":[{"id":9950932,"change_date":"2025-10-15 21:39:00","inspection_id":"86058552","dot_number":"3377671","report_state":"MI","report_number":"MANIJ02004","insp_date":"2025-10-14 00:00:00","insp_start_time":"1641","insp_end_time":"1703","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"130350","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1245974","transaction_code":"A","transaction_date":"2025-10-14 00:00:00","upload_date":"2025-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03377671","upload_search_indicator":null,"census_search_date":"2025-10-15 21:39:00","snet_input_date":"2025-10-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-15 21:39:00","insp_carrier_name":"MIDLAND SAND CO LLC","insp_carrier_street":"4450 N EASTMAN RD","insp_carrier_city":"MIDLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"48642","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-18T10:01:58.000000Z","updated_at":"2025-10-19T10:01:05.000000Z","inspection_violations":[{"id":16429783,"change_date":"2025-10-15 21:39:00","inspection_id":"86058552","insp_violation_id":"269319094","seq_no":"1","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"209487511","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:18:05.000000Z","updated_at":"2025-10-19T10:16:42.000000Z","normalized_code":"3939ALTSIR"},{"id":16429784,"change_date":"2025-10-15 21:39:00","inspection_id":"86058552","insp_violation_id":"269319095","seq_no":"2","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"2","insp_unit_id":"209487512","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:18:05.000000Z","updated_at":"2025-10-19T10:16:42.000000Z","normalized_code":"39311A1CSURR"},{"id":16429785,"change_date":"2025-10-15 21:39:00","inspection_id":"86058552","insp_violation_id":"269319096","seq_no":"3","part_no":"393","part_no_section":"11B-CSLRR","insp_viol_unit":"2","insp_unit_id":"209487512","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:18:05.000000Z","updated_at":"2025-10-19T10:16:42.000000Z","normalized_code":"39311BCSLRR"}],"inspection_per_units":[{"id":16519669,"change_date":"2025-10-15 21:39:00","inspection_id":"86058552","insp_unit_id":"209487511","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BE20426","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X2HJ166983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:15.000000Z","updated_at":"2025-10-19T09:46:18.000000Z"},{"id":16519670,"change_date":"2025-10-15 21:39:00","inspection_id":"86058552","insp_unit_id":"209487512","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BENS","insp_unit_company":null,"insp_unit_license":"E088982","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MDMDSSAC21B00033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:15.000000Z","updated_at":"2025-10-19T09:46:18.000000Z"}]},{"id":9807657,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","dot_number":"3377671","report_state":"MI","report_number":"SEYFE00210","insp_date":"2025-09-26 00:00:00","insp_start_time":"0916","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 @ KENSINGTON","county_code_state":"MI","county_code":"125","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":"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-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"12","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1243684","transaction_code":"C","transaction_date":"2025-09-26 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03377671","upload_search_indicator":null,"census_search_date":"2025-09-29 21:39:00","snet_input_date":"2025-09-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-29 21:39:00","insp_carrier_name":"MIDLAND SAND CO LLC","insp_carrier_street":"4450 N EASTMAN RD","insp_carrier_city":"MIDLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"48642","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-02T10:00:23.000000Z","updated_at":"2025-10-05T10:01:44.000000Z","inspection_violations":[{"id":16193783,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_violation_id":"269057123","seq_no":"1","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"3","insp_unit_id":"209263804","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":16193784,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_violation_id":"269057124","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"3","insp_unit_id":"209263804","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"3939ALIL"},{"id":16193785,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_violation_id":"269057125","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"209263803","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"39345DB"},{"id":16193786,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_violation_id":"269057126","seq_no":"4","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"209263802","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"3963A1BOS"},{"id":16193787,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_violation_id":"269057127","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209263802","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"39347E"},{"id":16193788,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_violation_id":"269057128","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209263802","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"39347E"},{"id":16193789,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_violation_id":"269057129","seq_no":"7","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209263802","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"39347E"},{"id":16193790,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_violation_id":"269057130","seq_no":"8","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209263802","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"39347E"},{"id":16193791,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_violation_id":"269057131","seq_no":"9","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209263802","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"39347E"},{"id":16193792,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_violation_id":"269057132","seq_no":"10","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"209263802","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"3965BL"},{"id":16193793,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_violation_id":"269057133","seq_no":"11","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"209263802","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"39311A1CSURR"},{"id":16193794,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_violation_id":"269057134","seq_no":"12","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"3","insp_unit_id":"209263804","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:28.000000Z","updated_at":"2025-10-05T10:17:28.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16307390,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_unit_id":"209263802","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"18","insp_unit_license":"BD50230","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDDB0X13F389690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:54.000000Z","updated_at":"2025-10-05T09:46:54.000000Z"},{"id":16307391,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_unit_id":"209263803","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"117","insp_unit_license":"D853542","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H2D02436SW048806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:54.000000Z","updated_at":"2025-10-05T09:46:54.000000Z"},{"id":16307392,"change_date":"2025-10-02 21:42:00","inspection_id":"85907495","insp_unit_id":"209263804","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"118","insp_unit_license":"D078368","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H2D02436SW048806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:54.000000Z","updated_at":"2025-10-05T09:46:54.000000Z"}]},{"id":9546935,"change_date":"2025-08-29 21:40:00","inspection_id":"85634389","dot_number":"3377671","report_state":"MI","report_number":"FRIZS03362","insp_date":"2025-08-28 00:00:00","insp_start_time":"0615","insp_end_time":"0644","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-10 E\/B @ EASTMAN RD","county_code_state":"MI","county_code":"111","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S \/ C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"186940","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1238633","transaction_code":"A","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03377671","upload_search_indicator":null,"census_search_date":"2025-08-29 21:40:00","snet_input_date":"2025-08-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-29 21:40:00","insp_carrier_name":"MIDLAND SAND CO LLC","insp_carrier_street":"4450 N EASTMAN RD","insp_carrier_city":"MIDLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"48642","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:32.000000Z","updated_at":"2025-09-06T10:42:32.000000Z","inspection_violations":[{"id":15585614,"change_date":"2025-08-29 21:40:00","inspection_id":"85634389","insp_violation_id":"268347163","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"208661101","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4580005","created_at":"2025-09-06T10:46:20.000000Z","updated_at":"2025-09-06T10:46:20.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":15585615,"change_date":"2025-08-29 21:40:00","inspection_id":"85634389","insp_violation_id":"268347164","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"208661101","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:20.000000Z","updated_at":"2025-09-06T10:46:20.000000Z","normalized_code":"3939ALCL"},{"id":15585616,"change_date":"2025-08-29 21:40:00","inspection_id":"85634389","insp_violation_id":"268347165","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"208661101","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:20.000000Z","updated_at":"2025-09-06T10:46:20.000000Z","normalized_code":"3939ALIL"},{"id":15585617,"change_date":"2025-08-29 21:40:00","inspection_id":"85634389","insp_violation_id":"268347166","seq_no":"4","part_no":"393","part_no_section":"11B-CSLRR","insp_viol_unit":"1","insp_unit_id":"208661101","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:20.000000Z","updated_at":"2025-09-06T10:46:20.000000Z","normalized_code":"39311BCSLRR"},{"id":15585618,"change_date":"2025-08-29 21:40:00","inspection_id":"85634389","insp_violation_id":"268347167","seq_no":"5","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"208661101","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:20.000000Z","updated_at":"2025-09-06T10:46:20.000000Z","normalized_code":"39311A1CSURR"},{"id":15585619,"change_date":"2025-08-29 21:40:00","inspection_id":"85634389","insp_violation_id":"268347168","seq_no":"6","part_no":"396","part_no_section":"3A1-OAL","insp_viol_unit":"1","insp_unit_id":"208661101","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:20.000000Z","updated_at":"2025-09-06T10:46:20.000000Z","normalized_code":"3963A1OAL"},{"id":15585620,"change_date":"2025-08-29 21:40:00","inspection_id":"85634389","insp_violation_id":"268347169","seq_no":"7","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"1","insp_unit_id":"208661101","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:20.000000Z","updated_at":"2025-09-06T10:46:20.000000Z","normalized_code":"393104F3C"}],"inspection_per_units":[{"id":15757524,"change_date":"2025-08-29 21:40:00","inspection_id":"85634389","insp_unit_id":"208661101","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"18","insp_unit_license":"BD50230","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDDB0X13F389690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:53.000000Z","updated_at":"2025-09-09T09:46:53.000000Z"},{"id":15757525,"change_date":"2025-08-29 21:40:00","inspection_id":"85634389","insp_unit_id":"208661102","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ETNY","insp_unit_company":null,"insp_unit_license":"D594925","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E9319268GE111229","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:53.000000Z","updated_at":"2025-09-09T09:46:53.000000Z"}]},{"id":6489969,"change_date":"2024-09-17 21:45:00","inspection_id":"82408075","dot_number":"3377671","report_state":"MI","report_number":"BEAMW03980","insp_date":"2024-08-14 00:00:00","insp_start_time":"1310","insp_end_time":"1326","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M20 @ CASTOR","county_code_state":"MI","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"1190197","transaction_code":"C","transaction_date":"2024-08-14 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03377671","upload_search_indicator":null,"census_search_date":"2024-08-16 21:39:00","snet_input_date":"2024-08-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"MIDLAND SAND CO LLC","insp_carrier_street":"4450 N EASTMAN RD","insp_carrier_city":"MIDLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"48642","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:34.000000Z","updated_at":"2025-03-17T20:31:34.000000Z","inspection_violations":[{"id":10076642,"change_date":"2024-09-17 21:45:00","inspection_id":"82408075","insp_violation_id":"261857422","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10461466,"change_date":"2024-09-17 21:45:00","inspection_id":"82408075","insp_unit_id":"202973908","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"BD75835","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDS7H4C4WJ517811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:23.000000Z","updated_at":"2025-03-17T23:31:23.000000Z"}]},{"id":6370015,"change_date":"2024-09-17 21:45:00","inspection_id":"82279728","dot_number":"3377671","report_state":"MI","report_number":"RAMSB01988","insp_date":"2024-08-01 00:00:00","insp_start_time":"0840","insp_end_time":"0916","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I94 WB AT OAKWOOD BLVD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WASTE MANAGEMENT","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"215000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1188608","transaction_code":"C","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03377671","upload_search_indicator":null,"census_search_date":"2024-08-01 21:41:00","snet_input_date":"2024-08-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-01 21:41:00","insp_carrier_name":"MIDLAND SAND CO LLC","insp_carrier_street":"4450 N EASTMAN RD","insp_carrier_city":"MIDLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"48642","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:06.000000Z","updated_at":"2025-03-17T20:29:06.000000Z","inspection_violations":[{"id":9888950,"change_date":"2024-09-17 21:45:00","inspection_id":"82279728","insp_violation_id":"261871901","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"3922"},{"id":9888951,"change_date":"2024-09-17 21:45:00","inspection_id":"82279728","insp_violation_id":"261871902","seq_no":"2","part_no":"390","part_no_section":"3(e)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4416274","created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"3903E"}],"inspection_per_units":[{"id":10265210,"change_date":"2024-09-17 21:45:00","inspection_id":"82279728","insp_unit_id":"202985544","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"18","insp_unit_license":"BD50230","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDDB0X13F389690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:21.000000Z","updated_at":"2025-03-17T23:29:21.000000Z"},{"id":10265211,"change_date":"2024-09-17 21:45:00","inspection_id":"82279728","insp_unit_id":"202985545","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACA","insp_unit_company":"19A","insp_unit_license":"D972944","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS24356C012043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:21.000000Z","updated_at":"2025-03-17T23:29:21.000000Z"},{"id":10265212,"change_date":"2024-09-17 21:45:00","inspection_id":"82279728","insp_unit_id":"202985546","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MACA","insp_unit_company":"19B","insp_unit_license":"E747553","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS20586C012044","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:21.000000Z","updated_at":"2025-03-17T23:29:21.000000Z"}]},{"id":4943112,"change_date":"2024-01-31 21:42:00","inspection_id":"80730981","dot_number":"3377671","report_state":"MI","report_number":"CHESJ04688","insp_date":"2024-01-30 00:00:00","insp_start_time":"1030","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E I-696 @ OLD PLANK","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-31 21:42:00","post_acc_ind":"Y","gross_comb_veh_wt":"182000","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":"1162388","transaction_code":"A","transaction_date":"2024-01-30 00:00:00","upload_date":"2024-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03377671","upload_search_indicator":null,"census_search_date":"2024-01-31 21:42:00","snet_input_date":"2024-01-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-31 21:42:00","insp_carrier_name":"MIDLAND SAND CO LLC","insp_carrier_street":"4450 N EASTMAN RD","insp_carrier_city":"MIDLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"48642","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:48.000000Z","updated_at":"2025-03-17T20:00:48.000000Z","inspection_violations":[{"id":7612616,"change_date":"2024-01-31 21:42:00","inspection_id":"80730981","insp_violation_id":"257584444","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:45.000000Z","updated_at":"2025-03-17T21:42:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7955032,"change_date":"2024-01-31 21:42:00","inspection_id":"80730981","insp_unit_id":"199195887","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"42","insp_unit_license":"BB68824","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X2HJ166983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:07.000000Z","updated_at":"2025-03-17T23:07:07.000000Z"},{"id":7955033,"change_date":"2024-01-31 21:42:00","inspection_id":"80730981","insp_unit_id":"199195888","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACA","insp_unit_company":"19A","insp_unit_license":"D972944","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS24356C012043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:07.000000Z","updated_at":"2025-03-17T23:07:07.000000Z"},{"id":7955034,"change_date":"2024-01-31 21:42:00","inspection_id":"80730981","insp_unit_id":"199195889","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MACA","insp_unit_company":"19B","insp_unit_license":"E747553","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS20586C012044","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:07.000000Z","updated_at":"2025-03-17T23:07:07.000000Z"}]},{"id":1098019,"change_date":"2022-08-22 21:42:00","inspection_id":"76392287","dot_number":"3377671","report_state":"MI","report_number":"JURKV01873","insp_date":"2022-08-18 00:00:00","insp_start_time":"1410","insp_end_time":"1432","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"172955","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":"1090524","transaction_code":"A","transaction_date":"2022-08-18 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03377671","upload_search_indicator":null,"census_search_date":"2022-08-22 21:42:00","snet_input_date":"2022-08-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-22 21:42:00","insp_carrier_name":"MIDLAND SAND CO LLC","insp_carrier_street":"4440 N EASTMAN RD","insp_carrier_city":"MIDLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"48642","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:57.000000Z","updated_at":"2025-03-17T18:46:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1766024,"change_date":"2022-08-22 21:42:00","inspection_id":"76392287","insp_unit_id":"190454768","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"AC92240","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDDB0X13F389690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:09.000000Z","updated_at":"2025-03-17T22:19:09.000000Z"},{"id":1766025,"change_date":"2022-08-22 21:42:00","inspection_id":"76392287","insp_unit_id":"190454769","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"D185637","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1Z9267795YE094018","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:09.000000Z","updated_at":"2025-03-17T22:19:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3377671\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3377671\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3377671\/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\/3377671\/inspections","per_page":100,"prev_page_url":null,"to":7,"total":7}