{"current_page":1,"data":[{"id":12399367,"change_date":"2026-07-14 21:41:00","inspection_id":"88356321","dot_number":"327516","report_state":"AL","report_number":"1118008170","insp_date":"2026-07-08 00:00:00","insp_start_time":"1130","insp_end_time":"1212","registration_date":"2026-07-14 00:00:00","region":"CD","ci_status_code":"C","location":null,"location_desc":"MAPLESVILLE AL","county_code_state":"AL","county_code":"021","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAGINAW PIPE","shipping_paper_number":"762786","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3716624","transaction_code":"C","transaction_date":"2026-07-09 00:00:00","upload_date":"2026-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2026-07-09 21:42:00","snet_input_date":"2026-07-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-09 21:42:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-13T09:39:20.000000Z","updated_at":"2026-07-25T09:30:17.000000Z","inspection_violations":[{"id":21575293,"change_date":"2026-07-14 21:41:00","inspection_id":"88356321","insp_violation_id":"275492426","seq_no":"2","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"U8340917","created_at":"2026-07-13T09:55:48.000000Z","updated_at":"2026-07-25T09:43:20.000000Z","normalized_code":"3922SLLS3"},{"id":21575292,"change_date":"2026-07-14 21:41:00","inspection_id":"88356321","insp_violation_id":"275492425","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"214603982","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:55:48.000000Z","updated_at":"2026-07-25T09:43:20.000000Z","normalized_code":"39617CPI"},{"id":21575294,"change_date":"2026-07-14 21:41:00","inspection_id":"88356321","insp_violation_id":"275492427","seq_no":"3","part_no":"391","part_no_section":"11B4-CLHA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:55:48.000000Z","updated_at":"2026-07-25T09:43:20.000000Z","normalized_code":"39111B4CLHA"}],"inspection_per_units":[{"id":21540798,"change_date":"2026-07-14 21:41:00","inspection_id":"88356321","insp_unit_id":"214603983","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"53-10272","insp_unit_license":"58AB3NU","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS2530DA488502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:39.000000Z","updated_at":"2026-07-25T09:01:23.000000Z"},{"id":21540797,"change_date":"2026-07-14 21:41:00","inspection_id":"88356321","insp_unit_id":"214603982","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"230137","insp_unit_license":"3407584","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"3HSDZTZR6RN257301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:39.000000Z","updated_at":"2026-07-25T09:01:23.000000Z"}]},{"id":11987488,"change_date":"2026-05-22 08:07:00","inspection_id":"87925117","dot_number":"327516","report_state":"AL","report_number":"2120000326","insp_date":"2026-05-21 00:00:00","insp_start_time":"0840","insp_end_time":"1010","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"OZARK AL","county_code_state":"AL","county_code":"045","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAGINAW","shipping_paper_number":"758146","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-22 08:07:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3380512","transaction_code":"A","transaction_date":"2026-05-21 00:00:00","upload_date":"2026-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2026-05-22 08:07:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 08:07:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:04.000000Z","updated_at":"2026-06-02T09:31:24.000000Z","inspection_violations":[{"id":20853896,"change_date":"2026-05-22 08:07:00","inspection_id":"87925117","insp_violation_id":"274426464","seq_no":"1","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"213692084","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"3939ALSML"},{"id":20853897,"change_date":"2026-05-22 08:07:00","inspection_id":"87925117","insp_violation_id":"274426465","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"39141APC"},{"id":20853898,"change_date":"2026-05-22 08:07:00","inspection_id":"87925117","insp_violation_id":"274426466","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213692084","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"39347E"},{"id":20853899,"change_date":"2026-05-22 08:07:00","inspection_id":"87925117","insp_violation_id":"274426467","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"213692084","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"39353BB"},{"id":20853900,"change_date":"2026-05-22 08:07:00","inspection_id":"87925117","insp_violation_id":"274426468","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213692084","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":20839958,"change_date":"2026-05-22 08:07:00","inspection_id":"87925117","insp_unit_id":"213692083","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"230137","insp_unit_license":"3407584","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZTZR6RN257301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:18:52.000000Z","updated_at":"2026-06-02T09:03:54.000000Z"},{"id":20839959,"change_date":"2026-05-22 08:07:00","inspection_id":"87925117","insp_unit_id":"213692084","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"53-10272","insp_unit_license":"58AB3NU","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS2530DA488502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:18:52.000000Z","updated_at":"2026-06-02T09:03:54.000000Z"}]},{"id":11128220,"change_date":"2026-02-13 21:39:00","inspection_id":"87041553","dot_number":"327516","report_state":"AL","report_number":"1299004136","insp_date":"2026-02-13 00:00:00","insp_start_time":"0730","insp_end_time":"0750","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"CALERA AL","county_code_state":"AL","county_code":"117","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-02-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2884124","transaction_code":"A","transaction_date":"2026-02-13 00:00:00","upload_date":"2026-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2026-02-13 21:39:00","snet_input_date":"2026-02-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-13 21:39:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-16T10:38:45.000000Z","updated_at":"2026-02-24T10:30:48.000000Z","inspection_violations":[{"id":18641922,"change_date":"2026-02-13 21:39:00","inspection_id":"87041553","insp_violation_id":"271785876","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211612269","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-16T10:54:30.000000Z","updated_at":"2026-02-24T10:39:08.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":18983189,"change_date":"2026-02-13 21:39:00","inspection_id":"87041553","insp_unit_id":"211612269","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"1191557","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1FUJA6CK57LX77731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-16T10:15:02.000000Z","updated_at":"2026-02-24T10:03:09.000000Z"},{"id":18983190,"change_date":"2026-02-13 21:39:00","inspection_id":"87041553","insp_unit_id":"211612270","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DM UTILITY","insp_unit_company":null,"insp_unit_license":"58AB3PY","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS25366A973701","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-16T10:15:02.000000Z","updated_at":"2026-02-24T10:03:09.000000Z"}]},{"id":11081321,"change_date":"2026-02-09 21:38:00","inspection_id":"86992540","dot_number":"327516","report_state":"AL","report_number":"1299004125","insp_date":"2026-02-09 00:00:00","insp_start_time":"1155","insp_end_time":"1215","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ALABASTER AL","county_code_state":"AL","county_code":"117","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAGINAW PIPE","shipping_paper_number":"749233","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-02-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","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":"2865017","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2026-02-09 21:38:00","snet_input_date":"2026-02-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-09 21:38:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-12T10:36:57.000000Z","updated_at":"2026-02-20T10:30:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18895671,"change_date":"2026-02-09 21:38:00","inspection_id":"86992540","insp_unit_id":"211514033","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"362791","insp_unit_license":"2893696","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEDV0LDMA0112","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:35.000000Z","updated_at":"2026-02-20T10:03:26.000000Z"},{"id":18895672,"change_date":"2026-02-09 21:38:00","inspection_id":"86992540","insp_unit_id":"211514034","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"53-10270","insp_unit_license":"A084726","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS2531CA331303","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:35.000000Z","updated_at":"2026-02-20T10:03:26.000000Z"}]},{"id":10831972,"change_date":"2026-01-22 21:38:00","inspection_id":"86860089","dot_number":"327516","report_state":"AL","report_number":"1204004481","insp_date":"2026-01-22 00:00:00","insp_start_time":"1004","insp_end_time":"1032","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"JASPER AL","county_code_state":"AL","county_code":"127","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":"2026-01-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"2801265","transaction_code":"A","transaction_date":"2026-01-22 00:00:00","upload_date":"2026-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2026-01-22 21:38:00","snet_input_date":"2026-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-22 21:38:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-25T10:36:44.000000Z","updated_at":"2026-02-02T10:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18193727,"change_date":"2026-01-22 21:38:00","inspection_id":"86860089","insp_unit_id":"211225334","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"531576","insp_unit_license":"3798993","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPR9TN154937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:10.000000Z","updated_at":"2026-02-02T10:02:30.000000Z"},{"id":18193728,"change_date":"2026-01-22 21:38:00","inspection_id":"86860089","insp_unit_id":"211225335","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"5310267","insp_unit_license":"58AB3NW","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS25326A971301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:10.000000Z","updated_at":"2026-02-02T10:02:30.000000Z"}]},{"id":9319788,"change_date":"2025-08-08 21:39:00","inspection_id":"85395184","dot_number":"327516","report_state":"AL","report_number":"1260004975","insp_date":"2025-08-04 00:00:00","insp_start_time":"0835","insp_end_time":"0900","registration_date":"2025-08-08 00:00:00","region":"CD","ci_status_code":"C","location":null,"location_desc":"CULLMAN AL","county_code_state":"AL","county_code":"043","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NORTH AL FABRICATING CO","shipping_paper_number":"736371","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-08-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","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":"2082892","transaction_code":"C","transaction_date":"2025-08-04 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2025-08-04 21:38:00","snet_input_date":"2025-08-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-04 21:38:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:47.000000Z","updated_at":"2025-08-12T10:44:07.000000Z","inspection_violations":[{"id":15200445,"change_date":"2025-08-08 21:39:00","inspection_id":"85395184","insp_violation_id":"267912794","seq_no":"1","part_no":"383","part_no_section":"95A-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:12.000000Z","updated_at":"2025-08-12T10:44:37.000000Z","normalized_code":"38395ALCDL"}],"inspection_per_units":[{"id":15417251,"change_date":"2025-08-08 21:39:00","inspection_id":"85395184","insp_unit_id":"208300079","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"230136","insp_unit_license":"3407832","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZTZR4RN257300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:20.000000Z","updated_at":"2025-08-12T09:45:16.000000Z"},{"id":15417252,"change_date":"2025-08-08 21:39:00","inspection_id":"85395184","insp_unit_id":"208300080","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"531024","insp_unit_license":"58AB3P4","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS25366A973701","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:20.000000Z","updated_at":"2025-08-12T09:45:16.000000Z"}]},{"id":9153993,"change_date":"2025-07-15 21:40:00","inspection_id":"85220801","dot_number":"327516","report_state":"MS","report_number":"5007013358","insp_date":"2025-07-15 00:00:00","insp_start_time":"0618","insp_end_time":"0636","registration_date":null,"region":"CT","ci_status_code":"C","location":"38","location_desc":"LAUDERDALE COUNTY","county_code_state":"MS","county_code":"075","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAGINAW PIPE CO,INC","shipping_paper_number":"734488","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1111759","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2025-07-15 21:40:00","snet_input_date":"2025-07-15 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-07-15 21:40:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:46:04.000000Z","updated_at":"2025-07-19T10:42:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15034730,"change_date":"2025-07-15 21:40:00","inspection_id":"85220801","insp_unit_id":"207880787","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"364238","insp_unit_license":"2894396","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLDR6LDMC7967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:39.000000Z","updated_at":"2025-07-19T09:45:45.000000Z"}]},{"id":9045341,"change_date":"2025-07-02 21:39:00","inspection_id":"85106284","dot_number":"327516","report_state":"AL","report_number":"1928003361","insp_date":"2025-07-01 00:00:00","insp_start_time":"0845","insp_end_time":"0902","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"DEATSVILLE AL","county_code_state":"AL","county_code":"001","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-07-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1938363","transaction_code":"A","transaction_date":"2025-07-01 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2025-07-02 21:39:00","snet_input_date":"2025-07-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-02 21:39:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:11.000000Z","updated_at":"2025-07-07T10:07:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14838437,"change_date":"2025-07-02 21:39:00","inspection_id":"85106284","insp_unit_id":"207667565","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"364238","insp_unit_license":"2894396","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLDR6LDMC7967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:03.000000Z","updated_at":"2025-07-06T09:45:08.000000Z"},{"id":14838438,"change_date":"2025-07-02 21:39:00","inspection_id":"85106284","insp_unit_id":"207667566","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"531026A","insp_unit_license":"58AB3NX","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS25346A971302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:03.000000Z","updated_at":"2025-07-06T09:45:08.000000Z"}]},{"id":8880189,"change_date":"2025-06-13 21:39:00","inspection_id":"84931638","dot_number":"327516","report_state":"AL","report_number":"2090000221","insp_date":"2025-06-12 00:00:00","insp_start_time":"0608","insp_end_time":"0629","registration_date":"2025-06-12 00:00:00","region":"CD","ci_status_code":"C","location":null,"location_desc":"TROY AL","county_code_state":"AL","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAGINAW PIPE","shipping_paper_number":"732322","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-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"1855485","transaction_code":"C","transaction_date":"2025-06-12 00:00:00","upload_date":"2025-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2025-06-12 21:40:00","snet_input_date":"2025-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-12 21:40:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-15T10:01:01.000000Z","updated_at":"2025-06-17T10:00:04.000000Z","inspection_violations":[{"id":14248155,"change_date":"2025-06-13 21:39:00","inspection_id":"84931638","insp_violation_id":"266822356","seq_no":"1","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-17T10:17:26.000000Z","updated_at":"2025-06-17T10:19:56.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":14562368,"change_date":"2025-06-13 21:39:00","inspection_id":"84931638","insp_unit_id":"207367704","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"364238","insp_unit_license":"2894396","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"3AKJGLDR6LDMC7967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-16T09:46:33.000000Z","updated_at":"2025-06-17T09:45:03.000000Z"},{"id":14562369,"change_date":"2025-06-13 21:39:00","inspection_id":"84931638","insp_unit_id":"207367705","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"531026A","insp_unit_license":"58AB3NX","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS25346A971302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-16T09:46:33.000000Z","updated_at":"2025-06-17T09:45:03.000000Z"}]},{"id":8447382,"change_date":"2025-04-23 21:41:00","inspection_id":"84464107","dot_number":"327516","report_state":"AL","report_number":"1440003257","insp_date":"2025-04-22 00:00:00","insp_start_time":"0705","insp_end_time":"0804","registration_date":"2025-04-23 00:00:00","region":"CD","ci_status_code":"C","location":null,"location_desc":"GOOD HOPE AL","county_code_state":"AL","county_code":"043","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"728579","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-04-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"141200","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1628059","transaction_code":"C","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2025-04-22 21:41:00","snet_input_date":"2025-04-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-22 21:41:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-26T10:28:15.000000Z","updated_at":"2025-04-27T10:29:55.000000Z","inspection_violations":[{"id":13345805,"change_date":"2025-04-23 21:41:00","inspection_id":"84464107","insp_violation_id":"265781670","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"206449258","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-25T11:03:48.000000Z","updated_at":"2025-04-26T10:44:02.000000Z","normalized_code":"39375A3TAOL"},{"id":13345806,"change_date":"2025-04-23 21:41:00","inspection_id":"84464107","insp_violation_id":"265781671","seq_no":"2","part_no":"393","part_no_section":"104B-C","insp_viol_unit":"2","insp_unit_id":"206449259","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:03:48.000000Z","updated_at":"2025-04-26T10:44:02.000000Z","normalized_code":"393104BC"}],"inspection_per_units":[{"id":13720923,"change_date":"2025-04-23 21:41:00","inspection_id":"84464107","insp_unit_id":"206449258","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"463715","insp_unit_license":"3570347","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPRXNN686796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:10:03.000000Z","updated_at":"2025-04-27T09:56:45.000000Z"},{"id":13720924,"change_date":"2025-04-23 21:41:00","inspection_id":"84464107","insp_unit_id":"206449259","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"53-1023","insp_unit_license":"58AB3P5","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS25386A973702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:10:03.000000Z","updated_at":"2025-04-27T09:56:45.000000Z"}]},{"id":8339600,"change_date":"2025-04-10 21:41:00","inspection_id":"84361121","dot_number":"327516","report_state":"AL","report_number":"1440003210","insp_date":"2025-04-10 00:00:00","insp_start_time":"0945","insp_end_time":"1008","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ONEONTA AL","county_code_state":"AL","county_code":"009","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"727726","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-04-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1577815","transaction_code":"A","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2025-04-10 21:41:00","snet_input_date":"2025-04-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-10 21:41:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:28:07.000000Z","updated_at":"2025-04-14T10:28:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13528800,"change_date":"2025-04-10 21:41:00","inspection_id":"84361121","insp_unit_id":"206241556","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"463715","insp_unit_license":"3570347","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZAPRXNN686796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:12:21.000000Z","updated_at":"2025-04-14T09:56:22.000000Z"},{"id":13528801,"change_date":"2025-04-10 21:41:00","inspection_id":"84361121","insp_unit_id":"206241557","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"53-367","insp_unit_license":"A083718","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS2537GA637508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:12:21.000000Z","updated_at":"2025-04-14T09:56:22.000000Z"}]},{"id":8336223,"change_date":"2025-04-10 21:41:00","inspection_id":"84357515","dot_number":"327516","report_state":"AL","report_number":"1836003083","insp_date":"2025-04-09 00:00:00","insp_start_time":"0630","insp_end_time":"0700","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SCOTTSBORO AL","county_code_state":"AL","county_code":"071","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAGINAW PIPE COMPANY","shipping_paper_number":"727835","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-04-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1574183","transaction_code":"A","transaction_date":"2025-04-09 00:00:00","upload_date":"2025-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2025-04-10 21:41:00","snet_input_date":"2025-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-10 21:41:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:27:51.000000Z","updated_at":"2025-04-14T10:27:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13523232,"change_date":"2025-04-10 21:41:00","inspection_id":"84357515","insp_unit_id":"206234874","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"323712","insp_unit_license":"3266108","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZTZR7KN731536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:08:11.000000Z","updated_at":"2025-04-14T09:50:19.000000Z"},{"id":13523233,"change_date":"2025-04-10 21:41:00","inspection_id":"84357515","insp_unit_id":"206234875","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"531024","insp_unit_license":"58AB3P4","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS25366A973701","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:08:11.000000Z","updated_at":"2025-04-14T09:50:19.000000Z"}]},{"id":7047604,"change_date":"2024-10-25 21:40:00","inspection_id":"83001411","dot_number":"327516","report_state":"MS","report_number":"MC00451006","insp_date":"2024-10-23 00:00:00","insp_start_time":"0856","insp_end_time":"0934","registration_date":null,"region":"ET","ci_status_code":"C","location":"44","location_desc":"COLUMBUS, MS","county_code_state":"MS","county_code":"087","insp_level_id":"1","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":"N","pen_cen_match":null,"final_status_date":"2024-10-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1080931","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2024-10-25 21:40:00","snet_input_date":"2024-10-24 00:00:00","source_office":"2MSS002","mcmis_add_date":"2024-10-25 21:40:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:01.000000Z","updated_at":"2025-03-17T20:43:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11366157,"change_date":"2024-10-25 21:40:00","inspection_id":"83001411","insp_unit_id":"203590523","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"362791","insp_unit_license":"2893696","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEDV0LDMA0112","insp_unit_decal":"Y","insp_unit_decal_number":"34573833","created_at":"2025-03-17T23:40:42.000000Z","updated_at":"2025-03-17T23:40:42.000000Z"},{"id":11366158,"change_date":"2024-10-25 21:40:00","inspection_id":"83001411","insp_unit_id":"203590524","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53-10270","insp_unit_license":"A084726","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS2531CA331303","insp_unit_decal":"Y","insp_unit_decal_number":"34573834","created_at":"2025-03-17T23:40:42.000000Z","updated_at":"2025-03-17T23:40:42.000000Z"}]},{"id":7013425,"change_date":"2024-10-22 21:41:00","inspection_id":"82965074","dot_number":"327516","report_state":"MS","report_number":"5019011004","insp_date":"2024-10-21 00:00:00","insp_start_time":"0842","insp_end_time":"0912","registration_date":null,"region":"ET","ci_status_code":"C","location":"38","location_desc":"LAUDERDALE COUNTY","county_code_state":"MS","county_code":"075","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAGINAW PIPE","shipping_paper_number":"716282","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-10-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1080703","transaction_code":"A","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2024-10-22 21:41:00","snet_input_date":"2024-10-22 00:00:00","source_office":"2MSS002","mcmis_add_date":"2024-10-22 21:41:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:17.000000Z","updated_at":"2025-03-17T20:42:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11311942,"change_date":"2024-10-22 21:41:00","inspection_id":"82965074","insp_unit_id":"203522789","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"218524","insp_unit_license":"3454657","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLDR9KSKN2984","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:08.000000Z","updated_at":"2025-03-17T23:40:08.000000Z"},{"id":11311943,"change_date":"2024-10-22 21:41:00","inspection_id":"82965074","insp_unit_id":"203522790","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53-10271","insp_unit_license":"A084188","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS2535CA385607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:08.000000Z","updated_at":"2025-03-17T23:40:08.000000Z"}]},{"id":6688710,"change_date":"2024-09-10 21:39:00","inspection_id":"82619611","dot_number":"327516","report_state":"AL","report_number":"MLCV009897","insp_date":"2024-09-09 00:00:00","insp_start_time":"0445","insp_end_time":"0515","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I 65 S@HOOVER","county_code_state":"AL","county_code":"073","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"53270","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"136000","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":"1022329","transaction_code":"A","transaction_date":"2024-09-09 00:00:00","upload_date":"2024-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2024-09-10 21:39:00","snet_input_date":"2024-09-09 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-09-10 21:39:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"PO BOX 8","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:39.000000Z","updated_at":"2025-03-17T20:35:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10784756,"change_date":"2024-09-10 21:39:00","inspection_id":"82619611","insp_unit_id":"202844005","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"362791","insp_unit_license":"2893696","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEDV0LDMA0112","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:38.000000Z","updated_at":"2025-03-17T23:34:38.000000Z"},{"id":10784757,"change_date":"2024-09-10 21:39:00","inspection_id":"82619611","insp_unit_id":"202844006","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAGT","insp_unit_company":"53-10270","insp_unit_license":"A084726","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1M9BA402661435202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:38.000000Z","updated_at":"2025-03-17T23:34:38.000000Z"}]},{"id":6071028,"change_date":"2024-06-25 21:42:00","inspection_id":"81959048","dot_number":"327516","report_state":"AL","report_number":"BWJW007988","insp_date":"2024-06-25 00:00:00","insp_start_time":"0520","insp_end_time":"0540","registration_date":null,"region":"CT","ci_status_code":"C","location":"S271","location_desc":"ROADSIDE","county_code_state":"AL","county_code":"101","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAGINAW STEEL","shipping_paper_number":"709073","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-06-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1011000","transaction_code":"A","transaction_date":"2024-06-25 00:00:00","upload_date":"2024-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2024-06-25 21:42:00","snet_input_date":"2024-06-25 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-06-25 21:42:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"PO BOX 8","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:00.000000Z","updated_at":"2025-03-17T20:23:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9778045,"change_date":"2024-06-25 21:42:00","inspection_id":"81959048","insp_unit_id":"201577394","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"362791","insp_unit_license":"2893696","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEDV0LDMA0112","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:16.000000Z","updated_at":"2025-03-17T23:24:16.000000Z"},{"id":9778046,"change_date":"2024-06-25 21:42:00","inspection_id":"81959048","insp_unit_id":"201577395","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53-10270","insp_unit_license":"A084726","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS2531CA331303","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:16.000000Z","updated_at":"2025-03-17T23:24:16.000000Z"}]},{"id":5740206,"change_date":"2024-05-22 21:40:00","inspection_id":"81600450","dot_number":"327516","report_state":"AL","report_number":"L266000155","insp_date":"2024-05-14 00:00:00","insp_start_time":"1200","insp_end_time":"1310","registration_date":"2024-05-22 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"INTERSTATE","county_code_state":"AL","county_code":"073","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAGINAW PIPE COMPANY 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-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","viol_total":"8","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1005051","transaction_code":"C","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2024-05-14 21:41:00","snet_input_date":"2024-05-14 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-05-14 21:41:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"PO BOX 8","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:38.000000Z","updated_at":"2025-03-17T20:16:38.000000Z","inspection_violations":[{"id":8885187,"change_date":"2024-05-22 21:40:00","inspection_id":"81600450","insp_violation_id":"259669488","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:01.000000Z","updated_at":"2025-03-17T21:49:01.000000Z","normalized_code":"38323A2"},{"id":8885188,"change_date":"2024-05-22 21:40:00","inspection_id":"81600450","insp_violation_id":"259669489","seq_no":"2","part_no":"391","part_no_section":"41(a)","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-17T21:49:01.000000Z","updated_at":"2025-03-17T21:49:01.000000Z","normalized_code":"39141A"},{"id":8885189,"change_date":"2024-05-22 21:40:00","inspection_id":"81600450","insp_violation_id":"259669490","seq_no":"3","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"201033748","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:01.000000Z","updated_at":"2025-03-17T21:49:01.000000Z","normalized_code":"39343"},{"id":8885190,"change_date":"2024-05-22 21:40:00","inspection_id":"81600450","insp_violation_id":"259669491","seq_no":"4","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"201033748","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:01.000000Z","updated_at":"2025-03-17T21:49:01.000000Z","normalized_code":"39021TA"},{"id":8885191,"change_date":"2024-05-22 21:40:00","inspection_id":"81600450","insp_violation_id":"259669492","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201033748","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:01.000000Z","updated_at":"2025-03-17T21:49:01.000000Z","normalized_code":"39617C"},{"id":8885192,"change_date":"2024-05-22 21:40:00","inspection_id":"81600450","insp_violation_id":"259669493","seq_no":"6","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201033748","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:01.000000Z","updated_at":"2025-03-17T21:49:01.000000Z","normalized_code":"39395A"},{"id":8885193,"change_date":"2024-05-22 21:40:00","inspection_id":"81600450","insp_violation_id":"259669494","seq_no":"7","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"201033748","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:01.000000Z","updated_at":"2025-03-17T21:49:01.000000Z","normalized_code":"39395F"},{"id":8885194,"change_date":"2024-05-22 21:40:00","inspection_id":"81600450","insp_violation_id":"259669495","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"201033749","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:01.000000Z","updated_at":"2025-03-17T21:49:01.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9245420,"change_date":"2024-05-22 21:40:00","inspection_id":"81600450","insp_unit_id":"201033748","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"WDV290","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"3C6UR5CL7KG587667","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:03.000000Z","updated_at":"2025-03-17T23:19:03.000000Z"},{"id":9245421,"change_date":"2024-05-22 21:40:00","inspection_id":"81600450","insp_unit_id":"201033749","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"58AB5AT","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"5FWFP3225NR029379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:03.000000Z","updated_at":"2025-03-17T23:19:03.000000Z"}]},{"id":5542875,"change_date":"2024-04-30 21:41:00","inspection_id":"81385810","dot_number":"327516","report_state":"MS","report_number":"2018010618","insp_date":"2024-04-16 00:00:00","insp_start_time":"1039","insp_end_time":"1108","registration_date":"2024-04-26 00:00:00","region":"CT","ci_status_code":"C","location":"2","location_desc":"CORINTH SCALES N\/B","county_code_state":"MS","county_code":"003","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAGINAW PIPE","shipping_paper_number":"704380","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-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1065520","transaction_code":"C","transaction_date":"2024-04-16 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2024-04-18 21:40:00","snet_input_date":"2024-04-17 00:00:00","source_office":"2MSS002","mcmis_add_date":"2024-04-18 21:40:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:43.000000Z","updated_at":"2025-03-17T20:12:43.000000Z","inspection_violations":[{"id":8564878,"change_date":"2024-04-30 21:41:00","inspection_id":"81385810","insp_violation_id":"259222327","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200648474","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:31.000000Z","updated_at":"2025-03-17T21:47:31.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":8928472,"change_date":"2024-04-30 21:41:00","inspection_id":"81385810","insp_unit_id":"200648474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"364238","insp_unit_license":"2894396","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLDR6LDMC7967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:04.000000Z","updated_at":"2025-03-17T23:16:04.000000Z"},{"id":8928473,"change_date":"2024-04-30 21:41:00","inspection_id":"81385810","insp_unit_id":"200648475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"531026A","insp_unit_license":"58AB3NX","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS25346A971302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:04.000000Z","updated_at":"2025-03-17T23:16:04.000000Z"}]},{"id":5134450,"change_date":"2024-03-15 21:40:00","inspection_id":"80940236","dot_number":"327516","report_state":"AL","report_number":"DWMC006592","insp_date":"2024-02-26 00:00:00","insp_start_time":"0730","insp_end_time":"0758","registration_date":"2024-03-15 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"101","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"701510","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":"2024-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"993471","transaction_code":"C","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2024-02-26 21:42:00","snet_input_date":"2024-02-26 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-02-26 21:42:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"PO BOX 8","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137-0008","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:14.000000Z","updated_at":"2025-03-17T20:04:14.000000Z","inspection_violations":[{"id":7917362,"change_date":"2024-03-15 21:40:00","inspection_id":"80940236","insp_violation_id":"258406721","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199933481","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:14.000000Z","updated_at":"2025-03-17T21:44:14.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":8266444,"change_date":"2024-03-15 21:40:00","inspection_id":"80940236","insp_unit_id":"199933481","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"302186","insp_unit_license":"2850650","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLDR2LDLU4346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:55.000000Z","updated_at":"2025-03-17T23:09:55.000000Z"},{"id":8266445,"change_date":"2024-03-15 21:40:00","inspection_id":"80940236","insp_unit_id":"199933482","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53-10267","insp_unit_license":"58AB3NW","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS25326A971301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:55.000000Z","updated_at":"2025-03-17T23:09:55.000000Z"}]},{"id":5036521,"change_date":"2024-02-13 21:41:00","inspection_id":"80833277","dot_number":"327516","report_state":"GA","report_number":"1387000023","insp_date":"2024-02-05 00:00:00","insp_start_time":"1125","insp_end_time":"1145","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NORCROSS GA","county_code_state":"GA","county_code":"135","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SAGINAW","shipping_paper_number":"692891RC","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-02-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","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":"238042","transaction_code":"A","transaction_date":"2024-02-13 00:00:00","upload_date":"2024-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2024-02-13 21:41:00","snet_input_date":"2024-02-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-13 21:41:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:25.000000Z","updated_at":"2025-03-17T20:02:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8107174,"change_date":"2024-02-13 21:41:00","inspection_id":"80833277","insp_unit_id":"199392666","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"364238","insp_unit_license":"2894396","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLDR6LDMC7967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:28.000000Z","updated_at":"2025-03-17T23:08:28.000000Z"},{"id":8107175,"change_date":"2024-02-13 21:41:00","inspection_id":"80833277","insp_unit_id":"199392667","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"5310268","insp_unit_license":"58AB3NX","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS25346A971302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:28.000000Z","updated_at":"2025-03-17T23:08:28.000000Z"}]},{"id":4348822,"change_date":"2023-11-03 21:40:00","inspection_id":"80078984","dot_number":"327516","report_state":"AL","report_number":"JPCP008928","insp_date":"2023-11-03 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"021","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAGINAW PIPE COMPANY INC","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":"N","pen_cen_match":"I","final_status_date":"2023-11-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"981387","transaction_code":"A","transaction_date":"2023-11-03 00:00:00","upload_date":"2023-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2023-11-03 21:40:00","snet_input_date":"2023-11-03 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-11-03 21:40:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"PO BOX 8","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137-0008","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:07.000000Z","updated_at":"2025-03-17T19:49:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6993655,"change_date":"2023-11-03 21:40:00","inspection_id":"80078984","insp_unit_id":"197893750","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"230137","insp_unit_license":"3407584","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZTZR6RN257301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:42.000000Z","updated_at":"2025-03-17T22:58:42.000000Z"},{"id":6993656,"change_date":"2023-11-03 21:40:00","inspection_id":"80078984","insp_unit_id":"197893751","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53-10272","insp_unit_license":"58AB3NU","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS2530DA488502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:42.000000Z","updated_at":"2025-03-17T22:58:42.000000Z"}]},{"id":4213220,"change_date":"2023-10-20 21:40:00","inspection_id":"79929194","dot_number":"327516","report_state":"AL","report_number":"JSBH007390","insp_date":"2023-10-16 00:00:00","insp_start_time":"1055","insp_end_time":"1135","registration_date":"2023-10-20 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAGINAW PIPE","shipping_paper_number":"693490","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-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"977957","transaction_code":"C","transaction_date":"2023-10-16 00:00:00","upload_date":"2023-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2023-10-17 21:41:00","snet_input_date":"2023-10-17 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-10-17 21:41:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"PO BOX 8","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137-0008","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:16.000000Z","updated_at":"2025-03-17T19:46:16.000000Z","inspection_violations":[{"id":6523700,"change_date":"2023-10-20 21:40:00","inspection_id":"79929194","insp_violation_id":"255956063","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197660550","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:28.000000Z","updated_at":"2025-03-17T21:37:28.000000Z","normalized_code":"3939A"},{"id":6523701,"change_date":"2023-10-20 21:40:00","inspection_id":"79929194","insp_violation_id":"255956064","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197660550","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:28.000000Z","updated_at":"2025-03-17T21:37:28.000000Z","normalized_code":"39311"},{"id":6523702,"change_date":"2023-10-20 21:40:00","inspection_id":"79929194","insp_violation_id":"255956065","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197660550","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:28.000000Z","updated_at":"2025-03-17T21:37:28.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6775242,"change_date":"2023-10-20 21:40:00","inspection_id":"79929194","insp_unit_id":"197660550","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2257","insp_unit_license":"1191553","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1FUJA6CG23LK71327","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:48.000000Z","updated_at":"2025-03-17T22:56:48.000000Z"},{"id":6775243,"change_date":"2023-10-20 21:40:00","inspection_id":"79929194","insp_unit_id":"197660551","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"80-1021","insp_unit_license":"58AB3P0","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"13N4482C741519781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:48.000000Z","updated_at":"2025-03-17T22:56:48.000000Z"}]},{"id":3988006,"change_date":"2023-09-17 21:31:00","inspection_id":"79679450","dot_number":"327516","report_state":"AL","report_number":"BSCV002450","insp_date":"2023-09-15 00:00:00","insp_start_time":"0510","insp_end_time":"0540","registration_date":null,"region":"CT","ci_status_code":"C","location":"58","location_desc":"INTERSTATE","county_code_state":"AL","county_code":"117","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAGINAW PIPE","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-09-17 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","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":"972891","transaction_code":"A","transaction_date":"2023-09-15 00:00:00","upload_date":"2023-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2023-09-17 21:31:00","snet_input_date":"2023-09-16 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-09-17 21:31:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"PO BOX 8","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137-0008","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:37.000000Z","updated_at":"2025-03-17T19:41:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6412565,"change_date":"2023-09-17 21:31:00","inspection_id":"79679450","insp_unit_id":"197089275","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLAR","insp_unit_company":"531026","insp_unit_license":"58AB3P2","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1CD2L53277A009387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:51.000000Z","updated_at":"2025-03-17T22:53:51.000000Z"},{"id":6412566,"change_date":"2023-09-17 21:31:00","inspection_id":"79679450","insp_unit_id":"197089276","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"230136","insp_unit_license":"3407832","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZTZR4RN257300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:51.000000Z","updated_at":"2025-03-17T22:53:51.000000Z"}]},{"id":3864806,"change_date":"2023-08-31 21:42:00","inspection_id":"79542406","dot_number":"327516","report_state":"AL","report_number":"1836001458","insp_date":"2023-08-30 00:00:00","insp_start_time":"1110","insp_end_time":"1145","registration_date":"2023-08-31 00:00:00","region":"CT","ci_status_code":"C","location":"28","location_desc":"ROADSIDE","county_code_state":"AL","county_code":"049","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAGINAW PIPE COMPANY INC","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-08-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"108220","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":"970024","transaction_code":"C","transaction_date":"2023-08-30 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2023-08-30 21:44:00","snet_input_date":"2023-08-30 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-08-30 21:44:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"PO BOX 8","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137-0008","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:21.000000Z","updated_at":"2025-03-17T19:39:21.000000Z","inspection_violations":[{"id":5969518,"change_date":"2023-08-31 21:42:00","inspection_id":"79542406","insp_violation_id":"255012720","seq_no":"1","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"196835510","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"393205C"},{"id":5969519,"change_date":"2023-08-31 21:42:00","inspection_id":"79542406","insp_violation_id":"255012721","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196835511","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6213334,"change_date":"2023-08-31 21:42:00","inspection_id":"79542406","insp_unit_id":"196835510","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"302186","insp_unit_license":"2850650","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLDR2LDLU4346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:12.000000Z","updated_at":"2025-03-17T22:52:12.000000Z"},{"id":6213335,"change_date":"2023-08-31 21:42:00","inspection_id":"79542406","insp_unit_id":"196835511","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLAM","insp_unit_company":"53-1025","insp_unit_license":"58AB3P3","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1CD2L53257A009386","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:12.000000Z","updated_at":"2025-03-17T22:52:12.000000Z"}]},{"id":3731988,"change_date":"2023-08-14 21:41:00","inspection_id":"79393973","dot_number":"327516","report_state":"MS","report_number":"5007012200","insp_date":"2023-08-11 00:00:00","insp_start_time":"0814","insp_end_time":"0838","registration_date":null,"region":"CT","ci_status_code":"C","location":"38","location_desc":"KEWANEE N99","county_code_state":"MS","county_code":"075","insp_level_id":"2","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":"2023-08-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1041362","transaction_code":"A","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2023-08-14 21:41:00","snet_input_date":"2023-08-14 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-08-14 21:41:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:31.000000Z","updated_at":"2025-03-17T19:36:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6000282,"change_date":"2023-08-14 21:41:00","inspection_id":"79393973","insp_unit_id":"196506096","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"364238","insp_unit_license":"2894396","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLKDR6LDMC796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:26.000000Z","updated_at":"2025-03-17T22:50:26.000000Z"}]},{"id":3400778,"change_date":"2023-06-29 21:42:00","inspection_id":"79022586","dot_number":"327516","report_state":"MS","report_number":"1027099635","insp_date":"2023-06-20 00:00:00","insp_start_time":"0836","insp_end_time":"0846","registration_date":null,"region":"CT","ci_status_code":"C","location":"44","location_desc":"LOWNDES COUNTY","county_code_state":"MS","county_code":"087","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAGINAW","shipping_paper_number":"685674","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1032884","transaction_code":"A","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2023-06-29 21:42:00","snet_input_date":"2023-06-29 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-06-29 21:42:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"1980 HIGHWAY 31 SOUTH","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:32.000000Z","updated_at":"2025-03-17T19:30:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5467484,"change_date":"2023-06-29 21:42:00","inspection_id":"79022586","insp_unit_id":"195754561","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"302186","insp_unit_license":"2850650","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLDR2LDLU4346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:07.000000Z","updated_at":"2025-03-17T22:46:07.000000Z"},{"id":5467485,"change_date":"2023-06-29 21:42:00","inspection_id":"79022586","insp_unit_id":"195754562","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53-10267","insp_unit_license":"58AB3NW","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS25326A971301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:07.000000Z","updated_at":"2025-03-17T22:46:07.000000Z"}]},{"id":2672858,"change_date":"2023-03-28 21:40:00","inspection_id":"78198853","dot_number":"327516","report_state":"AL","report_number":"RHCV001681","insp_date":"2023-03-28 00:00:00","insp_start_time":"1240","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"127","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"947435","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2023-03-28 21:40:00","snet_input_date":"2023-03-28 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-03-28 21:40:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"PO BOX 8","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137-0008","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:53.000000Z","updated_at":"2025-03-17T19:15:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4303259,"change_date":"2023-03-28 21:40:00","inspection_id":"78198853","insp_unit_id":"194089893","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8671686","insp_unit_license":"1191558","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"3AKJGEDV9ESFJ5720","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:54.000000Z","updated_at":"2025-03-17T22:36:54.000000Z"},{"id":4303260,"change_date":"2023-03-28 21:40:00","inspection_id":"78198853","insp_unit_id":"194089894","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLAR","insp_unit_company":"53-1026","insp_unit_license":"58AB3P2","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1CD2L53277A009387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:54.000000Z","updated_at":"2025-03-17T22:36:54.000000Z"}]},{"id":2474665,"change_date":"2023-03-10 21:40:00","inspection_id":"77973815","dot_number":"327516","report_state":"AL","report_number":"WBMC002906","insp_date":"2023-03-01 00:00:00","insp_start_time":"0956","insp_end_time":"1016","registration_date":"2023-03-10 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"RS","county_code_state":"AL","county_code":"073","insp_level_id":"2","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-03-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120366","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":"944077","transaction_code":"C","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2023-03-01 21:41:00","snet_input_date":"2023-03-01 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-03-01 21:41:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"PO BOX 8","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137-0008","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:10.000000Z","updated_at":"2025-03-17T19:12:10.000000Z","inspection_violations":[{"id":3809046,"change_date":"2023-03-10 21:40:00","inspection_id":"77973815","insp_violation_id":"251589084","seq_no":"1","part_no":"393","part_no_section":"60(e)","insp_viol_unit":"1","insp_unit_id":"193807676","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:54.000000Z","updated_at":"2025-03-17T21:24:54.000000Z","normalized_code":"39360E"}],"inspection_per_units":[{"id":3982402,"change_date":"2023-03-10 21:40:00","inspection_id":"77973815","insp_unit_id":"193807676","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"362791","insp_unit_license":"2893696","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEDV0LDMA0112","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:31.000000Z","updated_at":"2025-03-17T22:34:31.000000Z"},{"id":3982403,"change_date":"2023-03-10 21:40:00","inspection_id":"77973815","insp_unit_id":"193807677","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"58AB3P1","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"13N84126921515280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:31.000000Z","updated_at":"2025-03-17T22:34:31.000000Z"}]},{"id":2263211,"change_date":"2023-02-06 21:40:00","inspection_id":"77733015","dot_number":"327516","report_state":"AL","report_number":"MOCV003586","insp_date":"2023-01-31 00:00:00","insp_start_time":"0730","insp_end_time":"0757","registration_date":"2023-02-06 00:00:00","region":"CT","ci_status_code":"C","location":"61","location_desc":"ROADSIDE","county_code_state":"AL","county_code":"121","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"676599RC","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-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"126220","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"940459","transaction_code":"C","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2023-01-31 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-01-31 21:42:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"PO BOX 8","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137-0008","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":[{"id":3492953,"change_date":"2023-02-06 21:40:00","inspection_id":"77733015","insp_violation_id":"250961586","seq_no":"1","part_no":"393","part_no_section":"45(a)","insp_viol_unit":"1","insp_unit_id":"193238112","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39345A"},{"id":3492954,"change_date":"2023-02-06 21:40:00","inspection_id":"77733015","insp_violation_id":"250961587","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193238113","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3642761,"change_date":"2023-02-06 21:40:00","inspection_id":"77733015","insp_unit_id":"193238112","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"218524","insp_unit_license":"2750326","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLDR9KSKN2984","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:06.000000Z","updated_at":"2025-03-17T22:32:06.000000Z"},{"id":3642762,"change_date":"2023-02-06 21:40:00","inspection_id":"77733015","insp_unit_id":"193238113","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"53-10271","insp_unit_license":"A084188","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS2535CA385607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:06.000000Z","updated_at":"2025-03-17T22:32:06.000000Z"}]},{"id":687055,"change_date":"2022-06-24 21:39:00","inspection_id":"75911201","dot_number":"327516","report_state":"MS","report_number":"U066008228","insp_date":"2022-06-24 00:00:00","insp_start_time":"0750","insp_end_time":"0813","registration_date":null,"region":"CT","ci_status_code":"C","location":"121","location_desc":"RANKIN COUNTY","county_code_state":"MS","county_code":"121","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAGINAW PIPE CO., INC.","shipping_paper_number":"664309","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-06-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"974353","transaction_code":"A","transaction_date":"2022-06-24 00:00:00","upload_date":"2022-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00327516","upload_search_indicator":null,"census_search_date":"2022-06-24 21:39:00","snet_input_date":"2022-06-24 00:00:00","source_office":"2MSS002","mcmis_add_date":"2022-06-24 21:39:00","insp_carrier_name":"SAGINAW PIPE COMPANY INC","insp_carrier_street":"PO BOX 8","insp_carrier_city":"SAGINAW","insp_carrier_state":"AL","insp_carrier_zip_code":"35137-0008","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:49.000000Z","updated_at":"2025-03-17T18:39:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1103648,"change_date":"2022-06-24 21:39:00","inspection_id":"75911201","insp_unit_id":"189446403","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"364238","insp_unit_license":"2894396","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLDR6LDMC7967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:59.000000Z","updated_at":"2025-03-17T22:14:59.000000Z"},{"id":1103649,"change_date":"2022-06-24 21:39:00","inspection_id":"75911201","insp_unit_id":"189446404","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5310271","insp_unit_license":"A084188","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1UYFS2535CA385607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:59.000000Z","updated_at":"2025-03-17T22:14:59.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/327516\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/327516\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/327516\/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\/327516\/inspections","per_page":100,"prev_page_url":null,"to":30,"total":30}