{"current_page":1,"data":[{"id":12304727,"change_date":"2026-06-27 21:42:00","inspection_id":"88261966","dot_number":"1563469","report_state":"OK","report_number":"AG10000525","insp_date":"2026-06-27 00:00:00","insp_start_time":"1029","insp_end_time":"1049","registration_date":null,"region":"CD","ci_status_code":"C","location":"05040","location_desc":"OK","county_code_state":"OK","county_code":"009","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"PHILLIPS 66","shipping_paper_number":"787461","cargo_tank":"406","hazmat_placard_req":"Y","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-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"3637824","transaction_code":"A","transaction_date":"2026-06-27 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":"2026-06-27 21:42:00","snet_input_date":"2026-06-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:42:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-30T09:40:27.000000Z","updated_at":"2026-07-08T09:31:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21371858,"change_date":"2026-06-27 21:42:00","inspection_id":"88261966","insp_unit_id":"214330749","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2208","insp_unit_license":"3MD032","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGEBG0ESFT9215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:49.000000Z","updated_at":"2026-07-08T09:03:19.000000Z"},{"id":21371859,"change_date":"2026-06-27 21:42:00","inspection_id":"88261966","insp_unit_id":"214330750","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"244","insp_unit_license":"1081GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T4324AB000294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:49.000000Z","updated_at":"2026-07-08T09:03:19.000000Z"}]},{"id":12250944,"change_date":"2026-06-22 21:40:00","inspection_id":"88209361","dot_number":"1563469","report_state":"OK","report_number":"H600154779","insp_date":"2026-06-22 00:00:00","insp_start_time":"1545","insp_end_time":"1612","registration_date":null,"region":"CS","ci_status_code":"C","location":"63102","location_desc":"OK","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE","shipping_paper_number":"3228113","cargo_tank":"406","hazmat_placard_req":"Y","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-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"3596403","transaction_code":"A","transaction_date":"2026-06-22 00:00:00","upload_date":"2026-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":"2026-06-22 21:40:00","snet_input_date":"2026-06-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-22 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-25T09:38:56.000000Z","updated_at":"2026-07-03T09:31:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21274218,"change_date":"2026-06-22 21:40:00","inspection_id":"88209361","insp_unit_id":"214225187","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"265","insp_unit_license":"83C231","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3ALHG3FM8SDVV1897","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:21.000000Z","updated_at":"2026-07-05T09:02:07.000000Z"}]},{"id":12253968,"change_date":"2026-06-23 21:38:00","inspection_id":"88212435","dot_number":"1563469","report_state":"OK","report_number":"H600154780","insp_date":"2026-06-22 00:00:00","insp_start_time":"1613","insp_end_time":"1700","registration_date":null,"region":"CS","ci_status_code":"C","location":"63040","location_desc":"OK","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CVR SUPPLY & TRADING","shipping_paper_number":"903868","cargo_tank":"406","hazmat_placard_req":"Y","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-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117300","viol_total":"5","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3596620","transaction_code":"A","transaction_date":"2026-06-23 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":"2026-06-23 21:38:00","snet_input_date":"2026-06-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-23 21:38:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-26T09:40:38.000000Z","updated_at":"2026-07-04T09:30:13.000000Z","inspection_violations":[{"id":21330183,"change_date":"2026-06-23 21:38:00","inspection_id":"88212435","insp_violation_id":"275065704","seq_no":"1","part_no":"392","part_no_section":"2-LCDLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T10:00:51.000000Z","updated_at":"2026-07-04T09:42:08.000000Z","normalized_code":"3922LCDLR"},{"id":21330184,"change_date":"2026-06-23 21:38:00","inspection_id":"88212435","insp_violation_id":"275065705","seq_no":"2","part_no":"391","part_no_section":"11B4-CLHA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T10:00:51.000000Z","updated_at":"2026-07-04T09:42:08.000000Z","normalized_code":"39111B4CLHA"},{"id":21330185,"change_date":"2026-06-23 21:38:00","inspection_id":"88212435","insp_violation_id":"275065706","seq_no":"3","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"214231470","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T10:00:51.000000Z","updated_at":"2026-07-04T09:42:08.000000Z","normalized_code":"39360D"},{"id":21330186,"change_date":"2026-06-23 21:38:00","inspection_id":"88212435","insp_violation_id":"275065707","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"214231471","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T10:00:51.000000Z","updated_at":"2026-07-04T09:42:08.000000Z","normalized_code":"3939ALIL"},{"id":21330187,"change_date":"2026-06-23 21:38:00","inspection_id":"88212435","insp_violation_id":"275065708","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"214231471","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T10:00:51.000000Z","updated_at":"2026-07-04T09:42:08.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21279540,"change_date":"2026-06-23 21:38:00","inspection_id":"88212435","insp_unit_id":"214231470","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"2419","insp_unit_license":"54C310","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KJJAEBG3FPGN3484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:16:56.000000Z","updated_at":"2026-07-05T09:03:05.000000Z"},{"id":21279541,"change_date":"2026-06-23 21:38:00","inspection_id":"88212435","insp_unit_id":"214231471","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"233","insp_unit_license":"4499GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T43226B008160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:16:56.000000Z","updated_at":"2026-07-05T09:03:05.000000Z"}]},{"id":12009754,"change_date":"2026-05-25 21:34:00","inspection_id":"87948748","dot_number":"1563469","report_state":"OK","report_number":"B400000923","insp_date":"2026-05-25 00:00:00","insp_start_time":"1110","insp_end_time":"1145","registration_date":null,"region":"CS","ci_status_code":"C","location":"69081","location_desc":"OK","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-25 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"117300","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":"3397628","transaction_code":"A","transaction_date":"2026-05-25 00:00:00","upload_date":"2026-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":"2026-05-25 21:34:00","snet_input_date":"2026-05-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-25 21:34:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-28T09:39:22.000000Z","updated_at":"2026-06-06T09:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20876663,"change_date":"2026-05-25 21:34:00","inspection_id":"87948748","insp_unit_id":"213736223","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"2419","insp_unit_license":"54C310","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KJJAEBG3FPGN3484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-28T09:16:46.000000Z","updated_at":"2026-06-06T09:01:33.000000Z"},{"id":20876664,"change_date":"2026-05-25 21:34:00","inspection_id":"87948748","insp_unit_id":"213736224","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"233","insp_unit_license":"4499GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T43226B008160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-28T09:16:46.000000Z","updated_at":"2026-06-06T09:01:33.000000Z"}]},{"id":11994478,"change_date":"2026-05-22 21:38:00","inspection_id":"87932590","dot_number":"1563469","report_state":"OK","report_number":"N914155085","insp_date":"2026-05-22 00:00:00","insp_start_time":"0535","insp_end_time":"0610","registration_date":null,"region":"CS","ci_status_code":"C","location":"009040","location_desc":"OK","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"3216310","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"3384182","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:13.000000Z","updated_at":"2026-06-02T09:32:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20851441,"change_date":"2026-05-22 21:38:00","inspection_id":"87932590","insp_unit_id":"213706377","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"265","insp_unit_license":"83C231","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3ALHG3FM8SDVV1897","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:19.000000Z","updated_at":"2026-06-02T09:05:18.000000Z"}]},{"id":11986565,"change_date":"2026-05-22 08:07:00","inspection_id":"87924141","dot_number":"1563469","report_state":"OK","report_number":"A300152036","insp_date":"2026-05-21 00:00:00","insp_start_time":"1220","insp_end_time":"1245","registration_date":null,"region":"CS","ci_status_code":"C","location":"10076","location_desc":"OK","county_code_state":"OK","county_code":"019","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-22 08:07:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"3379330","transaction_code":"A","transaction_date":"2026-05-21 00:00:00","upload_date":"2026-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":"2026-05-22 08:07:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 08:07:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:02.000000Z","updated_at":"2026-06-02T09:31:15.000000Z","inspection_violations":[{"id":20852148,"change_date":"2026-05-22 08:07:00","inspection_id":"87924141","insp_violation_id":"274424423","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:00.000000Z","updated_at":"2026-06-02T09:41:59.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":20838475,"change_date":"2026-05-22 08:07:00","inspection_id":"87924141","insp_unit_id":"213690450","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"101","insp_unit_license":"20607V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDLP9X1FJ422653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:18:48.000000Z","updated_at":"2026-06-02T09:03:42.000000Z"}]},{"id":11478545,"change_date":"2026-03-25 21:40:00","inspection_id":"87397574","dot_number":"1563469","report_state":"TX","report_number":"V262273272","insp_date":"2026-03-16 00:00:00","insp_start_time":"1235","insp_end_time":"1252","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"EXIT 60 AT IH40 WB S","county_code_state":"TX","county_code":"375","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE CO","shipping_paper_number":"3188123","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9895451","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-03-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-25 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":"0962524","created_at":"2026-03-28T09:44:50.000000Z","updated_at":"2026-04-05T09:32:48.000000Z","inspection_violations":[{"id":19376688,"change_date":"2026-03-25 21:40:00","inspection_id":"87397574","insp_violation_id":"272640301","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"212337408","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:02.000000Z","updated_at":"2026-04-05T10:01:48.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":19661663,"change_date":"2026-03-25 21:40:00","inspection_id":"87397574","insp_unit_id":"212337408","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"151","insp_unit_license":"3KR412","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKAD49X6BJ288768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:01.000000Z","updated_at":"2026-04-05T09:19:12.000000Z"},{"id":19661664,"change_date":"2026-03-25 21:40:00","inspection_id":"87397574","insp_unit_id":"212337409","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"262","insp_unit_license":"BW5546","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T04220PT008201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:01.000000Z","updated_at":"2026-04-05T09:19:12.000000Z"}]},{"id":10635520,"change_date":"2026-01-13 21:39:00","inspection_id":"86776646","dot_number":"1563469","report_state":"OK","report_number":"H600154473","insp_date":"2026-01-12 00:00:00","insp_start_time":"1424","insp_end_time":"1530","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ HARDESTY RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CVR SUPPLY & TRADING","shipping_paper_number":"51585","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"8","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"809433","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-01-12 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-01-13 21:39:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-16T10:36:01.000000Z","updated_at":"2026-01-24T10:30:35.000000Z","inspection_violations":[{"id":17889949,"change_date":"2026-01-13 21:39:00","inspection_id":"86776646","insp_violation_id":"271166277","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"211051238","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:02.000000Z","updated_at":"2026-01-24T10:31:06.000000Z","normalized_code":"3939ALIL"},{"id":17889950,"change_date":"2026-01-13 21:39:00","inspection_id":"86776646","insp_violation_id":"271166278","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"211051238","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:02.000000Z","updated_at":"2026-01-24T10:31:06.000000Z","normalized_code":"39360D"},{"id":17889951,"change_date":"2026-01-13 21:39:00","inspection_id":"86776646","insp_violation_id":"271166279","seq_no":"3","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"211051238","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:02.000000Z","updated_at":"2026-01-24T10:31:06.000000Z","normalized_code":"3963A1BALAC"},{"id":17889952,"change_date":"2026-01-13 21:39:00","inspection_id":"86776646","insp_violation_id":"271166280","seq_no":"4","part_no":"393","part_no_section":"55C1-B","insp_viol_unit":"1","insp_unit_id":"211051238","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:02.000000Z","updated_at":"2026-01-24T10:31:06.000000Z","normalized_code":"39355C1B"},{"id":17889953,"change_date":"2026-01-13 21:39:00","inspection_id":"86776646","insp_violation_id":"271166281","seq_no":"5","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"211051237","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:02.000000Z","updated_at":"2026-01-24T10:31:06.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":17889954,"change_date":"2026-01-13 21:39:00","inspection_id":"86776646","insp_violation_id":"271166282","seq_no":"6","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:02.000000Z","updated_at":"2026-01-24T10:31:07.000000Z","normalized_code":"3922SLLEWA1"},{"id":17889955,"change_date":"2026-01-13 21:39:00","inspection_id":"86776646","insp_violation_id":"271166283","seq_no":"7","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:02.000000Z","updated_at":"2026-01-24T10:31:07.000000Z","normalized_code":"3922SLLEWA1"},{"id":17889956,"change_date":"2026-01-13 21:39:00","inspection_id":"86776646","insp_violation_id":"271166284","seq_no":"8","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:02.000000Z","updated_at":"2026-01-24T10:31:07.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":17838155,"change_date":"2026-01-13 21:39:00","inspection_id":"86776646","insp_unit_id":"211051238","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7193","insp_unit_license":"3MB949","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP7DB9X05D878816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:38.000000Z","updated_at":"2026-01-24T10:02:09.000000Z"},{"id":17838154,"change_date":"2026-01-13 21:39:00","inspection_id":"86776646","insp_unit_id":"211051237","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"249","insp_unit_license":"6922JY","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5HTAB4326D7H78978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:38.000000Z","updated_at":"2026-01-24T10:02:09.000000Z"}]},{"id":10449075,"change_date":"2025-12-16 21:38:00","inspection_id":"86581514","dot_number":"1563469","report_state":"OK","report_number":"P113155960","insp_date":"2025-12-16 00:00:00","insp_start_time":"0943","insp_end_time":"1011","registration_date":null,"region":"CT","ci_status_code":"C","location":"73CRT","location_desc":"CREEK TP @ NEW ORLEANS","county_code_state":"OK","county_code":"145","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE","shipping_paper_number":"3156074","cargo_tank":"406","hazmat_placard_req":"Y","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-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"806951","transaction_code":"A","transaction_date":"2025-12-16 00:00:00","upload_date":"2025-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-16 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-12-16 21:38:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-19T10:31:53.000000Z","updated_at":"2025-12-27T10:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17485165,"change_date":"2025-12-16 21:38:00","inspection_id":"86581514","insp_unit_id":"210639123","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"151","insp_unit_license":"3KR412","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKAD49X6BJ288768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-19T10:02:00.000000Z","updated_at":"2025-12-27T10:00:59.000000Z"},{"id":17485166,"change_date":"2025-12-16 21:38:00","inspection_id":"86581514","insp_unit_id":"210639124","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"262","insp_unit_license":"BW5546","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T04220PT008201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-19T10:02:00.000000Z","updated_at":"2025-12-27T10:00:59.000000Z"}]},{"id":10437813,"change_date":"2025-12-15 21:39:00","inspection_id":"86569760","dot_number":"1563469","report_state":"OK","report_number":"R600000128","insp_date":"2025-12-13 00:00:00","insp_start_time":"1042","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":"14044","location_desc":"I-44\/ SW 119TH ST","county_code_state":"OK","county_code":"027","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"806671","transaction_code":"A","transaction_date":"2025-12-15 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-12-13 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-12-15 21:39:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-18T10:30:42.000000Z","updated_at":"2025-12-26T10:30:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17461570,"change_date":"2025-12-15 21:39:00","inspection_id":"86569760","insp_unit_id":"210612819","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"151","insp_unit_license":"3KR412","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKAD49X6BJ288768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:35.000000Z","updated_at":"2025-12-26T10:00:59.000000Z"},{"id":17461571,"change_date":"2025-12-15 21:39:00","inspection_id":"86569760","insp_unit_id":"210612820","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"262","insp_unit_license":"BW5546","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T04220PT008201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:35.000000Z","updated_at":"2025-12-26T10:00:59.000000Z"}]},{"id":9926564,"change_date":"2025-10-13 21:37:00","inspection_id":"86032320","dot_number":"1563469","report_state":"OK","report_number":"I104153432","insp_date":"2025-10-11 00:00:00","insp_start_time":"0654","insp_end_time":"0721","registration_date":null,"region":"CT","ci_status_code":"C","location":"550CS","location_desc":"NE 10TH AND SUNNYLANE","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN","shipping_paper_number":"3131451","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"800377","transaction_code":"A","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-10-11 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-10-13 21:37:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-16T10:00:40.000000Z","updated_at":"2025-10-17T10:00:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16475241,"change_date":"2025-10-13 21:37:00","inspection_id":"86032320","insp_unit_id":"209439008","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"15","insp_unit_license":"731476","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPHD49X4CD151790","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:56.000000Z","updated_at":"2025-10-17T09:45:57.000000Z"},{"id":16475242,"change_date":"2025-10-13 21:37:00","inspection_id":"86032320","insp_unit_id":"209439009","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"218","insp_unit_license":"4497GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T042285T003101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:56.000000Z","updated_at":"2025-10-17T09:45:57.000000Z"}]},{"id":9926509,"change_date":"2025-10-13 21:37:00","inspection_id":"86032264","dot_number":"1563469","report_state":"OK","report_number":"H600154270","insp_date":"2025-10-10 00:00:00","insp_start_time":"0651","insp_end_time":"0720","registration_date":null,"region":"CT","ci_status_code":"C","location":"63040","location_desc":"I-40 W\/B \/ MCLOUD RD SH-102","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE","shipping_paper_number":"3131064","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"800530","transaction_code":"A","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-10-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-10-13 21:37:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-16T10:00:40.000000Z","updated_at":"2025-10-17T10:00:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16475142,"change_date":"2025-10-13 21:37:00","inspection_id":"86032264","insp_unit_id":"209438903","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"160","insp_unit_license":"734570","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGLDR0HSJG4300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:56.000000Z","updated_at":"2025-10-17T09:45:56.000000Z"},{"id":16475143,"change_date":"2025-10-13 21:37:00","inspection_id":"86032264","insp_unit_id":"209438904","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"249","insp_unit_license":"6922JY","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5HTAB4326D7H78978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:56.000000Z","updated_at":"2025-10-17T09:45:56.000000Z"}]},{"id":9926513,"change_date":"2025-12-01 21:39:00","inspection_id":"86032268","dot_number":"1563469","report_state":"OK","report_number":"H600154271","insp_date":"2025-10-10 00:00:00","insp_start_time":"0724","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":"63040","location_desc":"I-40 W\/B \/ SH-102","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLINE PIPELINE","shipping_paper_number":"3131273","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"800366","transaction_code":"C","transaction_date":"2025-12-01 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-10-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-10-13 21:37:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-16T10:00:40.000000Z","updated_at":"2025-12-05T10:30:49.000000Z","inspection_violations":[{"id":16380499,"change_date":"2025-10-13 21:37:00","inspection_id":"86032268","insp_violation_id":"269263710","seq_no":"2","part_no":"177","part_no_section":"823A-HMRAMTVM","insp_viol_unit":"2","insp_unit_id":"209438912","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-16T10:15:57.000000Z","updated_at":"2025-10-17T10:16:09.000000Z","normalized_code":"177823AHMRAMTVM"},{"id":17254452,"change_date":"2025-12-01 21:39:00","inspection_id":"86032268","insp_violation_id":"270364496","seq_no":"1","part_no":"177","part_no_section":"823A-HMRAMTVM","insp_viol_unit":"2","insp_unit_id":"210327347","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-04T10:30:49.000000Z","updated_at":"2025-12-05T10:31:04.000000Z","normalized_code":"177823AHMRAMTVM"}],"inspection_per_units":[{"id":17226943,"change_date":"2025-12-01 21:39:00","inspection_id":"86032268","insp_unit_id":"210327346","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"73","insp_unit_license":"3KD285","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3ALXFBCG5GDGX3862","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:33.000000Z","updated_at":"2025-12-05T10:00:58.000000Z"},{"id":17226944,"change_date":"2025-12-01 21:39:00","inspection_id":"86032268","insp_unit_id":"210327347","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACL","insp_unit_company":"255","insp_unit_license":"AB8287","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"558MEBR29JK004053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:33.000000Z","updated_at":"2025-12-05T10:00:58.000000Z"}]},{"id":9729959,"change_date":"2025-09-19 21:39:00","inspection_id":"85826057","dot_number":"1563469","report_state":"OK","report_number":"H514154243","insp_date":"2025-09-19 00:00:00","insp_start_time":"1210","insp_end_time":"1240","registration_date":null,"region":"CT","ci_status_code":"C","location":"055040","location_desc":"I-40 EB CHOCTAW","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE CO","shipping_paper_number":"3123363","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-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"798265","transaction_code":"A","transaction_date":"2025-09-19 00:00:00","upload_date":"2025-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-19 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-09-19 21:39:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:45.000000Z","updated_at":"2025-09-23T10:02:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16112852,"change_date":"2025-09-19 21:39:00","inspection_id":"85826057","insp_unit_id":"209048675","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"15","insp_unit_license":"731476","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPHD49X4CD151790","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:05.000000Z","updated_at":"2025-09-23T09:46:05.000000Z"},{"id":16112853,"change_date":"2025-09-19 21:39:00","inspection_id":"85826057","insp_unit_id":"209048676","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"218","insp_unit_license":"4497GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T042285T003101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:05.000000Z","updated_at":"2025-09-23T09:46:05.000000Z"}]},{"id":9706781,"change_date":"2025-09-17 21:40:00","inspection_id":"85801786","dot_number":"1563469","report_state":"OK","report_number":"X900201615","insp_date":"2025-09-17 00:00:00","insp_start_time":"0745","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":"09040","location_desc":"I40 W\/B BANNER ROAD","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"P66 PARTNERS HOLDINGS LLC","shipping_paper_number":"725968","cargo_tank":"406","hazmat_placard_req":"Y","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-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"797883","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-09-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-09-17 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:47.000000Z","updated_at":"2025-09-23T10:01:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16069812,"change_date":"2025-09-17 21:40:00","inspection_id":"85801786","insp_unit_id":"209001973","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"151","insp_unit_license":"3KR412","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKAD49X6BJ288768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:49.000000Z","updated_at":"2025-09-21T09:45:31.000000Z"},{"id":16069813,"change_date":"2025-09-17 21:40:00","inspection_id":"85801786","insp_unit_id":"209001974","insp_unit_type_id":"8","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"262","insp_unit_license":"BW5546","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T04220PT008201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:49.000000Z","updated_at":"2025-09-21T09:45:31.000000Z"}]},{"id":9685540,"change_date":"2025-09-15 21:40:00","inspection_id":"85779472","dot_number":"1563469","report_state":"KS","report_number":"HP03233677","insp_date":"2025-09-11 00:00:00","insp_start_time":"0845","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":"MG","location_desc":"MONTGOMERY COUNTY - 125","county_code_state":"KS","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WORLD FUEL SERVICES","shipping_paper_number":"30984","cargo_tank":"406","hazmat_placard_req":"Y","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-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"1374640","transaction_code":"A","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-11 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-09-15 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:00:38.000000Z","updated_at":"2025-09-18T10:00:38.000000Z","inspection_violations":[{"id":15881462,"change_date":"2025-09-15 21:40:00","inspection_id":"85779472","insp_violation_id":"268700369","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"208959878","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:20:54.000000Z","updated_at":"2025-09-18T10:20:54.000000Z","normalized_code":"39360D"},{"id":15881463,"change_date":"2025-09-15 21:40:00","inspection_id":"85779472","insp_violation_id":"268700370","seq_no":"2","part_no":"393","part_no_section":"11B-CSLRR","insp_viol_unit":"2","insp_unit_id":"208959879","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:20:54.000000Z","updated_at":"2025-09-18T10:20:54.000000Z","normalized_code":"39311BCSLRR"}],"inspection_per_units":[{"id":16030432,"change_date":"2025-09-15 21:40:00","inspection_id":"85779472","insp_unit_id":"208959878","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7193","insp_unit_license":"3MB949Q","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP7DB9X05D878816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:32.000000Z","updated_at":"2025-09-18T09:45:32.000000Z"},{"id":16030433,"change_date":"2025-09-15 21:40:00","inspection_id":"85779472","insp_unit_id":"208959879","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"238","insp_unit_license":"6467LP","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T432X8B010032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:32.000000Z","updated_at":"2025-09-18T09:45:32.000000Z"}]},{"id":9632765,"change_date":"2025-09-09 21:40:00","inspection_id":"85723906","dot_number":"1563469","report_state":"OK","report_number":"PB10154322","insp_date":"2025-09-08 00:00:00","insp_start_time":"0915","insp_end_time":"1010","registration_date":null,"region":"CT","ci_status_code":"C","location":"09040","location_desc":"EL RENO SCALES","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MAGELLAN PIPELINE","shipping_paper_number":"3118650","cargo_tank":"406","hazmat_placard_req":"Y","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-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"796883","transaction_code":"A","transaction_date":"2025-09-09 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-09-08 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-09-09 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-11T10:47:08.000000Z","updated_at":"2025-09-13T10:46:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15913014,"change_date":"2025-09-09 21:40:00","inspection_id":"85723906","insp_unit_id":"208829189","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTE","insp_unit_company":"588","insp_unit_license":"3JQ463","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3HSDJAPR7HN429588","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:47.000000Z","updated_at":"2025-09-13T09:59:43.000000Z"},{"id":15913015,"change_date":"2025-09-09 21:40:00","inspection_id":"85723906","insp_unit_id":"208829190","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACC","insp_unit_company":"257","insp_unit_license":"BG2590","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"558MEBR23KK004650","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:47.000000Z","updated_at":"2025-09-13T09:59:43.000000Z"}]},{"id":9438696,"change_date":"2025-08-18 21:39:00","inspection_id":"85520313","dot_number":"1563469","report_state":"OK","report_number":"H600154178","insp_date":"2025-08-15 00:00:00","insp_start_time":"1332","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ FARRELL ST","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CVR SUPPLY & TRADING","shipping_paper_number":"26260","cargo_tank":"406","hazmat_placard_req":"Y","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":"2025-08-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"794808","transaction_code":"A","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-08-15 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:45:56.000000Z","updated_at":"2025-08-23T10:45:56.000000Z","inspection_violations":[{"id":15364208,"change_date":"2025-08-18 21:39:00","inspection_id":"85520313","insp_violation_id":"268088827","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:29.000000Z","updated_at":"2025-08-22T10:43:48.000000Z","normalized_code":"3922SLLEWA2"},{"id":15364209,"change_date":"2025-08-18 21:39:00","inspection_id":"85520313","insp_violation_id":"268088828","seq_no":"2","part_no":"393","part_no_section":"209E-SPSLA","insp_viol_unit":"1","insp_unit_id":"208448553","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:29.000000Z","updated_at":"2025-08-22T10:43:48.000000Z","normalized_code":"393209ESPSLA"},{"id":15364210,"change_date":"2025-08-18 21:39:00","inspection_id":"85520313","insp_violation_id":"268088829","seq_no":"3","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"208448553","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:29.000000Z","updated_at":"2025-08-22T10:43:48.000000Z","normalized_code":"3939ALTSIR"},{"id":15364211,"change_date":"2025-08-18 21:39:00","inspection_id":"85520313","insp_violation_id":"268088830","seq_no":"4","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"208448554","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:29.000000Z","updated_at":"2025-08-22T10:43:48.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":15561983,"change_date":"2025-08-18 21:39:00","inspection_id":"85520313","insp_unit_id":"208448553","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"007","insp_unit_license":"3LY203","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKWDB9X85J087288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:41.000000Z","updated_at":"2025-08-22T09:45:55.000000Z"},{"id":15561984,"change_date":"2025-08-18 21:39:00","inspection_id":"85520313","insp_unit_id":"208448554","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"207","insp_unit_license":"1084GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T4324YB005960","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:41.000000Z","updated_at":"2025-08-22T09:45:55.000000Z"}]},{"id":9402313,"change_date":"2025-08-13 21:39:00","inspection_id":"85481844","dot_number":"1563469","report_state":"OK","report_number":"PB10154297","insp_date":"2025-08-13 00:00:00","insp_start_time":"1300","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":"09040","location_desc":"EL RENO SCALES","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"PHILLIPS 66","shipping_paper_number":"718821","cargo_tank":"406","hazmat_placard_req":"Y","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":"2025-08-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"6","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"794392","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-08-13 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-08-13 21:39:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-16T10:01:24.000000Z","updated_at":"2025-08-17T10:00:42.000000Z","inspection_violations":[{"id":15290397,"change_date":"2025-08-13 21:39:00","inspection_id":"85481844","insp_violation_id":"268005780","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"P113524","created_at":"2025-08-16T10:45:08.000000Z","updated_at":"2025-08-17T10:44:25.000000Z","normalized_code":"3922SLLEWA2"},{"id":15290398,"change_date":"2025-08-13 21:39:00","inspection_id":"85481844","insp_violation_id":"268005781","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"208378280","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-16T10:45:08.000000Z","updated_at":"2025-08-17T10:44:25.000000Z","normalized_code":"39360C"},{"id":15290399,"change_date":"2025-08-13 21:39:00","inspection_id":"85481844","insp_violation_id":"268005782","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208378280","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-16T10:45:08.000000Z","updated_at":"2025-08-17T10:44:25.000000Z","normalized_code":"39378"},{"id":15290400,"change_date":"2025-08-13 21:39:00","inspection_id":"85481844","insp_violation_id":"268005783","seq_no":"4","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"208378280","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-16T10:45:08.000000Z","updated_at":"2025-08-17T10:44:25.000000Z","normalized_code":"3963A1F"},{"id":15290401,"change_date":"2025-08-13 21:39:00","inspection_id":"85481844","insp_violation_id":"268005784","seq_no":"5","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"208378280","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-16T10:45:08.000000Z","updated_at":"2025-08-17T10:44:25.000000Z","normalized_code":"3963A1F"},{"id":15290402,"change_date":"2025-08-13 21:39:00","inspection_id":"85481844","insp_violation_id":"268005785","seq_no":"6","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"208378280","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-16T10:45:08.000000Z","updated_at":"2025-08-17T10:44:25.000000Z","normalized_code":"3963A1F"}],"inspection_per_units":[{"id":15496143,"change_date":"2025-08-13 21:39:00","inspection_id":"85481844","insp_unit_id":"208378280","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"405","insp_unit_license":"733098","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJHHDR4JSHM7816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-16T09:46:38.000000Z","updated_at":"2025-08-17T09:45:50.000000Z"},{"id":15496144,"change_date":"2025-08-13 21:39:00","inspection_id":"85481844","insp_unit_id":"208378281","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"217","insp_unit_license":"4496GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T432X4B007433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-16T09:46:38.000000Z","updated_at":"2025-08-17T09:45:50.000000Z"}]},{"id":8862431,"change_date":"2025-06-10 21:40:00","inspection_id":"84912907","dot_number":"1563469","report_state":"OK","report_number":"H600154036","insp_date":"2025-06-10 00:00:00","insp_start_time":"0647","insp_end_time":"0712","registration_date":null,"region":"CT","ci_status_code":"C","location":"63040","location_desc":"I-40 W\/B \/ SH-102","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLINE PIPELINE","shipping_paper_number":"3083463","cargo_tank":"406","hazmat_placard_req":"Y","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-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"787769","transaction_code":"A","transaction_date":"2025-06-10 00:00:00","upload_date":"2025-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-06-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-06-10 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:45.000000Z","updated_at":"2025-06-14T10:00:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14513035,"change_date":"2025-06-10 21:40:00","inspection_id":"84912907","insp_unit_id":"207312988","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"160","insp_unit_license":"734570","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGLDR0HSJG4300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:44.000000Z","updated_at":"2025-06-14T09:45:39.000000Z"},{"id":14513036,"change_date":"2025-06-10 21:40:00","inspection_id":"84912907","insp_unit_id":"207312989","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"219","insp_unit_license":"4498GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5HTAB442257H68576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:44.000000Z","updated_at":"2025-06-14T09:45:39.000000Z"}]},{"id":8255944,"change_date":"2025-03-31 21:40:00","inspection_id":"84273227","dot_number":"1563469","report_state":"OK","report_number":"X200172474","insp_date":"2025-03-31 00:00:00","insp_start_time":"0920","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"37081","location_desc":"US81\/1 N DOVER","county_code_state":"OK","county_code":"073","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"3055-60","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"780168","transaction_code":"A","transaction_date":"2025-03-31 00:00:00","upload_date":"2025-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-31 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-03-31 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-03T10:04:29.000000Z","updated_at":"2025-04-04T10:19:00.000000Z","inspection_violations":[{"id":12966255,"change_date":"2025-03-31 21:40:00","inspection_id":"84273227","insp_violation_id":"265353890","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"206080752","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:26:30.000000Z","updated_at":"2025-04-04T10:38:26.000000Z","normalized_code":"3965BL"},{"id":12966256,"change_date":"2025-03-31 21:40:00","inspection_id":"84273227","insp_violation_id":"265353891","seq_no":"2","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"206080752","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:26:30.000000Z","updated_at":"2025-04-04T10:38:26.000000Z","normalized_code":"3939ALFTSI"},{"id":12966257,"change_date":"2025-03-31 21:40:00","inspection_id":"84273227","insp_violation_id":"265353892","seq_no":"3","part_no":"172","part_no_section":"600C1-HMER","insp_viol_unit":"1","insp_unit_id":"206080752","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:26:30.000000Z","updated_at":"2025-04-04T10:38:26.000000Z","normalized_code":"172600C1HMER"}],"inspection_per_units":[{"id":13360154,"change_date":"2025-03-31 21:40:00","inspection_id":"84273227","insp_unit_id":"206080752","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"17708","insp_unit_license":"708876","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJGHDVXDSBX3051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-03T09:57:29.000000Z","updated_at":"2025-04-04T09:59:42.000000Z"},{"id":13360155,"change_date":"2025-03-31 21:40:00","inspection_id":"84273227","insp_unit_id":"206080753","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"249","insp_unit_license":"6922JY","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5HTAB4326D7H78978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-03T09:57:29.000000Z","updated_at":"2025-04-04T09:59:42.000000Z"}]},{"id":8212497,"change_date":"2025-03-26 21:40:00","inspection_id":"84228012","dot_number":"1563469","report_state":"OK","report_number":"C713154897","insp_date":"2025-03-26 00:00:00","insp_start_time":"1013","insp_end_time":"1043","registration_date":null,"region":"CT","ci_status_code":"C","location":"042035","location_desc":"3 MILES N OF EDMOND","county_code_state":"OK","county_code":"083","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"PHILLIPS 66","shipping_paper_number":"3053904","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"779872","transaction_code":"A","transaction_date":"2025-03-26 00:00:00","upload_date":"2025-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-26 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-03-26 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-29T10:21:15.000000Z","updated_at":"2025-03-30T10:35:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13279914,"change_date":"2025-03-26 21:40:00","inspection_id":"84228012","insp_unit_id":"205994287","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"160","insp_unit_license":"716684","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGLDR0HSJG4300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:08:32.000000Z","updated_at":"2025-03-30T10:04:33.000000Z"},{"id":13279915,"change_date":"2025-03-26 21:40:00","inspection_id":"84228012","insp_unit_id":"205994288","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"219","insp_unit_license":"4498GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5HTAB442257H68576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:08:32.000000Z","updated_at":"2025-03-30T10:04:33.000000Z"}]},{"id":8022745,"change_date":"2025-03-04 21:39:00","inspection_id":"84027589","dot_number":"1563469","report_state":"OK","report_number":"H600153789","insp_date":"2025-03-01 00:00:00","insp_start_time":"0756","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":"55040","location_desc":"I-40 \/ HARRAH RD","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE","shipping_paper_number":"3043910","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"777284","transaction_code":"A","transaction_date":"2025-03-01 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-01 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-03-04 21:39:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:54.000000Z","updated_at":"2025-03-17T21:04:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12952079,"change_date":"2025-03-04 21:39:00","inspection_id":"84027589","insp_unit_id":"205618478","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"701","insp_unit_license":"716265","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3ALXFBCG4FDGJ0850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:05.000000Z","updated_at":"2025-03-17T23:58:05.000000Z"},{"id":12952080,"change_date":"2025-03-04 21:39:00","inspection_id":"84027589","insp_unit_id":"205618479","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"216","insp_unit_license":"4495GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T042214T002001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:05.000000Z","updated_at":"2025-03-17T23:58:05.000000Z"}]},{"id":7994342,"change_date":"2025-03-04 21:39:00","inspection_id":"83997755","dot_number":"1563469","report_state":"OK","report_number":"X311155635","insp_date":"2025-02-28 00:00:00","insp_start_time":"1130","insp_end_time":"1155","registration_date":null,"region":"CT","ci_status_code":"C","location":"040055","location_desc":"I-40 AND MCARTHUR","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"397267","cargo_tank":"406","hazmat_placard_req":"Y","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-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"777190","transaction_code":"C","transaction_date":"2025-03-04 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-02-28 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-02-28 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:06.000000Z","updated_at":"2025-03-17T21:04:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12905833,"change_date":"2025-03-04 21:39:00","inspection_id":"83997755","insp_unit_id":"205618131","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2208","insp_unit_license":"705121","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGEBG0ESFT9215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:34.000000Z","updated_at":"2025-03-17T23:57:34.000000Z"},{"id":12905834,"change_date":"2025-03-04 21:39:00","inspection_id":"83997755","insp_unit_id":"205618132","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"244","insp_unit_license":"1081GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T4324AB000294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:34.000000Z","updated_at":"2025-03-17T23:57:34.000000Z"}]},{"id":7002325,"change_date":"2024-10-21 21:41:00","inspection_id":"82953352","dot_number":"1563469","report_state":"OK","report_number":"N914154230","insp_date":"2024-10-21 00:00:00","insp_start_time":"1000","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":"009344","location_desc":"KILPATRICK WB MORGAN","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"2994667","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-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"765178","transaction_code":"A","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-10-21 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:13.000000Z","updated_at":"2025-03-17T20:42:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11294430,"change_date":"2024-10-21 21:41:00","inspection_id":"82953352","insp_unit_id":"203500498","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"250","insp_unit_license":"70C773","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPSLP9X1ED225285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:55.000000Z","updated_at":"2025-03-17T23:39:55.000000Z"}]},{"id":6795382,"change_date":"2024-09-23 21:41:00","inspection_id":"82733536","dot_number":"1563469","report_state":"OK","report_number":"N914154173","insp_date":"2024-09-23 00:00:00","insp_start_time":"1220","insp_end_time":"1250","registration_date":null,"region":"CT","ci_status_code":"C","location":"09040","location_desc":"EL RENO SCALES","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MC","shipping_paper_number":"NONE","cargo_tank":"406","hazmat_placard_req":"Y","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-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"762133","transaction_code":"A","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-09-23 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:46.000000Z","updated_at":"2025-03-17T20:37:46.000000Z","inspection_violations":[{"id":10582641,"change_date":"2024-09-23 21:41:00","inspection_id":"82733536","insp_violation_id":"261981245","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203081479","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:16.000000Z","updated_at":"2025-03-17T21:57:16.000000Z","normalized_code":"3922"},{"id":10582642,"change_date":"2024-09-23 21:41:00","inspection_id":"82733536","insp_violation_id":"261981246","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203081479","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:16.000000Z","updated_at":"2025-03-17T21:57:16.000000Z","normalized_code":"3939A"},{"id":10582643,"change_date":"2024-09-23 21:41:00","inspection_id":"82733536","insp_violation_id":"261981247","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203081479","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:16.000000Z","updated_at":"2025-03-17T21:57:16.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10958086,"change_date":"2024-09-23 21:41:00","inspection_id":"82733536","insp_unit_id":"203081479","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"250","insp_unit_license":"V07105","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3E1AAB23XKSV23285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:31.000000Z","updated_at":"2025-03-17T23:36:31.000000Z"}]},{"id":6700414,"change_date":"2024-09-11 21:41:00","inspection_id":"82632067","dot_number":"1563469","report_state":"OK","report_number":"H600153496","insp_date":"2024-09-11 00:00:00","insp_start_time":"0759","insp_end_time":"0836","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ 45TH ST","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLINE PIPELINE","shipping_paper_number":"2979257","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"760944","transaction_code":"A","transaction_date":"2024-09-11 00:00:00","upload_date":"2024-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-11 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-09-11 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:03.000000Z","updated_at":"2025-03-17T20:36:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10803906,"change_date":"2024-09-11 21:41:00","inspection_id":"82632067","insp_unit_id":"202870588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"206","insp_unit_license":"696324","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HTHCAHR4XH689588","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:50.000000Z","updated_at":"2025-03-17T23:34:50.000000Z"}]},{"id":6444644,"change_date":"2024-08-12 21:43:00","inspection_id":"82359709","dot_number":"1563469","report_state":"OK","report_number":"X900200871","insp_date":"2024-08-12 00:00:00","insp_start_time":"1315","insp_end_time":"1340","registration_date":null,"region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT W\/B MORGAN ROAD","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE","shipping_paper_number":"2968679","cargo_tank":"406","hazmat_placard_req":"Y","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":"54000","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":"757675","transaction_code":"A","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-12 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-08-12 21:43:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","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":10007529,"change_date":"2024-08-12 21:43:00","inspection_id":"82359709","insp_violation_id":"261139520","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202345462","insp_violation_category_id":"28","out_of_service_indicator":"N","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":"39395A"}],"inspection_per_units":[{"id":10387249,"change_date":"2024-08-12 21:43:00","inspection_id":"82359709","insp_unit_id":"202345462","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"206","insp_unit_license":"696324","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HTHCAHR4XH689588","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":6431033,"change_date":"2024-08-09 21:38:00","inspection_id":"82345048","dot_number":"1563469","report_state":"OK","report_number":"D210153708","insp_date":"2024-08-09 00:00:00","insp_start_time":"1010","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":"025019","location_desc":"PAULS VALLEY","county_code_state":"OK","county_code":"049","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"646389","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-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"757453","transaction_code":"A","transaction_date":"2024-08-09 00:00:00","upload_date":"2024-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-08-09 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-08-09 21:38:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:18.000000Z","updated_at":"2025-03-17T20:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10364614,"change_date":"2024-08-09 21:38:00","inspection_id":"82345048","insp_unit_id":"202317958","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"722850","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJF6AV2DU80079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:24.000000Z","updated_at":"2025-03-17T23:30:24.000000Z"},{"id":10364615,"change_date":"2024-08-09 21:38:00","inspection_id":"82345048","insp_unit_id":"202317959","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":null,"insp_unit_license":"4497GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T042285T003101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:24.000000Z","updated_at":"2025-03-17T23:30:24.000000Z"}]},{"id":6176184,"change_date":"2024-07-09 21:43:00","inspection_id":"82072167","dot_number":"1563469","report_state":"OK","report_number":"N914154026","insp_date":"2024-07-09 00:00:00","insp_start_time":"1300","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":"09040","location_desc":"EL RENO SCALES","county_code_state":"OK","county_code":"017","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MC","shipping_paper_number":"2956210","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-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"753544","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-09 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-07-09 21:43:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:03.000000Z","updated_at":"2025-03-17T20:25:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9949508,"change_date":"2024-07-09 21:43:00","inspection_id":"82072167","insp_unit_id":"201795903","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"710","insp_unit_license":"700815","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KJJABCK76PV50955","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:05.000000Z","updated_at":"2025-03-17T23:26:05.000000Z"},{"id":9949509,"change_date":"2024-07-09 21:43:00","inspection_id":"82072167","insp_unit_id":"201795904","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"233","insp_unit_license":"4499GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T43226B008160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:05.000000Z","updated_at":"2025-03-17T23:26:05.000000Z"}]},{"id":6028287,"change_date":"2024-06-19 21:37:00","inspection_id":"81912973","dot_number":"1563469","report_state":"OK","report_number":"H910000248","insp_date":"2024-06-19 00:00:00","insp_start_time":"0744","insp_end_time":"0816","registration_date":null,"region":"CT","ci_status_code":"C","location":"26009","location_desc":"SH9 AT SH81","county_code_state":"OK","county_code":"051","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"TRANSMONTAIGNE PARTNERS LLC","shipping_paper_number":"130533","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"751566","transaction_code":"A","transaction_date":"2024-06-19 00:00:00","upload_date":"2024-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-19 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-06-19 21:37:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:15.000000Z","updated_at":"2025-03-17T20:22:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9709605,"change_date":"2024-06-19 21:37:00","inspection_id":"81912973","insp_unit_id":"201488169","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"405","insp_unit_license":"725187","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJHHDR4JSHM7816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:36.000000Z","updated_at":"2025-03-17T23:23:36.000000Z"},{"id":9709606,"change_date":"2024-06-19 21:37:00","inspection_id":"81912973","insp_unit_id":"201488170","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":null,"insp_unit_license":"4496GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T432X4B007433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:36.000000Z","updated_at":"2025-03-17T23:23:36.000000Z"}]},{"id":5380344,"change_date":"2024-03-27 21:42:00","inspection_id":"81208080","dot_number":"1563469","report_state":"OK","report_number":"C713154643","insp_date":"2024-03-25 00:00:00","insp_start_time":"0820","insp_end_time":"0850","registration_date":null,"region":"CT","ci_status_code":"C","location":"042035","location_desc":"GUTHRIE","county_code_state":"OK","county_code":"083","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"P66","shipping_paper_number":"618583","cargo_tank":"406","hazmat_placard_req":"Y","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-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"741877","transaction_code":"A","transaction_date":"2024-03-27 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-25 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-03-27 21:42:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:24.000000Z","updated_at":"2025-03-17T20:09:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8664969,"change_date":"2024-03-27 21:42:00","inspection_id":"81208080","insp_unit_id":"200112441","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2208","insp_unit_license":"705121","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGEBG0ESFT9215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:34.000000Z","updated_at":"2025-03-17T23:13:34.000000Z"},{"id":8664970,"change_date":"2024-03-27 21:42:00","inspection_id":"81208080","insp_unit_id":"200112442","insp_unit_type_id":"11","insp_unit_number":"2","insp_unit_make":"BEALL","insp_unit_company":"244","insp_unit_license":"1081GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T4324AB000294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:34.000000Z","updated_at":"2025-03-17T23:13:34.000000Z"}]},{"id":5296452,"change_date":"2024-03-15 21:40:00","inspection_id":"81116771","dot_number":"1563469","report_state":"OK","report_number":"H600153110","insp_date":"2024-03-15 00:00:00","insp_start_time":"0749","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":"63040","location_desc":"I-40 W\/B \/ MCLOUD RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLINE PIPELINE","shipping_paper_number":"2911815","cargo_tank":"406","hazmat_placard_req":"Y","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-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"740618","transaction_code":"A","transaction_date":"2024-03-15 00:00:00","upload_date":"2024-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-15 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-03-15 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:31.000000Z","updated_at":"2025-03-17T20:07:31.000000Z","inspection_violations":[{"id":8167914,"change_date":"2024-03-15 21:40:00","inspection_id":"81116771","insp_violation_id":"258409006","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199936193","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8529356,"change_date":"2024-03-15 21:40:00","inspection_id":"81116771","insp_unit_id":"199936193","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"701","insp_unit_license":"716265","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3ALXFBCG4FDGJ0850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:17.000000Z","updated_at":"2025-03-17T23:12:17.000000Z"},{"id":8529357,"change_date":"2024-03-15 21:40:00","inspection_id":"81116771","insp_unit_id":"199936194","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"216","insp_unit_license":"4495GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T042214T002001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:17.000000Z","updated_at":"2025-03-17T23:12:17.000000Z"}]},{"id":5189155,"change_date":"2024-03-01 21:39:00","inspection_id":"80999507","dot_number":"1563469","report_state":"OK","report_number":"AG50151777","insp_date":"2024-02-29 00:00:00","insp_start_time":"0809","insp_end_time":"0836","registration_date":null,"region":"CT","ci_status_code":"C","location":"55OCS","location_desc":"SUNNYLANE AND RENO","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"N\/A","cargo_tank":"406","hazmat_placard_req":"Y","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-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"739056","transaction_code":"A","transaction_date":"2024-03-01 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-29 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-03-01 21:39:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:21.000000Z","updated_at":"2025-03-17T20:05:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8355286,"change_date":"2024-03-01 21:39:00","inspection_id":"80999507","insp_unit_id":"199709646","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"17708","insp_unit_license":"708876","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJGHDVXDSBX3051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:42.000000Z","updated_at":"2025-03-17T23:10:42.000000Z"},{"id":8355287,"change_date":"2024-03-01 21:39:00","inspection_id":"80999507","insp_unit_id":"199709647","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":null,"insp_unit_license":"1088GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2M4323WB005460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:42.000000Z","updated_at":"2025-03-17T23:10:42.000000Z"}]},{"id":5135844,"change_date":"2024-02-26 21:42:00","inspection_id":"80941797","dot_number":"1563469","report_state":"OK","report_number":"T400161942","insp_date":"2024-02-24 00:00:00","insp_start_time":"1534","insp_end_time":"1624","registration_date":null,"region":"CT","ci_status_code":"C","location":"67377","location_desc":"US 377 @ SH 99A","county_code_state":"OK","county_code":"133","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CVR SUPPLY & TRADING, INC","shipping_paper_number":"798664","cargo_tank":"406","hazmat_placard_req":"Y","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-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"738607","transaction_code":"A","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-24 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-02-26 21:42:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:14.000000Z","updated_at":"2025-03-17T20:04:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8268795,"change_date":"2024-02-26 21:42:00","inspection_id":"80941797","insp_unit_id":"199600174","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"151","insp_unit_license":"710467","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKAD49X6BJ288768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:55.000000Z","updated_at":"2025-03-17T23:09:55.000000Z"},{"id":8268796,"change_date":"2024-02-26 21:42:00","inspection_id":"80941797","insp_unit_id":"199600175","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"262","insp_unit_license":"BW5546","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T04220PT008201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:55.000000Z","updated_at":"2025-03-17T23:09:55.000000Z"}]},{"id":5112878,"change_date":"2024-02-22 21:42:00","inspection_id":"80916616","dot_number":"1563469","report_state":"OK","report_number":"I104153093","insp_date":"2024-02-21 00:00:00","insp_start_time":"0617","insp_end_time":"0642","registration_date":null,"region":"CT","ci_status_code":"C","location":"550CS","location_desc":"NE 10TH AND SUNNYLANE","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"PHILLIPS 66","shipping_paper_number":"611923","cargo_tank":"406","hazmat_placard_req":"Y","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-02-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"738218","transaction_code":"A","transaction_date":"2024-02-21 00:00:00","upload_date":"2024-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-02-22 21:42:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:50.000000Z","updated_at":"2025-03-17T20:03:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8231420,"change_date":"2024-02-22 21:42:00","inspection_id":"80916616","insp_unit_id":"199550162","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":null,"insp_unit_license":"3KF745","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKADP9X7CJ311736","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:36.000000Z","updated_at":"2025-03-17T23:09:36.000000Z"},{"id":8231421,"change_date":"2024-02-22 21:42:00","inspection_id":"80916616","insp_unit_id":"199550163","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"256","insp_unit_license":"BG2589","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"558MEBR26KK004643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:36.000000Z","updated_at":"2025-03-17T23:09:36.000000Z"}]},{"id":5087891,"change_date":"2024-02-20 21:42:00","inspection_id":"80889414","dot_number":"1563469","report_state":"OK","report_number":"X900200482","insp_date":"2024-02-19 00:00:00","insp_start_time":"0715","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT SB AND SH3 \/ NW EXPRESSWAY","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE COMPANY","shipping_paper_number":"2901894","cargo_tank":"406","hazmat_placard_req":"Y","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-02-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"737886","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-19 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-02-20 21:42:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:27.000000Z","updated_at":"2025-03-17T20:03:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8190921,"change_date":"2024-02-20 21:42:00","inspection_id":"80889414","insp_unit_id":"199498943","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"250","insp_unit_license":"V07104","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPSLP9X1ED225285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"}]},{"id":4902377,"change_date":"2024-01-25 21:44:00","inspection_id":"80686441","dot_number":"1563469","report_state":"OK","report_number":"R107150791","insp_date":"2024-01-25 00:00:00","insp_start_time":"0846","insp_end_time":"0910","registration_date":null,"region":"CT","ci_status_code":"C","location":"55040","location_desc":"I-40 E\/B PEEBLY RD","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"2893089","cargo_tank":"406","hazmat_placard_req":"Y","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-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"735457","transaction_code":"A","transaction_date":"2024-01-25 00:00:00","upload_date":"2024-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-01-25 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-01-25 21:44:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:00.000000Z","updated_at":"2025-03-17T20:00:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7888435,"change_date":"2024-01-25 21:44:00","inspection_id":"80686441","insp_unit_id":"199109823","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"17","insp_unit_license":"700815","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KJJABCK76PV50955","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:30.000000Z","updated_at":"2025-03-17T23:06:30.000000Z"},{"id":7888436,"change_date":"2024-01-25 21:44:00","inspection_id":"80686441","insp_unit_id":"199109824","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":null,"insp_unit_license":"4499GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T43226B008160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:30.000000Z","updated_at":"2025-03-17T23:06:30.000000Z"}]},{"id":4902460,"change_date":"2024-01-25 21:44:00","inspection_id":"80686537","dot_number":"1563469","report_state":"OK","report_number":"H600153026","insp_date":"2024-01-25 00:00:00","insp_start_time":"1357","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":"63102","location_desc":"SH-102 S\/B \/ I-40","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE","shipping_paper_number":"2893194","cargo_tank":"406","hazmat_placard_req":"Y","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-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"735422","transaction_code":"A","transaction_date":"2024-01-25 00:00:00","upload_date":"2024-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-01-25 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-01-25 21:44:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:00.000000Z","updated_at":"2025-03-17T20:00:00.000000Z","inspection_violations":[{"id":7552764,"change_date":"2024-01-25 21:44:00","inspection_id":"80686537","insp_violation_id":"257495193","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199110035","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"3939A"},{"id":7552765,"change_date":"2024-01-25 21:44:00","inspection_id":"80686537","insp_violation_id":"257495194","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199110035","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"39617C"},{"id":7552766,"change_date":"2024-01-25 21:44:00","inspection_id":"80686537","insp_violation_id":"257495195","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199110035","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"3922"},{"id":7552767,"change_date":"2024-01-25 21:44:00","inspection_id":"80686537","insp_violation_id":"257495196","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"199110036","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":7888576,"change_date":"2024-01-25 21:44:00","inspection_id":"80686537","insp_unit_id":"199110035","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"405","insp_unit_license":"3HY898","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJHHDR4JSHM7816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:30.000000Z","updated_at":"2025-03-17T23:06:30.000000Z"},{"id":7888577,"change_date":"2024-01-25 21:44:00","inspection_id":"80686537","insp_unit_id":"199110036","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"217","insp_unit_license":"4496GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T432X4B007433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:30.000000Z","updated_at":"2025-03-17T23:06:30.000000Z"}]},{"id":4711064,"change_date":"2023-12-27 21:42:00","inspection_id":"80477584","dot_number":"1563469","report_state":"OK","report_number":"H514153341","insp_date":"2023-12-27 00:00:00","insp_start_time":"0725","insp_end_time":"0755","registration_date":null,"region":"CT","ci_status_code":"C","location":"055CTY","location_desc":"NE 10TH & I-35","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"733139","transaction_code":"A","transaction_date":"2023-12-27 00:00:00","upload_date":"2023-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-12-27 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-12-27 21:42:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:11.000000Z","updated_at":"2025-03-17T19:56:11.000000Z","inspection_violations":[{"id":7273706,"change_date":"2023-12-27 21:42:00","inspection_id":"80477584","insp_violation_id":"257065798","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198684748","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39395A"},{"id":7273707,"change_date":"2023-12-27 21:42:00","inspection_id":"80477584","insp_violation_id":"257065799","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198684748","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3939A"},{"id":7273708,"change_date":"2023-12-27 21:42:00","inspection_id":"80477584","insp_violation_id":"257065800","seq_no":"3","part_no":"393","part_no_section":"55(b)","insp_viol_unit":"1","insp_unit_id":"198684748","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39355B"},{"id":7273709,"change_date":"2023-12-27 21:42:00","inspection_id":"80477584","insp_violation_id":"257065801","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"198684748","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39345B2"},{"id":7273710,"change_date":"2023-12-27 21:42:00","inspection_id":"80477584","insp_violation_id":"257065802","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198684748","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7577370,"change_date":"2023-12-27 21:42:00","inspection_id":"80477584","insp_unit_id":"198684748","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"V17070","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2FUYDSEB4SA643724","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:44.000000Z","updated_at":"2025-03-17T23:03:44.000000Z"},{"id":7577371,"change_date":"2023-12-27 21:42:00","inspection_id":"80477584","insp_unit_id":"198684749","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"6922JY","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5HTAB4326D7H78978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:44.000000Z","updated_at":"2025-03-17T23:03:44.000000Z"}]},{"id":4675443,"change_date":"2023-12-20 21:42:00","inspection_id":"80438572","dot_number":"1563469","report_state":"OK","report_number":"X900200405","insp_date":"2023-12-18 00:00:00","insp_start_time":"1250","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT W\/B MORGAN ROAD","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN","shipping_paper_number":"2880258","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"732553","transaction_code":"A","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-12-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-12-20 21:42:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:25.000000Z","updated_at":"2025-03-17T19:55:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7519842,"change_date":"2023-12-20 21:42:00","inspection_id":"80438572","insp_unit_id":"198601640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"V07105","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPSLP9X1ED225285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:13.000000Z","updated_at":"2025-03-17T23:03:13.000000Z"}]},{"id":4675270,"change_date":"2023-12-20 21:42:00","inspection_id":"80438386","dot_number":"1563469","report_state":"OK","report_number":"X900200377","insp_date":"2023-12-12 00:00:00","insp_start_time":"0645","insp_end_time":"0725","registration_date":null,"region":"CT","ci_status_code":"C","location":"09040","location_desc":"EL RENO SCALES WB","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MAGELLAN","shipping_paper_number":"2877822","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"731530","transaction_code":"A","transaction_date":"2023-12-12 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-12-12 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-12-20 21:42:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:25.000000Z","updated_at":"2025-03-17T19:55:25.000000Z","inspection_violations":[{"id":7225737,"change_date":"2023-12-20 21:42:00","inspection_id":"80438386","insp_violation_id":"256989328","seq_no":"1","part_no":"173","part_no_section":"24(b)(1)","insp_viol_unit":"1","insp_unit_id":"198601228","insp_violation_category_id":"39","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:55.000000Z","updated_at":"2025-03-17T21:40:55.000000Z","normalized_code":"17324B1"}],"inspection_per_units":[{"id":7519576,"change_date":"2023-12-20 21:42:00","inspection_id":"80438386","insp_unit_id":"198601228","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"V07105","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPSLP9X1ED225285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:13.000000Z","updated_at":"2025-03-17T23:03:13.000000Z"}]},{"id":4491944,"change_date":"2023-11-27 21:41:00","inspection_id":"80237009","dot_number":"1563469","report_state":"OK","report_number":"P113154820","insp_date":"2023-11-27 00:00:00","insp_start_time":"0730","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":"66169","location_desc":"US 169 @ CANEY RIVER","county_code_state":"OK","county_code":"131","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CVR SUPPLY","shipping_paper_number":"921400","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"729812","transaction_code":"A","transaction_date":"2023-11-27 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-11-27 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-11-27 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:49.000000Z","updated_at":"2025-03-17T19:51:49.000000Z","inspection_violations":[{"id":6951316,"change_date":"2023-11-27 21:41:00","inspection_id":"80237009","insp_violation_id":"256557382","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"198208543","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"39395F"},{"id":6951317,"change_date":"2023-11-27 21:41:00","inspection_id":"80237009","insp_violation_id":"256557383","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3922"},{"id":6951318,"change_date":"2023-11-27 21:41:00","inspection_id":"80237009","insp_violation_id":"256557384","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198208543","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7224025,"change_date":"2023-11-27 21:41:00","inspection_id":"80237009","insp_unit_id":"198208543","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"243","insp_unit_license":"3FB820","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPHD09X4AD106077","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:40.000000Z","updated_at":"2025-03-17T23:00:40.000000Z"},{"id":7224026,"change_date":"2023-11-27 21:41:00","inspection_id":"80237009","insp_unit_id":"198208544","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"256","insp_unit_license":"BG2589","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"558MEBR26KK004643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:40.000000Z","updated_at":"2025-03-17T23:00:40.000000Z"}]},{"id":4421540,"change_date":"2023-11-14 21:41:00","inspection_id":"80159637","dot_number":"1563469","report_state":"OK","report_number":"H514153282","insp_date":"2023-11-09 00:00:00","insp_start_time":"1030","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"09040","location_desc":"EL RENO SCALES","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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":"56000","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":"728246","transaction_code":"A","transaction_date":"2023-11-09 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-09 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-11-14 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","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":[],"inspection_per_units":[{"id":7110480,"change_date":"2023-11-14 21:41:00","inspection_id":"80159637","insp_unit_id":"198052129","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"V07105","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPSLP9X1ED225285","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":4172529,"change_date":"2023-10-11 21:40:00","inspection_id":"79884265","dot_number":"1563469","report_state":"OK","report_number":"D210153261","insp_date":"2023-10-11 00:00:00","insp_start_time":"0750","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":"025019","location_desc":"SH 19 4 W OF SH 74","county_code_state":"OK","county_code":"049","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"725273","transaction_code":"A","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-11 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-10-11 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:29.000000Z","updated_at":"2025-03-17T19:45:29.000000Z","inspection_violations":[{"id":6458713,"change_date":"2023-10-11 21:40:00","inspection_id":"79884265","insp_violation_id":"255770724","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:37:06.000000Z","updated_at":"2025-03-17T21:37:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6709510,"change_date":"2023-10-11 21:40:00","inspection_id":"79884265","insp_unit_id":"197499114","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"700815","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KJJABCK76PV50955","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:15.000000Z","updated_at":"2025-03-17T22:56:15.000000Z"},{"id":6709511,"change_date":"2023-10-11 21:40:00","inspection_id":"79884265","insp_unit_id":"197499115","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":null,"insp_unit_license":"4499GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T43226B008160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:15.000000Z","updated_at":"2025-03-17T22:56:15.000000Z"}]},{"id":3495750,"change_date":"2023-07-13 21:41:00","inspection_id":"79129417","dot_number":"1563469","report_state":"US","report_number":"1584000014","insp_date":"2023-07-13 00:00:00","insp_start_time":"1032","insp_end_time":"1103","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"EL RENOOK","county_code_state":"OK","county_code":"017","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"PHILLIPS 66","shipping_paper_number":"2815058","cargo_tank":"406","hazmat_placard_req":"Y","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":"2023-07-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"30325","transaction_code":"A","transaction_date":"2023-07-13 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":"2023-07-13 21:41:00","snet_input_date":"2023-07-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-07-13 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:06.000000Z","updated_at":"2025-03-17T19:32:06.000000Z","inspection_violations":[{"id":5390997,"change_date":"2023-07-13 21:41:00","inspection_id":"79129417","insp_violation_id":"254030462","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"195970863","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":5621039,"change_date":"2023-07-13 21:41:00","inspection_id":"79129417","insp_unit_id":"195970863","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"705121","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGEBG0ESFT9215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:23.000000Z","updated_at":"2025-03-17T22:47:23.000000Z"},{"id":5621040,"change_date":"2023-07-13 21:41:00","inspection_id":"79129417","insp_unit_id":"195970864","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEALL, INC","insp_unit_company":null,"insp_unit_license":"1081CV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T4324AB000294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:23.000000Z","updated_at":"2025-03-17T22:47:23.000000Z"}]},{"id":3292968,"change_date":"2023-06-15 21:42:00","inspection_id":"78901339","dot_number":"1563469","report_state":"OK","report_number":"U200163670","insp_date":"2023-06-14 00:00:00","insp_start_time":"1152","insp_end_time":"1226","registration_date":null,"region":"CT","ci_status_code":"C","location":"042035","location_desc":"GUTHRIE SITE NB","county_code_state":"OK","county_code":"083","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"P66 PARTNERS","shipping_paper_number":"968925","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"713340","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-15 21:42:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:10.000000Z","updated_at":"2025-03-17T19:28:10.000000Z","inspection_violations":[{"id":5077796,"change_date":"2023-06-15 21:42:00","inspection_id":"78901339","insp_violation_id":"253525113","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:35.000000Z","updated_at":"2025-03-17T21:30:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5293971,"change_date":"2023-06-15 21:42:00","inspection_id":"78901339","insp_unit_id":"195515711","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"716265","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3ALXFBCG4FDGJ0850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:42.000000Z","updated_at":"2025-03-17T22:44:42.000000Z"},{"id":5293972,"change_date":"2023-06-15 21:42:00","inspection_id":"78901339","insp_unit_id":"195515712","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":null,"insp_unit_license":"4495GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T042214T002001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:42.000000Z","updated_at":"2025-03-17T22:44:42.000000Z"}]},{"id":2552246,"change_date":"2023-03-10 21:41:00","inspection_id":"78061972","dot_number":"1563469","report_state":"OK","report_number":"R513154012","insp_date":"2023-03-10 00:00:00","insp_start_time":"1310","insp_end_time":"1340","registration_date":null,"region":"CT","ci_status_code":"C","location":"05040","location_desc":"I40 40MM E\/B","county_code_state":"OK","county_code":"009","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"P66 PARTNERS HOLDINGS","shipping_paper_number":"949305","cargo_tank":"406","hazmat_placard_req":"Y","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-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"702376","transaction_code":"A","transaction_date":"2023-03-10 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-03-10 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:43.000000Z","updated_at":"2025-03-17T19:13:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4107841,"change_date":"2023-03-10 21:41:00","inspection_id":"78061972","insp_unit_id":"193811466","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"19","insp_unit_license":"722850","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJF6AV25DU80079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:26.000000Z","updated_at":"2025-03-17T22:35:26.000000Z"},{"id":4107842,"change_date":"2023-03-10 21:41:00","inspection_id":"78061972","insp_unit_id":"193811467","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"200","insp_unit_license":"4503GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1PMA24425V5001099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:26.000000Z","updated_at":"2025-03-17T22:35:26.000000Z"}]},{"id":2479784,"change_date":"2023-03-29 21:41:00","inspection_id":"77979868","dot_number":"1563469","report_state":"OK","report_number":"I104152888","insp_date":"2023-02-27 00:00:00","insp_start_time":"0751","insp_end_time":"0832","registration_date":"2023-03-03 00:00:00","region":"CT","ci_status_code":"C","location":"55040","location_desc":"I-40 AND KICKAPOO TP","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN","shipping_paper_number":"2759922","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":"120000","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":"701140","transaction_code":"C","transaction_date":"2023-03-29 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-27 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-03-01 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","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":3815787,"change_date":"2023-03-29 21:41:00","inspection_id":"77979868","insp_violation_id":"251930070","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194120691","insp_violation_category_id":"20","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":"3939A"},{"id":3815788,"change_date":"2023-03-29 21:41:00","inspection_id":"77979868","insp_violation_id":"251930071","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"194120692","insp_violation_category_id":"16","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":"3963A1"},{"id":3815789,"change_date":"2023-03-29 21:41:00","inspection_id":"77979868","insp_violation_id":"251930072","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"194120692","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:55.000000Z","updated_at":"2025-03-17T21:24:55.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3990106,"change_date":"2023-03-29 21:41:00","inspection_id":"77979868","insp_unit_id":"194120691","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"723091","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJA6CK56PW60738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:36.000000Z","updated_at":"2025-03-17T22:34:36.000000Z"},{"id":3990107,"change_date":"2023-03-29 21:41:00","inspection_id":"77979868","insp_unit_id":"194120692","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":null,"insp_unit_license":"4495GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T042214T002001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:36.000000Z","updated_at":"2025-03-17T22:34:36.000000Z"}]},{"id":2479857,"change_date":"2023-03-01 21:41:00","inspection_id":"77979959","dot_number":"1563469","report_state":"OK","report_number":"I904154815","insp_date":"2023-02-24 00:00:00","insp_start_time":"0708","insp_end_time":"0739","registration_date":"2023-03-01 00:00:00","region":"CT","ci_status_code":"C","location":"14044","location_desc":"I-44 N\/B MM 111","county_code_state":"OK","county_code":"027","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"2758896","cargo_tank":"406","hazmat_placard_req":"Y","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":"116000","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":"700644","transaction_code":"A","transaction_date":"2023-02-24 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-24 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-03-01 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","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":3815878,"change_date":"2023-03-01 21:41:00","inspection_id":"77979959","insp_violation_id":"251414289","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193647602","insp_violation_category_id":"20","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":"3939A"},{"id":3815879,"change_date":"2023-03-01 21:41:00","inspection_id":"77979959","insp_violation_id":"251414290","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193647602","insp_violation_category_id":"29","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":"39617C"}],"inspection_per_units":[{"id":3990233,"change_date":"2023-03-01 21:41:00","inspection_id":"77979959","insp_unit_id":"193647602","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"710","insp_unit_license":"700815","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KJJABCK76PV50955","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:36.000000Z","updated_at":"2025-03-17T22:34:36.000000Z"},{"id":3990234,"change_date":"2023-03-01 21:41:00","inspection_id":"77979959","insp_unit_id":"193647603","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"233","insp_unit_license":"4499GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T43226B008160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:36.000000Z","updated_at":"2025-03-17T22:34:36.000000Z"}]},{"id":2410332,"change_date":"2023-02-21 21:41:00","inspection_id":"77900880","dot_number":"1563469","report_state":"OK","report_number":"T400161375","insp_date":"2023-02-20 00:00:00","insp_start_time":"1003","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":"67377","location_desc":"SH 9 @ HARVEY RD","county_code_state":"OK","county_code":"133","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MEGELLAN PIPELINE COMPANY, L.P.","shipping_paper_number":"2757348","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"124320","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":"699855","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-20 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-02-21 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:04.000000Z","updated_at":"2025-03-17T19:11:04.000000Z","inspection_violations":[{"id":3710330,"change_date":"2023-02-21 21:41:00","inspection_id":"77900880","insp_violation_id":"251237850","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"193490125","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"39347E"},{"id":3710331,"change_date":"2023-02-21 21:41:00","inspection_id":"77900880","insp_violation_id":"251237851","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"193490125","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":3878234,"change_date":"2023-02-21 21:41:00","inspection_id":"77900880","insp_unit_id":"193490124","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"2023","insp_unit_license":"726808","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KJJAEDR0CPBL2023","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:46.000000Z","updated_at":"2025-03-17T22:33:46.000000Z"},{"id":3878235,"change_date":"2023-02-21 21:41:00","inspection_id":"77900880","insp_unit_id":"193490125","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"208","insp_unit_license":"1085GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T4325YB005983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:46.000000Z","updated_at":"2025-03-17T22:33:46.000000Z"}]},{"id":2368529,"change_date":"2023-02-14 21:41:00","inspection_id":"77852966","dot_number":"1563469","report_state":"OK","report_number":"H600152269","insp_date":"2023-02-14 00:00:00","insp_start_time":"1109","insp_end_time":"1134","registration_date":null,"region":"CT","ci_status_code":"C","location":"63040","location_desc":"I-40 W\/B \/ ARENA RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPLELINE","shipping_paper_number":"2755269","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"114009","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":"699558","transaction_code":"A","transaction_date":"2023-02-14 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:20.000000Z","updated_at":"2025-03-17T19:10:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3811216,"change_date":"2023-02-14 21:41:00","inspection_id":"77852966","insp_unit_id":"193392495","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"64","insp_unit_license":"719653","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X4VD408067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"},{"id":3811217,"change_date":"2023-02-14 21:41:00","inspection_id":"77852966","insp_unit_id":"193392496","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"203","insp_unit_license":"1088GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2M4323WB005460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"}]},{"id":2368209,"change_date":"2023-02-14 21:41:00","inspection_id":"77852587","dot_number":"1563469","report_state":"OK","report_number":"H514152995","insp_date":"2023-02-13 00:00:00","insp_start_time":"0945","insp_end_time":"1001","registration_date":null,"region":"CT","ci_status_code":"C","location":"55CTY","location_desc":"NE 10TH \/ BRYANT","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"699442","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-13 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:20.000000Z","updated_at":"2025-03-17T19:10:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3810658,"change_date":"2023-02-14 21:41:00","inspection_id":"77852587","insp_unit_id":"193391617","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"700815","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KJJABCK76PV50955","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"},{"id":3810659,"change_date":"2023-02-14 21:41:00","inspection_id":"77852587","insp_unit_id":"193391618","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":null,"insp_unit_license":"4499GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T43226B008160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"}]},{"id":2368252,"change_date":"2023-02-14 21:41:00","inspection_id":"77852636","dot_number":"1563469","report_state":"OK","report_number":"I904154793","insp_date":"2023-02-13 00:00:00","insp_start_time":"1430","insp_end_time":"1458","registration_date":null,"region":"CT","ci_status_code":"C","location":"44037","location_desc":"SH 37 & TRI CITY","county_code_state":"OK","county_code":"087","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"2754958","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"114009","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":"699404","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-13 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:20.000000Z","updated_at":"2025-03-17T19:10:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3810730,"change_date":"2023-02-14 21:41:00","inspection_id":"77852636","insp_unit_id":"193391735","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"64","insp_unit_license":"719653","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X4VD408067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"},{"id":3810731,"change_date":"2023-02-14 21:41:00","inspection_id":"77852636","insp_unit_id":"193391736","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"203","insp_unit_license":"1088GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2M4323WB005460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"}]},{"id":2265072,"change_date":"2023-01-31 21:43:00","inspection_id":"77735144","dot_number":"1563469","report_state":"OK","report_number":"H514152981","insp_date":"2023-01-28 00:00:00","insp_start_time":"0930","insp_end_time":"0950","registration_date":null,"region":"CT","ci_status_code":"C","location":"055CTY","location_desc":"NE 10TH \/ I-35","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"698170","transaction_code":"A","transaction_date":"2023-01-28 00:00:00","upload_date":"2023-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-28 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-01-31 21:43:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:28.000000Z","updated_at":"2025-03-17T19:08:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3645919,"change_date":"2023-01-31 21:43:00","inspection_id":"77735144","insp_unit_id":"193150851","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"701068","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJGLDR8CSBF8984","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:08.000000Z","updated_at":"2025-03-17T22:32:08.000000Z"},{"id":3645920,"change_date":"2023-01-31 21:43:00","inspection_id":"77735144","insp_unit_id":"193150852","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":null,"insp_unit_license":"4496GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T432X4B007433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:08.000000Z","updated_at":"2025-03-17T22:32:08.000000Z"}]},{"id":2201221,"change_date":"2023-01-23 21:41:00","inspection_id":"77662479","dot_number":"1563469","report_state":"OK","report_number":"H513153761","insp_date":"2023-01-20 00:00:00","insp_start_time":"0945","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":"550CS","location_desc":"SUNNYLANE \/ RENO","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"2746464","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"697550","transaction_code":"A","transaction_date":"2023-01-23 00:00:00","upload_date":"2023-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-20 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-01-23 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:19.000000Z","updated_at":"2025-03-17T19:07:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3542695,"change_date":"2023-01-23 21:41:00","inspection_id":"77662479","insp_unit_id":"193002374","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"256","insp_unit_license":"V07105","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPSLP9X1ED225285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:24.000000Z","updated_at":"2025-03-17T22:31:24.000000Z"}]},{"id":2165135,"change_date":"2023-01-19 21:43:00","inspection_id":"77621383","dot_number":"1563469","report_state":"OK","report_number":"H600152213","insp_date":"2023-01-14 00:00:00","insp_start_time":"1340","insp_end_time":"1450","registration_date":"2023-01-19 00:00:00","region":"CT","ci_status_code":"C","location":"63040","location_desc":"I-40 E\/W \/ SH-102","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE","shipping_paper_number":"2744511","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"9","oos_total":"1","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"696646","transaction_code":"C","transaction_date":"2023-01-18 00:00:00","upload_date":"2023-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-01-18 21:39:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:35.000000Z","updated_at":"2025-03-17T19:06:35.000000Z","inspection_violations":[{"id":3348098,"change_date":"2023-01-19 21:43:00","inspection_id":"77621383","insp_violation_id":"250657020","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"3922"},{"id":3348099,"change_date":"2023-01-19 21:43:00","inspection_id":"77621383","insp_violation_id":"250657021","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"3922"},{"id":3348100,"change_date":"2023-01-19 21:43:00","inspection_id":"77621383","insp_violation_id":"250657022","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:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"3922"},{"id":3348101,"change_date":"2023-01-19 21:43:00","inspection_id":"77621383","insp_violation_id":"250657023","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:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"3922"},{"id":3348102,"change_date":"2023-01-19 21:43:00","inspection_id":"77621383","insp_violation_id":"250657024","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"3922"},{"id":3348103,"change_date":"2023-01-19 21:43:00","inspection_id":"77621383","insp_violation_id":"250657025","seq_no":"6","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192953246","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"39395A"},{"id":3348104,"change_date":"2023-01-19 21:43:00","inspection_id":"77621383","insp_violation_id":"250657026","seq_no":"7","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"192953246","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"39345D"},{"id":3348105,"change_date":"2023-01-19 21:43:00","inspection_id":"77621383","insp_violation_id":"250657027","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192953247","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"3922"},{"id":3348106,"change_date":"2023-01-19 21:43:00","inspection_id":"77621383","insp_violation_id":"250657028","seq_no":"9","part_no":"177","part_no_section":"823(a)","insp_viol_unit":"2","insp_unit_id":"192953247","insp_violation_category_id":"32","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"177823A"}],"inspection_per_units":[{"id":3484469,"change_date":"2023-01-19 21:43:00","inspection_id":"77621383","insp_unit_id":"192953246","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"160","insp_unit_license":"716684","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3AKJGLDR0HSJG4300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:58.000000Z","updated_at":"2025-03-17T22:30:58.000000Z"},{"id":3484470,"change_date":"2023-01-19 21:43:00","inspection_id":"77621383","insp_unit_id":"192953247","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"219","insp_unit_license":"44986V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5HTAB442257H68576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:58.000000Z","updated_at":"2025-03-17T22:30:58.000000Z"}]},{"id":1485130,"change_date":"2022-10-11 21:41:00","inspection_id":"76841419","dot_number":"1563469","report_state":"OK","report_number":"H600152014","insp_date":"2022-10-07 00:00:00","insp_start_time":"1243","insp_end_time":"1308","registration_date":null,"region":"CT","ci_status_code":"C","location":"63177","location_desc":"US-177 \/ ACME RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLINE PIPELINE","shipping_paper_number":"2710539","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"687127","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":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-07 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-10-11 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:06.000000Z","updated_at":"2025-03-17T18:54:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2389633,"change_date":"2022-10-11 21:41:00","inspection_id":"76841419","insp_unit_id":"191370066","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"79","insp_unit_license":"709081","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9XX6N882844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:21.000000Z","updated_at":"2025-03-17T22:23:21.000000Z"},{"id":2389634,"change_date":"2022-10-11 21:41:00","inspection_id":"76841419","insp_unit_id":"191370067","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":"254","insp_unit_license":"AB8286","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"558MEBR27JK004052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:21.000000Z","updated_at":"2025-03-17T22:23:21.000000Z"}]},{"id":1177946,"change_date":"2022-09-06 21:42:00","inspection_id":"76485088","dot_number":"1563469","report_state":"OK","report_number":"I104152645","insp_date":"2022-08-31 00:00:00","insp_start_time":"1200","insp_end_time":"1218","registration_date":"2022-09-06 00:00:00","region":"CT","ci_status_code":"C","location":"550CS","location_desc":"SUNNYLANE AND RENO","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN","shipping_paper_number":"2697124","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-08-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"682599","transaction_code":"C","transaction_date":"2022-08-31 00:00:00","upload_date":"2022-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-31 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-08-31 21:42:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:20.000000Z","updated_at":"2025-03-17T18:48:20.000000Z","inspection_violations":[{"id":1869309,"change_date":"2022-09-06 21:42:00","inspection_id":"76485088","insp_violation_id":"248220240","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:38.000000Z","updated_at":"2025-03-17T21:15:38.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":1894217,"change_date":"2022-09-06 21:42:00","inspection_id":"76485088","insp_unit_id":"190730534","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"250","insp_unit_license":"V07105","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPSLP9X1ED225285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:01.000000Z","updated_at":"2025-03-17T22:20:01.000000Z"}]},{"id":1111911,"change_date":"2022-08-23 21:41:00","inspection_id":"76408217","dot_number":"1563469","report_state":"OK","report_number":"H514159796","insp_date":"2022-08-23 00:00:00","insp_start_time":"1052","insp_end_time":"1118","registration_date":null,"region":"CT","ci_status_code":"C","location":"055CTS","location_desc":"BRYANT","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"PHILLIPS 66","shipping_paper_number":"907811","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"681629","transaction_code":"A","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-08-23 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:15.000000Z","updated_at":"2025-03-17T18:47:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1787989,"change_date":"2022-08-23 21:41:00","inspection_id":"76408217","insp_unit_id":"190486910","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTER","insp_unit_company":"7865","insp_unit_license":"3GF089","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3HCDZAPR3ML579367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:17.000000Z","updated_at":"2025-03-17T22:19:17.000000Z"},{"id":1787990,"change_date":"2022-08-23 21:41:00","inspection_id":"76408217","insp_unit_id":"190486911","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACA","insp_unit_company":null,"insp_unit_license":"BG2589","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"558MEBR26KK004643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:17.000000Z","updated_at":"2025-03-17T22:19:17.000000Z"}]},{"id":1076745,"change_date":"2022-08-18 21:40:00","inspection_id":"76367212","dot_number":"1563469","report_state":"OK","report_number":"D210152637","insp_date":"2022-08-17 00:00:00","insp_start_time":"1400","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":"025017","location_desc":"SH 17A","county_code_state":"OK","county_code":"049","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"680932","transaction_code":"A","transaction_date":"2022-08-18 00:00:00","upload_date":"2022-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-08-18 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:34.000000Z","updated_at":"2025-03-17T18:46:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1731541,"change_date":"2022-08-18 21:40:00","inspection_id":"76367212","insp_unit_id":"190403931","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"710467","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKAD49X6BJ288768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:56.000000Z","updated_at":"2025-03-17T22:18:56.000000Z"},{"id":1731542,"change_date":"2022-08-18 21:40:00","inspection_id":"76367212","insp_unit_id":"190403932","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":null,"insp_unit_license":"4495GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T042214T002001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:56.000000Z","updated_at":"2025-03-17T22:18:56.000000Z"}]},{"id":921030,"change_date":"2022-08-24 21:39:00","inspection_id":"76185351","dot_number":"1563469","report_state":"OK","report_number":"P113154116","insp_date":"2022-07-28 00:00:00","insp_start_time":"0636","insp_end_time":"0720","registration_date":"2022-08-24 00:00:00","region":"CT","ci_status_code":"C","location":"66169","location_desc":"US 169 @ NS 4070","county_code_state":"OK","county_code":"131","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"678622","transaction_code":"C","transaction_date":"2022-07-28 00:00:00","upload_date":"2022-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-28 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-07-29 21:39:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:01.000000Z","updated_at":"2025-03-17T18:44:01.000000Z","inspection_violations":[{"id":1451884,"change_date":"2022-08-24 21:39:00","inspection_id":"76185351","insp_violation_id":"247956405","seq_no":"1","part_no":"177","part_no_section":"817(e)","insp_viol_unit":"1","insp_unit_id":"190513115","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:51.000000Z","updated_at":"2025-03-17T21:13:51.000000Z","normalized_code":"177817E"}],"inspection_per_units":[{"id":1482581,"change_date":"2022-08-24 21:39:00","inspection_id":"76185351","insp_unit_id":"190513115","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"7865","insp_unit_license":"3GF089","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3HCDZAPR3ML579367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:19.000000Z","updated_at":"2025-03-17T22:17:19.000000Z"},{"id":1482582,"change_date":"2022-08-24 21:39:00","inspection_id":"76185351","insp_unit_id":"190513116","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"256","insp_unit_license":"BG2589","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"558MEBR26KK004643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:19.000000Z","updated_at":"2025-03-17T22:17:19.000000Z"}]},{"id":769770,"change_date":"2022-07-07 21:41:00","inspection_id":"76008154","dot_number":"1563469","report_state":"OK","report_number":"B509153416","insp_date":"2022-07-07 00:00:00","insp_start_time":"0825","insp_end_time":"0900","registration_date":null,"region":"CT","ci_status_code":"C","location":"07078","location_desc":"SH 48","county_code_state":"OK","county_code":"013","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"2677137","cargo_tank":"406","hazmat_placard_req":"Y","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-07-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"676341","transaction_code":"A","transaction_date":"2022-07-07 00:00:00","upload_date":"2022-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-07 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-07-07 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:14.000000Z","updated_at":"2025-03-17T18:41:14.000000Z","inspection_violations":[{"id":1213580,"change_date":"2022-07-07 21:41:00","inspection_id":"76008154","insp_violation_id":"246943933","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:12:40.000000Z","updated_at":"2025-03-17T21:12:40.000000Z","normalized_code":"3922"},{"id":1213581,"change_date":"2022-07-07 21:41:00","inspection_id":"76008154","insp_violation_id":"246943934","seq_no":"2","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"189650409","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:40.000000Z","updated_at":"2025-03-17T21:12:40.000000Z","normalized_code":"107620B"}],"inspection_per_units":[{"id":1238218,"change_date":"2022-07-07 21:41:00","inspection_id":"76008154","insp_unit_id":"189650409","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"20","insp_unit_license":"696324","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HTHCAHR4XH689588","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:48.000000Z","updated_at":"2025-03-17T22:15:48.000000Z"}]},{"id":728371,"change_date":"2022-06-30 21:41:00","inspection_id":"75959979","dot_number":"1563469","report_state":"OK","report_number":"R107150655","insp_date":"2022-06-30 00:00:00","insp_start_time":"0800","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":"67099","location_desc":"HWY 99 NB 1\/4 S. OF I-40","county_code_state":"OK","county_code":"133","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"730712","cargo_tank":"406","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-06-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"675512","transaction_code":"A","transaction_date":"2022-06-30 00:00:00","upload_date":"2022-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-06-30 21:41:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:31.000000Z","updated_at":"2025-03-17T18:40:31.000000Z","inspection_violations":[{"id":1147089,"change_date":"2022-06-30 21:41:00","inspection_id":"75959979","insp_violation_id":"246823178","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:12:22.000000Z","updated_at":"2025-03-17T21:12:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1170734,"change_date":"2022-06-30 21:41:00","inspection_id":"75959979","insp_unit_id":"189547395","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"710","insp_unit_license":"700815","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5KJJABCK76PV50955","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:23.000000Z","updated_at":"2025-03-17T22:15:23.000000Z"},{"id":1170735,"change_date":"2022-06-30 21:41:00","inspection_id":"75959979","insp_unit_id":"189547396","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"233","insp_unit_license":"4499GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T43226B008160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:23.000000Z","updated_at":"2025-03-17T22:15:23.000000Z"}]},{"id":626209,"change_date":"2022-06-16 21:42:00","inspection_id":"75839388","dot_number":"1563469","report_state":"OK","report_number":"C813153171","insp_date":"2022-06-16 00:00:00","insp_start_time":"0935","insp_end_time":"1005","registration_date":null,"region":"CT","ci_status_code":"C","location":"09040","location_desc":"EL RENO SCALES","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"KENDRICK OIL CO","shipping_paper_number":"2669576","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"108000","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":"674252","transaction_code":"A","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-16 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-06-16 21:42:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:47.000000Z","updated_at":"2025-03-17T18:38:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1006372,"change_date":"2022-06-16 21:42:00","inspection_id":"75839388","insp_unit_id":"189290866","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"79","insp_unit_license":"709081","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9XX6N882844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:23.000000Z","updated_at":"2025-03-17T22:14:23.000000Z"},{"id":1006373,"change_date":"2022-06-16 21:42:00","inspection_id":"75839388","insp_unit_id":"189290867","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":null,"insp_unit_license":"4497GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T042285T003101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:23.000000Z","updated_at":"2025-03-17T22:14:23.000000Z"}]},{"id":615869,"change_date":"2022-06-15 21:40:00","inspection_id":"75827105","dot_number":"1563469","report_state":"OK","report_number":"I904154444","insp_date":"2022-06-15 00:00:00","insp_start_time":"1043","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":"55035","location_desc":"I-35 S\/B MM 136","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"893677","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"674127","transaction_code":"A","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-15 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-06-15 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:28.000000Z","updated_at":"2025-03-17T18:38:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":990452,"change_date":"2022-06-15 21:40:00","inspection_id":"75827105","insp_unit_id":"189263987","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"148","insp_unit_license":"V17070","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2FUYDSEB4SA643724","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:17.000000Z","updated_at":"2025-03-17T22:14:17.000000Z"},{"id":990453,"change_date":"2022-06-15 21:40:00","inspection_id":"75827105","insp_unit_id":"189263988","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"249","insp_unit_license":"6922JY","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5HTAB4326D7H78978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:17.000000Z","updated_at":"2025-03-17T22:14:17.000000Z"}]},{"id":603517,"change_date":"2022-06-14 21:42:00","inspection_id":"75812551","dot_number":"1563469","report_state":"OK","report_number":"C713153884","insp_date":"2022-06-14 00:00:00","insp_start_time":"0758","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":"042035","location_desc":"GUTHRIE","county_code_state":"OK","county_code":"083","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE CO","shipping_paper_number":"2668770","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"110200","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":"673975","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-06-14 21:42:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:25.000000Z","updated_at":"2025-03-17T18:38:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":970013,"change_date":"2022-06-14 21:42:00","inspection_id":"75812551","insp_unit_id":"189231867","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"151","insp_unit_license":"710467","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKAD49X6BJ288768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:10.000000Z","updated_at":"2025-03-17T22:14:10.000000Z"},{"id":970014,"change_date":"2022-06-14 21:42:00","inspection_id":"75812551","insp_unit_id":"189231868","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"216","insp_unit_license":"4495GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T042214T002001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:10.000000Z","updated_at":"2025-03-17T22:14:10.000000Z"}]},{"id":603539,"change_date":"2022-06-14 21:42:00","inspection_id":"75812574","dot_number":"1563469","report_state":"OK","report_number":"K200180671","insp_date":"2022-06-14 00:00:00","insp_start_time":"1205","insp_end_time":"1225","registration_date":null,"region":"CT","ci_status_code":"C","location":"055JKT","location_desc":"KILPATRICK TP WB \/ MERIDIAN","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN","shipping_paper_number":"2668774","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"673941","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-06-14 21:42:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:25.000000Z","updated_at":"2025-03-17T18:38:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":970050,"change_date":"2022-06-14 21:42:00","inspection_id":"75812574","insp_unit_id":"189231954","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"V07105","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NPSLP9X1ED225285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:10.000000Z","updated_at":"2025-03-17T22:14:10.000000Z"}]},{"id":51225,"change_date":"2022-03-28 21:40:00","inspection_id":"75150832","dot_number":"1563469","report_state":"OK","report_number":"H400152723","insp_date":"2022-03-25 00:00:00","insp_start_time":"1548","insp_end_time":"1612","registration_date":null,"region":"CT","ci_status_code":"C","location":"14035","location_desc":"NORMAN","county_code_state":"OK","county_code":"027","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN","shipping_paper_number":"2639034","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"664893","transaction_code":"A","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-03-25 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-03-28 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:27.000000Z","updated_at":"2025-03-17T18:28:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":82690,"change_date":"2022-03-28 21:40:00","inspection_id":"75150832","insp_unit_id":"187844578","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"725430","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FUJAPCG71LH25884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:45.000000Z","updated_at":"2025-03-17T22:08:45.000000Z"},{"id":82691,"change_date":"2022-03-28 21:40:00","inspection_id":"75150832","insp_unit_id":"187844579","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"244","insp_unit_license":"1081GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2T4324AB000294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:45.000000Z","updated_at":"2025-03-17T22:08:45.000000Z"}]},{"id":50689,"change_date":"2022-03-28 21:40:00","inspection_id":"75150183","dot_number":"1563469","report_state":"OK","report_number":"H600151647","insp_date":"2022-03-18 00:00:00","insp_start_time":"0737","insp_end_time":"0805","registration_date":"2022-03-25 00:00:00","region":"CT","ci_status_code":"C","location":"63040","location_desc":"I-40 W\/B \/ E MCLOUD RD","county_code_state":"OK","county_code":"125","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE","shipping_paper_number":"2636041","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"114009","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":"664730","transaction_code":"A","transaction_date":"2022-03-18 00:00:00","upload_date":"2022-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-03-28 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:26.000000Z","updated_at":"2025-03-17T18:28:26.000000Z","inspection_violations":[{"id":71664,"change_date":"2022-03-28 21:40:00","inspection_id":"75150183","insp_violation_id":"244802576","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"187842884","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":81795,"change_date":"2022-03-28 21:40:00","inspection_id":"75150183","insp_unit_id":"187842884","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"64","insp_unit_license":"719653","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XP5DB9X4VD408067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:45.000000Z","updated_at":"2025-03-17T22:08:45.000000Z"},{"id":81796,"change_date":"2022-03-28 21:40:00","inspection_id":"75150183","insp_unit_id":"187842885","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":null,"insp_unit_license":"1088GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1BN2M4323WB005460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:45.000000Z","updated_at":"2025-03-17T22:08:45.000000Z"}]},{"id":50690,"change_date":"2022-03-28 21:40:00","inspection_id":"75150184","dot_number":"1563469","report_state":"OK","report_number":"H600151648","insp_date":"2022-03-18 00:00:00","insp_start_time":"0825","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":"55040","location_desc":"I-40 E\/B \/ HARRAH RD","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE","shipping_paper_number":"2636071","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"664208","transaction_code":"A","transaction_date":"2022-03-18 00:00:00","upload_date":"2022-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01563469","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-03-28 21:40:00","insp_carrier_name":"RED ROCK TRANSPORTATION COMPANY","insp_carrier_street":"ONE NORTHWEST 50TH STREET","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73118","insp_colonia":null,"docket_number":"579639","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:26.000000Z","updated_at":"2025-03-17T18:28:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":81797,"change_date":"2022-03-28 21:40:00","inspection_id":"75150184","insp_unit_id":"187842886","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"151","insp_unit_license":"710467","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XKAD49X6BJ288768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:45.000000Z","updated_at":"2025-03-17T22:08:45.000000Z"},{"id":81798,"change_date":"2022-03-28 21:40:00","inspection_id":"75150184","insp_unit_id":"187842887","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"216","insp_unit_license":"4495GV","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4J8T042214T002001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:45.000000Z","updated_at":"2025-03-17T22:08:45.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1563469\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1563469\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1563469\/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\/1563469\/inspections","per_page":100,"prev_page_url":null,"to":71,"total":71}