{"current_page":1,"data":[{"id":11973769,"change_date":"2026-05-20 21:41:00","inspection_id":"87910706","dot_number":"786455","report_state":"OK","report_number":"C200000910","insp_date":"2026-05-20 00:00:00","insp_start_time":"0903","insp_end_time":"0930","registration_date":null,"region":"CS","ci_status_code":"C","location":"001061","location_desc":"OK","county_code_state":"OK","county_code":"123","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"3369488","transaction_code":"A","transaction_date":"2026-05-20 00:00:00","upload_date":"2026-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2026-05-20 21:41:00","snet_input_date":"2026-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-20 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-23T09:42:56.000000Z","updated_at":"2026-06-01T09:30:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20817709,"change_date":"2026-05-20 21:41:00","inspection_id":"87910706","insp_unit_id":"213666031","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"208","insp_unit_license":"734579","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKZL40X7TJ196700","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:28.000000Z","updated_at":"2026-06-01T09:03:12.000000Z"}]},{"id":11884009,"change_date":"2026-06-29 21:41:00","inspection_id":"87821787","dot_number":"786455","report_state":"OK","report_number":"Z600212238","insp_date":"2026-05-12 00:00:00","insp_start_time":"0808","insp_end_time":"0844","registration_date":null,"region":"CS","ci_status_code":"C","location":"09040","location_desc":"OK","county_code_state":"OK","county_code":"017","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MC","shipping_paper_number":"87265","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-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"3304743","transaction_code":"C","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2026-05-12 21:39:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-12 21:39:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-14T12:39:27.000000Z","updated_at":"2026-07-10T09:30:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20662659,"change_date":"2026-06-29 21:41:00","inspection_id":"87821787","insp_unit_id":"214346117","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"734562","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV3HLJA3321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:27.000000Z","updated_at":"2026-07-10T09:01:12.000000Z"}]},{"id":11857682,"change_date":"2026-06-29 21:42:00","inspection_id":"87794034","dot_number":"786455","report_state":"OK","report_number":"C200000866","insp_date":"2026-05-08 00:00:00","insp_start_time":"1107","insp_end_time":"1125","registration_date":null,"region":"CS","ci_status_code":"C","location":"63400","location_desc":"OK","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"3286436","transaction_code":"C","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2026-05-08 21:38:00","snet_input_date":"2026-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-08 21:38:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-11T09:40:01.000000Z","updated_at":"2026-07-10T09:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20619738,"change_date":"2026-06-29 21:42:00","inspection_id":"87794034","insp_unit_id":"214350580","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"723124","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC3RM039916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-11T09:16:24.000000Z","updated_at":"2026-07-10T09:01:08.000000Z"}]},{"id":11789691,"change_date":"2026-06-29 21:42:00","inspection_id":"87721440","dot_number":"786455","report_state":"OK","report_number":"C200000849","insp_date":"2026-04-29 00:00:00","insp_start_time":"2300","insp_end_time":"2300","registration_date":null,"region":"CS","ci_status_code":"C","location":"63400","location_desc":"OK","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-04-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3237103","transaction_code":"C","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2026-04-30 21:40:00","snet_input_date":"2026-04-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-30 21:40:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-03T09:40:50.000000Z","updated_at":"2026-07-10T09:30:05.000000Z","inspection_violations":[{"id":20502844,"change_date":"2026-06-29 21:42:00","inspection_id":"87721440","insp_violation_id":"275192270","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-03T10:01:36.000000Z","updated_at":"2026-07-10T09:42:02.000000Z","normalized_code":"3922SLLEWA2"},{"id":20502845,"change_date":"2026-06-29 21:42:00","inspection_id":"87721440","insp_violation_id":"275192271","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-03T10:01:36.000000Z","updated_at":"2026-07-10T09:42:02.000000Z","normalized_code":"3922SLLEWG1"}],"inspection_per_units":[{"id":20508837,"change_date":"2026-06-29 21:42:00","inspection_id":"87721440","insp_unit_id":"214347792","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"734579","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKZL40X7TJ196700","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:39.000000Z","updated_at":"2026-07-10T09:00:59.000000Z"}]},{"id":11618802,"change_date":"2026-04-28 21:39:00","inspection_id":"87546771","dot_number":"786455","report_state":"OK","report_number":"C200000815","insp_date":"2026-04-10 00:00:00","insp_start_time":"0744","insp_end_time":"0830","registration_date":"2026-04-22 00:00:00","region":"CT","ci_status_code":"C","location":"63400","location_desc":"I40 AND MCLOUD RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"441082","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"817763","transaction_code":"C","transaction_date":"2026-04-10 00:00:00","upload_date":"2026-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2026-04-10 21:38:00","snet_input_date":"2026-04-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-04-10 21:38:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-13T10:09:36.000000Z","updated_at":"2026-05-09T09:30:09.000000Z","inspection_violations":[{"id":20161387,"change_date":"2026-04-28 21:39:00","inspection_id":"87546771","insp_violation_id":"273906633","seq_no":"1","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"213269471","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-12T12:11:37.000000Z","updated_at":"2026-05-09T09:42:05.000000Z","normalized_code":"39345DBAAL"}],"inspection_per_units":[{"id":20207966,"change_date":"2026-04-28 21:39:00","inspection_id":"87546771","insp_unit_id":"213269471","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREI","insp_unit_company":"112","insp_unit_license":"3GP683","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGEDV0ESFJ5704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-13T10:01:47.000000Z","updated_at":"2026-05-09T09:02:12.000000Z"},{"id":20207967,"change_date":"2026-04-28 21:39:00","inspection_id":"87546771","insp_unit_id":"213269472","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"XPLO","insp_unit_company":"503","insp_unit_license":"DN1459","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1C93440285S770138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-13T10:01:47.000000Z","updated_at":"2026-05-09T09:02:12.000000Z"}]},{"id":11542969,"change_date":"2026-04-28 21:39:00","inspection_id":"87465449","dot_number":"786455","report_state":"OK","report_number":"H600154632","insp_date":"2026-03-31 00:00:00","insp_start_time":"1513","insp_end_time":"1543","registration_date":"2026-04-22 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ HARDESTY RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"816982","transaction_code":"C","transaction_date":"2026-03-31 00:00:00","upload_date":"2026-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2026-04-01 21:40:00","snet_input_date":"2026-03-31 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-04-01 21:40:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-04T09:43:31.000000Z","updated_at":"2026-05-09T09:30:04.000000Z","inspection_violations":[{"id":19500495,"change_date":"2026-04-28 21:39:00","inspection_id":"87465449","insp_violation_id":"273906228","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"213269172","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:19.000000Z","updated_at":"2026-05-09T09:42:01.000000Z","normalized_code":"39617CPI"},{"id":19500496,"change_date":"2026-04-28 21:39:00","inspection_id":"87465449","insp_violation_id":"273906229","seq_no":"2","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"213269172","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:19.000000Z","updated_at":"2026-05-09T09:42:01.000000Z","normalized_code":"3965BL"},{"id":19500497,"change_date":"2026-04-28 21:39:00","inspection_id":"87465449","insp_violation_id":"273906230","seq_no":"3","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"213269172","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:19.000000Z","updated_at":"2026-05-09T09:42:01.000000Z","normalized_code":"39311A1LIL"},{"id":19500498,"change_date":"2026-04-28 21:39:00","inspection_id":"87465449","insp_violation_id":"273906231","seq_no":"4","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"213269172","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:19.000000Z","updated_at":"2026-05-09T09:42:01.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":19779150,"change_date":"2026-04-28 21:39:00","inspection_id":"87465449","insp_unit_id":"213269172","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"17","insp_unit_license":"734566","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AG11C14M008813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:45.000000Z","updated_at":"2026-05-09T09:02:08.000000Z"}]},{"id":11417907,"change_date":"2026-03-19 21:39:00","inspection_id":"87333637","dot_number":"786455","report_state":"OK","report_number":"N914154985","insp_date":"2026-03-19 00:00:00","insp_start_time":"0905","insp_end_time":"0925","registration_date":null,"region":"CT","ci_status_code":"C","location":"009003","location_desc":"SH3 WB BANNER RD","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"000","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"815563","transaction_code":"A","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2026-03-19 21:39:00","snet_input_date":"2026-03-19 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-03-19 21:39:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-22T09:50:53.000000Z","updated_at":"2026-03-30T09:32:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19558474,"change_date":"2026-03-19 21:39:00","inspection_id":"87333637","insp_unit_id":"212221239","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"202","insp_unit_license":"734562","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV3HLJA3321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-22T09:32:31.000000Z","updated_at":"2026-03-30T09:06:40.000000Z"}]},{"id":11266340,"change_date":"2026-03-02 21:38:00","inspection_id":"87180406","dot_number":"786455","report_state":"OK","report_number":"V600172971","insp_date":"2026-02-26 00:00:00","insp_start_time":"1255","insp_end_time":"1325","registration_date":null,"region":"CT","ci_status_code":"C","location":"04419","location_desc":"TURNER TURNPIKE","county_code_state":"OK","county_code":"037","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","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":"2026-03-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"152350","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":"813391","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2026-03-02 21:38:00","snet_input_date":"2026-02-26 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-03-02 21:38:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-05T10:39:01.000000Z","updated_at":"2026-03-13T09:31:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19265873,"change_date":"2026-03-02 21:38:00","inspection_id":"87180406","insp_unit_id":"211919113","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"113","insp_unit_license":"3MB739","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKZD49X8KJ250204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:44.000000Z","updated_at":"2026-03-13T09:07:02.000000Z"},{"id":19265874,"change_date":"2026-03-02 21:38:00","inspection_id":"87180406","insp_unit_id":"211919114","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CNST","insp_unit_company":null,"insp_unit_license":"AT3279","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU344048FS000622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:44.000000Z","updated_at":"2026-03-13T09:07:03.000000Z"}]},{"id":11266543,"change_date":"2026-03-27 21:40:00","inspection_id":"87180615","dot_number":"786455","report_state":"OK","report_number":"C200000719","insp_date":"2026-02-26 00:00:00","insp_start_time":"1057","insp_end_time":"1130","registration_date":"2026-03-26 00:00:00","region":"CT","ci_status_code":"C","location":"63400","location_desc":"I40 AND MCLOUD RD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"73380","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":"2026-03-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"5","oos_total":"0","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"813425","transaction_code":"C","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2026-03-02 21:38:00","snet_input_date":"2026-02-26 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-03-02 21:38:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-05T10:39:01.000000Z","updated_at":"2026-04-07T09:33:19.000000Z","inspection_violations":[{"id":19430031,"change_date":"2026-03-27 21:40:00","inspection_id":"87180615","insp_violation_id":"272689581","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:29.000000Z","updated_at":"2026-04-07T09:48:24.000000Z","normalized_code":"3922SLLS1"},{"id":19430032,"change_date":"2026-03-27 21:40:00","inspection_id":"87180615","insp_violation_id":"272689582","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"P174778","created_at":"2026-03-30T10:20:29.000000Z","updated_at":"2026-04-07T09:48:24.000000Z","normalized_code":"3922SLLEWA3"},{"id":19430033,"change_date":"2026-03-27 21:40:00","inspection_id":"87180615","insp_violation_id":"272689583","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWG2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:29.000000Z","updated_at":"2026-04-07T09:48:24.000000Z","normalized_code":"3922SLLEWG2"},{"id":19430034,"change_date":"2026-03-27 21:40:00","inspection_id":"87180615","insp_violation_id":"272689584","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:29.000000Z","updated_at":"2026-04-07T09:48:24.000000Z","normalized_code":"3922SLLEWA1"},{"id":19430035,"change_date":"2026-03-27 21:40:00","inspection_id":"87180615","insp_violation_id":"272689585","seq_no":"5","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:29.000000Z","updated_at":"2026-04-07T09:48:24.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":19698859,"change_date":"2026-03-27 21:40:00","inspection_id":"87180615","insp_unit_id":"212381864","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"202","insp_unit_license":"734562","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV3HLJA3321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:21.000000Z","updated_at":"2026-04-07T09:08:00.000000Z"}]},{"id":11149623,"change_date":"2026-03-02 21:38:00","inspection_id":"87064158","dot_number":"786455","report_state":"OK","report_number":"PE12007231","insp_date":"2026-02-17 00:00:00","insp_start_time":"1155","insp_end_time":"1352","registration_date":"2026-02-26 00:00:00","region":"CT","ci_status_code":"C","location":"68040","location_desc":"SEQUOYAH POE","county_code_state":"OK","county_code":"135","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"TBCNXO","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"812379","transaction_code":"C","transaction_date":"2026-02-17 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2026-02-17 21:39:00","snet_input_date":"2026-02-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-02-17 21:39:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-20T10:37:49.000000Z","updated_at":"2026-03-13T09:32:10.000000Z","inspection_violations":[{"id":18928022,"change_date":"2026-03-02 21:38:00","inspection_id":"87064158","insp_violation_id":"272137891","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"211919260","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:46.000000Z","updated_at":"2026-03-13T09:46:15.000000Z","normalized_code":"39345DB"},{"id":18928023,"change_date":"2026-03-02 21:38:00","inspection_id":"87064158","insp_violation_id":"272137892","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"211919260","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-05T10:56:46.000000Z","updated_at":"2026-03-13T09:46:15.000000Z","normalized_code":"39345B2BHTD"},{"id":18928024,"change_date":"2026-03-02 21:38:00","inspection_id":"87064158","insp_violation_id":"272137893","seq_no":"3","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"211919260","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:46.000000Z","updated_at":"2026-03-13T09:46:16.000000Z","normalized_code":"3965BL"},{"id":18928025,"change_date":"2026-03-02 21:38:00","inspection_id":"87064158","insp_violation_id":"272137894","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"211919259","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:46.000000Z","updated_at":"2026-03-13T09:46:16.000000Z","normalized_code":"3939ALIL"},{"id":18928026,"change_date":"2026-03-02 21:38:00","inspection_id":"87064158","insp_violation_id":"272137895","seq_no":"5","part_no":"393","part_no_section":"25A-L","insp_viol_unit":"2","insp_unit_id":"211919259","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:46.000000Z","updated_at":"2026-03-13T09:46:16.000000Z","normalized_code":"39325AL"},{"id":18928027,"change_date":"2026-03-02 21:38:00","inspection_id":"87064158","insp_violation_id":"272137896","seq_no":"6","part_no":"393","part_no_section":"47A-BCFSBD","insp_viol_unit":"2","insp_unit_id":"211919259","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:46.000000Z","updated_at":"2026-03-13T09:46:16.000000Z","normalized_code":"39347ABCFSBD"},{"id":18928028,"change_date":"2026-03-02 21:38:00","inspection_id":"87064158","insp_violation_id":"272137897","seq_no":"7","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"2","insp_unit_id":"211919259","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-05T10:56:46.000000Z","updated_at":"2026-03-13T09:46:16.000000Z","normalized_code":"3965BHWSL"},{"id":18928029,"change_date":"2026-03-02 21:38:00","inspection_id":"87064158","insp_violation_id":"272137898","seq_no":"8","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"2","insp_unit_id":"211919259","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:46.000000Z","updated_at":"2026-03-13T09:46:16.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":18928030,"change_date":"2026-03-02 21:38:00","inspection_id":"87064158","insp_violation_id":"272137899","seq_no":"9","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"2","insp_unit_id":"211919259","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:46.000000Z","updated_at":"2026-03-13T09:46:16.000000Z","normalized_code":"393207ASAPPCBLM"}],"inspection_per_units":[{"id":19259383,"change_date":"2026-03-02 21:38:00","inspection_id":"87064158","insp_unit_id":"211919259","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"XPLO","insp_unit_company":"BP503","insp_unit_license":"DN1459","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1C93440285S770138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:40.000000Z","updated_at":"2026-03-13T09:05:39.000000Z"},{"id":19259384,"change_date":"2026-03-02 21:38:00","inspection_id":"87064158","insp_unit_id":"211919260","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"112","insp_unit_license":"3GP683","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGEDV0ESFJ5704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:40.000000Z","updated_at":"2026-03-13T09:05:40.000000Z"}]},{"id":11083458,"change_date":"2026-02-09 21:38:00","inspection_id":"86994747","dot_number":"786455","report_state":"OK","report_number":"C200000665","insp_date":"2026-02-05 00:00:00","insp_start_time":"0751","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 AND 45TH ST","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"811379","transaction_code":"A","transaction_date":"2026-02-05 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2026-02-09 21:38:00","snet_input_date":"2026-02-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-02-09 21:38:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-12T10:36:59.000000Z","updated_at":"2026-02-20T10:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18899447,"change_date":"2026-02-09 21:38:00","inspection_id":"86994747","insp_unit_id":"211518599","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"202","insp_unit_license":"734562","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV3HLJA3321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:37.000000Z","updated_at":"2026-02-20T10:03:47.000000Z"}]},{"id":10610843,"change_date":"2026-01-09 21:38:00","inspection_id":"86750691","dot_number":"786455","report_state":"OK","report_number":"Z600212009","insp_date":"2026-01-09 00:00:00","insp_start_time":"1100","insp_end_time":"1121","registration_date":null,"region":"CT","ci_status_code":"C","location":"14035","location_desc":"I-35 N\/B AND MM112","county_code_state":"OK","county_code":"027","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"809130","transaction_code":"A","transaction_date":"2026-01-09 00:00:00","upload_date":"2026-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2026-01-09 21:38:00","snet_input_date":"2026-01-09 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-01-09 21:38:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-12T10:34:45.000000Z","updated_at":"2026-01-20T10:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17789498,"change_date":"2026-01-09 21:38:00","inspection_id":"86750691","insp_unit_id":"210999822","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"014","insp_unit_license":"733012","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV1LPLG2598","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-12T10:11:46.000000Z","updated_at":"2026-01-20T10:00:48.000000Z"}]},{"id":10576540,"change_date":"2026-01-13 21:39:00","inspection_id":"86714732","dot_number":"786455","report_state":"OK","report_number":"H600154455","insp_date":"2026-01-05 00:00:00","insp_start_time":"0938","insp_end_time":"1038","registration_date":"2026-01-12 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ SH-18 (FARRELL ST)","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"73052","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"7","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"808655","transaction_code":"C","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2026-01-06 21:38:00","snet_input_date":"2026-01-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-01-06 21:38:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-09T10:34:24.000000Z","updated_at":"2026-01-24T10:30:11.000000Z","inspection_violations":[{"id":17881348,"change_date":"2026-01-13 21:39:00","inspection_id":"86714732","insp_violation_id":"271166265","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:41:46.000000Z","updated_at":"2026-01-24T10:30:23.000000Z","normalized_code":"3922SLLEWA2"},{"id":17881349,"change_date":"2026-01-13 21:39:00","inspection_id":"86714732","insp_violation_id":"271166266","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"211051229","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:41:46.000000Z","updated_at":"2026-01-24T10:30:23.000000Z","normalized_code":"39345DB"},{"id":17881350,"change_date":"2026-01-13 21:39:00","inspection_id":"86714732","insp_violation_id":"271166267","seq_no":"3","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"211051229","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:41:46.000000Z","updated_at":"2026-01-24T10:30:23.000000Z","normalized_code":"3965BL"},{"id":17881351,"change_date":"2026-01-13 21:39:00","inspection_id":"86714732","insp_violation_id":"271166268","seq_no":"4","part_no":"393","part_no_section":"209E-SPSLA","insp_viol_unit":"1","insp_unit_id":"211051229","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:41:46.000000Z","updated_at":"2026-01-24T10:30:23.000000Z","normalized_code":"393209ESPSLA"},{"id":17881352,"change_date":"2026-01-13 21:39:00","inspection_id":"86714732","insp_violation_id":"271166269","seq_no":"5","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"211051229","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:41:46.000000Z","updated_at":"2026-01-24T10:30:23.000000Z","normalized_code":"3965BL"},{"id":17881353,"change_date":"2026-01-13 21:39:00","inspection_id":"86714732","insp_violation_id":"271166270","seq_no":"6","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"211051229","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:41:46.000000Z","updated_at":"2026-01-24T10:30:23.000000Z","normalized_code":"39345B2BAIR"},{"id":17881354,"change_date":"2026-01-13 21:39:00","inspection_id":"86714732","insp_violation_id":"271166271","seq_no":"7","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"211051229","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:41:46.000000Z","updated_at":"2026-01-24T10:30:23.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":17829419,"change_date":"2026-01-13 21:39:00","inspection_id":"86714732","insp_unit_id":"211051229","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"203","insp_unit_license":"710635","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2FZHAZCV57AY45939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:32.000000Z","updated_at":"2026-01-24T10:01:37.000000Z"}]},{"id":10552983,"change_date":"2026-01-01 21:33:00","inspection_id":"86689966","dot_number":"786455","report_state":"OK","report_number":"C200000583","insp_date":"2025-12-31 00:00:00","insp_start_time":"1414","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":"63400","location_desc":"I40 AND SH-102","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-01 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","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":"808339","transaction_code":"A","transaction_date":"2025-12-31 00:00:00","upload_date":"2026-01-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2026-01-01 21:33:00","snet_input_date":"2025-12-31 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-01-01 21:33:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-04T10:33:46.000000Z","updated_at":"2026-01-12T10:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17678659,"change_date":"2026-01-01 21:33:00","inspection_id":"86689966","insp_unit_id":"210878298","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":"BP302","insp_unit_license":"2327DI","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"41970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-04T10:04:55.000000Z","updated_at":"2026-01-12T10:00:20.000000Z"},{"id":17678658,"change_date":"2026-01-01 21:33:00","inspection_id":"86689966","insp_unit_id":"210878297","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"109","insp_unit_license":"734560","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJALAV25DN67218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-04T10:04:55.000000Z","updated_at":"2026-01-12T10:00:20.000000Z"}]},{"id":10496561,"change_date":"2025-12-22 21:39:00","inspection_id":"86631233","dot_number":"786455","report_state":"OK","report_number":"H513154593","insp_date":"2025-12-22 00:00:00","insp_start_time":"1125","insp_end_time":"1155","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US 177 \/ LEO ST","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"-","shipping_paper_number":"-","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-12-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"807775","transaction_code":"A","transaction_date":"2025-12-22 00:00:00","upload_date":"2025-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2025-12-22 21:39:00","snet_input_date":"2025-12-22 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-12-22 21:39:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-25T10:37:45.000000Z","updated_at":"2026-01-02T10:30:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17576113,"change_date":"2025-12-22 21:39:00","inspection_id":"86631233","insp_unit_id":"210754002","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"11","insp_unit_license":"701513","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX04C5FM022464","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:42.000000Z","updated_at":"2026-01-02T10:00:53.000000Z"}]},{"id":10377580,"change_date":"2025-12-08 21:38:00","inspection_id":"86506768","dot_number":"786455","report_state":"OK","report_number":"H513154571","insp_date":"2025-12-05 00:00:00","insp_start_time":"1130","insp_end_time":"1200","registration_date":null,"region":"CT","ci_status_code":"C","location":"41099","location_desc":"SH 99 \/ US 62","county_code_state":"OK","county_code":"081","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-12-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"805944","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2025-12-08 21:38:00","snet_input_date":"2025-12-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-12-08 21:38:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-11T10:30:32.000000Z","updated_at":"2025-12-12T10:30:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17346877,"change_date":"2025-12-08 21:38:00","inspection_id":"86506768","insp_unit_id":"210477620","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"004","insp_unit_license":"733011","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HTWYAHT46J172416","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-11T10:00:31.000000Z","updated_at":"2025-12-12T10:00:47.000000Z"}]},{"id":10363581,"change_date":"2025-12-05 21:43:00","inspection_id":"86492107","dot_number":"786455","report_state":"OK","report_number":"C200000506","insp_date":"2025-12-04 00:00:00","insp_start_time":"0855","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":"63400","location_desc":"I40 AND SH-102","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-12-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"805731","transaction_code":"A","transaction_date":"2025-12-04 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2025-12-05 21:43:00","snet_input_date":"2025-12-04 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-12-05 21:43:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-08T10:32:04.000000Z","updated_at":"2025-12-09T10:31:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17322493,"change_date":"2025-12-05 21:43:00","inspection_id":"86492107","insp_unit_id":"210444615","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"206","insp_unit_license":"723124","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC3RM039916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:09.000000Z","updated_at":"2025-12-09T10:01:31.000000Z"}]},{"id":10261749,"change_date":"2025-11-21 21:39:00","inspection_id":"86385492","dot_number":"786455","report_state":"OK","report_number":"C200000478","insp_date":"2025-11-21 00:00:00","insp_start_time":"0804","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":"63400","location_desc":"I40 AND SH-102","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-11-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"804403","transaction_code":"A","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2025-11-21 21:39:00","snet_input_date":"2025-11-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-11-21 21:39:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-24T10:31:47.000000Z","updated_at":"2025-11-25T10:30:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17107786,"change_date":"2025-11-21 21:39:00","inspection_id":"86385492","insp_unit_id":"210179725","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"205","insp_unit_license":"734564","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV0KLKA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-24T10:01:58.000000Z","updated_at":"2025-11-25T10:00:56.000000Z"}]},{"id":10261754,"change_date":"2025-11-21 21:39:00","inspection_id":"86385497","dot_number":"786455","report_state":"OK","report_number":"C200000479","insp_date":"2025-11-21 00:00:00","insp_start_time":"0903","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 AND 45TH ST","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-11-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"804473","transaction_code":"A","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2025-11-21 21:39:00","snet_input_date":"2025-11-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-11-21 21:39:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-24T10:31:47.000000Z","updated_at":"2025-11-25T10:30:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17107793,"change_date":"2025-11-21 21:39:00","inspection_id":"86385497","insp_unit_id":"210179734","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"004","insp_unit_license":"733011","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HTWYAHT46J172416","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-24T10:01:58.000000Z","updated_at":"2025-11-25T10:00:56.000000Z"}]},{"id":10137855,"change_date":"2025-11-06 21:40:00","inspection_id":"86255362","dot_number":"786455","report_state":"OK","report_number":"C200000450","insp_date":"2025-11-05 00:00:00","insp_start_time":"1445","insp_end_time":"1511","registration_date":null,"region":"CT","ci_status_code":"C","location":"63400","location_desc":"I40 AND SH-102","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-11-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"802648","transaction_code":"A","transaction_date":"2025-11-05 00:00:00","upload_date":"2025-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2025-11-06 21:40:00","snet_input_date":"2025-11-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-11-06 21:40:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-09T10:31:42.000000Z","updated_at":"2025-11-10T10:30:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16875761,"change_date":"2025-11-06 21:40:00","inspection_id":"86255362","insp_unit_id":"209883130","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"203","insp_unit_license":"710635","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2FZHAZCV57AY45939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:55.000000Z","updated_at":"2025-11-10T10:01:27.000000Z"}]},{"id":9940168,"change_date":"2025-10-14 21:42:00","inspection_id":"86047214","dot_number":"786455","report_state":"OK","report_number":"H514154285","insp_date":"2025-10-14 00:00:00","insp_start_time":"1012","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":"063018","location_desc":"HWY 18 \/ I 40","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","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":"2025-10-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"800664","transaction_code":"A","transaction_date":"2025-10-14 00:00:00","upload_date":"2025-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2025-10-14 21:42:00","snet_input_date":"2025-10-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-10-14 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-17T10:01:51.000000Z","updated_at":"2025-10-18T10:01:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16499858,"change_date":"2025-10-14 21:42:00","inspection_id":"86047214","insp_unit_id":"209465962","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"701512","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2P267Y6VM030073","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-17T09:46:55.000000Z","updated_at":"2025-10-18T09:46:30.000000Z"}]},{"id":9781889,"change_date":"2025-10-06 21:40:00","inspection_id":"85880294","dot_number":"786455","report_state":"OK","report_number":"X900201638","insp_date":"2025-09-25 00:00:00","insp_start_time":"0820","insp_end_time":"0900","registration_date":"2025-10-06 00:00:00","region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT N\/B SW 29TH ST","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"M\/C","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-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"798851","transaction_code":"C","transaction_date":"2025-09-25 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2025-09-25 21:41:00","snet_input_date":"2025-09-25 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-09-25 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-28T10:01:11.000000Z","updated_at":"2025-10-10T10:00:34.000000Z","inspection_violations":[{"id":16247198,"change_date":"2025-10-06 21:40:00","inspection_id":"85880294","insp_violation_id":"269122163","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"209319631","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-09T10:15:57.000000Z","updated_at":"2025-10-10T10:15:59.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":16356193,"change_date":"2025-10-06 21:40:00","inspection_id":"85880294","insp_unit_id":"209319631","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"202","insp_unit_license":"734562","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV3HLJA3321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:38.000000Z","updated_at":"2025-10-10T09:45:39.000000Z"}]},{"id":9758171,"change_date":"2025-09-26 21:40:00","inspection_id":"85855464","dot_number":"786455","report_state":"OK","report_number":"H513154531","insp_date":"2025-09-16 00:00:00","insp_start_time":"1055","insp_end_time":"1125","registration_date":"2025-09-26 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US 177 \/ COKER","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-09-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"798508","transaction_code":"C","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2025-09-23 21:43:00","snet_input_date":"2025-09-16 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-09-23 21:43:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:49.000000Z","updated_at":"2025-09-30T10:01:07.000000Z","inspection_violations":[{"id":16102340,"change_date":"2025-09-26 21:40:00","inspection_id":"85855464","insp_violation_id":"268948700","seq_no":"1","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"209168206","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:48.000000Z","updated_at":"2025-09-30T10:16:48.000000Z","normalized_code":"39021TCMC"},{"id":16102341,"change_date":"2025-09-26 21:40:00","inspection_id":"85855464","insp_violation_id":"268948701","seq_no":"2","part_no":"393","part_no_section":"11A1-LSML","insp_viol_unit":"1","insp_unit_id":"209168206","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:48.000000Z","updated_at":"2025-09-30T10:16:48.000000Z","normalized_code":"39311A1LSML"},{"id":16102342,"change_date":"2025-09-26 21:40:00","inspection_id":"85855464","insp_violation_id":"268948702","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209168206","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:49.000000Z","updated_at":"2025-09-30T10:16:49.000000Z","normalized_code":"3922SLLSR"},{"id":16102343,"change_date":"2025-09-26 21:40:00","inspection_id":"85855464","insp_violation_id":"268948703","seq_no":"4","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"209168206","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:49.000000Z","updated_at":"2025-09-30T10:16:49.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":16225866,"change_date":"2025-09-26 21:40:00","inspection_id":"85855464","insp_unit_id":"209168206","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"-","insp_unit_license":"701512","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2P267Y6VM030073","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:44.000000Z","updated_at":"2025-09-30T09:45:42.000000Z"}]},{"id":8939860,"change_date":"2025-06-19 21:37:00","inspection_id":"84995178","dot_number":"786455","report_state":"OK","report_number":"T400162707","insp_date":"2025-06-18 00:00:00","insp_start_time":"1400","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":"67056","location_desc":"SH-56 @ EW 1240 RD","county_code_state":"OK","county_code":"133","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"69886","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-06-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"788748","transaction_code":"A","transaction_date":"2025-06-19 00:00:00","upload_date":"2025-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2025-06-19 21:37:00","snet_input_date":"2025-06-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-06-19 21:37:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-22T10:01:16.000000Z","updated_at":"2025-06-23T10:00:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14651829,"change_date":"2025-06-19 21:37:00","inspection_id":"84995178","insp_unit_id":"207465304","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"81","insp_unit_license":"734567","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDXR0X3YJ858758","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:29.000000Z","updated_at":"2025-06-23T09:45:39.000000Z"}]},{"id":8701669,"change_date":"2025-06-01 21:34:00","inspection_id":"84742594","dot_number":"786455","report_state":"OK","report_number":"C200000389","insp_date":"2025-05-21 00:00:00","insp_start_time":"1235","insp_end_time":"1320","registration_date":"2025-05-30 00:00:00","region":"CT","ci_status_code":"C","location":"55040","location_desc":"I40 - CHOCTAW RD","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"69662","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-05-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"786017","transaction_code":"C","transaction_date":"2025-05-21 00:00:00","upload_date":"2025-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2025-05-21 21:42:00","snet_input_date":"2025-05-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-24T10:04:21.000000Z","updated_at":"2025-06-05T10:00:05.000000Z","inspection_violations":[{"id":14048251,"change_date":"2025-06-01 21:34:00","inspection_id":"84742594","insp_violation_id":"266598857","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207171282","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-04T10:15:27.000000Z","updated_at":"2025-06-05T10:15:05.000000Z","normalized_code":"39378"},{"id":14048252,"change_date":"2025-06-01 21:34:00","inspection_id":"84742594","insp_violation_id":"266598858","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"207171282","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-04T10:15:27.000000Z","updated_at":"2025-06-05T10:15:05.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":14377855,"change_date":"2025-06-01 21:34:00","inspection_id":"84742594","insp_unit_id":"207171282","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"204","insp_unit_license":"734563","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AD62C3TW003619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-04T09:45:24.000000Z","updated_at":"2025-06-05T09:45:04.000000Z"}]},{"id":8689687,"change_date":"2025-06-01 21:34:00","inspection_id":"84729903","dot_number":"786455","report_state":"OK","report_number":"H600153988","insp_date":"2025-05-20 00:00:00","insp_start_time":"1113","insp_end_time":"1205","registration_date":"2025-05-30 00:00:00","region":"CT","ci_status_code":"C","location":"63102","location_desc":"SH-102 \/ LAKE RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"427400","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-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"785778","transaction_code":"C","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2025-05-20 21:41:00","snet_input_date":"2025-05-20 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-05-20 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-23T10:04:19.000000Z","updated_at":"2025-06-05T10:00:05.000000Z","inspection_violations":[{"id":14048238,"change_date":"2025-06-01 21:34:00","inspection_id":"84729903","insp_violation_id":"266598913","seq_no":"1","part_no":"393","part_no_section":"203E-CBP","insp_viol_unit":"1","insp_unit_id":"207171318","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-04T10:15:27.000000Z","updated_at":"2025-06-05T10:15:05.000000Z","normalized_code":"393203ECBP"},{"id":14048239,"change_date":"2025-06-01 21:34:00","inspection_id":"84729903","insp_violation_id":"266598914","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"207171318","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-04T10:15:27.000000Z","updated_at":"2025-06-05T10:15:05.000000Z","normalized_code":"39617CPI"},{"id":14048240,"change_date":"2025-06-01 21:34:00","inspection_id":"84729903","insp_violation_id":"266598915","seq_no":"3","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"207171318","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-04T10:15:27.000000Z","updated_at":"2025-06-05T10:15:05.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":14048241,"change_date":"2025-06-01 21:34:00","inspection_id":"84729903","insp_violation_id":"266598916","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207171318","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-04T10:15:27.000000Z","updated_at":"2025-06-05T10:15:05.000000Z","normalized_code":"3922SLLSR"},{"id":14048242,"change_date":"2025-06-01 21:34:00","inspection_id":"84729903","insp_violation_id":"266598917","seq_no":"5","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"207171318","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-04T10:15:27.000000Z","updated_at":"2025-06-05T10:15:05.000000Z","normalized_code":"39345DB"},{"id":14048243,"change_date":"2025-06-01 21:34:00","inspection_id":"84729903","insp_violation_id":"266598918","seq_no":"6","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"207171318","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-04T10:15:27.000000Z","updated_at":"2025-06-05T10:15:05.000000Z","normalized_code":"3963A1BALR"},{"id":14048244,"change_date":"2025-06-01 21:34:00","inspection_id":"84729903","insp_violation_id":"266598919","seq_no":"7","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"207171318","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-04T10:15:27.000000Z","updated_at":"2025-06-05T10:15:05.000000Z","normalized_code":"39345DB"},{"id":14048245,"change_date":"2025-06-01 21:34:00","inspection_id":"84729903","insp_violation_id":"266598920","seq_no":"8","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"207171319","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-04T10:15:27.000000Z","updated_at":"2025-06-05T10:15:05.000000Z","normalized_code":"3939ALIL"},{"id":14048246,"change_date":"2025-06-01 21:34:00","inspection_id":"84729903","insp_violation_id":"266598921","seq_no":"9","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"207171319","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-04T10:15:27.000000Z","updated_at":"2025-06-05T10:15:05.000000Z","normalized_code":"3922SLLMF"},{"id":14048247,"change_date":"2025-06-01 21:34:00","inspection_id":"84729903","insp_violation_id":"266598922","seq_no":"10","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"207171319","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-04T10:15:27.000000Z","updated_at":"2025-06-05T10:15:05.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14377850,"change_date":"2025-06-01 21:34:00","inspection_id":"84729903","insp_unit_id":"207171318","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"112","insp_unit_license":"3GP683","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGEDV0ESFJ5704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-04T09:45:24.000000Z","updated_at":"2025-06-05T09:45:04.000000Z"},{"id":14377851,"change_date":"2025-06-01 21:34:00","inspection_id":"84729903","insp_unit_id":"207171319","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"XPLO","insp_unit_company":"605","insp_unit_license":"BW7616","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1C93440285S770138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-04T09:45:24.000000Z","updated_at":"2025-06-05T09:45:04.000000Z"}]},{"id":8404885,"change_date":"2025-04-30 21:52:00","inspection_id":"84430017","dot_number":"786455","report_state":"OK","report_number":"H600153904","insp_date":"2025-04-17 00:00:00","insp_start_time":"0809","insp_end_time":"0825","registration_date":"2025-04-29 00:00:00","region":"CT","ci_status_code":"C","location":"63040","location_desc":"I-40 W\/B \/ FISHMARKET","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"782175","transaction_code":"C","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2025-04-17 21:42:00","snet_input_date":"2025-04-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-04-17 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-20T10:28:35.000000Z","updated_at":"2025-05-04T10:37:13.000000Z","inspection_violations":[{"id":13463355,"change_date":"2025-04-30 21:52:00","inspection_id":"84430017","insp_violation_id":"265926960","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:19:32.000000Z","updated_at":"2025-05-03T11:05:20.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":13827809,"change_date":"2025-04-30 21:52:00","inspection_id":"84430017","insp_unit_id":"206573702","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"205","insp_unit_license":"734565","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV0KLKA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:19:25.000000Z","updated_at":"2025-05-04T10:03:11.000000Z"}]},{"id":8276234,"change_date":"2025-04-02 21:41:00","inspection_id":"84294587","dot_number":"786455","report_state":"OK","report_number":"H600153863","insp_date":"2025-04-02 00:00:00","insp_start_time":"1240","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ 45 TH ST","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"780550","transaction_code":"A","transaction_date":"2025-04-02 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2025-04-02 21:41:00","snet_input_date":"2025-04-02 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:50.000000Z","updated_at":"2025-04-06T10:23:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13396778,"change_date":"2025-04-02 21:41:00","inspection_id":"84294587","insp_unit_id":"206119972","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"206","insp_unit_license":"723124","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC3RM039916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:11:39.000000Z","updated_at":"2025-04-06T09:59:16.000000Z"}]},{"id":8240652,"change_date":"2025-03-28 21:41:00","inspection_id":"84257051","dot_number":"786455","report_state":"OK","report_number":"H600153854","insp_date":"2025-03-27 00:00:00","insp_start_time":"0830","insp_end_time":"0900","registration_date":null,"region":"CT","ci_status_code":"C","location":"630CS","location_desc":"HARDESTY RD \/ E GORDON COOPER","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"780026","transaction_code":"A","transaction_date":"2025-03-27 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2025-03-28 21:41:00","snet_input_date":"2025-03-27 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-03-28 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-31T10:32:54.000000Z","updated_at":"2025-04-01T10:14:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13332487,"change_date":"2025-03-28 21:41:00","inspection_id":"84257051","insp_unit_id":"206050633","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"206","insp_unit_license":"723124","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC3RM039916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-31T10:21:26.000000Z","updated_at":"2025-04-01T10:01:31.000000Z"}]},{"id":7530188,"change_date":"2025-01-01 21:32:00","inspection_id":"83510416","dot_number":"786455","report_state":"OK","report_number":"B300000136","insp_date":"2024-12-31 00:00:00","insp_start_time":"1121","insp_end_time":"1138","registration_date":null,"region":"CT","ci_status_code":"C","location":"0177","location_desc":"US-177 \/ LEO STREET","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"M\/C","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-01-01 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"772292","transaction_code":"A","transaction_date":"2024-12-31 00:00:00","upload_date":"2024-12-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2025-01-01 21:32:00","snet_input_date":"2024-12-31 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-01-01 21:32:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:11.000000Z","updated_at":"2025-03-17T20:53:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12148489,"change_date":"2025-01-01 21:32:00","inspection_id":"83510416","insp_unit_id":"204614030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"710641","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV0KLKA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:07.000000Z","updated_at":"2025-03-17T23:49:07.000000Z"}]},{"id":7518876,"change_date":"2025-01-04 21:32:00","inspection_id":"83498578","dot_number":"786455","report_state":"OK","report_number":"B300000134","insp_date":"2024-12-30 00:00:00","insp_start_time":"1128","insp_end_time":"1208","registration_date":"2025-01-03 00:00:00","region":"CT","ci_status_code":"C","location":"0177","location_desc":"US-177 \/ COKER ROAD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"421499","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-12-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"772147","transaction_code":"C","transaction_date":"2024-12-30 00:00:00","upload_date":"2025-01-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2024-12-30 21:39:00","snet_input_date":"2024-12-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-12-30 21:39:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:44.000000Z","updated_at":"2025-03-17T20:52:44.000000Z","inspection_violations":[{"id":11750847,"change_date":"2025-01-04 21:32:00","inspection_id":"83498578","insp_violation_id":"263758990","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39141AMCPC"},{"id":11750848,"change_date":"2025-01-04 21:32:00","inspection_id":"83498578","insp_violation_id":"263758991","seq_no":"2","part_no":"391","part_no_section":"11B5-LNCDLNVL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39111B5LNCDLNVL"}],"inspection_per_units":[{"id":12130127,"change_date":"2025-01-04 21:32:00","inspection_id":"83498578","insp_unit_id":"204653954","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3GP683","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGEDV0ESFJ5704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:56.000000Z","updated_at":"2025-03-17T23:48:56.000000Z"},{"id":12130128,"change_date":"2025-01-04 21:32:00","inspection_id":"83498578","insp_unit_id":"204653955","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"AT3279","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU344048FS000622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:56.000000Z","updated_at":"2025-03-17T23:48:56.000000Z"}]},{"id":7328433,"change_date":"2024-12-03 21:40:00","inspection_id":"83298460","dot_number":"786455","report_state":"OK","report_number":"H600153675","insp_date":"2024-12-03 00:00:00","insp_start_time":"1330","insp_end_time":"1355","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ HARDESTY RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"07092","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"769460","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2024-12-03 21:40:00","snet_input_date":"2024-12-03 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-12-03 21:40:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:58.000000Z","updated_at":"2025-03-17T20:48:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11822007,"change_date":"2024-12-03 21:40:00","inspection_id":"83298460","insp_unit_id":"204152308","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"206","insp_unit_license":"723124","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC3RM039916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:33.000000Z","updated_at":"2025-03-17T23:45:33.000000Z"}]},{"id":7284661,"change_date":"2024-11-26 21:41:00","inspection_id":"83252224","dot_number":"786455","report_state":"OK","report_number":"H514153822","insp_date":"2024-11-26 00:00:00","insp_start_time":"1115","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":"063177","location_desc":"I-40","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","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-11-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"768729","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2024-11-26 21:41:00","snet_input_date":"2024-11-26 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-11-26 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:08.000000Z","updated_at":"2025-03-17T20:48:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11750351,"change_date":"2024-11-26 21:41:00","inspection_id":"83252224","insp_unit_id":"204067231","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"726935","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV3HLJA3321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:48.000000Z","updated_at":"2025-03-17T23:44:48.000000Z"}]},{"id":6817653,"change_date":"2024-09-25 21:41:00","inspection_id":"82757122","dot_number":"786455","report_state":"OK","report_number":"H513154381","insp_date":"2024-09-23 00:00:00","insp_start_time":"1525","insp_end_time":"1555","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US 177 \/ COKER","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"762409","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:15.000000Z","updated_at":"2025-03-17T20:38:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10994080,"change_date":"2024-09-25 21:41:00","inspection_id":"82757122","insp_unit_id":"203126684","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"205","insp_unit_license":"710641","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV0KLKA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:51.000000Z","updated_at":"2025-03-17T23:36:51.000000Z"}]},{"id":6768712,"change_date":"2024-09-25 21:41:00","inspection_id":"82704703","dot_number":"786455","report_state":"OK","report_number":"H600153521","insp_date":"2024-09-19 00:00:00","insp_start_time":"1303","insp_end_time":"1334","registration_date":"2024-09-24 00:00:00","region":"CT","ci_status_code":"C","location":"55240","location_desc":"I-240 \/ EASTERN","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"761811","transaction_code":"C","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2024-09-19 21:42:00","snet_input_date":"2024-09-19 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:20.000000Z","updated_at":"2025-03-17T20:37:20.000000Z","inspection_violations":[{"id":10540783,"change_date":"2024-09-25 21:41:00","inspection_id":"82704703","insp_violation_id":"262029384","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":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":10914821,"change_date":"2024-09-25 21:41:00","inspection_id":"82704703","insp_unit_id":"203126594","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"206","insp_unit_license":"723124","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC3RM039916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:03.000000Z","updated_at":"2025-03-17T23:36:03.000000Z"}]},{"id":6486855,"change_date":"2024-08-16 21:39:00","inspection_id":"82404600","dot_number":"786455","report_state":"OK","report_number":"N600000510","insp_date":"2024-08-16 00:00:00","insp_start_time":"0930","insp_end_time":"1005","registration_date":null,"region":"CT","ci_status_code":"C","location":"61177","location_desc":"U.S. HWY 177   1 N HARDESTY RD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"08162024","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"758239","transaction_code":"A","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2024-08-16 21:39:00","snet_input_date":"2024-08-16 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:33.000000Z","updated_at":"2025-03-17T20:31:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10456121,"change_date":"2024-08-16 21:39:00","inspection_id":"82404600","insp_unit_id":"202431281","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"205","insp_unit_license":"710641","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV0KLKA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:21.000000Z","updated_at":"2025-03-17T23:31:21.000000Z"}]},{"id":5919305,"change_date":"2024-06-05 21:42:00","inspection_id":"81794793","dot_number":"786455","report_state":"OK","report_number":"X900200728","insp_date":"2024-06-05 00:00:00","insp_start_time":"1300","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT SB AND SH3 \/ NW EXPRESSWAY","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CHS","shipping_paper_number":"M\/C","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"3","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"749953","transaction_code":"A","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2024-06-05 21:42:00","snet_input_date":"2024-06-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-06-05 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:53.000000Z","updated_at":"2025-03-17T20:19:53.000000Z","inspection_violations":[{"id":9178666,"change_date":"2024-06-05 21:42:00","inspection_id":"81794793","insp_violation_id":"259918606","seq_no":"1","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"201246815","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"393205C"},{"id":9178667,"change_date":"2024-06-05 21:42:00","inspection_id":"81794793","insp_violation_id":"259918607","seq_no":"2","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"201246815","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"39375G"},{"id":9178668,"change_date":"2024-06-05 21:42:00","inspection_id":"81794793","insp_violation_id":"259918608","seq_no":"3","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"201246815","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"39375G"},{"id":9178669,"change_date":"2024-06-05 21:42:00","inspection_id":"81794793","insp_violation_id":"259918609","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"N278646","created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3922"},{"id":9178670,"change_date":"2024-06-05 21:42:00","inspection_id":"81794793","insp_violation_id":"259918610","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9533978,"change_date":"2024-06-05 21:42:00","inspection_id":"81794793","insp_unit_id":"201246815","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"710636","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AD62C3TW003619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:52.000000Z","updated_at":"2025-03-17T23:21:52.000000Z"}]},{"id":5778472,"change_date":"2024-06-07 21:38:00","inspection_id":"81641867","dot_number":"786455","report_state":"OK","report_number":"H600153252","insp_date":"2024-05-17 00:00:00","insp_start_time":"1205","insp_end_time":"1223","registration_date":"2024-06-07 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ HARDESTY RD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"#GFTOTE","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":"2024-05-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"747898","transaction_code":"C","transaction_date":"2024-05-17 00:00:00","upload_date":"2024-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2024-05-17 21:40:00","snet_input_date":"2024-05-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-05-17 21:40:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:09.000000Z","updated_at":"2025-03-17T20:17:09.000000Z","inspection_violations":[{"id":8945783,"change_date":"2024-06-07 21:38:00","inspection_id":"81641867","insp_violation_id":"259963178","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:16.000000Z","updated_at":"2025-03-17T21:49:16.000000Z","normalized_code":"39216A"},{"id":8945784,"change_date":"2024-06-07 21:38:00","inspection_id":"81641867","insp_violation_id":"259963179","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201284070","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:16.000000Z","updated_at":"2025-03-17T21:49:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9307016,"change_date":"2024-06-07 21:38:00","inspection_id":"81641867","insp_unit_id":"201284069","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"109","insp_unit_license":"710643","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJALAV25DN67218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:39.000000Z","updated_at":"2025-03-17T23:19:39.000000Z"},{"id":9307017,"change_date":"2024-06-07 21:38:00","inspection_id":"81641867","insp_unit_id":"201284070","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"BP128","insp_unit_license":"BG7009","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JJF482F7XS523570","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:39.000000Z","updated_at":"2025-03-17T23:19:39.000000Z"}]},{"id":4964921,"change_date":"2024-02-06 21:42:00","inspection_id":"80754971","dot_number":"786455","report_state":"OK","report_number":"H513154345","insp_date":"2024-02-01 00:00:00","insp_start_time":"1320","insp_end_time":"1350","registration_date":"2024-02-06 00:00:00","region":"CT","ci_status_code":"C","location":"630CR","location_desc":"HARDESTY RD \/ SH 102","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"JOHNSON CONTROLS","shipping_paper_number":"15223","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":"2024-02-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"736523","transaction_code":"C","transaction_date":"2024-02-02 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2024-02-02 21:41:00","snet_input_date":"2024-02-01 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-02-02 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:12.000000Z","updated_at":"2025-03-17T20:01:12.000000Z","inspection_violations":[{"id":7646733,"change_date":"2024-02-06 21:42:00","inspection_id":"80754971","insp_violation_id":"257685447","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7990446,"change_date":"2024-02-06 21:42:00","inspection_id":"80754971","insp_unit_id":"199288678","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"204","insp_unit_license":"710636","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AD62C3TW003619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:27.000000Z","updated_at":"2025-03-17T23:07:27.000000Z"}]},{"id":4884821,"change_date":"2024-02-01 21:43:00","inspection_id":"80667163","dot_number":"786455","report_state":"OK","report_number":"H600153017","insp_date":"2024-01-23 00:00:00","insp_start_time":"1333","insp_end_time":"1353","registration_date":"2024-01-26 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ ACME RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"JOHNSON CONTROLS","shipping_paper_number":"15205","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-23 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"735245","transaction_code":"C","transaction_date":"2024-01-23 00:00:00","upload_date":"2024-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2024-01-23 21:45:00","snet_input_date":"2024-01-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-01-23 21:45:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:36.000000Z","updated_at":"2025-03-17T19:59:36.000000Z","inspection_violations":[{"id":7526584,"change_date":"2024-02-01 21:43:00","inspection_id":"80667163","insp_violation_id":"257611052","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199219937","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:20.000000Z","updated_at":"2025-03-17T21:42:20.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7859597,"change_date":"2024-02-01 21:43:00","inspection_id":"80667163","insp_unit_id":"199219937","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"203","insp_unit_license":"710635","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2FZHAZCV57AY45939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:14.000000Z","updated_at":"2025-03-17T23:06:14.000000Z"}]},{"id":4673750,"change_date":"2023-12-20 21:41:00","inspection_id":"80436722","dot_number":"786455","report_state":"OK","report_number":"H513154276","insp_date":"2023-12-18 00:00:00","insp_start_time":"1005","insp_end_time":"1035","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US 177 \/ HARDESTY","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"732338","transaction_code":"A","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2023-12-20 21:41:00","snet_input_date":"2023-12-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-12-20 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:24.000000Z","updated_at":"2025-03-17T19:55:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7517029,"change_date":"2023-12-20 21:41:00","inspection_id":"80436722","insp_unit_id":"198597041","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"-","insp_unit_license":"723124","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC3RM039916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:12.000000Z","updated_at":"2025-03-17T23:03:12.000000Z"}]},{"id":4537253,"change_date":"2023-12-01 21:42:00","inspection_id":"80286861","dot_number":"786455","report_state":"OK","report_number":"H513154218","insp_date":"2023-11-22 00:00:00","insp_start_time":"1615","insp_end_time":"1645","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US 177 \/ HARDESTY","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-12-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"729911","transaction_code":"A","transaction_date":"2023-11-22 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2023-12-01 21:42:00","snet_input_date":"2023-11-22 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-12-01 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:37.000000Z","updated_at":"2025-03-17T19:52:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7297062,"change_date":"2023-12-01 21:42:00","inspection_id":"80286861","insp_unit_id":"198304046","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"206","insp_unit_license":"723124","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC3RM039916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:18.000000Z","updated_at":"2025-03-17T23:01:18.000000Z"}]},{"id":4491826,"change_date":"2023-12-20 21:41:00","inspection_id":"80236875","dot_number":"786455","report_state":"OK","report_number":"H600152871","insp_date":"2023-11-17 00:00:00","insp_start_time":"1527","insp_end_time":"1627","registration_date":"2023-12-20 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ BENSON PARK","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"7","oos_total":"2","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"729611","transaction_code":"C","transaction_date":"2023-11-27 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2023-11-27 21:41:00","snet_input_date":"2023-11-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-11-27 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:49.000000Z","updated_at":"2025-03-17T19:51:49.000000Z","inspection_violations":[{"id":6951152,"change_date":"2023-12-20 21:41:00","inspection_id":"80236875","insp_violation_id":"256983548","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"N497991","created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3922"},{"id":6951153,"change_date":"2023-12-20 21:41:00","inspection_id":"80236875","insp_violation_id":"256983549","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"N509970","created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3922"},{"id":6951154,"change_date":"2023-12-20 21:41:00","inspection_id":"80236875","insp_violation_id":"256983550","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3922"},{"id":6951155,"change_date":"2023-12-20 21:41:00","inspection_id":"80236875","insp_violation_id":"256983551","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3922"},{"id":6951156,"change_date":"2023-12-20 21:41:00","inspection_id":"80236875","insp_violation_id":"256983552","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198596133","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"39395A"},{"id":6951157,"change_date":"2023-12-20 21:41:00","inspection_id":"80236875","insp_violation_id":"256983553","seq_no":"6","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"198596133","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"393100B"},{"id":6951158,"change_date":"2023-12-20 21:41:00","inspection_id":"80236875","insp_violation_id":"256983554","seq_no":"7","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198596133","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":7223833,"change_date":"2023-12-20 21:41:00","inspection_id":"80236875","insp_unit_id":"198596133","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"202","insp_unit_license":"726935","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV3HLJA3321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:40.000000Z","updated_at":"2025-03-17T23:00:40.000000Z"}]},{"id":4059957,"change_date":"2023-09-26 21:42:00","inspection_id":"79759421","dot_number":"786455","report_state":"OK","report_number":"C200000213","insp_date":"2023-09-25 00:00:00","insp_start_time":"1052","insp_end_time":"1125","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 AND HARDESTY RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-09-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"723555","transaction_code":"A","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2023-09-26 21:42:00","snet_input_date":"2023-09-25 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-09-26 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:51.000000Z","updated_at":"2025-03-17T19:42:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6527545,"change_date":"2023-09-26 21:42:00","inspection_id":"79759421","insp_unit_id":"197245762","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"205","insp_unit_license":"710641","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV0KLKA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:47.000000Z","updated_at":"2025-03-17T22:54:47.000000Z"}]},{"id":3878310,"change_date":"2023-12-20 21:41:00","inspection_id":"79557383","dot_number":"786455","report_state":"OK","report_number":"H513154073","insp_date":"2023-08-30 00:00:00","insp_start_time":"1619","insp_end_time":"1649","registration_date":"2023-12-06 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US 177 \/ LEO ST","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-08-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"721353","transaction_code":"C","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2023-08-31 21:42:00","snet_input_date":"2023-08-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-08-31 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:25.000000Z","updated_at":"2025-03-17T19:39:25.000000Z","inspection_violations":[{"id":5993023,"change_date":"2023-12-20 21:41:00","inspection_id":"79557383","insp_violation_id":"256984212","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"3922"},{"id":5993024,"change_date":"2023-12-20 21:41:00","inspection_id":"79557383","insp_violation_id":"256984213","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198596798","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6234977,"change_date":"2023-12-20 21:41:00","inspection_id":"79557383","insp_unit_id":"198596798","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"001","insp_unit_license":"701513","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX04C5FM022464","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:22.000000Z","updated_at":"2025-03-17T22:52:22.000000Z"}]},{"id":3787519,"change_date":"2023-11-14 21:41:00","inspection_id":"79455865","dot_number":"786455","report_state":"OK","report_number":"H513154045","insp_date":"2023-08-17 00:00:00","insp_start_time":"1225","insp_end_time":"1255","registration_date":"2023-11-14 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US 177 \/ ACME","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"0366","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"719924","transaction_code":"C","transaction_date":"2023-08-21 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2023-08-21 21:41:00","snet_input_date":"2023-08-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-08-21 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:40.000000Z","updated_at":"2025-03-17T19:37:40.000000Z","inspection_violations":[{"id":5842498,"change_date":"2023-11-14 21:41:00","inspection_id":"79455865","insp_violation_id":"256383171","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:10.000000Z","updated_at":"2025-03-17T21:34:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6089556,"change_date":"2023-11-14 21:41:00","inspection_id":"79455865","insp_unit_id":"198052007","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"202","insp_unit_license":"726935","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV3HLJA3321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:09.000000Z","updated_at":"2025-03-17T22:51:09.000000Z"}]},{"id":3332204,"change_date":"2023-06-30 21:40:00","inspection_id":"78945563","dot_number":"786455","report_state":"OK","report_number":"C200000172","insp_date":"2023-06-21 00:00:00","insp_start_time":"0852","insp_end_time":"0935","registration_date":"2023-06-30 00:00:00","region":"CT","ci_status_code":"C","location":"63400","location_desc":"I40 AND MCLOUD RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"714068","transaction_code":"C","transaction_date":"2023-06-21 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2023-06-21 21:42:00","snet_input_date":"2023-06-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-21 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:56.000000Z","updated_at":"2025-03-17T19:28:56.000000Z","inspection_violations":[{"id":5138232,"change_date":"2023-06-30 21:40:00","inspection_id":"78945563","insp_violation_id":"253814045","seq_no":"1","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195779476","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:51.000000Z","updated_at":"2025-03-17T21:30:51.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":5356981,"change_date":"2023-06-30 21:40:00","inspection_id":"78945563","insp_unit_id":"195779476","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"204","insp_unit_license":"710636","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AD62C3TW003619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:16.000000Z","updated_at":"2025-03-17T22:45:16.000000Z"}]},{"id":3257924,"change_date":"2023-06-12 21:40:00","inspection_id":"78861495","dot_number":"786455","report_state":"OK","report_number":"H513153961","insp_date":"2023-06-06 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US 177 \/ ACME RD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-06-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"712815","transaction_code":"A","transaction_date":"2023-06-12 00:00:00","upload_date":"2023-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2023-06-12 21:40:00","snet_input_date":"2023-06-06 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-12 21:40:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:23.000000Z","updated_at":"2025-03-17T19:27:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5239107,"change_date":"2023-06-12 21:40:00","inspection_id":"78861495","insp_unit_id":"195437158","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"-","insp_unit_license":"710635","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2FZHAZCV57AY45939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:17.000000Z","updated_at":"2025-03-17T22:44:17.000000Z"}]},{"id":3162989,"change_date":"2023-05-30 21:42:00","inspection_id":"78754348","dot_number":"786455","report_state":"OK","report_number":"I104152953","insp_date":"2023-05-22 00:00:00","insp_start_time":"1317","insp_end_time":"1338","registration_date":null,"region":"CT","ci_status_code":"C","location":"55240","location_desc":"I-240 AND DOUGLAS","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"710639","transaction_code":"A","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2023-05-30 21:42:00","snet_input_date":"2023-05-22 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-05-30 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:42.000000Z","updated_at":"2025-03-17T19:25:42.000000Z","inspection_violations":[{"id":4871024,"change_date":"2023-05-30 21:42:00","inspection_id":"78754348","insp_violation_id":"253134147","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5087084,"change_date":"2023-05-30 21:42:00","inspection_id":"78754348","insp_unit_id":"195190089","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"710636","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AD62C3TW003619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:06.000000Z","updated_at":"2025-03-17T22:43:06.000000Z"}]},{"id":2542479,"change_date":"2023-03-17 21:42:00","inspection_id":"78050970","dot_number":"786455","report_state":"OK","report_number":"H600152316","insp_date":"2023-03-03 00:00:00","insp_start_time":"1633","insp_end_time":"1658","registration_date":"2023-03-16 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ ACME RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"59561","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"701660","transaction_code":"C","transaction_date":"2023-03-03 00:00:00","upload_date":"2023-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2023-03-09 21:42:00","snet_input_date":"2023-03-03 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-03-09 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:40.000000Z","updated_at":"2025-03-17T19:13:40.000000Z","inspection_violations":[{"id":3910153,"change_date":"2023-03-17 21:42:00","inspection_id":"78050970","insp_violation_id":"251726262","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3922"},{"id":3910154,"change_date":"2023-03-17 21:42:00","inspection_id":"78050970","insp_violation_id":"251726263","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3922"},{"id":3910155,"change_date":"2023-03-17 21:42:00","inspection_id":"78050970","insp_violation_id":"251726264","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3922"},{"id":3910156,"change_date":"2023-03-17 21:42:00","inspection_id":"78050970","insp_violation_id":"251726265","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4092146,"change_date":"2023-03-17 21:42:00","inspection_id":"78050970","insp_unit_id":"193929032","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"205","insp_unit_license":"710641","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV0KLKA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:20.000000Z","updated_at":"2025-03-17T22:35:20.000000Z"}]},{"id":2491082,"change_date":"2023-03-02 21:41:00","inspection_id":"77992693","dot_number":"786455","report_state":"OK","report_number":"X200171229","insp_date":"2023-03-02 00:00:00","insp_start_time":"1411","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":"42035","location_desc":"I35\/SEWARD","county_code_state":"OK","county_code":"083","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","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-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"701480","transaction_code":"A","transaction_date":"2023-03-02 00:00:00","upload_date":"2023-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2023-03-02 21:41:00","snet_input_date":"2023-03-02 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-03-02 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:32.000000Z","updated_at":"2025-03-17T19:12:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4008457,"change_date":"2023-03-02 21:41:00","inspection_id":"77992693","insp_unit_id":"193672749","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"010","insp_unit_license":"701512","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2P267Y6VM030073","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:42.000000Z","updated_at":"2025-03-17T22:34:42.000000Z"}]},{"id":2434247,"change_date":"2023-03-09 21:42:00","inspection_id":"77928133","dot_number":"786455","report_state":"OK","report_number":"H513153798","insp_date":"2023-02-22 00:00:00","insp_start_time":"0957","insp_end_time":"1027","registration_date":"2023-02-27 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US 177 \/ HARDESTY RD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","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-02-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"700486","transaction_code":"C","transaction_date":"2023-03-06 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2023-02-23 21:40:00","snet_input_date":"2023-02-22 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-02-23 21:40:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:27.000000Z","updated_at":"2025-03-17T19:11:27.000000Z","inspection_violations":[{"id":3747570,"change_date":"2023-03-09 21:42:00","inspection_id":"77928133","insp_violation_id":"251568184","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39216A"},{"id":3747571,"change_date":"2023-03-09 21:42:00","inspection_id":"77928133","insp_violation_id":"251568185","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193789421","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3917303,"change_date":"2023-03-09 21:42:00","inspection_id":"77928133","insp_unit_id":"193789420","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"-","insp_unit_license":"710635","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2FZHAZCV57AY45939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:03.000000Z","updated_at":"2025-03-17T22:34:03.000000Z"},{"id":3917304,"change_date":"2023-03-09 21:42:00","inspection_id":"77928133","insp_unit_id":"193789421","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"G & H","insp_unit_company":"-","insp_unit_license":"8449KB","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1G9PW33213A116002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:03.000000Z","updated_at":"2025-03-17T22:34:03.000000Z"}]},{"id":2284818,"change_date":"2023-02-02 21:42:00","inspection_id":"77757555","dot_number":"786455","report_state":"OK","report_number":"H600152243","insp_date":"2023-02-01 00:00:00","insp_start_time":"0908","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ ACME RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"391997","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-02-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"698365","transaction_code":"A","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2023-02-02 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-02-02 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:51.000000Z","updated_at":"2025-03-17T19:08:51.000000Z","inspection_violations":[{"id":3523347,"change_date":"2023-02-02 21:42:00","inspection_id":"77757555","insp_violation_id":"250918331","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"193197720","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:39.000000Z","updated_at":"2025-03-17T21:23:39.000000Z","normalized_code":"39375A3"},{"id":3523348,"change_date":"2023-02-02 21:42:00","inspection_id":"77757555","insp_violation_id":"250918332","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193197721","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:39.000000Z","updated_at":"2025-03-17T21:23:39.000000Z","normalized_code":"39617C"},{"id":3523349,"change_date":"2023-02-02 21:42:00","inspection_id":"77757555","insp_violation_id":"250918333","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193197721","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:39.000000Z","updated_at":"2025-03-17T21:23:39.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3677004,"change_date":"2023-02-02 21:42:00","inspection_id":"77757555","insp_unit_id":"193197720","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"112","insp_unit_license":"3GP683","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGEDV0ESFJ5704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:21.000000Z","updated_at":"2025-03-17T22:32:21.000000Z"},{"id":3677005,"change_date":"2023-02-02 21:42:00","inspection_id":"77757555","insp_unit_id":"193197721","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"BT502","insp_unit_license":"BV1154","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5C2BR45B8NM012169","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:21.000000Z","updated_at":"2025-03-17T22:32:21.000000Z"}]},{"id":2113630,"change_date":"2023-01-11 21:42:00","inspection_id":"77561971","dot_number":"786455","report_state":"OK","report_number":"H600152192","insp_date":"2023-01-10 00:00:00","insp_start_time":"1406","insp_end_time":"1428","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ HARDESTY RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"58525","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"696120","transaction_code":"A","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2023-01-11 21:42:00","snet_input_date":"2023-01-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-01-11 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:32.000000Z","updated_at":"2025-03-17T19:05:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3401590,"change_date":"2023-01-11 21:42:00","inspection_id":"77561971","insp_unit_id":"192806594","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"205","insp_unit_license":"710641","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV0KLKA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:23.000000Z","updated_at":"2025-03-17T22:30:23.000000Z"}]},{"id":2025128,"change_date":"2022-12-28 21:39:00","inspection_id":"77460548","dot_number":"786455","report_state":"OK","report_number":"H513153724","insp_date":"2022-12-21 00:00:00","insp_start_time":"1410","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US 177 \/ ACME RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"694875","transaction_code":"A","transaction_date":"2022-12-28 00:00:00","upload_date":"2022-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2022-12-28 21:39:00","snet_input_date":"2022-12-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-12-28 21:39:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:59.000000Z","updated_at":"2025-03-17T19:03:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3258160,"change_date":"2022-12-28 21:39:00","inspection_id":"77460548","insp_unit_id":"192603216","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"204","insp_unit_license":"710636","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AD62C3TW003619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:19.000000Z","updated_at":"2025-03-17T22:29:19.000000Z"}]},{"id":1842167,"change_date":"2022-11-30 21:40:00","inspection_id":"77251395","dot_number":"786455","report_state":"OK","report_number":"H600152143","insp_date":"2022-11-30 00:00:00","insp_start_time":"1233","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ 45TH ST","county_code_state":"OK","county_code":"125","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"692571","transaction_code":"A","transaction_date":"2022-11-30 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2022-11-30 21:40:00","snet_input_date":"2022-11-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-11-30 21:40:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:42.000000Z","updated_at":"2025-03-17T19:00:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2963884,"change_date":"2022-11-30 21:40:00","inspection_id":"77251395","insp_unit_id":"192191050","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"205","insp_unit_license":"710641","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV0KLKA6106","insp_unit_decal":"Y","insp_unit_decal_number":"32050213","created_at":"2025-03-17T22:27:17.000000Z","updated_at":"2025-03-17T22:27:17.000000Z"}]},{"id":1833217,"change_date":"2022-12-08 21:40:00","inspection_id":"77241252","dot_number":"786455","report_state":"OK","report_number":"H600152138","insp_date":"2022-11-29 00:00:00","insp_start_time":"1039","insp_end_time":"1123","registration_date":"2022-12-07 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ LEO ST","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"JOHNSON CONTROLS","shipping_paper_number":"13928","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"6","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"692426","transaction_code":"C","transaction_date":"2022-11-29 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2022-11-29 21:41:00","snet_input_date":"2022-11-29 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-11-29 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:22.000000Z","updated_at":"2025-03-17T19:00:22.000000Z","inspection_violations":[{"id":2861352,"change_date":"2022-12-08 21:40:00","inspection_id":"77241252","insp_violation_id":"249992658","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:38.000000Z","updated_at":"2025-03-17T21:20:38.000000Z","normalized_code":"3922"},{"id":2861353,"change_date":"2022-12-08 21:40:00","inspection_id":"77241252","insp_violation_id":"249992659","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:38.000000Z","updated_at":"2025-03-17T21:20:38.000000Z","normalized_code":"3922"},{"id":2861354,"change_date":"2022-12-08 21:40:00","inspection_id":"77241252","insp_violation_id":"249992660","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:38.000000Z","updated_at":"2025-03-17T21:20:38.000000Z","normalized_code":"3922"},{"id":2861355,"change_date":"2022-12-08 21:40:00","inspection_id":"77241252","insp_violation_id":"249992661","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:38.000000Z","updated_at":"2025-03-17T21:20:38.000000Z","normalized_code":"3922"},{"id":2861356,"change_date":"2022-12-08 21:40:00","inspection_id":"77241252","insp_violation_id":"249992662","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192326924","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:38.000000Z","updated_at":"2025-03-17T21:20:38.000000Z","normalized_code":"3939A"},{"id":2861357,"change_date":"2022-12-08 21:40:00","inspection_id":"77241252","insp_violation_id":"249992663","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192326924","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:38.000000Z","updated_at":"2025-03-17T21:20:38.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":2949329,"change_date":"2022-12-08 21:40:00","inspection_id":"77241252","insp_unit_id":"192326924","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"203","insp_unit_license":"710635","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2FZHAZCV57AY45939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:10.000000Z","updated_at":"2025-03-17T22:27:10.000000Z"}]},{"id":1753079,"change_date":"2022-11-16 21:40:00","inspection_id":"77149260","dot_number":"786455","report_state":"OK","report_number":"W500171812","insp_date":"2022-11-16 00:00:00","insp_start_time":"1040","insp_end_time":"1105","registration_date":null,"region":"CT","ci_status_code":"C","location":"06840","location_desc":"2 MILES WEST OF SALLISAW","county_code_state":"OK","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"BALL PIPE","shipping_paper_number":"TBADE1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"691109","transaction_code":"A","transaction_date":"2022-11-16 00:00:00","upload_date":"2022-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2022-11-16 21:40:00","snet_input_date":"2022-11-16 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-11-16 21:40:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:57.000000Z","updated_at":"2025-03-17T18:58:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2820491,"change_date":"2022-11-16 21:40:00","inspection_id":"77149260","insp_unit_id":"191985550","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"3GP682","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DU9X32D581148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:18.000000Z","updated_at":"2025-03-17T22:26:18.000000Z"},{"id":2820492,"change_date":"2022-11-16 21:40:00","inspection_id":"77149260","insp_unit_id":"191985551","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CONST","insp_unit_company":"BP501","insp_unit_license":"AT3279","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU344048FS000622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:18.000000Z","updated_at":"2025-03-17T22:26:18.000000Z"}]},{"id":1685580,"change_date":"2022-11-16 21:40:00","inspection_id":"77072046","dot_number":"786455","report_state":"OK","report_number":"H600152091","insp_date":"2022-11-07 00:00:00","insp_start_time":"1335","insp_end_time":"1410","registration_date":"2022-11-16 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 S\/B \/ GORDON COOPER DR","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"690094","transaction_code":"C","transaction_date":"2022-11-07 00:00:00","upload_date":"2022-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2022-11-07 21:41:00","snet_input_date":"2022-11-07 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-11-07 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:44.000000Z","updated_at":"2025-03-17T18:57:44.000000Z","inspection_violations":[{"id":2642428,"change_date":"2022-11-16 21:40:00","inspection_id":"77072046","insp_violation_id":"249631852","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191984962","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:28.000000Z","updated_at":"2025-03-17T21:19:28.000000Z","normalized_code":"39311"},{"id":2642429,"change_date":"2022-11-16 21:40:00","inspection_id":"77072046","insp_violation_id":"249631853","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191984962","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:28.000000Z","updated_at":"2025-03-17T21:19:28.000000Z","normalized_code":"3939A"},{"id":2642430,"change_date":"2022-11-16 21:40:00","inspection_id":"77072046","insp_violation_id":"249631854","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191984962","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:28.000000Z","updated_at":"2025-03-17T21:19:28.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2711585,"change_date":"2022-11-16 21:40:00","inspection_id":"77072046","insp_unit_id":"191984962","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"204","insp_unit_license":"710636","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AD62C3TW003619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:35.000000Z","updated_at":"2025-03-17T22:25:35.000000Z"}]},{"id":1675735,"change_date":"2022-11-04 21:38:00","inspection_id":"77060630","dot_number":"786455","report_state":"OK","report_number":"C200000072","insp_date":"2022-11-04 00:00:00","insp_start_time":"1212","insp_end_time":"1240","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ LEO ST","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"689926","transaction_code":"A","transaction_date":"2022-11-04 00:00:00","upload_date":"2022-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2022-11-04 21:38:00","snet_input_date":"2022-11-04 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-11-04 21:38:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:27.000000Z","updated_at":"2025-03-17T18:57:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2695618,"change_date":"2022-11-04 21:38:00","inspection_id":"77060630","insp_unit_id":"191812300","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"205","insp_unit_license":"710641","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV0KLKA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:29.000000Z","updated_at":"2025-03-17T22:25:29.000000Z"}]},{"id":1363340,"change_date":"2022-10-12 21:41:00","inspection_id":"76700245","dot_number":"786455","report_state":"OK","report_number":"B910153757","insp_date":"2022-09-23 00:00:00","insp_start_time":"1035","insp_end_time":"1105","registration_date":null,"region":"CT","ci_status_code":"C","location":"40059","location_desc":"US271 SPIRO","county_code_state":"OK","county_code":"079","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-26 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":"685135","transaction_code":"C","transaction_date":"2022-10-12 00:00:00","upload_date":"2022-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2022-09-26 21:39:00","snet_input_date":"2022-09-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-09-26 21:39:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:56.000000Z","updated_at":"2025-03-17T18:51:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2195052,"change_date":"2022-10-12 21:41:00","inspection_id":"76700245","insp_unit_id":"191397662","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"3GP682","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DU9X32D581148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:02.000000Z","updated_at":"2025-03-17T22:22:02.000000Z"},{"id":2195053,"change_date":"2022-10-12 21:41:00","inspection_id":"76700245","insp_unit_id":"191397663","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CONST","insp_unit_company":"1","insp_unit_license":"AT3279","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU344048FS000622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:02.000000Z","updated_at":"2025-03-17T22:22:02.000000Z"}]},{"id":964105,"change_date":"2022-08-04 21:42:00","inspection_id":"76235746","dot_number":"786455","report_state":"OK","report_number":"H513153443","insp_date":"2022-07-29 00:00:00","insp_start_time":"0620","insp_end_time":"0650","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US 177 \/ SH 9","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"385373","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"679300","transaction_code":"A","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2022-08-04 21:42:00","snet_input_date":"2022-07-29 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-08-04 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:44.000000Z","updated_at":"2025-03-17T18:44:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1551162,"change_date":"2022-08-04 21:42:00","inspection_id":"76235746","insp_unit_id":"190135433","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"3GP62","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DU9X32D581148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:46.000000Z","updated_at":"2025-03-17T22:17:46.000000Z"},{"id":1551163,"change_date":"2022-08-04 21:42:00","inspection_id":"76235746","insp_unit_id":"190135434","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CONST","insp_unit_company":"-","insp_unit_license":"AT3279","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU344048FS000622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:46.000000Z","updated_at":"2025-03-17T22:17:46.000000Z"}]},{"id":788446,"change_date":"2022-07-11 21:41:00","inspection_id":"76030050","dot_number":"786455","report_state":"OK","report_number":"H600151813","insp_date":"2022-07-08 00:00:00","insp_start_time":"1116","insp_end_time":"2340","registration_date":null,"region":"CT","ci_status_code":"C","location":"14077","location_desc":"US-77 \/ FRANKLIN RD","county_code_state":"OK","county_code":"027","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"676520","transaction_code":"A","transaction_date":"2022-07-11 00:00:00","upload_date":"2022-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2022-07-11 21:41:00","snet_input_date":"2022-07-08 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-07-11 21:41:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:35.000000Z","updated_at":"2025-03-17T18:41:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1268372,"change_date":"2022-07-11 21:41:00","inspection_id":"76030050","insp_unit_id":"189697690","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"205","insp_unit_license":"710641","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV0KLKA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:58.000000Z","updated_at":"2025-03-17T22:15:58.000000Z"}]},{"id":708069,"change_date":"2022-06-28 21:42:00","inspection_id":"75936227","dot_number":"786455","report_state":"OK","report_number":"C200000021","insp_date":"2022-06-28 00:00:00","insp_start_time":"1124","insp_end_time":"1235","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 AND LEO ST","county_code_state":"OK","county_code":"125","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"55944","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"675413","transaction_code":"A","transaction_date":"2022-06-28 00:00:00","upload_date":"2022-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2022-06-28 21:42:00","snet_input_date":"2022-06-28 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-06-28 21:42:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:11.000000Z","updated_at":"2025-03-17T18:40:11.000000Z","inspection_violations":[{"id":1112591,"change_date":"2022-06-28 21:42:00","inspection_id":"75936227","insp_violation_id":"246760375","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189498021","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:12.000000Z","updated_at":"2025-03-17T21:12:12.000000Z","normalized_code":"3939A"},{"id":1112592,"change_date":"2022-06-28 21:42:00","inspection_id":"75936227","insp_violation_id":"246760376","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"189498021","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:12.000000Z","updated_at":"2025-03-17T21:12:12.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":1138115,"change_date":"2022-06-28 21:42:00","inspection_id":"75936227","insp_unit_id":"189498021","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"710641","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV0KLKA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:11.000000Z","updated_at":"2025-03-17T22:15:11.000000Z"}]},{"id":523113,"change_date":"2022-06-01 21:49:00","inspection_id":"75716682","dot_number":"786455","report_state":"OK","report_number":"H600151748","insp_date":"2022-05-27 00:00:00","insp_start_time":"1311","insp_end_time":"1333","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ LEO ST","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-01 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"672104","transaction_code":"A","transaction_date":"2022-05-31 00:00:00","upload_date":"2022-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2022-06-01 21:49:00","snet_input_date":"2022-05-27 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-06-01 21:49:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:01.000000Z","updated_at":"2025-03-17T18:37:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":841798,"change_date":"2022-06-01 21:49:00","inspection_id":"75716682","insp_unit_id":"189012825","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"205","insp_unit_license":"710641","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KKHAXDV0KLKA6106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:24.000000Z","updated_at":"2025-03-17T22:13:24.000000Z"}]},{"id":472093,"change_date":"2022-06-14 21:42:00","inspection_id":"75656036","dot_number":"786455","report_state":"OK","report_number":"W500171433","insp_date":"2022-05-24 00:00:00","insp_start_time":"0955","insp_end_time":"1025","registration_date":"2022-06-14 00:00:00","region":"CT","ci_status_code":"C","location":"06840","location_desc":"INTERSTATE 40 MILE MARKER 311","county_code_state":"OK","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"BALL PIPE","shipping_paper_number":"TBMTTJ","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"671739","transaction_code":"C","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2022-05-24 21:43:00","snet_input_date":"2022-05-24 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-05-24 21:43:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:59.000000Z","updated_at":"2025-03-17T18:35:59.000000Z","inspection_violations":[{"id":746808,"change_date":"2022-06-14 21:42:00","inspection_id":"75656036","insp_violation_id":"246442997","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":759001,"change_date":"2022-06-14 21:42:00","inspection_id":"75656036","insp_unit_id":"189232134","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"3GP682","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DU9X32D581148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:51.000000Z","updated_at":"2025-03-17T22:12:51.000000Z"},{"id":759002,"change_date":"2022-06-14 21:42:00","inspection_id":"75656036","insp_unit_id":"189232135","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CONST","insp_unit_company":"111","insp_unit_license":"AT3279","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5TU344048FS000622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:51.000000Z","updated_at":"2025-03-17T22:12:51.000000Z"}]},{"id":523048,"change_date":"2022-06-01 21:49:00","inspection_id":"75716608","dot_number":"786455","report_state":"OK","report_number":"H513153351","insp_date":"2022-05-22 00:00:00","insp_start_time":"1145","insp_end_time":"1220","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US 177 \/ ACME RD","county_code_state":"OK","county_code":"125","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"14847","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-01 21:49: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":"672413","transaction_code":"A","transaction_date":"2022-05-31 00:00:00","upload_date":"2022-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":"M","census_search_date":"2022-06-01 21:49:00","snet_input_date":"2022-05-22 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-06-01 21:49:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:01.000000Z","updated_at":"2025-03-17T18:37:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":841681,"change_date":"2022-06-01 21:49:00","inspection_id":"75716608","insp_unit_id":"189012686","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"101","insp_unit_license":"705640","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUYDSEB0XPB06295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:24.000000Z","updated_at":"2025-03-17T22:13:24.000000Z"},{"id":841682,"change_date":"2022-06-01 21:49:00","inspection_id":"75716608","insp_unit_id":"189012687","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"BP702","insp_unit_license":"7609DR","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"FWV457902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:24.000000Z","updated_at":"2025-03-17T22:13:24.000000Z"}]},{"id":99752,"change_date":"2022-04-20 21:42:00","inspection_id":"75210023","dot_number":"786455","report_state":"OK","report_number":"S614152414","insp_date":"2022-04-01 00:00:00","insp_start_time":"1620","insp_end_time":"1650","registration_date":"2022-04-15 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"SHAWNEE","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"665806","transaction_code":"C","transaction_date":"2022-04-01 00:00:00","upload_date":"2022-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2022-04-04 21:40:00","snet_input_date":"2022-04-01 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-04-04 21:40:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:12.000000Z","updated_at":"2025-03-17T18:29:12.000000Z","inspection_violations":[{"id":146833,"change_date":"2022-04-20 21:42:00","inspection_id":"75210023","insp_violation_id":"245263472","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"188243732","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":161375,"change_date":"2022-04-20 21:42:00","inspection_id":"75210023","insp_unit_id":"188243732","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"701511","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2P264Y3TM020716","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:12.000000Z","updated_at":"2025-03-17T22:09:12.000000Z"}]},{"id":50783,"change_date":"2022-04-06 21:40:00","inspection_id":"75150290","dot_number":"786455","report_state":"OK","report_number":"C200000003","insp_date":"2022-03-24 00:00:00","insp_start_time":"1548","insp_end_time":"1705","registration_date":"2022-04-06 00:00:00","region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 AND 45TH ST","county_code_state":"OK","county_code":"125","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MC","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"664840","transaction_code":"C","transaction_date":"2022-03-24 00:00:00","upload_date":"2022-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00786455","upload_search_indicator":null,"census_search_date":"2022-03-28 21:40:00","snet_input_date":"2022-03-24 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-03-28 21:40:00","insp_carrier_name":"BALL PIPE & SUPPLY INC","insp_carrier_street":"41501 HARDESTY ROAD","insp_carrier_city":"SHAWNEE","insp_carrier_state":"OK","insp_carrier_zip_code":"74801","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:26.000000Z","updated_at":"2025-03-17T18:28:26.000000Z","inspection_violations":[{"id":71806,"change_date":"2022-04-06 21:40:00","inspection_id":"75150290","insp_violation_id":"244992475","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188013159","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"3922"},{"id":71807,"change_date":"2022-04-06 21:40:00","inspection_id":"75150290","insp_violation_id":"244992476","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188013159","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"3922"},{"id":71808,"change_date":"2022-04-06 21:40:00","inspection_id":"75150290","insp_violation_id":"244992477","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188013159","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"39311"},{"id":71809,"change_date":"2022-04-06 21:40:00","inspection_id":"75150290","insp_violation_id":"244992478","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188013159","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":81948,"change_date":"2022-04-06 21:40:00","inspection_id":"75150290","insp_unit_id":"188013159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"204","insp_unit_license":"710636","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AD62C3TW003619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:45.000000Z","updated_at":"2025-03-17T22:08:45.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/786455\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/786455\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/786455\/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\/786455\/inspections","per_page":100,"prev_page_url":null,"to":69,"total":69}