{"current_page":1,"data":[{"id":12289817,"change_date":"2026-06-26 21:38:00","inspection_id":"88245748","dot_number":"1570388","report_state":"WY","report_number":"TJJW000171","insp_date":"2026-06-25 00:00:00","insp_start_time":"1600","insp_end_time":"1637","registration_date":null,"region":"MD","ci_status_code":"C","location":"ML25","location_desc":"WY","county_code_state":"WY","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MID AMERICAN PIPELINE CONSTRUCTION","shipping_paper_number":"06-25-2026","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25400","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":"3624995","transaction_code":"A","transaction_date":"2026-06-26 00:00:00","upload_date":"2026-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2026-06-26 21:38:00","snet_input_date":"2026-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-26 21:38:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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-06-29T09:41:18.000000Z","updated_at":"2026-07-01T09:38:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21346568,"change_date":"2026-06-26 21:38:00","inspection_id":"88245748","insp_unit_id":"214300494","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"4775","insp_unit_license":"354C26","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD8W3FN0TED44775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-29T09:16:22.000000Z","updated_at":"2026-07-01T09:13:12.000000Z"},{"id":21346569,"change_date":"2026-06-26 21:38:00","inspection_id":"88245748","insp_unit_id":"214300495","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STAV","insp_unit_company":"9681","insp_unit_license":"3083LD","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13YFS25227C099681","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-29T09:16:22.000000Z","updated_at":"2026-07-01T09:13:12.000000Z"}]},{"id":12279713,"change_date":"2026-06-25 21:51:00","inspection_id":"88239446","dot_number":"1570388","report_state":"WY","report_number":"PCDO001738","insp_date":"2026-06-23 00:00:00","insp_start_time":"0747","insp_end_time":"0921","registration_date":null,"region":"MS","ci_status_code":"C","location":"ML180","location_desc":"WY","county_code_state":"WY","county_code":"021","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MID AMERICA PIPELINE CONSTRUCTION INC","shipping_paper_number":"62326","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-06-25 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3604603","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2026-06-25 21:51:00","snet_input_date":"2026-06-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-25 21:51:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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-06-28T09:39:47.000000Z","updated_at":"2026-07-01T09:36:50.000000Z","inspection_violations":[{"id":21374105,"change_date":"2026-06-25 21:51:00","inspection_id":"88239446","insp_violation_id":"275124060","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-28T09:56:32.000000Z","updated_at":"2026-07-01T09:52:43.000000Z","normalized_code":"39141APC"},{"id":21374106,"change_date":"2026-06-25 21:51:00","inspection_id":"88239446","insp_violation_id":"275124061","seq_no":"2","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-28T09:56:32.000000Z","updated_at":"2026-07-01T09:52:43.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":21322636,"change_date":"2026-06-25 21:51:00","inspection_id":"88239446","insp_unit_id":"214283209","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"1237","insp_unit_license":"285C18","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C6UR5DL0TG301237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:15:25.000000Z","updated_at":"2026-07-01T09:11:05.000000Z"},{"id":21322637,"change_date":"2026-06-25 21:51:00","inspection_id":"88239446","insp_unit_id":"214283210","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"DN1002","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"49TCB2022K1029456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:15:25.000000Z","updated_at":"2026-07-01T09:11:05.000000Z"}]},{"id":12141288,"change_date":"2026-06-09 21:42:00","inspection_id":"88089652","dot_number":"1570388","report_state":"TX","report_number":"7G0B9DTKED","insp_date":"2026-06-01 00:00:00","insp_start_time":"1126","insp_end_time":"1147","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2300  STATE HIGHWAY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"METALPLATE GLAVANIZING","shipping_paper_number":"173276","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-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9985587","transaction_code":"A","transaction_date":"2026-06-09 00:00:00","upload_date":"2026-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2026-06-09 21:42:00","snet_input_date":"2026-06-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-09 21:42:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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":"0254505","created_at":"2026-06-12T09:40:08.000000Z","updated_at":"2026-06-20T09:33:24.000000Z","inspection_violations":[{"id":21130758,"change_date":"2026-06-09 21:42:00","inspection_id":"88089652","insp_violation_id":"274798418","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"214001815","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:51.000000Z","updated_at":"2026-06-19T09:48:40.000000Z","normalized_code":"39021A"},{"id":21130759,"change_date":"2026-06-09 21:42:00","inspection_id":"88089652","insp_violation_id":"274798419","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"214001815","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:51.000000Z","updated_at":"2026-06-19T09:48:40.000000Z","normalized_code":"39395F"},{"id":21130760,"change_date":"2026-06-09 21:42:00","inspection_id":"88089652","insp_violation_id":"274798420","seq_no":"3","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"214001815","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:51.000000Z","updated_at":"2026-06-19T09:48:40.000000Z","normalized_code":"39360D"},{"id":21130761,"change_date":"2026-06-09 21:42:00","inspection_id":"88089652","insp_violation_id":"274798421","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"214001815","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:59:51.000000Z","updated_at":"2026-06-19T09:48:40.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":21093004,"change_date":"2026-06-09 21:42:00","inspection_id":"88089652","insp_unit_id":"214001815","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"354C25","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD8W3HT4TED19082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:16:04.000000Z","updated_at":"2026-06-20T09:05:38.000000Z"},{"id":21093005,"change_date":"2026-06-09 21:42:00","inspection_id":"88089652","insp_unit_id":"214001816","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"AT5362","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VGX4023L6023927","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:16:04.000000Z","updated_at":"2026-06-20T09:05:38.000000Z"}]},{"id":11964909,"change_date":"2026-05-19 21:41:00","inspection_id":"87901282","dot_number":"1570388","report_state":"IA","report_number":"000P123HFM","insp_date":"2026-05-14 00:00:00","insp_start_time":"1242","insp_end_time":"1321","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"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":"N","pen_cen_match":null,"final_status_date":"2026-05-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"18400","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":"1","hazmat_oos_total":"1","snet_sequence_id":"1401317","transaction_code":"A","transaction_date":"2026-05-19 00:00:00","upload_date":"2026-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2026-05-19 21:41:00","snet_input_date":"2026-05-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-05-19 21:41:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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-05-22T09:41:15.000000Z","updated_at":"2026-05-30T09:31:05.000000Z","inspection_violations":[{"id":20811163,"change_date":"2026-05-19 21:41:00","inspection_id":"87901282","insp_violation_id":"274370779","seq_no":"1","part_no":"392","part_no_section":"2C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1LOP26051413094","created_at":"2026-05-22T10:01:40.000000Z","updated_at":"2026-05-30T09:41:38.000000Z","normalized_code":"3922C"},{"id":20811164,"change_date":"2026-05-19 21:41:00","inspection_id":"87901282","insp_violation_id":"274370780","seq_no":"2","part_no":"177","part_no_section":"834A-HMC","insp_viol_unit":"1","insp_unit_id":"213648766","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-22T10:01:40.000000Z","updated_at":"2026-05-30T09:41:38.000000Z","normalized_code":"177834AHMC"}],"inspection_per_units":[{"id":20803241,"change_date":"2026-05-19 21:41:00","inspection_id":"87901282","insp_unit_id":"213648765","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"7991","insp_unit_license":"5777P1","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VFX2029J2017991","insp_unit_decal":"Y","insp_unit_decal_number":"36427094","created_at":"2026-05-22T09:21:53.000000Z","updated_at":"2026-05-30T09:03:31.000000Z"},{"id":20803242,"change_date":"2026-05-19 21:41:00","inspection_id":"87901282","insp_unit_id":"213648766","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"6301","insp_unit_license":"354C30","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD8W3FN9TED46301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-22T09:21:53.000000Z","updated_at":"2026-05-30T09:03:31.000000Z"}]},{"id":11965493,"change_date":"2026-05-19 21:41:00","inspection_id":"87901907","dot_number":"1570388","report_state":"IA","report_number":"000P13DLMF","insp_date":"2026-05-10 00:00:00","insp_start_time":"1515","insp_end_time":"1555","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 60 NB & K64","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PRIVATE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21400","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":"1400352","transaction_code":"A","transaction_date":"2026-05-19 00:00:00","upload_date":"2026-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2026-05-19 21:41:00","snet_input_date":"2026-05-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-05-19 21:41:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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-05-22T09:41:16.000000Z","updated_at":"2026-05-30T09:31:13.000000Z","inspection_violations":[{"id":20812917,"change_date":"2026-05-19 21:41:00","inspection_id":"87901907","insp_violation_id":"274372833","seq_no":"1","part_no":"395","part_no_section":"30B1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7HIL26051015435","created_at":"2026-05-22T10:01:43.000000Z","updated_at":"2026-05-30T09:41:52.000000Z","normalized_code":"39530B1"},{"id":20812918,"change_date":"2026-05-19 21:41:00","inspection_id":"87901907","insp_violation_id":"274372834","seq_no":"2","part_no":"392","part_no_section":"2IN","insp_viol_unit":"1","insp_unit_id":"213649850","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7HIL26051015440","created_at":"2026-05-22T10:01:43.000000Z","updated_at":"2026-05-30T09:41:52.000000Z","normalized_code":"3922IN"},{"id":20812919,"change_date":"2026-05-19 21:41:00","inspection_id":"87901907","insp_violation_id":"274372835","seq_no":"3","part_no":"395","part_no_section":"8E1PC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:43.000000Z","updated_at":"2026-05-30T09:41:52.000000Z","normalized_code":"3958E1PC"}],"inspection_per_units":[{"id":20804231,"change_date":"2026-05-19 21:41:00","inspection_id":"87901907","insp_unit_id":"213649850","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"6301","insp_unit_license":"354C40","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD8W3FN9TED46301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-22T09:21:54.000000Z","updated_at":"2026-05-30T09:03:38.000000Z"},{"id":20804232,"change_date":"2026-05-19 21:41:00","inspection_id":"87901907","insp_unit_id":"213649851","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DOOL","insp_unit_company":"3877","insp_unit_license":"AH5373","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1DGCS2026HM023877","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-22T09:21:54.000000Z","updated_at":"2026-05-30T09:03:38.000000Z"}]},{"id":11710648,"change_date":"2026-04-21 21:39:00","inspection_id":"87637597","dot_number":"1570388","report_state":"IA","report_number":"000P120FQ9","insp_date":"2026-04-17 00:00:00","insp_start_time":"1313","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I-35 SB","county_code_state":"IA","county_code":"033","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MID AMERICA PIPELINE CONSTRUCTION I","shipping_paper_number":"SELF","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"7","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1397767","transaction_code":"A","transaction_date":"2026-04-17 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2026-04-21 21:39:00","snet_input_date":"2026-04-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-04-21 21:39:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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-27T09:37:58.000000Z","updated_at":"2026-05-02T09:31:02.000000Z","inspection_violations":[{"id":20352646,"change_date":"2026-04-21 21:39:00","inspection_id":"87637597","insp_violation_id":"273751857","seq_no":"7","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"213140269","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:31.000000Z","updated_at":"2026-05-02T09:43:13.000000Z","normalized_code":"39617C"},{"id":20352640,"change_date":"2026-04-21 21:39:00","inspection_id":"87637597","insp_violation_id":"273751851","seq_no":"1","part_no":"390","part_no_section":"21TB","insp_viol_unit":"1","insp_unit_id":"213140269","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:31.000000Z","updated_at":"2026-05-02T09:43:13.000000Z","normalized_code":"39021TB"},{"id":20352641,"change_date":"2026-04-21 21:39:00","inspection_id":"87637597","insp_violation_id":"273751852","seq_no":"2","part_no":"392","part_no_section":"71A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:31.000000Z","updated_at":"2026-05-02T09:43:13.000000Z","normalized_code":"39271A"},{"id":20352642,"change_date":"2026-04-21 21:39:00","inspection_id":"87637597","insp_violation_id":"273751853","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":"2026-04-27T09:55:31.000000Z","updated_at":"2026-05-02T09:43:13.000000Z","normalized_code":"3922"},{"id":20352643,"change_date":"2026-04-21 21:39:00","inspection_id":"87637597","insp_violation_id":"273751854","seq_no":"4","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"213140269","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:31.000000Z","updated_at":"2026-05-02T09:43:13.000000Z","normalized_code":"39360D"},{"id":20352644,"change_date":"2026-04-21 21:39:00","inspection_id":"87637597","insp_violation_id":"273751855","seq_no":"5","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"213140269","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:31.000000Z","updated_at":"2026-05-02T09:43:13.000000Z","normalized_code":"39395A"},{"id":20352645,"change_date":"2026-04-21 21:39:00","inspection_id":"87637597","insp_violation_id":"273751856","seq_no":"6","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213140269","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:31.000000Z","updated_at":"2026-05-02T09:43:13.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":20378860,"change_date":"2026-04-21 21:39:00","inspection_id":"87637597","insp_unit_id":"213140270","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"4518","insp_unit_license":"8059P6","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"13YBF222XJC124518","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:14:25.000000Z","updated_at":"2026-05-02T09:03:33.000000Z"},{"id":20378859,"change_date":"2026-04-21 21:39:00","inspection_id":"87637597","insp_unit_id":"213140269","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"1576","insp_unit_license":"128C36","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C6UR5FL4SG511576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:14:25.000000Z","updated_at":"2026-05-02T09:03:33.000000Z"}]},{"id":11143610,"change_date":"2026-02-17 21:38:00","inspection_id":"87057745","dot_number":"1570388","report_state":"ND","report_number":"TR20002155","insp_date":"2026-02-15 00:00:00","insp_start_time":"1039","insp_end_time":"1108","registration_date":null,"region":"CS","ci_status_code":"C","location":"MOORTN","location_desc":"MOORETON ND","county_code_state":"ND","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MIDAMERICA","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"153000","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":"2895521","transaction_code":"A","transaction_date":"2026-02-16 00:00:00","upload_date":"2026-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2026-02-17 21:38:00","snet_input_date":"2026-02-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-17 21:38:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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-20T10:37:40.000000Z","updated_at":"2026-02-28T10:30:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19010594,"change_date":"2026-02-17 21:38:00","inspection_id":"87057745","insp_unit_id":"211649286","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"195703","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XKWD49XXLR283257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-20T10:14:23.000000Z","updated_at":"2026-02-28T10:02:39.000000Z"},{"id":19010595,"change_date":"2026-02-17 21:38:00","inspection_id":"87057745","insp_unit_id":"211649287","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"XL","insp_unit_company":null,"insp_unit_license":"AT5562","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4U3J05338FL015012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-20T10:14:23.000000Z","updated_at":"2026-02-28T10:02:39.000000Z"}]},{"id":11083849,"change_date":"2026-02-09 21:38:00","inspection_id":"86995154","dot_number":"1570388","report_state":"KS","report_number":"HP93160324","insp_date":"2026-02-06 00:00:00","insp_start_time":"1330","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":"#26A","location_desc":"SOUTH HAVEN M.C.I.S","county_code_state":"KS","county_code":"191","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"M.C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"152860","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":"1388240","transaction_code":"A","transaction_date":"2026-02-06 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2026-02-09 21:38:00","snet_input_date":"2026-02-06 00:00:00","source_office":"3KSS001","mcmis_add_date":"2026-02-09 21:38:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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-12T10:36:59.000000Z","updated_at":"2026-02-20T10:30:46.000000Z","inspection_violations":[{"id":18553208,"change_date":"2026-02-09 21:38:00","inspection_id":"86995154","insp_violation_id":"271679534","seq_no":"1","part_no":"395","part_no_section":"8E1PC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:29.000000Z","updated_at":"2026-02-20T10:39:08.000000Z","normalized_code":"3958E1PC"}],"inspection_per_units":[{"id":18900122,"change_date":"2026-02-09 21:38:00","inspection_id":"86995154","insp_unit_id":"211519483","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6827","insp_unit_license":"3BK152","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKWLB9X8YR856827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:38.000000Z","updated_at":"2026-02-20T10:03:50.000000Z"},{"id":18900123,"change_date":"2026-02-09 21:38:00","inspection_id":"86995154","insp_unit_id":"211519484","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"X-L S","insp_unit_company":"5623","insp_unit_license":"AT5561","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4U3J05332GL015623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:38.000000Z","updated_at":"2026-02-20T10:03:50.000000Z"}]},{"id":10289711,"change_date":"2025-11-25 21:39:00","inspection_id":"86414886","dot_number":"1570388","report_state":"TX","report_number":"V252106959","insp_date":"2025-11-22 00:00:00","insp_start_time":"0844","insp_end_time":"0905","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"271M IH20 WB SVC RD","county_code_state":"TX","county_code":"441","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MID AMERICA PIPELINE CONTRUCT","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-11-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"142350","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":"9768712","transaction_code":"A","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2025-11-25 21:39:00","snet_input_date":"2025-11-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-25 21:39:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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":"0254505","created_at":"2025-11-28T10:32:00.000000Z","updated_at":"2025-11-29T10:31:15.000000Z","inspection_violations":[{"id":17208125,"change_date":"2025-11-25 21:39:00","inspection_id":"86414886","insp_violation_id":"270297605","seq_no":"1","part_no":"393","part_no_section":"75A","insp_viol_unit":"2","insp_unit_id":"210266838","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-11-28T10:33:01.000000Z","updated_at":"2025-11-29T10:32:06.000000Z","normalized_code":"39375A"},{"id":17208126,"change_date":"2025-11-25 21:39:00","inspection_id":"86414886","insp_violation_id":"270297606","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"210266837","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-28T10:33:01.000000Z","updated_at":"2025-11-29T10:32:06.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":17180875,"change_date":"2025-11-25 21:39:00","inspection_id":"86414886","insp_unit_id":"210266837","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5751","insp_unit_license":"240507","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XKZDP9X2RJ325751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-28T10:01:44.000000Z","updated_at":"2025-11-29T10:01:24.000000Z"},{"id":17180876,"change_date":"2025-11-25 21:39:00","inspection_id":"86414886","insp_unit_id":"210266838","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":"3341","insp_unit_license":"2110KA","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5VGFR4035EL003341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-28T10:01:44.000000Z","updated_at":"2025-11-29T10:01:24.000000Z"}]},{"id":10378169,"change_date":"2025-12-08 21:38:00","inspection_id":"86507391","dot_number":"1570388","report_state":"IA","report_number":"000P169BPN","insp_date":"2025-11-14 00:00:00","insp_start_time":"0951","insp_end_time":"1038","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"PIPELINE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"23400","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1383300","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2025-12-08 21:38:00","snet_input_date":"2025-11-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-12-08 21:38:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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-12-11T10:30:33.000000Z","updated_at":"2025-12-12T10:30:51.000000Z","inspection_violations":[{"id":17379720,"change_date":"2025-12-08 21:38:00","inspection_id":"86507391","insp_violation_id":"270533196","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"210478758","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-11T10:30:47.000000Z","updated_at":"2025-12-12T10:31:25.000000Z","normalized_code":"39360D"},{"id":17379721,"change_date":"2025-12-08 21:38:00","inspection_id":"86507391","insp_violation_id":"270533197","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"210478758","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-11T10:30:47.000000Z","updated_at":"2025-12-12T10:31:25.000000Z","normalized_code":"39617C"},{"id":17379722,"change_date":"2025-12-08 21:38:00","inspection_id":"86507391","insp_violation_id":"270533198","seq_no":"3","part_no":"395","part_no_section":"8F01","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-12-11T10:30:47.000000Z","updated_at":"2025-12-12T10:31:25.000000Z","normalized_code":"3958F01"}],"inspection_per_units":[{"id":17347927,"change_date":"2025-12-08 21:38:00","inspection_id":"86507391","insp_unit_id":"210478758","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"68","insp_unit_license":"68C649","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD8W3FN6RED55563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-11T10:00:32.000000Z","updated_at":"2025-12-12T10:00:52.000000Z"},{"id":17347928,"change_date":"2025-12-08 21:38:00","inspection_id":"86507391","insp_unit_id":"210478759","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"61","insp_unit_license":"6101JT","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"49TCB1625C1007468","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-11T10:00:32.000000Z","updated_at":"2025-12-12T10:00:52.000000Z"}]},{"id":10147926,"change_date":"2025-11-07 21:40:00","inspection_id":"86265998","dot_number":"1570388","report_state":"TX","report_number":"V252083928","insp_date":"2025-11-06 00:00:00","insp_start_time":"0905","insp_end_time":"0942","registration_date":null,"region":"CT","ci_status_code":"C","location":"5C001","location_desc":"IH20 LORAINE SCALE","county_code_state":"TX","county_code":"335","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MID AMERICA","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-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"84000","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":"9751465","transaction_code":"A","transaction_date":"2025-11-07 00:00:00","upload_date":"2025-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2025-11-07 21:40:00","snet_input_date":"2025-11-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-07 21:40:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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":"0254505","created_at":"2025-11-10T10:31:44.000000Z","updated_at":"2025-11-11T10:31:01.000000Z","inspection_violations":[{"id":16842731,"change_date":"2025-11-07 21:40:00","inspection_id":"86265998","insp_violation_id":"269814872","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"209909152","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:51.000000Z","updated_at":"2025-11-11T10:32:03.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":16894476,"change_date":"2025-11-07 21:40:00","inspection_id":"86265998","insp_unit_id":"209909152","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3348","insp_unit_license":"3KL646","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPVX4TX0RD663348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:02:16.000000Z","updated_at":"2025-11-11T10:01:13.000000Z"}]},{"id":9566455,"change_date":"2025-09-09 21:40:00","inspection_id":"85654964","dot_number":"1570388","report_state":"OK","report_number":"W600171735","insp_date":"2025-08-28 00:00:00","insp_start_time":"1315","insp_end_time":"1451","registration_date":"2025-09-08 00:00:00","region":"CT","ci_status_code":"C","location":"099019","location_desc":"SH 99 N\/ SH 33 BYPASS","county_code_state":"OK","county_code":"037","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","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":"2025-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"796106","transaction_code":"C","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2025-09-02 21:39:00","snet_input_date":"2025-08-28 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-09-02 21:39:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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-06T10:43:02.000000Z","updated_at":"2025-09-13T10:46:22.000000Z","inspection_violations":[{"id":15748681,"change_date":"2025-09-09 21:40:00","inspection_id":"85654964","insp_violation_id":"268552963","seq_no":"1","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"208828944","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:09.000000Z","updated_at":"2025-09-13T10:48:38.000000Z","normalized_code":"3939ALSLI"},{"id":15748682,"change_date":"2025-09-09 21:40:00","inspection_id":"85654964","insp_violation_id":"268552964","seq_no":"2","part_no":"393","part_no_section":"70B1I-CDFWFMI-LT20","insp_viol_unit":"1","insp_unit_id":"208828944","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:09.000000Z","updated_at":"2025-09-13T10:48:38.000000Z","normalized_code":"39370B1ICDFWFMILT20"},{"id":15748683,"change_date":"2025-09-09 21:40:00","inspection_id":"85654964","insp_violation_id":"268552965","seq_no":"3","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"208828945","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-12T10:51:09.000000Z","updated_at":"2025-09-13T10:48:38.000000Z","normalized_code":"3939ALSLIWR"},{"id":15748684,"change_date":"2025-09-09 21:40:00","inspection_id":"85654964","insp_violation_id":"268552966","seq_no":"4","part_no":"393","part_no_section":"207A-STCB","insp_viol_unit":"2","insp_unit_id":"208828945","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-12T10:51:09.000000Z","updated_at":"2025-09-13T10:48:38.000000Z","normalized_code":"393207ASTCB"}],"inspection_per_units":[{"id":15903222,"change_date":"2025-09-09 21:40:00","inspection_id":"85654964","insp_unit_id":"208828944","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2865","insp_unit_license":"3AX052","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPXDB9X88D762865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:41.000000Z","updated_at":"2025-09-13T09:59:05.000000Z"},{"id":15903223,"change_date":"2025-09-09 21:40:00","inspection_id":"85654964","insp_unit_id":"208828945","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONT","insp_unit_company":"7027","insp_unit_license":"6632JT","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"13N14830115997027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:41.000000Z","updated_at":"2025-09-13T09:59:05.000000Z"}]},{"id":8910324,"change_date":"2025-06-16 21:39:00","inspection_id":"84963871","dot_number":"1570388","report_state":"IA","report_number":"000P169B30","insp_date":"2025-06-13 00:00:00","insp_start_time":"1239","insp_end_time":"1323","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"MISC","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":"2025-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"1364108","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2025-06-16 21:39:00","snet_input_date":"2025-06-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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-06-19T10:00:23.000000Z","updated_at":"2025-06-20T10:00:27.000000Z","inspection_violations":[{"id":14287837,"change_date":"2025-06-16 21:39:00","inspection_id":"84963871","insp_violation_id":"266866587","seq_no":"1","part_no":"396","part_no_section":"3A1-HC","insp_viol_unit":"2","insp_unit_id":"207407503","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-19T10:15:33.000000Z","updated_at":"2025-06-20T10:15:48.000000Z","normalized_code":"3963A1HC"},{"id":14287838,"change_date":"2025-06-16 21:39:00","inspection_id":"84963871","insp_violation_id":"266866588","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"207407502","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:33.000000Z","updated_at":"2025-06-20T10:15:48.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":14599031,"change_date":"2025-06-16 21:39:00","inspection_id":"84963871","insp_unit_id":"207407502","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"49","insp_unit_license":"68C649","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD8W3FN6RED55563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:22.000000Z","updated_at":"2025-06-20T09:45:35.000000Z"},{"id":14599032,"change_date":"2025-06-16 21:39:00","inspection_id":"84963871","insp_unit_id":"207407503","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"80","insp_unit_license":"CX6280","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VPX2024K206765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:22.000000Z","updated_at":"2025-06-20T09:45:35.000000Z"}]},{"id":8776213,"change_date":"2025-05-30 21:40:00","inspection_id":"84821563","dot_number":"1570388","report_state":"MN","report_number":"1618000532","insp_date":"2025-05-23 00:00:00","insp_start_time":"1311","insp_end_time":"1341","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"EYOTA MN","county_code_state":"MN","county_code":"109","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"2025-05-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"11400","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1800462","transaction_code":"A","transaction_date":"2025-05-30 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2025-05-30 21:40:00","snet_input_date":"2025-05-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-30 21:40:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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-06-04T10:01:04.000000Z","updated_at":"2025-06-04T10:01:04.000000Z","inspection_violations":[{"id":14027862,"change_date":"2025-05-30 21:40:00","inspection_id":"84821563","insp_violation_id":"266568584","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"207144552","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-06-02T10:17:04.000000Z","updated_at":"2025-06-03T10:17:05.000000Z","normalized_code":"393100BC"},{"id":14027863,"change_date":"2025-05-30 21:40:00","inspection_id":"84821563","insp_violation_id":"266568585","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"207144552","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-06-02T10:17:04.000000Z","updated_at":"2025-06-03T10:17:05.000000Z","normalized_code":"3939ALLPL"},{"id":14027864,"change_date":"2025-05-30 21:40:00","inspection_id":"84821563","insp_violation_id":"266568586","seq_no":"3","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"207144552","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-06-02T10:17:04.000000Z","updated_at":"2025-06-03T10:17:05.000000Z","normalized_code":"3939ALSML"},{"id":14027865,"change_date":"2025-05-30 21:40:00","inspection_id":"84821563","insp_violation_id":"266568587","seq_no":"4","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-06-02T10:17:04.000000Z","updated_at":"2025-06-03T10:17:05.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":14358812,"change_date":"2025-05-30 21:40:00","inspection_id":"84821563","insp_unit_id":"207144552","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"5563","insp_unit_license":"68C649","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD8W3FN6RED55563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:19.000000Z","updated_at":"2025-06-03T09:45:28.000000Z"}]},{"id":8608251,"change_date":"2025-05-12 21:41:00","inspection_id":"84644248","dot_number":"1570388","report_state":"TX","report_number":"V251841784","insp_date":"2025-05-08 00:00:00","insp_start_time":"1405","insp_end_time":"1456","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 45 SB 166","county_code_state":"TX","county_code":"289","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MID AMERICA PIPELINE CONST.","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-05-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9574548","transaction_code":"A","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2025-05-12 21:41:00","snet_input_date":"2025-05-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-12 21:41:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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":"0254505","created_at":"2025-05-15T10:01:19.000000Z","updated_at":"2025-05-17T10:06:09.000000Z","inspection_violations":[{"id":13679965,"change_date":"2025-05-12 21:41:00","inspection_id":"84644248","insp_violation_id":"266168991","seq_no":"1","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"206812322","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-15T10:22:17.000000Z","updated_at":"2025-05-16T10:29:12.000000Z","normalized_code":"393100A"},{"id":13679966,"change_date":"2025-05-12 21:41:00","inspection_id":"84644248","insp_violation_id":"266168992","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206812323","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:22:17.000000Z","updated_at":"2025-05-16T10:29:12.000000Z","normalized_code":"3939"},{"id":13679967,"change_date":"2025-05-12 21:41:00","inspection_id":"84644248","insp_violation_id":"266168993","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"206812322","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:22:17.000000Z","updated_at":"2025-05-16T10:29:12.000000Z","normalized_code":"3939"},{"id":13679968,"change_date":"2025-05-12 21:41:00","inspection_id":"84644248","insp_violation_id":"266168994","seq_no":"4","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"206812322","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-15T10:22:17.000000Z","updated_at":"2025-05-16T10:29:12.000000Z","normalized_code":"3939TS"},{"id":13679969,"change_date":"2025-05-12 21:41:00","inspection_id":"84644248","insp_violation_id":"266168995","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"206812322","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:22:17.000000Z","updated_at":"2025-05-16T10:29:12.000000Z","normalized_code":"3922RG"},{"id":13679970,"change_date":"2025-05-12 21:41:00","inspection_id":"84644248","insp_violation_id":"266168996","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206812323","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:22:17.000000Z","updated_at":"2025-05-16T10:29:12.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":14053069,"change_date":"2025-05-12 21:41:00","inspection_id":"84644248","insp_unit_id":"206812322","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"7427","insp_unit_license":"AT7067","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VGX3526L6057427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:21.000000Z","updated_at":"2025-05-16T09:51:34.000000Z"},{"id":14053070,"change_date":"2025-05-12 21:41:00","inspection_id":"84644248","insp_unit_id":"206812323","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"0073","insp_unit_license":"91887V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT8W3DT0JEC90073","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:21.000000Z","updated_at":"2025-05-16T09:51:34.000000Z"}]},{"id":8087372,"change_date":"2025-03-12 21:41:00","inspection_id":"84095696","dot_number":"1570388","report_state":"TX","report_number":"V251791358","insp_date":"2025-03-05 00:00:00","insp_start_time":"0644","insp_end_time":"0728","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US59 MM428","county_code_state":"TX","county_code":"373","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MID-AMERICA","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-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"65502","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":"9519688","transaction_code":"C","transaction_date":"2025-03-12 00:00:00","upload_date":"2025-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2025-03-11 21:41:00","snet_input_date":"2025-03-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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":"0254505","created_at":"2025-03-17T21:06:16.000000Z","updated_at":"2025-03-17T21:06:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13057554,"change_date":"2025-03-12 21:41:00","inspection_id":"84095696","insp_unit_id":"205765009","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5754","insp_unit_license":"240487","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XKZDP9X0RJ325764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:21.000000Z","updated_at":"2025-03-17T23:59:21.000000Z"},{"id":13057555,"change_date":"2025-03-12 21:41:00","inspection_id":"84095696","insp_unit_id":"205765010","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SPLZ","insp_unit_company":"4618","insp_unit_license":"AT5563","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4U3J05336FL014618","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:21.000000Z","updated_at":"2025-03-17T23:59:21.000000Z"}]},{"id":7971083,"change_date":"2025-02-27 21:42:00","inspection_id":"83973389","dot_number":"1570388","report_state":"TX","report_number":"737D9DJW36","insp_date":"2025-02-25 00:00:00","insp_start_time":"1329","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400  E LOOP N S\/R E","county_code_state":"TX","county_code":"201","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":"Y","pen_cen_match":null,"final_status_date":"2025-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"84000","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":"9508092","transaction_code":"C","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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":"0254505","created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[{"id":12455059,"change_date":"2025-02-27 21:42:00","inspection_id":"83973389","insp_violation_id":"264747214","seq_no":"1","part_no":"393","part_no_section":"55C2","insp_viol_unit":"1","insp_unit_id":"205545367","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39355C2"},{"id":12455060,"change_date":"2025-02-27 21:42:00","inspection_id":"83973389","insp_violation_id":"264747215","seq_no":"2","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205545367","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"3929"}],"inspection_per_units":[{"id":12868218,"change_date":"2025-02-27 21:42:00","inspection_id":"83973389","insp_unit_id":"205545367","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"3KL645","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPCX4TXXRD663311","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"}]},{"id":7723100,"change_date":"2025-01-28 21:38:00","inspection_id":"83712893","dot_number":"1570388","report_state":"MN","report_number":"2690000350","insp_date":"2025-01-21 00:00:00","insp_start_time":"1128","insp_end_time":"1202","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MAPLEWOOD MN","county_code_state":"MN","county_code":"123","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-28 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"3","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":"1293705","transaction_code":"A","transaction_date":"2025-01-28 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2025-01-28 21:38:00","snet_input_date":"2025-01-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-28 21:38:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:58:40.000000Z","updated_at":"2025-03-17T20:58:40.000000Z","inspection_violations":[{"id":12067076,"change_date":"2025-01-28 21:38:00","inspection_id":"83712893","insp_violation_id":"264205236","seq_no":"1","part_no":"392","part_no_section":"2-SLLT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3922SLLT"},{"id":12067077,"change_date":"2025-01-28 21:38:00","inspection_id":"83712893","insp_violation_id":"264205237","seq_no":"2","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-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3922SLLTL"},{"id":12067078,"change_date":"2025-01-28 21:38:00","inspection_id":"83712893","insp_violation_id":"264205238","seq_no":"3","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":12462951,"change_date":"2025-01-28 21:38:00","inspection_id":"83712893","insp_unit_id":"205033941","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2444","insp_unit_license":"32C864","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD8W3HT9NEF12444","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:30.000000Z","updated_at":"2025-03-17T23:52:30.000000Z"}]},{"id":7487492,"change_date":"2024-12-23 21:39:00","inspection_id":"83465707","dot_number":"1570388","report_state":"IA","report_number":"000P123FV4","insp_date":"2024-12-16 00:00:00","insp_start_time":"1146","insp_end_time":"1211","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MID AMERICA PIPELINE CONSTRUCTION I","shipping_paper_number":"OWN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"23540","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":"1342336","transaction_code":"A","transaction_date":"2024-12-23 00:00:00","upload_date":"2024-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2024-12-23 21:39:00","snet_input_date":"2024-12-16 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-23 21:39:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:52:19.000000Z","updated_at":"2025-03-17T20:52:19.000000Z","inspection_violations":[{"id":11704488,"change_date":"2024-12-23 21:39:00","inspection_id":"83465707","insp_violation_id":"263633945","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204532542","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"39360D"},{"id":11704489,"change_date":"2024-12-23 21:39:00","inspection_id":"83465707","insp_violation_id":"263633946","seq_no":"2","part_no":"393","part_no_section":"9T","insp_viol_unit":"2","insp_unit_id":"204532543","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"3939T"},{"id":11704490,"change_date":"2024-12-23 21:39:00","inspection_id":"83465707","insp_violation_id":"263633947","seq_no":"3","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"204532543","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:02.000000Z","updated_at":"2025-03-17T22:03:02.000000Z","normalized_code":"393130"}],"inspection_per_units":[{"id":12079437,"change_date":"2024-12-23 21:39:00","inspection_id":"83465707","insp_unit_id":"204532542","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"6766","insp_unit_license":"64C970","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C6UR5DL3RG266766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:22.000000Z","updated_at":"2025-03-17T23:48:22.000000Z"},{"id":12079438,"change_date":"2024-12-23 21:39:00","inspection_id":"83465707","insp_unit_id":"204532543","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"NORST","insp_unit_company":"7094","insp_unit_license":"DJ3723","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"50HCH1825H1007094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:22.000000Z","updated_at":"2025-03-17T23:48:22.000000Z"}]},{"id":7135210,"change_date":"2024-11-06 21:40:00","inspection_id":"83094226","dot_number":"1570388","report_state":"IA","report_number":"000P1155N0","insp_date":"2024-11-05 00:00:00","insp_start_time":"1014","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":"01","location_desc":"01 - I80 WB MM 151 MITCHELLVIL","county_code_state":"IA","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MID AMERICA PIPELINE","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":"2024-11-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1336426","transaction_code":"A","transaction_date":"2024-11-06 00:00:00","upload_date":"2024-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2024-11-06 21:40:00","snet_input_date":"2024-11-05 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-11-06 21:40:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:44:42.000000Z","updated_at":"2025-03-17T20:44:42.000000Z","inspection_violations":[{"id":11145735,"change_date":"2024-11-06 21:40:00","inspection_id":"83094226","insp_violation_id":"262760496","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"3922"},{"id":11145736,"change_date":"2024-11-06 21:40:00","inspection_id":"83094226","insp_violation_id":"262760497","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"203763613","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":11508065,"change_date":"2024-11-06 21:40:00","inspection_id":"83094226","insp_unit_id":"203763612","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1910","insp_unit_license":"68C650","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD8W3FN9RED61910","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:13.000000Z","updated_at":"2025-03-17T23:42:13.000000Z"},{"id":11508066,"change_date":"2024-11-06 21:40:00","inspection_id":"83094226","insp_unit_id":"203763613","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STAV","insp_unit_company":"T1","insp_unit_license":"9925P0","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"13YBF222XJC124518","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:13.000000Z","updated_at":"2025-03-17T23:42:13.000000Z"}]},{"id":7025664,"change_date":"2024-10-23 21:42:00","inspection_id":"82978168","dot_number":"1570388","report_state":"IA","report_number":"000P16CVKM","insp_date":"2024-10-21 00:00:00","insp_start_time":"1618","insp_end_time":"1700","registration_date":null,"region":"CT","ci_status_code":"C","location":"10","location_desc":"10 - I35 NB MM 30 OSCEOLA","county_code_state":"IA","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MID AMERICA PIPELINE CONSTRUCTION","shipping_paper_number":"OWN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"18060","viol_total":"5","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1333851","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2024-10-23 21:42:00","snet_input_date":"2024-10-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-10-23 21:42:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:42:37.000000Z","updated_at":"2025-03-17T20:42:37.000000Z","inspection_violations":[{"id":10965242,"change_date":"2024-10-23 21:42:00","inspection_id":"82978168","insp_violation_id":"262514331","seq_no":"1","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"203548008","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39348A"},{"id":10965243,"change_date":"2024-10-23 21:42:00","inspection_id":"82978168","insp_violation_id":"262514332","seq_no":"2","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"203548008","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3963A1BOS"},{"id":10965244,"change_date":"2024-10-23 21:42:00","inspection_id":"82978168","insp_violation_id":"262514333","seq_no":"3","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"203548008","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39343D"},{"id":10965245,"change_date":"2024-10-23 21:42:00","inspection_id":"82978168","insp_violation_id":"262514334","seq_no":"4","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"203548007","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39395A"},{"id":10965246,"change_date":"2024-10-23 21:42:00","inspection_id":"82978168","insp_violation_id":"262514335","seq_no":"5","part_no":"395","part_no_section":"22G","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39522G"}],"inspection_per_units":[{"id":11330908,"change_date":"2024-10-23 21:42:00","inspection_id":"82978168","insp_unit_id":"203548007","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1910","insp_unit_license":"68C650","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD8W3FN9RED61910","insp_unit_decal":"Y","insp_unit_decal_number":"34679231","created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"},{"id":11330909,"change_date":"2024-10-23 21:42:00","inspection_id":"82978168","insp_unit_id":"203548008","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STARLITE","insp_unit_company":"4518","insp_unit_license":"9925P0","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"13YBF222XJC124518","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"}]},{"id":6963732,"change_date":"2024-10-15 21:43:00","inspection_id":"82912258","dot_number":"1570388","report_state":"TX","report_number":"6ZE89DBF2P","insp_date":"2024-10-11 00:00:00","insp_start_time":"0802","insp_end_time":"0856","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2200  CLINTON DR","county_code_state":"TX","county_code":"201","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":"Y","pen_cen_match":null,"final_status_date":"2024-10-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","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":"9402084","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2024-10-15 21:43:00","snet_input_date":"2024-10-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-15 21:43:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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":"0254505","created_at":"2025-03-17T20:41:23.000000Z","updated_at":"2025-03-17T20:41:23.000000Z","inspection_violations":[{"id":10858867,"change_date":"2024-10-15 21:43:00","inspection_id":"82912258","insp_violation_id":"262364509","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203421109","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:58:36.000000Z","updated_at":"2025-03-17T21:58:36.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":11231489,"change_date":"2024-10-15 21:43:00","inspection_id":"82912258","insp_unit_id":"203421108","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":null,"insp_unit_license":"195703","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XKWD49XXLR283257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:17.000000Z","updated_at":"2025-03-17T23:39:17.000000Z"},{"id":11231490,"change_date":"2024-10-15 21:43:00","inspection_id":"82912258","insp_unit_id":"203421109","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"XLST","insp_unit_company":null,"insp_unit_license":"AT5562","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4U3J05338FL015012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:17.000000Z","updated_at":"2025-03-17T23:39:17.000000Z"}]},{"id":6630080,"change_date":"2024-09-03 21:41:00","inspection_id":"82557352","dot_number":"1570388","report_state":"OK","report_number":"N600000542","insp_date":"2024-09-03 00:00:00","insp_start_time":"1030","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":"50035","location_desc":"DAVIS SCALES","county_code_state":"OK","county_code":"099","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MC","shipping_paper_number":"09032024","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-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"760054","transaction_code":"A","transaction_date":"2024-09-03 00:00:00","upload_date":"2024-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2024-09-03 21:41:00","snet_input_date":"2024-09-03 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-09-03 21:41:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:34:27.000000Z","updated_at":"2025-03-17T20:34:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10689098,"change_date":"2024-09-03 21:41:00","inspection_id":"82557352","insp_unit_id":"202722927","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7217","insp_unit_license":"26C123","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD8W3HT3NEG27217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:41.000000Z","updated_at":"2025-03-17T23:33:41.000000Z"}]},{"id":6574386,"change_date":"2024-08-27 21:42:00","inspection_id":"82497820","dot_number":"1570388","report_state":"OK","report_number":"V600172180","insp_date":"2024-08-27 00:00:00","insp_start_time":"1000","insp_end_time":"1118","registration_date":null,"region":"CT","ci_status_code":"C","location":"41260","location_desc":"CIMARRON TURNPIKE\/ MM 32","county_code_state":"OK","county_code":"119","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"154320","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":"759259","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2024-08-27 21:42:00","snet_input_date":"2024-08-27 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-08-27 21:42:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:33:13.000000Z","updated_at":"2025-03-17T20:33:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10598808,"change_date":"2024-08-27 21:42:00","inspection_id":"82497820","insp_unit_id":"202607416","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"3EB926","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KJJAEDR9LPLW1510","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:47.000000Z","updated_at":"2025-03-17T23:32:47.000000Z"},{"id":10598809,"change_date":"2024-08-27 21:42:00","inspection_id":"82497820","insp_unit_id":"202607417","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"XL","insp_unit_company":"4618","insp_unit_license":"AT5563","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4U3J05336FL014618","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:47.000000Z","updated_at":"2025-03-17T23:32:47.000000Z"}]},{"id":6369621,"change_date":"2024-08-06 21:43:00","inspection_id":"82279293","dot_number":"1570388","report_state":"OK","report_number":"PE10175669","insp_date":"2024-08-01 00:00:00","insp_start_time":"1325","insp_end_time":"1405","registration_date":"2024-08-05 00:00:00","region":"CT","ci_status_code":"C","location":"43035","location_desc":"LOVE PORT ENTRY","county_code_state":"OK","county_code":"085","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-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"756634","transaction_code":"C","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","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":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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":[{"id":9888172,"change_date":"2024-08-06 21:43:00","inspection_id":"82279293","insp_violation_id":"261041108","seq_no":"1","part_no":"395","part_no_section":"22(h)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"39522H1"},{"id":9888173,"change_date":"2024-08-06 21:43:00","inspection_id":"82279293","insp_violation_id":"261041109","seq_no":"2","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"202260379","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"39381"},{"id":9888174,"change_date":"2024-08-06 21:43:00","inspection_id":"82279293","insp_violation_id":"261041110","seq_no":"3","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"202260379","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":10264541,"change_date":"2024-08-06 21:43:00","inspection_id":"82279293","insp_unit_id":"202260379","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3692","insp_unit_license":"04942V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT8W3DT7HEB13692","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":6445000,"change_date":"2024-08-12 21:43:00","inspection_id":"82360090","dot_number":"1570388","report_state":"KS","report_number":"HP02195267","insp_date":"2024-08-01 00:00:00","insp_start_time":"1901","insp_end_time":"1941","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":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1333977","transaction_code":"A","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2024-08-12 21:43:00","snet_input_date":"2024-08-01 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-08-12 21:43:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:30:40.000000Z","updated_at":"2025-03-17T20:30:40.000000Z","inspection_violations":[{"id":10007941,"change_date":"2024-08-12 21:43:00","inspection_id":"82360090","insp_violation_id":"261140036","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:26.000000Z","updated_at":"2025-03-17T21:54:26.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":10387840,"change_date":"2024-08-12 21:43:00","inspection_id":"82360090","insp_unit_id":"202346145","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1752","insp_unit_license":"90344V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT8W3DT6KED51752","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:39.000000Z","updated_at":"2025-03-17T23:30:39.000000Z"}]},{"id":6249237,"change_date":"2024-07-30 21:44:00","inspection_id":"82150625","dot_number":"1570388","report_state":"OK","report_number":"PE07100428","insp_date":"2024-07-18 00:00:00","insp_start_time":"1105","insp_end_time":"1145","registration_date":"2024-07-30 00:00:00","region":"CT","ci_status_code":"C","location":"43035","location_desc":"BRYAN COUNTY PORT OF ENTRY","county_code_state":"OK","county_code":"013","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MC","shipping_paper_number":"07182024","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":"14000","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":"754846","transaction_code":"C","transaction_date":"2024-07-18 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","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":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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":[{"id":9708758,"change_date":"2024-07-30 21:44:00","inspection_id":"82150625","insp_violation_id":"260919786","seq_no":"1","part_no":"393","part_no_section":"67(c)(7)(v)","insp_viol_unit":"1","insp_unit_id":"202147774","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"39367C7V"}],"inspection_per_units":[{"id":10069026,"change_date":"2024-07-30 21:44:00","inspection_id":"82150625","insp_unit_id":"202147774","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7217","insp_unit_license":"26C123","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FD8W3HT3NEG27217","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":6213137,"change_date":"2024-07-14 21:33:00","inspection_id":"82111709","dot_number":"1570388","report_state":"AL","report_number":"MMHP003659","insp_date":"2024-07-13 00:00:00","insp_start_time":"1645","insp_end_time":"1745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"EXIT RAMP","county_code_state":"AL","county_code":"093","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MID AMERICA PIPELINE CONSTRUCTION INC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-14 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"4","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1013643","transaction_code":"A","transaction_date":"2024-07-13 00:00:00","upload_date":"2024-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2024-07-14 21:33:00","snet_input_date":"2024-07-14 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-07-14 21:33:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"PO BOX 1830","insp_carrier_city":"CATOOSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74015","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:48.000000Z","updated_at":"2025-03-17T20:25:48.000000Z","inspection_violations":[{"id":9650009,"change_date":"2024-07-14 21:33:00","inspection_id":"82111709","insp_violation_id":"260630161","seq_no":"1","part_no":"395","part_no_section":"3(a)(3)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:42.000000Z","updated_at":"2025-03-17T21:52:42.000000Z","normalized_code":"3953A3II"},{"id":9650010,"change_date":"2024-07-14 21:33:00","inspection_id":"82111709","insp_violation_id":"260630162","seq_no":"2","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:42.000000Z","updated_at":"2025-03-17T21:52:42.000000Z","normalized_code":"3958"},{"id":9650011,"change_date":"2024-07-14 21:33:00","inspection_id":"82111709","insp_violation_id":"260630163","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:42.000000Z","updated_at":"2025-03-17T21:52:42.000000Z","normalized_code":"3922"},{"id":9650012,"change_date":"2024-07-14 21:33:00","inspection_id":"82111709","insp_violation_id":"260630164","seq_no":"4","part_no":"390","part_no_section":"403(a)","insp_viol_unit":"1","insp_unit_id":"201874265","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:42.000000Z","updated_at":"2025-03-17T21:52:42.000000Z","normalized_code":"390403A"}],"inspection_per_units":[{"id":10009976,"change_date":"2024-07-14 21:33:00","inspection_id":"82111709","insp_unit_id":"201874265","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"3743","insp_unit_license":"57C142","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C6UR5DL7RG153743","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:43.000000Z","updated_at":"2025-03-17T23:26:43.000000Z"},{"id":10009977,"change_date":"2024-07-14 21:33:00","inspection_id":"82111709","insp_unit_id":"201874266","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"0778","insp_unit_license":"CY3618","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3EVBC2027R1110778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:43.000000Z","updated_at":"2025-03-17T23:26:43.000000Z"}]},{"id":5808644,"change_date":"2024-05-21 21:47:00","inspection_id":"81674528","dot_number":"1570388","report_state":"KS","report_number":"HP03017042","insp_date":"2024-05-20 00:00:00","insp_start_time":"1000","insp_end_time":"1125","registration_date":null,"region":"CT","ci_status_code":"C","location":"MI","location_desc":"MIAMI COUNTY - 121","county_code_state":"KS","county_code":"121","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"N","pen_cen_match":null,"final_status_date":"2024-05-21 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"22500","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":"1325472","transaction_code":"A","transaction_date":"2024-05-20 00:00:00","upload_date":"2024-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2024-05-21 21:47:00","snet_input_date":"2024-05-20 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-05-21 21:47:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:52.000000Z","updated_at":"2025-03-17T20:17:52.000000Z","inspection_violations":[{"id":8995986,"change_date":"2024-05-21 21:47:00","inspection_id":"81674528","insp_violation_id":"259644770","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"201014768","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"39360D"},{"id":8995987,"change_date":"2024-05-21 21:47:00","inspection_id":"81674528","insp_violation_id":"259644771","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"201014769","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"39343"},{"id":8995988,"change_date":"2024-05-21 21:47:00","inspection_id":"81674528","insp_violation_id":"259644772","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201014769","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9355061,"change_date":"2024-05-21 21:47:00","inspection_id":"81674528","insp_unit_id":"201014768","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"6207","insp_unit_license":"RKP7164","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FT7W2BT5NEF06207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:09.000000Z","updated_at":"2025-03-17T23:20:09.000000Z"},{"id":9355062,"change_date":"2024-05-21 21:47:00","inspection_id":"81674528","insp_unit_id":"201014769","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"3567","insp_unit_license":"AT5549","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5FTEE2429G1003567","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:09.000000Z","updated_at":"2025-03-17T23:20:09.000000Z"}]},{"id":5632221,"change_date":"2024-05-06 21:43:00","inspection_id":"81483154","dot_number":"1570388","report_state":"OK","report_number":"PE10175431","insp_date":"2024-04-30 00:00:00","insp_start_time":"1200","insp_end_time":"1315","registration_date":"2024-05-06 00:00:00","region":"CT","ci_status_code":"C","location":"50035","location_desc":"DAVIS NB SCALE","county_code_state":"OK","county_code":"099","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"M\/C","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":"N","pen_cen_match":null,"final_status_date":"2024-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25150","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":"745412","transaction_code":"C","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2024-04-30 21:41:00","snet_input_date":"2024-04-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-04-30 21:41:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:19.000000Z","updated_at":"2025-03-17T20:14:19.000000Z","inspection_violations":[{"id":8707968,"change_date":"2024-05-06 21:43:00","inspection_id":"81483154","insp_violation_id":"259331929","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"200742257","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39395F"},{"id":8707969,"change_date":"2024-05-06 21:43:00","inspection_id":"81483154","insp_violation_id":"259331930","seq_no":"2","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"200742257","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39375G"},{"id":8707970,"change_date":"2024-05-06 21:43:00","inspection_id":"81483154","insp_violation_id":"259331931","seq_no":"3","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"200742258","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39343D"}],"inspection_per_units":[{"id":9072220,"change_date":"2024-05-06 21:43:00","inspection_id":"81483154","insp_unit_id":"200742257","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"9591","insp_unit_license":"Z424627","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1GT49MEY4PF199591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:25.000000Z","updated_at":"2025-03-17T23:17:25.000000Z"},{"id":9072221,"change_date":"2024-05-06 21:43:00","inspection_id":"81483154","insp_unit_id":"200742258","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CM","insp_unit_company":"6156","insp_unit_license":"BK6674","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"49TCG2425J1026156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:25.000000Z","updated_at":"2025-03-17T23:17:25.000000Z"}]},{"id":5401443,"change_date":"2024-03-29 21:38:00","inspection_id":"81231022","dot_number":"1570388","report_state":"TX","report_number":"V241375801","insp_date":"2024-03-27 00:00:00","insp_start_time":"0755","insp_end_time":"0913","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:31   30' 18.72N","county_code_state":"TX","county_code":"347","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VALERO","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":"Y","pen_cen_match":null,"final_status_date":"2024-03-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"173000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9234932","transaction_code":"A","transaction_date":"2024-03-29 00:00:00","upload_date":"2024-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2024-03-29 21:38:00","snet_input_date":"2024-03-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-29 21:38:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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":"0254505","created_at":"2025-03-17T20:09:49.000000Z","updated_at":"2025-03-17T20:09:49.000000Z","inspection_violations":[{"id":8336497,"change_date":"2024-03-29 21:38:00","inspection_id":"81231022","insp_violation_id":"258662817","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200160619","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"39311"},{"id":8336498,"change_date":"2024-03-29 21:38:00","inspection_id":"81231022","insp_violation_id":"258662818","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"200160620","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"39311"},{"id":8336499,"change_date":"2024-03-29 21:38:00","inspection_id":"81231022","insp_violation_id":"258662819","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"3922"},{"id":8336500,"change_date":"2024-03-29 21:38:00","inspection_id":"81231022","insp_violation_id":"258662820","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8699517,"change_date":"2024-03-29 21:38:00","inspection_id":"81231022","insp_unit_id":"200160619","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"2613","insp_unit_license":"52Y355V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KJJAEBG2HPJC2613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"},{"id":8699518,"change_date":"2024-03-29 21:38:00","inspection_id":"81231022","insp_unit_id":"200160620","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":"0088","insp_unit_license":"59Y355V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7UZFR4334R2000088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"}]},{"id":5214355,"change_date":"2024-03-15 21:40:00","inspection_id":"81026971","dot_number":"1570388","report_state":"OK","report_number":"PE19000442","insp_date":"2024-03-05 00:00:00","insp_start_time":"1200","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":"07069","location_desc":"COLBERT SCALES ON US69","county_code_state":"OK","county_code":"013","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"M\/C","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":"2024-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","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":"739464","transaction_code":"C","transaction_date":"2024-03-15 00:00:00","upload_date":"2024-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2024-03-05 21:40:00","snet_input_date":"2024-03-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-03-05 21:40:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:05:47.000000Z","updated_at":"2025-03-17T20:05:47.000000Z","inspection_violations":[{"id":8035559,"change_date":"2024-03-15 21:40:00","inspection_id":"81026971","insp_violation_id":"258409375","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"199936506","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"39395F"},{"id":8035560,"change_date":"2024-03-15 21:40:00","inspection_id":"81026971","insp_violation_id":"258409376","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"199936507","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":8396145,"change_date":"2024-03-15 21:40:00","inspection_id":"81026971","insp_unit_id":"199936506","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"90344V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT8W3DT6KED51752","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:05.000000Z","updated_at":"2025-03-17T23:11:05.000000Z"},{"id":8396146,"change_date":"2024-03-15 21:40:00","inspection_id":"81026971","insp_unit_id":"199936507","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"BG6366","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"13YFS20247C110235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:05.000000Z","updated_at":"2025-03-17T23:11:05.000000Z"}]},{"id":4421874,"change_date":"2023-11-27 21:41:00","inspection_id":"80160006","dot_number":"1570388","report_state":"OK","report_number":"PE15184135","insp_date":"2023-11-03 00:00:00","insp_start_time":"1542","insp_end_time":"1645","registration_date":"2023-11-21 00:00:00","region":"CT","ci_status_code":"C","location":"68040","location_desc":"SEQUOYAH PORT OF ENTRY","county_code_state":"OK","county_code":"135","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":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-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52860","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":"727765","transaction_code":"C","transaction_date":"2023-11-03 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2023-11-14 21:41:00","snet_input_date":"2023-11-03 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-11-14 21:41:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:50:40.000000Z","updated_at":"2025-03-17T19:50:40.000000Z","inspection_violations":[{"id":6841816,"change_date":"2023-11-27 21:41:00","inspection_id":"80160006","insp_violation_id":"256558567","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198209535","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7111003,"change_date":"2023-11-27 21:41:00","inspection_id":"80160006","insp_unit_id":"198209535","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6827","insp_unit_license":"3BK152","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKWLB9X8YR856827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:43.000000Z","updated_at":"2025-03-17T22:59:43.000000Z"}]},{"id":3813529,"change_date":"2023-08-23 21:40:00","inspection_id":"79485079","dot_number":"1570388","report_state":"CO","report_number":"PF14602947","insp_date":"2023-08-23 00:00:00","insp_start_time":"0826","insp_end_time":"0905","registration_date":null,"region":"MT","ci_status_code":"C","location":"I76","location_desc":"FORT MORGAN POE WB","county_code_state":"CO","county_code":"087","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"MID AMERICA PIPELINE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","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":"1256848","transaction_code":"A","transaction_date":"2023-08-23 00:00:00","upload_date":"2023-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2023-08-23 21:40:00","snet_input_date":"2023-08-23 00:00:00","source_office":"4COS001","mcmis_add_date":"2023-08-23 21:40:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"PO BOX 1830","insp_carrier_city":"CATOOSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74015","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:05.000000Z","updated_at":"2025-03-17T19:38:05.000000Z","inspection_violations":[{"id":5885462,"change_date":"2023-08-23 21:40:00","inspection_id":"79485079","insp_violation_id":"254835180","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"196689479","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"32306979","created_at":"2025-03-17T21:34:25.000000Z","updated_at":"2025-03-17T21:34:25.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":6131548,"change_date":"2023-08-23 21:40:00","inspection_id":"79485079","insp_unit_id":"196689479","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"22ZF66","insp_unit_license":"9201V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT8W3DT0KEC98059","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:31.000000Z","updated_at":"2025-03-17T22:51:31.000000Z"},{"id":6131549,"change_date":"2023-08-23 21:40:00","inspection_id":"79485079","insp_unit_id":"196689480","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"1","insp_unit_license":"BG6366","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"13YFS20247C110235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:31.000000Z","updated_at":"2025-03-17T22:51:31.000000Z"}]},{"id":3733206,"change_date":"2023-12-27 21:42:00","inspection_id":"79395324","dot_number":"1570388","report_state":"OK","report_number":"PE12005477","insp_date":"2023-08-10 00:00:00","insp_start_time":"1023","insp_end_time":"1046","registration_date":null,"region":"CT","ci_status_code":"C","location":"68040","location_desc":"SEQUOYAH POE","county_code_state":"OK","county_code":"135","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","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":"719059","transaction_code":"C","transaction_date":"2023-12-22 00:00:00","upload_date":"2023-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2023-08-14 21:42:00","snet_input_date":"2023-08-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-08-14 21:42:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:36:31.000000Z","updated_at":"2025-03-17T19:36:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6002288,"change_date":"2023-12-27 21:42:00","inspection_id":"79395324","insp_unit_id":"198685151","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7172","insp_unit_license":"33C112","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT7W2BT3NEG27172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:26.000000Z","updated_at":"2025-03-17T22:50:26.000000Z"},{"id":6002289,"change_date":"2023-12-27 21:42:00","inspection_id":"79395324","insp_unit_id":"198685152","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"7991","insp_unit_license":"5777P1","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VFX2029J2017991","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:26.000000Z","updated_at":"2025-03-17T22:50:26.000000Z"}]},{"id":2479722,"change_date":"2023-03-22 21:42:00","inspection_id":"77979796","dot_number":"1570388","report_state":"OK","report_number":"A300150616","insp_date":"2023-02-28 00:00:00","insp_start_time":"1400","insp_end_time":"1430","registration_date":"2023-03-21 00:00:00","region":"CT","ci_status_code":"C","location":"17044","location_desc":"H.E. BAILEY I44\/US 70","county_code_state":"OK","county_code":"033","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"700995","transaction_code":"C","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2023-03-01 21:41:00","snet_input_date":"2023-02-28 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-03-01 21:41:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:12:11.000000Z","updated_at":"2025-03-17T19:12:11.000000Z","inspection_violations":[{"id":3815728,"change_date":"2023-03-22 21:42:00","inspection_id":"77979796","insp_violation_id":"251800378","seq_no":"1","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:55.000000Z","updated_at":"2025-03-17T21:24:55.000000Z","normalized_code":"3953A2"}],"inspection_per_units":[{"id":3989998,"change_date":"2023-03-22 21:42:00","inspection_id":"77979796","insp_unit_id":"194000813","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CAT","insp_unit_company":"6019","insp_unit_license":"3DD361","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3HSJGTKR0GN066019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:34.000000Z","updated_at":"2025-03-17T22:34:34.000000Z"}]},{"id":1995237,"change_date":"2022-12-21 21:39:00","inspection_id":"77426681","dot_number":"1570388","report_state":"OK","report_number":"PE05173131","insp_date":"2022-12-19 00:00:00","insp_start_time":"1816","insp_end_time":"1850","registration_date":null,"region":"CT","ci_status_code":"C","location":"43035","location_desc":"LOVE PORT OF ENTRY","county_code_state":"OK","county_code":"085","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"M\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"694533","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2022-12-21 21:39:00","snet_input_date":"2022-12-19 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-12-21 21:39:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:03:21.000000Z","updated_at":"2025-03-17T19:03:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3209811,"change_date":"2022-12-21 21:39:00","inspection_id":"77426681","insp_unit_id":"192536087","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"724547","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KJJAEBG2HPJC2613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:58.000000Z","updated_at":"2025-03-17T22:28:58.000000Z"},{"id":3209812,"change_date":"2022-12-21 21:39:00","inspection_id":"77426681","insp_unit_id":"192536088","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":"3341","insp_unit_license":"2110KA","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5VGFR4035EL003341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:58.000000Z","updated_at":"2025-03-17T22:28:58.000000Z"}]},{"id":1974310,"change_date":"2022-12-29 21:40:00","inspection_id":"77402970","dot_number":"1570388","report_state":"SD","report_number":"004B001354","insp_date":"2022-12-12 00:00:00","insp_start_time":"1043","insp_end_time":"1051","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"MM 74 SD 79","county_code_state":"SD","county_code":"103","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","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-12-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"633086","transaction_code":"C","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2022-12-19 21:41:00","snet_input_date":"2022-12-19 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-12-19 21:41:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"PO BOX 1830","insp_carrier_city":"CATOOSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74015","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:58.000000Z","updated_at":"2025-03-17T19:02:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3176654,"change_date":"2022-12-29 21:40:00","inspection_id":"77402970","insp_unit_id":"192636295","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6440","insp_unit_license":"3GL216","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGNDR2JDJY6440","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:45.000000Z","updated_at":"2025-03-17T22:28:45.000000Z"},{"id":3176655,"change_date":"2022-12-29 21:40:00","inspection_id":"77402970","insp_unit_id":"192636296","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"XPLO","insp_unit_company":"6124","insp_unit_license":"AT5786","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4U3J05339HL016124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:45.000000Z","updated_at":"2025-03-17T22:28:45.000000Z"}]},{"id":1850593,"change_date":"2022-12-08 21:40:00","inspection_id":"77261069","dot_number":"1570388","report_state":"OK","report_number":"H800153429","insp_date":"2022-12-01 00:00:00","insp_start_time":"0913","insp_end_time":"1004","registration_date":"2022-12-07 00:00:00","region":"CT","ci_status_code":"C","location":"12271","location_desc":"HUGO SCALES NB","county_code_state":"OK","county_code":"023","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","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-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","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":"692765","transaction_code":"C","transaction_date":"2022-12-01 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2022-12-01 21:41:00","snet_input_date":"2022-12-01 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-12-01 21:41:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:00:45.000000Z","updated_at":"2025-03-17T19:00:45.000000Z","inspection_violations":[{"id":2884471,"change_date":"2022-12-08 21:40:00","inspection_id":"77261069","insp_violation_id":"249992734","seq_no":"1","part_no":"395","part_no_section":"22(h)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:47.000000Z","updated_at":"2025-03-17T21:20:47.000000Z","normalized_code":"39522H2"},{"id":2884472,"change_date":"2022-12-08 21:40:00","inspection_id":"77261069","insp_violation_id":"249992735","seq_no":"2","part_no":"395","part_no_section":"22(h)(3)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:47.000000Z","updated_at":"2025-03-17T21:20:47.000000Z","normalized_code":"39522H3"},{"id":2884473,"change_date":"2022-12-08 21:40:00","inspection_id":"77261069","insp_violation_id":"249992736","seq_no":"3","part_no":"395","part_no_section":"22(h)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:47.000000Z","updated_at":"2025-03-17T21:20:47.000000Z","normalized_code":"39522H1"},{"id":2884474,"change_date":"2022-12-08 21:40:00","inspection_id":"77261069","insp_violation_id":"249992737","seq_no":"4","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:47.000000Z","updated_at":"2025-03-17T21:20:47.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":2977633,"change_date":"2022-12-08 21:40:00","inspection_id":"77261069","insp_unit_id":"192326964","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"04C554","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C6UR5CL5JG315200","insp_unit_decal":"Y","insp_unit_decal_number":"32049812","created_at":"2025-03-17T22:27:23.000000Z","updated_at":"2025-03-17T22:27:23.000000Z"},{"id":2977634,"change_date":"2022-12-08 21:40:00","inspection_id":"77261069","insp_unit_id":"192326965","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"9P5329","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VEX2020J2003554","insp_unit_decal":"Y","insp_unit_decal_number":"32049813","created_at":"2025-03-17T22:27:23.000000Z","updated_at":"2025-03-17T22:27:23.000000Z"}]},{"id":1708181,"change_date":"2022-11-09 21:40:00","inspection_id":"77097912","dot_number":"1570388","report_state":"MO","report_number":"W132006230","insp_date":"2022-11-07 00:00:00","insp_start_time":"1238","insp_end_time":"1321","registration_date":null,"region":"CT","ci_status_code":"C","location":"D4E","location_desc":"D4 EAST","county_code_state":"MO","county_code":"145","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"MID-AMERICA PIPELINE CONSTRUCTION INC.","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2042489","transaction_code":"A","transaction_date":"2022-11-07 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-09 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"PO BOX 1830","insp_carrier_city":"CATOOSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74015","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":2748031,"change_date":"2022-11-09 21:40:00","inspection_id":"77097912","insp_unit_id":"191884572","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2234","insp_unit_license":"04C430","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT8W3DT0KED52234","insp_unit_decal":"Y","insp_unit_decal_number":"NOTAVAIL","created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"},{"id":2748032,"change_date":"2022-11-09 21:40:00","inspection_id":"77097912","insp_unit_id":"191884573","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"3450","insp_unit_license":"6465JD","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4ZEPH2022D1043450","insp_unit_decal":"Y","insp_unit_decal_number":"NOTAVAIL","created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":1677403,"change_date":"2022-11-04 21:38:00","inspection_id":"77062599","dot_number":"1570388","report_state":"KS","report_number":"HP02660704","insp_date":"2022-11-03 00:00:00","insp_start_time":"1248","insp_end_time":"1343","registration_date":null,"region":"CT","ci_status_code":"C","location":"#26A","location_desc":"SOUTH HAVEN M.C.I.S. #26A","county_code_state":"KS","county_code":"191","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MID AMERICA PIPELINE","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-11-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","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":"1270084","transaction_code":"A","transaction_date":"2022-11-03 00:00:00","upload_date":"2022-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2022-11-04 21:38:00","snet_input_date":"2022-11-03 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-11-04 21:38:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:57:28.000000Z","updated_at":"2025-03-17T18:57:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2698541,"change_date":"2022-11-04 21:38:00","inspection_id":"77062599","insp_unit_id":"191816747","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3692","insp_unit_license":"04942V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT8W3DT7HEB13692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:29.000000Z","updated_at":"2025-03-17T22:25:29.000000Z"},{"id":2698542,"change_date":"2022-11-04 21:38:00","inspection_id":"77062599","insp_unit_id":"191816748","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"PJ TR","insp_unit_company":"2170","insp_unit_license":"BW2170","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4P5CC202971092723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:29.000000Z","updated_at":"2025-03-17T22:25:29.000000Z"}]},{"id":1528114,"change_date":"2022-10-20 21:41:00","inspection_id":"76890922","dot_number":"1570388","report_state":"OK","report_number":"A406151021","insp_date":"2022-10-14 00:00:00","insp_start_time":"1145","insp_end_time":"1220","registration_date":"2022-10-20 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 7 & BEECH","county_code_state":"OK","county_code":"137","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"38000","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":"687686","transaction_code":"C","transaction_date":"2022-10-17 00:00:00","upload_date":"2022-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2022-10-17 21:41:00","snet_input_date":"2022-10-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-10-17 21:41:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:54:49.000000Z","updated_at":"2025-03-17T18:54:49.000000Z","inspection_violations":[{"id":2405037,"change_date":"2022-10-20 21:41:00","inspection_id":"76890922","insp_violation_id":"249144535","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:18:09.000000Z","updated_at":"2025-03-17T21:18:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2458762,"change_date":"2022-10-20 21:41:00","inspection_id":"76890922","insp_unit_id":"191546482","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3692","insp_unit_license":"04942V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FT8W3DT7HEB13692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:51.000000Z","updated_at":"2025-03-17T22:23:51.000000Z"},{"id":2458763,"change_date":"2022-10-20 21:41:00","inspection_id":"76890922","insp_unit_id":"191546483","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"0339","insp_unit_license":"3075LD","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"13YFS45288C110339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:51.000000Z","updated_at":"2025-03-17T22:23:51.000000Z"}]},{"id":1487348,"change_date":"2022-10-11 21:41:00","inspection_id":"76844113","dot_number":"1570388","report_state":"MO","report_number":"HT02003164","insp_date":"2022-10-10 00:00:00","insp_start_time":"1330","insp_end_time":"1355","registration_date":null,"region":"CT","ci_status_code":"C","location":"H35","location_desc":"NB I-35 AT REST AREA","county_code_state":"MO","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MID AMERICA PIPELINE","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"181995","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":"2036915","transaction_code":"A","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2022-10-11 21:41:00","snet_input_date":"2022-10-11 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-10-11 21:41:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"PO BOX 1830","insp_carrier_city":"CATOOSA","insp_carrier_state":"OK","insp_carrier_zip_code":"74015","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:07.000000Z","updated_at":"2025-03-17T18:54:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2393402,"change_date":"2022-10-11 21:41:00","inspection_id":"76844113","insp_unit_id":"191375525","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2865","insp_unit_license":"3AX052","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPXDB9X88D762865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:23.000000Z","updated_at":"2025-03-17T22:23:23.000000Z"},{"id":2393403,"change_date":"2022-10-11 21:41:00","inspection_id":"76844113","insp_unit_id":"191375526","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"2865","insp_unit_license":"BH6337","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4U3J05335KL018413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:23.000000Z","updated_at":"2025-03-17T22:23:23.000000Z"}]},{"id":1421447,"change_date":"2022-10-03 21:40:00","inspection_id":"76767685","dot_number":"1570388","report_state":"OK","report_number":"C713154137","insp_date":"2022-10-03 00:00:00","insp_start_time":"0920","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":"055044","location_desc":"OKLAHOMA CITY","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60320","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":"686193","transaction_code":"A","transaction_date":"2022-10-03 00:00:00","upload_date":"2022-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2022-10-03 21:40:00","snet_input_date":"2022-10-03 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-10-03 21:40:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:53:01.000000Z","updated_at":"2025-03-17T18:53:01.000000Z","inspection_violations":[{"id":2239216,"change_date":"2022-10-03 21:40:00","inspection_id":"76767685","insp_violation_id":"248780868","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:17:14.000000Z","updated_at":"2025-03-17T21:17:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2288299,"change_date":"2022-10-03 21:40:00","inspection_id":"76767685","insp_unit_id":"191224163","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"724547","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KJJAEBG2HPJC2613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:39.000000Z","updated_at":"2025-03-17T22:22:39.000000Z"}]},{"id":1284146,"change_date":"2022-09-14 21:40:00","inspection_id":"76607821","dot_number":"1570388","report_state":"IA","report_number":"000TT8BQ7G","insp_date":"2022-09-13 00:00:00","insp_start_time":"1249","insp_end_time":"1259","registration_date":null,"region":"CT","ci_status_code":"C","location":"14","location_desc":"14 - I29 NB MM 12 PERCIVAL","county_code_state":"IA","county_code":"071","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"EMPTY","shipping_paper_number":"EMPTY","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-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"1241944","transaction_code":"A","transaction_date":"2022-09-14 00:00:00","upload_date":"2022-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":"M","census_search_date":"2022-09-14 21:40:00","snet_input_date":"2022-09-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-09-14 21:40:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION INC","insp_carrier_street":"12115 E ADMIRAL PL","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:26.000000Z","updated_at":"2025-03-17T18:50:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2066952,"change_date":"2022-09-14 21:40:00","inspection_id":"76607821","insp_unit_id":"190895279","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"5196","insp_unit_license":"04C581","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3C6UR5CL5JG315195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:11.000000Z","updated_at":"2025-03-17T22:21:11.000000Z"},{"id":2066953,"change_date":"2022-09-14 21:40:00","inspection_id":"76607821","insp_unit_id":"190895280","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"7991","insp_unit_license":"5777P1","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"16VFX2029J2017991","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:11.000000Z","updated_at":"2025-03-17T22:21:11.000000Z"}]},{"id":4866508,"change_date":"2024-01-19 21:44:00","inspection_id":"80647278","dot_number":"1570388","report_state":"IL","report_number":"4068340110","insp_date":"2022-07-22 00:00:00","insp_start_time":"1012","insp_end_time":"1047","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I55","county_code_state":"IL","county_code":"105","insp_level_id":"3","service_center":"MW","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-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2302747","transaction_code":"A","transaction_date":"2022-07-22 00:00:00","upload_date":"2024-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01570388","upload_search_indicator":null,"census_search_date":"2024-01-19 21:44:00","snet_input_date":"2022-07-22 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-01-19 21:44:00","insp_carrier_name":"MID AMERICA PIPELINE CONSTRUCTION I","insp_carrier_street":"12115 E ADMIRAL PL","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:59:13.000000Z","updated_at":"2025-03-17T19:59:13.000000Z","inspection_violations":[{"id":7500616,"change_date":"2024-01-19 21:44:00","inspection_id":"80647278","insp_violation_id":"257415873","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:42:13.000000Z","updated_at":"2025-03-17T21:42:13.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":7829988,"change_date":"2024-01-19 21:44:00","inspection_id":"80647278","insp_unit_id":"199032799","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3740","insp_unit_license":"720850","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGLD64ESFS3740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:57.000000Z","updated_at":"2025-03-17T23:05:57.000000Z"},{"id":7829989,"change_date":"2024-01-19 21:44:00","inspection_id":"80647278","insp_unit_id":"199032800","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"XL","insp_unit_company":null,"insp_unit_license":"AT5562","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4U3J05338FL015012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:57.000000Z","updated_at":"2025-03-17T23:05:57.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1570388\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1570388\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1570388\/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\/1570388\/inspections","per_page":100,"prev_page_url":null,"to":46,"total":46}