{"current_page":1,"data":[{"id":12103207,"change_date":"2026-06-05 21:38:00","inspection_id":"88047844","dot_number":"1987749","report_state":"TX","report_number":"V262378896","insp_date":"2026-06-02 00:00:00","insp_start_time":"0805","insp_end_time":"0843","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A103","location_desc":"US75 SB DENISON SCALE","county_code_state":"TX","county_code":"181","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YARD","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-06-04 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"23020","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9980875","transaction_code":"C","transaction_date":"2026-06-05 00:00:00","upload_date":"2026-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2026-06-04 21:46:00","snet_input_date":"2026-06-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-04 21:46:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2026-06-07T09:41:01.000000Z","updated_at":"2026-06-16T09:32:40.000000Z","inspection_violations":[{"id":21062621,"change_date":"2026-06-05 21:38:00","inspection_id":"88047844","insp_violation_id":"274726187","seq_no":"1","part_no":"393","part_no_section":"11LR","insp_viol_unit":"2","insp_unit_id":"213938835","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:01:27.000000Z","updated_at":"2026-06-16T09:49:55.000000Z","normalized_code":"39311LR"},{"id":21062622,"change_date":"2026-06-05 21:38:00","inspection_id":"88047844","insp_violation_id":"274726188","seq_no":"2","part_no":"393","part_no_section":"11UR","insp_viol_unit":"2","insp_unit_id":"213938835","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:01:27.000000Z","updated_at":"2026-06-16T09:49:55.000000Z","normalized_code":"39311UR"},{"id":21062623,"change_date":"2026-06-05 21:38:00","inspection_id":"88047844","insp_violation_id":"274726189","seq_no":"3","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"213938835","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:01:27.000000Z","updated_at":"2026-06-16T09:49:55.000000Z","normalized_code":"39375C"},{"id":21062624,"change_date":"2026-06-05 21:38:00","inspection_id":"88047844","insp_violation_id":"274726190","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213938835","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:01:27.000000Z","updated_at":"2026-06-16T09:49:55.000000Z","normalized_code":"3939"},{"id":21062625,"change_date":"2026-06-05 21:38:00","inspection_id":"88047844","insp_violation_id":"274726191","seq_no":"5","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"213938834","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:01:27.000000Z","updated_at":"2026-06-16T09:49:55.000000Z","normalized_code":"39395A"},{"id":21062626,"change_date":"2026-06-05 21:38:00","inspection_id":"88047844","insp_violation_id":"274726192","seq_no":"6","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"213938834","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:01:27.000000Z","updated_at":"2026-06-16T09:49:55.000000Z","normalized_code":"39617C"},{"id":21062627,"change_date":"2026-06-05 21:38:00","inspection_id":"88047844","insp_violation_id":"274726193","seq_no":"7","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"213938835","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:01:27.000000Z","updated_at":"2026-06-16T09:49:55.000000Z","normalized_code":"39617C"},{"id":21062628,"change_date":"2026-06-05 21:38:00","inspection_id":"88047844","insp_violation_id":"274726194","seq_no":"8","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"213938835","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:01:27.000000Z","updated_at":"2026-06-16T09:49:55.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":21029428,"change_date":"2026-06-05 21:38:00","inspection_id":"88047844","insp_unit_id":"213938834","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"L126","insp_unit_license":"48C054","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT7W2BT7GEC82098","insp_unit_decal":"Y","insp_unit_decal_number":"36259579","created_at":"2026-06-07T09:18:19.000000Z","updated_at":"2026-06-16T09:04:55.000000Z"},{"id":21029429,"change_date":"2026-06-05 21:38:00","inspection_id":"88047844","insp_unit_id":"213938835","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"DG8751","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"58SGC2620JE008193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:18:19.000000Z","updated_at":"2026-06-16T09:04:55.000000Z"}]},{"id":11912985,"change_date":"2026-05-15 21:45:00","inspection_id":"87852364","dot_number":"1987749","report_state":"TX","report_number":"V262306156","insp_date":"2026-05-12 00:00:00","insp_start_time":"0630","insp_end_time":"0731","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH35 NB SVC RD","county_code_state":"TX","county_code":"325","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AMERICAN PIPING INSPECTION","shipping_paper_number":"30022304","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":"Y","pen_cen_match":null,"final_status_date":"2026-05-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","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":"3","hazmat_oos_total":"1","snet_sequence_id":"9955246","transaction_code":"C","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2026-05-14 21:43:00","snet_input_date":"2026-05-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-14 21:43:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2026-05-16T13:32:59.000000Z","updated_at":"2026-05-26T09:30:15.000000Z","inspection_violations":[{"id":20721628,"change_date":"2026-05-15 21:45:00","inspection_id":"87852364","insp_violation_id":"274303150","seq_no":"1","part_no":"172","part_no_section":"324","insp_viol_unit":"1","insp_unit_id":"213591022","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:22.000000Z","updated_at":"2026-05-26T09:46:14.000000Z","normalized_code":"172324"},{"id":20721629,"change_date":"2026-05-15 21:45:00","inspection_id":"87852364","insp_violation_id":"274303151","seq_no":"2","part_no":"172","part_no_section":"403G","insp_viol_unit":"1","insp_unit_id":"213591022","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:22.000000Z","updated_at":"2026-05-26T09:46:14.000000Z","normalized_code":"172403G"},{"id":20721630,"change_date":"2026-05-15 21:45:00","inspection_id":"87852364","insp_violation_id":"274303152","seq_no":"3","part_no":"177","part_no_section":"817E","insp_viol_unit":"1","insp_unit_id":"213591022","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-05-16T13:13:22.000000Z","updated_at":"2026-05-26T09:46:14.000000Z","normalized_code":"177817E"}],"inspection_per_units":[{"id":20709836,"change_date":"2026-05-15 21:45:00","inspection_id":"87852364","insp_unit_id":"213591022","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TTM3311","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BTXREC36638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:59.000000Z","updated_at":"2026-05-26T09:02:01.000000Z"}]},{"id":11999119,"change_date":"2026-05-22 21:38:00","inspection_id":"87937496","dot_number":"1987749","report_state":"TX","report_number":"7FB99DMBY1","insp_date":"2026-05-07 00:00:00","insp_start_time":"0944","insp_end_time":"1022","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-0250 IN MIDLAND CO. (274-28","county_code_state":"TX","county_code":"329","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","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":"Y","pen_cen_match":null,"final_status_date":"2026-05-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","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":"3","hazmat_oos_total":"1","snet_sequence_id":"9965636","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2026-05-25T09:41:20.000000Z","updated_at":"2026-06-02T09:32:49.000000Z","inspection_violations":[{"id":20875011,"change_date":"2026-05-22 21:38:00","inspection_id":"87937496","insp_violation_id":"274455042","seq_no":"1","part_no":"177","part_no_section":"817A","insp_viol_unit":"1","insp_unit_id":"213715347","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-25T10:03:08.000000Z","updated_at":"2026-06-02T09:45:14.000000Z","normalized_code":"177817A"},{"id":20875012,"change_date":"2026-05-22 21:38:00","inspection_id":"87937496","insp_violation_id":"274455043","seq_no":"2","part_no":"173","part_no_section":"25A","insp_viol_unit":"1","insp_unit_id":"213715347","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:08.000000Z","updated_at":"2026-06-02T09:45:14.000000Z","normalized_code":"17325A"},{"id":20875013,"change_date":"2026-05-22 21:38:00","inspection_id":"87937496","insp_violation_id":"274455044","seq_no":"3","part_no":"172","part_no_section":"403G","insp_viol_unit":"1","insp_unit_id":"213715347","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:08.000000Z","updated_at":"2026-06-02T09:45:14.000000Z","normalized_code":"172403G"}],"inspection_per_units":[{"id":20858959,"change_date":"2026-05-22 21:38:00","inspection_id":"87937496","insp_unit_id":"213715347","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"L91","insp_unit_license":"TTM5060","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT7REC36435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:33.000000Z","updated_at":"2026-06-02T09:06:18.000000Z"}]},{"id":11311594,"change_date":"2026-03-10 21:39:00","inspection_id":"87227808","dot_number":"1987749","report_state":"TX","report_number":"V262252297","insp_date":"2026-02-28 00:00:00","insp_start_time":"0645","insp_end_time":"0743","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH35 BL NB","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AMERICAN PIPING INSPECTION","shipping_paper_number":"NONE","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":"Y","pen_cen_match":null,"final_status_date":"2026-03-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"7","hazmat_oos_total":"0","snet_sequence_id":"9876676","transaction_code":"C","transaction_date":"2026-03-09 00:00:00","upload_date":"2026-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2026-03-06 21:43:00","snet_input_date":"2026-02-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-06 21:43:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2026-03-09T09:42:49.000000Z","updated_at":"2026-03-21T09:31:24.000000Z","inspection_violations":[{"id":19082237,"change_date":"2026-03-10 21:39:00","inspection_id":"87227808","insp_violation_id":"272318033","seq_no":"1","part_no":"172","part_no_section":"203D4","insp_viol_unit":"1","insp_unit_id":"212068125","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:05:03.000000Z","updated_at":"2026-03-21T09:49:16.000000Z","normalized_code":"172203D4"},{"id":19082238,"change_date":"2026-03-10 21:39:00","inspection_id":"87227808","insp_violation_id":"272318034","seq_no":"2","part_no":"172","part_no_section":"203D5","insp_viol_unit":"1","insp_unit_id":"212068125","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:05:03.000000Z","updated_at":"2026-03-21T09:49:16.000000Z","normalized_code":"172203D5"},{"id":19082239,"change_date":"2026-03-10 21:39:00","inspection_id":"87227808","insp_violation_id":"272318035","seq_no":"3","part_no":"172","part_no_section":"203D6","insp_viol_unit":"1","insp_unit_id":"212068125","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:05:03.000000Z","updated_at":"2026-03-21T09:49:16.000000Z","normalized_code":"172203D6"},{"id":19082240,"change_date":"2026-03-10 21:39:00","inspection_id":"87227808","insp_violation_id":"272318036","seq_no":"4","part_no":"172","part_no_section":"403B","insp_viol_unit":"1","insp_unit_id":"212068125","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:05:03.000000Z","updated_at":"2026-03-21T09:49:16.000000Z","normalized_code":"172403B"},{"id":19082241,"change_date":"2026-03-10 21:39:00","inspection_id":"87227808","insp_violation_id":"272318037","seq_no":"5","part_no":"172","part_no_section":"403F","insp_viol_unit":"1","insp_unit_id":"212068125","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:05:03.000000Z","updated_at":"2026-03-21T09:49:16.000000Z","normalized_code":"172403F"},{"id":19082242,"change_date":"2026-03-10 21:39:00","inspection_id":"87227808","insp_violation_id":"272318038","seq_no":"6","part_no":"172","part_no_section":"403G","insp_viol_unit":"1","insp_unit_id":"212068125","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:05:03.000000Z","updated_at":"2026-03-21T09:49:16.000000Z","normalized_code":"172403G"},{"id":19082243,"change_date":"2026-03-10 21:39:00","inspection_id":"87227808","insp_violation_id":"272318039","seq_no":"7","part_no":"172","part_no_section":"406E","insp_viol_unit":"1","insp_unit_id":"212068125","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:05:03.000000Z","updated_at":"2026-03-21T09:49:16.000000Z","normalized_code":"172406E"}],"inspection_per_units":[{"id":19395866,"change_date":"2026-03-10 21:39:00","inspection_id":"87227808","insp_unit_id":"212068125","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"WDR4934","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT2SEC03378","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:24.000000Z","updated_at":"2026-03-21T09:11:25.000000Z"}]},{"id":11257104,"change_date":"2026-02-28 21:34:00","inspection_id":"87170660","dot_number":"1987749","report_state":"TN","report_number":"I3A1410102","insp_date":"2026-02-26 00:00:00","insp_start_time":"1705","insp_end_time":"1740","registration_date":null,"region":"CS","ci_status_code":"C","location":"HAYWDW","location_desc":"STANTON TN","county_code_state":"TN","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"TOWN WEST","shipping_paper_number":"2262026","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-28 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"24275","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":"2946143","transaction_code":"A","transaction_date":"2026-02-27 00:00:00","upload_date":"2026-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":null,"census_search_date":"2026-02-28 21:34:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-28 21:34:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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-03-03T10:39:20.000000Z","updated_at":"2026-03-11T09:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19248466,"change_date":"2026-02-28 21:34:00","inspection_id":"87170660","insp_unit_id":"211898016","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":null,"insp_unit_license":"48C054","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT7W2BT7GEC82098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-03T10:15:29.000000Z","updated_at":"2026-03-11T09:02:16.000000Z"},{"id":19248467,"change_date":"2026-02-28 21:34:00","inspection_id":"87170660","insp_unit_id":"211898017","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"AT5229","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5RVH62229JP063513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-03T10:15:29.000000Z","updated_at":"2026-03-11T09:02:16.000000Z"}]},{"id":11120322,"change_date":"2026-03-02 21:38:00","inspection_id":"87033366","dot_number":"1987749","report_state":"TX","report_number":"V262199787","insp_date":"2026-02-11 00:00:00","insp_start_time":"1029","insp_end_time":"1103","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"21505 AZALEA BLVD","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AMERICAN PIPING INSPECTION","shipping_paper_number":"NONE","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":"Y","pen_cen_match":null,"final_status_date":"2026-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"5","hazmat_oos_total":"1","snet_sequence_id":"9848995","transaction_code":"C","transaction_date":"2026-03-02 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2026-02-12 21:41:00","snet_input_date":"2026-02-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-12 21:41:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2026-02-15T10:38:50.000000Z","updated_at":"2026-03-13T09:32:04.000000Z","inspection_violations":[{"id":18927709,"change_date":"2026-03-02 21:38:00","inspection_id":"87033366","insp_violation_id":"272145505","seq_no":"1","part_no":"172","part_no_section":"203D6","insp_viol_unit":"1","insp_unit_id":"211924400","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:45.000000Z","updated_at":"2026-03-13T09:46:03.000000Z","normalized_code":"172203D6"},{"id":18927710,"change_date":"2026-03-02 21:38:00","inspection_id":"87033366","insp_violation_id":"272145506","seq_no":"2","part_no":"172","part_no_section":"403G","insp_viol_unit":"1","insp_unit_id":"211924400","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:45.000000Z","updated_at":"2026-03-13T09:46:03.000000Z","normalized_code":"172403G"},{"id":18927711,"change_date":"2026-03-02 21:38:00","inspection_id":"87033366","insp_violation_id":"272145507","seq_no":"3","part_no":"172","part_no_section":"403G2","insp_viol_unit":"1","insp_unit_id":"211924400","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:45.000000Z","updated_at":"2026-03-13T09:46:03.000000Z","normalized_code":"172403G2"},{"id":18927712,"change_date":"2026-03-02 21:38:00","inspection_id":"87033366","insp_violation_id":"272145508","seq_no":"4","part_no":"172","part_no_section":"600C","insp_viol_unit":"1","insp_unit_id":"211924400","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-05T10:56:45.000000Z","updated_at":"2026-03-13T09:46:03.000000Z","normalized_code":"172600C"},{"id":18927713,"change_date":"2026-03-02 21:38:00","inspection_id":"87033366","insp_violation_id":"272145509","seq_no":"5","part_no":"177","part_no_section":"817A","insp_viol_unit":"1","insp_unit_id":"211924400","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-05T10:56:45.000000Z","updated_at":"2026-03-13T09:46:03.000000Z","normalized_code":"177817A"}],"inspection_per_units":[{"id":19259186,"change_date":"2026-03-02 21:38:00","inspection_id":"87033366","insp_unit_id":"211924400","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"Z727386","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1FT7W2BN7RED57838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:39.000000Z","updated_at":"2026-03-13T09:05:31.000000Z"}]},{"id":10230133,"change_date":"2025-11-18 21:39:00","inspection_id":"86352274","dot_number":"1987749","report_state":"OK","report_number":"R200162236","insp_date":"2025-11-18 00:00:00","insp_start_time":"1205","insp_end_time":"1230","registration_date":null,"region":"CT","ci_status_code":"C","location":"12271","location_desc":"HUGO SCALES","county_code_state":"OK","county_code":"023","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"30000","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":"803988","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":null,"census_search_date":"2025-11-18 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-11-18 21:39:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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-21T10:31:53.000000Z","updated_at":"2025-11-23T10:30:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17048144,"change_date":"2025-11-18 21:39:00","inspection_id":"86352274","insp_unit_id":"210103512","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"48C054","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT7W2BT7GEC82098","insp_unit_decal":"Y","insp_unit_decal_number":"35801597","created_at":"2025-11-21T10:01:59.000000Z","updated_at":"2025-11-23T10:01:12.000000Z"},{"id":17048145,"change_date":"2025-11-18 21:39:00","inspection_id":"86352274","insp_unit_id":"210103513","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"DG8751","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"58SGC2620JE008193","insp_unit_decal":"Y","insp_unit_decal_number":"35801598","created_at":"2025-11-21T10:01:59.000000Z","updated_at":"2025-11-23T10:01:12.000000Z"}]},{"id":10231080,"change_date":"2025-11-18 21:39:00","inspection_id":"86353292","dot_number":"1987749","report_state":"TX","report_number":"V252018812","insp_date":"2025-11-10 00:00:00","insp_start_time":"1014","insp_end_time":"1039","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 2105 MILEPOST 375","county_code_state":"TX","county_code":"451","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AMERICAN PIPING INSPECTION","shipping_paper_number":"NONE","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":"Y","pen_cen_match":null,"final_status_date":"2025-11-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"9761852","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2025-11-18 21:39:00","snet_input_date":"2025-11-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-18 21:39:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2025-11-21T10:31:54.000000Z","updated_at":"2025-11-23T10:31:04.000000Z","inspection_violations":[{"id":17008973,"change_date":"2025-11-18 21:39:00","inspection_id":"86353292","insp_violation_id":"270043958","seq_no":"1","part_no":"177","part_no_section":"817E","insp_viol_unit":"1","insp_unit_id":"210105683","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:33:02.000000Z","updated_at":"2025-11-23T10:31:31.000000Z","normalized_code":"177817E"}],"inspection_per_units":[{"id":17049769,"change_date":"2025-11-18 21:39:00","inspection_id":"86353292","insp_unit_id":"210105683","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"T462","insp_unit_license":"56C957","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT7X2BA8PED82089","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:02:00.000000Z","updated_at":"2025-11-23T10:01:18.000000Z"}]},{"id":9734958,"change_date":"2025-09-20 21:33:00","inspection_id":"85831259","dot_number":"1987749","report_state":"MO","report_number":"0193001101","insp_date":"2025-09-18 00:00:00","insp_start_time":"1008","insp_end_time":"1129","registration_date":null,"region":"CD","ci_status_code":"C","location":"C2E","location_desc":"ST CLAIR MO","county_code_state":"MO","county_code":"071","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","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":"U","pen_cen_match":"I","final_status_date":"2025-09-20 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"32180","viol_total":"10","oos_total":"4","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2303316","transaction_code":"A","transaction_date":"2025-09-19 00:00:00","upload_date":"2025-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":null,"census_search_date":"2025-09-20 21:33:00","snet_input_date":"2025-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-20 21:33:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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-09-23T10:02:51.000000Z","updated_at":"2025-09-24T10:00:10.000000Z","inspection_violations":[{"id":15985381,"change_date":"2025-09-20 21:33:00","inspection_id":"85831259","insp_violation_id":"268819892","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"209057655","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-23T10:17:13.000000Z","updated_at":"2025-09-24T10:15:16.000000Z","normalized_code":"39617CPI"},{"id":15985382,"change_date":"2025-09-20 21:33:00","inspection_id":"85831259","insp_violation_id":"268819893","seq_no":"2","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-23T10:17:13.000000Z","updated_at":"2025-09-24T10:15:16.000000Z","normalized_code":"38323A2LCDLN"},{"id":15985383,"change_date":"2025-09-20 21:33:00","inspection_id":"85831259","insp_violation_id":"268819894","seq_no":"3","part_no":"392","part_no_section":"2-SLL","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-09-23T10:17:13.000000Z","updated_at":"2025-09-24T10:15:16.000000Z","normalized_code":"3922SLL"},{"id":15985385,"change_date":"2025-09-20 21:33:00","inspection_id":"85831259","insp_violation_id":"268819896","seq_no":"5","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-23T10:17:13.000000Z","updated_at":"2025-09-24T10:15:16.000000Z","normalized_code":"3922SLLTL"},{"id":15985386,"change_date":"2025-09-20 21:33:00","inspection_id":"85831259","insp_violation_id":"268819897","seq_no":"6","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"2","insp_unit_id":"209057655","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-23T10:17:13.000000Z","updated_at":"2025-09-24T10:15:16.000000Z","normalized_code":"393104F3C"},{"id":15985387,"change_date":"2025-09-20 21:33:00","inspection_id":"85831259","insp_violation_id":"268819898","seq_no":"7","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"209057655","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-23T10:17:13.000000Z","updated_at":"2025-09-24T10:15:16.000000Z","normalized_code":"39343DB"},{"id":15985388,"change_date":"2025-09-20 21:33:00","inspection_id":"85831259","insp_violation_id":"268819899","seq_no":"8","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"209057655","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-23T10:17:13.000000Z","updated_at":"2025-09-24T10:15:16.000000Z","normalized_code":"39343DBMA"},{"id":15985389,"change_date":"2025-09-20 21:33:00","inspection_id":"85831259","insp_violation_id":"268819900","seq_no":"9","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209057654","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-23T10:17:13.000000Z","updated_at":"2025-09-24T10:15:16.000000Z","normalized_code":"3939ALIL"},{"id":15985390,"change_date":"2025-09-20 21:33:00","inspection_id":"85831259","insp_violation_id":"268819901","seq_no":"10","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-23T10:17:13.000000Z","updated_at":"2025-09-24T10:15:16.000000Z","normalized_code":"3958A1HOSP"},{"id":15985384,"change_date":"2025-09-20 21:33:00","inspection_id":"85831259","insp_violation_id":"268819895","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209057654","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-23T10:17:13.000000Z","updated_at":"2025-09-24T10:15:16.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16120941,"change_date":"2025-09-20 21:33:00","inspection_id":"85831259","insp_unit_id":"209057654","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"T241","insp_unit_license":"V64231","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD0W4HT4FED65731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-23T09:46:30.000000Z","updated_at":"2025-09-24T09:45:11.000000Z"},{"id":16120942,"change_date":"2025-09-20 21:33:00","inspection_id":"85831259","insp_unit_id":"209057655","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"DG8751","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"58SGC2620JE008193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-23T09:46:30.000000Z","updated_at":"2025-09-24T09:45:11.000000Z"}]},{"id":9389509,"change_date":"2025-08-12 21:40:00","inspection_id":"85459439","dot_number":"1987749","report_state":"TX","report_number":"V251917384","insp_date":"2025-08-06 00:00:00","insp_start_time":"1622","insp_end_time":"1717","registration_date":null,"region":"CT","ci_status_code":"C","location":"6C001","location_desc":"TX16 JOURDANTON SCALE","county_code_state":"TX","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMERICAN PIPING INSPECTION","shipping_paper_number":"NONE","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":"Y","pen_cen_match":null,"final_status_date":"2025-08-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"2","hazmat_oos_total":"1","snet_sequence_id":"9661012","transaction_code":"C","transaction_date":"2025-08-12 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2025-08-12 21:40:00","snet_input_date":"2025-08-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-11 21:38:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2025-08-15T10:43:48.000000Z","updated_at":"2025-08-16T10:00:40.000000Z","inspection_violations":[{"id":15265056,"change_date":"2025-08-12 21:40:00","inspection_id":"85459439","insp_violation_id":"267986150","seq_no":"1","part_no":"172","part_no_section":"403G","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:46.000000Z","updated_at":"2025-08-16T10:43:51.000000Z","normalized_code":"172403G"},{"id":15265057,"change_date":"2025-08-12 21:40:00","inspection_id":"85459439","insp_violation_id":"267986151","seq_no":"2","part_no":"177","part_no_section":"817E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-08-15T10:45:46.000000Z","updated_at":"2025-08-16T10:43:51.000000Z","normalized_code":"177817E"}],"inspection_per_units":[{"id":15473419,"change_date":"2025-08-12 21:40:00","inspection_id":"85459439","insp_unit_id":"208361260","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"VTS7833","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT0RED34092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:22.000000Z","updated_at":"2025-08-16T09:45:50.000000Z"}]},{"id":9345384,"change_date":"2025-09-04 21:41:00","inspection_id":"85422156","dot_number":"1987749","report_state":"TX","report_number":"V251939370","insp_date":"2025-08-01 00:00:00","insp_start_time":"1052","insp_end_time":"1138","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"106 TX171","county_code_state":"TX","county_code":"221","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"API","shipping_paper_number":"NO #","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":"Y","pen_cen_match":null,"final_status_date":"2025-08-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"3","hazmat_oos_total":"0","snet_sequence_id":"9658284","transaction_code":"C","transaction_date":"2025-09-04 00:00:00","upload_date":"2025-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2025-08-06 21:40:00","snet_input_date":"2025-08-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-06 21:40:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2025-08-12T10:42:23.000000Z","updated_at":"2025-09-10T10:45:28.000000Z","inspection_violations":[{"id":15678223,"change_date":"2025-09-04 21:41:00","inspection_id":"85422156","insp_violation_id":"268467858","seq_no":"1","part_no":"172","part_no_section":"407","insp_viol_unit":"1","insp_unit_id":"208754166","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-09T10:43:02.000000Z","updated_at":"2025-09-10T10:47:35.000000Z","normalized_code":"172407"},{"id":15678224,"change_date":"2025-09-04 21:41:00","inspection_id":"85422156","insp_violation_id":"268467859","seq_no":"2","part_no":"172","part_no_section":"600C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-09T10:43:02.000000Z","updated_at":"2025-09-10T10:47:35.000000Z","normalized_code":"172600C"},{"id":15678225,"change_date":"2025-09-04 21:41:00","inspection_id":"85422156","insp_violation_id":"268467860","seq_no":"3","part_no":"177","part_no_section":"817E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-09T10:43:02.000000Z","updated_at":"2025-09-10T10:47:35.000000Z","normalized_code":"177817E"}],"inspection_per_units":[{"id":15840148,"change_date":"2025-09-04 21:41:00","inspection_id":"85422156","insp_unit_id":"208754166","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"L238","insp_unit_license":"WPT7124","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT5SED15219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:49.000000Z","updated_at":"2025-09-10T09:45:52.000000Z"}]},{"id":8940604,"change_date":"2025-06-19 21:38:00","inspection_id":"84995924","dot_number":"1987749","report_state":"TX","report_number":"V251895470","insp_date":"2025-06-18 00:00:00","insp_start_time":"0652","insp_end_time":"0704","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX302","county_code_state":"TX","county_code":"301","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":"NONE","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":"Y","pen_cen_match":null,"final_status_date":"2025-06-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","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":"9611820","transaction_code":"A","transaction_date":"2025-06-19 00:00:00","upload_date":"2025-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2025-06-19 21:38:00","snet_input_date":"2025-06-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-19 21:38:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2025-06-22T10:01:16.000000Z","updated_at":"2025-06-23T10:00:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14653092,"change_date":"2025-06-19 21:38:00","inspection_id":"84995924","insp_unit_id":"207467559","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"L166","insp_unit_license":"WDR4908","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT0SEC03427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:30.000000Z","updated_at":"2025-06-23T09:45:44.000000Z"}]},{"id":8298182,"change_date":"2025-04-04 21:41:00","inspection_id":"84317602","dot_number":"1987749","report_state":"TX","report_number":"74789DMBIN","insp_date":"2025-04-02 00:00:00","insp_start_time":"0800","insp_end_time":"0831","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0020 IN MIDLAND CO. (123-14","county_code_state":"TX","county_code":"329","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"STRAIGHT","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":"Y","pen_cen_match":null,"final_status_date":"2025-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","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":"1","hazmat_oos_total":"1","snet_sequence_id":"9541316","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2025-04-04 21:41:00","snet_input_date":"2025-04-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-04 21:41:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2025-04-07T10:22:18.000000Z","updated_at":"2025-04-08T10:09:49.000000Z","inspection_violations":[{"id":13048488,"change_date":"2025-04-04 21:41:00","inspection_id":"84317602","insp_violation_id":"265447931","seq_no":"1","part_no":"177","part_no_section":"817A","insp_viol_unit":"1","insp_unit_id":"206162000","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-07T10:51:44.000000Z","updated_at":"2025-04-07T10:59:44.000000Z","normalized_code":"177817A"}],"inspection_per_units":[{"id":13454619,"change_date":"2025-04-04 21:41:00","inspection_id":"84317602","insp_unit_id":"206162000","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TTL8353","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT9RED34091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:12:47.000000Z","updated_at":"2025-04-08T10:00:58.000000Z"}]},{"id":8288455,"change_date":"2025-04-04 21:41:00","inspection_id":"84307371","dot_number":"1987749","report_state":"TX","report_number":"V251801820","insp_date":"2025-03-27 00:00:00","insp_start_time":"1425","insp_end_time":"1520","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1406  US181","county_code_state":"TX","county_code":"493","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DEVON ENERGY","shipping_paper_number":"GA1309","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":"Y","pen_cen_match":null,"final_status_date":"2025-04-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"5","hazmat_oos_total":"1","snet_sequence_id":"9540097","transaction_code":"C","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2025-04-03 21:41:00","snet_input_date":"2025-03-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-03 21:41:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2025-04-06T10:25:07.000000Z","updated_at":"2025-04-08T10:09:42.000000Z","inspection_violations":[{"id":13046703,"change_date":"2025-04-04 21:41:00","inspection_id":"84307371","insp_violation_id":"265449183","seq_no":"1","part_no":"172","part_no_section":"403G","insp_viol_unit":"1","insp_unit_id":"206162490","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:50:39.000000Z","updated_at":"2025-04-07T10:58:15.000000Z","normalized_code":"172403G"},{"id":13046704,"change_date":"2025-04-04 21:41:00","inspection_id":"84307371","insp_violation_id":"265449184","seq_no":"2","part_no":"172","part_no_section":"403G","insp_viol_unit":"1","insp_unit_id":"206162490","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:50:39.000000Z","updated_at":"2025-04-07T10:58:15.000000Z","normalized_code":"172403G"},{"id":13046705,"change_date":"2025-04-04 21:41:00","inspection_id":"84307371","insp_violation_id":"265449185","seq_no":"3","part_no":"172","part_no_section":"403G","insp_viol_unit":"1","insp_unit_id":"206162490","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:50:39.000000Z","updated_at":"2025-04-07T10:58:15.000000Z","normalized_code":"172403G"},{"id":13046706,"change_date":"2025-04-04 21:41:00","inspection_id":"84307371","insp_violation_id":"265449186","seq_no":"4","part_no":"172","part_no_section":"403G2","insp_viol_unit":"1","insp_unit_id":"206162490","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:50:39.000000Z","updated_at":"2025-04-07T10:58:15.000000Z","normalized_code":"172403G2"},{"id":13046707,"change_date":"2025-04-04 21:41:00","inspection_id":"84307371","insp_violation_id":"265449187","seq_no":"5","part_no":"177","part_no_section":"817A","insp_viol_unit":"1","insp_unit_id":"206162490","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-04-07T10:50:39.000000Z","updated_at":"2025-04-07T10:58:15.000000Z","normalized_code":"177817A"}],"inspection_per_units":[{"id":13453481,"change_date":"2025-04-04 21:41:00","inspection_id":"84307371","insp_unit_id":"206162490","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"T473","insp_unit_license":"V80673","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT7X2BA6RED07815","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:11:42.000000Z","updated_at":"2025-04-08T09:59:28.000000Z"}]},{"id":8178949,"change_date":"2025-03-21 21:40:00","inspection_id":"84192084","dot_number":"1987749","report_state":"OK","report_number":"R200161869","insp_date":"2025-03-21 00:00:00","insp_start_time":"1025","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"12271","location_desc":"HUGO SCALES","county_code_state":"OK","county_code":"023","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"24500","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":"779426","transaction_code":"A","transaction_date":"2025-03-21 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2025-03-21 21:40:00","snet_input_date":"2025-03-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-03-21 21:40:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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-24T10:28:00.000000Z","updated_at":"2025-03-25T10:10:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13220824,"change_date":"2025-03-21 21:40:00","inspection_id":"84192084","insp_unit_id":"205928828","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"EATX","insp_unit_company":null,"insp_unit_license":"DG8751","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5BSGC2620JE008193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-24T10:17:21.000000Z","updated_at":"2025-03-25T09:59:25.000000Z"},{"id":13220823,"change_date":"2025-03-21 21:40:00","inspection_id":"84192084","insp_unit_id":"205928827","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"T241","insp_unit_license":"V64231","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD0W4HT4FED65731","insp_unit_decal":"Y","insp_unit_decal_number":"34958426","created_at":"2025-03-24T10:17:21.000000Z","updated_at":"2025-03-25T09:59:25.000000Z"}]},{"id":7321720,"change_date":"2024-12-03 21:41:00","inspection_id":"83291408","dot_number":"1987749","report_state":"TX","report_number":"V241689710","insp_date":"2024-11-27 00:00:00","insp_start_time":"0656","insp_end_time":"0809","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6925  US181 SB","county_code_state":"TX","county_code":"493","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOME-PP","shipping_paper_number":"FK1403","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":"Y","pen_cen_match":null,"final_status_date":"2024-12-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"2","hazmat_oos_total":"1","snet_sequence_id":"9440953","transaction_code":"C","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2024-12-02 21:40:00","snet_input_date":"2024-11-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-02 21:40:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2025-03-17T20:48:56.000000Z","updated_at":"2025-03-17T20:48:56.000000Z","inspection_violations":[{"id":11446477,"change_date":"2024-12-03 21:41:00","inspection_id":"83291408","insp_violation_id":"263212511","seq_no":"1","part_no":"172","part_no_section":"200A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:01:40.000000Z","updated_at":"2025-03-17T22:01:40.000000Z","normalized_code":"172200A"},{"id":11446478,"change_date":"2024-12-03 21:41:00","inspection_id":"83291408","insp_violation_id":"263212512","seq_no":"2","part_no":"172","part_no_section":"403G2","insp_viol_unit":"1","insp_unit_id":"204162909","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:40.000000Z","updated_at":"2025-03-17T22:01:40.000000Z","normalized_code":"172403G2"}],"inspection_per_units":[{"id":11811191,"change_date":"2024-12-03 21:41:00","inspection_id":"83291408","insp_unit_id":"204162909","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"T423","insp_unit_license":"99963V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT7X2B66NEF23704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:26.000000Z","updated_at":"2025-03-17T23:45:26.000000Z"}]},{"id":7252709,"change_date":"2024-11-25 21:44:00","inspection_id":"83218509","dot_number":"1987749","report_state":"TX","report_number":"V241706032","insp_date":"2024-11-20 00:00:00","insp_start_time":"0710","insp_end_time":"0749","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 16 MP 666","county_code_state":"TX","county_code":"311","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AMERICAN PIPING INSPECTION","shipping_paper_number":"NONE","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":"Y","pen_cen_match":null,"final_status_date":"2024-11-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"3","hazmat_oos_total":"0","snet_sequence_id":"9434066","transaction_code":"C","transaction_date":"2024-11-25 00:00:00","upload_date":"2024-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2024-11-21 21:41:00","snet_input_date":"2024-11-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-21 21:41:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2025-03-17T20:47:17.000000Z","updated_at":"2025-03-17T20:47:17.000000Z","inspection_violations":[{"id":11337938,"change_date":"2024-11-25 21:44:00","inspection_id":"83218509","insp_violation_id":"263088464","seq_no":"1","part_no":"172","part_no_section":"203D4","insp_viol_unit":"1","insp_unit_id":"204054452","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:02.000000Z","updated_at":"2025-03-17T22:01:02.000000Z","normalized_code":"172203D4"},{"id":11337939,"change_date":"2024-11-25 21:44:00","inspection_id":"83218509","insp_violation_id":"263088465","seq_no":"2","part_no":"172","part_no_section":"203D6","insp_viol_unit":"1","insp_unit_id":"204054452","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:02.000000Z","updated_at":"2025-03-17T22:01:02.000000Z","normalized_code":"172203D6"},{"id":11337940,"change_date":"2024-11-25 21:44:00","inspection_id":"83218509","insp_violation_id":"263088466","seq_no":"3","part_no":"172","part_no_section":"403G","insp_viol_unit":"1","insp_unit_id":"204054452","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:02.000000Z","updated_at":"2025-03-17T22:01:02.000000Z","normalized_code":"172403G"}],"inspection_per_units":[{"id":11698427,"change_date":"2024-11-25 21:44:00","inspection_id":"83218509","insp_unit_id":"204054452","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"L98","insp_unit_license":"TKJ2004","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT1REC93326","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:14.000000Z","updated_at":"2025-03-17T23:44:14.000000Z"}]},{"id":5655892,"change_date":"2024-05-02 21:43:00","inspection_id":"81508855","dot_number":"1987749","report_state":"OK","report_number":"H800154046","insp_date":"2024-05-02 00:00:00","insp_start_time":"1029","insp_end_time":"1106","registration_date":null,"region":"CT","ci_status_code":"C","location":"12271","location_desc":"HUGO SCALES","county_code_state":"OK","county_code":"023","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"745715","transaction_code":"A","transaction_date":"2024-05-02 00:00:00","upload_date":"2024-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2024-05-02 21:43:00","snet_input_date":"2024-05-02 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-05-02 21:43:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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:14:44.000000Z","updated_at":"2025-03-17T20:14:44.000000Z","inspection_violations":[{"id":8748031,"change_date":"2024-05-02 21:43:00","inspection_id":"81508855","insp_violation_id":"259282040","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:19.000000Z","updated_at":"2025-03-17T21:48:19.000000Z","normalized_code":"39141A"},{"id":8748032,"change_date":"2024-05-02 21:43:00","inspection_id":"81508855","insp_violation_id":"259282041","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200698526","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:19.000000Z","updated_at":"2025-03-17T21:48:19.000000Z","normalized_code":"39395A"},{"id":8748033,"change_date":"2024-05-02 21:43:00","inspection_id":"81508855","insp_violation_id":"259282042","seq_no":"3","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:19.000000Z","updated_at":"2025-03-17T21:48:19.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":9109758,"change_date":"2024-05-02 21:43:00","inspection_id":"81508855","insp_unit_id":"200698526","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"51719V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT7W2BT2LEC24524","insp_unit_decal":"Y","insp_unit_decal_number":"33980544","created_at":"2025-03-17T23:17:45.000000Z","updated_at":"2025-03-17T23:17:45.000000Z"},{"id":9109759,"change_date":"2024-05-02 21:43:00","inspection_id":"81508855","insp_unit_id":"200698527","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"AH5042","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"58SGC2620JE008193","insp_unit_decal":"Y","insp_unit_decal_number":"33980545","created_at":"2025-03-17T23:17:45.000000Z","updated_at":"2025-03-17T23:17:45.000000Z"}]},{"id":4196049,"change_date":"2023-10-19 21:41:00","inspection_id":"79910312","dot_number":"1987749","report_state":"TX","report_number":"V231112985","insp_date":"2023-08-10 00:00:00","insp_start_time":"1655","insp_end_time":"1727","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 302 MILEPOST 224","county_code_state":"TX","county_code":"495","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AMERICAN PIPING INSPECTION INC","shipping_paper_number":"2251","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":"Y","pen_cen_match":null,"final_status_date":"2023-10-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","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":"2","hazmat_oos_total":"0","snet_sequence_id":"9101483","transaction_code":"C","transaction_date":"2023-10-19 00:00:00","upload_date":"2023-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2023-10-13 21:41:00","snet_input_date":"2023-08-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-13 21:41:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2025-03-17T19:45:53.000000Z","updated_at":"2025-03-17T19:45:53.000000Z","inspection_violations":[{"id":6497763,"change_date":"2023-10-19 21:41:00","inspection_id":"79910312","insp_violation_id":"255945877","seq_no":"1","part_no":"172","part_no_section":"403(g)(2)","insp_viol_unit":"1","insp_unit_id":"197651043","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:19.000000Z","updated_at":"2025-03-17T21:37:19.000000Z","normalized_code":"172403G2"},{"id":6497764,"change_date":"2023-10-19 21:41:00","inspection_id":"79910312","insp_violation_id":"255945878","seq_no":"2","part_no":"177","part_no_section":"817(e)","insp_viol_unit":"1","insp_unit_id":"197651043","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:19.000000Z","updated_at":"2025-03-17T21:37:19.000000Z","normalized_code":"177817E"}],"inspection_per_units":[{"id":6747887,"change_date":"2023-10-19 21:41:00","inspection_id":"79910312","insp_unit_id":"197651043","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"T429","insp_unit_license":"99971V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT7X2B69NEF55434","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:34.000000Z","updated_at":"2025-03-17T22:56:34.000000Z"}]},{"id":1789930,"change_date":"2022-11-21 21:41:00","inspection_id":"77191757","dot_number":"1987749","report_state":"TX","report_number":"6G370ALIJH","insp_date":"2022-11-16 00:00:00","insp_start_time":"0736","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CR-300","county_code_state":"TX","county_code":"301","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":"NONE","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":"N","pen_cen_match":null,"final_status_date":"2022-11-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","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":"2","hazmat_oos_total":"0","snet_sequence_id":"8832112","transaction_code":"A","transaction_date":"2022-11-21 00:00:00","upload_date":"2022-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2022-11-21 21:41:00","snet_input_date":"2022-11-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-21 21:41:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2025-03-17T18:59:39.000000Z","updated_at":"2025-03-17T18:59:39.000000Z","inspection_violations":[{"id":2800400,"change_date":"2022-11-21 21:41:00","inspection_id":"77191757","insp_violation_id":"249726663","seq_no":"1","part_no":"172","part_no_section":"203(d)(6)","insp_viol_unit":"1","insp_unit_id":"192071877","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"172203D6"},{"id":2800401,"change_date":"2022-11-21 21:41:00","inspection_id":"77191757","insp_violation_id":"249726664","seq_no":"2","part_no":"172","part_no_section":"403(g)","insp_viol_unit":"1","insp_unit_id":"192071877","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"172403G"}],"inspection_per_units":[{"id":2879674,"change_date":"2022-11-21 21:41:00","inspection_id":"77191757","insp_unit_id":"192071877","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"T375","insp_unit_license":"51565V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT7X2B69KED64009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:41.000000Z","updated_at":"2025-03-17T22:26:41.000000Z"}]},{"id":1789647,"change_date":"2022-11-21 21:41:00","inspection_id":"77191438","dot_number":"1987749","report_state":"TX","report_number":"6G280ALIJ8","insp_date":"2022-11-15 00:00:00","insp_start_time":"0751","insp_end_time":"0831","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-2119 IN REEVES CO. (164-196","county_code_state":"TX","county_code":"389","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MOTEL","shipping_paper_number":"NONE","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":"N","pen_cen_match":null,"final_status_date":"2022-11-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"4","hazmat_oos_total":"1","snet_sequence_id":"8831864","transaction_code":"A","transaction_date":"2022-11-21 00:00:00","upload_date":"2022-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01987749","upload_search_indicator":"M","census_search_date":"2022-11-21 21:41:00","snet_input_date":"2022-11-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-21 21:41:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2025-03-17T18:59:39.000000Z","updated_at":"2025-03-17T18:59:39.000000Z","inspection_violations":[{"id":2799323,"change_date":"2022-11-21 21:41:00","inspection_id":"77191438","insp_violation_id":"249725247","seq_no":"1","part_no":"177","part_no_section":"817(a)","insp_viol_unit":"1","insp_unit_id":"192071205","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:20:06.000000Z","updated_at":"2025-03-17T21:20:06.000000Z","normalized_code":"177817A"},{"id":2799324,"change_date":"2022-11-21 21:41:00","inspection_id":"77191438","insp_violation_id":"249725248","seq_no":"2","part_no":"172","part_no_section":"602(b)","insp_viol_unit":"1","insp_unit_id":"192071205","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:06.000000Z","updated_at":"2025-03-17T21:20:06.000000Z","normalized_code":"172602B"},{"id":2799325,"change_date":"2022-11-21 21:41:00","inspection_id":"77191438","insp_violation_id":"249725249","seq_no":"3","part_no":"172","part_no_section":"403(a)","insp_viol_unit":"1","insp_unit_id":"192071205","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:06.000000Z","updated_at":"2025-03-17T21:20:06.000000Z","normalized_code":"172403A"},{"id":2799326,"change_date":"2022-11-21 21:41:00","inspection_id":"77191438","insp_violation_id":"249725250","seq_no":"4","part_no":"172","part_no_section":"324","insp_viol_unit":"1","insp_unit_id":"192071205","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:06.000000Z","updated_at":"2025-03-17T21:20:06.000000Z","normalized_code":"172324"}],"inspection_per_units":[{"id":2879181,"change_date":"2022-11-21 21:41:00","inspection_id":"77191438","insp_unit_id":"192071205","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"T285","insp_unit_license":"51307V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT7X2B64HEF21860","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:41.000000Z","updated_at":"2025-03-17T22:26:41.000000Z"}]},{"id":435912,"change_date":"2022-05-19 21:42:00","inspection_id":"75612910","dot_number":"1987749","report_state":"TX","report_number":"6AUA0XLWUQ","insp_date":"2022-05-11 00:00:00","insp_start_time":"1010","insp_end_time":"1149","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0302 IN WINKLER CO. (210-24","county_code_state":"TX","county_code":"495","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AMERICAN PIPING INSPECTION","shipping_paper_number":"NONE","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":"N","pen_cen_match":null,"final_status_date":"2022-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","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":"1","hazmat_oos_total":"1","snet_sequence_id":"8658828","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":"01987749","upload_search_indicator":"M","census_search_date":"2022-05-19 21:42:00","snet_input_date":"2022-05-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-19 21:42:00","insp_carrier_name":"AMERICAN PIPING INSPECTION INC","insp_carrier_street":"17110 EAST PINE","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":"1007775","created_at":"2025-03-17T18:35:11.000000Z","updated_at":"2025-03-17T18:35:11.000000Z","inspection_violations":[{"id":685897,"change_date":"2022-05-19 21:42:00","inspection_id":"75612910","insp_violation_id":"245928725","seq_no":"1","part_no":"177","part_no_section":"817(a)","insp_viol_unit":"1","insp_unit_id":"188797624","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:14.000000Z","updated_at":"2025-03-17T21:10:14.000000Z","normalized_code":"177817A"}],"inspection_per_units":[{"id":702909,"change_date":"2022-05-19 21:42:00","inspection_id":"75612910","insp_unit_id":"188797624","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"T245","insp_unit_license":"V64235","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT7X2B69HEB90032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:31.000000Z","updated_at":"2025-03-17T22:12:31.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1987749\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1987749\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1987749\/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\/1987749\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}