{"current_page":1,"data":[{"id":12179112,"change_date":"2026-06-13 21:35:00","inspection_id":"88134269","dot_number":"262068","report_state":"TN","report_number":"I033GS1872","insp_date":"2026-06-11 00:00:00","insp_start_time":"1529","insp_end_time":"1533","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MT. JULIET TN","county_code_state":"TN","county_code":"189","insp_level_id":"2","service_center":"SH","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":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"3534158","transaction_code":"A","transaction_date":"2026-06-12 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-16T09:43:46.000000Z","updated_at":"2026-06-24T09:30:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21154766,"change_date":"2026-06-13 21:35:00","inspection_id":"88134269","insp_unit_id":"214085314","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"N874HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FVHCYD23THWG3105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:20:58.000000Z","updated_at":"2026-06-24T09:01:02.000000Z"}]},{"id":12055810,"change_date":"2026-05-30 21:35:00","inspection_id":"87997175","dot_number":"262068","report_state":"TN","report_number":"I01R291302","insp_date":"2026-05-29 00:00:00","insp_start_time":"0818","insp_end_time":"0831","registration_date":null,"region":"ED","ci_status_code":"C","location":"KNXWS","location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"OWNED BY CO","shipping_paper_number":"01\/0000003015","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-30 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"3433137","transaction_code":"A","transaction_date":"2026-05-30 00:00:00","upload_date":"2026-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2026-05-30 21:35:00","snet_input_date":"2026-05-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-30 21:35:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-02T09:40:07.000000Z","updated_at":"2026-06-10T09:30:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20952802,"change_date":"2026-05-30 21:35:00","inspection_id":"87997175","insp_unit_id":"213828929","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"73","insp_unit_license":"A547HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY4HDJA1541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-02T09:17:12.000000Z","updated_at":"2026-06-10T09:01:09.000000Z"}]},{"id":11976953,"change_date":"2026-05-26 21:40:00","inspection_id":"87914046","dot_number":"262068","report_state":"KY","report_number":"CV43854783","insp_date":"2026-05-20 00:00:00","insp_start_time":"0850","insp_end_time":"0918","registration_date":"2026-05-26 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"LANCASTER","county_code_state":"KY","county_code":"079","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"HAYES PIPE SUPPLY, INC.","shipping_paper_number":"B7583101","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-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2346454","transaction_code":"C","transaction_date":"2026-05-20 00:00:00","upload_date":"2026-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":"M","census_search_date":"2026-05-20 21:41:00","snet_input_date":"2026-05-20 00:00:00","source_office":"2KYS001","mcmis_add_date":"2026-05-20 21:41:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-23T09:43:01.000000Z","updated_at":"2026-06-06T09:30:46.000000Z","inspection_violations":[{"id":20834309,"change_date":"2026-05-26 21:40:00","inspection_id":"87914046","insp_violation_id":"274500745","seq_no":"2","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"1","insp_unit_id":"213752148","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:20.000000Z","updated_at":"2026-06-06T09:43:56.000000Z","normalized_code":"393104F3C"},{"id":20834308,"change_date":"2026-05-26 21:40:00","inspection_id":"87914046","insp_violation_id":"274500744","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"213752148","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:20.000000Z","updated_at":"2026-06-06T09:43:56.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":20822725,"change_date":"2026-05-26 21:40:00","inspection_id":"87914046","insp_unit_id":"213752148","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"81","insp_unit_license":"L042HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYD26NDNN1122","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:39.000000Z","updated_at":"2026-06-06T09:02:06.000000Z"}]},{"id":10476522,"change_date":"2025-12-19 21:38:00","inspection_id":"86610217","dot_number":"262068","report_state":"TN","report_number":"I033GS1701","insp_date":"2025-12-17 00:00:00","insp_start_time":"1306","insp_end_time":"1327","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MT. JULIET TN","county_code_state":"TN","county_code":"189","insp_level_id":"3","service_center":"SH","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":"2025-12-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2677234","transaction_code":"A","transaction_date":"2025-12-19 00:00:00","upload_date":"2025-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2025-12-19 21:38:00","snet_input_date":"2025-12-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-19 21:38:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-22T10:31:43.000000Z","updated_at":"2025-12-30T10:30:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17537351,"change_date":"2025-12-19 21:38:00","inspection_id":"86610217","insp_unit_id":"210706295","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"N874HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FVHCYD23THWG3105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-22T10:01:56.000000Z","updated_at":"2025-12-30T10:00:17.000000Z"}]},{"id":10426608,"change_date":"2025-12-13 21:34:00","inspection_id":"86558050","dot_number":"262068","report_state":"FL","report_number":"2592003124","insp_date":"2025-12-11 00:00:00","insp_start_time":"1431","insp_end_time":"1454","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MIMS FL","county_code_state":"FL","county_code":"009","insp_level_id":"2","service_center":"SH","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":"2025-12-13 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"2652513","transaction_code":"A","transaction_date":"2025-12-12 00:00:00","upload_date":"2025-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2025-12-13 21:34:00","snet_input_date":"2025-12-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-13 21:34:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-16T10:31:33.000000Z","updated_at":"2025-12-24T10:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17439704,"change_date":"2025-12-13 21:34:00","inspection_id":"86558050","insp_unit_id":"210589775","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"54","insp_unit_license":"A541HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY8FDGA3971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-16T10:02:01.000000Z","updated_at":"2025-12-24T10:00:11.000000Z"}]},{"id":9893151,"change_date":"2025-10-09 21:40:00","inspection_id":"85997179","dot_number":"262068","report_state":"GA","report_number":"1276000397","insp_date":"2025-10-02 00:00:00","insp_start_time":"1045","insp_end_time":"1200","registration_date":null,"region":"ED","ci_status_code":"C","location":"272","location_desc":"DOUGLASVILLE GA","county_code_state":"GA","county_code":"097","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"EAST JORDAN","shipping_paper_number":"559843","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":"2025-10-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"8","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":"2383649","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2025-10-09 21:40:00","snet_input_date":"2025-10-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-09 21:40:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-12T10:01:47.000000Z","updated_at":"2025-10-13T10:00:21.000000Z","inspection_violations":[{"id":16318184,"change_date":"2025-10-09 21:40:00","inspection_id":"85997179","insp_violation_id":"269191104","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"209374183","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:16.000000Z","updated_at":"2025-10-13T10:15:30.000000Z","normalized_code":"39395A1"},{"id":16318185,"change_date":"2025-10-09 21:40:00","inspection_id":"85997179","insp_violation_id":"269191105","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"209374183","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:16.000000Z","updated_at":"2025-10-13T10:15:30.000000Z","normalized_code":"3922SLLIFTA"},{"id":16318186,"change_date":"2025-10-09 21:40:00","inspection_id":"85997179","insp_violation_id":"269191106","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"209374183","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:16.000000Z","updated_at":"2025-10-13T10:15:30.000000Z","normalized_code":"39021TB2DOT"},{"id":16318187,"change_date":"2025-10-09 21:40:00","inspection_id":"85997179","insp_violation_id":"269191107","seq_no":"4","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"209374183","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:16.000000Z","updated_at":"2025-10-13T10:15:30.000000Z","normalized_code":"3922SLLIRP"},{"id":16318188,"change_date":"2025-10-09 21:40:00","inspection_id":"85997179","insp_violation_id":"269191108","seq_no":"5","part_no":"387","part_no_section":"301A","insp_viol_unit":"1","insp_unit_id":"209374183","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:16.000000Z","updated_at":"2025-10-13T10:15:30.000000Z","normalized_code":"387301A"},{"id":16318189,"change_date":"2025-10-09 21:40:00","inspection_id":"85997179","insp_violation_id":"269191109","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"209374183","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:16.000000Z","updated_at":"2025-10-13T10:15:30.000000Z","normalized_code":"39617CPI"},{"id":16318190,"change_date":"2025-10-09 21:40:00","inspection_id":"85997179","insp_violation_id":"269191110","seq_no":"7","part_no":"383","part_no_section":"51A-NSIN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:16.000000Z","updated_at":"2025-10-13T10:15:30.000000Z","normalized_code":"38351ANSIN"},{"id":16318191,"change_date":"2025-10-09 21:40:00","inspection_id":"85997179","insp_violation_id":"269191111","seq_no":"8","part_no":"390","part_no_section":"3E-DAC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"E03358799","created_at":"2025-10-12T10:17:16.000000Z","updated_at":"2025-10-13T10:15:30.000000Z","normalized_code":"3903EDAC"}],"inspection_per_units":[{"id":16416039,"change_date":"2025-10-09 21:40:00","inspection_id":"85997179","insp_unit_id":"209374183","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"84","insp_unit_license":"L045HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYD21NDNN1125","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:06.000000Z","updated_at":"2025-10-13T09:45:19.000000Z"}]},{"id":9590345,"change_date":"2025-09-04 21:40:00","inspection_id":"85679505","dot_number":"262068","report_state":"FL","report_number":"2148003634","insp_date":"2025-09-03 00:00:00","insp_start_time":"0820","insp_end_time":"0841","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"COCOA FL","county_code_state":"FL","county_code":"009","insp_level_id":"3","service_center":"SH","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":"Y","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":"2025-09-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"2219836","transaction_code":"A","transaction_date":"2025-09-04 00:00:00","upload_date":"2025-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2025-09-04 21:40:00","snet_input_date":"2025-09-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-04 21:40:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:24.000000Z","updated_at":"2025-09-10T10:45:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15834045,"change_date":"2025-09-04 21:40:00","inspection_id":"85679505","insp_unit_id":"208743222","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"54","insp_unit_license":"A541HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY8FDGA3971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:45.000000Z","updated_at":"2025-09-10T09:45:27.000000Z"}]},{"id":8952679,"change_date":"2025-06-22 21:34:00","inspection_id":"85008748","dot_number":"262068","report_state":"TN","report_number":"I036A30061","insp_date":"2025-06-20 00:00:00","insp_start_time":"0929","insp_end_time":"0936","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"3","service_center":"SH","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-22 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"1895399","transaction_code":"A","transaction_date":"2025-06-21 00:00:00","upload_date":"2025-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2025-06-22 21:34:00","snet_input_date":"2025-06-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-22 21:34:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-25T10:00:20.000000Z","updated_at":"2025-06-28T10:00:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14673946,"change_date":"2025-06-22 21:34:00","inspection_id":"85008748","insp_unit_id":"207490297","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1","insp_unit_license":"L235HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYD25NDNN1127","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-25T09:45:26.000000Z","updated_at":"2025-06-26T09:45:17.000000Z"}]},{"id":8530182,"change_date":"2025-05-02 21:40:00","inspection_id":"84562101","dot_number":"262068","report_state":"FL","report_number":"2592002789","insp_date":"2025-04-29 00:00:00","insp_start_time":"0738","insp_end_time":"0801","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ORANGE CITY FL","county_code_state":"FL","county_code":"127","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"10179","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":"2025-05-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"1674653","transaction_code":"A","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2025-05-02 21:40:00","snet_input_date":"2025-04-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-02 21:40:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-05T10:15:27.000000Z","updated_at":"2025-05-06T10:04:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13869064,"change_date":"2025-05-02 21:40:00","inspection_id":"84562101","insp_unit_id":"206609145","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"54","insp_unit_license":"A541HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY8FDGA3971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T10:00:45.000000Z","updated_at":"2025-05-07T09:54:39.000000Z"}]},{"id":7998569,"change_date":"2025-03-01 21:34:00","inspection_id":"84002165","dot_number":"262068","report_state":"FL","report_number":"3196007123","insp_date":"2025-02-25 00:00:00","insp_start_time":"1129","insp_end_time":"1154","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SORRENTO FL","county_code_state":"FL","county_code":"069","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-01 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"41900","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1415047","transaction_code":"A","transaction_date":"2025-03-01 00:00:00","upload_date":"2025-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2025-03-01 21:34:00","snet_input_date":"2025-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-01 21:34:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:08.000000Z","updated_at":"2025-03-17T21:04:08.000000Z","inspection_violations":[{"id":12497084,"change_date":"2025-03-01 21:34:00","inspection_id":"84002165","insp_violation_id":"264774894","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"205573318","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:03.000000Z","updated_at":"2025-03-17T22:07:03.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":12912748,"change_date":"2025-03-01 21:34:00","inspection_id":"84002165","insp_unit_id":"205573317","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"66","insp_unit_license":"H335480","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FDUF5GT7GEA79155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:37.000000Z","updated_at":"2025-03-17T23:57:37.000000Z"},{"id":12912749,"change_date":"2025-03-01 21:34:00","inspection_id":"84002165","insp_unit_id":"205573318","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"U568987","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"16VGX4026F6009590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:37.000000Z","updated_at":"2025-03-17T23:57:37.000000Z"}]},{"id":7868771,"change_date":"2025-02-14 21:39:00","inspection_id":"83866063","dot_number":"262068","report_state":"FL","report_number":"2334004654","insp_date":"2025-02-10 00:00:00","insp_start_time":"1400","insp_end_time":"1422","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GIBSONTON FL","county_code_state":"FL","county_code":"057","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"53464","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":"2025-02-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1359318","transaction_code":"A","transaction_date":"2025-02-14 00:00:00","upload_date":"2025-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2025-02-14 21:39:00","snet_input_date":"2025-02-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-14 21:39:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:33.000000Z","updated_at":"2025-03-17T21:01:33.000000Z","inspection_violations":[{"id":12296982,"change_date":"2025-02-14 21:39:00","inspection_id":"83866063","insp_violation_id":"264516184","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"205322220","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":12700209,"change_date":"2025-02-14 21:39:00","inspection_id":"83866063","insp_unit_id":"205322220","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"75","insp_unit_license":"A5564HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY8HDJA1543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:18.000000Z","updated_at":"2025-03-17T23:55:18.000000Z"}]},{"id":6452353,"change_date":"2024-08-13 21:41:00","inspection_id":"82367844","dot_number":"262068","report_state":"FL","report_number":"2073003567","insp_date":"2024-08-07 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PALM COAST FL","county_code_state":"FL","county_code":"035","insp_level_id":"2","service_center":"SH","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-08-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"741196","transaction_code":"A","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2024-08-13 21:41:00","snet_input_date":"2024-08-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-13 21:41:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:42.000000Z","updated_at":"2025-03-17T20:30:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10400005,"change_date":"2024-08-13 21:41:00","inspection_id":"82367844","insp_unit_id":"202360063","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"A548HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY7FDGA3976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:48.000000Z","updated_at":"2025-03-17T23:30:48.000000Z"}]},{"id":6249570,"change_date":"2024-07-18 21:40:00","inspection_id":"82150993","dot_number":"262068","report_state":"SC","report_number":"M321002344","insp_date":"2024-07-17 00:00:00","insp_start_time":"1340","insp_end_time":"1355","registration_date":null,"region":"ET","ci_status_code":"C","location":"011","location_desc":"I-20 WB LEXINGTON COUNTY","county_code_state":"SC","county_code":"063","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","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":"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":"52350","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":"1155294","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":"00262068","upload_search_indicator":null,"census_search_date":"2024-07-18 21:40:00","snet_input_date":"2024-07-17 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","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":10069610,"change_date":"2024-07-18 21:40:00","inspection_id":"82150993","insp_unit_id":"201949171","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"74","insp_unit_license":"A554HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY6HDJA1542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:18.000000Z","updated_at":"2025-03-17T23:27:18.000000Z"}]},{"id":5469517,"change_date":"2024-04-09 21:41:00","inspection_id":"81305412","dot_number":"262068","report_state":"KY","report_number":"CV42010421","insp_date":"2024-04-09 00:00:00","insp_start_time":"0939","insp_end_time":"1009","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PRESTONSBURG","county_code_state":"KY","county_code":"071","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"HAYES PIPE SUPPLY","shipping_paper_number":"MANIFEST","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-04-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"2219181","transaction_code":"A","transaction_date":"2024-04-09 00:00:00","upload_date":"2024-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":"M","census_search_date":"2024-04-09 21:41:00","snet_input_date":"2024-04-09 00:00:00","source_office":"2KYS001","mcmis_add_date":"2024-04-09 21:41:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:10.000000Z","updated_at":"2025-03-17T20:11:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8809952,"change_date":"2024-04-09 21:41:00","inspection_id":"81305412","insp_unit_id":"200307647","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"53","insp_unit_license":"A544HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCYXFDGA3972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:55.000000Z","updated_at":"2025-03-17T23:14:55.000000Z"}]},{"id":4815261,"change_date":"2024-01-11 21:46:00","inspection_id":"80591251","dot_number":"262068","report_state":"SC","report_number":"W351001624","insp_date":"2024-01-11 00:00:00","insp_start_time":"0840","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"017","location_desc":"I-77 NB CHESTER COUNTY","county_code_state":"SC","county_code":"023","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"WHITESELL TRUCKING INC","shipping_paper_number":"23006","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-11 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1124317","transaction_code":"A","transaction_date":"2024-01-11 00:00:00","upload_date":"2024-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2024-01-11 21:46:00","snet_input_date":"2024-01-11 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-01-11 21:46:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:04.000000Z","updated_at":"2025-03-17T19:58:04.000000Z","inspection_violations":[{"id":7426423,"change_date":"2024-01-11 21:46:00","inspection_id":"80591251","insp_violation_id":"257301691","seq_no":"1","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":"WA54454","created_at":"2025-03-17T21:41:51.000000Z","updated_at":"2025-03-17T21:41:51.000000Z","normalized_code":"3903E"}],"inspection_per_units":[{"id":7747199,"change_date":"2024-01-11 21:46:00","inspection_id":"80591251","insp_unit_id":"198924130","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"A554HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY6HDJA1542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:14.000000Z","updated_at":"2025-03-17T23:05:14.000000Z"}]},{"id":4764431,"change_date":"2024-01-05 21:46:00","inspection_id":"80535546","dot_number":"262068","report_state":"KY","report_number":"CV41013950","insp_date":"2024-01-04 00:00:00","insp_start_time":"1125","insp_end_time":"1210","registration_date":"2024-01-05 00:00:00","region":"ET","ci_status_code":"C","location":"9812","location_desc":"LONDON","county_code_state":"KY","county_code":"125","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"HAYES PIPE SUPPLY INC","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-04 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"2203001","transaction_code":"C","transaction_date":"2024-01-04 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":"M","census_search_date":"2024-01-04 21:47:00","snet_input_date":"2024-01-04 00:00:00","source_office":"2KYS001","mcmis_add_date":"2024-01-04 21:47:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:14.000000Z","updated_at":"2025-03-17T19:57:14.000000Z","inspection_violations":[{"id":7352269,"change_date":"2024-01-05 21:46:00","inspection_id":"80535546","insp_violation_id":"257207156","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:29.000000Z","updated_at":"2025-03-17T21:41:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7664522,"change_date":"2024-01-05 21:46:00","inspection_id":"80535546","insp_unit_id":"198833087","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"53","insp_unit_license":"A544HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCYXFDGA3972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:29.000000Z","updated_at":"2025-03-17T23:04:29.000000Z"}]},{"id":4526271,"change_date":"2023-12-08 21:40:00","inspection_id":"80274737","dot_number":"262068","report_state":"KY","report_number":"L731000254","insp_date":"2023-11-30 00:00:00","insp_start_time":"0934","insp_end_time":"1048","registration_date":"2023-12-08 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"LEXINGTON","county_code_state":"KY","county_code":"067","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"HAYES PIPE SUPPLY INC","shipping_paper_number":"AM3Q2","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2197851","transaction_code":"C","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":"M","census_search_date":"2023-11-30 21:38:00","snet_input_date":"2023-11-30 00:00:00","source_office":"2KYS001","mcmis_add_date":"2023-11-30 21:38:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:34.000000Z","updated_at":"2025-03-17T19:52:34.000000Z","inspection_violations":[{"id":7004086,"change_date":"2023-12-08 21:40:00","inspection_id":"80274737","insp_violation_id":"256788534","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198415335","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"39311"},{"id":7004087,"change_date":"2023-12-08 21:40:00","inspection_id":"80274737","insp_violation_id":"256788535","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198415335","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":7279328,"change_date":"2023-12-08 21:40:00","inspection_id":"80274737","insp_unit_id":"198415335","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"53","insp_unit_license":"A544HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCYXFDGA3972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:08.000000Z","updated_at":"2025-03-17T23:01:08.000000Z"}]},{"id":4378334,"change_date":"2023-11-08 21:40:00","inspection_id":"80112002","dot_number":"262068","report_state":"IN","report_number":"7250000098","insp_date":"2023-11-01 00:00:00","insp_start_time":"1015","insp_end_time":"1102","registration_date":null,"region":"ED","ci_status_code":"C","location":"4274W","location_desc":"WEST HARRISON IN","county_code_state":"IN","county_code":"029","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HAYES PIPE SUPPLY","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":"2023-11-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"89445","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2023-11-08 21:40:00","snet_input_date":"2023-11-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-08 21:40:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:34.000000Z","updated_at":"2025-03-17T19:49:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7041665,"change_date":"2023-11-08 21:40:00","inspection_id":"80112002","insp_unit_id":"197957983","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"H327564","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FDUF5GT2CEB55603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:07.000000Z","updated_at":"2025-03-17T22:59:07.000000Z"}]},{"id":4142143,"change_date":"2023-10-06 21:40:00","inspection_id":"79850794","dot_number":"262068","report_state":"FL","report_number":"2073002923","insp_date":"2023-10-04 00:00:00","insp_start_time":"1226","insp_end_time":"1248","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PALM COAST","county_code_state":"FL","county_code":"035","insp_level_id":"3","service_center":"SH","census_source_id":"4","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":"I","final_status_date":"2023-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"2546979","transaction_code":"A","transaction_date":"2023-10-04 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2023-10-06 21:40:00","snet_input_date":"2023-10-05 00:00:00","source_office":"2FLS001","mcmis_add_date":"2023-10-06 21:40:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"P O BOX 101550","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37224-1550","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:54.000000Z","updated_at":"2025-03-17T19:44:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6660057,"change_date":"2023-10-06 21:40:00","inspection_id":"79850794","insp_unit_id":"197432891","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"H335480","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FDUF5GT7GEA79155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:52.000000Z","updated_at":"2025-03-17T22:55:52.000000Z"}]},{"id":3953332,"change_date":"2023-09-26 21:42:00","inspection_id":"79640964","dot_number":"262068","report_state":"GA","report_number":"1349003581","insp_date":"2023-09-05 00:00:00","insp_start_time":"1645","insp_end_time":"1700","registration_date":null,"region":"ET","ci_status_code":"C","location":"A","location_desc":"INTERSTATE HWY","county_code_state":"GA","county_code":"135","insp_level_id":"3","service_center":"SH","census_source_id":"4","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":"I","final_status_date":"2023-09-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1999388","transaction_code":"C","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2023-09-12 21:39:00","snet_input_date":"2023-09-08 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-09-12 21:39:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"P O BOX 101550","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37224-1550","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:50.000000Z","updated_at":"2025-03-17T19:40:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6356515,"change_date":"2023-09-26 21:42:00","inspection_id":"79640964","insp_unit_id":"197241000","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"57","insp_unit_license":"A542HV","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"3ALHCYCY5FDGA3975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:24.000000Z","updated_at":"2025-03-17T22:53:24.000000Z"}]},{"id":3178358,"change_date":"2023-05-31 21:42:00","inspection_id":"78771813","dot_number":"262068","report_state":"NC","report_number":"0006540375","insp_date":"2023-05-31 00:00:00","insp_start_time":"0920","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":"GASTON","location_desc":"GASTON COUNTY WEIGH STATION I-","county_code_state":"NC","county_code":"071","insp_level_id":"3","service_center":"SH","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"2073955","transaction_code":"A","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":"M","census_search_date":"2023-05-31 21:42:00","snet_input_date":"2023-05-31 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-05-31 21:42:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"P O BOX 101550","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37224-1550","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:47.000000Z","updated_at":"2025-03-17T19:25:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5112208,"change_date":"2023-05-31 21:42:00","inspection_id":"78771813","insp_unit_id":"195226430","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"F305HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY4HDJA1538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:17.000000Z","updated_at":"2025-03-17T22:43:17.000000Z"}]},{"id":2816215,"change_date":"2023-04-17 21:40:00","inspection_id":"78362707","dot_number":"262068","report_state":"KY","report_number":"CV43402558","insp_date":"2023-04-17 00:00:00","insp_start_time":"0928","insp_end_time":"0948","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WADDY","county_code_state":"KY","county_code":"211","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"HAYES PIPE SUPPLY INC","shipping_paper_number":"AD394","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","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":"2159892","transaction_code":"A","transaction_date":"2023-04-17 00:00:00","upload_date":"2023-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":"M","census_search_date":"2023-04-17 21:40:00","snet_input_date":"2023-04-17 00:00:00","source_office":"2KYS001","mcmis_add_date":"2023-04-17 21:40:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:33.000000Z","updated_at":"2025-03-17T19:18:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4532298,"change_date":"2023-04-17 21:40:00","inspection_id":"78362707","insp_unit_id":"194417702","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"62","insp_unit_license":"A552HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY9FDGA3980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:44.000000Z","updated_at":"2025-03-17T22:38:44.000000Z"}]},{"id":2264525,"change_date":"2023-01-31 21:43:00","inspection_id":"77734531","dot_number":"262068","report_state":"NC","report_number":"0006500040","insp_date":"2023-01-31 00:00:00","insp_start_time":"1412","insp_end_time":"1423","registration_date":null,"region":"ET","ci_status_code":"C","location":"I40","location_desc":"I40","county_code_state":"NC","county_code":"021","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"HAYES PIPE SUPLY INC","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":"2023-01-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"2033702","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":"M","census_search_date":"2023-01-31 21:43:00","snet_input_date":"2023-01-31 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-01-31 21:43:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"P O BOX 101550","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37224-1550","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:28.000000Z","updated_at":"2025-03-17T19:08:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3644975,"change_date":"2023-01-31 21:43:00","inspection_id":"77734531","insp_unit_id":"193149630","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"F305HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY4HDJA1538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:07.000000Z","updated_at":"2025-03-17T22:32:07.000000Z"}]},{"id":2212094,"change_date":"2023-01-24 21:42:00","inspection_id":"77674734","dot_number":"262068","report_state":"FL","report_number":"3572005280","insp_date":"2023-01-18 00:00:00","insp_start_time":"1236","insp_end_time":"1249","registration_date":null,"region":"ET","ci_status_code":"C","location":"03","location_desc":"MCINTOSH RD & I-4 EB","county_code_state":"FL","county_code":"057","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAC","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":"I","final_status_date":"2023-01-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"2470067","transaction_code":"A","transaction_date":"2023-01-18 00:00:00","upload_date":"2023-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2023-01-24 21:42:00","snet_input_date":"2023-01-23 00:00:00","source_office":"2FLS001","mcmis_add_date":"2023-01-24 21:42:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"P O BOX 101550","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37224-1550","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:22.000000Z","updated_at":"2025-03-17T19:07:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3559960,"change_date":"2023-01-24 21:42:00","inspection_id":"77674734","insp_unit_id":"193026242","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"F272HV","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3ALHCYCY9HDJA1535","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:31.000000Z","updated_at":"2025-03-17T22:31:31.000000Z"}]},{"id":2139712,"change_date":"2023-01-13 21:40:00","inspection_id":"77591764","dot_number":"262068","report_state":"NC","report_number":"0006494563","insp_date":"2023-01-13 00:00:00","insp_start_time":"1010","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"GASTON","location_desc":"GASTON COUNTY WEIGH STATION I-","county_code_state":"NC","county_code":"071","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"HAYES PIPE SUPPLY","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":"2023-01-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"2028234","transaction_code":"A","transaction_date":"2023-01-13 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":"M","census_search_date":"2023-01-13 21:40:00","snet_input_date":"2023-01-13 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-01-13 21:40:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"P O BOX 101550","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37224-1550","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:56.000000Z","updated_at":"2025-03-17T19:05:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3443223,"change_date":"2023-01-13 21:40:00","inspection_id":"77591764","insp_unit_id":"192864535","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"F305HV","insp_unit_license_state":"SC","insp_unit_vehicle_id_number":"3ALHCYCY4HDJA1538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:40.000000Z","updated_at":"2025-03-17T22:30:40.000000Z"}]},{"id":1550473,"change_date":"2022-10-19 21:41:00","inspection_id":"76916758","dot_number":"262068","report_state":"SC","report_number":"G222008666","insp_date":"2022-10-17 00:00:00","insp_start_time":"1419","insp_end_time":"1436","registration_date":null,"region":"ET","ci_status_code":"C","location":"108","location_desc":"I-85 SB ROADSIDE","county_code_state":"SC","county_code":"021","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"1054692","transaction_code":"A","transaction_date":"2022-10-17 00:00:00","upload_date":"2022-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2022-10-19 21:41:00","snet_input_date":"2022-10-17 00:00:00","source_office":"2SCS001","mcmis_add_date":"2022-10-19 21:41:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:13.000000Z","updated_at":"2025-03-17T18:55:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2494760,"change_date":"2022-10-19 21:41:00","inspection_id":"76916758","insp_unit_id":"191522237","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"F305HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY4HDJA1538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:05.000000Z","updated_at":"2025-03-17T22:24:05.000000Z"}]},{"id":1445581,"change_date":"2022-10-05 21:40:00","inspection_id":"76795327","dot_number":"262068","report_state":"NC","report_number":"0006462522","insp_date":"2022-10-05 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"DRIVE","location_desc":"DRIVE","county_code_state":"NC","county_code":"119","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"1996150","transaction_code":"A","transaction_date":"2022-10-05 00:00:00","upload_date":"2022-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":"M","census_search_date":"2022-10-05 21:40:00","snet_input_date":"2022-10-05 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-10-05 21:40:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"P O BOX 101550","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37224-1550","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:24.000000Z","updated_at":"2025-03-17T18:53:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2327129,"change_date":"2022-10-05 21:40:00","inspection_id":"76795327","insp_unit_id":"191279346","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"74","insp_unit_license":"A554HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY6HDJA1542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:56.000000Z","updated_at":"2025-03-17T22:22:56.000000Z"}]},{"id":1155267,"change_date":"2022-08-29 21:41:00","inspection_id":"76458769","dot_number":"262068","report_state":"KY","report_number":"CV43232575","insp_date":"2022-08-29 00:00:00","insp_start_time":"1213","insp_end_time":"1259","registration_date":null,"region":"ET","ci_status_code":"C","location":"9811","location_desc":"LONDON","county_code_state":"KY","county_code":"125","insp_level_id":"1","service_center":"SH","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":"2022-08-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2118546","transaction_code":"A","transaction_date":"2022-08-29 00:00:00","upload_date":"2022-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":"M","census_search_date":"2022-08-29 21:41:00","snet_input_date":"2022-08-29 00:00:00","source_office":"2KYS001","mcmis_add_date":"2022-08-29 21:41:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:57.000000Z","updated_at":"2025-03-17T18:47:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1857062,"change_date":"2022-08-29 21:41:00","inspection_id":"76458769","insp_unit_id":"190587245","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"55","insp_unit_license":"A551HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY1FDGA3973","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:47.000000Z","updated_at":"2025-03-17T22:19:47.000000Z"}]},{"id":1193127,"change_date":"2022-09-01 21:41:00","inspection_id":"76502514","dot_number":"262068","report_state":"FL","report_number":"3186005751","insp_date":"2022-08-26 00:00:00","insp_start_time":"1504","insp_end_time":"1536","registration_date":null,"region":"ET","ci_status_code":"C","location":"HCCM24","location_desc":"MCSAP HCC I-4 HILLSBOROUGH","county_code_state":"FL","county_code":"057","insp_level_id":"1","service_center":"SH","census_source_id":"4","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":"I","final_status_date":"2022-09-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"2433381","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2022-09-01 21:41:00","snet_input_date":"2022-08-30 00:00:00","source_office":"2FLS001","mcmis_add_date":"2022-09-01 21:41:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"P O BOX 101550","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37224-1550","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:39.000000Z","updated_at":"2025-03-17T18:48:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1918517,"change_date":"2022-09-01 21:41:00","inspection_id":"76502514","insp_unit_id":"190676142","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"71","insp_unit_license":"K869HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY6HDJA1539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:11.000000Z","updated_at":"2025-03-17T22:20:11.000000Z"}]},{"id":1133816,"change_date":"2022-08-25 21:42:00","inspection_id":"76433773","dot_number":"262068","report_state":"SC","report_number":"C361000211","insp_date":"2022-08-25 00:00:00","insp_start_time":"1206","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":"012","location_desc":"I-26 EB NEWBERRY COUNTY","county_code_state":"SC","county_code":"071","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","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":"2022-08-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"1047576","transaction_code":"A","transaction_date":"2022-08-25 00:00:00","upload_date":"2022-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2022-08-25 21:42:00","snet_input_date":"2022-08-25 00:00:00","source_office":"2SCS001","mcmis_add_date":"2022-08-25 21:42:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:35.000000Z","updated_at":"2025-03-17T18:47:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1823429,"change_date":"2022-08-25 21:42:00","inspection_id":"76433773","insp_unit_id":"190539629","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"70","insp_unit_license":"F305HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY4HDJA1538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:33.000000Z","updated_at":"2025-03-17T22:19:33.000000Z"}]},{"id":920419,"change_date":"2022-08-15 21:37:00","inspection_id":"76184621","dot_number":"262068","report_state":"KY","report_number":"CV43723516","insp_date":"2022-07-28 00:00:00","insp_start_time":"1450","insp_end_time":"1535","registration_date":"2022-08-15 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"LONDON","county_code_state":"KY","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"2112724","transaction_code":"C","transaction_date":"2022-07-29 00:00:00","upload_date":"2022-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":"M","census_search_date":"2022-07-29 21:39:00","snet_input_date":"2022-07-29 00:00:00","source_office":"2KYS001","mcmis_add_date":"2022-07-29 21:39:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"950 FIBER GLASS RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37210-4633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:01.000000Z","updated_at":"2025-03-17T18:44:01.000000Z","inspection_violations":[{"id":1451236,"change_date":"2022-08-15 21:37:00","inspection_id":"76184621","insp_violation_id":"247702717","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190299045","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:51.000000Z","updated_at":"2025-03-17T21:13:51.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":1481551,"change_date":"2022-08-15 21:37:00","inspection_id":"76184621","insp_unit_id":"190299045","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"55","insp_unit_license":"A551HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY1FDGA3973","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:19.000000Z","updated_at":"2025-03-17T22:17:19.000000Z"}]},{"id":854298,"change_date":"2022-07-20 21:41:00","inspection_id":"76107064","dot_number":"262068","report_state":"NC","report_number":"0006438900","insp_date":"2022-07-19 00:00:00","insp_start_time":"1450","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":"I77 3M","location_desc":"I77 3MM","county_code_state":"NC","county_code":"119","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"1972680","transaction_code":"A","transaction_date":"2022-07-20 00:00:00","upload_date":"2022-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":"M","census_search_date":"2022-07-20 21:41:00","snet_input_date":"2022-07-20 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-07-20 21:41:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"P O BOX 101550","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37224-1550","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:42.000000Z","updated_at":"2025-03-17T18:42:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1375040,"change_date":"2022-07-20 21:41:00","inspection_id":"76107064","insp_unit_id":"189870897","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"74","insp_unit_license":"A554HV","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3ALHCYCY6HDJA1542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:39.000000Z","updated_at":"2025-03-17T22:16:39.000000Z"}]},{"id":933326,"change_date":"2022-08-01 21:39:00","inspection_id":"76199823","dot_number":"262068","report_state":"TN","report_number":"TFFP000028","insp_date":"2022-06-10 00:00:00","insp_start_time":"1007","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I-24 9.4 EB EXIT 11 SHELL STAT","county_code_state":"TN","county_code":"125","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"L AND R PLUMBING LLC","shipping_paper_number":"VJ629","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-08-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26001","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":"1588413","transaction_code":"A","transaction_date":"2022-06-10 00:00:00","upload_date":"2022-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00262068","upload_search_indicator":null,"census_search_date":"2022-08-01 21:39:00","snet_input_date":"2022-08-01 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-08-01 21:39:00","insp_carrier_name":"HAYES PIPE SUPPLY INC","insp_carrier_street":"P O BOX 101550","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37224-1550","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:05.000000Z","updated_at":"2025-03-17T18:44:05.000000Z","inspection_violations":[{"id":1472621,"change_date":"2022-08-01 21:39:00","inspection_id":"76199823","insp_violation_id":"247429378","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190061727","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:58.000000Z","updated_at":"2025-03-17T21:13:58.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1502236,"change_date":"2022-08-01 21:39:00","inspection_id":"76199823","insp_unit_id":"190061727","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1","insp_unit_license":"H337516","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FDUF5GT9GEA56167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:27.000000Z","updated_at":"2025-03-17T22:17:27.000000Z"},{"id":1502237,"change_date":"2022-08-01 21:39:00","inspection_id":"76199823","insp_unit_id":"190061728","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"1A","insp_unit_license":"U663904","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16VGX3023F6028530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:27.000000Z","updated_at":"2025-03-17T22:17:27.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/262068\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/262068\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/262068\/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\/262068\/inspections","per_page":100,"prev_page_url":null,"to":33,"total":33}