{"current_page":1,"data":[{"id":12574888,"change_date":"2026-07-29 21:41:00","inspection_id":"88543099","dot_number":"2707426","report_state":"CA","report_number":"NEK3003065","insp_date":"2026-07-28 00:00:00","insp_start_time":"1843","insp_end_time":"1913","registration_date":null,"region":"PD","ci_status_code":"C","location":"541","location_desc":"CA","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JFC INTERNATIONAL INC IDC","shipping_paper_number":"1026996","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118300","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3858234","transaction_code":"A","transaction_date":"2026-07-29 00:00:00","upload_date":"2026-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2026-07-29 21:41:00","snet_input_date":"2026-07-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-29 21:41:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"4330 ELM STREEET","insp_carrier_city":"FIREBAUGH","insp_carrier_state":"CA","insp_carrier_zip_code":"93622","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2026-08-01T09:41:22.000000Z","updated_at":"2026-08-09T09:30:27.000000Z","inspection_violations":[{"id":21893923,"change_date":"2026-07-29 21:41:00","inspection_id":"88543099","insp_violation_id":"275791809","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"214867378","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA657669","created_at":"2026-08-01T10:02:11.000000Z","updated_at":"2026-08-09T09:42:58.000000Z","normalized_code":"39375A3TAOL"},{"id":21893924,"change_date":"2026-07-29 21:41:00","inspection_id":"88543099","insp_violation_id":"275791810","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"214867379","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-01T10:02:11.000000Z","updated_at":"2026-08-09T09:42:58.000000Z","normalized_code":"39347E"},{"id":21893925,"change_date":"2026-07-29 21:41:00","inspection_id":"88543099","insp_violation_id":"275791811","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"214867379","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-01T10:02:11.000000Z","updated_at":"2026-08-09T09:42:58.000000Z","normalized_code":"39353BB"},{"id":21893922,"change_date":"2026-07-29 21:41:00","inspection_id":"88543099","insp_violation_id":"275791808","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"214867378","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-01T10:02:11.000000Z","updated_at":"2026-08-09T09:42:58.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":21833838,"change_date":"2026-07-29 21:41:00","inspection_id":"88543099","insp_unit_id":"214867378","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10\/RED","insp_unit_license":"9H00727","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR1KSKE3461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-01T09:18:07.000000Z","updated_at":"2026-08-09T09:01:40.000000Z"},{"id":21833839,"change_date":"2026-07-29 21:41:00","inspection_id":"88543099","insp_unit_id":"214867379","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4353","insp_unit_license":"4KF7896","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25399U767612","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-01T09:18:07.000000Z","updated_at":"2026-08-09T09:01:40.000000Z"}]},{"id":12556704,"change_date":"2026-07-27 21:38:00","inspection_id":"88524021","dot_number":"2707426","report_state":"CA","report_number":"UHCV000484","insp_date":"2026-07-25 00:00:00","insp_start_time":"2130","insp_end_time":"2205","registration_date":null,"region":"PD","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"3842959","transaction_code":"A","transaction_date":"2026-07-27 00:00:00","upload_date":"2026-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2026-07-27 21:38:00","snet_input_date":"2026-07-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-27 21:38:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"4330 ELM STREEET","insp_carrier_city":"FIREBAUGH","insp_carrier_state":"CA","insp_carrier_zip_code":"93622","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-30T09:39:58.000000Z","updated_at":"2026-08-07T09:30:33.000000Z","inspection_violations":[{"id":21861177,"change_date":"2026-07-27 21:38:00","inspection_id":"88524021","insp_violation_id":"275748765","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"214831799","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-30T09:58:26.000000Z","updated_at":"2026-08-07T09:40:48.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":21803609,"change_date":"2026-07-27 21:38:00","inspection_id":"88524021","insp_unit_id":"214831799","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09\/WHT","insp_unit_license":"9G64478","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD66FSGN3231","insp_unit_decal":"Y","insp_unit_decal_number":"36536415","created_at":"2026-07-30T09:17:19.000000Z","updated_at":"2026-08-07T09:01:46.000000Z"}]},{"id":12289346,"change_date":"2026-06-26 21:38:00","inspection_id":"88245269","dot_number":"2707426","report_state":"CA","report_number":"UGCY000245","insp_date":"2026-06-25 00:00:00","insp_start_time":"1445","insp_end_time":"1520","registration_date":null,"region":"PD","ci_status_code":"C","location":"450","location_desc":"CA","county_code_state":"CA","county_code":"039","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3624760","transaction_code":"A","transaction_date":"2026-06-26 00:00:00","upload_date":"2026-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2026-06-26 21:38:00","snet_input_date":"2026-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-26 21:38:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"4330 ELM STREEET","insp_carrier_city":"FIREBAUGH","insp_carrier_state":"CA","insp_carrier_zip_code":"93622","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2026-06-29T09:41:17.000000Z","updated_at":"2026-07-07T09:30:24.000000Z","inspection_violations":[{"id":21391178,"change_date":"2026-06-26 21:38:00","inspection_id":"88245269","insp_violation_id":"275144773","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"7M6V0078N","created_at":"2026-06-29T10:01:06.000000Z","updated_at":"2026-07-07T09:41:38.000000Z","normalized_code":"38323A2LCDLN"},{"id":21391179,"change_date":"2026-06-26 21:38:00","inspection_id":"88245269","insp_violation_id":"275144774","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"214299430","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-29T10:01:06.000000Z","updated_at":"2026-07-07T09:41:38.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":21345764,"change_date":"2026-06-26 21:38:00","inspection_id":"88245269","insp_unit_id":"214299430","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"RED TRK","insp_unit_license":"9E02059","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG1BLAX8781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-29T09:16:21.000000Z","updated_at":"2026-07-07T09:01:52.000000Z"},{"id":21345765,"change_date":"2026-06-26 21:38:00","inspection_id":"88245269","insp_unit_id":"214299431","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"REF TRL","insp_unit_license":"4KB9865","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0623AW700965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-29T09:16:21.000000Z","updated_at":"2026-07-07T09:01:52.000000Z"}]},{"id":12256073,"change_date":"2026-06-23 21:38:00","inspection_id":"88214655","dot_number":"2707426","report_state":"CA","report_number":"UCRG001101","insp_date":"2026-06-22 00:00:00","insp_start_time":"1000","insp_end_time":"1022","registration_date":null,"region":"PS","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","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":"U","pen_cen_match":"I","final_status_date":"2026-06-23 21:38: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":"3600529","transaction_code":"A","transaction_date":"2026-06-23 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2026-06-23 21:38:00","snet_input_date":"2026-06-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-23 21:38:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"4330 ELM STREEET","insp_carrier_city":"FIREBAUGH","insp_carrier_state":"CA","insp_carrier_zip_code":"93622","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2026-06-26T09:40:45.000000Z","updated_at":"2026-07-04T09:30:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21283007,"change_date":"2026-06-23 21:38:00","inspection_id":"88214655","insp_unit_id":"214235498","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09\/WHI","insp_unit_license":"9G64478","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD66FSGN3231","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:06.000000Z","updated_at":"2026-07-05T09:03:30.000000Z"},{"id":21283008,"change_date":"2026-06-23 21:38:00","inspection_id":"88214655","insp_unit_id":"214235499","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4253\/WHI","insp_unit_license":"4KF7895","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25379U767611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:06.000000Z","updated_at":"2026-07-05T09:03:30.000000Z"}]},{"id":12152402,"change_date":"2026-06-10 21:45:00","inspection_id":"88101702","dot_number":"2707426","report_state":"CA","report_number":"UG2G001775","insp_date":"2026-06-10 00:00:00","insp_start_time":"1004","insp_end_time":"1035","registration_date":null,"region":"PS","ci_status_code":"C","location":"435","location_desc":"CA","county_code_state":"CA","county_code":"019","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":"U","pen_cen_match":"I","final_status_date":"2026-06-10 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"8","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3513935","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2026-06-10 21:45:00","snet_input_date":"2026-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:45:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"4330 ELM STREEET","insp_carrier_city":"FIREBAUGH","insp_carrier_state":"CA","insp_carrier_zip_code":"93622","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2026-06-13T09:41:34.000000Z","updated_at":"2026-06-21T09:31:48.000000Z","inspection_violations":[{"id":21149513,"change_date":"2026-06-10 21:45:00","inspection_id":"88101702","insp_violation_id":"274823247","seq_no":"1","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"000DF","created_at":"2026-06-13T10:02:50.000000Z","updated_at":"2026-06-21T09:46:10.000000Z","normalized_code":"39282DUMT"},{"id":21149514,"change_date":"2026-06-10 21:45:00","inspection_id":"88101702","insp_violation_id":"274823248","seq_no":"2","part_no":"395","part_no_section":"30B2-ELDDFC24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-06-13T10:02:50.000000Z","updated_at":"2026-06-21T09:46:10.000000Z","normalized_code":"39530B2ELDDFC24"},{"id":21149516,"change_date":"2026-06-10 21:45:00","inspection_id":"88101702","insp_violation_id":"274823250","seq_no":"4","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"214022170","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-06-13T10:02:50.000000Z","updated_at":"2026-06-21T09:46:10.000000Z","normalized_code":"3922SLLEQP"},{"id":21149517,"change_date":"2026-06-10 21:45:00","inspection_id":"88101702","insp_violation_id":"274823251","seq_no":"5","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"214022170","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-06-13T10:02:50.000000Z","updated_at":"2026-06-21T09:46:10.000000Z","normalized_code":"3939ALFTSI"},{"id":21149518,"change_date":"2026-06-10 21:45:00","inspection_id":"88101702","insp_violation_id":"274823252","seq_no":"6","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"214022170","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-06-13T10:02:50.000000Z","updated_at":"2026-06-21T09:46:10.000000Z","normalized_code":"3939ALCL"},{"id":21149519,"change_date":"2026-06-10 21:45:00","inspection_id":"88101702","insp_violation_id":"274823253","seq_no":"7","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"214022171","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"VERBAL","created_at":"2026-06-13T10:02:50.000000Z","updated_at":"2026-06-21T09:46:10.000000Z","normalized_code":"39375A3TAOL"},{"id":21149520,"change_date":"2026-06-10 21:45:00","inspection_id":"88101702","insp_violation_id":"274823254","seq_no":"8","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"214022171","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"000DG","created_at":"2026-06-13T10:02:50.000000Z","updated_at":"2026-06-21T09:46:10.000000Z","normalized_code":"3922SLLSR"},{"id":21149515,"change_date":"2026-06-10 21:45:00","inspection_id":"88101702","insp_violation_id":"274823249","seq_no":"3","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-06-13T10:02:50.000000Z","updated_at":"2026-06-21T09:46:10.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":21110145,"change_date":"2026-06-10 21:45:00","inspection_id":"88101702","insp_unit_id":"214022170","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06\/3X BLU","insp_unit_license":"9F84222","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBGXCSBF3349","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:04.000000Z","updated_at":"2026-06-21T09:03:17.000000Z"},{"id":21110146,"change_date":"2026-06-10 21:45:00","inspection_id":"88101702","insp_unit_id":"214022171","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAN","insp_unit_company":"53171\/2X","insp_unit_license":"4FS1850","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1B95C1014LC403162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:04.000000Z","updated_at":"2026-06-21T09:03:17.000000Z"}]},{"id":11254797,"change_date":"2026-02-27 21:42:00","inspection_id":"87168217","dot_number":"2707426","report_state":"CA","report_number":"UG2G001485","insp_date":"2026-02-26 00:00:00","insp_start_time":"1545","insp_end_time":"1609","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"FRESNO AREA","county_code_state":"CA","county_code":"019","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":"2026-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118300","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16187267","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2026-02-27 21:42:00","snet_input_date":"2026-02-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-27 21:42:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"4330 ELM STREEET","insp_carrier_city":"FIREBAUGH","insp_carrier_state":"CA","insp_carrier_zip_code":"93622","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2026-03-02T10:39:54.000000Z","updated_at":"2026-03-10T09:32:01.000000Z","inspection_violations":[{"id":18911583,"change_date":"2026-02-27 21:42:00","inspection_id":"87168217","insp_violation_id":"272109587","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"211893877","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0004J","created_at":"2026-03-02T10:59:15.000000Z","updated_at":"2026-03-10T09:45:31.000000Z","normalized_code":"3922SLLEQP"},{"id":18911584,"change_date":"2026-02-27 21:42:00","inspection_id":"87168217","insp_violation_id":"272109588","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211893877","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0004J","created_at":"2026-03-02T10:59:15.000000Z","updated_at":"2026-03-10T09:45:31.000000Z","normalized_code":"3922SLLSR"},{"id":18911585,"change_date":"2026-02-27 21:42:00","inspection_id":"87168217","insp_violation_id":"272109589","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211893877","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-03-02T10:59:15.000000Z","updated_at":"2026-03-10T09:45:31.000000Z","normalized_code":"3922SLLSR"},{"id":18911586,"change_date":"2026-02-27 21:42:00","inspection_id":"87168217","insp_violation_id":"272109590","seq_no":"4","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"211893877","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-03-02T10:59:15.000000Z","updated_at":"2026-03-10T09:45:31.000000Z","normalized_code":"3922SLLSIV"},{"id":18911587,"change_date":"2026-02-27 21:42:00","inspection_id":"87168217","insp_violation_id":"272109591","seq_no":"5","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"211893877","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-03-02T10:59:15.000000Z","updated_at":"2026-03-10T09:45:31.000000Z","normalized_code":"39395A4EEUS"},{"id":18911588,"change_date":"2026-02-27 21:42:00","inspection_id":"87168217","insp_violation_id":"272109592","seq_no":"6","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"211893877","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0004J","created_at":"2026-03-02T10:59:15.000000Z","updated_at":"2026-03-10T09:45:31.000000Z","normalized_code":"3922SLLEQP"},{"id":18911589,"change_date":"2026-02-27 21:42:00","inspection_id":"87168217","insp_violation_id":"272109593","seq_no":"7","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"211893878","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"VERBAL","created_at":"2026-03-02T10:59:15.000000Z","updated_at":"2026-03-10T09:45:31.000000Z","normalized_code":"3939ALTSI"},{"id":18911590,"change_date":"2026-02-27 21:42:00","inspection_id":"87168217","insp_violation_id":"272109594","seq_no":"8","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"211893878","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"VERBAL","created_at":"2026-03-02T10:59:15.000000Z","updated_at":"2026-03-10T09:45:31.000000Z","normalized_code":"39375A3TAOL"},{"id":18911591,"change_date":"2026-02-27 21:42:00","inspection_id":"87168217","insp_violation_id":"272109595","seq_no":"9","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"211893878","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-03-02T10:59:15.000000Z","updated_at":"2026-03-10T09:45:31.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":19243733,"change_date":"2026-02-27 21:42:00","inspection_id":"87168217","insp_unit_id":"211893877","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"25\/3X RED","insp_unit_license":"9H00727","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR1KSKE3461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:32.000000Z","updated_at":"2026-03-10T09:06:47.000000Z"},{"id":19243734,"change_date":"2026-02-27 21:42:00","inspection_id":"87168217","insp_unit_id":"211893878","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X WHI","insp_unit_license":"4HS3960","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25387U932501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:32.000000Z","updated_at":"2026-03-10T09:06:47.000000Z"}]},{"id":11269934,"change_date":"2026-03-02 21:39:00","inspection_id":"87184156","dot_number":"2707426","report_state":"CA","report_number":"N9PI010193","insp_date":"2026-02-26 00:00:00","insp_start_time":"1038","insp_end_time":"1108","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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":"2026-03-02 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":"16189724","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2026-03-02 21:39:00","snet_input_date":"2026-02-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-02 21:39:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"4330 ELM STREEET","insp_carrier_city":"FIREBAUGH","insp_carrier_state":"CA","insp_carrier_zip_code":"93622","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2026-03-05T10:39:08.000000Z","updated_at":"2026-03-13T09:32:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19272633,"change_date":"2026-03-02 21:39:00","inspection_id":"87184156","insp_unit_id":"211927920","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT 09","insp_unit_license":"9G64478","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD66FSGN3231","insp_unit_decal":"Y","insp_unit_decal_number":"35894616","created_at":"2026-03-05T10:14:49.000000Z","updated_at":"2026-03-13T09:07:42.000000Z"},{"id":19272634,"change_date":"2026-03-02 21:39:00","inspection_id":"87184156","insp_unit_id":"211927921","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"REF 4253","insp_unit_license":"4KF7895","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25379U767611","insp_unit_decal":"Y","insp_unit_decal_number":"35894617","created_at":"2026-03-05T10:14:49.000000Z","updated_at":"2026-03-13T09:07:42.000000Z"}]},{"id":11131867,"change_date":"2026-02-13 21:39:00","inspection_id":"87045372","dot_number":"2707426","report_state":"CA","report_number":"NCNK009941","insp_date":"2026-02-12 00:00:00","insp_start_time":"1700","insp_end_time":"1735","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ENRIQUE RAMIREZ","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":"2026-02-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16170963","transaction_code":"A","transaction_date":"2026-02-12 00:00:00","upload_date":"2026-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2026-02-13 21:39:00","snet_input_date":"2026-02-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-13 21:39:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"4330 ELM STREEET","insp_carrier_city":"FIREBAUGH","insp_carrier_state":"CA","insp_carrier_zip_code":"93622","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2026-02-16T10:38:49.000000Z","updated_at":"2026-02-24T10:31:11.000000Z","inspection_violations":[{"id":18649162,"change_date":"2026-02-13 21:39:00","inspection_id":"87045372","insp_violation_id":"271798485","seq_no":"3","part_no":"393","part_no_section":"207B-AALPME","insp_viol_unit":"2","insp_unit_id":"211623598","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-02-16T10:54:47.000000Z","updated_at":"2026-02-24T10:39:59.000000Z","normalized_code":"393207BAALPME"},{"id":18649160,"change_date":"2026-02-13 21:39:00","inspection_id":"87045372","insp_violation_id":"271798483","seq_no":"1","part_no":"393","part_no_section":"207A-STCB","insp_viol_unit":"1","insp_unit_id":"211623597","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-02-16T10:54:47.000000Z","updated_at":"2026-02-24T10:39:59.000000Z","normalized_code":"393207ASTCB"},{"id":18649161,"change_date":"2026-02-13 21:39:00","inspection_id":"87045372","insp_violation_id":"271798484","seq_no":"2","part_no":"393","part_no_section":"207A-STCB","insp_viol_unit":"1","insp_unit_id":"211623597","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-02-16T10:54:47.000000Z","updated_at":"2026-02-24T10:39:59.000000Z","normalized_code":"393207ASTCB"},{"id":18649163,"change_date":"2026-02-13 21:39:00","inspection_id":"87045372","insp_violation_id":"271798486","seq_no":"4","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"2","insp_unit_id":"211623598","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-02-16T10:54:47.000000Z","updated_at":"2026-02-24T10:39:59.000000Z","normalized_code":"39348ABMBCBD"}],"inspection_per_units":[{"id":18989224,"change_date":"2026-02-13 21:39:00","inspection_id":"87045372","insp_unit_id":"211623597","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/09","insp_unit_license":"9G64478","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD66FSGN3231","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-16T10:15:06.000000Z","updated_at":"2026-02-24T10:03:39.000000Z"},{"id":18989225,"change_date":"2026-02-13 21:39:00","inspection_id":"87045372","insp_unit_id":"211623598","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT\/4253","insp_unit_license":"4KF7895","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25379U767611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-16T10:15:06.000000Z","updated_at":"2026-02-24T10:03:39.000000Z"}]},{"id":10850086,"change_date":"2026-01-23 21:40:00","inspection_id":"86879004","dot_number":"2707426","report_state":"CA","report_number":"UHA2000155","insp_date":"2026-01-23 00:00:00","insp_start_time":"1005","insp_end_time":"1048","registration_date":null,"region":"PT","ci_status_code":"C","location":"9450","location_desc":"RD 13 SB AT AVE 25","county_code_state":"CA","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16143124","transaction_code":"A","transaction_date":"2026-01-23 00:00:00","upload_date":"2026-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2026-01-23 21:40:00","snet_input_date":"2026-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-23 21:40:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-26T10:37:38.000000Z","updated_at":"2026-02-03T10:30:51.000000Z","inspection_violations":[{"id":18150831,"change_date":"2026-01-23 21:40:00","inspection_id":"86879004","insp_violation_id":"271404392","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211268617","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:43.000000Z","updated_at":"2026-02-04T10:36:35.000000Z","normalized_code":"3922SLLSR"},{"id":18150832,"change_date":"2026-01-23 21:40:00","inspection_id":"86879004","insp_violation_id":"271404393","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211268617","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:43.000000Z","updated_at":"2026-02-04T10:36:35.000000Z","normalized_code":"39360C"},{"id":18150833,"change_date":"2026-01-23 21:40:00","inspection_id":"86879004","insp_violation_id":"271404394","seq_no":"3","part_no":"393","part_no_section":"60E","insp_viol_unit":"1","insp_unit_id":"211268617","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:43.000000Z","updated_at":"2026-02-04T10:36:35.000000Z","normalized_code":"39360E"},{"id":18150834,"change_date":"2026-01-23 21:40:00","inspection_id":"86879004","insp_violation_id":"271404395","seq_no":"4","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"211268617","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:43.000000Z","updated_at":"2026-02-04T10:36:35.000000Z","normalized_code":"39395A4EEUS"},{"id":18150835,"change_date":"2026-01-23 21:40:00","inspection_id":"86879004","insp_violation_id":"271404396","seq_no":"5","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"211268617","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:43.000000Z","updated_at":"2026-02-04T10:36:35.000000Z","normalized_code":"39395A1"},{"id":18150836,"change_date":"2026-01-23 21:40:00","inspection_id":"86879004","insp_violation_id":"271404397","seq_no":"6","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"211268618","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:43.000000Z","updated_at":"2026-02-04T10:36:35.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":18230089,"change_date":"2026-01-23 21:40:00","inspection_id":"86879004","insp_unit_id":"211268617","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"03","insp_unit_license":"9G68604","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPXD49XXCD137324","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-26T10:10:00.000000Z","updated_at":"2026-02-03T10:03:18.000000Z"},{"id":18230090,"change_date":"2026-01-23 21:40:00","inspection_id":"86879004","insp_unit_id":"211268618","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"7474A","insp_unit_license":"4SM5193","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA06237W703163","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-26T10:10:00.000000Z","updated_at":"2026-02-03T10:03:18.000000Z"}]},{"id":10561400,"change_date":"2026-01-02 21:36:00","inspection_id":"86698725","dot_number":"2707426","report_state":"CA","report_number":"UF44006936","insp_date":"2025-12-31 00:00:00","insp_start_time":"0708","insp_end_time":"0815","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB @ ANDRADE RD","county_code_state":"CA","county_code":"001","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-02 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16113954","transaction_code":"A","transaction_date":"2025-12-31 00:00:00","upload_date":"2026-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2026-01-02 21:36:00","snet_input_date":"2025-12-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-02 21:36:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2026-01-05T10:33:42.000000Z","updated_at":"2026-01-13T10:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17694116,"change_date":"2026-01-02 21:36:00","inspection_id":"86698725","insp_unit_id":"210895464","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G64478","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD66FSGN3231","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:11.000000Z","updated_at":"2026-01-13T10:01:02.000000Z"},{"id":17694117,"change_date":"2026-01-02 21:36:00","inspection_id":"86698725","insp_unit_id":"210895465","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4KF7895","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25379U767611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:11.000000Z","updated_at":"2026-01-13T10:01:02.000000Z"}]},{"id":10560519,"change_date":"2026-01-02 21:35:00","inspection_id":"86697817","dot_number":"2707426","report_state":"CA","report_number":"UCOM001132","insp_date":"2025-12-31 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","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":"2026-01-02 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"116999","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":"16114125","transaction_code":"A","transaction_date":"2025-12-31 00:00:00","upload_date":"2026-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2026-01-02 21:35:00","snet_input_date":"2025-12-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-02 21:35:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-05T10:33:40.000000Z","updated_at":"2026-01-13T10:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17692719,"change_date":"2026-01-02 21:35:00","inspection_id":"86697817","insp_unit_id":"210893953","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X","insp_unit_license":"9G64478","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD66FSGN3231","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:10.000000Z","updated_at":"2026-01-13T10:00:57.000000Z"},{"id":17692720,"change_date":"2026-01-02 21:35:00","inspection_id":"86697817","insp_unit_id":"210893954","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X","insp_unit_license":"4KF7895","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25379U767611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:10.000000Z","updated_at":"2026-01-13T10:00:57.000000Z"}]},{"id":10501698,"change_date":"2025-12-22 21:39:00","inspection_id":"86636528","dot_number":"2707426","report_state":"CA","report_number":"UEBY002423","insp_date":"2025-12-22 00:00:00","insp_start_time":"1200","insp_end_time":"1231","registration_date":null,"region":"PT","ci_status_code":"C","location":"9410","location_desc":"FRESNO, CA","county_code_state":"CA","county_code":"019","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":"2025-12-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","viol_total":"6","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16106328","transaction_code":"A","transaction_date":"2025-12-22 00:00:00","upload_date":"2025-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2025-12-22 21:39:00","snet_input_date":"2025-12-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-22 21:39:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-12-25T10:37:51.000000Z","updated_at":"2026-01-02T10:31:21.000000Z","inspection_violations":[{"id":17626266,"change_date":"2025-12-22 21:39:00","inspection_id":"86636528","insp_violation_id":"270852416","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00SQ00072","created_at":"2025-12-25T10:43:03.000000Z","updated_at":"2026-01-02T10:32:13.000000Z","normalized_code":"39216AD"},{"id":17626267,"change_date":"2025-12-22 21:39:00","inspection_id":"86636528","insp_violation_id":"270852417","seq_no":"2","part_no":"395","part_no_section":"22H4-ELDBRODS","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-12-25T10:43:03.000000Z","updated_at":"2026-01-02T10:32:13.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":17626268,"change_date":"2025-12-22 21:39:00","inspection_id":"86636528","insp_violation_id":"270852418","seq_no":"3","part_no":"395","part_no_section":"22G-ELDMFV","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-12-25T10:43:03.000000Z","updated_at":"2026-01-02T10:32:13.000000Z","normalized_code":"39522GELDMFV"},{"id":17626269,"change_date":"2025-12-22 21:39:00","inspection_id":"86636528","insp_violation_id":"270852419","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210763922","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00SQ00073","created_at":"2025-12-25T10:43:03.000000Z","updated_at":"2026-01-02T10:32:13.000000Z","normalized_code":"3922SLLSR"},{"id":17626270,"change_date":"2025-12-22 21:39:00","inspection_id":"86636528","insp_violation_id":"270852420","seq_no":"5","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"210763922","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00SQ00073","created_at":"2025-12-25T10:43:03.000000Z","updated_at":"2026-01-02T10:32:13.000000Z","normalized_code":"3922SLLEQP"},{"id":17626271,"change_date":"2025-12-22 21:39:00","inspection_id":"86636528","insp_violation_id":"270852421","seq_no":"6","part_no":"393","part_no_section":"11B-CSURR","insp_viol_unit":"2","insp_unit_id":"210763923","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00SQ00074","created_at":"2025-12-25T10:43:03.000000Z","updated_at":"2026-01-02T10:32:13.000000Z","normalized_code":"39311BCSURR"}],"inspection_per_units":[{"id":17584434,"change_date":"2025-12-22 21:39:00","inspection_id":"86636528","insp_unit_id":"210763922","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRAI","insp_unit_company":"1","insp_unit_license":"9E68310","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGMD1XBDAZ4969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:47.000000Z","updated_at":"2026-01-02T10:01:26.000000Z"},{"id":17584435,"change_date":"2025-12-22 21:39:00","inspection_id":"86636528","insp_unit_id":"210763923","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAN","insp_unit_company":null,"insp_unit_license":"4FS1850","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1B95C1014LC403162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:47.000000Z","updated_at":"2026-01-02T10:01:26.000000Z"}]},{"id":10167433,"change_date":"2025-11-10 21:40:00","inspection_id":"86286506","dot_number":"2707426","report_state":"CA","report_number":"NCNK009534","insp_date":"2025-11-06 00:00:00","insp_start_time":"1710","insp_end_time":"1844","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ENRIQUE RAMIREZ","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-11-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16051803","transaction_code":"A","transaction_date":"2025-11-06 00:00:00","upload_date":"2025-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2025-11-10 21:40:00","snet_input_date":"2025-11-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-10 21:40:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-11-13T10:30:47.000000Z","updated_at":"2025-11-14T10:31:08.000000Z","inspection_violations":[{"id":16880001,"change_date":"2025-11-10 21:40:00","inspection_id":"86286506","insp_violation_id":"269863749","seq_no":"1","part_no":"393","part_no_section":"205A-WRBH","insp_viol_unit":"2","insp_unit_id":"209952084","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA251488","created_at":"2025-11-13T10:31:14.000000Z","updated_at":"2025-11-14T10:32:09.000000Z","normalized_code":"393205AWRBH"},{"id":16880002,"change_date":"2025-11-10 21:40:00","inspection_id":"86286506","insp_violation_id":"269863750","seq_no":"2","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"209952084","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA251488","created_at":"2025-11-13T10:31:14.000000Z","updated_at":"2025-11-14T10:32:09.000000Z","normalized_code":"3963A1BOS"},{"id":16880003,"change_date":"2025-11-10 21:40:00","inspection_id":"86286506","insp_violation_id":"269863751","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"209952084","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-13T10:31:14.000000Z","updated_at":"2025-11-14T10:32:09.000000Z","normalized_code":"39347E"},{"id":16880004,"change_date":"2025-11-10 21:40:00","inspection_id":"86286506","insp_violation_id":"269863752","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"209952084","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-13T10:31:14.000000Z","updated_at":"2025-11-14T10:32:09.000000Z","normalized_code":"39347E"},{"id":16880005,"change_date":"2025-11-10 21:40:00","inspection_id":"86286506","insp_violation_id":"269863753","seq_no":"5","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"209952084","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-13T10:31:14.000000Z","updated_at":"2025-11-14T10:32:09.000000Z","normalized_code":"39353BB"},{"id":16880006,"change_date":"2025-11-10 21:40:00","inspection_id":"86286506","insp_violation_id":"269863754","seq_no":"6","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"209952083","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA251490","created_at":"2025-11-13T10:31:14.000000Z","updated_at":"2025-11-14T10:32:09.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":16929902,"change_date":"2025-11-10 21:40:00","inspection_id":"86286506","insp_unit_id":"209952083","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/09","insp_unit_license":"9G64478","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD66FSGN3231","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:46.000000Z","updated_at":"2025-11-14T10:01:26.000000Z"},{"id":16929903,"change_date":"2025-11-10 21:40:00","inspection_id":"86286506","insp_unit_id":"209952084","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT\/4253","insp_unit_license":"4KF7895","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25379U767611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:46.000000Z","updated_at":"2025-11-14T10:01:26.000000Z"}]},{"id":9872186,"change_date":"2025-10-06 21:41:00","inspection_id":"85975210","dot_number":"2707426","report_state":"CA","report_number":"UGCY000152","insp_date":"2025-10-06 00:00:00","insp_start_time":"0930","insp_end_time":"0958","registration_date":null,"region":"PT","ci_status_code":"C","location":"450","location_desc":"MADERA AREA, 4TH","county_code_state":"CA","county_code":"039","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16008366","transaction_code":"A","transaction_date":"2025-10-06 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2025-10-06 21:41:00","snet_input_date":"2025-10-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-06 21:41:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-09T10:01:02.000000Z","updated_at":"2025-10-10T10:02:00.000000Z","inspection_violations":[{"id":16266406,"change_date":"2025-10-06 21:41:00","inspection_id":"85975210","insp_violation_id":"269135818","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209331364","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:34.000000Z","updated_at":"2025-10-10T10:18:04.000000Z","normalized_code":"3922SLLSR"},{"id":16266407,"change_date":"2025-10-06 21:41:00","inspection_id":"85975210","insp_violation_id":"269135819","seq_no":"2","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-10-09T10:16:34.000000Z","updated_at":"2025-10-10T10:18:04.000000Z","normalized_code":"3922SLLLR"},{"id":16266408,"change_date":"2025-10-06 21:41:00","inspection_id":"85975210","insp_violation_id":"269135820","seq_no":"3","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"209331364","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7M6V0016Y","created_at":"2025-10-09T10:16:34.000000Z","updated_at":"2025-10-10T10:18:04.000000Z","normalized_code":"3922SLLSIV"},{"id":16266409,"change_date":"2025-10-06 21:41:00","inspection_id":"85975210","insp_violation_id":"269135821","seq_no":"4","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"209331364","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:34.000000Z","updated_at":"2025-10-10T10:18:04.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":16374876,"change_date":"2025-10-06 21:41:00","inspection_id":"85975210","insp_unit_id":"209331364","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLU\/06","insp_unit_license":"9F844222","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBGXCSBF3349","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:56.000000Z","updated_at":"2025-10-10T09:47:33.000000Z"},{"id":16374877,"change_date":"2025-10-06 21:41:00","inspection_id":"85975210","insp_unit_id":"209331365","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHI\/SIL REF","insp_unit_license":"4MW3170","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS24887M159901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:56.000000Z","updated_at":"2025-10-10T09:47:33.000000Z"}]},{"id":9180642,"change_date":"2025-07-17 21:42:00","inspection_id":"85248775","dot_number":"2707426","report_state":"CA","report_number":"NFDX000984","insp_date":"2025-07-16 00:00:00","insp_start_time":"1711","insp_end_time":"1849","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RAMIREZ EXPRESS","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-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15903826","transaction_code":"A","transaction_date":"2025-07-16 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2025-07-17 21:42:00","snet_input_date":"2025-07-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-17 21:42:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-07-21T10:43:22.000000Z","updated_at":"2025-07-21T10:43:22.000000Z","inspection_violations":[{"id":14827418,"change_date":"2025-07-17 21:42:00","inspection_id":"85248775","insp_violation_id":"267483758","seq_no":"1","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"207937266","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA251079","created_at":"2025-07-21T10:45:53.000000Z","updated_at":"2025-07-21T10:45:53.000000Z","normalized_code":"3963A1BOS"},{"id":14827419,"change_date":"2025-07-17 21:42:00","inspection_id":"85248775","insp_violation_id":"267483759","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"207937266","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:53.000000Z","updated_at":"2025-07-21T10:45:53.000000Z","normalized_code":"39347E"},{"id":14827420,"change_date":"2025-07-17 21:42:00","inspection_id":"85248775","insp_violation_id":"267483760","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"207937266","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:53.000000Z","updated_at":"2025-07-21T10:45:53.000000Z","normalized_code":"39347E"},{"id":14827421,"change_date":"2025-07-17 21:42:00","inspection_id":"85248775","insp_violation_id":"267483761","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"207937266","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:53.000000Z","updated_at":"2025-07-21T10:45:53.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":15086585,"change_date":"2025-07-17 21:42:00","inspection_id":"85248775","insp_unit_id":"207937265","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/09","insp_unit_license":"9G64478","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD66FSGN3231","insp_unit_decal":"Y","insp_unit_decal_number":"35350064","created_at":"2025-07-20T09:46:34.000000Z","updated_at":"2025-07-21T09:46:24.000000Z"},{"id":15086586,"change_date":"2025-07-17 21:42:00","inspection_id":"85248775","insp_unit_id":"207937266","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT\/4253","insp_unit_license":"4KF7895","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25379U767611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:34.000000Z","updated_at":"2025-07-21T09:46:24.000000Z"}]},{"id":7677707,"change_date":"2025-01-21 21:40:00","inspection_id":"83665396","dot_number":"2707426","report_state":"CA","report_number":"UCH4001510","insp_date":"2025-01-21 00:00:00","insp_start_time":"1240","insp_end_time":"1250","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-01-21 21:40: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":"15672275","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-03-17T20:57:29.000000Z","updated_at":"2025-03-17T20:57:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12389090,"change_date":"2025-01-21 21:40:00","inspection_id":"83665396","insp_unit_id":"204945517","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02 - GRN","insp_unit_license":"9E02059","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG1BLAX8781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:42.000000Z","updated_at":"2025-03-17T23:51:42.000000Z"},{"id":12389091,"change_date":"2025-01-21 21:40:00","inspection_id":"83665396","insp_unit_id":"204945518","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4253","insp_unit_license":"4KF7895","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25379U767611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:42.000000Z","updated_at":"2025-03-17T23:51:42.000000Z"}]},{"id":7306783,"change_date":"2024-11-30 21:33:00","inspection_id":"83275685","dot_number":"2707426","report_state":"CA","report_number":"NAHY007246","insp_date":"2024-11-26 00:00:00","insp_start_time":"0501","insp_end_time":"0532","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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":"2024-11-30 21:33: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":"15609431","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2024-11-30 21:33:00","snet_input_date":"2024-11-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-03-17T20:48:33.000000Z","updated_at":"2025-03-17T20:48:33.000000Z","inspection_violations":[{"id":11423894,"change_date":"2024-11-30 21:33:00","inspection_id":"83275685","insp_violation_id":"263151130","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"204111113","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:33.000000Z","updated_at":"2025-03-17T22:01:33.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":11786853,"change_date":"2024-11-30 21:33:00","inspection_id":"83275685","insp_unit_id":"204111113","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02\/GREEN","insp_unit_license":"9E02059","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG1BLAX8781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:10.000000Z","updated_at":"2025-03-17T23:45:10.000000Z"},{"id":11786854,"change_date":"2024-11-30 21:33:00","inspection_id":"83275685","insp_unit_id":"204111114","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4253","insp_unit_license":"4KF7895","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25379U767611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:10.000000Z","updated_at":"2025-03-17T23:45:10.000000Z"}]},{"id":6965519,"change_date":"2024-10-15 21:43:00","inspection_id":"82914101","dot_number":"2707426","report_state":"CA","report_number":"NEDJ003155","insp_date":"2024-10-02 00:00:00","insp_start_time":"2224","insp_end_time":"2326","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":"PACIFIC CHEESE","shipping_paper_number":"SH1103938","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15556195","transaction_code":"A","transaction_date":"2024-10-03 00:00:00","upload_date":"2024-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2024-10-15 21:43:00","snet_input_date":"2024-10-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-15 21:43:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-03-17T20:41:23.000000Z","updated_at":"2025-03-17T20:41:23.000000Z","inspection_violations":[{"id":10862395,"change_date":"2024-10-15 21:43:00","inspection_id":"82914101","insp_violation_id":"262368673","seq_no":"1","part_no":"393","part_no_section":"47(b)","insp_viol_unit":"1","insp_unit_id":"203424414","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:58:40.000000Z","updated_at":"2025-03-17T21:58:40.000000Z","normalized_code":"39347B"},{"id":10862396,"change_date":"2024-10-15 21:43:00","inspection_id":"82914101","insp_violation_id":"262368674","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203424414","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK12693","created_at":"2025-03-17T21:58:40.000000Z","updated_at":"2025-03-17T21:58:40.000000Z","normalized_code":"3922"},{"id":10862397,"change_date":"2024-10-15 21:43:00","inspection_id":"82914101","insp_violation_id":"262368675","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"203424415","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:58:40.000000Z","updated_at":"2025-03-17T21:58:40.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":11234418,"change_date":"2024-10-15 21:43:00","inspection_id":"82914101","insp_unit_id":"203424414","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"9E02059","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG1BLAX8781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:17.000000Z","updated_at":"2025-03-17T23:39:17.000000Z"},{"id":11234419,"change_date":"2024-10-15 21:43:00","inspection_id":"82914101","insp_unit_id":"203424415","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4253","insp_unit_license":"4KF7895","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25379U767611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:17.000000Z","updated_at":"2025-03-17T23:39:17.000000Z"}]},{"id":6579239,"change_date":"2024-08-27 21:43:00","inspection_id":"82502940","dot_number":"2707426","report_state":"CA","report_number":"UF0F002366","insp_date":"2024-08-26 00:00:00","insp_start_time":"1322","insp_end_time":"1354","registration_date":null,"region":"PT","ci_status_code":"C","location":"461","location_desc":"SANTA NELLA SCALES","county_code_state":"CA","county_code":"047","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PACIFIC CHEESE","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-08-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15498345","transaction_code":"A","transaction_date":"2024-08-26 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2024-08-27 21:43:00","snet_input_date":"2024-08-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-27 21:43:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-03-17T20:33:14.000000Z","updated_at":"2025-03-17T20:33:14.000000Z","inspection_violations":[{"id":10228410,"change_date":"2024-08-27 21:43:00","inspection_id":"82502940","insp_violation_id":"261450238","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202617286","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10606652,"change_date":"2024-08-27 21:43:00","inspection_id":"82502940","insp_unit_id":"202617286","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9E02059","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG1BLAX8781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:53.000000Z","updated_at":"2025-03-17T23:32:53.000000Z"},{"id":10606653,"change_date":"2024-08-27 21:43:00","inspection_id":"82502940","insp_unit_id":"202617287","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4KF7895","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25379U767611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:53.000000Z","updated_at":"2025-03-17T23:32:53.000000Z"}]},{"id":6508223,"change_date":"2024-08-19 21:43:00","inspection_id":"82427380","dot_number":"2707426","report_state":"CA","report_number":"ND7N008413","insp_date":"2024-08-16 00:00:00","insp_start_time":"1347","insp_end_time":"1407","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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-08-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15487581","transaction_code":"A","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2024-08-19 21:43:00","snet_input_date":"2024-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-19 21:43:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:58.000000Z","updated_at":"2025-03-17T20:31:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10491288,"change_date":"2024-08-19 21:43:00","inspection_id":"82427380","insp_unit_id":"202473593","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"07 WHT","insp_unit_license":"9E80939","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG6CSBJ1507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:41.000000Z","updated_at":"2025-03-17T23:31:41.000000Z"},{"id":10491289,"change_date":"2024-08-19 21:43:00","inspection_id":"82427380","insp_unit_id":"202473594","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"R70 WHT","insp_unit_license":"4KB9865","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0623AW700965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:41.000000Z","updated_at":"2025-03-17T23:31:41.000000Z"}]},{"id":6507482,"change_date":"2024-08-19 21:43:00","inspection_id":"82426623","dot_number":"2707426","report_state":"CA","report_number":"NCNK007782","insp_date":"2024-08-15 00:00:00","insp_start_time":"0643","insp_end_time":"0817","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ECHOSPHERE CORP","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15488055","transaction_code":"A","transaction_date":"2024-08-15 00:00:00","upload_date":"2024-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2024-08-19 21:43:00","snet_input_date":"2024-08-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-19 21:43:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-03-17T20:31:57.000000Z","updated_at":"2025-03-17T20:31:57.000000Z","inspection_violations":[{"id":10107568,"change_date":"2024-08-19 21:43:00","inspection_id":"82426623","insp_violation_id":"261279402","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"202472360","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA248752","created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"39375A3"},{"id":10107569,"change_date":"2024-08-19 21:43:00","inspection_id":"82426623","insp_violation_id":"261279403","seq_no":"2","part_no":"393","part_no_section":"43(a)","insp_viol_unit":"1","insp_unit_id":"202472359","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA248752","created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"39343A"},{"id":10107570,"change_date":"2024-08-19 21:43:00","inspection_id":"82426623","insp_violation_id":"261279404","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202472359","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK88217","created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3939A"},{"id":10107571,"change_date":"2024-08-19 21:43:00","inspection_id":"82426623","insp_violation_id":"261279405","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202472359","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK88217","created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3922"},{"id":10107572,"change_date":"2024-08-19 21:43:00","inspection_id":"82426623","insp_violation_id":"261279406","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"202472359","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3965B"},{"id":10107573,"change_date":"2024-08-19 21:43:00","inspection_id":"82426623","insp_violation_id":"261279407","seq_no":"6","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"1","insp_unit_id":"202472359","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"39524D"},{"id":10107574,"change_date":"2024-08-19 21:43:00","inspection_id":"82426623","insp_violation_id":"261279408","seq_no":"7","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"202472360","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"39355E"},{"id":10107575,"change_date":"2024-08-19 21:43:00","inspection_id":"82426623","insp_violation_id":"261279409","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"202472360","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10490117,"change_date":"2024-08-19 21:43:00","inspection_id":"82426623","insp_unit_id":"202472359","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/07","insp_unit_license":"9E80939","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG6CSBJ1507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:41.000000Z","updated_at":"2025-03-17T23:31:41.000000Z"},{"id":10490118,"change_date":"2024-08-19 21:43:00","inspection_id":"82426623","insp_unit_id":"202472360","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT\/R70","insp_unit_license":"4KB9865","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0623AW700965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:41.000000Z","updated_at":"2025-03-17T23:31:41.000000Z"}]},{"id":5822582,"change_date":"2024-05-22 21:41:00","inspection_id":"81689889","dot_number":"2707426","report_state":"CA","report_number":"NCNK007465","insp_date":"2024-05-21 00:00:00","insp_start_time":"0653","insp_end_time":"1111","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ENRIQUE RAMIREZ","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-22 21:41: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":"15374681","transaction_code":"A","transaction_date":"2024-05-21 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2024-05-22 21:41:00","snet_input_date":"2024-05-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-22 21:41:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-03-17T20:18:14.000000Z","updated_at":"2025-03-17T20:18:14.000000Z","inspection_violations":[{"id":9021122,"change_date":"2024-05-22 21:41:00","inspection_id":"81689889","insp_violation_id":"259681947","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"201044336","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:39.000000Z","updated_at":"2025-03-17T21:49:39.000000Z","normalized_code":"39395F"},{"id":9021123,"change_date":"2024-05-22 21:41:00","inspection_id":"81689889","insp_violation_id":"259681948","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201044336","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:39.000000Z","updated_at":"2025-03-17T21:49:39.000000Z","normalized_code":"3922"},{"id":9021124,"change_date":"2024-05-22 21:41:00","inspection_id":"81689889","insp_violation_id":"259681949","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"201044336","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:39.000000Z","updated_at":"2025-03-17T21:49:39.000000Z","normalized_code":"39345D"},{"id":9021125,"change_date":"2024-05-22 21:41:00","inspection_id":"81689889","insp_violation_id":"259681950","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"201044337","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:39.000000Z","updated_at":"2025-03-17T21:49:39.000000Z","normalized_code":"39355E"},{"id":9021126,"change_date":"2024-05-22 21:41:00","inspection_id":"81689889","insp_violation_id":"259681951","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201044337","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:39.000000Z","updated_at":"2025-03-17T21:49:39.000000Z","normalized_code":"3963A1"},{"id":9021127,"change_date":"2024-05-22 21:41:00","inspection_id":"81689889","insp_violation_id":"259681952","seq_no":"6","part_no":"396","part_no_section":"5(a)","insp_viol_unit":"2","insp_unit_id":"201044337","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA248414","created_at":"2025-03-17T21:49:39.000000Z","updated_at":"2025-03-17T21:49:39.000000Z","normalized_code":"3965A"}],"inspection_per_units":[{"id":9377525,"change_date":"2024-05-22 21:41:00","inspection_id":"81689889","insp_unit_id":"201044336","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/07","insp_unit_license":"9E80939","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG6CSBJ1507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:21.000000Z","updated_at":"2025-03-17T23:20:21.000000Z"},{"id":9377526,"change_date":"2024-05-22 21:41:00","inspection_id":"81689889","insp_unit_id":"201044337","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT\/R71","insp_unit_license":"4VR1905","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XAW703636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:21.000000Z","updated_at":"2025-03-17T23:20:21.000000Z"}]},{"id":5345095,"change_date":"2024-03-21 21:42:00","inspection_id":"81169806","dot_number":"2707426","report_state":"CA","report_number":"UFWH000541","insp_date":"2024-03-20 00:00:00","insp_start_time":"0838","insp_end_time":"0859","registration_date":null,"region":"PT","ci_status_code":"C","location":"805","location_desc":"SB 99 @ WHITMORE AVE","county_code_state":"CA","county_code":"099","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":"2024-03-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15289040","transaction_code":"A","transaction_date":"2024-03-20 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2024-03-21 21:42:00","snet_input_date":"2024-03-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-21 21:42:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-03-17T20:08:39.000000Z","updated_at":"2025-03-17T20:08:39.000000Z","inspection_violations":[{"id":8247854,"change_date":"2024-03-21 21:42:00","inspection_id":"81169806","insp_violation_id":"258526847","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"200037553","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW919835","created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"39021TA"},{"id":8247855,"change_date":"2024-03-21 21:42:00","inspection_id":"81169806","insp_violation_id":"258526848","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"200037553","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW919835","created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"39021TB"},{"id":8247856,"change_date":"2024-03-21 21:42:00","inspection_id":"81169806","insp_violation_id":"258526849","seq_no":"3","part_no":"392","part_no_section":"80(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MJ64557","created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"39280A"}],"inspection_per_units":[{"id":8607867,"change_date":"2024-03-21 21:42:00","inspection_id":"81169806","insp_unit_id":"200037553","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G76919","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ6GN945328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:04.000000Z","updated_at":"2025-03-17T23:13:04.000000Z"},{"id":8607868,"change_date":"2024-03-21 21:42:00","inspection_id":"81169806","insp_unit_id":"200037554","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"4VR1905","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XAW703636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:04.000000Z","updated_at":"2025-03-17T23:13:04.000000Z"}]},{"id":4679525,"change_date":"2023-12-20 21:42:00","inspection_id":"80443057","dot_number":"2707426","report_state":"CA","report_number":"UFCR002744","insp_date":"2023-12-19 00:00:00","insp_start_time":"0950","insp_end_time":"1032","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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":"2023-12-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15176033","transaction_code":"A","transaction_date":"2023-12-19 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2023-12-20 21:42:00","snet_input_date":"2023-12-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-20 21:42:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-03-17T19:55:26.000000Z","updated_at":"2025-03-17T19:55:26.000000Z","inspection_violations":[{"id":7232047,"change_date":"2023-12-20 21:42:00","inspection_id":"80443057","insp_violation_id":"256999312","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:55.000000Z","updated_at":"2025-03-17T21:40:55.000000Z","normalized_code":"3922"},{"id":7232048,"change_date":"2023-12-20 21:42:00","inspection_id":"80443057","insp_violation_id":"256999313","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KW78987","created_at":"2025-03-17T21:40:55.000000Z","updated_at":"2025-03-17T21:40:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7526450,"change_date":"2023-12-20 21:42:00","inspection_id":"80443057","insp_unit_id":"198610421","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"9E55865","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJSJR2EN760069","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:18.000000Z","updated_at":"2025-03-17T23:03:18.000000Z"},{"id":7526451,"change_date":"2023-12-20 21:42:00","inspection_id":"80443057","insp_unit_id":"198610422","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"4VR1905","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XAW703636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:18.000000Z","updated_at":"2025-03-17T23:03:18.000000Z"}]},{"id":3417525,"change_date":"2023-06-30 21:41:00","inspection_id":"79041429","dot_number":"2707426","report_state":"CA","report_number":"UBJR000389","insp_date":"2023-06-27 00:00:00","insp_start_time":"2252","insp_end_time":"2338","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":"PACIFIC CHEESE HAYWARD","shipping_paper_number":"SO435949","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"4","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14965428","transaction_code":"A","transaction_date":"2023-06-28 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2023-06-30 21:41:00","snet_input_date":"2023-06-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-30 21:41:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-03-17T19:30:37.000000Z","updated_at":"2025-03-17T19:30:37.000000Z","inspection_violations":[{"id":5268833,"change_date":"2023-06-30 21:41:00","inspection_id":"79041429","insp_violation_id":"253829987","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195792354","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KR31030","created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3922"},{"id":5268834,"change_date":"2023-06-30 21:41:00","inspection_id":"79041429","insp_violation_id":"253829988","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"195792353","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"39345"},{"id":5268835,"change_date":"2023-06-30 21:41:00","inspection_id":"79041429","insp_violation_id":"253829989","seq_no":"3","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"195792353","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"39345"},{"id":5268836,"change_date":"2023-06-30 21:41:00","inspection_id":"79041429","insp_violation_id":"253829990","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195792354","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5494617,"change_date":"2023-06-30 21:41:00","inspection_id":"79041429","insp_unit_id":"195792353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"03","insp_unit_license":"9E16673","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPXD49XXCD137324","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:20.000000Z","updated_at":"2025-03-17T22:46:20.000000Z"},{"id":5494618,"change_date":"2023-06-30 21:41:00","inspection_id":"79041429","insp_unit_id":"195792354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"5543","insp_unit_license":"4SL1151","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA06217W700066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:20.000000Z","updated_at":"2025-03-17T22:46:20.000000Z"}]},{"id":3267020,"change_date":"2023-06-12 21:41:00","inspection_id":"78871811","dot_number":"2707426","report_state":"CA","report_number":"UFEV002338","insp_date":"2023-06-10 00:00:00","insp_start_time":"1225","insp_end_time":"1242","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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":"2023-06-12 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":"14938337","transaction_code":"A","transaction_date":"2023-06-10 00:00:00","upload_date":"2023-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2023-06-12 21:41:00","snet_input_date":"2023-06-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-12 21:41:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-03-17T19:27:42.000000Z","updated_at":"2025-03-17T19:27:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5253832,"change_date":"2023-06-12 21:41:00","inspection_id":"78871811","insp_unit_id":"195457304","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"03","insp_unit_license":"9E16673","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPXD49XXCD137324","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:24.000000Z","updated_at":"2025-03-17T22:44:24.000000Z"}]},{"id":2022055,"change_date":"2022-12-27 21:40:00","inspection_id":"77457089","dot_number":"2707426","report_state":"CA","report_number":"UBVF002472","insp_date":"2022-12-26 00:00:00","insp_start_time":"1026","insp_end_time":"1148","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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-12-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14720588","transaction_code":"A","transaction_date":"2022-12-26 00:00:00","upload_date":"2022-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02707426","upload_search_indicator":null,"census_search_date":"2022-12-27 21:40:00","snet_input_date":"2022-12-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-27 21:40:00","insp_carrier_name":"ENRIQUE RAMIREZ","insp_carrier_street":"331 OXNARD STREET","insp_carrier_city":"MENDOTA","insp_carrier_state":"CA","insp_carrier_zip_code":"93640","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"447017","created_at":"2025-03-17T19:03:58.000000Z","updated_at":"2025-03-17T19:03:58.000000Z","inspection_violations":[{"id":3136484,"change_date":"2022-12-27 21:40:00","inspection_id":"77457089","insp_violation_id":"250280828","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:50.000000Z","updated_at":"2025-03-17T21:21:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3253370,"change_date":"2022-12-27 21:40:00","inspection_id":"77457089","insp_unit_id":"192595856","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02 GRN","insp_unit_license":"9E02059","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG1BLAX8781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:17.000000Z","updated_at":"2025-03-17T22:29:17.000000Z"},{"id":3253371,"change_date":"2022-12-27 21:40:00","inspection_id":"77457089","insp_unit_id":"192595857","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT","insp_unit_license":"4KL7026","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XAW703636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:17.000000Z","updated_at":"2025-03-17T22:29:17.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2707426\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2707426\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2707426\/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\/2707426\/inspections","per_page":100,"prev_page_url":null,"to":27,"total":27}