{"current_page":1,"data":[{"id":12099992,"change_date":"2026-06-04 21:46:00","inspection_id":"88044382","dot_number":"1869469","report_state":"MI","report_number":"DEJOS02671","insp_date":"2026-06-04 00:00:00","insp_start_time":"1225","insp_end_time":"1244","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-04 21:46:00","post_acc_ind":"N","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":"3468843","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01869469","upload_search_indicator":null,"census_search_date":"2026-06-04 21:46:00","snet_input_date":"2026-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:46:00","insp_carrier_name":"MCCONNELL SAND AND STONE LLC","insp_carrier_street":"29209 COUNTY RD 407","insp_carrier_city":"NEWBERRY","insp_carrier_state":"MI","insp_carrier_zip_code":"49868","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-07T09:40:57.000000Z","updated_at":"2026-06-16T09:32:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21024123,"change_date":"2026-06-04 21:46:00","inspection_id":"88044382","insp_unit_id":"213917348","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RC56568","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2AY38Y5KM001595","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:18:08.000000Z","updated_at":"2026-06-16T09:04:01.000000Z"},{"id":21024124,"change_date":"2026-06-04 21:46:00","inspection_id":"88044382","insp_unit_id":"213917349","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ROGE","insp_unit_company":null,"insp_unit_license":"F170248","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"16380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:18:08.000000Z","updated_at":"2026-06-16T09:04:01.000000Z"}]},{"id":11910612,"change_date":"2026-06-26 21:38:00","inspection_id":"87849886","dot_number":"1869469","report_state":"PA","report_number":"E907613406","insp_date":"2026-05-14 00:00:00","insp_start_time":"1300","insp_end_time":"1350","registration_date":"2026-06-26 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"BEAVER TWP PA","county_code_state":"PA","county_code":"031","insp_level_id":"1","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2026-05-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3325903","transaction_code":"C","transaction_date":"2026-06-26 00:00:00","upload_date":"2026-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01869469","upload_search_indicator":null,"census_search_date":"2026-05-14 21:43:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-14 21:43:00","insp_carrier_name":"MCCONNELL SAND AND STONE LLC","insp_carrier_street":"29209 COUNTY RD 407","insp_carrier_city":"NEWBERRY","insp_carrier_state":"MI","insp_carrier_zip_code":"49868","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"MI","created_at":"2026-05-16T13:32:56.000000Z","updated_at":"2026-07-07T09:30:04.000000Z","inspection_violations":[{"id":20719087,"change_date":"2026-06-26 21:38:00","inspection_id":"87849886","insp_violation_id":"275141491","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"214296776","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:15.000000Z","updated_at":"2026-07-07T09:41:24.000000Z","normalized_code":"39360D"},{"id":20719088,"change_date":"2026-06-26 21:38:00","inspection_id":"87849886","insp_violation_id":"275141492","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"214296776","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:15.000000Z","updated_at":"2026-07-07T09:41:24.000000Z","normalized_code":"39021TB1MC"},{"id":20719089,"change_date":"2026-06-26 21:38:00","inspection_id":"87849886","insp_violation_id":"275141493","seq_no":"3","part_no":"393","part_no_section":"48A-BLMACBD","insp_viol_unit":"1","insp_unit_id":"214296776","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:15.000000Z","updated_at":"2026-07-07T09:41:24.000000Z","normalized_code":"39348ABLMACBD"},{"id":20719090,"change_date":"2026-06-26 21:38:00","inspection_id":"87849886","insp_violation_id":"275141494","seq_no":"4","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"214296776","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-16T13:13:15.000000Z","updated_at":"2026-07-07T09:41:24.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":20705916,"change_date":"2026-06-26 21:38:00","inspection_id":"87849886","insp_unit_id":"214296776","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL TRUCK","insp_unit_company":null,"insp_unit_license":"RC45101","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAMKAZN5CL433705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:54.000000Z","updated_at":"2026-07-07T09:01:22.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1869469\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1869469\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1869469\/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\/1869469\/inspections","per_page":100,"prev_page_url":null,"to":2,"total":2}