{"current_page":1,"data":[{"id":12204014,"change_date":"2026-06-16 21:40:00","inspection_id":"88160918","dot_number":"977673","report_state":"MO","report_number":"W230004532","insp_date":"2026-06-15 00:00:00","insp_start_time":"0719","insp_end_time":"0814","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KEWANEE MO","county_code_state":"MO","county_code":"143","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RALPH JONES SHEET METAL","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-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"6","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3555207","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00977673","upload_search_indicator":null,"census_search_date":"2026-06-16 21:40:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-16 21:40:00","insp_carrier_name":"RALPH JONES SHEET METAL INC","insp_carrier_street":"2035 HIGHWAY 70","insp_carrier_city":"GALLAWAY","insp_carrier_state":"TN","insp_carrier_zip_code":"38036","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-19T09:42:45.000000Z","updated_at":"2026-06-27T09:31:11.000000Z","inspection_violations":[{"id":21239325,"change_date":"2026-06-16 21:40:00","inspection_id":"88160918","insp_violation_id":"274947994","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"214135965","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:04:55.000000Z","updated_at":"2026-06-27T09:42:56.000000Z","normalized_code":"39395A4EEUS"},{"id":21239324,"change_date":"2026-06-16 21:40:00","inspection_id":"88160918","insp_violation_id":"274947993","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"214135965","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:04:55.000000Z","updated_at":"2026-06-27T09:42:56.000000Z","normalized_code":"39360C"},{"id":21239326,"change_date":"2026-06-16 21:40:00","inspection_id":"88160918","insp_violation_id":"274947995","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"214135964","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:04:55.000000Z","updated_at":"2026-06-27T09:42:56.000000Z","normalized_code":"3939ALIL"},{"id":21239327,"change_date":"2026-06-16 21:40:00","inspection_id":"88160918","insp_violation_id":"274947996","seq_no":"4","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:04:55.000000Z","updated_at":"2026-06-27T09:42:56.000000Z","normalized_code":"3958A"},{"id":21239328,"change_date":"2026-06-16 21:40:00","inspection_id":"88160918","insp_violation_id":"274947997","seq_no":"5","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:04:55.000000Z","updated_at":"2026-06-27T09:42:56.000000Z","normalized_code":"3958A"},{"id":21239329,"change_date":"2026-06-16 21:40:00","inspection_id":"88160918","insp_violation_id":"274947998","seq_no":"6","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:04:55.000000Z","updated_at":"2026-06-27T09:42:56.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":21196301,"change_date":"2026-06-16 21:40:00","inspection_id":"88160918","insp_unit_id":"214135964","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"U395272","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"46CFB2520CM017884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-19T09:20:25.000000Z","updated_at":"2026-06-27T09:02:27.000000Z"},{"id":21196302,"change_date":"2026-06-16 21:40:00","inspection_id":"88160918","insp_unit_id":"214135965","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"52786H2","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FT7W2A65KEF09616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-19T09:20:25.000000Z","updated_at":"2026-06-27T09:02:27.000000Z"}]},{"id":12165584,"change_date":"2026-07-17 21:43:00","inspection_id":"88119825","dot_number":"977673","report_state":"IL","report_number":"5002850302","insp_date":"2026-06-10 00:00:00","insp_start_time":"1348","insp_end_time":"1502","registration_date":"2026-07-16 00:00:00","region":"CT","ci_status_code":"C","location":"999","location_desc":"I-57","county_code_state":"IL","county_code":"003","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RALPH JONES SHEET METAL INC","shipping_paper_number":"11208389","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":"2026-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2479193","transaction_code":"C","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00977673","upload_search_indicator":null,"census_search_date":"2026-06-11 21:42:00","snet_input_date":"2026-06-10 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-06-11 21:42:00","insp_carrier_name":"RALPH JONES SHEET METAL INC","insp_carrier_street":"2035 HIGHWAY 70","insp_carrier_city":"GALLAWAY","insp_carrier_state":"TN","insp_carrier_zip_code":"38036","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-15T09:41:40.000000Z","updated_at":"2026-07-28T09:30:09.000000Z","inspection_violations":[{"id":21171408,"change_date":"2026-07-17 21:43:00","inspection_id":"88119825","insp_violation_id":"275584496","seq_no":"1","part_no":"392","part_no_section":"71A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-15T10:03:24.000000Z","updated_at":"2026-07-28T09:44:22.000000Z","normalized_code":"39271A"},{"id":21171415,"change_date":"2026-07-17 21:43:00","inspection_id":"88119825","insp_violation_id":"275584503","seq_no":"8","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-15T10:03:24.000000Z","updated_at":"2026-07-28T09:44:22.000000Z","normalized_code":"3958F1"},{"id":21171416,"change_date":"2026-07-17 21:43:00","inspection_id":"88119825","insp_violation_id":"275584504","seq_no":"9","part_no":"395","part_no_section":"8F10","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-15T10:03:24.000000Z","updated_at":"2026-07-28T09:44:22.000000Z","normalized_code":"3958F10"},{"id":21171409,"change_date":"2026-07-17 21:43:00","inspection_id":"88119825","insp_violation_id":"275584497","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"214689464","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-15T10:03:24.000000Z","updated_at":"2026-07-28T09:44:22.000000Z","normalized_code":"39360C"},{"id":21171410,"change_date":"2026-07-17 21:43:00","inspection_id":"88119825","insp_violation_id":"275584498","seq_no":"3","part_no":"393","part_no_section":"110B","insp_viol_unit":"2","insp_unit_id":"214689465","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-15T10:03:24.000000Z","updated_at":"2026-07-28T09:44:22.000000Z","normalized_code":"393110B"},{"id":21171411,"change_date":"2026-07-17 21:43:00","inspection_id":"88119825","insp_violation_id":"275584499","seq_no":"4","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"214689465","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-15T10:03:24.000000Z","updated_at":"2026-07-28T09:44:22.000000Z","normalized_code":"39343D"},{"id":21171412,"change_date":"2026-07-17 21:43:00","inspection_id":"88119825","insp_violation_id":"275584500","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"214689465","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-15T10:03:24.000000Z","updated_at":"2026-07-28T09:44:22.000000Z","normalized_code":"3939"},{"id":21171413,"change_date":"2026-07-17 21:43:00","inspection_id":"88119825","insp_violation_id":"275584501","seq_no":"6","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"214689464","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-15T10:03:24.000000Z","updated_at":"2026-07-28T09:44:22.000000Z","normalized_code":"39617C"},{"id":21171414,"change_date":"2026-07-17 21:43:00","inspection_id":"88119825","insp_violation_id":"275584502","seq_no":"7","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"214689465","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-15T10:03:24.000000Z","updated_at":"2026-07-28T09:44:22.000000Z","normalized_code":"39617C"},{"id":21171417,"change_date":"2026-07-17 21:43:00","inspection_id":"88119825","insp_violation_id":"275584505","seq_no":"10","part_no":"392","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"214689465","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-15T10:03:24.000000Z","updated_at":"2026-07-28T09:44:22.000000Z","normalized_code":"3929"}],"inspection_per_units":[{"id":21131760,"change_date":"2026-07-17 21:43:00","inspection_id":"88119825","insp_unit_id":"214689464","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"52786H2","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FT7W2A65KEF09616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-15T09:19:38.000000Z","updated_at":"2026-07-28T09:01:11.000000Z"},{"id":21131761,"change_date":"2026-07-17 21:43:00","inspection_id":"88119825","insp_unit_id":"214689465","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":null,"insp_unit_license":"587852T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"4Z1GF3527SS001028","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-15T09:19:38.000000Z","updated_at":"2026-07-28T09:01:11.000000Z"}]},{"id":7255411,"change_date":"2024-11-22 21:40:00","inspection_id":"83221340","dot_number":"977673","report_state":"WI","report_number":"2259008665","insp_date":"2024-11-19 00:00:00","insp_start_time":"0827","insp_end_time":"0904","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"TOWN WAUPUN WI","county_code_state":"WI","county_code":"039","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1080029","transaction_code":"A","transaction_date":"2024-11-22 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00977673","upload_search_indicator":null,"census_search_date":"2024-11-22 21:40:00","snet_input_date":"2024-11-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-22 21:40:00","insp_carrier_name":"RALPH JONES SHEET METAL INC","insp_carrier_street":"2035 HIGHWAY 70","insp_carrier_city":"GALLAWAY","insp_carrier_state":"TN","insp_carrier_zip_code":"38036","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:18.000000Z","updated_at":"2025-03-17T20:47:18.000000Z","inspection_violations":[{"id":11342898,"change_date":"2024-11-22 21:40:00","inspection_id":"83221340","insp_violation_id":"263033977","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"204003278","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39360C"},{"id":11342899,"change_date":"2024-11-22 21:40:00","inspection_id":"83221340","insp_violation_id":"263033978","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"204003278","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39021TB2DOT"},{"id":11342900,"change_date":"2024-11-22 21:40:00","inspection_id":"83221340","insp_violation_id":"263033979","seq_no":"3","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"204003278","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39021TB1MC"},{"id":11342901,"change_date":"2024-11-22 21:40:00","inspection_id":"83221340","insp_violation_id":"263033980","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204003278","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39617CPI"},{"id":11342902,"change_date":"2024-11-22 21:40:00","inspection_id":"83221340","insp_violation_id":"263033981","seq_no":"5","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3958A1HOSP"},{"id":11342903,"change_date":"2024-11-22 21:40:00","inspection_id":"83221340","insp_violation_id":"263033982","seq_no":"6","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39141AMCPC"},{"id":11342904,"change_date":"2024-11-22 21:40:00","inspection_id":"83221340","insp_violation_id":"263033983","seq_no":"7","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"204003279","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":11702753,"change_date":"2024-11-22 21:40:00","inspection_id":"83221340","insp_unit_id":"204003278","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"52786H2","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FT7W2A65KEF09616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:17.000000Z","updated_at":"2025-03-17T23:44:17.000000Z"},{"id":11702754,"change_date":"2024-11-22 21:40:00","inspection_id":"83221340","insp_unit_id":"204003279","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATOR TRAI","insp_unit_company":null,"insp_unit_license":"587852T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"4Z1GF3527SS001028","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:17.000000Z","updated_at":"2025-03-17T23:44:17.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/977673\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/977673\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/977673\/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\/977673\/inspections","per_page":100,"prev_page_url":null,"to":3,"total":3}