{"current_page":1,"data":[{"id":12137788,"change_date":"2026-06-09 21:42:00","inspection_id":"88084335","dot_number":"523315","report_state":"OK","report_number":"Y600202825","insp_date":"2026-06-09 00:00:00","insp_start_time":"1314","insp_end_time":"1332","registration_date":null,"region":"CS","ci_status_code":"C","location":"73069","location_desc":"OK","county_code_state":"OK","county_code":"145","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MUSKOGEE SAND","shipping_paper_number":"59995","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3501814","transaction_code":"A","transaction_date":"2026-06-09 00:00:00","upload_date":"2026-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":null,"census_search_date":"2026-06-09 21:42:00","snet_input_date":"2026-06-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-09 21:42:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-12T09:40:04.000000Z","updated_at":"2026-06-20T09:32:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21087131,"change_date":"2026-06-09 21:42:00","inspection_id":"88084335","insp_unit_id":"213991082","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"V70962","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2HSFMAXR7WC068426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:54.000000Z","updated_at":"2026-06-20T09:04:54.000000Z"}]},{"id":11779941,"change_date":"2026-06-29 21:42:00","inspection_id":"87711166","dot_number":"523315","report_state":"OK","report_number":"P313152730","insp_date":"2026-04-28 00:00:00","insp_start_time":"2300","insp_end_time":"2300","registration_date":null,"region":"CS","ci_status_code":"C","location":"51MTP","location_desc":"OK","county_code_state":"OK","county_code":"101","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":"U","pen_cen_match":"I","final_status_date":"2026-04-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3231302","transaction_code":"C","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":null,"census_search_date":"2026-04-29 21:40:00","snet_input_date":"2026-04-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-29 21:40:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-02T09:41:02.000000Z","updated_at":"2026-07-10T09:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20492986,"change_date":"2026-06-29 21:42:00","inspection_id":"87711166","insp_unit_id":"214349776","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"V70962","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2HSFMAXR7WC068426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:15.000000Z","updated_at":"2026-07-10T09:00:59.000000Z"}]},{"id":10106386,"change_date":"2025-11-03 21:39:00","inspection_id":"86222227","dot_number":"523315","report_state":"OK","report_number":"Y600202363","insp_date":"2025-11-03 00:00:00","insp_start_time":"0920","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":"73069","location_desc":"US69 \/ SH51B","county_code_state":"OK","county_code":"145","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"802363","transaction_code":"A","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-03 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-11-03 21:39:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-06T10:30:41.000000Z","updated_at":"2025-11-07T10:30:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16807137,"change_date":"2025-11-03 21:39:00","inspection_id":"86222227","insp_unit_id":"209804107","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"390","insp_unit_license":"12172V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPFDU9X7YD501069","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:37.000000Z","updated_at":"2025-11-07T10:00:54.000000Z"}]},{"id":9632568,"change_date":"2025-09-09 21:40:00","inspection_id":"85723704","dot_number":"523315","report_state":"OK","report_number":"J206155568","insp_date":"2025-09-08 00:00:00","insp_start_time":"0711","insp_end_time":"0736","registration_date":null,"region":"CT","ci_status_code":"C","location":"73069","location_desc":"US 69 AT CRESTWOOD","county_code_state":"OK","county_code":"145","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"796765","transaction_code":"A","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":null,"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":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-11T10:47:08.000000Z","updated_at":"2025-09-13T10:46:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15912690,"change_date":"2025-09-09 21:40:00","inspection_id":"85723704","insp_unit_id":"208828770","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"V70962","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2HSFMAXR7WC068426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:47.000000Z","updated_at":"2025-09-13T09:59:42.000000Z"}]},{"id":8310875,"change_date":"2025-05-15 21:43:00","inspection_id":"84331041","dot_number":"523315","report_state":"OK","report_number":"J206155354","insp_date":"2025-04-07 00:00:00","insp_start_time":"0657","insp_end_time":"0724","registration_date":"2025-05-15 00:00:00","region":"CT","ci_status_code":"C","location":"73069","location_desc":"U.S. 69 AND FLATROCK ROAD","county_code_state":"OK","county_code":"145","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MUSKOGEE SAND","shipping_paper_number":"38091","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117827","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":"780871","transaction_code":"C","transaction_date":"2025-04-07 00:00:00","upload_date":"2025-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-04-07 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-04-07 21:40:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-11T10:11:19.000000Z","updated_at":"2025-05-19T10:04:11.000000Z","inspection_violations":[{"id":13739777,"change_date":"2025-05-15 21:43:00","inspection_id":"84331041","insp_violation_id":"266247471","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"206880768","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:29:06.000000Z","updated_at":"2025-05-19T10:21:25.000000Z","normalized_code":"3939ALTSI"},{"id":13739778,"change_date":"2025-05-15 21:43:00","inspection_id":"84331041","insp_violation_id":"266247472","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"206880769","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:29:06.000000Z","updated_at":"2025-05-19T10:21:25.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":13739779,"change_date":"2025-05-15 21:43:00","inspection_id":"84331041","insp_violation_id":"266247473","seq_no":"3","part_no":"393","part_no_section":"75A1-TEPBM","insp_viol_unit":"2","insp_unit_id":"206880769","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:29:06.000000Z","updated_at":"2025-05-19T10:21:25.000000Z","normalized_code":"39375A1TEPBM"}],"inspection_per_units":[{"id":14107157,"change_date":"2025-05-15 21:43:00","inspection_id":"84331041","insp_unit_id":"206880768","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"99","insp_unit_license":"702494","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4VG7DERH5XN785693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:49:50.000000Z","updated_at":"2025-05-19T09:49:23.000000Z"},{"id":14107158,"change_date":"2025-05-15 21:43:00","inspection_id":"84331041","insp_unit_id":"206880769","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"12041","insp_unit_license":"4048LM","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"48X1C2822Y1000892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:49:50.000000Z","updated_at":"2025-05-19T09:49:23.000000Z"}]},{"id":6007224,"change_date":"2024-06-17 21:43:00","inspection_id":"81890312","dot_number":"523315","report_state":"OK","report_number":"P313151530","insp_date":"2024-06-17 00:00:00","insp_start_time":"1342","insp_end_time":"1414","registration_date":null,"region":"CT","ci_status_code":"C","location":"51069","location_desc":"US69\/53RD ST","county_code_state":"OK","county_code":"101","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"751290","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-06-17 21:43:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:51.000000Z","updated_at":"2025-03-17T20:21:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9675432,"change_date":"2024-06-17 21:43:00","inspection_id":"81890312","insp_unit_id":"201427261","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"V70962","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2HSFMAXR7WC068426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"}]},{"id":5248511,"change_date":"2024-03-09 21:31:00","inspection_id":"81064415","dot_number":"523315","report_state":"OK","report_number":"N114152465","insp_date":"2024-03-08 00:00:00","insp_start_time":"0912","insp_end_time":"0953","registration_date":null,"region":"CT","ci_status_code":"C","location":"073364","location_desc":"CREEK TRNPK MM 30 EB","county_code_state":"OK","county_code":"145","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MUSKOGEE SAND","shipping_paper_number":"16823","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-09 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"740001","transaction_code":"A","transaction_date":"2024-03-09 00:00:00","upload_date":"2024-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-08 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-03-09 21:31:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:40.000000Z","updated_at":"2025-03-17T20:06:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8451360,"change_date":"2024-03-09 21:31:00","inspection_id":"81064415","insp_unit_id":"199832320","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"V70962","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2HSFMAXR7WC068426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:35.000000Z","updated_at":"2025-03-17T23:11:35.000000Z"}]},{"id":4954136,"change_date":"2024-02-01 21:43:00","inspection_id":"80743127","dot_number":"523315","report_state":"OK","report_number":"K300181477","insp_date":"2024-01-31 00:00:00","insp_start_time":"1316","insp_end_time":"1340","registration_date":null,"region":"CT","ci_status_code":"C","location":"49412","location_desc":"US 69 \/ US 412","county_code_state":"OK","county_code":"097","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"PRYOR STONE","shipping_paper_number":"1502749","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-02-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"735996","transaction_code":"A","transaction_date":"2024-01-31 00:00:00","upload_date":"2024-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-01-31 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-02-01 21:43:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:51.000000Z","updated_at":"2025-03-17T20:00:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7972974,"change_date":"2024-02-01 21:43:00","inspection_id":"80743127","insp_unit_id":"199219783","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"V70962","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2HSFMAXR7WC068426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:16.000000Z","updated_at":"2025-03-17T23:07:16.000000Z"}]},{"id":4674146,"change_date":"2023-12-20 21:41:00","inspection_id":"80437157","dot_number":"523315","report_state":"OK","report_number":"P313151218","insp_date":"2023-12-18 00:00:00","insp_start_time":"1325","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":"71069","location_desc":"US69\/MTP","county_code_state":"OK","county_code":"145","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MUSKOGEE SAND","shipping_paper_number":"651832","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"732325","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":"00523315","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:41:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","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":7517629,"change_date":"2023-12-20 21:41:00","inspection_id":"80437157","insp_unit_id":"198598068","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"V70962","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2HSFMAXR7WC068426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:12.000000Z","updated_at":"2025-03-17T23:03:12.000000Z"}]},{"id":4492266,"change_date":"2023-11-27 21:41:00","inspection_id":"80237358","dot_number":"523315","report_state":"OK","report_number":"P313151158","insp_date":"2023-11-27 00:00:00","insp_start_time":"1215","insp_end_time":"1250","registration_date":null,"region":"CT","ci_status_code":"C","location":"73CTP","location_desc":"CTP\/NORTH GATE","county_code_state":"OK","county_code":"145","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","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":"48000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"729810","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":"00523315","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":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:50.000000Z","updated_at":"2025-03-17T19:51:50.000000Z","inspection_violations":[{"id":6951741,"change_date":"2023-11-27 21:41:00","inspection_id":"80237358","insp_violation_id":"256558809","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"39216A"},{"id":6951742,"change_date":"2023-11-27 21:41:00","inspection_id":"80237358","insp_violation_id":"256558810","seq_no":"2","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"198209757","insp_violation_category_id":"30","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":"393203C"},{"id":6951743,"change_date":"2023-11-27 21:41:00","inspection_id":"80237358","insp_violation_id":"256558811","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198209757","insp_violation_category_id":"30","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":"3963A1"}],"inspection_per_units":[{"id":7224571,"change_date":"2023-11-27 21:41:00","inspection_id":"80237358","insp_unit_id":"198209757","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"390","insp_unit_license":"12172V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPFDU9X7YD501069","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":4311865,"change_date":"2023-10-30 21:42:00","inspection_id":"80038343","dot_number":"523315","report_state":"OK","report_number":"J206154413","insp_date":"2023-10-24 00:00:00","insp_start_time":"0711","insp_end_time":"0724","registration_date":null,"region":"CT","ci_status_code":"C","location":"73069","location_desc":"US 69 AT CRESTWOOD","county_code_state":"OK","county_code":"145","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"726577","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-24 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-10-30 21:42:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:22.000000Z","updated_at":"2025-03-17T19:48:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6934691,"change_date":"2023-10-30 21:42:00","inspection_id":"80038343","insp_unit_id":"197811640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"346","insp_unit_license":"V70962","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2HSFMAXR7WC068426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:11.000000Z","updated_at":"2025-03-17T22:58:11.000000Z"}]},{"id":3787426,"change_date":"2023-12-20 21:41:00","inspection_id":"79455760","dot_number":"523315","report_state":"OK","report_number":"J206154313","insp_date":"2023-08-17 00:00:00","insp_start_time":"0749","insp_end_time":"0816","registration_date":"2023-12-07 00:00:00","region":"CT","ci_status_code":"C","location":"73069","location_desc":"U.S. 69 AND BAKERS ROAD","county_code_state":"OK","county_code":"145","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"719753","transaction_code":"C","transaction_date":"2023-08-21 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-08-21 21:41:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:40.000000Z","updated_at":"2025-03-17T19:37:40.000000Z","inspection_violations":[{"id":5842329,"change_date":"2023-12-20 21:41:00","inspection_id":"79455760","insp_violation_id":"256986636","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198599060","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:10.000000Z","updated_at":"2025-03-17T21:34:10.000000Z","normalized_code":"39617C"},{"id":5842330,"change_date":"2023-12-20 21:41:00","inspection_id":"79455760","insp_violation_id":"256986637","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198599060","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:10.000000Z","updated_at":"2025-03-17T21:34:10.000000Z","normalized_code":"39378"},{"id":5842331,"change_date":"2023-12-20 21:41:00","inspection_id":"79455760","insp_violation_id":"256986638","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198599060","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:10.000000Z","updated_at":"2025-03-17T21:34:10.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6089417,"change_date":"2023-12-20 21:41:00","inspection_id":"79455760","insp_unit_id":"198599060","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"390","insp_unit_license":"12172V","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1XPFDU9X7YD501069","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:09.000000Z","updated_at":"2025-03-17T22:51:09.000000Z"}]},{"id":3432084,"change_date":"2023-07-05 21:41:00","inspection_id":"79057499","dot_number":"523315","report_state":"OK","report_number":"H513153997","insp_date":"2023-06-29 00:00:00","insp_start_time":"1425","insp_end_time":"1500","registration_date":null,"region":"CT","ci_status_code":"C","location":"73016","location_desc":"SH 16 \/ 15TH ST (WAGONER)","county_code_state":"OK","county_code":"145","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"287673","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"715442","transaction_code":"A","transaction_date":"2023-07-05 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-29 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-07-05 21:41:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:57.000000Z","updated_at":"2025-03-17T19:30:57.000000Z","inspection_violations":[{"id":5290602,"change_date":"2023-07-05 21:41:00","inspection_id":"79057499","insp_violation_id":"253863326","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195823363","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:34.000000Z","updated_at":"2025-03-17T21:31:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5518152,"change_date":"2023-07-05 21:41:00","inspection_id":"79057499","insp_unit_id":"195823363","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"-","insp_unit_license":"V70962","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2HSFMAXR7WC068426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:33.000000Z","updated_at":"2025-03-17T22:46:33.000000Z"}]},{"id":3385425,"change_date":"2023-06-28 21:42:00","inspection_id":"79005306","dot_number":"523315","report_state":"OK","report_number":"Y600200967","insp_date":"2023-06-28 00:00:00","insp_start_time":"1555","insp_end_time":"1613","registration_date":null,"region":"CT","ci_status_code":"C","location":"73069","location_desc":"US 69 \/ 90TH ST N","county_code_state":"OK","county_code":"145","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MUSKOGEE SAND","shipping_paper_number":"4593","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117827","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":"714946","transaction_code":"A","transaction_date":"2023-06-28 00:00:00","upload_date":"2023-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-28 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-28 21:42:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:09.000000Z","updated_at":"2025-03-17T19:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5442498,"change_date":"2023-06-28 21:42:00","inspection_id":"79005306","insp_unit_id":"195719856","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"99","insp_unit_license":"702494","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4VG7DERH5XN785693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:56.000000Z","updated_at":"2025-03-17T22:45:56.000000Z"},{"id":5442499,"change_date":"2023-06-28 21:42:00","inspection_id":"79005306","insp_unit_id":"195719857","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":null,"insp_unit_license":"4048LM","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"48X1C2822Y1000892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:56.000000Z","updated_at":"2025-03-17T22:45:56.000000Z"}]},{"id":1675728,"change_date":"2022-11-21 21:41:00","inspection_id":"77060623","dot_number":"523315","report_state":"OK","report_number":"Y600200567","insp_date":"2022-11-03 00:00:00","insp_start_time":"1443","insp_end_time":"1526","registration_date":"2022-11-21 00:00:00","region":"CT","ci_status_code":"C","location":"73069","location_desc":"US 69 AND 90TH ST N","county_code_state":"OK","county_code":"145","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"819247","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"689852","transaction_code":"C","transaction_date":"2022-11-04 00:00:00","upload_date":"2022-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-03 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-11-04 21:38:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:27.000000Z","updated_at":"2025-03-17T18:57:27.000000Z","inspection_violations":[{"id":2627912,"change_date":"2022-11-21 21:41:00","inspection_id":"77060623","insp_violation_id":"249712308","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:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"3922"},{"id":2627913,"change_date":"2022-11-21 21:41:00","inspection_id":"77060623","insp_violation_id":"249712309","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:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2695607,"change_date":"2022-11-21 21:41:00","inspection_id":"77060623","insp_unit_id":"192058513","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"346","insp_unit_license":"V70962","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2HSFMAXR7WC068426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:29.000000Z","updated_at":"2025-03-17T22:25:29.000000Z"}]},{"id":1386627,"change_date":"2022-09-28 21:40:00","inspection_id":"76727091","dot_number":"523315","report_state":"OK","report_number":"J206153727","insp_date":"2022-09-28 00:00:00","insp_start_time":"0722","insp_end_time":"0737","registration_date":null,"region":"CT","ci_status_code":"C","location":"73069","location_desc":"U.S. 69 AND SW 9TH","county_code_state":"OK","county_code":"145","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MUSKOGEE SAND","shipping_paper_number":"631371","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"685659","transaction_code":"A","transaction_date":"2022-09-28 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-28 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-09-28 21:40:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:19.000000Z","updated_at":"2025-03-17T18:52:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2232742,"change_date":"2022-09-28 21:40:00","inspection_id":"76727091","insp_unit_id":"191142855","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"346","insp_unit_license":"V70962","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2HSFMAXR7WC068426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:16.000000Z","updated_at":"2025-03-17T22:22:16.000000Z"}]},{"id":1177930,"change_date":"2022-08-31 21:42:00","inspection_id":"76485067","dot_number":"523315","report_state":"OK","report_number":"N114151523","insp_date":"2022-08-31 00:00:00","insp_start_time":"0935","insp_end_time":"1003","registration_date":null,"region":"CT","ci_status_code":"C","location":"058060","location_desc":"US 60 @ FAIRLAND","county_code_state":"OK","county_code":"115","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"KEMPSTONE","shipping_paper_number":"609019","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-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117827","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":"682583","transaction_code":"A","transaction_date":"2022-08-31 00:00:00","upload_date":"2022-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","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":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","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":[],"inspection_per_units":[{"id":1894191,"change_date":"2022-08-31 21:42:00","inspection_id":"76485067","insp_unit_id":"190643374","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"99","insp_unit_license":"702494","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4VG7DERH5XN785693","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":1894192,"change_date":"2022-08-31 21:42:00","inspection_id":"76485067","insp_unit_id":"190643375","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"421","insp_unit_license":"4048LM","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"48X1C2822Y1000892","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":746334,"change_date":"2022-07-05 21:41:00","inspection_id":"75981094","dot_number":"523315","report_state":"OK","report_number":"K300180624","insp_date":"2022-07-05 00:00:00","insp_start_time":"1018","insp_end_time":"1036","registration_date":null,"region":"CT","ci_status_code":"C","location":"73051","location_desc":"SH 51 \/ S 230 RD","county_code_state":"OK","county_code":"145","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"676020","transaction_code":"A","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-07-05 21:41:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:52.000000Z","updated_at":"2025-03-17T18:40:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1199674,"change_date":"2022-07-05 21:41:00","inspection_id":"75981094","insp_unit_id":"189594314","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"346","insp_unit_license":"V70962","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2HSFMAXR7WC068426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:32.000000Z","updated_at":"2025-03-17T22:15:32.000000Z"}]},{"id":458961,"change_date":"2022-05-23 21:42:00","inspection_id":"75640318","dot_number":"523315","report_state":"OK","report_number":"J206153508","insp_date":"2022-05-23 00:00:00","insp_start_time":"0912","insp_end_time":"0925","registration_date":null,"region":"CT","ci_status_code":"C","location":"73069","location_desc":"U.S. 69 AND RR OVERPASS","county_code_state":"OK","county_code":"145","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MUSKOGEE SAND","shipping_paper_number":"623197","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"671656","transaction_code":"A","transaction_date":"2022-05-23 00:00:00","upload_date":"2022-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00523315","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-05-23 21:42:00","insp_carrier_name":"YATES TRUCKING COMPANY INC","insp_carrier_street":"1100 SOUTH WEST 12TH","insp_carrier_city":"WAGONER","insp_carrier_state":"OK","insp_carrier_zip_code":"74467","insp_colonia":null,"docket_number":"205064","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:41.000000Z","updated_at":"2025-03-17T18:35:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":739347,"change_date":"2022-05-23 21:42:00","inspection_id":"75640318","insp_unit_id":"188853886","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"V70962","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"2HSFMAXR7WC068426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:44.000000Z","updated_at":"2025-03-17T22:12:44.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/523315\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/523315\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/523315\/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\/523315\/inspections","per_page":100,"prev_page_url":null,"to":19,"total":19}