{"current_page":1,"data":[{"id":12101261,"change_date":"2026-06-04 21:46:00","inspection_id":"88045748","dot_number":"2201010","report_state":"CA","report_number":"NE46006167","insp_date":"2026-06-03 00:00:00","insp_start_time":"2057","insp_end_time":"2131","registration_date":null,"region":"PS","ci_status_code":"C","location":"424","location_desc":"CA","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COSTCO","shipping_paper_number":"26D61140","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-04 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"66453","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":"3470552","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":"2026-06-04 21:46:00","snet_input_date":"2026-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:46:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2026-06-07T09:40:58.000000Z","updated_at":"2026-06-16T09:32:08.000000Z","inspection_violations":[{"id":21059116,"change_date":"2026-06-04 21:46:00","inspection_id":"88045748","insp_violation_id":"274701645","seq_no":"1","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"213919628","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:01:09.000000Z","updated_at":"2026-06-16T09:47:01.000000Z","normalized_code":"3939AHLLH"}],"inspection_per_units":[{"id":21026100,"change_date":"2026-06-04 21:46:00","inspection_id":"88045748","insp_unit_id":"213919628","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6","insp_unit_license":"9F40824","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD67ESFM1309","insp_unit_decal":"Y","insp_unit_decal_number":"36202950","created_at":"2026-06-07T09:18:13.000000Z","updated_at":"2026-06-16T09:04:18.000000Z"},{"id":21026101,"change_date":"2026-06-04 21:46:00","inspection_id":"88045748","insp_unit_id":"213919629","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"65000","insp_unit_license":"4PB2198","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0626CW704107","insp_unit_decal":"Y","insp_unit_decal_number":"36202951","created_at":"2026-06-07T09:18:13.000000Z","updated_at":"2026-06-16T09:04:18.000000Z"}]},{"id":11764188,"change_date":"2026-04-27 21:39:00","inspection_id":"87694635","dot_number":"2201010","report_state":"CA","report_number":"UFEK005166","insp_date":"2026-04-24 00:00:00","insp_start_time":"1405","insp_end_time":"1436","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"OPPENHEIMER","shipping_paper_number":"LD02341257","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-04-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16263595","transaction_code":"A","transaction_date":"2026-04-24 00:00:00","upload_date":"2026-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-27 21:39:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2026-04-30T09:39:44.000000Z","updated_at":"2026-05-08T09:31:36.000000Z","inspection_violations":[{"id":20453904,"change_date":"2026-04-27 21:39:00","inspection_id":"87694635","insp_violation_id":"273890377","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"213255940","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-30T09:59:34.000000Z","updated_at":"2026-05-08T09:43:35.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":20467193,"change_date":"2026-04-27 21:39:00","inspection_id":"87694635","insp_unit_id":"213255939","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHT-07","insp_unit_license":"9E96120","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1FJ428892","insp_unit_decal":"Y","insp_unit_decal_number":"36214813","created_at":"2026-04-30T09:18:58.000000Z","updated_at":"2026-05-08T09:04:40.000000Z"},{"id":20467194,"change_date":"2026-04-27 21:39:00","inspection_id":"87694635","insp_unit_id":"213255940","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT-14453","insp_unit_license":"4PB2198","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0626CW704107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-30T09:18:58.000000Z","updated_at":"2026-05-08T09:04:40.000000Z"}]},{"id":11359538,"change_date":"2026-03-12 21:40:00","inspection_id":"87278094","dot_number":"2201010","report_state":"CA","report_number":"NF4W000944","insp_date":"2026-03-10 00:00:00","insp_start_time":"2214","insp_end_time":"2242","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BOOTH RANCHES","shipping_paper_number":"266254","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-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"16206569","transaction_code":"A","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-12 21:40:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2026-03-15T09:40:03.000000Z","updated_at":"2026-03-23T09:32:57.000000Z","inspection_violations":[{"id":19140492,"change_date":"2026-03-12 21:40:00","inspection_id":"87278094","insp_violation_id":"272377990","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"212113878","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA236909","created_at":"2026-03-15T10:03:52.000000Z","updated_at":"2026-03-23T09:52:24.000000Z","normalized_code":"3939ALFTSI"},{"id":19140493,"change_date":"2026-03-12 21:40:00","inspection_id":"87278094","insp_violation_id":"272377991","seq_no":"2","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"212113878","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-15T10:03:52.000000Z","updated_at":"2026-03-23T09:52:24.000000Z","normalized_code":"3939ALHWS"},{"id":19140494,"change_date":"2026-03-12 21:40:00","inspection_id":"87278094","insp_violation_id":"272377992","seq_no":"3","part_no":"393","part_no_section":"207B-AALPME","insp_viol_unit":"2","insp_unit_id":"212113879","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-15T10:03:52.000000Z","updated_at":"2026-03-23T09:52:24.000000Z","normalized_code":"393207BAALPME"}],"inspection_per_units":[{"id":19441044,"change_date":"2026-03-12 21:40:00","inspection_id":"87278094","insp_unit_id":"212113878","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"32","insp_unit_license":"9G15212","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5FJ438423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:45.000000Z","updated_at":"2026-03-23T09:12:04.000000Z"},{"id":19441045,"change_date":"2026-03-12 21:40:00","inspection_id":"87278094","insp_unit_id":"212113879","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5317","insp_unit_license":"4UA9049","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2535AU944208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:45.000000Z","updated_at":"2026-03-23T09:12:04.000000Z"}]},{"id":11302261,"change_date":"2026-03-05 21:40:00","inspection_id":"87218021","dot_number":"2201010","report_state":"CA","report_number":"NEVB002780","insp_date":"2026-03-04 00:00:00","insp_start_time":"1509","insp_end_time":"1539","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PRODUCERS DAIRY FOODS","shipping_paper_number":"51915532","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-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"16194029","transaction_code":"A","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-05 21:40:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-08T09:44:17.000000Z","updated_at":"2026-03-16T09:31:15.000000Z","inspection_violations":[{"id":19011694,"change_date":"2026-03-05 21:40:00","inspection_id":"87218021","insp_violation_id":"272231167","seq_no":"1","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"211995993","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-08T10:08:54.000000Z","updated_at":"2026-03-16T09:41:58.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":19332988,"change_date":"2026-03-05 21:40:00","inspection_id":"87218021","insp_unit_id":"211995992","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHT3XL","insp_unit_license":"9G14896","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYDP9X7FJ452129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-08T09:25:21.000000Z","updated_at":"2026-03-16T09:04:41.000000Z"},{"id":19332989,"change_date":"2026-03-05 21:40:00","inspection_id":"87218021","insp_unit_id":"211995993","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT2XL","insp_unit_license":"38224F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS2536YM036313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-08T09:25:21.000000Z","updated_at":"2026-03-16T09:04:41.000000Z"}]},{"id":10641564,"change_date":"2026-01-13 21:40:00","inspection_id":"86782996","dot_number":"2201010","report_state":"CA","report_number":"NDOG006872","insp_date":"2026-01-07 00:00:00","insp_start_time":"2052","insp_end_time":"2130","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GOLD CUP FRESH","shipping_paper_number":"TD260024","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-01-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"16127053","transaction_code":"A","transaction_date":"2026-01-07 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-13 21:40:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"Y","insp_carrier_state_id":"412253","created_at":"2026-01-16T10:36:07.000000Z","updated_at":"2026-01-24T10:31:03.000000Z","inspection_violations":[{"id":17904155,"change_date":"2026-01-13 21:40:00","inspection_id":"86782996","insp_violation_id":"271185792","seq_no":"6","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"211065491","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA244422","created_at":"2026-01-16T10:42:29.000000Z","updated_at":"2026-01-24T10:32:18.000000Z","normalized_code":"3963A1BOS"},{"id":17904156,"change_date":"2026-01-13 21:40:00","inspection_id":"86782996","insp_violation_id":"271185793","seq_no":"1","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"211065492","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:29.000000Z","updated_at":"2026-01-24T10:32:18.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":17904157,"change_date":"2026-01-13 21:40:00","inspection_id":"86782996","insp_violation_id":"271185794","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"211065491","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:29.000000Z","updated_at":"2026-01-24T10:32:18.000000Z","normalized_code":"39345B2BAIR"},{"id":17904158,"change_date":"2026-01-13 21:40:00","inspection_id":"86782996","insp_violation_id":"271185795","seq_no":"3","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"211065491","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:29.000000Z","updated_at":"2026-01-24T10:32:18.000000Z","normalized_code":"39345B2BAIR"},{"id":17904159,"change_date":"2026-01-13 21:40:00","inspection_id":"86782996","insp_violation_id":"271185796","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"211065491","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:29.000000Z","updated_at":"2026-01-24T10:32:19.000000Z","normalized_code":"39347E"},{"id":17904160,"change_date":"2026-01-13 21:40:00","inspection_id":"86782996","insp_violation_id":"271185797","seq_no":"5","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"211065491","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:29.000000Z","updated_at":"2026-01-24T10:32:19.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":17848551,"change_date":"2026-01-13 21:40:00","inspection_id":"86782996","insp_unit_id":"211065491","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"9E96120","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1FJ428892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:44.000000Z","updated_at":"2026-01-24T10:02:43.000000Z"},{"id":17848552,"change_date":"2026-01-13 21:40:00","inspection_id":"86782996","insp_unit_id":"211065492","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"4830","insp_unit_license":"4GE4082","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA96236W702128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:44.000000Z","updated_at":"2026-01-24T10:02:43.000000Z"}]},{"id":10462540,"change_date":"2025-12-17 21:39:00","inspection_id":"86595513","dot_number":"2201010","report_state":"CA","report_number":"NEK3002556","insp_date":"2025-12-16 00:00:00","insp_start_time":"1402","insp_end_time":"1429","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CALIFORNIA CUSTOM FRUITS & FLAVORS","shipping_paper_number":"2025-62477-00","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-12-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"16098697","transaction_code":"A","transaction_date":"2025-12-16 00:00:00","upload_date":"2025-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-17 21:39:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-12-20T10:31:48.000000Z","updated_at":"2025-12-28T10:31:07.000000Z","inspection_violations":[{"id":17551459,"change_date":"2025-12-17 21:39:00","inspection_id":"86595513","insp_violation_id":"270751745","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"210671453","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RM00417","created_at":"2025-12-20T10:32:26.000000Z","updated_at":"2025-12-28T10:31:52.000000Z","normalized_code":"39360D"},{"id":17551460,"change_date":"2025-12-17 21:39:00","inspection_id":"86595513","insp_violation_id":"270751746","seq_no":"2","part_no":"395","part_no_section":"8F4-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-12-20T10:32:26.000000Z","updated_at":"2025-12-28T10:31:52.000000Z","normalized_code":"3958F4HOSM"},{"id":17551461,"change_date":"2025-12-17 21:39:00","inspection_id":"86595513","insp_violation_id":"270751747","seq_no":"3","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-12-20T10:32:26.000000Z","updated_at":"2025-12-28T10:31:52.000000Z","normalized_code":"3958F7HOSM"}],"inspection_per_units":[{"id":17509629,"change_date":"2025-12-17 21:39:00","inspection_id":"86595513","insp_unit_id":"210671452","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5317","insp_unit_license":"4UA9049","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2535AU944208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:52.000000Z","updated_at":"2025-12-28T10:01:13.000000Z"},{"id":17509630,"change_date":"2025-12-17 21:39:00","inspection_id":"86595513","insp_unit_id":"210671453","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"24\/GRY","insp_unit_license":"9G14897","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X4FJ438669","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:52.000000Z","updated_at":"2025-12-28T10:01:13.000000Z"}]},{"id":10222810,"change_date":"2025-11-17 21:40:00","inspection_id":"86344630","dot_number":"2201010","report_state":"CA","report_number":"NEZA002534","insp_date":"2025-11-14 00:00:00","insp_start_time":"2009","insp_end_time":"2030","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FOUR STAR SALES","shipping_paper_number":"302216","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-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"16060661","transaction_code":"A","transaction_date":"2025-11-14 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-17 21:40:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-11-20T10:30:41.000000Z","updated_at":"2025-11-21T10:31:20.000000Z","inspection_violations":[{"id":16992629,"change_date":"2025-11-17 21:40:00","inspection_id":"86344630","insp_violation_id":"270019186","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210081294","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-11-20T10:31:17.000000Z","updated_at":"2025-11-21T10:32:28.000000Z","normalized_code":"3922SLLSR"},{"id":16992630,"change_date":"2025-11-17 21:40:00","inspection_id":"86344630","insp_violation_id":"270019187","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"210081294","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA242175","created_at":"2025-11-20T10:31:17.000000Z","updated_at":"2025-11-21T10:32:28.000000Z","normalized_code":"39395F"},{"id":16992631,"change_date":"2025-11-17 21:40:00","inspection_id":"86344630","insp_violation_id":"270019188","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"210081295","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-11-20T10:31:17.000000Z","updated_at":"2025-11-21T10:32:28.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":17031565,"change_date":"2025-11-17 21:40:00","inspection_id":"86344630","insp_unit_id":"210081294","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6","insp_unit_license":"9F40824","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD67ESFM1309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:45.000000Z","updated_at":"2025-11-21T10:01:38.000000Z"},{"id":17031566,"change_date":"2025-11-17 21:40:00","inspection_id":"86344630","insp_unit_id":"210081295","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5310","insp_unit_license":"4EX9502","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25375U434920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:45.000000Z","updated_at":"2025-11-21T10:01:38.000000Z"}]},{"id":9843931,"change_date":"2025-10-02 21:43:00","inspection_id":"85945492","dot_number":"2201010","report_state":"CA","report_number":"NFFX000872","insp_date":"2025-09-30 00:00:00","insp_start_time":"0033","insp_end_time":"0107","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FOUR STAR SALES INC","shipping_paper_number":"013870916184","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-10-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"16001567","transaction_code":"A","transaction_date":"2025-09-30 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-02 21:43:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-10-05T10:02:03.000000Z","updated_at":"2025-10-05T10:02:03.000000Z","inspection_violations":[{"id":16208716,"change_date":"2025-10-02 21:43:00","inspection_id":"85945492","insp_violation_id":"269070081","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"209276006","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA244312","created_at":"2025-10-05T10:17:53.000000Z","updated_at":"2025-10-05T10:17:53.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":16323939,"change_date":"2025-10-02 21:43:00","inspection_id":"85945492","insp_unit_id":"209276005","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6","insp_unit_license":"9F40824","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD67ESFM1309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:06.000000Z","updated_at":"2025-10-05T09:47:06.000000Z"},{"id":16323940,"change_date":"2025-10-02 21:43:00","inspection_id":"85945492","insp_unit_id":"209276006","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5310","insp_unit_license":"4EX9502","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25375U434920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:06.000000Z","updated_at":"2025-10-05T09:47:06.000000Z"}]},{"id":9526099,"change_date":"2025-08-27 21:41:00","inspection_id":"85612039","dot_number":"2201010","report_state":"CA","report_number":"UGM6002193","insp_date":"2025-08-26 00:00:00","insp_start_time":"1451","insp_end_time":"1531","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"N\/B SR-99 JNO SR-119","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15954893","transaction_code":"A","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-27 21:41:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-09-05T10:47:26.000000Z","updated_at":"2025-09-06T10:41:57.000000Z","inspection_violations":[{"id":15547128,"change_date":"2025-08-27 21:41:00","inspection_id":"85612039","insp_violation_id":"268297016","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD25231","created_at":"2025-09-05T10:50:42.000000Z","updated_at":"2025-09-06T10:45:13.000000Z","normalized_code":"3922SLLCP"},{"id":15547129,"change_date":"2025-08-27 21:41:00","inspection_id":"85612039","insp_violation_id":"268297017","seq_no":"2","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":"SD25231","created_at":"2025-09-05T10:50:42.000000Z","updated_at":"2025-09-06T10:45:13.000000Z","normalized_code":"3958A1HOSP"},{"id":15547130,"change_date":"2025-08-27 21:41:00","inspection_id":"85612039","insp_violation_id":"268297018","seq_no":"3","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"208621376","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD25232","created_at":"2025-09-05T10:50:42.000000Z","updated_at":"2025-09-06T10:45:13.000000Z","normalized_code":"3939ALFTSI"},{"id":15547131,"change_date":"2025-08-27 21:41:00","inspection_id":"85612039","insp_violation_id":"268297019","seq_no":"4","part_no":"393","part_no_section":"11B-CSURR","insp_viol_unit":"2","insp_unit_id":"208621377","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:50:42.000000Z","updated_at":"2025-09-06T10:45:13.000000Z","normalized_code":"39311BCSURR"},{"id":15547132,"change_date":"2025-08-27 21:41:00","inspection_id":"85612039","insp_violation_id":"268297020","seq_no":"5","part_no":"393","part_no_section":"11B-CSRIGRR","insp_viol_unit":"2","insp_unit_id":"208621377","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:50:42.000000Z","updated_at":"2025-09-06T10:45:13.000000Z","normalized_code":"39311BCSRIGRR"},{"id":15547133,"change_date":"2025-08-27 21:41:00","inspection_id":"85612039","insp_violation_id":"268297021","seq_no":"6","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"208621377","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:50:42.000000Z","updated_at":"2025-09-06T10:45:13.000000Z","normalized_code":"3939ALLPL"},{"id":15547134,"change_date":"2025-08-27 21:41:00","inspection_id":"85612039","insp_violation_id":"268297022","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"208621377","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD25233","created_at":"2025-09-05T10:50:42.000000Z","updated_at":"2025-09-06T10:45:13.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15721659,"change_date":"2025-08-27 21:41:00","inspection_id":"85612039","insp_unit_id":"208621376","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"9G49763","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD50GSGX6741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:43.000000Z","updated_at":"2025-09-09T09:46:22.000000Z"},{"id":15721660,"change_date":"2025-08-27 21:41:00","inspection_id":"85612039","insp_unit_id":"208621377","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"4830","insp_unit_license":"4GE4082","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA96236W702128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:43.000000Z","updated_at":"2025-09-09T09:46:22.000000Z"}]},{"id":9526603,"change_date":"2025-08-27 21:41:00","inspection_id":"85612566","dot_number":"2201010","report_state":"CA","report_number":"NEK3002286","insp_date":"2025-08-26 00:00:00","insp_start_time":"1605","insp_end_time":"1630","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KALIROY FRESH, LLC","shipping_paper_number":"0181822","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-08-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15954326","transaction_code":"A","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-27 21:41:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-09-05T10:47:27.000000Z","updated_at":"2025-09-06T10:42:00.000000Z","inspection_violations":[{"id":15547954,"change_date":"2025-08-27 21:41:00","inspection_id":"85612566","insp_violation_id":"268297912","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"208622211","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:50:43.000000Z","updated_at":"2025-09-06T10:45:16.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":15722449,"change_date":"2025-08-27 21:41:00","inspection_id":"85612566","insp_unit_id":"208622210","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6\/WHT","insp_unit_license":"9F40824","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD67ESFM1309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:44.000000Z","updated_at":"2025-09-09T09:46:25.000000Z"},{"id":15722450,"change_date":"2025-08-27 21:41:00","inspection_id":"85612566","insp_unit_id":"208622211","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5315","insp_unit_license":"38224F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS2536YM036313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:44.000000Z","updated_at":"2025-09-09T09:46:25.000000Z"}]},{"id":9337560,"change_date":"2025-08-05 21:39:00","inspection_id":"85413754","dot_number":"2201010","report_state":"CA","report_number":"UGM6002141","insp_date":"2025-08-04 00:00:00","insp_start_time":"1945","insp_end_time":"2013","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"S\/B SR-99 JNO WHITE LANE","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ILLUME AG SALES","shipping_paper_number":"2570696","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15925850","transaction_code":"A","transaction_date":"2025-08-04 00:00:00","upload_date":"2025-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-05 21:39:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-08-08T10:01:25.000000Z","updated_at":"2025-08-12T10:42:08.000000Z","inspection_violations":[{"id":15156247,"change_date":"2025-08-05 21:39:00","inspection_id":"85413754","insp_violation_id":"267856144","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"208253219","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD24506","created_at":"2025-08-08T10:45:01.000000Z","updated_at":"2025-08-09T10:44:57.000000Z","normalized_code":"3922SLLEQP"},{"id":15156248,"change_date":"2025-08-05 21:39:00","inspection_id":"85413754","insp_violation_id":"267856145","seq_no":"2","part_no":"393","part_no_section":"43B-BATV","insp_viol_unit":"1","insp_unit_id":"208253219","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:45:01.000000Z","updated_at":"2025-08-09T10:44:57.000000Z","normalized_code":"39343BBATV"},{"id":15156249,"change_date":"2025-08-05 21:39:00","inspection_id":"85413754","insp_violation_id":"267856146","seq_no":"3","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"1","insp_unit_id":"208253219","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:45:01.000000Z","updated_at":"2025-08-09T10:44:57.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":15156250,"change_date":"2025-08-05 21:39:00","inspection_id":"85413754","insp_violation_id":"267856147","seq_no":"4","part_no":"395","part_no_section":"24D-ELDPT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:45:01.000000Z","updated_at":"2025-08-09T10:44:57.000000Z","normalized_code":"39524DELDPT"},{"id":15156251,"change_date":"2025-08-05 21:39:00","inspection_id":"85413754","insp_violation_id":"267856148","seq_no":"5","part_no":"393","part_no_section":"205C-WRAWFLMIB","insp_viol_unit":"1","insp_unit_id":"208253219","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:45:01.000000Z","updated_at":"2025-08-09T10:44:57.000000Z","normalized_code":"393205CWRAWFLMIB"},{"id":15156252,"change_date":"2025-08-05 21:39:00","inspection_id":"85413754","insp_violation_id":"267856149","seq_no":"6","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"208253219","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD24506","created_at":"2025-08-08T10:45:01.000000Z","updated_at":"2025-08-09T10:44:57.000000Z","normalized_code":"3922SLLEQP"},{"id":15156253,"change_date":"2025-08-05 21:39:00","inspection_id":"85413754","insp_violation_id":"267856150","seq_no":"7","part_no":"393","part_no_section":"11B-CSRIGRR","insp_viol_unit":"2","insp_unit_id":"208253220","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:45:01.000000Z","updated_at":"2025-08-09T10:44:57.000000Z","normalized_code":"39311BCSRIGRR"}],"inspection_per_units":[{"id":15379425,"change_date":"2025-08-05 21:39:00","inspection_id":"85413754","insp_unit_id":"208253219","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"9E96120","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1FJ428892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-08T09:46:37.000000Z","updated_at":"2025-08-09T09:46:11.000000Z"},{"id":15379426,"change_date":"2025-08-05 21:39:00","inspection_id":"85413754","insp_unit_id":"208253220","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"525","insp_unit_license":"4PB2198","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0626CW704107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-08T09:46:37.000000Z","updated_at":"2025-08-09T09:46:11.000000Z"}]},{"id":9107042,"change_date":"2025-07-09 21:43:00","inspection_id":"85171353","dot_number":"2201010","report_state":"CA","report_number":"UCJ1000140","insp_date":"2025-07-07 00:00:00","insp_start_time":"1335","insp_end_time":"1359","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"065","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15890016","transaction_code":"A","transaction_date":"2025-07-07 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-09 21:43:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-07-12T10:45:33.000000Z","updated_at":"2025-07-14T10:46:34.000000Z","inspection_violations":[{"id":14675953,"change_date":"2025-07-09 21:43:00","inspection_id":"85171353","insp_violation_id":"267311305","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"2","insp_unit_id":"207789662","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RP68554","created_at":"2025-07-13T10:49:22.000000Z","updated_at":"2025-07-13T10:49:22.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":14949513,"change_date":"2025-07-09 21:43:00","inspection_id":"85171353","insp_unit_id":"207789661","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"31 \/ WHT","insp_unit_license":"9G14896","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYDP9X7FJ452129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:59.000000Z","updated_at":"2025-07-13T09:46:45.000000Z"},{"id":14949514,"change_date":"2025-07-09 21:43:00","inspection_id":"85171353","insp_unit_id":"207789662","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5315 \/ SIL","insp_unit_license":"38224F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS2536YM036313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:59.000000Z","updated_at":"2025-07-13T09:46:45.000000Z"}]},{"id":9034655,"change_date":"2025-06-30 21:40:00","inspection_id":"85095071","dot_number":"2201010","report_state":"CA","report_number":"UDYA000265","insp_date":"2025-06-29 00:00:00","insp_start_time":"0830","insp_end_time":"0849","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15879624","transaction_code":"A","transaction_date":"2025-06-29 00:00:00","upload_date":"2025-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-30 21:40:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-07-03T10:01:57.000000Z","updated_at":"2025-07-04T10:00:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14819339,"change_date":"2025-06-30 21:40:00","inspection_id":"85095071","insp_unit_id":"207647034","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"GRY\/24","insp_unit_license":"9G14897","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X4FJ438669","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-03T09:45:42.000000Z","updated_at":"2025-07-04T09:46:16.000000Z"},{"id":14819340,"change_date":"2025-06-30 21:40:00","inspection_id":"85095071","insp_unit_id":"207647035","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"WHT\/2X","insp_unit_license":"4NP9969","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5322FL004107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-03T09:45:42.000000Z","updated_at":"2025-07-04T09:46:16.000000Z"}]},{"id":8855994,"change_date":"2025-06-09 21:42:00","inspection_id":"84906030","dot_number":"2201010","report_state":"CA","report_number":"UDK5002768","insp_date":"2025-06-07 00:00:00","insp_start_time":"1035","insp_end_time":"1050","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15853116","transaction_code":"A","transaction_date":"2025-06-07 00:00:00","upload_date":"2025-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-09 21:42:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:36.000000Z","updated_at":"2025-06-14T10:00:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14501864,"change_date":"2025-06-09 21:42:00","inspection_id":"84906030","insp_unit_id":"207300847","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"83-WHT","insp_unit_license":"9G90284","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR3CSBH9256","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:37.000000Z","updated_at":"2025-06-13T09:45:37.000000Z"},{"id":14501865,"change_date":"2025-06-09 21:42:00","inspection_id":"84906030","insp_unit_id":"207300848","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5310","insp_unit_license":"4EX9502","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25375U434920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:37.000000Z","updated_at":"2025-06-13T09:45:37.000000Z"}]},{"id":8856257,"change_date":"2025-06-09 21:42:00","inspection_id":"84906301","dot_number":"2201010","report_state":"CA","report_number":"UDYA000194","insp_date":"2025-06-07 00:00:00","insp_start_time":"0915","insp_end_time":"0934","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15853808","transaction_code":"A","transaction_date":"2025-06-07 00:00:00","upload_date":"2025-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-09 21:42:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:36.000000Z","updated_at":"2025-06-14T10:00:36.000000Z","inspection_violations":[{"id":14183906,"change_date":"2025-06-09 21:42:00","inspection_id":"84906301","insp_violation_id":"266748250","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":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:59.000000Z","updated_at":"2025-06-13T10:18:03.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":14502255,"change_date":"2025-06-09 21:42:00","inspection_id":"84906301","insp_unit_id":"207301264","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/#6","insp_unit_license":"9F40824","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD67ESFM1309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:37.000000Z","updated_at":"2025-06-13T09:45:37.000000Z"},{"id":14502256,"change_date":"2025-06-09 21:42:00","inspection_id":"84906301","insp_unit_id":"207301265","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT\/#5308","insp_unit_license":"4HZ1880","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA06298W701502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:37.000000Z","updated_at":"2025-06-13T09:45:37.000000Z"}]},{"id":9106520,"change_date":"2025-07-09 21:43:00","inspection_id":"85170818","dot_number":"2201010","report_state":"CA","report_number":"NE3R003256","insp_date":"2025-06-06 00:00:00","insp_start_time":"0746","insp_end_time":"0848","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"12499 GARZOLI AVE  MCFARLAND","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15891385","transaction_code":"A","transaction_date":"2025-06-06 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-09 21:43:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-07-12T10:45:32.000000Z","updated_at":"2025-07-14T10:46:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14948738,"change_date":"2025-07-09 21:43:00","inspection_id":"85170818","insp_unit_id":"207788831","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"24","insp_unit_license":"9G14897","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X4FJ438669","insp_unit_decal":"Y","insp_unit_decal_number":"35065471","created_at":"2025-07-12T09:45:58.000000Z","updated_at":"2025-07-13T09:46:42.000000Z"},{"id":14948739,"change_date":"2025-07-09 21:43:00","inspection_id":"85170818","insp_unit_id":"207788832","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEG","insp_unit_company":"WHITE","insp_unit_license":"4NP9969","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5322FL004107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:58.000000Z","updated_at":"2025-07-13T09:46:43.000000Z"}]},{"id":9106521,"change_date":"2025-07-09 21:43:00","inspection_id":"85170819","dot_number":"2201010","report_state":"CA","report_number":"NE3R003257","insp_date":"2025-06-06 00:00:00","insp_start_time":"0849","insp_end_time":"0925","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"12499 GARZOLI AVE  MCFARLAND","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15891386","transaction_code":"A","transaction_date":"2025-06-06 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-09 21:43:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-07-12T10:45:32.000000Z","updated_at":"2025-07-14T10:46:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14948740,"change_date":"2025-07-09 21:43:00","inspection_id":"85170819","insp_unit_id":"207788833","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"9E96120","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1FJ428892","insp_unit_decal":"Y","insp_unit_decal_number":"35065472","created_at":"2025-07-12T09:45:58.000000Z","updated_at":"2025-07-13T09:46:43.000000Z"},{"id":14948741,"change_date":"2025-07-09 21:43:00","inspection_id":"85170819","insp_unit_id":"207788834","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHITE","insp_unit_license":"4PB2198","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0626CW704107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:58.000000Z","updated_at":"2025-07-13T09:46:43.000000Z"}]},{"id":9106586,"change_date":"2025-07-09 21:43:00","inspection_id":"85170886","dot_number":"2201010","report_state":"CA","report_number":"NE3R003258","insp_date":"2025-06-06 00:00:00","insp_start_time":"0926","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"12499 GARZOLI AVE  MCFARLAND","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"15891387","transaction_code":"A","transaction_date":"2025-06-06 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-09 21:43:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-07-12T10:45:32.000000Z","updated_at":"2025-07-14T10:46:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14948848,"change_date":"2025-07-09 21:43:00","inspection_id":"85170886","insp_unit_id":"207788952","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"31","insp_unit_license":"9G14896","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYDP9X7FJ452129","insp_unit_decal":"Y","insp_unit_decal_number":"35065473","created_at":"2025-07-12T09:45:58.000000Z","updated_at":"2025-07-13T09:46:43.000000Z"},{"id":14948849,"change_date":"2025-07-09 21:43:00","inspection_id":"85170886","insp_unit_id":"207788953","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"606","insp_unit_license":"4UA9049","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2535AU944208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:58.000000Z","updated_at":"2025-07-13T09:46:43.000000Z"}]},{"id":9106587,"change_date":"2025-07-09 21:43:00","inspection_id":"85170887","dot_number":"2201010","report_state":"CA","report_number":"NE3R003259","insp_date":"2025-06-06 00:00:00","insp_start_time":"1003","insp_end_time":"1043","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"12499 GARZOLI AVE  MCFARLAND","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","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":"15891388","transaction_code":"A","transaction_date":"2025-06-06 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-09 21:43:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-07-12T10:45:32.000000Z","updated_at":"2025-07-14T10:46:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14948850,"change_date":"2025-07-09 21:43:00","inspection_id":"85170887","insp_unit_id":"207788954","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"UTIL","insp_unit_company":"5321","insp_unit_license":"4UZ4458","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539HP875841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:58.000000Z","updated_at":"2025-07-13T09:46:43.000000Z"}]},{"id":8808305,"change_date":"2025-06-03 21:41:00","inspection_id":"84855469","dot_number":"2201010","report_state":"CA","report_number":"NFCT000652","insp_date":"2025-06-02 00:00:00","insp_start_time":"1547","insp_end_time":"1606","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15845397","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-03 21:41:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-06T10:01:08.000000Z","updated_at":"2025-06-07T10:00:48.000000Z","inspection_violations":[{"id":14092546,"change_date":"2025-06-03 21:41:00","inspection_id":"84855469","insp_violation_id":"266644537","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207209078","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:51.000000Z","updated_at":"2025-06-07T10:17:59.000000Z","normalized_code":"3922SLLSR"},{"id":14092547,"change_date":"2025-06-03 21:41:00","inspection_id":"84855469","insp_violation_id":"266644538","seq_no":"2","part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"1","insp_unit_id":"207209078","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:51.000000Z","updated_at":"2025-06-07T10:17:59.000000Z","normalized_code":"39355D2B"}],"inspection_per_units":[{"id":14417238,"change_date":"2025-06-03 21:41:00","inspection_id":"84855469","insp_unit_id":"207209078","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHT\/07","insp_unit_license":"9E96120","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1FJ428892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:52.000000Z","updated_at":"2025-06-07T09:46:02.000000Z"},{"id":14417239,"change_date":"2025-06-03 21:41:00","inspection_id":"84855469","insp_unit_id":"207209079","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT\/53","insp_unit_license":"4PB2198","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0626CW704107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:52.000000Z","updated_at":"2025-06-07T09:46:02.000000Z"}]},{"id":8397247,"change_date":"2025-04-16 21:41:00","inspection_id":"84421870","dot_number":"2201010","report_state":"CA","report_number":"UGM6001759","insp_date":"2025-04-15 00:00:00","insp_start_time":"1433","insp_end_time":"1504","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD AREA","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VANGUARD DIRECT","shipping_paper_number":"111406","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15783103","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-16 21:41:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-04-19T10:19:41.000000Z","updated_at":"2025-04-20T10:27:20.000000Z","inspection_violations":[{"id":13243936,"change_date":"2025-04-16 21:41:00","inspection_id":"84421870","insp_violation_id":"265668799","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ96888","created_at":"2025-04-18T11:21:39.000000Z","updated_at":"2025-04-20T10:52:17.000000Z","normalized_code":"3922SLLCP"},{"id":13243937,"change_date":"2025-04-16 21:41:00","inspection_id":"84421870","insp_violation_id":"265668800","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"206352906","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"RJ96888","created_at":"2025-04-18T11:21:39.000000Z","updated_at":"2025-04-20T10:52:17.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":13630953,"change_date":"2025-04-16 21:41:00","inspection_id":"84421870","insp_unit_id":"206352905","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"83","insp_unit_license":"9G90284","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR3CSBH9256","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:13:18.000000Z","updated_at":"2025-04-20T10:07:09.000000Z"},{"id":13630954,"change_date":"2025-04-16 21:41:00","inspection_id":"84421870","insp_unit_id":"206352906","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"610","insp_unit_license":"4UA9039","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W68L100731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:13:18.000000Z","updated_at":"2025-04-20T10:07:09.000000Z"}]},{"id":8357517,"change_date":"2025-04-11 21:41:00","inspection_id":"84380025","dot_number":"2201010","report_state":"CA","report_number":"NFCT000492","insp_date":"2025-04-11 00:00:00","insp_start_time":"0049","insp_end_time":"0149","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15776547","transaction_code":"A","transaction_date":"2025-04-11 00:00:00","upload_date":"2025-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-11 21:41:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-14T10:29:57.000000Z","updated_at":"2025-04-15T10:16:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13560599,"change_date":"2025-04-11 21:41:00","inspection_id":"84380025","insp_unit_id":"206276758","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRY\/08","insp_unit_license":"9G49763","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD50GSGX6741","insp_unit_decal":"Y","insp_unit_decal_number":"35074145","created_at":"2025-04-14T10:20:58.000000Z","updated_at":"2025-04-15T10:07:51.000000Z"},{"id":13560600,"change_date":"2025-04-11 21:41:00","inspection_id":"84380025","insp_unit_id":"206276759","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT\/4830","insp_unit_license":"4GE4082","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA96236W702128","insp_unit_decal":"Y","insp_unit_decal_number":"35074146","created_at":"2025-04-14T10:20:58.000000Z","updated_at":"2025-04-15T10:07:51.000000Z"}]},{"id":8299397,"change_date":"2025-04-04 21:41:00","inspection_id":"84318871","dot_number":"2201010","report_state":"CA","report_number":"UGM6001698","insp_date":"2025-04-03 00:00:00","insp_start_time":"1335","insp_end_time":"1403","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD AREA","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15767458","transaction_code":"A","transaction_date":"2025-04-03 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-04 21:41:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-04-07T10:22:21.000000Z","updated_at":"2025-04-08T10:10:03.000000Z","inspection_violations":[{"id":13051882,"change_date":"2025-04-04 21:41:00","inspection_id":"84318871","insp_violation_id":"265452101","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"206164345","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ96178","created_at":"2025-04-07T10:54:17.000000Z","updated_at":"2025-04-07T11:02:55.000000Z","normalized_code":"3922SLLEQP"},{"id":13051883,"change_date":"2025-04-04 21:41:00","inspection_id":"84318871","insp_violation_id":"265452102","seq_no":"2","part_no":"393","part_no_section":"43B-BATV","insp_viol_unit":"1","insp_unit_id":"206164345","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:54:17.000000Z","updated_at":"2025-04-07T11:02:55.000000Z","normalized_code":"39343BBATV"},{"id":13051884,"change_date":"2025-04-04 21:41:00","inspection_id":"84318871","insp_violation_id":"265452103","seq_no":"3","part_no":"392","part_no_section":"71A-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ96177","created_at":"2025-04-07T10:54:17.000000Z","updated_at":"2025-04-07T11:02:55.000000Z","normalized_code":"39271AD"},{"id":13051885,"change_date":"2025-04-04 21:41:00","inspection_id":"84318871","insp_violation_id":"265452104","seq_no":"4","part_no":"393","part_no_section":"11B-CSRIGRR","insp_viol_unit":"2","insp_unit_id":"206164346","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:54:17.000000Z","updated_at":"2025-04-07T11:02:55.000000Z","normalized_code":"39311BCSRIGRR"},{"id":13051886,"change_date":"2025-04-04 21:41:00","inspection_id":"84318871","insp_violation_id":"265452105","seq_no":"5","part_no":"396","part_no_section":"3A1-AASGMD-L6","insp_viol_unit":"2","insp_unit_id":"206164346","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:54:17.000000Z","updated_at":"2025-04-07T11:02:55.000000Z","normalized_code":"3963A1AASGMDL6"}],"inspection_per_units":[{"id":13456616,"change_date":"2025-04-04 21:41:00","inspection_id":"84318871","insp_unit_id":"206164345","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"31","insp_unit_license":"9G14896","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYDP9X7FJ452129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:14:04.000000Z","updated_at":"2025-04-08T10:03:17.000000Z"},{"id":13456617,"change_date":"2025-04-04 21:41:00","inspection_id":"84318871","insp_unit_id":"206164346","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"606","insp_unit_license":"4UA9049","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2535AU944208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:14:04.000000Z","updated_at":"2025-04-08T10:03:17.000000Z"}]},{"id":8243365,"change_date":"2025-03-28 21:42:00","inspection_id":"84259920","dot_number":"2201010","report_state":"CA","report_number":"NECL003002","insp_date":"2025-03-28 00:00:00","insp_start_time":"0615","insp_end_time":"0655","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FRUPCO EXPIDITING & SERVICES","shipping_paper_number":"PB25218-2","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-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15760445","transaction_code":"A","transaction_date":"2025-03-28 00:00:00","upload_date":"2025-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-28 21:42:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-03-31T10:33:03.000000Z","updated_at":"2025-04-01T10:14:42.000000Z","inspection_violations":[{"id":12942662,"change_date":"2025-03-28 21:42:00","inspection_id":"84259920","insp_violation_id":"265328188","seq_no":"1","part_no":"396","part_no_section":"3A1-AASGMD-L6","insp_viol_unit":"2","insp_unit_id":"206056476","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-31T11:17:59.000000Z","updated_at":"2025-03-31T11:27:20.000000Z","normalized_code":"3963A1AASGMDL6"},{"id":12942663,"change_date":"2025-03-28 21:42:00","inspection_id":"84259920","insp_violation_id":"265328189","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"206056475","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RM00067","created_at":"2025-03-31T11:17:59.000000Z","updated_at":"2025-03-31T11:27:20.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":13337150,"change_date":"2025-03-28 21:42:00","inspection_id":"84259920","insp_unit_id":"206056475","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"GRY3X","insp_unit_license":"9F59031","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X3DR340362","insp_unit_decal":"Y","insp_unit_decal_number":"34791269","created_at":"2025-03-31T10:25:23.000000Z","updated_at":"2025-04-01T10:06:14.000000Z"},{"id":13337151,"change_date":"2025-03-28 21:42:00","inspection_id":"84259920","insp_unit_id":"206056476","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT2X","insp_unit_license":"4GE4082","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA96236W702128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-31T10:25:23.000000Z","updated_at":"2025-04-01T10:06:14.000000Z"}]},{"id":8075738,"change_date":"2025-03-10 21:39:00","inspection_id":"84083445","dot_number":"2201010","report_state":"CA","report_number":"UEA9000595","insp_date":"2025-03-08 00:00:00","insp_start_time":"1135","insp_end_time":"1155","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15733441","transaction_code":"A","transaction_date":"2025-03-08 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-10 21:39:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-03-17T21:05:53.000000Z","updated_at":"2025-03-17T21:05:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13038952,"change_date":"2025-03-10 21:39:00","inspection_id":"84083445","insp_unit_id":"205719898","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9E96120","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1FJ428892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:05.000000Z","updated_at":"2025-03-17T23:59:05.000000Z"},{"id":13038953,"change_date":"2025-03-10 21:39:00","inspection_id":"84083445","insp_unit_id":"205719899","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UA9039","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W68L100731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:05.000000Z","updated_at":"2025-03-17T23:59:05.000000Z"}]},{"id":7958910,"change_date":"2025-02-25 21:40:00","inspection_id":"83960565","dot_number":"2201010","report_state":"CA","report_number":"NECL002881","insp_date":"2025-02-25 00:00:00","insp_start_time":"1130","insp_end_time":"1157","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15717348","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-25 21:40:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-03-17T21:03:19.000000Z","updated_at":"2025-03-17T21:03:19.000000Z","inspection_violations":[{"id":12437176,"change_date":"2025-02-25 21:40:00","inspection_id":"83960565","insp_violation_id":"264696466","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"205495529","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"3922SLLEQP"},{"id":12437177,"change_date":"2025-02-25 21:40:00","inspection_id":"83960565","insp_violation_id":"264696467","seq_no":"2","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"205495529","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"39355D1B"},{"id":12437178,"change_date":"2025-02-25 21:40:00","inspection_id":"83960565","insp_violation_id":"264696468","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"205495529","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"39360C"},{"id":12437179,"change_date":"2025-02-25 21:40:00","inspection_id":"83960565","insp_violation_id":"264696469","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"205495529","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"39395F"},{"id":12437180,"change_date":"2025-02-25 21:40:00","inspection_id":"83960565","insp_violation_id":"264696470","seq_no":"5","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"205495529","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":12847979,"change_date":"2025-02-25 21:40:00","inspection_id":"83960565","insp_unit_id":"205495529","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT3X","insp_unit_license":"9F40824","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD67ESFM1309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:55.000000Z","updated_at":"2025-03-17T23:56:55.000000Z"},{"id":12847980,"change_date":"2025-02-25 21:40:00","inspection_id":"83960565","insp_unit_id":"205495530","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT2X","insp_unit_license":"4HZ1880","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA06298W701502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:55.000000Z","updated_at":"2025-03-17T23:56:55.000000Z"}]},{"id":7730660,"change_date":"2025-01-28 21:39:00","inspection_id":"83720794","dot_number":"2201010","report_state":"CA","report_number":"UEHJ005239","insp_date":"2025-01-24 00:00:00","insp_start_time":"2150","insp_end_time":"2224","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CAL DIAMOND","shipping_paper_number":"87743","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-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15680755","transaction_code":"A","transaction_date":"2025-01-24 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-28 21:39:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-03-17T20:58:42.000000Z","updated_at":"2025-03-17T20:58:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12475254,"change_date":"2025-01-28 21:39:00","inspection_id":"83720794","insp_unit_id":"205048957","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6","insp_unit_license":"9F40824","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD67ESFM1309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:40.000000Z","updated_at":"2025-03-17T23:52:40.000000Z"},{"id":12475255,"change_date":"2025-01-28 21:39:00","inspection_id":"83720794","insp_unit_id":"205048958","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"5308","insp_unit_license":"4HZ1880","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA06298W701502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:40.000000Z","updated_at":"2025-03-17T23:52:40.000000Z"}]},{"id":7187370,"change_date":"2024-11-13 21:40:00","inspection_id":"83149451","dot_number":"2201010","report_state":"CA","report_number":"NDOG005771","insp_date":"2024-11-12 00:00:00","insp_start_time":"1155","insp_end_time":"1235","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"CONEJO CVEF","county_code_state":"CA","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"15591933","transaction_code":"A","transaction_date":"2024-11-12 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-13 21:40:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-03-17T20:46:00.000000Z","updated_at":"2025-03-17T20:46:00.000000Z","inspection_violations":[{"id":11232727,"change_date":"2024-11-13 21:40:00","inspection_id":"83149451","insp_violation_id":"262881772","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"203867667","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"39360D"},{"id":11232728,"change_date":"2024-11-13 21:40:00","inspection_id":"83149451","insp_violation_id":"262881773","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"203867667","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"3922SLLEQP"},{"id":11232729,"change_date":"2024-11-13 21:40:00","inspection_id":"83149451","insp_violation_id":"262881774","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"203867667","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"39345DB"},{"id":11232730,"change_date":"2024-11-13 21:40:00","inspection_id":"83149451","insp_violation_id":"262881775","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"203867668","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"3922SLLSR"},{"id":11232731,"change_date":"2024-11-13 21:40:00","inspection_id":"83149451","insp_violation_id":"262881776","seq_no":"5","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"2","insp_unit_id":"203867668","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"3965BHWSL"}],"inspection_per_units":[{"id":11592999,"change_date":"2024-11-13 21:40:00","inspection_id":"83149451","insp_unit_id":"203867667","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"9F59031","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X3DR340362","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:07.000000Z","updated_at":"2025-03-17T23:43:07.000000Z"},{"id":11593000,"change_date":"2024-11-13 21:40:00","inspection_id":"83149451","insp_unit_id":"203867668","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"T-525","insp_unit_license":"4PB2198","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0626CW704107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:07.000000Z","updated_at":"2025-03-17T23:43:07.000000Z"}]},{"id":7179452,"change_date":"2024-11-12 21:42:00","inspection_id":"83141044","dot_number":"2201010","report_state":"CA","report_number":"UDM0002049","insp_date":"2024-11-10 00:00:00","insp_start_time":"1015","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15589540","transaction_code":"A","transaction_date":"2024-11-10 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-12 21:42:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-03-17T20:45:38.000000Z","updated_at":"2025-03-17T20:45:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11580304,"change_date":"2024-11-12 21:42:00","inspection_id":"83141044","insp_unit_id":"203851232","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHT\/07","insp_unit_license":"9E96120","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1FJ428892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:01.000000Z","updated_at":"2025-03-17T23:43:01.000000Z"},{"id":11580305,"change_date":"2024-11-12 21:42:00","inspection_id":"83141044","insp_unit_id":"203851233","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"4830","insp_unit_license":"4GE4082","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA96236W702128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:01.000000Z","updated_at":"2025-03-17T23:43:01.000000Z"}]},{"id":6772780,"change_date":"2024-09-19 21:42:00","inspection_id":"82709056","dot_number":"2201010","report_state":"CA","report_number":"NEDJ003098","insp_date":"2024-09-18 00:00:00","insp_start_time":"0323","insp_end_time":"0420","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUN PACIFIC","shipping_paper_number":"493587","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-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15528019","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-03-17T20:37:21.000000Z","updated_at":"2025-03-17T20:37:21.000000Z","inspection_violations":[{"id":10548429,"change_date":"2024-09-19 21:42:00","inspection_id":"82709056","insp_violation_id":"261932218","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203036568","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"39347E"},{"id":10548430,"change_date":"2024-09-19 21:42:00","inspection_id":"82709056","insp_violation_id":"261932219","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203036568","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"39347E"},{"id":10548431,"change_date":"2024-09-19 21:42:00","inspection_id":"82709056","insp_violation_id":"261932220","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"203036568","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"39353B"},{"id":10548432,"change_date":"2024-09-19 21:42:00","inspection_id":"82709056","insp_violation_id":"261932221","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203036568","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3963A1"},{"id":10548433,"change_date":"2024-09-19 21:42:00","inspection_id":"82709056","insp_violation_id":"261932222","seq_no":"5","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":"1","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3958A1"},{"id":10548434,"change_date":"2024-09-19 21:42:00","inspection_id":"82709056","insp_violation_id":"261932223","seq_no":"6","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"203036568","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":10921621,"change_date":"2024-09-19 21:42:00","inspection_id":"82709056","insp_unit_id":"203036568","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"9E96120","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1FJ428892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:09.000000Z","updated_at":"2025-03-17T23:36:09.000000Z"},{"id":10921622,"change_date":"2024-09-19 21:42:00","inspection_id":"82709056","insp_unit_id":"203036569","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"14453","insp_unit_license":"4PB2198","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0626CW704107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:09.000000Z","updated_at":"2025-03-17T23:36:09.000000Z"}]},{"id":6154791,"change_date":"2024-07-05 21:36:00","inspection_id":"82048971","dot_number":"2201010","report_state":"CA","report_number":"UF6N000348","insp_date":"2024-07-03 00:00:00","insp_start_time":"1900","insp_end_time":"1928","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CAL CARTAGE CES","shipping_paper_number":"86203-02","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-07-05 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15430397","transaction_code":"A","transaction_date":"2024-07-03 00:00:00","upload_date":"2024-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-05 21:36:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:38.000000Z","updated_at":"2025-03-17T20:24:38.000000Z","inspection_violations":[{"id":9552113,"change_date":"2024-07-05 21:36:00","inspection_id":"82048971","insp_violation_id":"260485783","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"201751384","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:13.000000Z","updated_at":"2025-03-17T21:52:13.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":9914307,"change_date":"2024-07-05 21:36:00","inspection_id":"82048971","insp_unit_id":"201751384","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"24 WHT","insp_unit_license":"9E80565","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X7DJ364114","insp_unit_decal":"Y","insp_unit_decal_number":"34169262","created_at":"2025-03-17T23:25:45.000000Z","updated_at":"2025-03-17T23:25:45.000000Z"},{"id":9914308,"change_date":"2024-07-05 21:36:00","inspection_id":"82048971","insp_unit_id":"201751385","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT 2X","insp_unit_license":"4UZ4458","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539HP875841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:45.000000Z","updated_at":"2025-03-17T23:25:45.000000Z"}]},{"id":6123470,"change_date":"2024-07-01 21:45:00","inspection_id":"82015286","dot_number":"2201010","report_state":"CA","report_number":"NECL001829","insp_date":"2024-06-29 00:00:00","insp_start_time":"1500","insp_end_time":"1524","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"R PLANET EARTH","shipping_paper_number":"SH6772","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-07-01 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15424400","transaction_code":"A","transaction_date":"2024-06-29 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-01 21:45:00","insp_carrier_name":"MEDINA EXPRESS","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:10.000000Z","updated_at":"2025-03-17T20:24:10.000000Z","inspection_violations":[{"id":9507648,"change_date":"2024-07-01 21:45:00","inspection_id":"82015286","insp_violation_id":"260421799","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201688130","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"39347E"},{"id":9507649,"change_date":"2024-07-01 21:45:00","inspection_id":"82015286","insp_violation_id":"260421800","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201688130","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"39353B"},{"id":9507650,"change_date":"2024-07-01 21:45:00","inspection_id":"82015286","insp_violation_id":"260421801","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"201688130","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":9863349,"change_date":"2024-07-01 21:45:00","inspection_id":"82015286","insp_unit_id":"201688130","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHT3X","insp_unit_license":"9E80565","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X7DJ364114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:12.000000Z","updated_at":"2025-03-17T23:25:12.000000Z"},{"id":9863350,"change_date":"2024-07-01 21:45:00","inspection_id":"82015286","insp_unit_id":"201688131","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT2X","insp_unit_license":"4UZ4458","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539HP875841","insp_unit_decal":"Y","insp_unit_decal_number":"33836952","created_at":"2025-03-17T23:25:12.000000Z","updated_at":"2025-03-17T23:25:12.000000Z"}]},{"id":5798299,"change_date":"2024-05-20 21:43:00","inspection_id":"81663108","dot_number":"2201010","report_state":"CA","report_number":"UDK5002149","insp_date":"2024-05-19 00:00:00","insp_start_time":"1030","insp_end_time":"1045","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15370734","transaction_code":"A","transaction_date":"2024-05-19 00:00:00","upload_date":"2024-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-20 21:43:00","insp_carrier_name":"ANDRES GERARDO MEDINA RODRIGUEZ","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:33.000000Z","updated_at":"2025-03-17T20:17:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9339006,"change_date":"2024-05-20 21:43:00","inspection_id":"81663108","insp_unit_id":"200993809","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"29\/WHT","insp_unit_license":"9E80565","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X7DJ364114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:56.000000Z","updated_at":"2025-03-17T23:19:56.000000Z"}]},{"id":5733703,"change_date":"2024-05-13 21:42:00","inspection_id":"81593479","dot_number":"2201010","report_state":"CA","report_number":"NABR007701","insp_date":"2024-05-12 00:00:00","insp_start_time":"1044","insp_end_time":"1120","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"15359518","transaction_code":"A","transaction_date":"2024-05-12 00:00:00","upload_date":"2024-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-13 21:42:00","insp_carrier_name":"ANDRES GERARDO MEDINA RODRIGUEZ","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"Y","insp_carrier_state_id":"412253","created_at":"2025-03-17T20:16:19.000000Z","updated_at":"2025-03-17T20:16:19.000000Z","inspection_violations":[{"id":8875365,"change_date":"2024-05-13 21:42:00","inspection_id":"81593479","insp_violation_id":"259473281","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"200863376","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"3963A1"},{"id":8875366,"change_date":"2024-05-13 21:42:00","inspection_id":"81593479","insp_violation_id":"259473282","seq_no":"2","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"200863376","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"393201A"},{"id":8875367,"change_date":"2024-05-13 21:42:00","inspection_id":"81593479","insp_violation_id":"259473283","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"200863376","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39375C"},{"id":8875368,"change_date":"2024-05-13 21:42:00","inspection_id":"81593479","insp_violation_id":"259473284","seq_no":"4","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"200863375","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"393209D"},{"id":8875369,"change_date":"2024-05-13 21:42:00","inspection_id":"81593479","insp_violation_id":"259473285","seq_no":"5","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"1","insp_unit_id":"200863375","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"393207F"}],"inspection_per_units":[{"id":9235191,"change_date":"2024-05-13 21:42:00","inspection_id":"81593479","insp_unit_id":"200863375","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"29\/WHT","insp_unit_license":"9E80565","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X7DJ364114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:57.000000Z","updated_at":"2025-03-17T23:18:57.000000Z"},{"id":9235192,"change_date":"2024-05-13 21:42:00","inspection_id":"81593479","insp_unit_id":"200863376","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"5308","insp_unit_license":"4HZ1880","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA06298W701502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:57.000000Z","updated_at":"2025-03-17T23:18:57.000000Z"}]},{"id":5760461,"change_date":"2024-05-15 21:44:00","inspection_id":"81622416","dot_number":"2201010","report_state":"CA","report_number":"UEHJ004703","insp_date":"2024-05-11 00:00:00","insp_start_time":"2050","insp_end_time":"2107","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUNKIST","shipping_paper_number":"497199","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-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15362925","transaction_code":"A","transaction_date":"2024-05-11 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-15 21:44:00","insp_carrier_name":"ANDRES GERARDO MEDINA RODRIGUEZ","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"Y","insp_carrier_state_id":"412253","created_at":"2025-03-17T20:17:03.000000Z","updated_at":"2025-03-17T20:17:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9278225,"change_date":"2024-05-15 21:44:00","inspection_id":"81622416","insp_unit_id":"200916684","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"9E96120","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1FJ428892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:21.000000Z","updated_at":"2025-03-17T23:19:21.000000Z"},{"id":9278226,"change_date":"2024-05-15 21:44:00","inspection_id":"81622416","insp_unit_id":"200916685","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5313","insp_unit_license":"4UZ4458","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539HP875841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:21.000000Z","updated_at":"2025-03-17T23:19:21.000000Z"}]},{"id":5547009,"change_date":"2024-04-18 21:40:00","inspection_id":"81390285","dot_number":"2201010","report_state":"CA","report_number":"UBG2003366","insp_date":"2024-04-18 00:00:00","insp_start_time":"0833","insp_end_time":"0902","registration_date":null,"region":"PT","ci_status_code":"C","location":"9480","location_desc":"MERRITT","county_code_state":"CA","county_code":"107","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-18 21:40: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":"15325368","transaction_code":"A","transaction_date":"2024-04-18 00:00:00","upload_date":"2024-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-18 21:40:00","insp_carrier_name":"ANDRES GERARDO MEDINA RODRIGUEZ","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"Y","insp_carrier_state_id":"412253","created_at":"2025-03-17T20:12:45.000000Z","updated_at":"2025-03-17T20:12:45.000000Z","inspection_violations":[{"id":8571564,"change_date":"2024-04-18 21:40:00","inspection_id":"81390285","insp_violation_id":"259017025","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MS53313","created_at":"2025-03-17T21:47:32.000000Z","updated_at":"2025-03-17T21:47:32.000000Z","normalized_code":"39216A"},{"id":8571565,"change_date":"2024-04-18 21:40:00","inspection_id":"81390285","insp_violation_id":"259017026","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"200472828","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:32.000000Z","updated_at":"2025-03-17T21:47:32.000000Z","normalized_code":"39375C"},{"id":8571566,"change_date":"2024-04-18 21:40:00","inspection_id":"81390285","insp_violation_id":"259017027","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200472828","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:32.000000Z","updated_at":"2025-03-17T21:47:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8935102,"change_date":"2024-04-18 21:40:00","inspection_id":"81390285","insp_unit_id":"200472828","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"18\/BLU","insp_unit_license":"9G16325","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDRXBSBB7447","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:10.000000Z","updated_at":"2025-03-17T23:16:10.000000Z"}]},{"id":5322531,"change_date":"2024-03-19 21:45:00","inspection_id":"81145301","dot_number":"2201010","report_state":"CA","report_number":"UDFY002191","insp_date":"2024-03-16 00:00:00","insp_start_time":"1130","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"VICTORVILLE AREA","county_code_state":"CA","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-19 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15284076","transaction_code":"A","transaction_date":"2024-03-16 00:00:00","upload_date":"2024-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-19 21:45:00","insp_carrier_name":"ANDRES GERARDO MEDINA RODRIGUEZ","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:15.000000Z","updated_at":"2025-03-17T20:08:15.000000Z","inspection_violations":[{"id":8212302,"change_date":"2024-03-19 21:45:00","inspection_id":"81145301","insp_violation_id":"258473148","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"199990912","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"39347E"},{"id":8212303,"change_date":"2024-03-19 21:45:00","inspection_id":"81145301","insp_violation_id":"258473149","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"199990912","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":8571842,"change_date":"2024-03-19 21:45:00","inspection_id":"81145301","insp_unit_id":"199990911","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"30","insp_unit_license":"9G49762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD50GSGX6738","insp_unit_decal":"Y","insp_unit_decal_number":"33588682","created_at":"2025-03-17T23:12:42.000000Z","updated_at":"2025-03-17T23:12:42.000000Z"},{"id":8571843,"change_date":"2024-03-19 21:45:00","inspection_id":"81145301","insp_unit_id":"199990912","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5315","insp_unit_license":"38224F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS25364M036313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:42.000000Z","updated_at":"2025-03-17T23:12:42.000000Z"}]},{"id":4574653,"change_date":"2023-12-06 21:42:00","inspection_id":"80327975","dot_number":"2201010","report_state":"CA","report_number":"UETI000496","insp_date":"2023-12-02 00:00:00","insp_start_time":"1624","insp_end_time":"1657","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GRIMMWAY FARMS","shipping_paper_number":"47769971","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15156100","transaction_code":"A","transaction_date":"2023-12-02 00:00:00","upload_date":"2023-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-06 21:42:00","insp_carrier_name":"ANDRES GERARDO MEDINA RODRIGUEZ","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"Y","insp_carrier_state_id":"412253","created_at":"2025-03-17T19:53:25.000000Z","updated_at":"2025-03-17T19:53:25.000000Z","inspection_violations":[{"id":7076195,"change_date":"2023-12-06 21:42:00","inspection_id":"80327975","insp_violation_id":"256756892","seq_no":"1","part_no":"393","part_no_section":"60(e)","insp_viol_unit":"1","insp_unit_id":"198386295","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KR32081","created_at":"2025-03-17T21:40:10.000000Z","updated_at":"2025-03-17T21:40:10.000000Z","normalized_code":"39360E"},{"id":7076196,"change_date":"2023-12-06 21:42:00","inspection_id":"80327975","insp_violation_id":"256756893","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198386296","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:40:10.000000Z","updated_at":"2025-03-17T21:40:10.000000Z","normalized_code":"3922"},{"id":7076197,"change_date":"2023-12-06 21:42:00","inspection_id":"80327975","insp_violation_id":"256756894","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"198386296","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:40:10.000000Z","updated_at":"2025-03-17T21:40:10.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7357648,"change_date":"2023-12-06 21:42:00","inspection_id":"80327975","insp_unit_id":"198386295","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"24","insp_unit_license":"9G14897","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X4FJ438669","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:50.000000Z","updated_at":"2025-03-17T23:01:50.000000Z"},{"id":7357649,"change_date":"2023-12-06 21:42:00","inspection_id":"80327975","insp_unit_id":"198386296","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"R8000B","insp_unit_license":"4NP9969","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5322FL004107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:50.000000Z","updated_at":"2025-03-17T23:01:50.000000Z"}]},{"id":4415553,"change_date":"2023-11-13 21:42:00","inspection_id":"80153034","dot_number":"2201010","report_state":"CA","report_number":"UDT2001032","insp_date":"2023-11-11 00:00:00","insp_start_time":"0028","insp_end_time":"0050","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE CVEF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GRIMMWAY FARMS","shipping_paper_number":"47685014","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15131028","transaction_code":"A","transaction_date":"2023-11-11 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-13 21:42:00","insp_carrier_name":"ANDRES GERARDO MEDINA RODRIGUEZ","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"Y","insp_carrier_state_id":"412253","created_at":"2025-03-17T19:50:20.000000Z","updated_at":"2025-03-17T19:50:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7101353,"change_date":"2023-11-13 21:42:00","inspection_id":"80153034","insp_unit_id":"198038719","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"32","insp_unit_license":"9G15212","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5FJ438423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:38.000000Z","updated_at":"2025-03-17T22:59:38.000000Z"},{"id":7101354,"change_date":"2023-11-13 21:42:00","inspection_id":"80153034","insp_unit_id":"198038720","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMCD","insp_unit_company":"5312","insp_unit_license":"4NZ9788","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"LJRR53264D6001904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:38.000000Z","updated_at":"2025-03-17T22:59:38.000000Z"}]},{"id":3569839,"change_date":"2023-07-21 21:41:00","inspection_id":"79212521","dot_number":"2201010","report_state":"CA","report_number":"ND6B004622","insp_date":"2023-07-20 00:00:00","insp_start_time":"0650","insp_end_time":"0741","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"CACHE CREEK","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FOUR STAR","shipping_paper_number":"260077","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14991661","transaction_code":"A","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-21 21:41:00","insp_carrier_name":"ANDRES G MEDINA RODRIGUEZ","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-03-17T19:33:33.000000Z","updated_at":"2025-03-17T19:33:33.000000Z","inspection_violations":[{"id":5504959,"change_date":"2023-07-21 21:41:00","inspection_id":"79212521","insp_violation_id":"254215368","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"196137318","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"393207A"},{"id":5504960,"change_date":"2023-07-21 21:41:00","inspection_id":"79212521","insp_violation_id":"254215369","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"196137317","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"39345"},{"id":5504961,"change_date":"2023-07-21 21:41:00","inspection_id":"79212521","insp_violation_id":"254215370","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"196137317","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":5739975,"change_date":"2023-07-21 21:41:00","inspection_id":"79212521","insp_unit_id":"196137317","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"31","insp_unit_license":"9G14896","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYDP9X7FJ452129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:17.000000Z","updated_at":"2025-03-17T22:48:17.000000Z"},{"id":5739976,"change_date":"2023-07-21 21:41:00","inspection_id":"79212521","insp_unit_id":"196137318","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"610","insp_unit_license":"4UA9039","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W68L100731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:17.000000Z","updated_at":"2025-03-17T22:48:17.000000Z"}]},{"id":3215845,"change_date":"2023-06-05 21:43:00","inspection_id":"78814251","dot_number":"2201010","report_state":"CA","report_number":"NABR006619","insp_date":"2023-06-04 00:00:00","insp_start_time":"0902","insp_end_time":"0924","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"14930202","transaction_code":"A","transaction_date":"2023-06-04 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-05 21:43:00","insp_carrier_name":"ANDRES G MEDINA RODRIGUEZ","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-03-17T19:26:31.000000Z","updated_at":"2025-03-17T19:26:31.000000Z","inspection_violations":[{"id":4956016,"change_date":"2023-06-05 21:43:00","inspection_id":"78814251","insp_violation_id":"253304610","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195331927","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:03.000000Z","updated_at":"2025-03-17T21:30:03.000000Z","normalized_code":"3963A1"},{"id":4956017,"change_date":"2023-06-05 21:43:00","inspection_id":"78814251","insp_violation_id":"253304611","seq_no":"2","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"195331926","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"JJ13911","created_at":"2025-03-17T21:30:03.000000Z","updated_at":"2025-03-17T21:30:03.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":5172069,"change_date":"2023-06-05 21:43:00","inspection_id":"78814251","insp_unit_id":"195331926","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"30\/GRY","insp_unit_license":"9G49762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD50GSGX6738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:45.000000Z","updated_at":"2025-03-17T22:43:45.000000Z"},{"id":5172070,"change_date":"2023-06-05 21:43:00","inspection_id":"78814251","insp_unit_id":"195331927","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"4830","insp_unit_license":"4EE4082","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA96236W702128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:45.000000Z","updated_at":"2025-03-17T22:43:45.000000Z"}]},{"id":2496684,"change_date":"2023-03-02 21:41:00","inspection_id":"77999050","dot_number":"2201010","report_state":"CA","report_number":"UFEK002650","insp_date":"2023-03-01 00:00:00","insp_start_time":"1810","insp_end_time":"1830","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-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":"14804463","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-02 21:41:00","insp_carrier_name":"ANDRES G MEDINA RODRIGUEZ","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:34.000000Z","updated_at":"2025-03-17T19:12:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4017581,"change_date":"2023-03-02 21:41:00","inspection_id":"77999050","insp_unit_id":"193685275","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G49762","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD50GSGX6738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:47.000000Z","updated_at":"2025-03-17T22:34:47.000000Z"}]},{"id":652699,"change_date":"2022-06-20 21:36:00","inspection_id":"75870636","dot_number":"2201010","report_state":"CA","report_number":"UF6X001097","insp_date":"2022-06-17 00:00:00","insp_start_time":"2112","insp_end_time":"2119","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-20 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14474682","transaction_code":"A","transaction_date":"2022-06-17 00:00:00","upload_date":"2022-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-20 21:36:00","insp_carrier_name":"ANDRES G MEDINA RODRIGUEZ","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:11.000000Z","updated_at":"2025-03-17T18:39:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1049264,"change_date":"2022-06-20 21:36:00","inspection_id":"75870636","insp_unit_id":"189360575","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9E80565","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X7DJ364114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:38.000000Z","updated_at":"2025-03-17T22:14:38.000000Z"},{"id":1049265,"change_date":"2022-06-20 21:36:00","inspection_id":"75870636","insp_unit_id":"189360576","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"4HZ1880","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA06298W701502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:38.000000Z","updated_at":"2025-03-17T22:14:38.000000Z"}]},{"id":498200,"change_date":"2022-05-26 21:43:00","inspection_id":"75687109","dot_number":"2201010","report_state":"CA","report_number":"UC8B001053","insp_date":"2022-05-25 00:00:00","insp_start_time":"1009","insp_end_time":"1026","registration_date":null,"region":"PT","ci_status_code":"C","location":"480","location_desc":"VISALIA AREA","county_code_state":"CA","county_code":"107","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14444965","transaction_code":"A","transaction_date":"2022-05-25 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02201010","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-26 21:43:00","insp_carrier_name":"ANDRES G MEDINA RODRIGUEZ","insp_carrier_street":"835 BUTTE STREET","insp_carrier_city":"MCFARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"763742","insp_interstate":"N","insp_carrier_state_id":"412253","created_at":"2025-03-17T18:36:22.000000Z","updated_at":"2025-03-17T18:36:22.000000Z","inspection_violations":[{"id":790957,"change_date":"2022-05-26 21:43:00","inspection_id":"75687109","insp_violation_id":"246120450","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KJ53449","created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3922"},{"id":790958,"change_date":"2022-05-26 21:43:00","inspection_id":"75687109","insp_violation_id":"246120451","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188950671","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":801313,"change_date":"2022-05-26 21:43:00","inspection_id":"75687109","insp_unit_id":"188950670","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G02535","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJBBDR29DAC2209","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:09.000000Z","updated_at":"2025-03-17T22:13:09.000000Z"},{"id":801314,"change_date":"2022-05-26 21:43:00","inspection_id":"75687109","insp_unit_id":"188950671","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"15484","insp_unit_license":"NONE","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25366U715026","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:09.000000Z","updated_at":"2025-03-17T22:13:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2201010\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2201010\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2201010\/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\/2201010\/inspections","per_page":100,"prev_page_url":null,"to":44,"total":44}