{"current_page":1,"data":[{"id":11992567,"change_date":"2026-05-22 21:38:00","inspection_id":"87930518","dot_number":"3848993","report_state":"KS","report_number":"9343000186","insp_date":"2026-05-20 00:00:00","insp_start_time":"1205","insp_end_time":"1310","registration_date":null,"region":"CD","ci_status_code":"C","location":"#24W","location_desc":"OLATHE KS","county_code_state":"KS","county_code":"091","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"3382088","transaction_code":"A","transaction_date":"2026-05-21 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":null,"census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:10.000000Z","updated_at":"2026-06-02T09:32:02.000000Z","inspection_violations":[{"id":20863479,"change_date":"2026-05-22 21:38:00","inspection_id":"87930518","insp_violation_id":"274440250","seq_no":"3","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:35.000000Z","updated_at":"2026-06-02T09:43:41.000000Z","normalized_code":"3958A"},{"id":20863478,"change_date":"2026-05-22 21:38:00","inspection_id":"87930518","insp_violation_id":"274440249","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"213702999","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:35.000000Z","updated_at":"2026-06-02T09:43:41.000000Z","normalized_code":"3939ALLPL"},{"id":20863477,"change_date":"2026-05-22 21:38:00","inspection_id":"87930518","insp_violation_id":"274440248","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"213702999","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:35.000000Z","updated_at":"2026-06-02T09:43:41.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":20848423,"change_date":"2026-05-22 21:38:00","inspection_id":"87930518","insp_unit_id":"213702999","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"04","insp_unit_license":"463C91","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5PVNJ8JP4H4S51735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:12.000000Z","updated_at":"2026-06-02T09:04:59.000000Z"}]},{"id":11945554,"change_date":"2026-05-17 21:35:00","inspection_id":"87880914","dot_number":"3848993","report_state":"KS","report_number":"9342000189","insp_date":"2026-05-15 00:00:00","insp_start_time":"1310","insp_end_time":"1405","registration_date":null,"region":"CD","ci_status_code":"C","location":"#24W","location_desc":"OLATHE KS","county_code_state":"KS","county_code":"091","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"UNKNOWN","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-17 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"3347440","transaction_code":"A","transaction_date":"2026-05-16 00:00:00","upload_date":"2026-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":null,"census_search_date":"2026-05-17 21:35:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-17 21:35:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-20T09:41:11.000000Z","updated_at":"2026-05-28T09:30:22.000000Z","inspection_violations":[{"id":20776736,"change_date":"2026-05-17 21:35:00","inspection_id":"87880914","insp_violation_id":"274324135","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"213610278","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-20T10:02:12.000000Z","updated_at":"2026-05-28T09:39:55.000000Z","normalized_code":"39021TB1MC"},{"id":20776737,"change_date":"2026-05-17 21:35:00","inspection_id":"87880914","insp_violation_id":"274324136","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"213610278","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-20T10:02:12.000000Z","updated_at":"2026-05-28T09:39:55.000000Z","normalized_code":"39360C"},{"id":20776738,"change_date":"2026-05-17 21:35:00","inspection_id":"87880914","insp_violation_id":"274324137","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213610278","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-20T10:02:12.000000Z","updated_at":"2026-05-28T09:39:55.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":20771946,"change_date":"2026-05-17 21:35:00","inspection_id":"87880914","insp_unit_id":"213610278","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"01","insp_unit_license":"734611","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HTMMMML9KH586514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-20T09:17:20.000000Z","updated_at":"2026-05-28T09:02:07.000000Z"}]},{"id":11398961,"change_date":"2026-03-18 21:38:00","inspection_id":"87313906","dot_number":"3848993","report_state":"KS","report_number":"HP01070057","insp_date":"2026-03-13 00:00:00","insp_start_time":"1724","insp_end_time":"1830","registration_date":null,"region":"CT","ci_status_code":"C","location":"U050","location_desc":"U050 MP 103","county_code_state":"KS","county_code":"069","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"9","oos_total":"2","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1391245","transaction_code":"C","transaction_date":"2026-03-18 00:00:00","upload_date":"2026-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":"M","census_search_date":"2026-03-17 21:39:00","snet_input_date":"2026-03-13 00:00:00","source_office":"3KSS001","mcmis_add_date":"2026-03-17 21:39:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-20T09:42:38.000000Z","updated_at":"2026-03-29T09:31:26.000000Z","inspection_violations":[{"id":19230521,"change_date":"2026-03-18 21:38:00","inspection_id":"87313906","insp_violation_id":"272477876","seq_no":"1","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"212202562","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:30.000000Z","updated_at":"2026-03-29T09:56:07.000000Z","normalized_code":"39395F"},{"id":19230522,"change_date":"2026-03-18 21:38:00","inspection_id":"87313906","insp_violation_id":"272477877","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"212202562","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:30.000000Z","updated_at":"2026-03-29T09:56:07.000000Z","normalized_code":"39395A4EEUS"},{"id":19230523,"change_date":"2026-03-18 21:38:00","inspection_id":"87313906","insp_violation_id":"272477878","seq_no":"3","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"212202562","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:30.000000Z","updated_at":"2026-03-29T09:56:07.000000Z","normalized_code":"39021TB1MC"},{"id":19230524,"change_date":"2026-03-18 21:38:00","inspection_id":"87313906","insp_violation_id":"272477879","seq_no":"4","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"212202562","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-21T10:12:30.000000Z","updated_at":"2026-03-29T09:56:07.000000Z","normalized_code":"3963A1F"},{"id":19230525,"change_date":"2026-03-18 21:38:00","inspection_id":"87313906","insp_violation_id":"272477880","seq_no":"5","part_no":"393","part_no_section":"67C7V-F","insp_viol_unit":"1","insp_unit_id":"212202562","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:30.000000Z","updated_at":"2026-03-29T09:56:07.000000Z","normalized_code":"39367C7VF"},{"id":19230526,"change_date":"2026-03-18 21:38:00","inspection_id":"87313906","insp_violation_id":"272477881","seq_no":"6","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:30.000000Z","updated_at":"2026-03-29T09:56:07.000000Z","normalized_code":"3958EHOSPD"},{"id":19230527,"change_date":"2026-03-18 21:38:00","inspection_id":"87313906","insp_violation_id":"272477882","seq_no":"7","part_no":"392","part_no_section":"7A-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:30.000000Z","updated_at":"2026-03-29T09:56:07.000000Z","normalized_code":"3927AD"},{"id":19230528,"change_date":"2026-03-18 21:38:00","inspection_id":"87313906","insp_violation_id":"272477883","seq_no":"8","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:30.000000Z","updated_at":"2026-03-29T09:56:07.000000Z","normalized_code":"3922SLLTL"},{"id":19230529,"change_date":"2026-03-18 21:38:00","inspection_id":"87313906","insp_violation_id":"272477884","seq_no":"9","part_no":"395","part_no_section":"3A3I-HOSPDIT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:30.000000Z","updated_at":"2026-03-29T09:56:07.000000Z","normalized_code":"3953A3IHOSPDIT"}],"inspection_per_units":[{"id":19535390,"change_date":"2026-03-18 21:38:00","inspection_id":"87313906","insp_unit_id":"212202562","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"07","insp_unit_license":"464C01","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5PVNJ8JV1F4S59433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-21T09:33:18.000000Z","updated_at":"2026-03-29T09:17:30.000000Z"}]},{"id":11267101,"change_date":"2026-03-02 21:38:00","inspection_id":"87181200","dot_number":"3848993","report_state":"KS","report_number":"HP02223452","insp_date":"2026-02-27 00:00:00","insp_start_time":"0851","insp_end_time":"0919","registration_date":null,"region":"CT","ci_status_code":"C","location":"FO","location_desc":"FORD COUNTY - 057","county_code_state":"KS","county_code":"057","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1390136","transaction_code":"A","transaction_date":"2026-02-27 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":null,"census_search_date":"2026-03-02 21:38:00","snet_input_date":"2026-02-27 00:00:00","source_office":"3KSS001","mcmis_add_date":"2026-03-02 21:38:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-05T10:39:02.000000Z","updated_at":"2026-03-13T09:31:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19267213,"change_date":"2026-03-02 21:38:00","inspection_id":"87181200","insp_unit_id":"211920884","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"179C44","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5PVNJ8JV6H4S64825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:45.000000Z","updated_at":"2026-03-13T09:07:11.000000Z"}]},{"id":11204581,"change_date":"2026-02-23 21:38:00","inspection_id":"87115639","dot_number":"3848993","report_state":"KS","report_number":"HP01893886","insp_date":"2026-02-20 00:00:00","insp_start_time":"0811","insp_end_time":"1006","registration_date":null,"region":"CT","ci_status_code":"C","location":"CA","location_desc":"CLARK COUNTY - 025","county_code_state":"KS","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"32835","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-23 21:38:00","post_acc_ind":"Y","gross_comb_veh_wt":"25999","viol_total":"11","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1389590","transaction_code":"A","transaction_date":"2026-02-20 00:00:00","upload_date":"2026-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":null,"census_search_date":"2026-02-23 21:38:00","snet_input_date":"2026-02-20 00:00:00","source_office":"3KSS001","mcmis_add_date":"2026-02-23 21:38:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-26T10:36:57.000000Z","updated_at":"2026-03-06T10:30:40.000000Z","inspection_violations":[{"id":18787188,"change_date":"2026-02-23 21:38:00","inspection_id":"87115639","insp_violation_id":"271957315","seq_no":"1","part_no":"393","part_no_section":"80A","insp_viol_unit":"1","insp_unit_id":"211765820","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:46.000000Z","updated_at":"2026-03-06T10:40:58.000000Z","normalized_code":"39380A"},{"id":18787189,"change_date":"2026-02-23 21:38:00","inspection_id":"87115639","insp_violation_id":"271957316","seq_no":"2","part_no":"393","part_no_section":"11A1-LBL","insp_viol_unit":"1","insp_unit_id":"211765820","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:46.000000Z","updated_at":"2026-03-06T10:40:58.000000Z","normalized_code":"39311A1LBL"},{"id":18787190,"change_date":"2026-02-23 21:38:00","inspection_id":"87115639","insp_violation_id":"271957317","seq_no":"3","part_no":"393","part_no_section":"11A1-LRLM","insp_viol_unit":"1","insp_unit_id":"211765820","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:46.000000Z","updated_at":"2026-03-06T10:40:58.000000Z","normalized_code":"39311A1LRLM"},{"id":18787191,"change_date":"2026-02-23 21:38:00","inspection_id":"87115639","insp_violation_id":"271957318","seq_no":"4","part_no":"393","part_no_section":"11A1-LSLMWR","insp_viol_unit":"1","insp_unit_id":"211765820","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-26T10:50:46.000000Z","updated_at":"2026-03-06T10:40:58.000000Z","normalized_code":"39311A1LSLMWR"},{"id":18787192,"change_date":"2026-02-23 21:38:00","inspection_id":"87115639","insp_violation_id":"271957319","seq_no":"5","part_no":"393","part_no_section":"11A1-LTSM","insp_viol_unit":"1","insp_unit_id":"211765820","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-26T10:50:46.000000Z","updated_at":"2026-03-06T10:40:58.000000Z","normalized_code":"39311A1LTSM"},{"id":18787193,"change_date":"2026-02-23 21:38:00","inspection_id":"87115639","insp_violation_id":"271957320","seq_no":"6","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"211765820","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-26T10:50:46.000000Z","updated_at":"2026-03-06T10:40:58.000000Z","normalized_code":"393100BC"},{"id":18787194,"change_date":"2026-02-23 21:38:00","inspection_id":"87115639","insp_violation_id":"271957321","seq_no":"7","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"211765820","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:47.000000Z","updated_at":"2026-03-06T10:40:58.000000Z","normalized_code":"39311A1LIL"},{"id":18787195,"change_date":"2026-02-23 21:38:00","inspection_id":"87115639","insp_violation_id":"271957322","seq_no":"8","part_no":"393","part_no_section":"11A1-LCL","insp_viol_unit":"1","insp_unit_id":"211765820","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:47.000000Z","updated_at":"2026-03-06T10:40:58.000000Z","normalized_code":"39311A1LCL"},{"id":18787196,"change_date":"2026-02-23 21:38:00","inspection_id":"87115639","insp_violation_id":"271957323","seq_no":"9","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:47.000000Z","updated_at":"2026-03-06T10:40:58.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":18787197,"change_date":"2026-02-23 21:38:00","inspection_id":"87115639","insp_violation_id":"271957324","seq_no":"10","part_no":"395","part_no_section":"8K2-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:47.000000Z","updated_at":"2026-03-06T10:40:58.000000Z","normalized_code":"3958K2HOSP"},{"id":18787198,"change_date":"2026-02-23 21:38:00","inspection_id":"87115639","insp_violation_id":"271957325","seq_no":"11","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:50:47.000000Z","updated_at":"2026-03-06T10:40:58.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":19133306,"change_date":"2026-02-23 21:38:00","inspection_id":"87115639","insp_unit_id":"211765820","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"03","insp_unit_license":"99C295","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3HAMMMML9HL691105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:12.000000Z","updated_at":"2026-03-06T10:03:19.000000Z"}]},{"id":10875718,"change_date":"2026-01-28 21:37:00","inspection_id":"86905967","dot_number":"3848993","report_state":"NM","report_number":"3563Q0RFW4","insp_date":"2026-01-27 00:00:00","insp_start_time":"1219","insp_end_time":"1300","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"TEXICO PORT OF ENTRY","county_code_state":"NM","county_code":"009","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RJ HISPANIC DISTRIBUTIONS","shipping_paper_number":"31827","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-01-28 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2251276","transaction_code":"A","transaction_date":"2026-01-27 00:00:00","upload_date":"2026-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":null,"census_search_date":"2026-01-28 21:37:00","snet_input_date":"2026-01-28 00:00:00","source_office":"2NMS001","mcmis_add_date":"2026-01-28 21:37:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"425 KOALA AVE","insp_carrier_city":"EDMOND","insp_carrier_state":"OK","insp_carrier_zip_code":"73034","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-31T10:36:26.000000Z","updated_at":"2026-02-08T10:31:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18278322,"change_date":"2026-01-28 21:37:00","inspection_id":"86905967","insp_unit_id":"211324657","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"TRK 01","insp_unit_license":"99C295","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3HAMMMML9HL691105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-31T10:11:01.000000Z","updated_at":"2026-02-08T10:04:43.000000Z"}]},{"id":10816403,"change_date":"2026-02-23 21:38:00","inspection_id":"86843792","dot_number":"3848993","report_state":"TX","report_number":"V262188807","insp_date":"2026-01-14 00:00:00","insp_start_time":"1005","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":"4A106","location_desc":"IH20 EB ODESSA SCALE","county_code_state":"TX","county_code":"135","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RJ","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"9824940","transaction_code":"C","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":"M","census_search_date":"2026-01-20 21:40:00","snet_input_date":"2026-01-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-20 21:40:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1101134","created_at":"2026-01-23T10:36:30.000000Z","updated_at":"2026-03-06T10:30:09.000000Z","inspection_violations":[{"id":18795980,"change_date":"2026-02-23 21:38:00","inspection_id":"86843792","insp_violation_id":"271964276","seq_no":"1","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"211770660","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:51:05.000000Z","updated_at":"2026-03-06T10:40:06.000000Z","normalized_code":"39395B"},{"id":18795981,"change_date":"2026-02-23 21:38:00","inspection_id":"86843792","insp_violation_id":"271964277","seq_no":"2","part_no":"395","part_no_section":"30B2-ELDDFC24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:51:05.000000Z","updated_at":"2026-03-06T10:40:06.000000Z","normalized_code":"39530B2ELDDFC24"}],"inspection_per_units":[{"id":19138655,"change_date":"2026-02-23 21:38:00","inspection_id":"86843792","insp_unit_id":"211770660","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1","insp_unit_license":"734611","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HTMMMML9KH586514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:16.000000Z","updated_at":"2026-03-06T10:02:35.000000Z"}]},{"id":9988543,"change_date":"2025-10-20 21:40:00","inspection_id":"86098170","dot_number":"3848993","report_state":"TX","report_number":"V252058824","insp_date":"2025-10-17 00:00:00","insp_start_time":"1424","insp_end_time":"1519","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US287 MM 32","county_code_state":"TX","county_code":"421","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9732375","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":"M","census_search_date":"2025-10-20 21:40:00","snet_input_date":"2025-10-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-20 21:40:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1101134","created_at":"2025-10-23T10:00:45.000000Z","updated_at":"2025-10-24T10:01:12.000000Z","inspection_violations":[{"id":16505600,"change_date":"2025-10-20 21:40:00","inspection_id":"86098170","insp_violation_id":"269408290","seq_no":"1","part_no":"383","part_no_section":"23A2","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-10-23T10:16:07.000000Z","updated_at":"2025-10-24T10:17:06.000000Z","normalized_code":"38323A2"},{"id":16505601,"change_date":"2025-10-20 21:40:00","inspection_id":"86098170","insp_violation_id":"269408291","seq_no":"2","part_no":"392","part_no_section":"2IRP","insp_viol_unit":"1","insp_unit_id":"209561684","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:16:07.000000Z","updated_at":"2025-10-24T10:17:06.000000Z","normalized_code":"3922IRP"}],"inspection_per_units":[{"id":16586904,"change_date":"2025-10-20 21:40:00","inspection_id":"86098170","insp_unit_id":"209561684","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"99C295","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3HAMMMML9HL691105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:49.000000Z","updated_at":"2025-10-24T09:46:28.000000Z"}]},{"id":9961902,"change_date":"2025-10-16 21:40:00","inspection_id":"86070035","dot_number":"3848993","report_state":"KS","report_number":"HP93426230","insp_date":"2025-10-15 00:00:00","insp_start_time":"1200","insp_end_time":"1240","registration_date":null,"region":"CT","ci_status_code":"C","location":"#24W","location_desc":"OLATHE SOUTH M.C.I.S. #24W","county_code_state":"KS","county_code":"091","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1378800","transaction_code":"A","transaction_date":"2025-10-15 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":null,"census_search_date":"2025-10-16 21:40:00","snet_input_date":"2025-10-15 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-10-16 21:40:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-19T10:01:46.000000Z","updated_at":"2025-10-20T10:01:09.000000Z","inspection_violations":[{"id":16451012,"change_date":"2025-10-16 21:40:00","inspection_id":"86070035","insp_violation_id":"269342863","seq_no":"1","part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"209508758","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-19T10:17:45.000000Z","updated_at":"2025-10-20T10:16:43.000000Z","normalized_code":"39330B"},{"id":16451013,"change_date":"2025-10-16 21:40:00","inspection_id":"86070035","insp_violation_id":"269342864","seq_no":"2","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"209508758","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-19T10:17:45.000000Z","updated_at":"2025-10-20T10:16:43.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":16539825,"change_date":"2025-10-16 21:40:00","inspection_id":"86070035","insp_unit_id":"209508758","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"04","insp_unit_license":"92C640","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5PVNJ8JP4H4S51735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:46:59.000000Z","updated_at":"2025-10-20T09:46:22.000000Z"}]},{"id":9926484,"change_date":"2025-11-13 21:39:00","inspection_id":"86032238","dot_number":"3848993","report_state":"OK","report_number":"D800152103","insp_date":"2025-10-10 00:00:00","insp_start_time":"0755","insp_end_time":"0840","registration_date":"2025-11-13 00:00:00","region":"CT","ci_status_code":"C","location":"21412","location_desc":"US 412\/ KANSAS EXIT","county_code_state":"OK","county_code":"041","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"RJ HISPANIC DISTRIBUTION","shipping_paper_number":"26973","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-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"800323","transaction_code":"C","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":"M","census_search_date":"2025-10-13 21:37:00","snet_input_date":"2025-10-10 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-10-13 21:37:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-16T10:00:40.000000Z","updated_at":"2025-11-17T10:30:08.000000Z","inspection_violations":[{"id":16919326,"change_date":"2025-11-13 21:39:00","inspection_id":"86032238","insp_violation_id":"269933987","seq_no":"1","part_no":"391","part_no_section":"11B2-S","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-16T10:33:07.000000Z","updated_at":"2025-11-17T10:30:13.000000Z","normalized_code":"39111B2S"}],"inspection_per_units":[{"id":16965362,"change_date":"2025-11-13 21:39:00","inspection_id":"86032238","insp_unit_id":"210012230","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"05","insp_unit_license":"OSB89471","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5PVNJ8JV6H4S64825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-16T10:02:18.000000Z","updated_at":"2025-11-17T10:00:08.000000Z"}]},{"id":9868748,"change_date":"2025-10-07 21:41:00","inspection_id":"85971655","dot_number":"3848993","report_state":"TX","report_number":"V251980802","insp_date":"2025-09-26 00:00:00","insp_start_time":"1926","insp_end_time":"1939","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 60 MP 430","county_code_state":"TX","county_code":"211","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"9716660","transaction_code":"C","transaction_date":"2025-10-07 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":"M","census_search_date":"2025-10-06 21:41:00","snet_input_date":"2025-09-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-06 21:41:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1101134","created_at":"2025-10-09T10:00:57.000000Z","updated_at":"2025-10-11T10:00:50.000000Z","inspection_violations":[{"id":16280372,"change_date":"2025-10-07 21:41:00","inspection_id":"85971655","insp_violation_id":"269158423","seq_no":"1","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"209348131","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:34.000000Z","updated_at":"2025-10-11T10:16:40.000000Z","normalized_code":"39330"},{"id":16280373,"change_date":"2025-10-07 21:41:00","inspection_id":"85971655","insp_violation_id":"269158424","seq_no":"2","part_no":"392","part_no_section":"2WC","insp_viol_unit":"1","insp_unit_id":"209348131","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:34.000000Z","updated_at":"2025-10-11T10:16:40.000000Z","normalized_code":"3922WC"}],"inspection_per_units":[{"id":16385022,"change_date":"2025-10-07 21:41:00","inspection_id":"85971655","insp_unit_id":"209348131","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"04","insp_unit_license":"92C640","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5PVNJ8JP4H4S51735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:45.000000Z","updated_at":"2025-10-11T09:46:06.000000Z"}]},{"id":9566270,"change_date":"2025-09-02 21:39:00","inspection_id":"85654772","dot_number":"3848993","report_state":"OK","report_number":"D800152026","insp_date":"2025-08-29 00:00:00","insp_start_time":"0840","insp_end_time":"0905","registration_date":null,"region":"CT","ci_status_code":"C","location":"21412","location_desc":"US 412\/ KANSAS EXIT","county_code_state":"OK","county_code":"041","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"RJ HISPANIC","shipping_paper_number":"25261","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"795992","transaction_code":"A","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":null,"census_search_date":"2025-09-02 21:39:00","snet_input_date":"2025-08-29 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-09-02 21:39:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:02.000000Z","updated_at":"2025-09-06T10:43:02.000000Z","inspection_violations":[{"id":15623133,"change_date":"2025-09-02 21:39:00","inspection_id":"85654772","insp_violation_id":"268394888","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"208696876","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:47:21.000000Z","updated_at":"2025-09-06T10:47:21.000000Z","normalized_code":"3939ALCL"},{"id":15623134,"change_date":"2025-09-02 21:39:00","inspection_id":"85654772","insp_violation_id":"268394889","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"208696876","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:47:21.000000Z","updated_at":"2025-09-06T10:47:21.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":15790570,"change_date":"2025-09-02 21:39:00","inspection_id":"85654772","insp_unit_id":"208696876","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"01","insp_unit_license":"734611","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HTMMMML9KH586514","insp_unit_decal":"Y","insp_unit_decal_number":"35522247","created_at":"2025-09-09T09:47:15.000000Z","updated_at":"2025-09-09T09:47:15.000000Z"}]},{"id":9322474,"change_date":"2025-08-05 21:39:00","inspection_id":"85398042","dot_number":"3848993","report_state":"KS","report_number":"HP01070017","insp_date":"2025-08-01 00:00:00","insp_start_time":"0954","insp_end_time":"1036","registration_date":null,"region":"CT","ci_status_code":"C","location":"U050","location_desc":"U050 MP 91","county_code_state":"KS","county_code":"069","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"6","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1370026","transaction_code":"C","transaction_date":"2025-08-01 00:00:00","upload_date":"2025-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":null,"census_search_date":"2025-08-04 21:39:00","snet_input_date":"2025-08-01 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-08-04 21:39:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:50.000000Z","updated_at":"2025-08-12T10:41:38.000000Z","inspection_violations":[{"id":15149507,"change_date":"2025-08-05 21:39:00","inspection_id":"85398042","insp_violation_id":"267849739","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"208248715","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:44:51.000000Z","updated_at":"2025-08-09T10:44:27.000000Z","normalized_code":"3939ALFTSI"},{"id":15149508,"change_date":"2025-08-05 21:39:00","inspection_id":"85398042","insp_violation_id":"267849740","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"208248715","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:44:51.000000Z","updated_at":"2025-08-09T10:44:27.000000Z","normalized_code":"39395A4EEUS"},{"id":15149509,"change_date":"2025-08-05 21:39:00","inspection_id":"85398042","insp_violation_id":"267849741","seq_no":"3","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"208248715","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:44:51.000000Z","updated_at":"2025-08-09T10:44:27.000000Z","normalized_code":"39021TB1MC"},{"id":15149510,"change_date":"2025-08-05 21:39:00","inspection_id":"85398042","insp_violation_id":"267849742","seq_no":"4","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"208248715","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:44:51.000000Z","updated_at":"2025-08-09T10:44:27.000000Z","normalized_code":"3969D2FTF"},{"id":15149511,"change_date":"2025-08-05 21:39:00","inspection_id":"85398042","insp_violation_id":"267849743","seq_no":"5","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:44:51.000000Z","updated_at":"2025-08-09T10:44:28.000000Z","normalized_code":"3958EHOSPD"},{"id":15149512,"change_date":"2025-08-05 21:39:00","inspection_id":"85398042","insp_violation_id":"267849744","seq_no":"6","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"NA18912201","created_at":"2025-08-08T10:44:51.000000Z","updated_at":"2025-08-09T10:44:28.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":15372362,"change_date":"2025-08-05 21:39:00","inspection_id":"85398042","insp_unit_id":"208248715","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"03","insp_unit_license":"99C295","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3HAMMMML9HL691105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-08T09:46:32.000000Z","updated_at":"2025-08-09T09:45:46.000000Z"}]},{"id":9123102,"change_date":"2025-07-11 21:39:00","inspection_id":"85188424","dot_number":"3848993","report_state":"OK","report_number":"H100000204","insp_date":"2025-07-04 00:00:00","insp_start_time":"0745","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":"21412","location_desc":"US412\/CHEROKEE TP MM 24.4 EB","county_code_state":"OK","county_code":"041","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"23066","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":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"790751","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-04 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:04.000000Z","updated_at":"2025-07-16T10:44:43.000000Z","inspection_violations":[{"id":14708017,"change_date":"2025-07-11 21:39:00","inspection_id":"85188424","insp_violation_id":"267346164","seq_no":"1","part_no":"392","part_no_section":"2-SLLML","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:46.000000Z","updated_at":"2025-07-16T10:45:59.000000Z","normalized_code":"3922SLLML"},{"id":14708018,"change_date":"2025-07-11 21:39:00","inspection_id":"85188424","insp_violation_id":"267346165","seq_no":"2","part_no":"390","part_no_section":"21TE2IV-D","insp_viol_unit":"1","insp_unit_id":"207820615","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:46.000000Z","updated_at":"2025-07-16T10:45:59.000000Z","normalized_code":"39021TE2IVD"},{"id":14708019,"change_date":"2025-07-11 21:39:00","inspection_id":"85188424","insp_violation_id":"267346166","seq_no":"3","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:46.000000Z","updated_at":"2025-07-16T10:45:59.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":14978752,"change_date":"2025-07-11 21:39:00","inspection_id":"85188424","insp_unit_id":"207820615","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"502902","insp_unit_license":"3452748","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVACWFC4RHUZ2468","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:07.000000Z","updated_at":"2025-07-15T09:45:45.000000Z"}]},{"id":8533732,"change_date":"2025-05-02 21:41:00","inspection_id":"84565852","dot_number":"3848993","report_state":"OK","report_number":"U200164758","insp_date":"2025-05-01 00:00:00","insp_start_time":"1353","insp_end_time":"1416","registration_date":null,"region":"CT","ci_status_code":"C","location":"042033","location_desc":"SH74\/SH33","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":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-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"783168","transaction_code":"A","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":"M","census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-05-01 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-05T10:16:05.000000Z","updated_at":"2025-05-06T10:06:10.000000Z","inspection_violations":[{"id":13515714,"change_date":"2025-05-02 21:41:00","inspection_id":"84565852","insp_violation_id":"265975426","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"206616094","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:30.000000Z","updated_at":"2025-05-06T10:31:07.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":13875988,"change_date":"2025-05-02 21:41:00","inspection_id":"84565852","insp_unit_id":"206616094","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"99C295","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3HAMMMML9HL691105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T10:04:09.000000Z","updated_at":"2025-05-07T10:02:04.000000Z"}]},{"id":8179236,"change_date":"2025-03-21 21:40:00","inspection_id":"84192381","dot_number":"3848993","report_state":"KS","report_number":"HP00701584","insp_date":"2025-03-20 00:00:00","insp_start_time":"1325","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":"#24W","location_desc":"OLATHE SOUTH M.C.I.S. #24W","county_code_state":"KS","county_code":"091","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1355722","transaction_code":"A","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":null,"census_search_date":"2025-03-21 21:40:00","snet_input_date":"2025-03-20 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-03-21 21:40:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-24T10:28:02.000000Z","updated_at":"2025-03-25T10:10:59.000000Z","inspection_violations":[{"id":12818891,"change_date":"2025-03-21 21:40:00","inspection_id":"84192381","insp_violation_id":"265185907","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-23T11:39:06.000000Z","updated_at":"2025-03-25T10:31:24.000000Z","normalized_code":"39141AMCPC"},{"id":12818892,"change_date":"2025-03-21 21:40:00","inspection_id":"84192381","insp_violation_id":"265185908","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"205929356","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-23T11:39:06.000000Z","updated_at":"2025-03-25T10:31:24.000000Z","normalized_code":"39360C"},{"id":12818893,"change_date":"2025-03-21 21:40:00","inspection_id":"84192381","insp_violation_id":"265185909","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"205929356","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-23T11:39:06.000000Z","updated_at":"2025-03-25T10:31:24.000000Z","normalized_code":"39395A4EEUS"},{"id":12818894,"change_date":"2025-03-21 21:40:00","inspection_id":"84192381","insp_violation_id":"265185910","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"205929356","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-23T11:39:06.000000Z","updated_at":"2025-03-25T10:31:24.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":13221326,"change_date":"2025-03-21 21:40:00","inspection_id":"84192381","insp_unit_id":"205929356","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"01","insp_unit_license":"734611","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HTMMMML9KH586514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-24T10:17:43.000000Z","updated_at":"2025-03-25T09:59:56.000000Z"}]},{"id":8110436,"change_date":"2025-03-13 21:44:00","inspection_id":"84119952","dot_number":"3848993","report_state":"KS","report_number":"HP03031829","insp_date":"2025-03-12 00:00:00","insp_start_time":"1730","insp_end_time":"1840","registration_date":null,"region":"CT","ci_status_code":"C","location":"DG","location_desc":"DOUGLAS COUNTY - 045","county_code_state":"KS","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"18639","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-13 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"5","oos_total":"1","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1354714","transaction_code":"A","transaction_date":"2025-03-12 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":null,"census_search_date":"2025-03-13 21:44:00","snet_input_date":"2025-03-12 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-03-13 21:44:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:52.000000Z","updated_at":"2025-03-17T21:06:52.000000Z","inspection_violations":[{"id":12680760,"change_date":"2025-03-13 21:44:00","inspection_id":"84119952","insp_violation_id":"265025584","seq_no":"1","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:08.000000Z","updated_at":"2025-03-17T22:08:08.000000Z","normalized_code":"3958A1HOSP"},{"id":12680761,"change_date":"2025-03-13 21:44:00","inspection_id":"84119952","insp_violation_id":"265025585","seq_no":"2","part_no":"395","part_no_section":"8F7-HOSM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:08.000000Z","updated_at":"2025-03-17T22:08:08.000000Z","normalized_code":"3958F7HOSM"},{"id":12680762,"change_date":"2025-03-13 21:44:00","inspection_id":"84119952","insp_violation_id":"265025586","seq_no":"3","part_no":"395","part_no_section":"8D10-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:08.000000Z","updated_at":"2025-03-17T22:08:08.000000Z","normalized_code":"3958D10HOSF"},{"id":12680763,"change_date":"2025-03-13 21:44:00","inspection_id":"84119952","insp_violation_id":"265025587","seq_no":"4","part_no":"395","part_no_section":"8H5-HOSM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:08.000000Z","updated_at":"2025-03-17T22:08:08.000000Z","normalized_code":"3958H5HOSM"},{"id":12680764,"change_date":"2025-03-13 21:44:00","inspection_id":"84119952","insp_violation_id":"265025588","seq_no":"5","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"205789951","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:08.000000Z","updated_at":"2025-03-17T22:08:08.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":13095087,"change_date":"2025-03-13 21:44:00","inspection_id":"84119952","insp_unit_id":"205789951","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"01","insp_unit_license":"734611","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HTMMMML9KH586514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:47.000000Z","updated_at":"2025-03-17T23:59:47.000000Z"}]},{"id":7639843,"change_date":"2025-01-16 21:41:00","inspection_id":"83625573","dot_number":"3848993","report_state":"KS","report_number":"HP20082455","insp_date":"2025-01-15 00:00:00","insp_start_time":"1405","insp_end_time":"1445","registration_date":null,"region":"CT","ci_status_code":"C","location":"#24W","location_desc":"OLATHE SOUTH M.C.I.S. #24W","county_code_state":"KS","county_code":"091","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":"16020","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-01-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"10","oos_total":"2","driver_viol_total":"4","driver_oos_total":"2","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1350162","transaction_code":"A","transaction_date":"2025-01-16 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":"M","census_search_date":"2025-01-16 21:41:00","snet_input_date":"2025-01-15 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-01-16 21:41:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:35.000000Z","updated_at":"2025-03-17T20:56:35.000000Z","inspection_violations":[{"id":11938305,"change_date":"2025-01-16 21:41:00","inspection_id":"83625573","insp_violation_id":"264038224","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"204873703","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:08.000000Z","updated_at":"2025-03-17T22:04:08.000000Z","normalized_code":"39395A1"},{"id":11938306,"change_date":"2025-01-16 21:41:00","inspection_id":"83625573","insp_violation_id":"264038225","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204873703","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:08.000000Z","updated_at":"2025-03-17T22:04:08.000000Z","normalized_code":"39395F"},{"id":11938307,"change_date":"2025-01-16 21:41:00","inspection_id":"83625573","insp_violation_id":"264038226","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204873703","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:08.000000Z","updated_at":"2025-03-17T22:04:08.000000Z","normalized_code":"39617CPI"},{"id":11938308,"change_date":"2025-01-16 21:41:00","inspection_id":"83625573","insp_violation_id":"264038227","seq_no":"4","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"204873703","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:08.000000Z","updated_at":"2025-03-17T22:04:08.000000Z","normalized_code":"39021TB1MC"},{"id":11938309,"change_date":"2025-01-16 21:41:00","inspection_id":"83625573","insp_violation_id":"264038228","seq_no":"5","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"204873703","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:08.000000Z","updated_at":"2025-03-17T22:04:08.000000Z","normalized_code":"39021TB2DOT"},{"id":11938310,"change_date":"2025-01-16 21:41:00","inspection_id":"83625573","insp_violation_id":"264038229","seq_no":"6","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"204873703","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:08.000000Z","updated_at":"2025-03-17T22:04:08.000000Z","normalized_code":"39311A1LLPL"},{"id":11938311,"change_date":"2025-01-16 21:41:00","inspection_id":"83625573","insp_violation_id":"264038230","seq_no":"7","part_no":"392","part_no_section":"8-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:08.000000Z","updated_at":"2025-03-17T22:04:08.000000Z","normalized_code":"3928D"},{"id":11938312,"change_date":"2025-01-16 21:41:00","inspection_id":"83625573","insp_violation_id":"264038231","seq_no":"8","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:08.000000Z","updated_at":"2025-03-17T22:04:08.000000Z","normalized_code":"39141AMCPC"},{"id":11938313,"change_date":"2025-01-16 21:41:00","inspection_id":"83625573","insp_violation_id":"264038232","seq_no":"9","part_no":"395","part_no_section":"8K2-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:08.000000Z","updated_at":"2025-03-17T22:04:08.000000Z","normalized_code":"3958K2HOSP"},{"id":11938314,"change_date":"2025-01-16 21:41:00","inspection_id":"83625573","insp_violation_id":"264038233","seq_no":"10","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:08.000000Z","updated_at":"2025-03-17T22:04:08.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":12327621,"change_date":"2025-01-16 21:41:00","inspection_id":"83625573","insp_unit_id":"204873703","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3","insp_unit_license":"99C295","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3HAMMMML9HL691105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:03.000000Z","updated_at":"2025-03-17T23:51:03.000000Z"}]},{"id":6680123,"change_date":"2024-09-09 21:40:00","inspection_id":"82610589","dot_number":"3848993","report_state":"KS","report_number":"HP04502889","insp_date":"2024-09-06 00:00:00","insp_start_time":"0931","insp_end_time":"1012","registration_date":null,"region":"CT","ci_status_code":"C","location":"FO","location_desc":"FORD COUNTY - 057","county_code_state":"KS","county_code":"057","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RJ HISPANIC DISTRIBUTION","shipping_paper_number":"10747","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-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33300","viol_total":"5","oos_total":"2","driver_viol_total":"4","driver_oos_total":"2","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1336751","transaction_code":"A","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":null,"census_search_date":"2024-09-09 21:40:00","snet_input_date":"2024-09-06 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:36.000000Z","updated_at":"2025-03-17T20:35:36.000000Z","inspection_violations":[{"id":10396237,"change_date":"2024-09-09 21:40:00","inspection_id":"82610589","insp_violation_id":"261689903","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"3922"},{"id":10396238,"change_date":"2024-09-09 21:40:00","inspection_id":"82610589","insp_violation_id":"261689904","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:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"3922"},{"id":10396239,"change_date":"2024-09-09 21:40:00","inspection_id":"82610589","insp_violation_id":"261689905","seq_no":"3","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:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"38323A2"},{"id":10396240,"change_date":"2024-09-09 21:40:00","inspection_id":"82610589","insp_violation_id":"261689906","seq_no":"4","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"3958A1"},{"id":10396241,"change_date":"2024-09-09 21:40:00","inspection_id":"82610589","insp_violation_id":"261689907","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202826838","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10770606,"change_date":"2024-09-09 21:40:00","inspection_id":"82610589","insp_unit_id":"202826838","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"01","insp_unit_license":"731606","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1HTMMMML9KH586514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"}]},{"id":5080864,"change_date":"2024-02-19 21:34:00","inspection_id":"80881793","dot_number":"3848993","report_state":"KS","report_number":"HP01271787","insp_date":"2024-02-16 00:00:00","insp_start_time":"1315","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RJ DISTRIBUTION LLC","shipping_paper_number":"3251","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-02-19 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"17995","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1315978","transaction_code":"A","transaction_date":"2024-02-16 00:00:00","upload_date":"2024-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03848993","upload_search_indicator":null,"census_search_date":"2024-02-19 21:34:00","snet_input_date":"2024-02-16 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-02-19 21:34:00","insp_carrier_name":"RJ HISPANIC DISTRIBUTION LLC","insp_carrier_street":"10809 NE 16TH ST","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73130","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:25.000000Z","updated_at":"2025-03-17T20:03:25.000000Z","inspection_violations":[{"id":7831882,"change_date":"2024-02-19 21:34:00","inspection_id":"80881793","insp_violation_id":"257906718","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:51.000000Z","updated_at":"2025-03-17T21:43:51.000000Z","normalized_code":"39141A"},{"id":7831883,"change_date":"2024-02-19 21:34:00","inspection_id":"80881793","insp_violation_id":"257906719","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199485561","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:51.000000Z","updated_at":"2025-03-17T21:43:51.000000Z","normalized_code":"39617C"},{"id":7831884,"change_date":"2024-02-19 21:34:00","inspection_id":"80881793","insp_violation_id":"257906720","seq_no":"3","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"199485561","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:51.000000Z","updated_at":"2025-03-17T21:43:51.000000Z","normalized_code":"39330"},{"id":7831885,"change_date":"2024-02-19 21:34:00","inspection_id":"80881793","insp_violation_id":"257906721","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199485561","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:51.000000Z","updated_at":"2025-03-17T21:43:51.000000Z","normalized_code":"39395A"},{"id":7831886,"change_date":"2024-02-19 21:34:00","inspection_id":"80881793","insp_violation_id":"257906722","seq_no":"5","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"199485561","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:51.000000Z","updated_at":"2025-03-17T21:43:51.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":8179854,"change_date":"2024-02-19 21:34:00","inspection_id":"80881793","insp_unit_id":"199485561","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITS","insp_unit_company":null,"insp_unit_license":"47C714","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"JL6CRK1A8CK013830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:08.000000Z","updated_at":"2025-03-17T23:09:08.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3848993\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3848993\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3848993\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/3848993\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}