{"current_page":1,"data":[{"id":12372544,"change_date":"2026-07-07 21:40:00","inspection_id":"88335006","dot_number":"2561156","report_state":"OK","report_number":"X900202139","insp_date":"2026-07-07 00:00:00","insp_start_time":"0740","insp_end_time":"0805","registration_date":null,"region":"CD","ci_status_code":"C","location":"JKT","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":"M\/C","shipping_paper_number":"M\/C","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-07 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":"3697554","transaction_code":"A","transaction_date":"2026-07-07 00:00:00","upload_date":"2026-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":null,"census_search_date":"2026-07-07 21:40:00","snet_input_date":"2026-07-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-07 21:40:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"5616 S ROCKWELL ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73179","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-10T09:40:17.000000Z","updated_at":"2026-07-17T09:31:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21484806,"change_date":"2026-07-07 21:40:00","inspection_id":"88335006","insp_unit_id":"214474455","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5","insp_unit_license":"011C79","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC5SM048509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-10T09:16:32.000000Z","updated_at":"2026-07-17T09:03:27.000000Z"}]},{"id":12315300,"change_date":"2026-06-29 21:42:00","inspection_id":"88273030","dot_number":"2561156","report_state":"OK","report_number":"U200165399","insp_date":"2026-06-29 00:00:00","insp_start_time":"1048","insp_end_time":"1125","registration_date":null,"region":"CD","ci_status_code":"C","location":"055CIS","location_desc":"OK","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":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"3647188","transaction_code":"A","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":null,"census_search_date":"2026-06-29 21:42:00","snet_input_date":"2026-06-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-29 21:42:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"5616 S ROCKWELL ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73179","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-02T09:40:41.000000Z","updated_at":"2026-07-10T09:31:31.000000Z","inspection_violations":[{"id":21431973,"change_date":"2026-06-29 21:42:00","inspection_id":"88273030","insp_violation_id":"275200744","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG1","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-07-02T10:01:00.000000Z","updated_at":"2026-07-10T09:43:11.000000Z","normalized_code":"3922SLLEWG1"},{"id":21431974,"change_date":"2026-06-29 21:42:00","inspection_id":"88273030","insp_violation_id":"275200745","seq_no":"2","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":"P220024","created_at":"2026-07-02T10:01:00.000000Z","updated_at":"2026-07-10T09:43:11.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":21389352,"change_date":"2026-06-29 21:42:00","inspection_id":"88273030","insp_unit_id":"214354965","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"011C80","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC3SM048508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:40.000000Z","updated_at":"2026-07-10T09:02:52.000000Z"}]},{"id":12248553,"change_date":"2026-06-22 21:39:00","inspection_id":"88206881","dot_number":"2561156","report_state":"OK","report_number":"D900000994","insp_date":"2026-06-22 00:00:00","insp_start_time":"1022","insp_end_time":"1053","registration_date":null,"region":"CS","ci_status_code":"C","location":"05535","location_desc":"OK","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":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-22 21:39: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":"3594560","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":"02561156","upload_search_indicator":null,"census_search_date":"2026-06-22 21:39:00","snet_input_date":"2026-06-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-22 21:39:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"5616 S ROCKWELL ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73179","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-25T09:38:49.000000Z","updated_at":"2026-07-03T09:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21270454,"change_date":"2026-06-22 21:39:00","inspection_id":"88206881","insp_unit_id":"214220984","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"8","insp_unit_license":"011C79","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC5SM048509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:12.000000Z","updated_at":"2026-07-05T09:01:42.000000Z"}]},{"id":11972849,"change_date":"2026-05-20 21:41:00","inspection_id":"87909710","dot_number":"2561156","report_state":"OK","report_number":"X200173157","insp_date":"2026-05-20 00:00:00","insp_start_time":"0631","insp_end_time":"0710","registration_date":null,"region":"CS","ci_status_code":"C","location":"37081","location_desc":"OK","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":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"3368515","transaction_code":"A","transaction_date":"2026-05-20 00:00:00","upload_date":"2026-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":null,"census_search_date":"2026-05-20 21:41:00","snet_input_date":"2026-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-20 21:41:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"5616 S ROCKWELL ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73179","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-23T09:42:54.000000Z","updated_at":"2026-06-01T09:30:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20816257,"change_date":"2026-05-20 21:41:00","inspection_id":"87909710","insp_unit_id":"213663972","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"8","insp_unit_license":"011C47","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M1AN3GY0KM002992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:25.000000Z","updated_at":"2026-06-01T09:02:48.000000Z"},{"id":20816258,"change_date":"2026-05-20 21:41:00","inspection_id":"87909710","insp_unit_id":"213663973","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DURE","insp_unit_company":"8","insp_unit_license":"DM8911","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3F8KF5321T1011097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:25.000000Z","updated_at":"2026-06-01T09:02:48.000000Z"}]},{"id":11770681,"change_date":"2026-04-28 21:39:00","inspection_id":"87701460","dot_number":"2561156","report_state":"OK","report_number":"X900202020","insp_date":"2026-04-27 00:00:00","insp_start_time":"0700","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT N\/B SW 29TH ST","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"GENERAL MATERIALS INC","shipping_paper_number":"696663","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-28 21:39: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":"0","hazmat_oos_total":"0","snet_sequence_id":"818445","transaction_code":"A","transaction_date":"2026-04-27 00:00:00","upload_date":"2026-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2026-04-28 21:39:00","snet_input_date":"2026-04-27 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-04-28 21:39:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"5616 S ROCKWELL ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73179","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-01T09:40:29.000000Z","updated_at":"2026-05-09T09:31:07.000000Z","inspection_violations":[{"id":20466088,"change_date":"2026-04-28 21:39:00","inspection_id":"87701460","insp_violation_id":"273906920","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"213269682","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-05-01T10:02:08.000000Z","updated_at":"2026-05-09T09:42:09.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":20477701,"change_date":"2026-04-28 21:39:00","inspection_id":"87701460","insp_unit_id":"213269682","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"011C79","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC5SM048509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:20:46.000000Z","updated_at":"2026-05-09T09:03:36.000000Z"}]},{"id":11105126,"change_date":"2026-02-11 21:38:00","inspection_id":"87017378","dot_number":"2561156","report_state":"OK","report_number":"X900201909","insp_date":"2026-02-11 00:00:00","insp_start_time":"1345","insp_end_time":"1405","registration_date":null,"region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT 2\/B BRITTON TOLL PLAZA","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SCHEARTZ SAND LLC","shipping_paper_number":"5300011","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-11 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":"812081","transaction_code":"A","transaction_date":"2026-02-11 00:00:00","upload_date":"2026-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":null,"census_search_date":"2026-02-11 21:38:00","snet_input_date":"2026-02-11 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-02-11 21:38:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"5616 S ROCKWELL ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73179","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-14T10:37:33.000000Z","updated_at":"2026-02-22T10:30:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18938372,"change_date":"2026-02-11 21:38:00","inspection_id":"87017378","insp_unit_id":"211563255","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4","insp_unit_license":"011C80","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC3SM048508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-14T10:15:33.000000Z","updated_at":"2026-02-22T10:03:05.000000Z"}]},{"id":11094056,"change_date":"2026-03-10 21:38:00","inspection_id":"87005811","dot_number":"2561156","report_state":"OK","report_number":"K200182946","insp_date":"2026-02-10 00:00:00","insp_start_time":"1209","insp_end_time":"1235","registration_date":"2026-03-06 00:00:00","region":"CT","ci_status_code":"C","location":"055035","location_desc":"I-35 NB \/ KILPATRICK TURNPIKE","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SCHWARTZ","shipping_paper_number":"5309882","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"811895","transaction_code":"C","transaction_date":"2026-02-10 00:00:00","upload_date":"2026-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2026-02-10 21:38:00","snet_input_date":"2026-02-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-02-10 21:38:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"5616 S ROCKWELL ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73179","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-13T10:37:52.000000Z","updated_at":"2026-03-21T09:31:17.000000Z","inspection_violations":[{"id":19080211,"change_date":"2026-03-10 21:38:00","inspection_id":"87005811","insp_violation_id":"272309574","seq_no":"1","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-03-13T10:04:59.000000Z","updated_at":"2026-03-21T09:48:57.000000Z","normalized_code":"3922SLLEWA1"},{"id":19080212,"change_date":"2026-03-10 21:38:00","inspection_id":"87005811","insp_violation_id":"272309575","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG1","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-03-13T10:04:59.000000Z","updated_at":"2026-03-21T09:48:57.000000Z","normalized_code":"3922SLLEWG1"},{"id":19080213,"change_date":"2026-03-10 21:38:00","inspection_id":"87005811","insp_violation_id":"272309576","seq_no":"3","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"212063038","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:04:59.000000Z","updated_at":"2026-03-21T09:48:57.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":19384522,"change_date":"2026-03-10 21:38:00","inspection_id":"87005811","insp_unit_id":"212063038","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"6","insp_unit_license":"180C37","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX13CXGM035316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:13.000000Z","updated_at":"2026-03-21T09:08:18.000000Z"}]},{"id":10177764,"change_date":"2025-11-12 21:41:00","inspection_id":"86297434","dot_number":"2561156","report_state":"OK","report_number":"D900000653","insp_date":"2025-11-12 00:00:00","insp_start_time":"0643","insp_end_time":"0726","registration_date":null,"region":"CT","ci_status_code":"C","location":"05535","location_desc":"I-35 NB & SE 15TH - EDMOND","county_code_state":"OK","county_code":"109","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-12 21:41: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":"803237","transaction_code":"A","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":null,"census_search_date":"2025-11-12 21:41:00","snet_input_date":"2025-11-12 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-11-12 21:41:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"5616 S ROCKWELL ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73179","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-15T10:30:47.000000Z","updated_at":"2025-11-16T10:30:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16951232,"change_date":"2025-11-12 21:41:00","inspection_id":"86297434","insp_unit_id":"209976820","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4","insp_unit_license":"011C80","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC3SM048508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:39.000000Z","updated_at":"2025-11-16T10:01:11.000000Z"}]},{"id":10018975,"change_date":"2025-10-30 21:42:00","inspection_id":"86130120","dot_number":"2561156","report_state":"OK","report_number":"X900201692","insp_date":"2025-10-23 00:00:00","insp_start_time":"0700","insp_end_time":"0725","registration_date":"2025-10-30 00:00:00","region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT S\/B BRITTON TOLL PLAZA","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"GENERAL MATERIALS","shipping_paper_number":"875147","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-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"801442","transaction_code":"C","transaction_date":"2025-10-23 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2025-10-23 21:39:00","snet_input_date":"2025-10-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"5616 S ROCKWELL ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73179","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:54.000000Z","updated_at":"2025-11-03T11:00:23.000000Z","inspection_violations":[{"id":16685474,"change_date":"2025-10-30 21:42:00","inspection_id":"86130120","insp_violation_id":"269626100","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"209749603","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:17:47.000000Z","updated_at":"2025-11-03T11:15:33.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":16747011,"change_date":"2025-10-30 21:42:00","inspection_id":"86130120","insp_unit_id":"209749603","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4","insp_unit_license":"011C86","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC3SM048508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:20.000000Z","updated_at":"2025-11-03T10:45:33.000000Z"}]},{"id":9706795,"change_date":"2025-09-24 21:42:00","inspection_id":"85801801","dot_number":"2561156","report_state":"OK","report_number":"H514154231","insp_date":"2025-09-17 00:00:00","insp_start_time":"1000","insp_end_time":"1018","registration_date":"2025-09-23 00:00:00","region":"CT","ci_status_code":"C","location":"055044","location_desc":"KILPATRICK TURNPIKE \/ SANTA FE","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"797959","transaction_code":"C","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2025-09-17 21:40:00","snet_input_date":"2025-09-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-09-17 21:40:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"5616 S ROCKWELL ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73179","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:47.000000Z","updated_at":"2025-09-28T10:00:36.000000Z","inspection_violations":[{"id":16056548,"change_date":"2025-09-24 21:42:00","inspection_id":"85801801","insp_violation_id":"268898277","seq_no":"1","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:17:04.000000Z","updated_at":"2025-09-28T10:15:58.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":16183885,"change_date":"2025-09-24 21:42:00","inspection_id":"85801801","insp_unit_id":"209124937","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"011C78","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC1SM048507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:23.000000Z","updated_at":"2025-09-29T09:46:03.000000Z"}]},{"id":9604138,"change_date":"2025-09-05 21:39:00","inspection_id":"85694126","dot_number":"2561156","report_state":"OK","report_number":"K200182682","insp_date":"2025-09-05 00:00:00","insp_start_time":"0945","insp_end_time":"1018","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"KILPATRICK TP WB & BROADWAY","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MUNOZ SAND","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-05 21:39: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":"796712","transaction_code":"A","transaction_date":"2025-09-05 00:00:00","upload_date":"2025-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2025-09-05 21:39:00","snet_input_date":"2025-09-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-09-05 21:39:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"5616 S ROCKWELL ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73179","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:47.000000Z","updated_at":"2025-09-10T10:45:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15858834,"change_date":"2025-09-05 21:39:00","inspection_id":"85694126","insp_unit_id":"208770732","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1","insp_unit_license":"011C78","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC1SM048507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:29.000000Z","updated_at":"2025-09-10T09:46:29.000000Z"}]},{"id":9155036,"change_date":"2025-07-15 21:40:00","inspection_id":"85221885","dot_number":"2561156","report_state":"OK","report_number":"K200182584","insp_date":"2025-07-15 00:00:00","insp_start_time":"0813","insp_end_time":"0825","registration_date":null,"region":"CT","ci_status_code":"C","location":"055KTP","location_desc":"KICKAPOO TURNPIKE \/ NE 50TH","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-15 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":"791208","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2025-07-15 21:40:00","snet_input_date":"2025-07-15 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-07-15 21:40:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"5616 S ROCKWELL ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73179","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-18T10:46:05.000000Z","updated_at":"2025-07-19T10:42:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15036454,"change_date":"2025-07-15 21:40:00","inspection_id":"85221885","insp_unit_id":"207882892","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4","insp_unit_license":"011C80","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC3SM048508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:40.000000Z","updated_at":"2025-07-19T09:45:51.000000Z"}]},{"id":9123150,"change_date":"2025-07-15 21:40:00","inspection_id":"85188475","dot_number":"2561156","report_state":"OK","report_number":"H514154128","insp_date":"2025-07-10 00:00:00","insp_start_time":"0930","insp_end_time":"1007","registration_date":"2025-07-15 00:00:00","region":"CT","ci_status_code":"C","location":"055044","location_desc":"I-44\/ I-35","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"790548","transaction_code":"C","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:04.000000Z","updated_at":"2025-07-19T10:41:43.000000Z","inspection_violations":[{"id":14763655,"change_date":"2025-07-15 21:40:00","inspection_id":"85188475","insp_violation_id":"267418664","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207882913","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:08.000000Z","updated_at":"2025-07-18T10:48:08.000000Z","normalized_code":"3922SLLSR"},{"id":14763656,"change_date":"2025-07-15 21:40:00","inspection_id":"85188475","insp_violation_id":"267418665","seq_no":"2","part_no":"390","part_no_section":"21TE-LCMVINFO","insp_viol_unit":"1","insp_unit_id":"207882913","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:08.000000Z","updated_at":"2025-07-18T10:48:08.000000Z","normalized_code":"39021TELCMVINFO"}],"inspection_per_units":[{"id":15028307,"change_date":"2025-07-15 21:40:00","inspection_id":"85188475","insp_unit_id":"207882913","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"QKL652","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2GR3GC1SM048507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:35.000000Z","updated_at":"2025-07-19T09:45:24.000000Z"}]},{"id":9051400,"change_date":"2025-07-15 21:40:00","inspection_id":"85112771","dot_number":"2561156","report_state":"OK","report_number":"X900201494","insp_date":"2025-07-02 00:00:00","insp_start_time":"1300","insp_end_time":"1325","registration_date":"2025-07-15 00:00:00","region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT N\/B BRITTON TOLL PLAZA","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"EMPTY","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"789992","transaction_code":"C","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":null,"census_search_date":"2025-07-02 21:40:00","snet_input_date":"2025-07-02 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-07-02 21:40:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:23.000000Z","updated_at":"2025-07-19T10:41:43.000000Z","inspection_violations":[{"id":14762887,"change_date":"2025-07-15 21:40:00","inspection_id":"85112771","insp_violation_id":"267418469","seq_no":"1","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"207882755","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:07.000000Z","updated_at":"2025-07-18T10:48:07.000000Z","normalized_code":"39311A1LIL"}],"inspection_per_units":[{"id":15027867,"change_date":"2025-07-15 21:40:00","inspection_id":"85112771","insp_unit_id":"207882755","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"6","insp_unit_license":"V95565","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX13CXGM035316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:35.000000Z","updated_at":"2025-07-19T09:45:22.000000Z"}]},{"id":8701702,"change_date":"2025-06-12 21:41:00","inspection_id":"84742627","dot_number":"2561156","report_state":"OK","report_number":"K200182500","insp_date":"2025-05-21 00:00:00","insp_start_time":"1015","insp_end_time":"1055","registration_date":"2025-06-12 00:00:00","region":"CT","ci_status_code":"C","location":"055KTP","location_desc":"KILPATRICK TURNPIKE \/ SANTA FE","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":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":"2025-05-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"5","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"786008","transaction_code":"C","transaction_date":"2025-05-21 00:00:00","upload_date":"2025-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2025-05-21 21:42:00","snet_input_date":"2025-05-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-24T10:04:21.000000Z","updated_at":"2025-06-16T10:00:23.000000Z","inspection_violations":[{"id":14234735,"change_date":"2025-06-12 21:41:00","inspection_id":"84742627","insp_violation_id":"266811145","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"207356097","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-17T10:17:06.000000Z","updated_at":"2025-06-17T10:18:57.000000Z","normalized_code":"39378AWS"},{"id":14234736,"change_date":"2025-06-12 21:41:00","inspection_id":"84742627","insp_violation_id":"266811146","seq_no":"2","part_no":"393","part_no_section":"55C1-B","insp_viol_unit":"1","insp_unit_id":"207356097","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-17T10:17:06.000000Z","updated_at":"2025-06-17T10:18:57.000000Z","normalized_code":"39355C1B"},{"id":14234737,"change_date":"2025-06-12 21:41:00","inspection_id":"84742627","insp_violation_id":"266811147","seq_no":"3","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":"2025-06-17T10:17:06.000000Z","updated_at":"2025-06-17T10:18:57.000000Z","normalized_code":"3922SLLEWA1"},{"id":14234738,"change_date":"2025-06-12 21:41:00","inspection_id":"84742627","insp_violation_id":"266811148","seq_no":"4","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":"2025-06-17T10:17:06.000000Z","updated_at":"2025-06-17T10:18:57.000000Z","normalized_code":"3922SLLEWA1"},{"id":14234739,"change_date":"2025-06-12 21:41:00","inspection_id":"84742627","insp_violation_id":"266811149","seq_no":"5","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"P083870","created_at":"2025-06-17T10:17:06.000000Z","updated_at":"2025-06-17T10:18:57.000000Z","normalized_code":"3922SLLEWA3"}],"inspection_per_units":[{"id":14546792,"change_date":"2025-06-12 21:41:00","inspection_id":"84742627","insp_unit_id":"207356097","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"V96526","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C5EM020840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-15T09:46:27.000000Z","updated_at":"2025-06-16T09:45:32.000000Z"}]},{"id":8256068,"change_date":"2025-03-31 21:40:00","inspection_id":"84273356","dot_number":"2561156","report_state":"OK","report_number":"X900201286","insp_date":"2025-03-31 00:00:00","insp_start_time":"1230","insp_end_time":"1310","registration_date":null,"region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT N\/B SW 29TH ST","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"BUTLER","shipping_paper_number":"M\/C","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":"2025-03-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"780293","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":"02561156","upload_search_indicator":"M","census_search_date":"2025-03-31 21:40:00","snet_input_date":"2025-03-31 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-03-31 21:40:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-03T10:04:29.000000Z","updated_at":"2025-04-04T10:19:03.000000Z","inspection_violations":[{"id":12966430,"change_date":"2025-03-31 21:40:00","inspection_id":"84273356","insp_violation_id":"265354460","seq_no":"1","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"206081223","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:48.000000Z","normalized_code":"3922SLLMF"},{"id":12966431,"change_date":"2025-03-31 21:40:00","inspection_id":"84273356","insp_violation_id":"265354461","seq_no":"2","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":"2025-04-03T10:26:30.000000Z","updated_at":"2025-04-04T10:38:48.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":13360366,"change_date":"2025-03-31 21:40:00","inspection_id":"84273356","insp_unit_id":"206081223","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"62C536","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDLU0X06J154819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-03T09:57:51.000000Z","updated_at":"2025-04-04T10:00:01.000000Z"}]},{"id":8155211,"change_date":"2025-03-19 21:41:00","inspection_id":"84167087","dot_number":"2561156","report_state":"OK","report_number":"H514153961","insp_date":"2025-03-19 00:00:00","insp_start_time":"0905","insp_end_time":"0921","registration_date":null,"region":"CT","ci_status_code":"C","location":"055044","location_desc":"KILPATRICK TURNPIKE \/ ROCKWELL","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-19 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":"779131","transaction_code":"A","transaction_date":"2025-03-19 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2025-03-19 21:41:00","snet_input_date":"2025-03-19 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-03-19 21:41:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-22T10:33:44.000000Z","updated_at":"2025-03-23T10:48:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13175054,"change_date":"2025-03-19 21:41:00","inspection_id":"84167087","insp_unit_id":"205878861","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"V96526","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C5EM020840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:05:38.000000Z","updated_at":"2025-03-23T10:01:26.000000Z"}]},{"id":8154969,"change_date":"2025-03-19 21:41:00","inspection_id":"84166832","dot_number":"2561156","report_state":"OK","report_number":"D900000453","insp_date":"2025-03-17 00:00:00","insp_start_time":"1448","insp_end_time":"1504","registration_date":null,"region":"CT","ci_status_code":"C","location":"05544","location_desc":"KILP TP WB & ROCKWELL AVE","county_code_state":"OK","county_code":"001","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"778837","transaction_code":"A","transaction_date":"2025-03-17 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":null,"census_search_date":"2025-03-19 21:41:00","snet_input_date":"2025-03-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-03-19 21:41:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-22T10:33:43.000000Z","updated_at":"2025-03-23T10:47:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13174691,"change_date":"2025-03-19 21:41:00","inspection_id":"84166832","insp_unit_id":"205878364","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"3","insp_unit_license":"V96525","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C2EM019080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:05:37.000000Z","updated_at":"2025-03-23T10:01:02.000000Z"}]},{"id":8096416,"change_date":"2025-03-20 21:42:00","inspection_id":"84105198","dot_number":"2561156","report_state":"OK","report_number":"X900201250","insp_date":"2025-03-12 00:00:00","insp_start_time":"1315","insp_end_time":"1335","registration_date":"2025-03-19 00:00:00","region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT S\/B BRITTON TOLL PLAZA","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"M\/C","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"778444","transaction_code":"C","transaction_date":"2025-03-12 00:00:00","upload_date":"2025-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2025-03-12 21:40:00","snet_input_date":"2025-03-12 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-03-12 21:40:00","insp_carrier_name":"TEXOMA SAND LLC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:19.000000Z","updated_at":"2025-03-24T10:25:30.000000Z","inspection_violations":[{"id":12794392,"change_date":"2025-03-20 21:42:00","inspection_id":"84105198","insp_violation_id":"265160107","seq_no":"1","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"205907295","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:07:15.000000Z","updated_at":"2025-03-23T11:38:19.000000Z","normalized_code":"39311A1LIL"},{"id":12794393,"change_date":"2025-03-20 21:42:00","inspection_id":"84105198","insp_violation_id":"265160108","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"205907295","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:07:15.000000Z","updated_at":"2025-03-23T11:38:19.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":13199109,"change_date":"2025-03-20 21:42:00","inspection_id":"84105198","insp_unit_id":"205907295","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"3","insp_unit_license":"V96525","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C2EM019080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:14:33.000000Z","updated_at":"2025-03-24T10:01:27.000000Z"}]},{"id":8034178,"change_date":"2025-03-13 21:44:00","inspection_id":"84039732","dot_number":"2561156","report_state":"OK","report_number":"H514153932","insp_date":"2025-03-05 00:00:00","insp_start_time":"1020","insp_end_time":"1108","registration_date":"2025-03-13 00:00:00","region":"CT","ci_status_code":"C","location":"055044","location_desc":"KILPATRICK TURNPIKE \/ ROCKWELL","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":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"777618","transaction_code":"C","transaction_date":"2025-03-05 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2025-03-05 21:40:00","snet_input_date":"2025-03-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:58.000000Z","updated_at":"2025-03-17T21:04:58.000000Z","inspection_violations":[{"id":12555120,"change_date":"2025-03-13 21:44:00","inspection_id":"84039732","insp_violation_id":"265024912","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"205789418","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"3965BL"},{"id":12555121,"change_date":"2025-03-13 21:44:00","inspection_id":"84039732","insp_violation_id":"265024913","seq_no":"2","part_no":"396","part_no_section":"3A1-OAL","insp_viol_unit":"1","insp_unit_id":"205789418","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"3963A1OAL"},{"id":12555122,"change_date":"2025-03-13 21:44:00","inspection_id":"84039732","insp_violation_id":"265024914","seq_no":"3","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"205789418","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"39378AWS"},{"id":12555123,"change_date":"2025-03-13 21:44:00","inspection_id":"84039732","insp_violation_id":"265024915","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"205789418","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:22.000000Z","updated_at":"2025-03-17T22:07:22.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":12970523,"change_date":"2025-03-13 21:44:00","inspection_id":"84039732","insp_unit_id":"205789418","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"62C536","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDLU0X06J154819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:18.000000Z","updated_at":"2025-03-17T23:58:18.000000Z"}]},{"id":8022630,"change_date":"2025-03-13 21:44:00","inspection_id":"84027464","dot_number":"2561156","report_state":"OK","report_number":"D900000435","insp_date":"2025-03-03 00:00:00","insp_start_time":"1134","insp_end_time":"1209","registration_date":"2025-03-13 00:00:00","region":"CT","ci_status_code":"C","location":"055344","location_desc":"KILP TP WB & SANTA FE","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":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"777492","transaction_code":"C","transaction_date":"2025-03-04 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2025-03-04 21:39:00","snet_input_date":"2025-03-03 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-03-04 21:39:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:54.000000Z","updated_at":"2025-03-17T21:04:54.000000Z","inspection_violations":[{"id":12536224,"change_date":"2025-03-13 21:44:00","inspection_id":"84027464","insp_violation_id":"265024895","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"P057461","created_at":"2025-03-17T22:07:16.000000Z","updated_at":"2025-03-17T22:07:16.000000Z","normalized_code":"3922SLLEWG3"},{"id":12536225,"change_date":"2025-03-13 21:44:00","inspection_id":"84027464","insp_violation_id":"265024896","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"P057462","created_at":"2025-03-17T22:07:16.000000Z","updated_at":"2025-03-17T22:07:16.000000Z","normalized_code":"3922SLLEWA3"},{"id":12536226,"change_date":"2025-03-13 21:44:00","inspection_id":"84027464","insp_violation_id":"265024897","seq_no":"3","part_no":"392","part_no_section":"9A-DFSL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"55","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:16.000000Z","updated_at":"2025-03-17T22:07:16.000000Z","normalized_code":"3929ADFSL"}],"inspection_per_units":[{"id":12951894,"change_date":"2025-03-13 21:44:00","inspection_id":"84027464","insp_unit_id":"205789411","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"#2","insp_unit_license":"V96526","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C5EM020840","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":7944627,"change_date":"2025-03-13 21:44:00","inspection_id":"83945713","dot_number":"2561156","report_state":"OK","report_number":"D900000422","insp_date":"2025-02-24 00:00:00","insp_start_time":"0833","insp_end_time":"0905","registration_date":"2025-03-13 00:00:00","region":"CT","ci_status_code":"C","location":"055CTY","location_desc":"SH 74 NB & NW 164TH","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":"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-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"776690","transaction_code":"C","transaction_date":"2025-02-24 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2025-02-24 21:40:00","snet_input_date":"2025-02-24 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-02-24 21:40:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:14.000000Z","updated_at":"2025-03-17T21:03:14.000000Z","inspection_violations":[{"id":12412579,"change_date":"2025-03-13 21:44:00","inspection_id":"83945713","insp_violation_id":"265024892","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"205789410","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"3965BL"},{"id":12412580,"change_date":"2025-03-13 21:44:00","inspection_id":"83945713","insp_violation_id":"265024893","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"205789410","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39378AWS"},{"id":12412581,"change_date":"2025-03-13 21:44:00","inspection_id":"83945713","insp_violation_id":"265024894","seq_no":"3","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"205789410","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39311A1CSURR"}],"inspection_per_units":[{"id":12824843,"change_date":"2025-03-13 21:44:00","inspection_id":"83945713","insp_unit_id":"205789410","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"62C536","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDLU0X06J154819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:39.000000Z","updated_at":"2025-03-17T23:56:39.000000Z"}]},{"id":7302495,"change_date":"2024-12-09 21:41:00","inspection_id":"83271237","dot_number":"2561156","report_state":"OK","report_number":"D900000293","insp_date":"2024-11-25 00:00:00","insp_start_time":"0830","insp_end_time":"0920","registration_date":"2024-12-09 00:00:00","region":"CT","ci_status_code":"C","location":"05544","location_desc":"KILP TP WB & WESTERN AVE","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":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-29 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"3","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"769066","transaction_code":"C","transaction_date":"2024-11-29 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2024-11-29 21:34:00","snet_input_date":"2024-11-25 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-11-29 21:34:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:32.000000Z","updated_at":"2025-03-17T20:48:32.000000Z","inspection_violations":[{"id":11419053,"change_date":"2024-12-09 21:41:00","inspection_id":"83271237","insp_violation_id":"263329502","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"204268986","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"39375A3TAOL"},{"id":11419054,"change_date":"2024-12-09 21:41:00","inspection_id":"83271237","insp_violation_id":"263329503","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"204268986","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"39375A3TAOL"},{"id":11419055,"change_date":"2024-12-09 21:41:00","inspection_id":"83271237","insp_violation_id":"263329504","seq_no":"3","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":"2025-03-17T22:01:28.000000Z","updated_at":"2025-03-17T22:01:28.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":11779782,"change_date":"2024-12-09 21:41:00","inspection_id":"83271237","insp_unit_id":"204268986","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"6","insp_unit_license":"V95565","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX13CXGM035316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:04.000000Z","updated_at":"2025-03-17T23:45:04.000000Z"}]},{"id":7081946,"change_date":"2024-11-13 21:40:00","inspection_id":"83037725","dot_number":"2561156","report_state":"OK","report_number":"X200172244","insp_date":"2024-10-30 00:00:00","insp_start_time":"1238","insp_end_time":"1257","registration_date":"2024-11-13 00:00:00","region":"CT","ci_status_code":"C","location":"55074","location_desc":"SH74\/178TH","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":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-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"766191","transaction_code":"C","transaction_date":"2024-10-30 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2024-10-30 21:40:00","snet_input_date":"2024-10-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-10-30 21:40:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:49.000000Z","updated_at":"2025-03-17T20:43:49.000000Z","inspection_violations":[{"id":11055848,"change_date":"2024-11-13 21:40:00","inspection_id":"83037725","insp_violation_id":"262873584","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"203862069","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:37.000000Z","updated_at":"2025-03-17T21:59:37.000000Z","normalized_code":"39395A1"},{"id":11055849,"change_date":"2024-11-13 21:40:00","inspection_id":"83037725","insp_violation_id":"262873585","seq_no":"2","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"203862069","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:37.000000Z","updated_at":"2025-03-17T21:59:37.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":11421495,"change_date":"2024-11-13 21:40:00","inspection_id":"83037725","insp_unit_id":"203862069","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"62C536","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDLU0X06J154819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:17.000000Z","updated_at":"2025-03-17T23:41:17.000000Z"}]},{"id":7081977,"change_date":"2024-10-30 21:40:00","inspection_id":"83037757","dot_number":"2561156","report_state":"OK","report_number":"X900201004","insp_date":"2024-10-29 00:00:00","insp_start_time":"0633","insp_end_time":"0705","registration_date":null,"region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT S\/B BRITTON TOLL PLAZA","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"EMPTY","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"766112","transaction_code":"A","transaction_date":"2024-10-30 00:00:00","upload_date":"2024-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2024-10-30 21:40:00","snet_input_date":"2024-10-29 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-10-30 21:40:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:49.000000Z","updated_at":"2025-03-17T20:43:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11421548,"change_date":"2024-10-30 21:40:00","inspection_id":"83037757","insp_unit_id":"203657780","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2","insp_unit_license":"V96526","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C5EM020840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:17.000000Z","updated_at":"2025-03-17T23:41:17.000000Z"}]},{"id":6873302,"change_date":"2024-10-02 21:41:00","inspection_id":"82816075","dot_number":"2561156","report_state":"OK","report_number":"K200182148","insp_date":"2024-10-02 00:00:00","insp_start_time":"0840","insp_end_time":"0905","registration_date":null,"region":"CT","ci_status_code":"C","location":"055035","location_desc":"INTERSTATE 35 NB \/ I-44","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-02 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":"763406","transaction_code":"A","transaction_date":"2024-10-02 00:00:00","upload_date":"2024-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":null,"census_search_date":"2024-10-02 21:41:00","snet_input_date":"2024-10-02 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-10-02 21:41:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:26.000000Z","updated_at":"2025-03-17T20:39:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11084701,"change_date":"2024-10-02 21:41:00","inspection_id":"82816075","insp_unit_id":"203236748","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"62C536","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDLU0X06J154819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:46.000000Z","updated_at":"2025-03-17T23:37:46.000000Z"}]},{"id":6779558,"change_date":"2024-09-20 21:42:00","inspection_id":"82716364","dot_number":"2561156","report_state":"OK","report_number":"I104153210","insp_date":"2024-09-20 00:00:00","insp_start_time":"0619","insp_end_time":"0637","registration_date":null,"region":"CT","ci_status_code":"C","location":"550CS","location_desc":"SE 134 AND I-44","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":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-09-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"761979","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2024-09-20 21:42:00","snet_input_date":"2024-09-20 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-09-20 21:42:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:23.000000Z","updated_at":"2025-03-17T20:37:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10932496,"change_date":"2024-09-20 21:42:00","inspection_id":"82716364","insp_unit_id":"203050423","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2","insp_unit_license":"V96526","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C5EM020840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:15.000000Z","updated_at":"2025-03-17T23:36:15.000000Z"}]},{"id":6689460,"change_date":"2024-09-10 21:39:00","inspection_id":"82620416","dot_number":"2561156","report_state":"OK","report_number":"X200172153","insp_date":"2024-09-09 00:00:00","insp_start_time":"1648","insp_end_time":"1706","registration_date":null,"region":"CT","ci_status_code":"C","location":"42074","location_desc":"SH74\/WATERLOO","county_code_state":"OK","county_code":"083","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":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"760750","transaction_code":"A","transaction_date":"2024-09-09 00:00:00","upload_date":"2024-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":null,"census_search_date":"2024-09-10 21:39:00","snet_input_date":"2024-09-09 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-09-10 21:39:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:39.000000Z","updated_at":"2025-03-17T20:35:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10786002,"change_date":"2024-09-10 21:39:00","inspection_id":"82620416","insp_unit_id":"202845625","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"62C536","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDLU0X06J154819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:41.000000Z","updated_at":"2025-03-17T23:34:41.000000Z"}]},{"id":6596914,"change_date":"2024-08-29 21:43:00","inspection_id":"82522053","dot_number":"2561156","report_state":"OK","report_number":"X900200898","insp_date":"2024-08-28 00:00:00","insp_start_time":"0731","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT S\/B BRITTON TOLL PLAZA","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"GENERAL MATERIALS","shipping_paper_number":"859146","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-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"759407","transaction_code":"A","transaction_date":"2024-08-28 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":null,"census_search_date":"2024-08-29 21:43:00","snet_input_date":"2024-08-28 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-08-29 21:43:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:42.000000Z","updated_at":"2025-03-17T20:33:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10635453,"change_date":"2024-08-29 21:43:00","inspection_id":"82522053","insp_unit_id":"202655139","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2","insp_unit_license":"V96526","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C5EM020840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:10.000000Z","updated_at":"2025-03-17T23:33:10.000000Z"}]},{"id":6596639,"change_date":"2024-11-14 21:41:00","inspection_id":"82521764","dot_number":"2561156","report_state":"OK","report_number":"D900000209","insp_date":"2024-08-27 00:00:00","insp_start_time":"1518","insp_end_time":"1550","registration_date":"2024-11-14 00:00:00","region":"CT","ci_status_code":"C","location":"055152","location_desc":"SH 152 & SW 59TH","county_code_state":"OK","county_code":"109","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-08-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"759352","transaction_code":"C","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":null,"census_search_date":"2024-08-29 21:43:00","snet_input_date":"2024-08-27 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-08-29 21:43:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:42.000000Z","updated_at":"2025-03-17T20:33:42.000000Z","inspection_violations":[{"id":10258505,"change_date":"2024-11-14 21:41:00","inspection_id":"82521764","insp_violation_id":"262894029","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"203879716","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"3939"},{"id":10258506,"change_date":"2024-11-14 21:41:00","inspection_id":"82521764","insp_violation_id":"262894030","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"203879716","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"39395A"},{"id":10258507,"change_date":"2024-11-14 21:41:00","inspection_id":"82521764","insp_violation_id":"262894031","seq_no":"3","part_no":"393","part_no_section":"203C","insp_viol_unit":"1","insp_unit_id":"203879716","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"393203C"},{"id":10258508,"change_date":"2024-11-14 21:41:00","inspection_id":"82521764","insp_violation_id":"262894032","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"203879716","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"39617C"},{"id":10258509,"change_date":"2024-11-14 21:41:00","inspection_id":"82521764","insp_violation_id":"262894033","seq_no":"5","part_no":"392","part_no_section":"2IN","insp_viol_unit":"1","insp_unit_id":"203879716","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"3922IN"}],"inspection_per_units":[{"id":10635004,"change_date":"2024-11-14 21:41:00","inspection_id":"82521764","insp_unit_id":"203879716","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"6","insp_unit_license":"V95565","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX13CXGM035316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:10.000000Z","updated_at":"2025-03-17T23:33:10.000000Z"}]},{"id":6334882,"change_date":"2024-07-29 21:42:00","inspection_id":"82242172","dot_number":"2561156","report_state":"OK","report_number":"U200164283","insp_date":"2024-07-29 00:00:00","insp_start_time":"0735","insp_end_time":"0748","registration_date":null,"region":"CT","ci_status_code":"C","location":"055CIS","location_desc":"SOONER\/122ND","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","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-07-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"756078","transaction_code":"A","transaction_date":"2024-07-29 00:00:00","upload_date":"2024-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2024-07-29 21:42:00","snet_input_date":"2024-07-29 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-07-29 21:42:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:17.000000Z","updated_at":"2025-03-17T20:28:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10207838,"change_date":"2024-07-29 21:42:00","inspection_id":"82242172","insp_unit_id":"202122513","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"3","insp_unit_license":"V96525","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C2EM019080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:43.000000Z","updated_at":"2025-03-17T23:28:43.000000Z"}]},{"id":6148456,"change_date":"2024-07-04 21:33:00","inspection_id":"82042221","dot_number":"2561156","report_state":"OK","report_number":"K200181990","insp_date":"2024-07-02 00:00:00","insp_start_time":"0705","insp_end_time":"0718","registration_date":null,"region":"CT","ci_status_code":"C","location":"055CTY","location_desc":"SOONER RD \/ TURNER TURNPIKE","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"GENERAL MATERIALS","shipping_paper_number":"856881","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-04 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"752866","transaction_code":"A","transaction_date":"2024-07-02 00:00:00","upload_date":"2024-07-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":null,"census_search_date":"2024-07-04 21:33:00","snet_input_date":"2024-07-02 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-07-04 21:33:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:36.000000Z","updated_at":"2025-03-17T20:24:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9903954,"change_date":"2024-07-04 21:33:00","inspection_id":"82042221","insp_unit_id":"201738561","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"V96525","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C2EM019080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:39.000000Z","updated_at":"2025-03-17T23:25:39.000000Z"}]},{"id":5885276,"change_date":"2024-06-06 21:41:00","inspection_id":"81757538","dot_number":"2561156","report_state":"OK","report_number":"X200172114","insp_date":"2024-05-31 00:00:00","insp_start_time":"0756","insp_end_time":"0820","registration_date":"2024-06-06 00:00:00","region":"CT","ci_status_code":"C","location":"42033","location_desc":"SH33\/SH74","county_code_state":"OK","county_code":"083","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":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"749549","transaction_code":"C","transaction_date":"2024-05-31 00:00:00","upload_date":"2024-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2024-05-31 21:39:00","snet_input_date":"2024-05-31 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-05-31 21:39:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:26.000000Z","updated_at":"2025-03-17T20:19:26.000000Z","inspection_violations":[{"id":9124197,"change_date":"2024-06-06 21:41:00","inspection_id":"81757538","insp_violation_id":"259940883","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"201266884","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:07.000000Z","updated_at":"2025-03-17T21:50:07.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":9478889,"change_date":"2024-06-06 21:41:00","inspection_id":"81757538","insp_unit_id":"201266884","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"6","insp_unit_license":"V95565","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX13CXGM035316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:19.000000Z","updated_at":"2025-03-17T23:21:19.000000Z"}]},{"id":5305929,"change_date":"2024-04-02 21:42:00","inspection_id":"81127121","dot_number":"2561156","report_state":"OK","report_number":"X200171953","insp_date":"2024-03-18 00:00:00","insp_start_time":"1246","insp_end_time":"1332","registration_date":"2024-04-02 00:00:00","region":"CT","ci_status_code":"C","location":"42074","location_desc":"SH74\/WATERLOO","county_code_state":"OK","county_code":"083","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"32714","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-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"740855","transaction_code":"C","transaction_date":"2024-03-18 00:00:00","upload_date":"2024-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2024-03-18 21:38:00","snet_input_date":"2024-03-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-03-18 21:38:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:52.000000Z","updated_at":"2025-03-17T20:07:52.000000Z","inspection_violations":[{"id":8182398,"change_date":"2024-04-02 21:42:00","inspection_id":"81127121","insp_violation_id":"258703879","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":"N497782","created_at":"2025-03-17T21:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"3922"},{"id":8182399,"change_date":"2024-04-02 21:42:00","inspection_id":"81127121","insp_violation_id":"258703880","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:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"3922"},{"id":8182400,"change_date":"2024-04-02 21:42:00","inspection_id":"81127121","insp_violation_id":"258703881","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:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8544850,"change_date":"2024-04-02 21:42:00","inspection_id":"81127121","insp_unit_id":"200197309","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"3","insp_unit_license":"V96525","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C2EM019080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:25.000000Z","updated_at":"2025-03-17T23:12:25.000000Z"}]},{"id":5296512,"change_date":"2024-03-29 21:38:00","inspection_id":"81116837","dot_number":"2561156","report_state":"OK","report_number":"U200163992","insp_date":"2024-03-15 00:00:00","insp_start_time":"0738","insp_end_time":"0759","registration_date":"2024-03-29 00:00:00","region":"CT","ci_status_code":"C","location":"042CYR","location_desc":"SH74\/WATERLOO","county_code_state":"OK","county_code":"083","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"32539","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-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"740658","transaction_code":"C","transaction_date":"2024-03-15 00:00:00","upload_date":"2024-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2024-03-15 21:40:00","snet_input_date":"2024-03-15 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-03-15 21:40:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:31.000000Z","updated_at":"2025-03-17T20:07:31.000000Z","inspection_violations":[{"id":8167995,"change_date":"2024-03-29 21:38:00","inspection_id":"81116837","insp_violation_id":"258655970","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:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8529445,"change_date":"2024-03-29 21:38:00","inspection_id":"81116837","insp_unit_id":"200155472","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"V95565","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX13CXGM035316","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":5135716,"change_date":"2024-02-26 21:42:00","inspection_id":"80941647","dot_number":"2561156","report_state":"OK","report_number":"H514159788","insp_date":"2024-02-26 00:00:00","insp_start_time":"0845","insp_end_time":"0912","registration_date":null,"region":"CT","ci_status_code":"C","location":"420CTY","location_desc":"BROADWAY\/ SEWARD","county_code_state":"OK","county_code":"083","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"738785","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":"02561156","upload_search_indicator":"M","census_search_date":"2024-02-26 21:42:00","snet_input_date":"2024-02-26 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-02-26 21:42:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:14.000000Z","updated_at":"2025-03-17T20:04:14.000000Z","inspection_violations":[{"id":7918567,"change_date":"2024-02-26 21:42:00","inspection_id":"80941647","insp_violation_id":"258035642","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199599783","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:14.000000Z","updated_at":"2025-03-17T21:44:14.000000Z","normalized_code":"3922"},{"id":7918568,"change_date":"2024-02-26 21:42:00","inspection_id":"80941647","insp_violation_id":"258035643","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199599783","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:14.000000Z","updated_at":"2025-03-17T21:44:14.000000Z","normalized_code":"3922"},{"id":7918569,"change_date":"2024-02-26 21:42:00","inspection_id":"80941647","insp_violation_id":"258035644","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:14.000000Z","updated_at":"2025-03-17T21:44:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8268574,"change_date":"2024-02-26 21:42:00","inspection_id":"80941647","insp_unit_id":"199599783","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"V95565","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX13CXGM035316","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":5135771,"change_date":"2024-03-06 21:40:00","inspection_id":"80941711","dot_number":"2561156","report_state":"OK","report_number":"K200189813","insp_date":"2024-02-26 00:00:00","insp_start_time":"0958","insp_end_time":"1020","registration_date":"2024-03-06 00:00:00","region":"CT","ci_status_code":"C","location":"009JKT","location_desc":"KILPATRICK TP NB \/ WILSHIRE","county_code_state":"OK","county_code":"017","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"BUTLER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"738700","transaction_code":"C","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2024-02-26 21:42:00","snet_input_date":"2024-02-26 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-02-26 21:42:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:14.000000Z","updated_at":"2025-03-17T20:04:14.000000Z","inspection_violations":[{"id":7918648,"change_date":"2024-03-06 21:40:00","inspection_id":"80941711","insp_violation_id":"258236091","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:14.000000Z","updated_at":"2025-03-17T21:44:14.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":8268662,"change_date":"2024-03-06 21:40:00","inspection_id":"80941711","insp_unit_id":"199785002","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"V96526","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C5EM020840","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":4755479,"change_date":"2024-01-03 21:44:00","inspection_id":"80525770","dot_number":"2561156","report_state":"OK","report_number":"H514153368","insp_date":"2024-01-02 00:00:00","insp_start_time":"1337","insp_end_time":"1355","registration_date":null,"region":"CT","ci_status_code":"C","location":"55CTY","location_desc":"BROADWAY\/ COFFEE CREEK","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-03 21:44: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":"733581","transaction_code":"A","transaction_date":"2024-01-03 00:00:00","upload_date":"2024-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2024-01-03 21:44:00","snet_input_date":"2024-01-02 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-01-03 21:44:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14550 S PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025-1676","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:55.000000Z","updated_at":"2025-03-17T19:56:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7650177,"change_date":"2024-01-03 21:44:00","inspection_id":"80525770","insp_unit_id":"198792745","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"V96525","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C2EM019080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:24.000000Z","updated_at":"2025-03-17T23:04:24.000000Z"}]},{"id":4080749,"change_date":"2023-12-20 21:42:00","inspection_id":"79782673","dot_number":"2561156","report_state":"OK","report_number":"X200171662","insp_date":"2023-09-28 00:00:00","insp_start_time":"1258","insp_end_time":"1338","registration_date":"2023-12-06 00:00:00","region":"CT","ci_status_code":"C","location":"42074","location_desc":"SH33\/SH74","county_code_state":"OK","county_code":"083","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"25423","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-09-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"724078","transaction_code":"C","transaction_date":"2023-09-28 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2023-09-28 21:40:00","snet_input_date":"2023-09-28 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-09-28 21:40:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:35.000000Z","updated_at":"2025-03-17T19:43:35.000000Z","inspection_violations":[{"id":6316491,"change_date":"2023-12-20 21:42:00","inspection_id":"79782673","insp_violation_id":"256989481","seq_no":"1","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"198601392","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:27.000000Z","updated_at":"2025-03-17T21:36:27.000000Z","normalized_code":"393209E"},{"id":6316492,"change_date":"2023-12-20 21:42:00","inspection_id":"79782673","insp_violation_id":"256989482","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198601392","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:36:27.000000Z","updated_at":"2025-03-17T21:36:27.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":6560794,"change_date":"2023-12-20 21:42:00","inspection_id":"79782673","insp_unit_id":"198601392","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"V13208","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDLU0X06J154819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:04.000000Z","updated_at":"2025-03-17T22:55:04.000000Z"}]},{"id":4060600,"change_date":"2023-09-26 21:43:00","inspection_id":"79760139","dot_number":"2561156","report_state":"OK","report_number":"X900200216","insp_date":"2023-09-20 00:00:00","insp_start_time":"0700","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT S\/B WILSHIRE BLVD EXIT","county_code_state":"OK","county_code":"017","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"M\/C","shipping_paper_number":"M\/C","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-09-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"723464","transaction_code":"A","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2023-09-26 21:43:00","snet_input_date":"2023-09-20 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-09-26 21:43:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:09.000000Z","updated_at":"2025-03-17T19:43:09.000000Z","inspection_violations":[{"id":6286194,"change_date":"2023-09-26 21:43:00","inspection_id":"79760139","insp_violation_id":"255493305","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197247023","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:20.000000Z","updated_at":"2025-03-17T21:36:20.000000Z","normalized_code":"39347E"},{"id":6286195,"change_date":"2023-09-26 21:43:00","inspection_id":"79760139","insp_violation_id":"255493306","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197247023","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:20.000000Z","updated_at":"2025-03-17T21:36:20.000000Z","normalized_code":"39353B"},{"id":6286196,"change_date":"2023-09-26 21:43:00","inspection_id":"79760139","insp_violation_id":"255493307","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197247023","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:20.000000Z","updated_at":"2025-03-17T21:36:20.000000Z","normalized_code":"39347E"},{"id":6286197,"change_date":"2023-09-26 21:43:00","inspection_id":"79760139","insp_violation_id":"255493308","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197247023","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:20.000000Z","updated_at":"2025-03-17T21:36:20.000000Z","normalized_code":"3963A1"},{"id":6286198,"change_date":"2023-09-26 21:43:00","inspection_id":"79760139","insp_violation_id":"255493309","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197247023","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:20.000000Z","updated_at":"2025-03-17T21:36:20.000000Z","normalized_code":"39311"},{"id":6286199,"change_date":"2023-09-26 21:43:00","inspection_id":"79760139","insp_violation_id":"255493310","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197247023","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:20.000000Z","updated_at":"2025-03-17T21:36:20.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6528629,"change_date":"2023-09-26 21:43:00","inspection_id":"79760139","insp_unit_id":"197247023","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"3","insp_unit_license":"V96525","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C2EM019080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:47.000000Z","updated_at":"2025-03-17T22:54:47.000000Z"}]},{"id":3954068,"change_date":"2024-11-29 21:34:00","inspection_id":"79641781","dot_number":"2561156","report_state":"OK","report_number":"H514153223","insp_date":"2023-09-11 00:00:00","insp_start_time":"1015","insp_end_time":"1030","registration_date":"2024-11-27 00:00:00","region":"CT","ci_status_code":"C","location":"055035","location_desc":"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":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-09-12 21:39: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":"722268","transaction_code":"C","transaction_date":"2023-09-12 00:00:00","upload_date":"2024-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2023-09-12 21:39:00","snet_input_date":"2023-09-11 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-09-12 21:39:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:51.000000Z","updated_at":"2025-03-17T19:40:51.000000Z","inspection_violations":[{"id":6113523,"change_date":"2024-11-29 21:34:00","inspection_id":"79641781","insp_violation_id":"263145049","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204103122","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":6357749,"change_date":"2024-11-29 21:34:00","inspection_id":"79641781","insp_unit_id":"204103122","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"V13208","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDLU0X06J154819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:24.000000Z","updated_at":"2025-03-17T22:53:24.000000Z"}]},{"id":3923885,"change_date":"2023-11-27 21:41:00","inspection_id":"79608223","dot_number":"2561156","report_state":"OK","report_number":"C106153690","insp_date":"2023-09-07 00:00:00","insp_start_time":"1125","insp_end_time":"1233","registration_date":"2023-11-21 00:00:00","region":"CT","ci_status_code":"C","location":"14035","location_desc":"MOORE","county_code_state":"OK","county_code":"027","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"721851","transaction_code":"C","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2023-09-07 21:40:00","snet_input_date":"2023-09-07 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-09-07 21:40:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:26.000000Z","updated_at":"2025-03-17T19:40:26.000000Z","inspection_violations":[{"id":6064580,"change_date":"2023-11-27 21:41:00","inspection_id":"79608223","insp_violation_id":"256556755","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198208004","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"39347E"},{"id":6064581,"change_date":"2023-11-27 21:41:00","inspection_id":"79608223","insp_violation_id":"256556756","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"198208004","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"39353B"},{"id":6064582,"change_date":"2023-11-27 21:41:00","inspection_id":"79608223","insp_violation_id":"256556757","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198208004","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"39347E"},{"id":6064583,"change_date":"2023-11-27 21:41:00","inspection_id":"79608223","insp_violation_id":"256556758","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198208004","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"3963A1"},{"id":6064584,"change_date":"2023-11-27 21:41:00","inspection_id":"79608223","insp_violation_id":"256556759","seq_no":"5","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"198208004","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"39381"},{"id":6064585,"change_date":"2023-11-27 21:41:00","inspection_id":"79608223","insp_violation_id":"256556760","seq_no":"6","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"198208004","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":6309235,"change_date":"2023-11-27 21:41:00","inspection_id":"79608223","insp_unit_id":"198208004","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"3","insp_unit_license":"V96525","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C2EM019080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:00.000000Z","updated_at":"2025-03-17T22:53:00.000000Z"}]},{"id":3843200,"change_date":"2023-11-14 21:41:00","inspection_id":"79518280","dot_number":"2561156","report_state":"OK","report_number":"U200163838","insp_date":"2023-08-25 00:00:00","insp_start_time":"0635","insp_end_time":"0652","registration_date":"2023-11-14 00:00:00","region":"CT","ci_status_code":"C","location":"055TTP","location_desc":"TTP\/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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"720705","transaction_code":"C","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2023-08-28 21:41:00","snet_input_date":"2023-08-25 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-08-28 21:41:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:54.000000Z","updated_at":"2025-03-17T19:38:54.000000Z","inspection_violations":[{"id":5936347,"change_date":"2023-11-14 21:41:00","inspection_id":"79518280","insp_violation_id":"256386413","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"198054440","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:40.000000Z","updated_at":"2025-03-17T21:34:40.000000Z","normalized_code":"39360C"},{"id":5936348,"change_date":"2023-11-14 21:41:00","inspection_id":"79518280","insp_violation_id":"256386414","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"198054440","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:40.000000Z","updated_at":"2025-03-17T21:34:40.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":6178817,"change_date":"2023-11-14 21:41:00","inspection_id":"79518280","insp_unit_id":"198054440","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"6","insp_unit_license":"V95565","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX13CXGM035316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:54.000000Z","updated_at":"2025-03-17T22:51:54.000000Z"}]},{"id":3733189,"change_date":"2023-08-16 21:39:00","inspection_id":"79395306","dot_number":"2561156","report_state":"OK","report_number":"X900200153","insp_date":"2023-08-11 00:00:00","insp_start_time":"1315","insp_end_time":"1340","registration_date":"2023-08-16 00:00:00","region":"CT","ci_status_code":"C","location":"JKT","location_desc":"JKT WB SH74","county_code_state":"OK","county_code":"017","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"M\/C","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"719312","transaction_code":"C","transaction_date":"2023-08-14 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2023-08-14 21:42:00","snet_input_date":"2023-08-11 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-08-14 21:42:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:31.000000Z","updated_at":"2025-03-17T19:36:31.000000Z","inspection_violations":[{"id":5757242,"change_date":"2023-08-16 21:39:00","inspection_id":"79395306","insp_violation_id":"254684213","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196558613","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"39617C"},{"id":5757243,"change_date":"2023-08-16 21:39:00","inspection_id":"79395306","insp_violation_id":"254684214","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196558613","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"39395A"},{"id":5757244,"change_date":"2023-08-16 21:39:00","inspection_id":"79395306","insp_violation_id":"254684215","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196558613","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"39378"},{"id":5757245,"change_date":"2023-08-16 21:39:00","inspection_id":"79395306","insp_violation_id":"254684216","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196558613","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6002264,"change_date":"2023-08-16 21:39:00","inspection_id":"79395306","insp_unit_id":"196558613","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2","insp_unit_license":"V96526","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C5EM020840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:26.000000Z","updated_at":"2025-03-17T22:50:26.000000Z"}]},{"id":3521528,"change_date":"2023-07-17 21:41:00","inspection_id":"79158210","dot_number":"2561156","report_state":"OK","report_number":"X200171499","insp_date":"2023-07-14 00:00:00","insp_start_time":"1723","insp_end_time":"1750","registration_date":null,"region":"CT","ci_status_code":"C","location":"55074","location_desc":"SH74\/234TH","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":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"716413","transaction_code":"A","transaction_date":"2023-07-17 00:00:00","upload_date":"2023-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2023-07-17 21:41:00","snet_input_date":"2023-07-14 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-07-17 21:41:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:46.000000Z","updated_at":"2025-03-17T19:32:46.000000Z","inspection_violations":[{"id":5429985,"change_date":"2023-07-17 21:41:00","inspection_id":"79158210","insp_violation_id":"254094357","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"196029565","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":5662169,"change_date":"2023-07-17 21:41:00","inspection_id":"79158210","insp_unit_id":"196029565","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"V13208","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDLU0X06J154819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:41.000000Z","updated_at":"2025-03-17T22:47:41.000000Z"}]},{"id":3374184,"change_date":"2023-06-27 21:40:00","inspection_id":"78992593","dot_number":"2561156","report_state":"OK","report_number":"I904155029","insp_date":"2023-06-26 00:00:00","insp_start_time":"1447","insp_end_time":"1505","registration_date":null,"region":"CT","ci_status_code":"C","location":"14044","location_desc":"I-44 N\/B MM 110","county_code_state":"OK","county_code":"027","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"714604","transaction_code":"A","transaction_date":"2023-06-27 00:00:00","upload_date":"2023-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2023-06-27 21:40:00","snet_input_date":"2023-06-26 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-27 21:40:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:47.000000Z","updated_at":"2025-03-17T19:29:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5424076,"change_date":"2023-06-27 21:40:00","inspection_id":"78992593","insp_unit_id":"195694074","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"3","insp_unit_license":"V96525","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C2EM019080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:47.000000Z","updated_at":"2025-03-17T22:45:47.000000Z"}]},{"id":3341971,"change_date":"2023-06-22 21:41:00","inspection_id":"78956496","dot_number":"2561156","report_state":"OK","report_number":"V900171733","insp_date":"2023-06-22 00:00:00","insp_start_time":"0856","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":"26044","location_desc":"I-44 (H.E. BAILEY TURNPIKE) WB","county_code_state":"OK","county_code":"051","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":"2023-06-22 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":"714166","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2023-06-22 21:41:00","snet_input_date":"2023-06-22 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-22 21:41:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:19.000000Z","updated_at":"2025-03-17T19:29:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5372713,"change_date":"2023-06-22 21:41:00","inspection_id":"78956496","insp_unit_id":"195622813","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"V13208","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDLU0X06J154819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:23.000000Z","updated_at":"2025-03-17T22:45:23.000000Z"}]},{"id":3022100,"change_date":"2023-06-06 21:44:00","inspection_id":"78595648","dot_number":"2561156","report_state":"OK","report_number":"H514153096","insp_date":"2023-05-10 00:00:00","insp_start_time":"1110","insp_end_time":"1153","registration_date":"2023-06-06 00:00:00","region":"CT","ci_status_code":"C","location":"055044","location_desc":"KILPATRICK TURNPIKE \/ WESTERN","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":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-05-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"5","oos_total":"2","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"708949","transaction_code":"C","transaction_date":"2023-05-11 00:00:00","upload_date":"2023-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2023-05-11 21:42:00","snet_input_date":"2023-05-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-05-11 21:42:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:58.000000Z","updated_at":"2025-03-17T19:22:58.000000Z","inspection_violations":[{"id":4641263,"change_date":"2023-06-06 21:44:00","inspection_id":"78595648","insp_violation_id":"253317189","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"195342605","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"39375A3"},{"id":4641264,"change_date":"2023-06-06 21:44:00","inspection_id":"78595648","insp_violation_id":"253317190","seq_no":"2","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"195342605","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"39375G"},{"id":4641265,"change_date":"2023-06-06 21:44:00","inspection_id":"78595648","insp_violation_id":"253317191","seq_no":"3","part_no":"387","part_no_section":"303(b)(4)","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:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"387303B4"},{"id":4641266,"change_date":"2023-06-06 21:44:00","inspection_id":"78595648","insp_violation_id":"253317192","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":"N488839","created_at":"2025-03-17T21:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"3922"},{"id":4641267,"change_date":"2023-06-06 21:44:00","inspection_id":"78595648","insp_violation_id":"253317193","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":"N489726","created_at":"2025-03-17T21:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4861821,"change_date":"2023-06-06 21:44:00","inspection_id":"78595648","insp_unit_id":"195342605","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"V13208","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDLU0X06J154819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:19.000000Z","updated_at":"2025-03-17T22:41:19.000000Z"}]},{"id":2542651,"change_date":"2023-03-17 21:42:00","inspection_id":"78051167","dot_number":"2561156","report_state":"OK","report_number":"H514153017","insp_date":"2023-03-08 00:00:00","insp_start_time":"1045","insp_end_time":"1109","registration_date":"2023-03-16 00:00:00","region":"CT","ci_status_code":"C","location":"009003","location_desc":"KILPATRICK TPK \/ 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":"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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"702214","transaction_code":"C","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2023-03-09 21:42:00","snet_input_date":"2023-03-08 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-03-09 21:42:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:40.000000Z","updated_at":"2025-03-17T19:13:40.000000Z","inspection_violations":[{"id":3910414,"change_date":"2023-03-17 21:42:00","inspection_id":"78051167","insp_violation_id":"251725962","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193928816","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3939A"},{"id":3910415,"change_date":"2023-03-17 21:42:00","inspection_id":"78051167","insp_violation_id":"251725963","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193928816","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39378"},{"id":3910416,"change_date":"2023-03-17 21:42:00","inspection_id":"78051167","insp_violation_id":"251725964","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193928816","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3922"},{"id":3910417,"change_date":"2023-03-17 21:42:00","inspection_id":"78051167","insp_violation_id":"251725965","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193928816","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4092417,"change_date":"2023-03-17 21:42:00","inspection_id":"78051167","insp_unit_id":"193928816","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"V95565","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX13CXGM035316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:20.000000Z","updated_at":"2025-03-17T22:35:20.000000Z"}]},{"id":2542647,"change_date":"2023-03-17 21:42:00","inspection_id":"78051162","dot_number":"2561156","report_state":"OK","report_number":"K200181201","insp_date":"2023-03-07 00:00:00","insp_start_time":"0818","insp_end_time":"0855","registration_date":"2023-03-16 00:00:00","region":"CT","ci_status_code":"C","location":"055035","location_desc":"I-35 NB \/ KILPATRICK TURNPIKE","county_code_state":"OK","county_code":"109","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"JR SAND","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"702086","transaction_code":"C","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2023-03-09 21:42:00","snet_input_date":"2023-03-07 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-03-09 21:42:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:40.000000Z","updated_at":"2025-03-17T19:13:40.000000Z","inspection_violations":[{"id":3910405,"change_date":"2023-03-17 21:42:00","inspection_id":"78051162","insp_violation_id":"251726629","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193929334","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39395A"},{"id":3910406,"change_date":"2023-03-17 21:42:00","inspection_id":"78051162","insp_violation_id":"251726630","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193929334","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39378"},{"id":3910407,"change_date":"2023-03-17 21:42:00","inspection_id":"78051162","insp_violation_id":"251726631","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193929334","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39617C"},{"id":3910408,"change_date":"2023-03-17 21:42:00","inspection_id":"78051162","insp_violation_id":"251726632","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:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3922"},{"id":3910409,"change_date":"2023-03-17 21:42:00","inspection_id":"78051162","insp_violation_id":"251726633","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:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3922"},{"id":3910410,"change_date":"2023-03-17 21:42:00","inspection_id":"78051162","insp_violation_id":"251726634","seq_no":"6","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":"N365944","created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4092413,"change_date":"2023-03-17 21:42:00","inspection_id":"78051162","insp_unit_id":"193929334","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"V13208","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1NKDLU0X06J154819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:20.000000Z","updated_at":"2025-03-17T22:35:20.000000Z"}]},{"id":2284815,"change_date":"2023-02-06 21:41:00","inspection_id":"77757550","dot_number":"2561156","report_state":"OK","report_number":"I904154764","insp_date":"2023-02-01 00:00:00","insp_start_time":"1326","insp_end_time":"1348","registration_date":"2023-02-06 00:00:00","region":"CT","ci_status_code":"C","location":"14CRD","location_desc":"SW 149TH & MERIDIAN","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":"371681","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-02-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"698407","transaction_code":"C","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2023-02-02 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-02-02 21:42:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:51.000000Z","updated_at":"2025-03-17T19:08:51.000000Z","inspection_violations":[{"id":3523344,"change_date":"2023-02-06 21:41:00","inspection_id":"77757550","insp_violation_id":"250965025","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:39.000000Z","updated_at":"2025-03-17T21:23:39.000000Z","normalized_code":"3922"},{"id":3523345,"change_date":"2023-02-06 21:41:00","inspection_id":"77757550","insp_violation_id":"250965026","seq_no":"2","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:23:39.000000Z","updated_at":"2025-03-17T21:23:39.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":3676999,"change_date":"2023-02-06 21:41:00","inspection_id":"77757550","insp_unit_id":"193242535","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"6","insp_unit_license":"V95565","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX13CXGM035316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:21.000000Z","updated_at":"2025-03-17T22:32:21.000000Z"}]},{"id":1879208,"change_date":"2022-12-06 21:40:00","inspection_id":"77293916","dot_number":"2561156","report_state":"OK","report_number":"K200181015","insp_date":"2022-12-05 00:00:00","insp_start_time":"1155","insp_end_time":"1235","registration_date":null,"region":"CT","ci_status_code":"C","location":"055035","location_desc":"I-35 NB \/ TURNER TURNPIKE","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NORTH CANADIAN HOLDING","shipping_paper_number":"156440","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-12-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"693012","transaction_code":"A","transaction_date":"2022-12-06 00:00:00","upload_date":"2022-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2022-12-06 21:40:00","snet_input_date":"2022-12-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-12-06 21:40:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:10.000000Z","updated_at":"2025-03-17T19:01:10.000000Z","inspection_violations":[{"id":2924505,"change_date":"2022-12-06 21:40:00","inspection_id":"77293916","insp_violation_id":"249936841","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":"N353282","created_at":"2025-03-17T21:20:57.000000Z","updated_at":"2025-03-17T21:20:57.000000Z","normalized_code":"3922"},{"id":2924506,"change_date":"2022-12-06 21:40:00","inspection_id":"77293916","insp_violation_id":"249936842","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":"N353747","created_at":"2025-03-17T21:20:57.000000Z","updated_at":"2025-03-17T21:20:57.000000Z","normalized_code":"3922"},{"id":2924507,"change_date":"2022-12-06 21:40:00","inspection_id":"77293916","insp_violation_id":"249936843","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":"N355408","created_at":"2025-03-17T21:20:57.000000Z","updated_at":"2025-03-17T21:20:57.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3024465,"change_date":"2022-12-06 21:40:00","inspection_id":"77293916","insp_unit_id":"192277184","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"V96526","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C5EM020840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:42.000000Z","updated_at":"2025-03-17T22:27:42.000000Z"}]},{"id":1784198,"change_date":"2022-11-30 21:40:00","inspection_id":"77185163","dot_number":"2561156","report_state":"OK","report_number":"H514152862","insp_date":"2022-11-18 00:00:00","insp_start_time":"1455","insp_end_time":"1515","registration_date":"2022-11-30 00:00:00","region":"CT","ci_status_code":"C","location":"55035","location_desc":"I-35\/ WILSHIRE","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":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"691503","transaction_code":"C","transaction_date":"2022-11-21 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2022-11-21 21:41:00","snet_input_date":"2022-11-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-11-21 21:41:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:37.000000Z","updated_at":"2025-03-17T18:59:37.000000Z","inspection_violations":[{"id":2791047,"change_date":"2022-11-30 21:40:00","inspection_id":"77185163","insp_violation_id":"249849001","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192191023","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:06.000000Z","updated_at":"2025-03-17T21:20:06.000000Z","normalized_code":"39395A"},{"id":2791048,"change_date":"2022-11-30 21:40:00","inspection_id":"77185163","insp_violation_id":"249849002","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192191023","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:20:06.000000Z","updated_at":"2025-03-17T21:20:06.000000Z","normalized_code":"39375A3"},{"id":2791049,"change_date":"2022-11-30 21:40:00","inspection_id":"77185163","insp_violation_id":"249849003","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192191023","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:06.000000Z","updated_at":"2025-03-17T21:20:06.000000Z","normalized_code":"3939A"},{"id":2791050,"change_date":"2022-11-30 21:40:00","inspection_id":"77185163","insp_violation_id":"249849004","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192191023","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:06.000000Z","updated_at":"2025-03-17T21:20:06.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2869916,"change_date":"2022-11-30 21:40:00","inspection_id":"77185163","insp_unit_id":"192191023","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"V96526","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C5EM020840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:37.000000Z","updated_at":"2025-03-17T22:26:37.000000Z"}]},{"id":1675692,"change_date":"2022-11-21 21:41:00","inspection_id":"77060582","dot_number":"2561156","report_state":"OK","report_number":"K200180954","insp_date":"2022-11-04 00:00:00","insp_start_time":"0855","insp_end_time":"0925","registration_date":"2022-11-21 00:00:00","region":"CT","ci_status_code":"C","location":"042035","location_desc":"INTERSTATE 35 NB \/ WATERLOO RD","county_code_state":"OK","county_code":"083","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"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":"62000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"689921","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":"02561156","upload_search_indicator":"M","census_search_date":"2022-11-04 21:38:00","snet_input_date":"2022-11-04 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-11-04 21:38:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:27.000000Z","updated_at":"2025-03-17T18:57:27.000000Z","inspection_violations":[{"id":2627856,"change_date":"2022-11-21 21:41:00","inspection_id":"77060582","insp_violation_id":"249712009","seq_no":"1","part_no":"387","part_no_section":"303(b)(4)","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:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"387303B4"},{"id":2627857,"change_date":"2022-11-21 21:41:00","inspection_id":"77060582","insp_violation_id":"249712010","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192058220","insp_violation_category_id":"26","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":"39378"},{"id":2627858,"change_date":"2022-11-21 21:41:00","inspection_id":"77060582","insp_violation_id":"249712011","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"192058220","insp_violation_category_id":"23","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":"39375C"},{"id":2627859,"change_date":"2022-11-21 21:41:00","inspection_id":"77060582","insp_violation_id":"249712012","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:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2695542,"change_date":"2022-11-21 21:41:00","inspection_id":"77060582","insp_unit_id":"192058220","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"3","insp_unit_license":"V96525","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C2EM019080","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":1413135,"change_date":"2022-10-19 21:41:00","inspection_id":"76758053","dot_number":"2561156","report_state":"OK","report_number":"X200170966","insp_date":"2022-09-30 00:00:00","insp_start_time":"1212","insp_end_time":"1233","registration_date":"2022-10-19 00:00:00","region":"CT","ci_status_code":"C","location":"55074","location_desc":"SH74\/206TH","county_code_state":"OK","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"686021","transaction_code":"C","transaction_date":"2022-09-30 00:00:00","upload_date":"2022-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2022-09-30 21:39:00","snet_input_date":"2022-09-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-09-30 21:39:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:43.000000Z","updated_at":"2025-03-17T18:52:43.000000Z","inspection_violations":[{"id":2226889,"change_date":"2022-10-19 21:41:00","inspection_id":"76758053","insp_violation_id":"249120119","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:17:13.000000Z","updated_at":"2025-03-17T21:17:13.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":2274878,"change_date":"2022-10-19 21:41:00","inspection_id":"76758053","insp_unit_id":"191521823","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2","insp_unit_license":"V96526","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C5EM020840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:33.000000Z","updated_at":"2025-03-17T22:22:33.000000Z"}]},{"id":835837,"change_date":"2022-08-03 21:42:00","inspection_id":"76085460","dot_number":"2561156","report_state":"OK","report_number":"H514152631","insp_date":"2022-07-15 00:00:00","insp_start_time":"0905","insp_end_time":"0934","registration_date":null,"region":"CT","ci_status_code":"C","location":"055044","location_desc":"KILPATRICK TURNPIKE \/ 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":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-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"7","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"677568","transaction_code":"C","transaction_date":"2022-08-03 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02561156","upload_search_indicator":"M","census_search_date":"2022-07-18 21:42:00","snet_input_date":"2022-07-15 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-07-18 21:42:00","insp_carrier_name":"JR SAND & GRAVEL INC","insp_carrier_street":"14500 SOUTH PENNSYLVANIA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73025","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:20.000000Z","updated_at":"2025-03-17T18:42:20.000000Z","inspection_violations":[{"id":1317065,"change_date":"2022-08-03 21:42:00","inspection_id":"76085460","insp_violation_id":"247488588","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190113455","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"3939A"},{"id":1317066,"change_date":"2022-08-03 21:42:00","inspection_id":"76085460","insp_violation_id":"247488589","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190113455","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"3939A"},{"id":1317067,"change_date":"2022-08-03 21:42:00","inspection_id":"76085460","insp_violation_id":"247488590","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190113455","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"3939A"},{"id":1317068,"change_date":"2022-08-03 21:42:00","inspection_id":"76085460","insp_violation_id":"247488591","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190113455","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"3939A"},{"id":1317069,"change_date":"2022-08-03 21:42:00","inspection_id":"76085460","insp_violation_id":"247488592","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190113455","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"3965B"},{"id":1317070,"change_date":"2022-08-03 21:42:00","inspection_id":"76085460","insp_violation_id":"247488593","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"190113455","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"39375C"},{"id":1317071,"change_date":"2022-08-03 21:42:00","inspection_id":"76085460","insp_violation_id":"247488594","seq_no":"7","part_no":"387","part_no_section":"303(b)(4)","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:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"387303B4"}],"inspection_per_units":[{"id":1344599,"change_date":"2022-08-03 21:42:00","inspection_id":"76085460","insp_unit_id":"190113455","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"V96525","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M2AX07C2EM019080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:26.000000Z","updated_at":"2025-03-17T22:16:26.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2561156\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2561156\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2561156\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2561156\/inspections","per_page":100,"prev_page_url":null,"to":56,"total":56}