{"current_page":1,"data":[{"id":11617317,"change_date":"2026-04-10 21:38:00","inspection_id":"87545169","dot_number":"919321","report_state":"ND","report_number":"HP15001011","insp_date":"2026-04-09 00:00:00","insp_start_time":"0848","insp_end_time":"0930","registration_date":null,"region":"CD","ci_status_code":"C","location":"PANGER","location_desc":"WILLISTON ND","county_code_state":"ND","county_code":"053","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","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":"3141415","transaction_code":"A","transaction_date":"2026-04-10 00:00:00","upload_date":"2026-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2026-04-10 21:38:00","snet_input_date":"2026-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-10 21:38:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-13T10:09:33.000000Z","updated_at":"2026-04-21T09:31:04.000000Z","inspection_violations":[{"id":20159130,"change_date":"2026-04-10 21:38:00","inspection_id":"87545169","insp_violation_id":"273522443","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"212949195","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-12T12:11:32.000000Z","updated_at":"2026-04-21T09:50:45.000000Z","normalized_code":"39395A1"},{"id":20159131,"change_date":"2026-04-10 21:38:00","inspection_id":"87545169","insp_violation_id":"273522444","seq_no":"2","part_no":"393","part_no_section":"110B3-C","insp_viol_unit":"2","insp_unit_id":"212949196","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-04-12T12:11:32.000000Z","updated_at":"2026-04-21T09:50:45.000000Z","normalized_code":"393110B3C"}],"inspection_per_units":[{"id":20205627,"change_date":"2026-04-10 21:38:00","inspection_id":"87545169","insp_unit_id":"212949195","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"ELR817","insp_unit_license":"3BF211","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCLXHG702890","insp_unit_decal":"Y","insp_unit_decal_number":"36428465","created_at":"2026-04-13T10:01:45.000000Z","updated_at":"2026-04-21T09:04:21.000000Z"},{"id":20205628,"change_date":"2026-04-10 21:38:00","inspection_id":"87545169","insp_unit_id":"212949196","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOP HAT","insp_unit_company":"T2","insp_unit_license":"AV1171","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G04026HT167466","insp_unit_decal":"Y","insp_unit_decal_number":"36428466","created_at":"2026-04-13T10:01:45.000000Z","updated_at":"2026-04-21T09:04:21.000000Z"}]},{"id":11559967,"change_date":"2026-04-03 21:37:00","inspection_id":"87483215","dot_number":"919321","report_state":"CO","report_number":"1644951042","insp_date":"2026-04-01 00:00:00","insp_start_time":"1230","insp_end_time":"1257","registration_date":null,"region":"MD","ci_status_code":"C","location":"LOVFIR","location_desc":"LOVELAND CO","county_code_state":"CO","county_code":"069","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-03 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","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":"3108943","transaction_code":"A","transaction_date":"2026-04-02 00:00:00","upload_date":"2026-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2026-04-03 21:37:00","snet_input_date":"2026-04-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-03 21:37:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-06T09:50:28.000000Z","updated_at":"2026-04-14T09:30:27.000000Z","inspection_violations":[{"id":19539562,"change_date":"2026-04-03 21:37:00","inspection_id":"87483215","insp_violation_id":"272847935","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"212523796","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-06T10:17:56.000000Z","updated_at":"2026-04-13T10:10:20.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":19811383,"change_date":"2026-04-03 21:37:00","inspection_id":"87483215","insp_unit_id":"212523796","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"01","insp_unit_license":"2WZ590","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FDUF5HTXEEB11866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-06T09:38:20.000000Z","updated_at":"2026-04-14T09:02:59.000000Z"}]},{"id":11385452,"change_date":"2026-03-16 21:38:00","inspection_id":"87299795","dot_number":"919321","report_state":"PA","report_number":"C112607588","insp_date":"2026-03-16 00:00:00","insp_start_time":"1140","insp_end_time":"1200","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BEAVER TWP PA","county_code_state":"PA","county_code":"031","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"INDUSTRIAL PIPING SPECIALISTS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3012889","transaction_code":"A","transaction_date":"2026-03-16 00:00:00","upload_date":"2026-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2026-03-16 21:38:00","snet_input_date":"2026-03-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-16 21:38:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"PO BOX 581270","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74158","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"OK","created_at":"2026-03-19T09:37:46.000000Z","updated_at":"2026-03-27T09:31:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19496328,"change_date":"2026-03-16 21:38:00","inspection_id":"87299795","insp_unit_id":"212154938","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"PWZ6973","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUJHTFW8RLVD4938","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-19T09:12:39.000000Z","updated_at":"2026-03-27T09:04:49.000000Z"}]},{"id":11356602,"change_date":"2026-03-17 21:39:00","inspection_id":"87275063","dot_number":"919321","report_state":"PA","report_number":"C112606877","insp_date":"2026-03-09 00:00:00","insp_start_time":"1040","insp_end_time":"1110","registration_date":"2026-03-17 00:00:00","region":"ED","ci_status_code":"C","location":"999","location_desc":"PA","county_code_state":"PA","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"IDUST PIPE SPECIALISTS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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-03-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"3015749","transaction_code":"C","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2026-03-12 21:39:00","snet_input_date":"2026-03-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-12 21:39:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"PO BOX 581270","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74158","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-15T09:39:56.000000Z","updated_at":"2026-03-28T09:30:15.000000Z","inspection_violations":[{"id":19205186,"change_date":"2026-03-17 21:39:00","inspection_id":"87275063","insp_violation_id":"272445625","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"212173689","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-20T10:03:20.000000Z","updated_at":"2026-03-28T09:45:25.000000Z","normalized_code":"3939ALLPL"},{"id":19205187,"change_date":"2026-03-17 21:39:00","inspection_id":"87275063","insp_violation_id":"272445626","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"212173689","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-20T10:03:20.000000Z","updated_at":"2026-03-28T09:45:25.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":19510265,"change_date":"2026-03-17 21:39:00","inspection_id":"87275063","insp_unit_id":"212173689","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"3LL842","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCLXRG364263","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:18.000000Z","updated_at":"2026-03-28T09:03:57.000000Z"}]},{"id":10896771,"change_date":"2026-01-31 21:33:00","inspection_id":"86927977","dot_number":"919321","report_state":"OH","report_number":"3225001791","insp_date":"2026-01-29 00:00:00","insp_start_time":"0944","insp_end_time":"1013","registration_date":null,"region":"ES","ci_status_code":"C","location":"007","location_desc":"NEW SPRINGFIELD OH","county_code_state":"OH","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"STO64615-3 \/ ST","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-31 21:33: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":"2831004","transaction_code":"A","transaction_date":"2026-01-30 00:00:00","upload_date":"2026-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2026-01-31 21:33:00","snet_input_date":"2026-01-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-31 21:33:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-03T10:35:14.000000Z","updated_at":"2026-02-11T10:30:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18320202,"change_date":"2026-01-31 21:33:00","inspection_id":"86927977","insp_unit_id":"211374178","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"M6134","insp_unit_license":"PWZ6973","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALHCYCY3FDGM6134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-03T10:09:32.000000Z","updated_at":"2026-02-11T10:03:41.000000Z"}]},{"id":10813385,"change_date":"2026-01-20 21:40:00","inspection_id":"86840605","dot_number":"919321","report_state":"TX","report_number":"7BYF9DDNJ1","insp_date":"2026-01-06 00:00:00","insp_start_time":"1500","insp_end_time":"1520","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0364 IN JEFFERSON CO. (438-","county_code_state":"TX","county_code":"245","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"IPS","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":"Y","pen_cen_match":null,"final_status_date":"2026-01-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"41900","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":"9821582","transaction_code":"A","transaction_date":"2026-01-20 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2026-01-20 21:40:00","snet_input_date":"2026-01-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-20 21:40:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2026-01-23T10:36:27.000000Z","updated_at":"2026-01-31T10:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18159352,"change_date":"2026-01-20 21:40:00","inspection_id":"86840605","insp_unit_id":"211186648","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3LF972","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL7KG540945","insp_unit_decal":"Y","insp_unit_decal_number":"35973165","created_at":"2026-01-24T10:08:23.000000Z","updated_at":"2026-01-31T10:03:24.000000Z"},{"id":18159353,"change_date":"2026-01-20 21:40:00","inspection_id":"86840605","insp_unit_id":"211186649","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TPHT","insp_unit_company":null,"insp_unit_license":"AE7688","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G04022HT163754","insp_unit_decal":"Y","insp_unit_decal_number":"35973166","created_at":"2026-01-24T10:08:23.000000Z","updated_at":"2026-01-31T10:03:24.000000Z"}]},{"id":10115081,"change_date":"2025-11-04 21:39:00","inspection_id":"86231294","dot_number":"919321","report_state":"OH","report_number":"3228001027","insp_date":"2025-11-03 00:00:00","insp_start_time":"0829","insp_end_time":"0856","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"YOUNGSTOWN OH","county_code_state":"OH","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"INDUSTRIAL PIPING SPECIALISTS","shipping_paper_number":"251021-2069","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"142350","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":"2499149","transaction_code":"A","transaction_date":"2025-11-04 00:00:00","upload_date":"2025-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2025-11-04 21:39:00","snet_input_date":"2025-11-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-04 21:39:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-07T10:31:14.000000Z","updated_at":"2025-11-08T10:30:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16822794,"change_date":"2025-11-04 21:39:00","inspection_id":"86231294","insp_unit_id":"209822884","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"S6","insp_unit_license":"3BF340","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGEDV7JSJT5492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:29.000000Z","updated_at":"2025-11-08T10:00:34.000000Z"},{"id":16822795,"change_date":"2025-11-04 21:39:00","inspection_id":"86231294","insp_unit_id":"209822885","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REITNOUER","insp_unit_company":null,"insp_unit_license":"TPY7392","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1RNF48A23DR027690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:29.000000Z","updated_at":"2025-11-08T10:00:34.000000Z"}]},{"id":9317680,"change_date":"2025-08-04 21:38:00","inspection_id":"85392974","dot_number":"919321","report_state":"WV","report_number":"PSC1411692","insp_date":"2025-08-01 00:00:00","insp_start_time":"1105","insp_end_time":"1120","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HURRICANE WV","county_code_state":"WV","county_code":"079","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"45000","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":"2081345","transaction_code":"A","transaction_date":"2025-08-03 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2025-08-04 21:38:00","snet_input_date":"2025-08-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-04 21:38:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:43.000000Z","updated_at":"2025-08-08T10:00:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15344835,"change_date":"2025-08-04 21:38:00","inspection_id":"85392974","insp_unit_id":"208215086","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"01","insp_unit_license":"3LL843","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL1RG182807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:23.000000Z","updated_at":"2025-08-08T09:45:17.000000Z"}]},{"id":9225718,"change_date":"2025-08-04 21:39:00","inspection_id":"85296242","dot_number":"919321","report_state":"PA","report_number":"B125520343","insp_date":"2025-07-22 00:00:00","insp_start_time":"1508","insp_end_time":"1545","registration_date":"2025-08-04 00:00:00","region":"ET","ci_status_code":"C","location":"466","location_desc":"SR 79 SB LONE PINE WEIGH STATI","county_code_state":"PA","county_code":"125","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"45000","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":"2531686","transaction_code":"C","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2025-07-23 21:42:00","snet_input_date":"2025-07-22 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-07-23 21:42:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"PO BOX 581270","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74158","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:37.000000Z","updated_at":"2025-08-08T10:00:40.000000Z","inspection_violations":[{"id":15126011,"change_date":"2025-08-04 21:39:00","inspection_id":"85296242","insp_violation_id":"267825572","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208226609","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-07T10:45:34.000000Z","updated_at":"2025-08-08T10:43:44.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":15352168,"change_date":"2025-08-04 21:39:00","inspection_id":"85296242","insp_unit_id":"208226609","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"3LL843","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL1RG182807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:30.000000Z","updated_at":"2025-08-08T09:45:48.000000Z"}]},{"id":8975099,"change_date":"2025-06-24 21:41:00","inspection_id":"85032672","dot_number":"919321","report_state":"TX","report_number":"76BA9DUE21","insp_date":"2025-06-17 00:00:00","insp_start_time":"1016","insp_end_time":"1112","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4020  KERMIT HEY","county_code_state":"TX","county_code":"135","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INDUSTRIAL PIPING SPECIALISTS","shipping_paper_number":"M0138553-1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"43500","viol_total":"7","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9615116","transaction_code":"A","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2025-06-24 21:41:00","snet_input_date":"2025-06-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-24 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-06-28T10:00:55.000000Z","updated_at":"2025-06-28T10:00:55.000000Z","inspection_violations":[{"id":14424847,"change_date":"2025-06-24 21:41:00","inspection_id":"85032672","insp_violation_id":"267022851","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207534963","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:34.000000Z","updated_at":"2025-06-28T10:18:09.000000Z","normalized_code":"39378"},{"id":14424848,"change_date":"2025-06-24 21:41:00","inspection_id":"85032672","insp_violation_id":"267022852","seq_no":"2","part_no":"393","part_no_section":"43D","insp_viol_unit":"1","insp_unit_id":"207534963","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-27T10:17:34.000000Z","updated_at":"2025-06-28T10:18:09.000000Z","normalized_code":"39343D"},{"id":14424849,"change_date":"2025-06-24 21:41:00","inspection_id":"85032672","insp_violation_id":"267022853","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"207534963","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-27T10:17:34.000000Z","updated_at":"2025-06-28T10:18:09.000000Z","normalized_code":"39375A3TAOL"},{"id":14424850,"change_date":"2025-06-24 21:41:00","inspection_id":"85032672","insp_violation_id":"267022854","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"207534964","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-27T10:17:34.000000Z","updated_at":"2025-06-28T10:18:09.000000Z","normalized_code":"39375A3TAOL"},{"id":14424851,"change_date":"2025-06-24 21:41:00","inspection_id":"85032672","insp_violation_id":"267022855","seq_no":"5","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"207534964","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:34.000000Z","updated_at":"2025-06-28T10:18:09.000000Z","normalized_code":"39375A3TAOL"},{"id":14424852,"change_date":"2025-06-24 21:41:00","inspection_id":"85032672","insp_violation_id":"267022856","seq_no":"6","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"2","insp_unit_id":"207534964","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:34.000000Z","updated_at":"2025-06-28T10:18:09.000000Z","normalized_code":"39021A"},{"id":14424853,"change_date":"2025-06-24 21:41:00","inspection_id":"85032672","insp_violation_id":"267022857","seq_no":"7","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"207534963","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:34.000000Z","updated_at":"2025-06-28T10:18:09.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":14715180,"change_date":"2025-06-24 21:41:00","inspection_id":"85032672","insp_unit_id":"207534964","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STAV","insp_unit_company":null,"insp_unit_license":"099B658","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13YFS4223CC117714","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:40.000000Z","updated_at":"2025-06-28T09:46:05.000000Z"},{"id":14715179,"change_date":"2025-06-24 21:41:00","inspection_id":"85032672","insp_unit_id":"207534963","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"2","insp_unit_license":"3DY202","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL9KG549393","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:40.000000Z","updated_at":"2025-06-28T09:46:05.000000Z"}]},{"id":8677707,"change_date":"2025-05-19 21:40:00","inspection_id":"84717332","dot_number":"919321","report_state":"PA","report_number":"E319513510","insp_date":"2025-05-15 00:00:00","insp_start_time":"1015","insp_end_time":"1101","registration_date":null,"region":"ET","ci_status_code":"C","location":"093","location_desc":"I80 WB MM 24 WOLF CREEK TWP -","county_code_state":"PA","county_code":"085","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2518004","transaction_code":"A","transaction_date":"2025-05-16 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2025-05-19 21:40:00","snet_input_date":"2025-05-15 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-05-19 21:40:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"PO BOX 581270","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74158","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-22T10:01:38.000000Z","updated_at":"2025-05-23T10:05:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14176366,"change_date":"2025-05-19 21:40:00","inspection_id":"84717332","insp_unit_id":"206944970","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3LL842","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCLXRG364263","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:46:20.000000Z","updated_at":"2025-05-23T09:50:43.000000Z"}]},{"id":8333323,"change_date":"2025-04-09 21:41:00","inspection_id":"84354520","dot_number":"919321","report_state":"TX","report_number":"74599DGXQQ","insp_date":"2025-03-31 00:00:00","insp_start_time":"1135","insp_end_time":"1205","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5400  GENOA RED BLUF","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PRO STAR","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":"Y","pen_cen_match":null,"final_status_date":"2025-04-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","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":"9544685","transaction_code":"A","transaction_date":"2025-04-09 00:00:00","upload_date":"2025-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2025-04-09 21:41:00","snet_input_date":"2025-03-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-09 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-04-12T10:24:41.000000Z","updated_at":"2025-04-14T10:26:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13517324,"change_date":"2025-04-09 21:41:00","inspection_id":"84354520","insp_unit_id":"206229801","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"40354","insp_unit_license":"3DY203","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRMCL2KG640354","insp_unit_decal":"Y","insp_unit_decal_number":"34869970","created_at":"2025-04-12T10:14:15.000000Z","updated_at":"2025-04-13T10:07:06.000000Z"},{"id":13517325,"change_date":"2025-04-09 21:41:00","inspection_id":"84354520","insp_unit_id":"206229802","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TPHT","insp_unit_company":"2","insp_unit_license":"AJ1037","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G0402XJT168285","insp_unit_decal":"Y","insp_unit_decal_number":"34869971","created_at":"2025-04-12T10:14:15.000000Z","updated_at":"2025-04-13T10:07:06.000000Z"}]},{"id":8214901,"change_date":"2025-05-06 21:40:00","inspection_id":"84229961","dot_number":"919321","report_state":"PA","report_number":"XL00080410","insp_date":"2025-03-25 00:00:00","insp_start_time":"1430","insp_end_time":"1455","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"US 422 @ NCST","county_code_state":"PA","county_code":"073","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","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":"2504164","transaction_code":"C","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2025-03-26 21:41:00","snet_input_date":"2025-03-25 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-03-26 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"PO BOX 581270","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74158","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-29T10:21:57.000000Z","updated_at":"2025-05-10T10:51:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13919342,"change_date":"2025-05-06 21:40:00","inspection_id":"84229961","insp_unit_id":"206666612","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"46406","insp_unit_license":"3DJ222","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCLXKG546406","insp_unit_decal":"Y","insp_unit_decal_number":"34193559","created_at":"2025-05-09T10:11:42.000000Z","updated_at":"2025-05-10T09:59:29.000000Z"}]},{"id":8012808,"change_date":"2025-03-03 21:38:00","inspection_id":"84017231","dot_number":"919321","report_state":"TX","report_number":"V251798376","insp_date":"2025-02-26 00:00:00","insp_start_time":"1156","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 124 @ BISD STADIU","county_code_state":"TX","county_code":"245","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"X","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":"Y","pen_cen_match":null,"final_status_date":"2025-03-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"31500","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":"9511681","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2025-03-03 21:38:00","snet_input_date":"2025-02-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-03 21:38:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T21:04:31.000000Z","updated_at":"2025-03-17T21:04:31.000000Z","inspection_violations":[{"id":12523204,"change_date":"2025-03-03 21:38:00","inspection_id":"84017231","insp_violation_id":"264806716","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"205600595","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:15.000000Z","updated_at":"2025-03-17T22:07:15.000000Z","normalized_code":"39021A"},{"id":12523205,"change_date":"2025-03-03 21:38:00","inspection_id":"84017231","insp_violation_id":"264806717","seq_no":"2","part_no":"393","part_no_section":"43D","insp_viol_unit":"1","insp_unit_id":"205600595","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:07:15.000000Z","updated_at":"2025-03-17T22:07:15.000000Z","normalized_code":"39343D"}],"inspection_per_units":[{"id":12936406,"change_date":"2025-03-03 21:38:00","inspection_id":"84017231","insp_unit_id":"205600595","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"1","insp_unit_license":"3LF972","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL7KG540945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:54.000000Z","updated_at":"2025-03-17T23:57:54.000000Z"},{"id":12936407,"change_date":"2025-03-03 21:38:00","inspection_id":"84017231","insp_unit_id":"205600596","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TPHT","insp_unit_company":"1","insp_unit_license":"AE7688","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G04022HT163754","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:54.000000Z","updated_at":"2025-03-17T23:57:54.000000Z"}]},{"id":7740944,"change_date":"2025-01-29 21:41:00","inspection_id":"83731605","dot_number":"919321","report_state":"TX","report_number":"72FG9DDM6G","insp_date":"2025-01-28 00:00:00","insp_start_time":"1045","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0124 IN JEFFERSON CO. (456-","county_code_state":"TX","county_code":"245","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"IPS","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":"Y","pen_cen_match":null,"final_status_date":"2025-01-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","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":"9486055","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2025-01-29 21:41:00","snet_input_date":"2025-01-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-29 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T20:59:05.000000Z","updated_at":"2025-03-17T20:59:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12491999,"change_date":"2025-01-29 21:41:00","inspection_id":"83731605","insp_unit_id":"205068920","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"31F972","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL7KE40945","insp_unit_decal":"Y","insp_unit_decal_number":"03486655","created_at":"2025-03-17T23:52:51.000000Z","updated_at":"2025-03-17T23:52:51.000000Z"},{"id":12492000,"change_date":"2025-01-29 21:41:00","inspection_id":"83731605","insp_unit_id":"205068921","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TPHT","insp_unit_company":null,"insp_unit_license":"AE7688","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G04022HT163754","insp_unit_decal":"Y","insp_unit_decal_number":"03486656","created_at":"2025-03-17T23:52:51.000000Z","updated_at":"2025-03-17T23:52:51.000000Z"}]},{"id":7666069,"change_date":"2025-01-20 21:34:00","inspection_id":"83653190","dot_number":"919321","report_state":"OK","report_number":"I404154579","insp_date":"2025-01-20 00:00:00","insp_start_time":"1028","insp_end_time":"1052","registration_date":null,"region":"CT","ci_status_code":"C","location":"200I40","location_desc":"CLINTON","county_code_state":"OK","county_code":"039","insp_level_id":"1","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":"2025-01-20 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","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":"773862","transaction_code":"A","transaction_date":"2025-01-20 00:00:00","upload_date":"2025-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2025-01-20 21:34:00","snet_input_date":"2025-01-20 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-01-20 21:34:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:26.000000Z","updated_at":"2025-03-17T20:57:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12370206,"change_date":"2025-01-20 21:34:00","inspection_id":"83653190","insp_unit_id":"204923141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"EL10","insp_unit_license":"3CQ311","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL6JG342636","insp_unit_decal":"Y","insp_unit_decal_number":"34959529","created_at":"2025-03-17T23:51:32.000000Z","updated_at":"2025-03-17T23:51:32.000000Z"},{"id":12370207,"change_date":"2025-01-20 21:34:00","inspection_id":"83653190","insp_unit_id":"204923142","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOP H","insp_unit_company":"G1","insp_unit_license":"AJ1065","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G04025JT168615","insp_unit_decal":"Y","insp_unit_decal_number":"34959530","created_at":"2025-03-17T23:51:32.000000Z","updated_at":"2025-03-17T23:51:32.000000Z"}]},{"id":7588707,"change_date":"2025-01-10 21:39:00","inspection_id":"83571893","dot_number":"919321","report_state":"OH","report_number":"3241000159","insp_date":"2025-01-07 00:00:00","insp_start_time":"1145","insp_end_time":"1215","registration_date":null,"region":"ES","ci_status_code":"C","location":"01","location_desc":"CAMBRIDGE OH","county_code_state":"OH","county_code":"059","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"01072025","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-10 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":"1232784","transaction_code":"A","transaction_date":"2025-01-10 00:00:00","upload_date":"2025-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2025-01-10 21:39:00","snet_input_date":"2025-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-10 21:39:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:41.000000Z","updated_at":"2025-03-17T20:55:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12244650,"change_date":"2025-01-10 21:39:00","inspection_id":"83571893","insp_unit_id":"204739544","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"PWZ6973","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALHCYCY3FDGM6134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:08.000000Z","updated_at":"2025-03-17T23:50:08.000000Z"}]},{"id":7532202,"change_date":"2025-01-02 21:38:00","inspection_id":"83512535","dot_number":"919321","report_state":"ND","report_number":"FT39000575","insp_date":"2024-12-31 00:00:00","insp_start_time":"1321","insp_end_time":"1336","registration_date":null,"region":"CS","ci_status_code":"C","location":"PANGER","location_desc":"WILLISTON ND","county_code_state":"ND","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"42000","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":"1210045","transaction_code":"A","transaction_date":"2025-01-02 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2025-01-02 21:38:00","snet_input_date":"2024-12-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-02 21:38:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:12.000000Z","updated_at":"2025-03-17T20:53:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12151815,"change_date":"2025-01-02 21:38:00","inspection_id":"83512535","insp_unit_id":"204617998","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"TUL401","insp_unit_license":"3AN031","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL5HG635700","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:10.000000Z","updated_at":"2025-03-17T23:49:10.000000Z"},{"id":12151816,"change_date":"2025-01-02 21:38:00","inspection_id":"83512535","insp_unit_id":"204617999","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAXE","insp_unit_company":null,"insp_unit_license":"AB2780","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5R8GD4024HM046889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:10.000000Z","updated_at":"2025-03-17T23:49:10.000000Z"}]},{"id":6925132,"change_date":"2024-10-09 21:42:00","inspection_id":"82871200","dot_number":"919321","report_state":"TX","report_number":"V241608539","insp_date":"2024-10-08 00:00:00","insp_start_time":"0758","insp_end_time":"0828","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1430  US80","county_code_state":"TX","county_code":"183","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INDUSTRIAL PIPING SPECIALISTS","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":"Y","pen_cen_match":null,"final_status_date":"2024-10-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"39500","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":"9398385","transaction_code":"A","transaction_date":"2024-10-09 00:00:00","upload_date":"2024-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2024-10-09 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-09 21:42:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T20:40:37.000000Z","updated_at":"2025-03-17T20:40:37.000000Z","inspection_violations":[{"id":10794135,"change_date":"2024-10-09 21:42:00","inspection_id":"82871200","insp_violation_id":"262274486","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"203342721","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:16.000000Z","updated_at":"2025-03-17T21:58:16.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":11168731,"change_date":"2024-10-09 21:42:00","inspection_id":"82871200","insp_unit_id":"203342721","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"TY101","insp_unit_license":"2WJ614","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL0FG539576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:39.000000Z","updated_at":"2025-03-17T23:38:39.000000Z"},{"id":11168732,"change_date":"2024-10-09 21:42:00","inspection_id":"82871200","insp_unit_id":"203342722","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STAR","insp_unit_company":null,"insp_unit_license":"Y77452","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13YFS4025AC114801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:39.000000Z","updated_at":"2025-03-17T23:38:39.000000Z"}]},{"id":6905121,"change_date":"2024-10-07 21:41:00","inspection_id":"82850002","dot_number":"919321","report_state":"TX","report_number":"V241592895","insp_date":"2024-10-03 00:00:00","insp_start_time":"1238","insp_end_time":"1323","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"9395061","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2024-10-07 21:41:00","snet_input_date":"2024-10-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-07 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T20:40:12.000000Z","updated_at":"2025-03-17T20:40:12.000000Z","inspection_violations":[{"id":10760646,"change_date":"2024-10-07 21:41:00","inspection_id":"82850002","insp_violation_id":"262229092","seq_no":"1","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"203303082","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39355E"},{"id":10760647,"change_date":"2024-10-07 21:41:00","inspection_id":"82850002","insp_violation_id":"262229093","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"203303081","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":11136470,"change_date":"2024-10-07 21:41:00","inspection_id":"82850002","insp_unit_id":"203303081","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"3BS167","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJGEDV9JLJZ4605","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:21.000000Z","updated_at":"2025-03-17T23:38:21.000000Z"},{"id":11136471,"change_date":"2024-10-07 21:41:00","inspection_id":"82850002","insp_unit_id":"203303082","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":"01","insp_unit_license":"189B675","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L01B452071164516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:21.000000Z","updated_at":"2025-03-17T23:38:21.000000Z"}]},{"id":6781607,"change_date":"2024-09-20 21:43:00","inspection_id":"82718843","dot_number":"919321","report_state":"TX","report_number":"6YKA9DGX8G","insp_date":"2024-09-11 00:00:00","insp_start_time":"1016","insp_end_time":"1035","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7800  FAIRMONT PKWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INDUSTRIAL PIPING SPECIALISTS","shipping_paper_number":"E0113444-1","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-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"51800","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":"9382485","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2024-09-20 21:43:00","snet_input_date":"2024-09-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-20 21:43:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T20:37:42.000000Z","updated_at":"2025-03-17T20:37:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10935890,"change_date":"2024-09-20 21:43:00","inspection_id":"82718843","insp_unit_id":"203055658","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3DY203","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G0402XJT168285","insp_unit_decal":"Y","insp_unit_decal_number":"34254933","created_at":"2025-03-17T23:36:18.000000Z","updated_at":"2025-03-17T23:36:18.000000Z"},{"id":10935891,"change_date":"2024-09-20 21:43:00","inspection_id":"82718843","insp_unit_id":"203055659","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TPHT","insp_unit_company":"02","insp_unit_license":"AJ1037","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G0402XJT168285","insp_unit_decal":"Y","insp_unit_decal_number":"34254934","created_at":"2025-03-17T23:36:18.000000Z","updated_at":"2025-03-17T23:36:18.000000Z"}]},{"id":6369651,"change_date":"2024-08-01 21:41:00","inspection_id":"82279325","dot_number":"919321","report_state":"OK","report_number":"A910153593","insp_date":"2024-08-01 00:00:00","insp_start_time":"1018","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":"026062","location_desc":"US 81\/US 62","county_code_state":"OK","county_code":"051","insp_level_id":"1","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":"2024-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"44500","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":"756651","transaction_code":"A","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2024-08-01 21:41:00","snet_input_date":"2024-08-01 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-08-01 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:06.000000Z","updated_at":"2025-03-17T20:29:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10264592,"change_date":"2024-08-01 21:41:00","inspection_id":"82279325","insp_unit_id":"202193355","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"T5500-2","insp_unit_license":"3EB999","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL9KG667427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:19.000000Z","updated_at":"2025-03-17T23:29:19.000000Z"},{"id":10264593,"change_date":"2024-08-01 21:41:00","inspection_id":"82279325","insp_unit_id":"202193356","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELT","insp_unit_company":"T105","insp_unit_license":"AX6257","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4MWGF402XDN032672","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:19.000000Z","updated_at":"2025-03-17T23:29:19.000000Z"}]},{"id":6249265,"change_date":"2024-07-18 21:40:00","inspection_id":"82150656","dot_number":"919321","report_state":"OK","report_number":"R107150847","insp_date":"2024-07-18 00:00:00","insp_start_time":"1028","insp_end_time":"1048","registration_date":null,"region":"CT","ci_status_code":"C","location":"26081","location_desc":"HWY 82 NB AT HWY 152","county_code_state":"OK","county_code":"051","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"44900","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":"754766","transaction_code":"A","transaction_date":"2024-07-18 00:00:00","upload_date":"2024-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2024-07-18 21:40:00","snet_input_date":"2024-07-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:37.000000Z","updated_at":"2025-03-17T20:26:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10069075,"change_date":"2024-07-18 21:40:00","inspection_id":"82150656","insp_unit_id":"201948341","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"D5500-2","insp_unit_license":"3EB999","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL9KG667427","insp_unit_decal":"Y","insp_unit_decal_number":"34374789","created_at":"2025-03-17T23:27:17.000000Z","updated_at":"2025-03-17T23:27:17.000000Z"},{"id":10069076,"change_date":"2024-07-18 21:40:00","inspection_id":"82150656","insp_unit_id":"201948342","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELTA","insp_unit_company":"T-105","insp_unit_license":"AX6257","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4MWGF402XDN032672","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:17.000000Z","updated_at":"2025-03-17T23:27:17.000000Z"}]},{"id":6155591,"change_date":"2024-07-06 21:31:00","inspection_id":"82049825","dot_number":"919321","report_state":"OK","report_number":"P113155159","insp_date":"2024-07-05 00:00:00","insp_start_time":"0922","insp_end_time":"0946","registration_date":null,"region":"CT","ci_status_code":"C","location":"73CRT","location_desc":"CREEK TP @ MM 27","county_code_state":"OK","county_code":"145","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"T0552772","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-06 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"125350","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":"753241","transaction_code":"A","transaction_date":"2024-07-06 00:00:00","upload_date":"2024-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2024-07-06 21:31:00","snet_input_date":"2024-07-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-07-06 21:31:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:38.000000Z","updated_at":"2025-03-17T20:24:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9915720,"change_date":"2024-07-06 21:31:00","inspection_id":"82049825","insp_unit_id":"201752970","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"S1","insp_unit_license":"3JL039","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJHLDR7PDUH9496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:48.000000Z","updated_at":"2025-03-17T23:25:48.000000Z"},{"id":9915721,"change_date":"2024-07-06 21:31:00","inspection_id":"82049825","insp_unit_id":"201752971","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"AJ1464","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1TTF482S8J3065775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:48.000000Z","updated_at":"2025-03-17T23:25:48.000000Z"}]},{"id":6039976,"change_date":"2024-06-20 21:44:00","inspection_id":"81925652","dot_number":"919321","report_state":"PA","report_number":"E938417175","insp_date":"2024-06-19 00:00:00","insp_start_time":"1505","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON UNNAMED STREET 348 FEET EAS","county_code_state":"PA","county_code":"033","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-20 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","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":"2451480","transaction_code":"A","transaction_date":"2024-06-19 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2024-06-20 21:44:00","snet_input_date":"2024-06-19 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-06-20 21:44:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"PO BOX 581270","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74158","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:18.000000Z","updated_at":"2025-03-17T20:22:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9728256,"change_date":"2024-06-20 21:44:00","inspection_id":"81925652","insp_unit_id":"201513095","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PWZ6973","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALHCYCY3FDGM6134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:47.000000Z","updated_at":"2025-03-17T23:23:47.000000Z"}]},{"id":5846326,"change_date":"2024-05-28 21:42:00","inspection_id":"81715514","dot_number":"919321","report_state":"CO","report_number":"1112380477","insp_date":"2024-05-22 00:00:00","insp_start_time":"1241","insp_end_time":"1325","registration_date":null,"region":"MD","ci_status_code":"C","location":"FCPESB","location_desc":"FORT COLLINS CO","county_code_state":"CO","county_code":"069","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"518516","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2024-05-28 21:42:00","snet_input_date":"2024-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-28 21:42:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:39.000000Z","updated_at":"2025-03-17T20:18:39.000000Z","inspection_violations":[{"id":9061980,"change_date":"2024-05-28 21:42:00","inspection_id":"81715514","insp_violation_id":"259738609","seq_no":"1","part_no":"390","part_no_section":"21T(b)(1)","insp_viol_unit":"1","insp_unit_id":"201092288","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:49.000000Z","updated_at":"2025-03-17T21:49:49.000000Z","normalized_code":"39021TB1"},{"id":9061981,"change_date":"2024-05-28 21:42:00","inspection_id":"81715514","insp_violation_id":"259738610","seq_no":"2","part_no":"390","part_no_section":"21T(b)(2)","insp_viol_unit":"1","insp_unit_id":"201092288","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:49.000000Z","updated_at":"2025-03-17T21:49:49.000000Z","normalized_code":"39021TB2"},{"id":9061982,"change_date":"2024-05-28 21:42:00","inspection_id":"81715514","insp_violation_id":"259738611","seq_no":"3","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"201092288","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"212410196","created_at":"2025-03-17T21:49:49.000000Z","updated_at":"2025-03-17T21:49:49.000000Z","normalized_code":"39341"},{"id":9061983,"change_date":"2024-05-28 21:42:00","inspection_id":"81715514","insp_violation_id":"259738612","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"201092289","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:49.000000Z","updated_at":"2025-03-17T21:49:49.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9415930,"change_date":"2024-05-28 21:42:00","inspection_id":"81715514","insp_unit_id":"201092288","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"LVND 2","insp_unit_license":"2WZ590","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FDUF5HTXEEB11866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:44.000000Z","updated_at":"2025-03-17T23:20:44.000000Z"},{"id":9415931,"change_date":"2024-05-28 21:42:00","inspection_id":"81715514","insp_unit_id":"201092289","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"1","insp_unit_license":"6939GX","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VGX4021F6082043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:44.000000Z","updated_at":"2025-03-17T23:20:44.000000Z"}]},{"id":5774751,"change_date":"2024-05-17 21:39:00","inspection_id":"81637848","dot_number":"919321","report_state":"WV","report_number":"PSC0560175","insp_date":"2024-05-15 00:00:00","insp_start_time":"1412","insp_end_time":"1445","registration_date":null,"region":"ED","ci_status_code":"C","location":"I064EB","location_desc":"HURRICANE WEIGH STATION EB","county_code_state":"WV","county_code":"079","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"490737","transaction_code":"A","transaction_date":"2024-05-17 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2024-05-17 21:39:00","snet_input_date":"2024-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-17 21:39:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:07.000000Z","updated_at":"2025-03-17T20:17:07.000000Z","inspection_violations":[{"id":8941159,"change_date":"2024-05-17 21:39:00","inspection_id":"81637848","insp_violation_id":"259565958","seq_no":"1","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"200945677","insp_violation_category_id":"20","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":"39311A1"}],"inspection_per_units":[{"id":9301225,"change_date":"2024-05-17 21:39:00","inspection_id":"81637848","insp_unit_id":"200945677","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"3DY237","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL8KG546405","insp_unit_decal":"Y","insp_unit_decal_number":"34073870","created_at":"2025-03-17T23:19:36.000000Z","updated_at":"2025-03-17T23:19:36.000000Z"}]},{"id":5588874,"change_date":"2024-04-24 21:42:00","inspection_id":"81435873","dot_number":"919321","report_state":"TX","report_number":"6UI99DBBV7","insp_date":"2024-04-18 00:00:00","insp_start_time":"0949","insp_end_time":"1016","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INDUSTRIAL PIPING SPECIALISTS","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":"Y","pen_cen_match":null,"final_status_date":"2024-04-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","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":"9256104","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2024-04-24 21:42:00","snet_input_date":"2024-04-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-24 21:42:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T20:13:30.000000Z","updated_at":"2025-03-17T20:13:30.000000Z","inspection_violations":[{"id":8640810,"change_date":"2024-04-24 21:42:00","inspection_id":"81435873","insp_violation_id":"259122044","seq_no":"1","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"200558522","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:52.000000Z","updated_at":"2025-03-17T21:47:52.000000Z","normalized_code":"393100A"}],"inspection_per_units":[{"id":9002403,"change_date":"2024-04-24 21:42:00","inspection_id":"81435873","insp_unit_id":"200558521","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3DY203","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3C7WRMCL2KG640354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:46.000000Z","updated_at":"2025-03-17T23:16:46.000000Z"},{"id":9002404,"change_date":"2024-04-24 21:42:00","inspection_id":"81435873","insp_unit_id":"200558522","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TPHT","insp_unit_company":null,"insp_unit_license":"AJ1037","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G0402XJT168285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:46.000000Z","updated_at":"2025-03-17T23:16:46.000000Z"}]},{"id":5555573,"change_date":"2024-04-20 21:32:00","inspection_id":"81399584","dot_number":"919321","report_state":"WV","report_number":"PSC1500131","insp_date":"2024-04-09 00:00:00","insp_start_time":"1250","insp_end_time":"1321","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MINERAL WELLS WV","county_code_state":"WV","county_code":"107","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"FAZALARE ENGINEERING","shipping_paper_number":"4851","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-20 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"19000","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":"391463","transaction_code":"A","transaction_date":"2024-04-12 00:00:00","upload_date":"2024-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2024-04-20 21:32:00","snet_input_date":"2024-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-20 21:32:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:47.000000Z","updated_at":"2025-03-17T20:12:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8948689,"change_date":"2024-04-20 21:32:00","inspection_id":"81399584","insp_unit_id":"200489707","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"46405","insp_unit_license":"3DY237","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL8KG546405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:15.000000Z","updated_at":"2025-03-17T23:16:15.000000Z"}]},{"id":5424503,"change_date":"2024-04-03 21:41:00","inspection_id":"81256447","dot_number":"919321","report_state":"OK","report_number":"K300181566","insp_date":"2024-04-03 00:00:00","insp_start_time":"0958","insp_end_time":"1018","registration_date":null,"region":"CT","ci_status_code":"C","location":"49069","location_desc":"US 412 \/ S 428 RD","county_code_state":"OK","county_code":"097","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"T5439555-1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","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":"742555","transaction_code":"A","transaction_date":"2024-04-03 00:00:00","upload_date":"2024-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2024-04-03 21:41:00","snet_input_date":"2024-04-03 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-04-03 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:16.000000Z","updated_at":"2025-03-17T20:10:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8737363,"change_date":"2024-04-03 21:41:00","inspection_id":"81256447","insp_unit_id":"200214190","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3JL039","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJHLDR7PDUH9496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:16.000000Z","updated_at":"2025-03-17T23:14:16.000000Z"},{"id":8737364,"change_date":"2024-04-03 21:41:00","inspection_id":"81256447","insp_unit_id":"200214191","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"AJ1464","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1TTF482S8J3065775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:16.000000Z","updated_at":"2025-03-17T23:14:16.000000Z"}]},{"id":5392479,"change_date":"2024-03-28 21:41:00","inspection_id":"81221299","dot_number":"919321","report_state":"PA","report_number":"XL00066459","insp_date":"2024-03-27 00:00:00","insp_start_time":"1515","insp_end_time":"1550","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"US 422 @ PINE GLENN RD","county_code_state":"PA","county_code":"073","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","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":"2429818","transaction_code":"A","transaction_date":"2024-03-27 00:00:00","upload_date":"2024-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2024-03-28 21:41:00","snet_input_date":"2024-03-27 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-03-28 21:41:00","insp_carrier_name":"INDUSTRIAL PIPPING SPECIALISTS, INC","insp_carrier_street":"606 N 145TH EAST AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:28.000000Z","updated_at":"2025-03-17T20:09:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8684857,"change_date":"2024-03-28 21:41:00","inspection_id":"81221299","insp_unit_id":"200142130","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"3DJ222","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCLXKG546406","insp_unit_decal":"Y","insp_unit_decal_number":"33661198","created_at":"2025-03-17T23:13:45.000000Z","updated_at":"2025-03-17T23:13:45.000000Z"}]},{"id":5340298,"change_date":"2024-03-27 21:42:00","inspection_id":"81164701","dot_number":"919321","report_state":"WY","report_number":"PTRR001144","insp_date":"2024-03-21 00:00:00","insp_start_time":"0721","insp_end_time":"0812","registration_date":"2024-03-27 00:00:00","region":"MT","ci_status_code":"C","location":"ML253B","location_desc":"WY253","county_code_state":"WY","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"L&L ENTERPRISES","shipping_paper_number":"CA997631","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"444014","transaction_code":"C","transaction_date":"2024-03-27 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2024-03-21 21:41:00","snet_input_date":"2024-03-21 00:00:00","source_office":"4WYS001","mcmis_add_date":"2024-03-21 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:37.000000Z","updated_at":"2025-03-17T20:08:37.000000Z","inspection_violations":[{"id":8240591,"change_date":"2024-03-27 21:42:00","inspection_id":"81164701","insp_violation_id":"258619267","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200120219","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"3922"},{"id":8240592,"change_date":"2024-03-27 21:42:00","inspection_id":"81164701","insp_violation_id":"258619268","seq_no":"2","part_no":"393","part_no_section":"100(c)","insp_viol_unit":"1","insp_unit_id":"200120219","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"393100C"},{"id":8240593,"change_date":"2024-03-27 21:42:00","inspection_id":"81164701","insp_violation_id":"258619269","seq_no":"3","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:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":8600473,"change_date":"2024-03-27 21:42:00","inspection_id":"81164701","insp_unit_id":"200120219","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"3EX586","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD4F5HT4JDA01217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:01.000000Z","updated_at":"2025-03-17T23:13:01.000000Z"},{"id":8600474,"change_date":"2024-03-27 21:42:00","inspection_id":"81164701","insp_unit_id":"200120220","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ETXL","insp_unit_company":null,"insp_unit_license":"AJ1251","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5J2GS4022HE018897","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:01.000000Z","updated_at":"2025-03-17T23:13:01.000000Z"}]},{"id":5104162,"change_date":"2024-02-22 21:43:00","inspection_id":"80907126","dot_number":"919321","report_state":"TX","report_number":"6SRB9DAP9Z","insp_date":"2024-02-15 00:00:00","insp_start_time":"1157","insp_end_time":"1218","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"IPS","shipping_paper_number":"HP494161","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","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":"9202572","transaction_code":"C","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2024-02-21 21:40:00","snet_input_date":"2024-02-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-21 21:40:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T20:03:47.000000Z","updated_at":"2025-03-17T20:03:47.000000Z","inspection_violations":[{"id":7872283,"change_date":"2024-02-22 21:43:00","inspection_id":"80907126","insp_violation_id":"257993675","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"199560031","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:44:02.000000Z","updated_at":"2025-03-17T21:44:02.000000Z","normalized_code":"393207A"},{"id":7872284,"change_date":"2024-02-22 21:43:00","inspection_id":"80907126","insp_violation_id":"257993676","seq_no":"2","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"199560031","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:02.000000Z","updated_at":"2025-03-17T21:44:02.000000Z","normalized_code":"393207A"},{"id":7872285,"change_date":"2024-02-22 21:43:00","inspection_id":"80907126","insp_violation_id":"257993677","seq_no":"3","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"199560031","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:02.000000Z","updated_at":"2025-03-17T21:44:02.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":8217471,"change_date":"2024-02-22 21:43:00","inspection_id":"80907126","insp_unit_id":"199560030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3DY203","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL2KG640354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:28.000000Z","updated_at":"2025-03-17T23:09:28.000000Z"},{"id":8217472,"change_date":"2024-02-22 21:43:00","inspection_id":"80907126","insp_unit_id":"199560031","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TPHT","insp_unit_company":"2","insp_unit_license":"AJ1037","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G0402XJT168285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:28.000000Z","updated_at":"2025-03-17T23:09:28.000000Z"}]},{"id":4385830,"change_date":"2023-11-08 21:41:00","inspection_id":"80120309","dot_number":"919321","report_state":"PA","report_number":"M245200249","insp_date":"2023-11-07 00:00:00","insp_start_time":"1450","insp_end_time":"1525","registration_date":null,"region":"ET","ci_status_code":"C","location":"37","location_desc":"422 W @ NCST","county_code_state":"PA","county_code":"073","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-11-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2395301","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2023-11-08 21:41:00","snet_input_date":"2023-11-08 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-11-08 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"PO BOX 581270","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74158","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:51.000000Z","updated_at":"2025-03-17T19:49:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7053639,"change_date":"2023-11-08 21:41:00","inspection_id":"80120309","insp_unit_id":"197974810","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3DJ222","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCLXKG546406","insp_unit_decal":"Y","insp_unit_decal_number":"33365406","created_at":"2025-03-17T22:59:12.000000Z","updated_at":"2025-03-17T22:59:12.000000Z"}]},{"id":4124118,"change_date":"2023-10-04 21:41:00","inspection_id":"79830853","dot_number":"919321","report_state":"OK","report_number":"Z600210802","insp_date":"2023-10-02 00:00:00","insp_start_time":"1351","insp_end_time":"1429","registration_date":null,"region":"CT","ci_status_code":"C","location":"14035","location_desc":"I-35 S\/B AND MM112","county_code_state":"OK","county_code":"027","insp_level_id":"1","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":"2023-10-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"44900","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":"724362","transaction_code":"A","transaction_date":"2023-10-03 00:00:00","upload_date":"2023-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2023-10-04 21:41:00","snet_input_date":"2023-10-02 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-10-04 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:25.000000Z","updated_at":"2025-03-17T19:44:25.000000Z","inspection_violations":[{"id":6382515,"change_date":"2023-10-04 21:41:00","inspection_id":"79830853","insp_violation_id":"255653780","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197393909","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:47.000000Z","updated_at":"2025-03-17T21:36:47.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6630684,"change_date":"2023-10-04 21:41:00","inspection_id":"79830853","insp_unit_id":"197393908","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"3EB999","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL9KG667427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:38.000000Z","updated_at":"2025-03-17T22:55:38.000000Z"},{"id":6630685,"change_date":"2023-10-04 21:41:00","inspection_id":"79830853","insp_unit_id":"197393909","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELTA","insp_unit_company":null,"insp_unit_license":"AX6257","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4MWGF402XDN032672","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:38.000000Z","updated_at":"2025-03-17T22:55:38.000000Z"}]},{"id":4147565,"change_date":"2023-10-06 21:41:00","inspection_id":"79856832","dot_number":"919321","report_state":"TX","report_number":"6OZC9DGXK6","insp_date":"2023-10-02 00:00:00","insp_start_time":"1220","insp_end_time":"1239","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5400  GENOA RED BLUF","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2023-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","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":"9094014","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2023-10-06 21:41:00","snet_input_date":"2023-10-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-06 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T19:44:55.000000Z","updated_at":"2025-03-17T19:44:55.000000Z","inspection_violations":[{"id":6419513,"change_date":"2023-10-06 21:41:00","inspection_id":"79856832","insp_violation_id":"255710527","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197445001","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:55.000000Z","updated_at":"2025-03-17T21:36:55.000000Z","normalized_code":"39395A"},{"id":6419514,"change_date":"2023-10-06 21:41:00","inspection_id":"79856832","insp_violation_id":"255710528","seq_no":"2","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"1","insp_unit_id":"197445001","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:36:55.000000Z","updated_at":"2025-03-17T21:36:55.000000Z","normalized_code":"393100A"}],"inspection_per_units":[{"id":6668931,"change_date":"2023-10-06 21:41:00","inspection_id":"79856832","insp_unit_id":"197445001","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3DY203","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL2KG640354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:55.000000Z","updated_at":"2025-03-17T22:55:55.000000Z"},{"id":6668932,"change_date":"2023-10-06 21:41:00","inspection_id":"79856832","insp_unit_id":"197445002","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TPHT","insp_unit_company":null,"insp_unit_license":"AJ1037","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G0402XJT168285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:55.000000Z","updated_at":"2025-03-17T22:55:55.000000Z"}]},{"id":3533230,"change_date":"2023-07-18 21:42:00","inspection_id":"79171188","dot_number":"919321","report_state":"OK","report_number":"C713154489","insp_date":"2023-07-18 00:00:00","insp_start_time":"1006","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":"009KTP","location_desc":"YUKON","county_code_state":"OK","county_code":"017","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"T0530652-3","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-07-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","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":"716634","transaction_code":"A","transaction_date":"2023-07-18 00:00:00","upload_date":"2023-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2023-07-18 21:42:00","snet_input_date":"2023-07-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-07-18 21:42:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:49.000000Z","updated_at":"2025-03-17T19:32:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5680752,"change_date":"2023-07-18 21:42:00","inspection_id":"79171188","insp_unit_id":"196054578","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"3CQ311","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL6JG342636","insp_unit_decal":"Y","insp_unit_decal_number":"33106224","created_at":"2025-03-17T22:47:50.000000Z","updated_at":"2025-03-17T22:47:50.000000Z"},{"id":5680753,"change_date":"2023-07-18 21:42:00","inspection_id":"79171188","insp_unit_id":"196054579","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOP H","insp_unit_company":null,"insp_unit_license":"AJ1065","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G04025JT168615","insp_unit_decal":"Y","insp_unit_decal_number":"33106225","created_at":"2025-03-17T22:47:50.000000Z","updated_at":"2025-03-17T22:47:50.000000Z"}]},{"id":3524345,"change_date":"2023-07-17 21:41:00","inspection_id":"79161423","dot_number":"919321","report_state":"TX","report_number":"6MN99DBBIF","insp_date":"2023-07-10 00:00:00","insp_start_time":"0902","insp_end_time":"0928","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0249 IN HARRIS CO. (450-470","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INDUSTRIAL PIPING SPEC","shipping_paper_number":"H02090413","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","viol_total":"3","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9029623","transaction_code":"A","transaction_date":"2023-07-17 00:00:00","upload_date":"2023-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2023-07-17 21:41:00","snet_input_date":"2023-07-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-17 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T19:32:46.000000Z","updated_at":"2025-03-17T19:32:46.000000Z","inspection_violations":[{"id":5434838,"change_date":"2023-07-17 21:41:00","inspection_id":"79161423","insp_violation_id":"254102754","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196036877","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:13.000000Z","updated_at":"2025-03-17T21:32:13.000000Z","normalized_code":"3963A1"},{"id":5434839,"change_date":"2023-07-17 21:41:00","inspection_id":"79161423","insp_violation_id":"254102755","seq_no":"2","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"196036878","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:13.000000Z","updated_at":"2025-03-17T21:32:13.000000Z","normalized_code":"39343D"},{"id":5434840,"change_date":"2023-07-17 21:41:00","inspection_id":"79161423","insp_violation_id":"254102756","seq_no":"3","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"196036878","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:32:13.000000Z","updated_at":"2025-03-17T21:32:13.000000Z","normalized_code":"393100A"}],"inspection_per_units":[{"id":5667084,"change_date":"2023-07-17 21:41:00","inspection_id":"79161423","insp_unit_id":"196036877","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3DY203","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL2KG640354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:43.000000Z","updated_at":"2025-03-17T22:47:43.000000Z"},{"id":5667085,"change_date":"2023-07-17 21:41:00","inspection_id":"79161423","insp_unit_id":"196036878","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TPHT","insp_unit_company":null,"insp_unit_license":"AJ1037","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G0402XJT168285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:43.000000Z","updated_at":"2025-03-17T22:47:43.000000Z"}]},{"id":2788386,"change_date":"2023-04-12 21:41:00","inspection_id":"78331114","dot_number":"919321","report_state":"OH","report_number":"1808003968","insp_date":"2023-04-12 00:00:00","insp_start_time":"1013","insp_end_time":"1048","registration_date":null,"region":"ET","ci_status_code":"C","location":"10376","location_desc":"WADSWORTH SCALES","county_code_state":"OH","county_code":"103","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"INDUSTRIAL PIPING SPECIALISTS INC","shipping_paper_number":"ST050640-1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1649988","transaction_code":"A","transaction_date":"2023-04-12 00:00:00","upload_date":"2023-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2023-04-12 21:41:00","snet_input_date":"2023-04-12 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-04-12 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"PO BOX 581270","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74158","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:04.000000Z","updated_at":"2025-03-17T19:18:04.000000Z","inspection_violations":[{"id":4278166,"change_date":"2023-04-12 21:41:00","inspection_id":"78331114","insp_violation_id":"252179141","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194349648","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"39395A"},{"id":4278167,"change_date":"2023-04-12 21:41:00","inspection_id":"78331114","insp_violation_id":"252179142","seq_no":"2","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"2","insp_unit_id":"194349649","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"3929A1"},{"id":4278168,"change_date":"2023-04-12 21:41:00","inspection_id":"78331114","insp_violation_id":"252179143","seq_no":"3","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"2","insp_unit_id":"194349649","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"3929A1"}],"inspection_per_units":[{"id":4488050,"change_date":"2023-04-12 21:41:00","inspection_id":"78331114","insp_unit_id":"194349648","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"ST01","insp_unit_license":"PVU2853","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJGEBG3DSFH2476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:23.000000Z","updated_at":"2025-03-17T22:38:23.000000Z"},{"id":4488051,"change_date":"2023-04-12 21:41:00","inspection_id":"78331114","insp_unit_id":"194349649","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REIT","insp_unit_company":null,"insp_unit_license":"TPY7392","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1RNF48A23DR027690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:23.000000Z","updated_at":"2025-03-17T22:38:23.000000Z"}]},{"id":2770930,"change_date":"2023-04-13 21:43:00","inspection_id":"78311592","dot_number":"919321","report_state":"PA","report_number":"E930309578","insp_date":"2023-04-05 00:00:00","insp_start_time":"0830","insp_end_time":"0930","registration_date":"2023-04-13 00:00:00","region":"ET","ci_status_code":"C","location":"466","location_desc":"SR 79 SB LONE PINE WEIGH STATI","county_code_state":"PA","county_code":"125","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-11 12:05:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2334757","transaction_code":"C","transaction_date":"2023-04-05 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2023-04-11 12:05:00","snet_input_date":"2023-04-05 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-04-11 12:05:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"PO BOX 581270","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74158","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:41.000000Z","updated_at":"2025-03-17T19:17:41.000000Z","inspection_violations":[{"id":4252795,"change_date":"2023-04-13 21:43:00","inspection_id":"78311592","insp_violation_id":"252215606","seq_no":"1","part_no":"393","part_no_section":"45(a)","insp_viol_unit":"1","insp_unit_id":"194379893","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"T9978235-1","created_at":"2025-03-17T21:26:53.000000Z","updated_at":"2025-03-17T21:26:53.000000Z","normalized_code":"39345A"},{"id":4252796,"change_date":"2023-04-13 21:43:00","inspection_id":"78311592","insp_violation_id":"252215607","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194379893","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:53.000000Z","updated_at":"2025-03-17T21:26:53.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4460209,"change_date":"2023-04-13 21:43:00","inspection_id":"78311592","insp_unit_id":"194379893","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PVZ2939","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRNBL2EG265254","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:08.000000Z","updated_at":"2025-03-17T22:38:08.000000Z"}]},{"id":2711097,"change_date":"2023-05-02 21:41:00","inspection_id":"78243689","dot_number":"919321","report_state":"PA","report_number":"M245200211","insp_date":"2023-03-30 00:00:00","insp_start_time":"1045","insp_end_time":"1125","registration_date":"2023-05-01 00:00:00","region":"ET","ci_status_code":"C","location":"37","location_desc":"422 E NCST","county_code_state":"PA","county_code":"073","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2332933","transaction_code":"C","transaction_date":"2023-03-30 00:00:00","upload_date":"2023-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2023-03-31 21:41:00","snet_input_date":"2023-03-30 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-03-31 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"PO BOX 581270","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74158","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:36.000000Z","updated_at":"2025-03-17T19:16:36.000000Z","inspection_violations":[{"id":4164512,"change_date":"2023-05-02 21:41:00","inspection_id":"78243689","insp_violation_id":"252577119","seq_no":"1","part_no":"393","part_no_section":"100(c)","insp_viol_unit":"1","insp_unit_id":"194708908","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"393100C"}],"inspection_per_units":[{"id":4363144,"change_date":"2023-05-02 21:41:00","inspection_id":"78243689","insp_unit_id":"194708908","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3DJ222","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCLXKG546406","insp_unit_decal":"Y","insp_unit_decal_number":"32311154","created_at":"2025-03-17T22:37:21.000000Z","updated_at":"2025-03-17T22:37:21.000000Z"}]},{"id":2711539,"change_date":"2023-03-31 21:41:00","inspection_id":"78244189","dot_number":"919321","report_state":"TX","report_number":"6JSB9DDMFJ","insp_date":"2023-03-29 00:00:00","insp_start_time":"1010","insp_end_time":"1035","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SP-0093 IN JEFFERSON CO. (448-","county_code_state":"TX","county_code":"245","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ISP","shipping_paper_number":"BM065504-1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"43000","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":"8942485","transaction_code":"A","transaction_date":"2023-03-31 00:00:00","upload_date":"2023-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2023-03-31 21:41:00","snet_input_date":"2023-03-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-31 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T19:16:36.000000Z","updated_at":"2025-03-17T19:16:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4363898,"change_date":"2023-03-31 21:41:00","inspection_id":"78244189","insp_unit_id":"194177092","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"3DJ221","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL7KG540945","insp_unit_decal":"Y","insp_unit_decal_number":"32612687","created_at":"2025-03-17T22:37:21.000000Z","updated_at":"2025-03-17T22:37:21.000000Z"},{"id":4363899,"change_date":"2023-03-31 21:41:00","inspection_id":"78244189","insp_unit_id":"194177093","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TPHT","insp_unit_company":null,"insp_unit_license":"AE7688","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G04022HT163754","insp_unit_decal":"Y","insp_unit_decal_number":"32612688","created_at":"2025-03-17T22:37:21.000000Z","updated_at":"2025-03-17T22:37:21.000000Z"}]},{"id":2594383,"change_date":"2023-03-16 21:43:00","inspection_id":"78110412","dot_number":"919321","report_state":"KS","report_number":"HP04400299","insp_date":"2023-03-15 00:00:00","insp_start_time":"1033","insp_end_time":"1043","registration_date":null,"region":"CT","ci_status_code":"C","location":"HV","location_desc":"HARVEY COUNTY - 079","county_code_state":"KS","county_code":"079","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"INDUSTRIAL PIPING SPECIALISTS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1281380","transaction_code":"A","transaction_date":"2023-03-15 00:00:00","upload_date":"2023-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2023-03-16 21:43:00","snet_input_date":"2023-03-15 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-03-16 21:43:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:30.000000Z","updated_at":"2025-03-17T19:14:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4175739,"change_date":"2023-03-16 21:43:00","inspection_id":"78110412","insp_unit_id":"193912878","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"D-5500-1","insp_unit_license":"3AN093","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL7HG643412","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:56.000000Z","updated_at":"2025-03-17T22:35:56.000000Z"}]},{"id":1965090,"change_date":"2022-12-16 21:40:00","inspection_id":"77392370","dot_number":"919321","report_state":"TX","report_number":"6GTC0ANW7B","insp_date":"2022-12-12 00:00:00","insp_start_time":"1220","insp_end_time":"1250","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0259 IN RUSK CO. (298-338)","county_code_state":"TX","county_code":"401","insp_level_id":"2","service_center":"WE","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-12-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"39500","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":"8853211","transaction_code":"A","transaction_date":"2022-12-16 00:00:00","upload_date":"2022-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2022-12-16 21:40:00","snet_input_date":"2022-12-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-16 21:40:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T19:02:55.000000Z","updated_at":"2025-03-17T19:02:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3161966,"change_date":"2022-12-16 21:40:00","inspection_id":"77392370","insp_unit_id":"192469110","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3DK274","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL5KG540944","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:39.000000Z","updated_at":"2025-03-17T22:28:39.000000Z"},{"id":3161967,"change_date":"2022-12-16 21:40:00","inspection_id":"77392370","insp_unit_id":"192469111","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STAR","insp_unit_company":null,"insp_unit_license":"Y77452","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13YFS4025AC114801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:39.000000Z","updated_at":"2025-03-17T22:28:39.000000Z"}]},{"id":1706478,"change_date":"2022-11-09 21:40:00","inspection_id":"77095912","dot_number":"919321","report_state":"OK","report_number":"R107150691","insp_date":"2022-11-08 00:00:00","insp_start_time":"1136","insp_end_time":"1211","registration_date":null,"region":"CT","ci_status_code":"C","location":"63040","location_desc":"I-40 EB AT HWY 102","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":"ER048354-2","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-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","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":"690324","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-08 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2745103,"change_date":"2022-11-09 21:40:00","inspection_id":"77095912","insp_unit_id":"191880543","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"ERLD5500-1","insp_unit_license":"3CQ311","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL6JG342636","insp_unit_decal":"Y","insp_unit_decal_number":"32050737","created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"},{"id":2745104,"change_date":"2022-11-09 21:40:00","inspection_id":"77095912","insp_unit_id":"191880544","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOP H","insp_unit_company":null,"insp_unit_license":"AJ1065","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G04025JT168615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":1574784,"change_date":"2022-10-21 21:39:00","inspection_id":"76944908","dot_number":"919321","report_state":"TX","report_number":"6FB80XJRD4","insp_date":"2022-10-19 00:00:00","insp_start_time":"0740","insp_end_time":"0816","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0037 IN NUECES CO. (0-15)","county_code_state":"TX","county_code":"355","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INDUSTRIAL PIPING SPEC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"43500","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":"8807326","transaction_code":"A","transaction_date":"2022-10-21 00:00:00","upload_date":"2022-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2022-10-21 21:39:00","snet_input_date":"2022-10-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-21 21:39:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T18:55:37.000000Z","updated_at":"2025-03-17T18:55:37.000000Z","inspection_violations":[{"id":2476783,"change_date":"2022-10-21 21:39:00","inspection_id":"76944908","insp_violation_id":"249185431","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"191581580","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:35.000000Z","updated_at":"2025-03-17T21:18:35.000000Z","normalized_code":"39395A"},{"id":2476784,"change_date":"2022-10-21 21:39:00","inspection_id":"76944908","insp_violation_id":"249185432","seq_no":"2","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"1","insp_unit_id":"191581580","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:18:35.000000Z","updated_at":"2025-03-17T21:18:35.000000Z","normalized_code":"393100A"}],"inspection_per_units":[{"id":2534603,"change_date":"2022-10-21 21:39:00","inspection_id":"76944908","insp_unit_id":"191581580","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3AW575","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL5HG691890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:21.000000Z","updated_at":"2025-03-17T22:24:21.000000Z"},{"id":2534604,"change_date":"2022-10-21 21:39:00","inspection_id":"76944908","insp_unit_id":"191581581","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"23308P","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5RVGN422XCM013248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:21.000000Z","updated_at":"2025-03-17T22:24:21.000000Z"}]},{"id":1468730,"change_date":"2022-10-07 21:39:00","inspection_id":"76822497","dot_number":"919321","report_state":"TX","report_number":"6EXD9DDMDH","insp_date":"2022-09-27 00:00:00","insp_start_time":"1545","insp_end_time":"1610","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0364 IN JEFFERSON CO. (438-","county_code_state":"TX","county_code":"245","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LABELLECO","shipping_paper_number":"BM063111-2","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-10-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"41900","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":"8793954","transaction_code":"A","transaction_date":"2022-10-07 00:00:00","upload_date":"2022-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2022-10-07 21:39:00","snet_input_date":"2022-10-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-07 21:39:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T18:53:47.000000Z","updated_at":"2025-03-17T18:53:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2364760,"change_date":"2022-10-07 21:39:00","inspection_id":"76822497","insp_unit_id":"191334238","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3DJ221","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL7KG540945","insp_unit_decal":"Y","insp_unit_decal_number":"31603441","created_at":"2025-03-17T22:23:11.000000Z","updated_at":"2025-03-17T22:23:11.000000Z"},{"id":2364761,"change_date":"2022-10-07 21:39:00","inspection_id":"76822497","insp_unit_id":"191334239","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TPHT","insp_unit_company":null,"insp_unit_license":"AE7688","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G04022HT163754","insp_unit_decal":"Y","insp_unit_decal_number":"31603442","created_at":"2025-03-17T22:23:11.000000Z","updated_at":"2025-03-17T22:23:11.000000Z"}]},{"id":1363249,"change_date":"2022-09-26 21:39:00","inspection_id":"76700141","dot_number":"919321","report_state":"OK","report_number":"D800150867","insp_date":"2022-09-19 00:00:00","insp_start_time":"0855","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":"49412","location_desc":"US 412\/ .5 WB","county_code_state":"OK","county_code":"097","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"INDUSTRIAL PIPING SPECIALISTS","shipping_paper_number":"T0517082-1","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-09-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"684683","transaction_code":"A","transaction_date":"2022-09-19 00:00:00","upload_date":"2022-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2022-09-26 21:39:00","snet_input_date":"2022-09-19 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-09-26 21:39:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","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":[{"id":2155922,"change_date":"2022-09-26 21:39:00","inspection_id":"76700141","insp_violation_id":"248633468","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:50.000000Z","updated_at":"2025-03-17T21:16:50.000000Z","normalized_code":"3922"},{"id":2155923,"change_date":"2022-09-26 21:39:00","inspection_id":"76700141","insp_violation_id":"248633469","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"191087842","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:50.000000Z","updated_at":"2025-03-17T21:16:50.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":2194906,"change_date":"2022-09-26 21:39:00","inspection_id":"76700141","insp_unit_id":"191087841","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3DY201","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL0KG640353","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:01.000000Z","updated_at":"2025-03-17T22:22:01.000000Z"},{"id":2194907,"change_date":"2022-09-26 21:39:00","inspection_id":"76700141","insp_unit_id":"191087842","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOP H","insp_unit_company":null,"insp_unit_license":"BL6610","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4R7G04020JT174273","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:01.000000Z","updated_at":"2025-03-17T22:22:01.000000Z"}]},{"id":1293636,"change_date":"2022-09-26 21:39:00","inspection_id":"76618857","dot_number":"919321","report_state":"OK","report_number":"N114151554","insp_date":"2022-09-15 00:00:00","insp_start_time":"1155","insp_end_time":"1220","registration_date":"2022-09-20 00:00:00","region":"CT","ci_status_code":"C","location":"066066","location_desc":"SH66@SH28","county_code_state":"OK","county_code":"131","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A CARRIER","shipping_paper_number":"T0516844-1","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-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"684348","transaction_code":"C","transaction_date":"2022-09-15 00:00:00","upload_date":"2022-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2022-09-15 21:40:00","snet_input_date":"2022-09-15 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-09-15 21:40:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:29.000000Z","updated_at":"2025-03-17T18:50:29.000000Z","inspection_violations":[{"id":2046771,"change_date":"2022-09-26 21:39:00","inspection_id":"76618857","insp_violation_id":"248633936","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:24.000000Z","updated_at":"2025-03-17T21:16:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2082158,"change_date":"2022-09-26 21:39:00","inspection_id":"76618857","insp_unit_id":"191088233","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"AJ1042","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1TTF482S6J3065774","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:17.000000Z","updated_at":"2025-03-17T22:21:17.000000Z"},{"id":2082159,"change_date":"2022-09-26 21:39:00","inspection_id":"76618857","insp_unit_id":"191088234","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"S6","insp_unit_license":"3BF340","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGEDV7JSJT5492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:17.000000Z","updated_at":"2025-03-17T22:21:17.000000Z"}]},{"id":1240518,"change_date":"2022-10-02 21:30:00","inspection_id":"76557484","dot_number":"919321","report_state":"CO","report_number":"GR18000115","insp_date":"2022-09-08 00:00:00","insp_start_time":"1125","insp_end_time":"1136","registration_date":"2022-09-29 00:00:00","region":"MT","ci_status_code":"C","location":"RCITY","location_desc":"H34 BUSINESS MP2 2 PROMONTORY","county_code_state":"CO","county_code":"123","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1219040","transaction_code":"C","transaction_date":"2022-09-08 00:00:00","upload_date":"2022-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":null,"census_search_date":"2022-09-08 21:39:00","snet_input_date":"2022-09-08 00:00:00","source_office":"4COS001","mcmis_add_date":"2022-09-08 21:39:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"PO BOX 581270","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74158","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:40.000000Z","updated_at":"2025-03-17T18:49:40.000000Z","inspection_violations":[{"id":1964490,"change_date":"2022-10-02 21:30:00","inspection_id":"76557484","insp_violation_id":"248771656","seq_no":"1","part_no":"392","part_no_section":"7(a)","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:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"3927A"}],"inspection_per_units":[{"id":1996361,"change_date":"2022-10-02 21:30:00","inspection_id":"76557484","insp_unit_id":"191215732","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"F550-1","insp_unit_license":"2WZ590","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FDUF5HTXEEB11866","insp_unit_decal":"Y","insp_unit_decal_number":"31697989","created_at":"2025-03-17T22:20:44.000000Z","updated_at":"2025-03-17T22:20:44.000000Z"}]},{"id":1123299,"change_date":"2022-08-24 21:39:00","inspection_id":"76421503","dot_number":"919321","report_state":"OK","report_number":"I904154547","insp_date":"2022-08-24 00:00:00","insp_start_time":"1410","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":"44062","location_desc":"US 62 & SH 76 BLANCHARD","county_code_state":"OK","county_code":"087","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"330936","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-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44900","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":"681827","transaction_code":"A","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2022-08-24 21:39:00","snet_input_date":"2022-08-24 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-08-24 21:39:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:32.000000Z","updated_at":"2025-03-17T18:47:32.000000Z","inspection_violations":[{"id":1773982,"change_date":"2022-08-24 21:39:00","inspection_id":"76421503","insp_violation_id":"247956839","seq_no":"1","part_no":"393","part_no_section":"100(c)","insp_viol_unit":"2","insp_unit_id":"190513447","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:15.000000Z","updated_at":"2025-03-17T21:15:15.000000Z","normalized_code":"393100C"}],"inspection_per_units":[{"id":1806643,"change_date":"2022-08-24 21:39:00","inspection_id":"76421503","insp_unit_id":"190513446","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"D5500-2","insp_unit_license":"3EB999","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL9KG667427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:27.000000Z","updated_at":"2025-03-17T22:19:27.000000Z"},{"id":1806644,"change_date":"2022-08-24 21:39:00","inspection_id":"76421503","insp_unit_id":"190513447","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELT","insp_unit_company":null,"insp_unit_license":"AX6257","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4MWGF402XDN032672","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:27.000000Z","updated_at":"2025-03-17T22:19:27.000000Z"}]},{"id":908341,"change_date":"2022-07-27 21:41:00","inspection_id":"76169949","dot_number":"919321","report_state":"TX","report_number":"6CYA9DHHV7","insp_date":"2022-07-26 00:00:00","insp_start_time":"1017","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-0281 IN GREGG CO. (710-722)","county_code_state":"TX","county_code":"183","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INDUSTRIAL PIPE","shipping_paper_number":"TY043040-2","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-07-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"28057","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":"8726264","transaction_code":"A","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2022-07-27 21:41:00","snet_input_date":"2022-07-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-27 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T18:43:42.000000Z","updated_at":"2025-03-17T18:43:42.000000Z","inspection_violations":[{"id":1433590,"change_date":"2022-07-27 21:41:00","inspection_id":"76169949","insp_violation_id":"247359158","seq_no":"1","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"190002002","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:13:45.000000Z","updated_at":"2025-03-17T21:13:45.000000Z","normalized_code":"393110B"}],"inspection_per_units":[{"id":1462268,"change_date":"2022-07-27 21:41:00","inspection_id":"76169949","insp_unit_id":"190002001","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"TY101","insp_unit_license":"2WJ614","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL0FG539576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:12.000000Z","updated_at":"2025-03-17T22:17:12.000000Z"},{"id":1462269,"change_date":"2022-07-27 21:41:00","inspection_id":"76169949","insp_unit_id":"190002002","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STAV","insp_unit_company":"TT02","insp_unit_license":"Y77452","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13YFS4025AC114801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:12.000000Z","updated_at":"2025-03-17T22:17:12.000000Z"}]},{"id":620006,"change_date":"2022-06-23 21:40:00","inspection_id":"75832053","dot_number":"919321","report_state":"TX","report_number":"6BL90XQYDV","insp_date":"2022-06-07 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":"2022-06-23 00:00:00","region":"CT","ci_status_code":"C","location":"3C106","location_desc":"US 77 NORTHBOUND\/SOUTHBOUND RE","county_code_state":"TX","county_code":"391","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"48631","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-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"43500","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":"8681691","transaction_code":"C","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2022-06-15 21:41:00","snet_input_date":"2022-06-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-15 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T18:38:45.000000Z","updated_at":"2025-03-17T18:38:45.000000Z","inspection_violations":[{"id":974264,"change_date":"2022-06-23 21:40:00","inspection_id":"75832053","insp_violation_id":"246686098","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189435212","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39617C"},{"id":974265,"change_date":"2022-06-23 21:40:00","inspection_id":"75832053","insp_violation_id":"246686099","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189435212","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"3939A"},{"id":974266,"change_date":"2022-06-23 21:40:00","inspection_id":"75832053","insp_violation_id":"246686100","seq_no":"3","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"189435213","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":997227,"change_date":"2022-06-23 21:40:00","inspection_id":"75832053","insp_unit_id":"189435212","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3AW575","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRMCL5HG691890","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:20.000000Z","updated_at":"2025-03-17T22:14:20.000000Z"},{"id":997228,"change_date":"2022-06-23 21:40:00","inspection_id":"75832053","insp_unit_id":"189435213","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"23308P","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5RVGN422XCM013248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:20.000000Z","updated_at":"2025-03-17T22:14:20.000000Z"}]},{"id":432366,"change_date":"2022-05-19 21:42:00","inspection_id":"75608684","dot_number":"919321","report_state":"KS","report_number":"HP03131259","insp_date":"2022-05-18 00:00:00","insp_start_time":"1400","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":"RC","location_desc":"RICE COUNTY - 159","county_code_state":"KS","county_code":"159","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ONEOK","shipping_paper_number":"168060","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-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1250689","transaction_code":"A","transaction_date":"2022-05-19 00:00:00","upload_date":"2022-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2022-05-19 21:42:00","snet_input_date":"2022-05-18 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-05-19 21:42:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:10.000000Z","updated_at":"2025-03-17T18:35:10.000000Z","inspection_violations":[{"id":678672,"change_date":"2022-05-19 21:42:00","inspection_id":"75608684","insp_violation_id":"245917393","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188789289","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:11.000000Z","updated_at":"2025-03-17T21:10:11.000000Z","normalized_code":"3939A"},{"id":678673,"change_date":"2022-05-19 21:42:00","inspection_id":"75608684","insp_violation_id":"245917394","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188789289","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:11.000000Z","updated_at":"2025-03-17T21:10:11.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":697188,"change_date":"2022-05-19 21:42:00","inspection_id":"75608684","insp_unit_id":"188789289","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"D-5500-1","insp_unit_license":"3AN093","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL7HG643412","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:29.000000Z","updated_at":"2025-03-17T22:12:29.000000Z"}]},{"id":447144,"change_date":"2022-07-21 21:40:00","inspection_id":"75626153","dot_number":"919321","report_state":"ND","report_number":"TR04002506","insp_date":"2022-05-18 00:00:00","insp_start_time":"1255","insp_end_time":"1327","registration_date":"2022-07-15 00:00:00","region":"CT","ci_status_code":"C","location":"1","location_desc":"PANGER SCALE","county_code_state":"ND","county_code":"053","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"IPS","shipping_paper_number":"BLO169902-2","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"42000","viol_total":"7","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"359977","transaction_code":"C","transaction_date":"2022-05-20 00:00:00","upload_date":"2022-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2022-05-20 21:41:00","snet_input_date":"2022-05-19 00:00:00","source_office":"4NDS001","mcmis_add_date":"2022-05-20 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"PO BOX 581270","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74158","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:37.000000Z","updated_at":"2025-03-17T18:35:37.000000Z","inspection_violations":[{"id":706744,"change_date":"2022-07-21 21:40:00","inspection_id":"75626153","insp_violation_id":"247235486","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"189901818","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39348A"},{"id":706745,"change_date":"2022-07-21 21:40:00","inspection_id":"75626153","insp_violation_id":"247235487","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"189901818","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39348A"},{"id":706746,"change_date":"2022-07-21 21:40:00","inspection_id":"75626153","insp_violation_id":"247235488","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"189901818","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3963A1"},{"id":706747,"change_date":"2022-07-21 21:40:00","inspection_id":"75626153","insp_violation_id":"247235489","seq_no":"6","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"189901818","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39375A3"},{"id":706748,"change_date":"2022-07-21 21:40:00","inspection_id":"75626153","insp_violation_id":"247235490","seq_no":"7","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":"151020287","created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3922"},{"id":706749,"change_date":"2022-07-21 21:40:00","inspection_id":"75626153","insp_violation_id":"247235491","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"189901818","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39348A"},{"id":706750,"change_date":"2022-07-21 21:40:00","inspection_id":"75626153","insp_violation_id":"247235492","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"189901818","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":720752,"change_date":"2022-07-21 21:40:00","inspection_id":"75626153","insp_unit_id":"189901817","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"TUL-401","insp_unit_license":"3AN031","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL5HG635700","insp_unit_decal":"Y","insp_unit_decal_number":"31379124","created_at":"2025-03-17T22:12:38.000000Z","updated_at":"2025-03-17T22:12:38.000000Z"},{"id":720753,"change_date":"2022-07-21 21:40:00","inspection_id":"75626153","insp_unit_id":"189901818","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIRE","insp_unit_company":null,"insp_unit_license":"AB2780","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5R8GD4024HM046889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:38.000000Z","updated_at":"2025-03-17T22:12:38.000000Z"}]},{"id":179273,"change_date":"2022-04-14 21:42:00","inspection_id":"75307126","dot_number":"919321","report_state":"TX","report_number":"69V80MVA4H","insp_date":"2022-04-06 00:00:00","insp_start_time":"0817","insp_end_time":"0907","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0085 IN DIMMIT CO. (408-438","county_code_state":"TX","county_code":"127","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SUPPLY","shipping_paper_number":"822-6","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-04-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"43500","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":"8622799","transaction_code":"A","transaction_date":"2022-04-14 00:00:00","upload_date":"2022-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2022-04-14 21:42:00","snet_input_date":"2022-04-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-14 21:42:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"606 N 145TH E AVE","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74116","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0070961","created_at":"2025-03-17T18:30:33.000000Z","updated_at":"2025-03-17T18:30:33.000000Z","inspection_violations":[{"id":271378,"change_date":"2022-04-14 21:42:00","inspection_id":"75307126","insp_violation_id":"245170161","seq_no":"1","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"188164304","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"3929"},{"id":271379,"change_date":"2022-04-14 21:42:00","inspection_id":"75307126","insp_violation_id":"245170162","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"188164305","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"39311"},{"id":271380,"change_date":"2022-04-14 21:42:00","inspection_id":"75307126","insp_violation_id":"245170163","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188164304","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":290549,"change_date":"2022-04-14 21:42:00","inspection_id":"75307126","insp_unit_id":"188164304","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"TRK-1","insp_unit_license":"3DY204","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL8KG662199","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:57.000000Z","updated_at":"2025-03-17T22:09:57.000000Z"},{"id":290550,"change_date":"2022-04-14 21:42:00","inspection_id":"75307126","insp_unit_id":"188164305","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"XCEL","insp_unit_company":"TRL-1","insp_unit_license":"011C412","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1X9FG4527AC014197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:57.000000Z","updated_at":"2025-03-17T22:09:57.000000Z"}]},{"id":121632,"change_date":"2022-04-06 21:41:00","inspection_id":"75236269","dot_number":"919321","report_state":"ND","report_number":"HP15000139","insp_date":"2022-04-04 00:00:00","insp_start_time":"1255","insp_end_time":"1324","registration_date":null,"region":"CT","ci_status_code":"C","location":"01","location_desc":"PANGER SCALE","county_code_state":"ND","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"62500","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":"358716","transaction_code":"A","transaction_date":"2022-04-05 00:00:00","upload_date":"2022-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00919321","upload_search_indicator":"M","census_search_date":"2022-04-06 21:41:00","snet_input_date":"2022-04-05 00:00:00","source_office":"4NDS001","mcmis_add_date":"2022-04-06 21:41:00","insp_carrier_name":"INDUSTRIAL PIPING SPECIALISTS INC","insp_carrier_street":"PO BOX 581270","insp_carrier_city":"TULSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74158","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:47.000000Z","updated_at":"2025-03-17T18:29:47.000000Z","inspection_violations":[{"id":180251,"change_date":"2022-04-06 21:41:00","inspection_id":"75236269","insp_violation_id":"245000720","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"39617C"},{"id":180252,"change_date":"2022-04-06 21:41:00","inspection_id":"75236269","insp_violation_id":"245000721","seq_no":"2","part_no":"387","part_no_section":"301(a)","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:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"387301A"},{"id":180253,"change_date":"2022-04-06 21:41:00","inspection_id":"75236269","insp_violation_id":"245000722","seq_no":"3","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:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"3922"},{"id":180254,"change_date":"2022-04-06 21:41:00","inspection_id":"75236269","insp_violation_id":"245000723","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":196992,"change_date":"2022-04-06 21:41:00","inspection_id":"75236269","insp_unit_id":"188019751","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"OTHR","insp_unit_company":"4","insp_unit_license":"3AN032","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C7WRNCL1HG632079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:24.000000Z","updated_at":"2025-03-17T22:09:24.000000Z"},{"id":196993,"change_date":"2022-04-06 21:41:00","inspection_id":"75236269","insp_unit_id":"188019752","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"AB2780","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5R8GD4024HM046889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:24.000000Z","updated_at":"2025-03-17T22:09:24.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/919321\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/919321\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/919321\/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\/919321\/inspections","per_page":100,"prev_page_url":null,"to":57,"total":57}