{"current_page":1,"data":[{"id":12569373,"change_date":"2026-07-28 21:41:00","inspection_id":"88537297","dot_number":"4385189","report_state":"CA","report_number":"UEFD000633","insp_date":"2026-07-22 00:00:00","insp_start_time":"1040","insp_end_time":"1115","registration_date":null,"region":"PD","ci_status_code":"C","location":"646","location_desc":"CA","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONMEX","shipping_paper_number":"A6652","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"103350","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":"3854404","transaction_code":"A","transaction_date":"2026-07-28 00:00:00","upload_date":"2026-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-07-28 21:41:00","snet_input_date":"2026-07-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-28 21:41:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-31T09:41:28.000000Z","updated_at":"2026-08-08T09:31:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21824682,"change_date":"2026-07-28 21:41:00","inspection_id":"88537297","insp_unit_id":"214856798","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"52 WHT","insp_unit_license":"9H34270","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4N39EG6FN910159","insp_unit_decal":"Y","insp_unit_decal_number":"36551585","created_at":"2026-07-31T09:18:06.000000Z","updated_at":"2026-08-08T09:02:35.000000Z"},{"id":21824683,"change_date":"2026-07-28 21:41:00","inspection_id":"88537297","insp_unit_id":"214856799","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALLCO","insp_unit_company":"A5 WHT","insp_unit_license":"4SL1518","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BS2012TC152621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-31T09:18:06.000000Z","updated_at":"2026-08-08T09:02:35.000000Z"},{"id":21824684,"change_date":"2026-07-28 21:41:00","inspection_id":"88537297","insp_unit_id":"214856800","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"ALLCO","insp_unit_company":"A6 WHT","insp_unit_license":"4SL1519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BP3024TC152622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-31T09:18:06.000000Z","updated_at":"2026-08-08T09:02:35.000000Z"}]},{"id":12550282,"change_date":"2026-07-25 21:35:00","inspection_id":"88517224","dot_number":"4385189","report_state":"CA","report_number":"UDIS000943","insp_date":"2026-07-20 00:00:00","insp_start_time":"1132","insp_end_time":"1141","registration_date":null,"region":"PD","ci_status_code":"C","location":"646","location_desc":"CA","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONMEX INC","shipping_paper_number":"G4268","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-25 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"100350","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":"3835486","transaction_code":"A","transaction_date":"2026-07-25 00:00:00","upload_date":"2026-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-07-25 21:35:00","snet_input_date":"2026-07-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-25 21:35:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"659125","created_at":"2026-07-28T09:41:41.000000Z","updated_at":"2026-08-05T09:31:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21792838,"change_date":"2026-07-25 21:35:00","inspection_id":"88517224","insp_unit_id":"214819750","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"39 RED","insp_unit_license":"9H08142","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV7HSHN1753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-28T09:19:08.000000Z","updated_at":"2026-08-05T09:01:55.000000Z"},{"id":21792839,"change_date":"2026-07-25 21:35:00","inspection_id":"88517224","insp_unit_id":"214819751","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAGN","insp_unit_company":"A1 WHI","insp_unit_license":"4GS4299","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UNSD22125C034945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-28T09:19:08.000000Z","updated_at":"2026-08-05T09:01:55.000000Z"},{"id":21792840,"change_date":"2026-07-25 21:35:00","inspection_id":"88517224","insp_unit_id":"214819752","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"DRAGN","insp_unit_company":"A2 WHI","insp_unit_license":"4KG8630","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UNSD22235C034946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-28T09:19:08.000000Z","updated_at":"2026-08-05T09:01:55.000000Z"}]},{"id":12550526,"change_date":"2026-07-25 21:35:00","inspection_id":"88517478","dot_number":"4385189","report_state":"CA","report_number":"N9Y4008992","insp_date":"2026-07-20 00:00:00","insp_start_time":"1052","insp_end_time":"1157","registration_date":null,"region":"PD","ci_status_code":"C","location":"646","location_desc":"CA","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"G4302","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-25 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"103350","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3835460","transaction_code":"A","transaction_date":"2026-07-25 00:00:00","upload_date":"2026-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-07-25 21:35:00","snet_input_date":"2026-07-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-25 21:35:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"659125","created_at":"2026-07-28T09:41:42.000000Z","updated_at":"2026-08-05T09:31:08.000000Z","inspection_violations":[{"id":21850757,"change_date":"2026-07-25 21:35:00","inspection_id":"88517478","insp_violation_id":"275735850","seq_no":"1","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"214820197","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA641629","created_at":"2026-07-28T10:02:35.000000Z","updated_at":"2026-08-05T09:42:27.000000Z","normalized_code":"39311A1LHLM"},{"id":21850758,"change_date":"2026-07-25 21:35:00","inspection_id":"88517478","insp_violation_id":"275735851","seq_no":"2","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"214820197","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA641629","created_at":"2026-07-28T10:02:35.000000Z","updated_at":"2026-08-05T09:42:27.000000Z","normalized_code":"3963A1BALAC"},{"id":21850759,"change_date":"2026-07-25 21:35:00","inspection_id":"88517478","insp_violation_id":"275735852","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"214820197","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA641629","created_at":"2026-07-28T10:02:35.000000Z","updated_at":"2026-08-05T09:42:27.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":21793264,"change_date":"2026-07-25 21:35:00","inspection_id":"88517478","insp_unit_id":"214820198","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALLCO","insp_unit_company":"A5\/WHT","insp_unit_license":"4SL1518","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BS2012TC152621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-28T09:19:09.000000Z","updated_at":"2026-08-05T09:01:59.000000Z"},{"id":21793265,"change_date":"2026-07-25 21:35:00","inspection_id":"88517478","insp_unit_id":"214820199","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"ALLCO","insp_unit_company":"A6\/WHT","insp_unit_license":"4SL1519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BP3024TC152622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-28T09:19:09.000000Z","updated_at":"2026-08-05T09:01:59.000000Z"},{"id":21793263,"change_date":"2026-07-25 21:35:00","inspection_id":"88517478","insp_unit_id":"214820197","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"52\/WHT","insp_unit_license":"9H34270","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4N39EG6FN910159","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-28T09:19:09.000000Z","updated_at":"2026-08-05T09:01:59.000000Z"}]},{"id":12497263,"change_date":"2026-07-20 21:39:00","inspection_id":"88460898","dot_number":"4385189","report_state":"CA","report_number":"UEFD000618","insp_date":"2026-07-17 00:00:00","insp_start_time":"1320","insp_end_time":"1331","registration_date":null,"region":"PD","ci_status_code":"C","location":"646","location_desc":"CA","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONMEX INC","shipping_paper_number":"G4262","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"87000","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":"3795127","transaction_code":"A","transaction_date":"2026-07-20 00:00:00","upload_date":"2026-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-07-20 21:39:00","snet_input_date":"2026-07-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-20 21:39:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-23T09:41:14.000000Z","updated_at":"2026-07-31T09:30:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21704724,"change_date":"2026-07-20 21:39:00","inspection_id":"88460898","insp_unit_id":"214713916","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"WHT TT","insp_unit_license":"9H34270","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4N39EG6FN910159","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-23T09:17:35.000000Z","updated_at":"2026-07-31T09:02:05.000000Z"},{"id":21704725,"change_date":"2026-07-20 21:39:00","inspection_id":"88460898","insp_unit_id":"214713917","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALLCO","insp_unit_company":"A5 WHT","insp_unit_license":"4SL1518","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BS2012TC152621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-23T09:17:35.000000Z","updated_at":"2026-07-31T09:02:05.000000Z"}]},{"id":12429984,"change_date":"2026-07-12 21:34:00","inspection_id":"88388919","dot_number":"4385189","report_state":"CA","report_number":"NAOF007866","insp_date":"2026-07-09 00:00:00","insp_start_time":"1444","insp_end_time":"1529","registration_date":null,"region":"PD","ci_status_code":"C","location":"646","location_desc":"CA","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONMEX","shipping_paper_number":"G4216  G4217","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-12 21:34: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":"3736546","transaction_code":"A","transaction_date":"2026-07-12 00:00:00","upload_date":"2026-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-07-12 21:34:00","snet_input_date":"2026-07-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-12 21:34:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"659125","created_at":"2026-07-15T09:40:12.000000Z","updated_at":"2026-07-23T09:30:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21592523,"change_date":"2026-07-12 21:34:00","inspection_id":"88388919","insp_unit_id":"214575967","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"45 WHT","insp_unit_license":"9H08082","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGBDV4ELFW6461","insp_unit_decal":"Y","insp_unit_decal_number":"36550974","created_at":"2026-07-15T09:16:43.000000Z","updated_at":"2026-07-23T09:01:37.000000Z"},{"id":21592524,"change_date":"2026-07-12 21:34:00","inspection_id":"88388919","insp_unit_id":"214575968","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ACE","insp_unit_company":"13 WHT","insp_unit_license":"4UE9487","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A913865120074001","insp_unit_decal":"Y","insp_unit_decal_number":"36550975","created_at":"2026-07-15T09:16:43.000000Z","updated_at":"2026-07-23T09:01:37.000000Z"},{"id":21592525,"change_date":"2026-07-12 21:34:00","inspection_id":"88388919","insp_unit_id":"214575969","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"ACE","insp_unit_company":"A4 WHT","insp_unit_license":"4UE9488","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A923866520074001","insp_unit_decal":"Y","insp_unit_decal_number":"36550976","created_at":"2026-07-15T09:16:43.000000Z","updated_at":"2026-07-23T09:01:37.000000Z"}]},{"id":12316082,"change_date":"2026-06-29 21:42:00","inspection_id":"88273846","dot_number":"4385189","report_state":"CA","report_number":"UCIW001220","insp_date":"2026-06-23 00:00:00","insp_start_time":"1419","insp_end_time":"1446","registration_date":null,"region":"PD","ci_status_code":"C","location":"646","location_desc":"CA","county_code_state":"CA","county_code":"073","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":"U","pen_cen_match":"I","final_status_date":"2026-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"188000","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":"3649161","transaction_code":"A","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-06-29 21:42:00","snet_input_date":"2026-06-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-29 21:42:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-02T09:40:43.000000Z","updated_at":"2026-07-10T09:31:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21390584,"change_date":"2026-06-29 21:42:00","inspection_id":"88273846","insp_unit_id":"214356302","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9H08082","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGBDV4ELFW6461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:43.000000Z","updated_at":"2026-07-10T09:03:04.000000Z"},{"id":21390585,"change_date":"2026-06-29 21:42:00","inspection_id":"88273846","insp_unit_id":"214356303","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ACE","insp_unit_company":null,"insp_unit_license":"4UE9487","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A913865120074001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:43.000000Z","updated_at":"2026-07-10T09:03:04.000000Z"},{"id":21390586,"change_date":"2026-06-29 21:42:00","inspection_id":"88273846","insp_unit_id":"214356304","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"ACE","insp_unit_company":null,"insp_unit_license":"4UE9488","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A923866520074001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:43.000000Z","updated_at":"2026-07-10T09:03:04.000000Z"}]},{"id":12151667,"change_date":"2026-06-10 21:45:00","inspection_id":"88100899","dot_number":"4385189","report_state":"CA","report_number":"NAOF007786","insp_date":"2026-06-04 00:00:00","insp_start_time":"1044","insp_end_time":"1139","registration_date":null,"region":"PS","ci_status_code":"C","location":"646","location_desc":"CA","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LOMA TOVA","shipping_paper_number":"G3951   G3952","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-10 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"107000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3513261","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":"04385189","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":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:33.000000Z","updated_at":"2026-06-21T09:31:37.000000Z","inspection_violations":[{"id":21148593,"change_date":"2026-06-10 21:45:00","inspection_id":"88100899","insp_violation_id":"274822069","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"214020915","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-13T10:02:48.000000Z","updated_at":"2026-06-21T09:46:01.000000Z","normalized_code":"3939ALHLI"},{"id":21148595,"change_date":"2026-06-10 21:45:00","inspection_id":"88100899","insp_violation_id":"274822071","seq_no":"3","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"3","insp_unit_id":"214020917","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-13T10:02:48.000000Z","updated_at":"2026-06-21T09:46:01.000000Z","normalized_code":"3965BHWSL"},{"id":21148596,"change_date":"2026-06-10 21:45:00","inspection_id":"88100899","insp_violation_id":"274822072","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"3","insp_unit_id":"214020917","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-13T10:02:48.000000Z","updated_at":"2026-06-21T09:46:01.000000Z","normalized_code":"39347E"},{"id":21148597,"change_date":"2026-06-10 21:45:00","inspection_id":"88100899","insp_violation_id":"274822073","seq_no":"5","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"3","insp_unit_id":"214020917","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-13T10:02:48.000000Z","updated_at":"2026-06-21T09:46:01.000000Z","normalized_code":"3922SLLEQP"},{"id":21148594,"change_date":"2026-06-10 21:45:00","inspection_id":"88100899","insp_violation_id":"274822070","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"2","insp_unit_id":"214020916","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA641239","created_at":"2026-06-13T10:02:48.000000Z","updated_at":"2026-06-21T09:46:01.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":21109031,"change_date":"2026-06-10 21:45:00","inspection_id":"88100899","insp_unit_id":"214020915","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"44 WHT","insp_unit_license":"9G81676","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV8DSFK1102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:02.000000Z","updated_at":"2026-06-21T09:03:09.000000Z"},{"id":21109032,"change_date":"2026-06-10 21:45:00","inspection_id":"88100899","insp_unit_id":"214020916","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"A09 WHT","insp_unit_license":"4WW3771","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:02.000000Z","updated_at":"2026-06-21T09:03:09.000000Z"},{"id":21109033,"change_date":"2026-06-10 21:45:00","inspection_id":"88100899","insp_unit_id":"214020917","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"A10 WHT","insp_unit_license":"4WW3768","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:02.000000Z","updated_at":"2026-06-21T09:03:09.000000Z"}]},{"id":12007012,"change_date":"2026-05-24 21:33:00","inspection_id":"87945836","dot_number":"4385189","report_state":"CA","report_number":"UEFD000444","insp_date":"2026-05-22 00:00:00","insp_start_time":"0830","insp_end_time":"0848","registration_date":null,"region":"PS","ci_status_code":"C","location":"646","location_desc":"CA","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONMEX INC","shipping_paper_number":"A5901-A5902","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-24 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"84000","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":"3394077","transaction_code":"A","transaction_date":"2026-05-24 00:00:00","upload_date":"2026-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-05-24 21:33:00","snet_input_date":"2026-05-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-24 21:33:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-27T09:39:48.000000Z","updated_at":"2026-06-05T09:30:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20872052,"change_date":"2026-05-24 21:33:00","inspection_id":"87945836","insp_unit_id":"213731081","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"44 GRY","insp_unit_license":"9G81676","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV8DSFK1102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-27T09:17:03.000000Z","updated_at":"2026-06-05T09:02:05.000000Z"},{"id":20872053,"change_date":"2026-05-24 21:33:00","inspection_id":"87945836","insp_unit_id":"213731082","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"A9","insp_unit_license":"4WW3768","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-27T09:17:03.000000Z","updated_at":"2026-06-05T09:02:05.000000Z"}]},{"id":11941407,"change_date":"2026-05-16 21:38:00","inspection_id":"87876540","dot_number":"4385189","report_state":"CA","report_number":"ND4C007818","insp_date":"2026-05-13 00:00:00","insp_start_time":"1015","insp_end_time":"1110","registration_date":null,"region":"PS","ci_status_code":"C","location":"646","location_desc":"CA","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONMEX INC.","shipping_paper_number":"G3733","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"109000","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":"3343286","transaction_code":"A","transaction_date":"2026-05-16 00:00:00","upload_date":"2026-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-05-16 21:38:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-16 21:38:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"659125","created_at":"2026-05-19T09:41:16.000000Z","updated_at":"2026-05-27T09:30:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20765118,"change_date":"2026-05-16 21:38:00","inspection_id":"87876540","insp_unit_id":"213602895","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT33","insp_unit_license":"9G30684","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGADV8DLBW3611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-19T09:20:11.000000Z","updated_at":"2026-05-27T09:03:27.000000Z"},{"id":20765119,"change_date":"2026-05-16 21:38:00","inspection_id":"87876540","insp_unit_id":"213602896","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAGN","insp_unit_company":"WHT","insp_unit_license":"4GS4299","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UNSD22125C034945","insp_unit_decal":"Y","insp_unit_decal_number":"36224205","created_at":"2026-05-19T09:20:11.000000Z","updated_at":"2026-05-27T09:03:27.000000Z"},{"id":20765120,"change_date":"2026-05-16 21:38:00","inspection_id":"87876540","insp_unit_id":"213602897","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"DRAGN","insp_unit_company":"WHT","insp_unit_license":"4KG8630","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UNSD22235C034946","insp_unit_decal":"Y","insp_unit_decal_number":"36224206","created_at":"2026-05-19T09:20:11.000000Z","updated_at":"2026-05-27T09:03:27.000000Z"}]},{"id":11492639,"change_date":"2026-03-26 21:40:00","inspection_id":"87412406","dot_number":"4385189","report_state":"CA","report_number":"UCIW001129","insp_date":"2026-03-24 00:00:00","insp_start_time":"1400","insp_end_time":"1425","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE","county_code_state":"CA","county_code":"073","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-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"98000","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":"16225314","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-03-26 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-26 21:40:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-29T09:54:23.000000Z","updated_at":"2026-04-06T09:34:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19687293,"change_date":"2026-03-26 21:40:00","inspection_id":"87412406","insp_unit_id":"212366520","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9H14008","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV8HDHV9512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:51:07.000000Z","updated_at":"2026-04-06T09:14:14.000000Z"},{"id":19687294,"change_date":"2026-03-26 21:40:00","inspection_id":"87412406","insp_unit_id":"212366521","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALLK","insp_unit_company":null,"insp_unit_license":"4WX7258","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BS2012WC411032","insp_unit_decal":"Y","insp_unit_decal_number":"35912806","created_at":"2026-03-29T09:51:07.000000Z","updated_at":"2026-04-06T09:14:14.000000Z"},{"id":19687295,"change_date":"2026-03-26 21:40:00","inspection_id":"87412406","insp_unit_id":"212366522","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"ALLK","insp_unit_company":null,"insp_unit_license":"4WS4465","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BP3022WC411032","insp_unit_decal":"Y","insp_unit_decal_number":"35912807","created_at":"2026-03-29T09:51:07.000000Z","updated_at":"2026-04-06T09:14:14.000000Z"}]},{"id":11479847,"change_date":"2026-03-25 21:40:00","inspection_id":"87398924","dot_number":"4385189","report_state":"CA","report_number":"UEFD000333","insp_date":"2026-03-20 00:00:00","insp_start_time":"1100","insp_end_time":"1128","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONCRETOS AGREGADOS","shipping_paper_number":"G3319","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16222141","transaction_code":"A","transaction_date":"2026-03-20 00:00:00","upload_date":"2026-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-03-25 21:40:00","snet_input_date":"2026-03-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-25 21:40:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-28T09:44:52.000000Z","updated_at":"2026-04-05T09:33:31.000000Z","inspection_violations":[{"id":19379467,"change_date":"2026-03-25 21:40:00","inspection_id":"87398924","insp_violation_id":"272643790","seq_no":"1","part_no":"393","part_no_section":"201A-FRCLS","insp_viol_unit":"3","insp_unit_id":"212339879","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:09.000000Z","updated_at":"2026-04-05T10:02:15.000000Z","normalized_code":"393201AFRCLS"},{"id":19379468,"change_date":"2026-03-25 21:40:00","inspection_id":"87398924","insp_violation_id":"272643791","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"212339878","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA640783","created_at":"2026-03-28T10:12:09.000000Z","updated_at":"2026-04-05T10:02:15.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":19663841,"change_date":"2026-03-25 21:40:00","inspection_id":"87398924","insp_unit_id":"212339877","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"42 WHT","insp_unit_license":"9H14008","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV8HDHV9512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:04.000000Z","updated_at":"2026-04-05T09:19:36.000000Z"},{"id":19663842,"change_date":"2026-03-25 21:40:00","inspection_id":"87398924","insp_unit_id":"212339878","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALLK","insp_unit_company":"A13 BLK","insp_unit_license":"4WX7258","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BS2012WC411032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:04.000000Z","updated_at":"2026-04-05T09:19:36.000000Z"},{"id":19663843,"change_date":"2026-03-25 21:40:00","inspection_id":"87398924","insp_unit_id":"212339879","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"ALLK","insp_unit_company":"A14 BLK","insp_unit_license":"4WS4465","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BP3022WC411032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:04.000000Z","updated_at":"2026-04-05T09:19:36.000000Z"}]},{"id":11479358,"change_date":"2026-03-25 21:40:00","inspection_id":"87398425","dot_number":"4385189","report_state":"CA","report_number":"NAOF007622","insp_date":"2026-03-19 00:00:00","insp_start_time":"1224","insp_end_time":"1315","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"OTAY MESA IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONCRETOS Y AGGRGADOS","shipping_paper_number":"G3319","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-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16223310","transaction_code":"A","transaction_date":"2026-03-20 00:00:00","upload_date":"2026-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-03-25 21:40:00","snet_input_date":"2026-03-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-25 21:40:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"659125","created_at":"2026-03-28T09:44:51.000000Z","updated_at":"2026-04-05T09:33:09.000000Z","inspection_violations":[{"id":19378847,"change_date":"2026-03-25 21:40:00","inspection_id":"87398425","insp_violation_id":"272643152","seq_no":"1","part_no":"393","part_no_section":"40A-B","insp_viol_unit":"2","insp_unit_id":"212339072","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-28T10:12:07.000000Z","updated_at":"2026-04-05T10:02:09.000000Z","normalized_code":"39340AB"},{"id":19378848,"change_date":"2026-03-25 21:40:00","inspection_id":"87398425","insp_violation_id":"272643153","seq_no":"2","part_no":"393","part_no_section":"201A-FRCLS","insp_viol_unit":"3","insp_unit_id":"212339073","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:07.000000Z","updated_at":"2026-04-05T10:02:09.000000Z","normalized_code":"393201AFRCLS"},{"id":19378849,"change_date":"2026-03-25 21:40:00","inspection_id":"87398425","insp_violation_id":"272643154","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"3","insp_unit_id":"212339073","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA642029","created_at":"2026-03-28T10:12:07.000000Z","updated_at":"2026-04-05T10:02:09.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":19663068,"change_date":"2026-03-25 21:40:00","inspection_id":"87398425","insp_unit_id":"212339072","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALLCO","insp_unit_company":"A13 BLK","insp_unit_license":"4WX7258","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BS2012WC411032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:03.000000Z","updated_at":"2026-04-05T09:19:27.000000Z"},{"id":19663067,"change_date":"2026-03-25 21:40:00","inspection_id":"87398425","insp_unit_id":"212339071","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"42 WHT","insp_unit_license":"9H14008","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV8HDHV9512","insp_unit_decal":"Y","insp_unit_decal_number":"35912895","created_at":"2026-03-28T09:23:03.000000Z","updated_at":"2026-04-05T09:19:27.000000Z"},{"id":19663069,"change_date":"2026-03-25 21:40:00","inspection_id":"87398425","insp_unit_id":"212339073","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"ALLCO","insp_unit_company":"A 14 BLK","insp_unit_license":"4WS4465","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BP3022WC411032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:03.000000Z","updated_at":"2026-04-05T09:19:27.000000Z"}]},{"id":11391871,"change_date":"2026-03-16 21:39:00","inspection_id":"87306438","dot_number":"4385189","report_state":"CA","report_number":"UEFD000312","insp_date":"2026-03-12 00:00:00","insp_start_time":"1321","insp_end_time":"1327","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"G3279-G3280","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"16209005","transaction_code":"A","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-03-16 21:39:00","snet_input_date":"2026-03-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-16 21:39:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-19T09:38:00.000000Z","updated_at":"2026-03-27T09:32:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19508168,"change_date":"2026-03-16 21:39:00","inspection_id":"87306438","insp_unit_id":"212167915","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"42 WHT","insp_unit_license":"9H14008","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV8HDHV9512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-19T09:12:49.000000Z","updated_at":"2026-03-27T09:06:27.000000Z"},{"id":19508169,"change_date":"2026-03-16 21:39:00","inspection_id":"87306438","insp_unit_id":"212167916","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALLK","insp_unit_company":"A14 WHT","insp_unit_license":"4WS4465","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BP3022WC411032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-19T09:12:49.000000Z","updated_at":"2026-03-27T09:06:27.000000Z"}]},{"id":11359437,"change_date":"2026-03-12 21:40:00","inspection_id":"87277985","dot_number":"4385189","report_state":"CA","report_number":"UDIS000793","insp_date":"2026-03-09 00:00:00","insp_start_time":"1441","insp_end_time":"1447","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE IF","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONMEX INC","shipping_paper_number":"G3247-G3248","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"107000","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":"16205934","transaction_code":"A","transaction_date":"2026-03-09 00:00:00","upload_date":"2026-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-03-12 21:40:00","snet_input_date":"2026-03-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-12 21:40:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-15T09:40:03.000000Z","updated_at":"2026-03-23T09:32:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19440867,"change_date":"2026-03-12 21:40:00","inspection_id":"87277985","insp_unit_id":"212113692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"35 WHI","insp_unit_license":"9G30814","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV9FDGP2148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:45.000000Z","updated_at":"2026-03-23T09:12:03.000000Z"},{"id":19440868,"change_date":"2026-03-12 21:40:00","inspection_id":"87277985","insp_unit_id":"212113693","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GALLT","insp_unit_company":"A7 TAN","insp_unit_license":"4WN2900","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1G9CD20102N029211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:45.000000Z","updated_at":"2026-03-23T09:12:03.000000Z"},{"id":19440869,"change_date":"2026-03-12 21:40:00","inspection_id":"87277985","insp_unit_id":"212113694","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"GALLT","insp_unit_company":"A8 TAN","insp_unit_license":"4WJ4949","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1G92D20272N029212","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:45.000000Z","updated_at":"2026-03-23T09:12:03.000000Z"}]},{"id":11326527,"change_date":"2026-03-09 21:37:00","inspection_id":"87243459","dot_number":"4385189","report_state":"CA","report_number":"NAOF007590","insp_date":"2026-03-05 00:00:00","insp_start_time":"0941","insp_end_time":"1031","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"OTAY MESA IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LOMA TOVA","shipping_paper_number":"G3227  G3228","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-09 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"108000","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":"16199794","transaction_code":"A","transaction_date":"2026-03-05 00:00:00","upload_date":"2026-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-03-09 21:37:00","snet_input_date":"2026-03-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-09 21:37:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"659125","created_at":"2026-03-12T09:40:30.000000Z","updated_at":"2026-03-20T09:31:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19379919,"change_date":"2026-03-09 21:37:00","inspection_id":"87243459","insp_unit_id":"212048267","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALLCO","insp_unit_company":"A5 WHT","insp_unit_license":"4SL1518","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BS2012TC152621","insp_unit_decal":"Y","insp_unit_decal_number":"35912303","created_at":"2026-03-12T09:21:09.000000Z","updated_at":"2026-03-20T09:03:59.000000Z"},{"id":19379920,"change_date":"2026-03-09 21:37:00","inspection_id":"87243459","insp_unit_id":"212048268","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"33 WHT","insp_unit_license":"9G30684","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGADV8DLBW3611","insp_unit_decal":"Y","insp_unit_decal_number":"35912302","created_at":"2026-03-12T09:21:09.000000Z","updated_at":"2026-03-20T09:03:59.000000Z"},{"id":19379921,"change_date":"2026-03-09 21:37:00","inspection_id":"87243459","insp_unit_id":"212048269","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"ALLCO","insp_unit_company":"A6 WHT","insp_unit_license":"4SL1519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BP3024TC152622","insp_unit_decal":"Y","insp_unit_decal_number":"35912304","created_at":"2026-03-12T09:21:09.000000Z","updated_at":"2026-03-20T09:03:59.000000Z"}]},{"id":11326529,"change_date":"2026-03-09 21:37:00","inspection_id":"87243461","dot_number":"4385189","report_state":"CA","report_number":"NAOF007592","insp_date":"2026-03-05 00:00:00","insp_start_time":"1227","insp_end_time":"1323","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"OTAY MESA IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONCRETOS Y AGREGADOS","shipping_paper_number":"CA-2514","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-09 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"106700","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":"16199819","transaction_code":"A","transaction_date":"2026-03-05 00:00:00","upload_date":"2026-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-03-09 21:37:00","snet_input_date":"2026-03-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-09 21:37:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"659125","created_at":"2026-03-12T09:40:30.000000Z","updated_at":"2026-03-20T09:31:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19379923,"change_date":"2026-03-09 21:37:00","inspection_id":"87243461","insp_unit_id":"212048271","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"45 WHT","insp_unit_license":"9H08082","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGBDV4ELFW6461","insp_unit_decal":"Y","insp_unit_decal_number":"35912306","created_at":"2026-03-12T09:21:09.000000Z","updated_at":"2026-03-20T09:03:59.000000Z"},{"id":19379924,"change_date":"2026-03-09 21:37:00","inspection_id":"87243461","insp_unit_id":"212048272","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ACE","insp_unit_company":"A3 WHT","insp_unit_license":"4UE9487","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A913865120074001","insp_unit_decal":"Y","insp_unit_decal_number":"35912307","created_at":"2026-03-12T09:21:09.000000Z","updated_at":"2026-03-20T09:03:59.000000Z"},{"id":19379925,"change_date":"2026-03-09 21:37:00","inspection_id":"87243461","insp_unit_id":"212048273","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"ACE","insp_unit_company":"A4 WHT","insp_unit_license":"4UE9488","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A923866520074001","insp_unit_decal":"Y","insp_unit_decal_number":"35912308","created_at":"2026-03-12T09:21:09.000000Z","updated_at":"2026-03-20T09:03:59.000000Z"}]},{"id":11327984,"change_date":"2026-03-09 21:37:00","inspection_id":"87244943","dot_number":"4385189","report_state":"CA","report_number":"UDIS000781","insp_date":"2026-03-05 00:00:00","insp_start_time":"1105","insp_end_time":"1125","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE IF","county_code_state":"CA","county_code":"073","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONMEX INC","shipping_paper_number":"G3207 G3208","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-09 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"100350","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":"16199329","transaction_code":"A","transaction_date":"2026-03-05 00:00:00","upload_date":"2026-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-03-09 21:37:00","snet_input_date":"2026-03-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-09 21:37:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-12T09:40:31.000000Z","updated_at":"2026-03-20T09:31:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19382342,"change_date":"2026-03-09 21:37:00","inspection_id":"87244943","insp_unit_id":"212050821","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"DRAGN","insp_unit_company":"A2 WHI","insp_unit_license":"4KG8630","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UNSD22235C034946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-12T09:21:11.000000Z","updated_at":"2026-03-20T09:04:20.000000Z"},{"id":19382340,"change_date":"2026-03-09 21:37:00","inspection_id":"87244943","insp_unit_id":"212050819","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"93 RED","insp_unit_license":"9H08142","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV7HSHN1753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-12T09:21:11.000000Z","updated_at":"2026-03-20T09:04:20.000000Z"},{"id":19382341,"change_date":"2026-03-09 21:37:00","inspection_id":"87244943","insp_unit_id":"212050820","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAGN","insp_unit_company":"A1  WHI","insp_unit_license":"4GS4299","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UNSD22125C034945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-12T09:21:11.000000Z","updated_at":"2026-03-20T09:04:20.000000Z"}]},{"id":11242815,"change_date":"2026-02-26 21:42:00","inspection_id":"87155596","dot_number":"4385189","report_state":"CA","report_number":"NESY002670","insp_date":"2026-02-23 00:00:00","insp_start_time":"1119","insp_end_time":"1141","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONCRETOS Y AGREGADOS LOMA TOVA","shipping_paper_number":"A4871-A4872","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"91000","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":"16185514","transaction_code":"A","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-02-26 21:42:00","snet_input_date":"2026-02-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-26 21:42:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-01T10:39:08.000000Z","updated_at":"2026-03-09T09:32:25.000000Z","inspection_violations":[{"id":18883184,"change_date":"2026-02-26 21:42:00","inspection_id":"87155596","insp_violation_id":"272075283","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"211866181","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA642275","created_at":"2026-03-01T10:57:16.000000Z","updated_at":"2026-03-09T09:47:08.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":19219656,"change_date":"2026-02-26 21:42:00","inspection_id":"87155596","insp_unit_id":"211866182","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"A9","insp_unit_license":"4WW3771","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:50.000000Z","updated_at":"2026-03-09T09:10:28.000000Z"},{"id":19219657,"change_date":"2026-02-26 21:42:00","inspection_id":"87155596","insp_unit_id":"211866183","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"A10","insp_unit_license":"4WW3768","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:50.000000Z","updated_at":"2026-03-09T09:10:28.000000Z"},{"id":19219655,"change_date":"2026-02-26 21:42:00","inspection_id":"87155596","insp_unit_id":"211866181","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"44 WHT","insp_unit_license":"9G81676","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV8DSFK1102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:50.000000Z","updated_at":"2026-03-09T09:10:28.000000Z"}]},{"id":10819555,"change_date":"2026-01-20 21:41:00","inspection_id":"86847013","dot_number":"4385189","report_state":"CA","report_number":"UCIW001066","insp_date":"2026-01-19 00:00:00","insp_start_time":"0856","insp_end_time":"0907","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE","county_code_state":"CA","county_code":"073","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":"2026-01-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"188000","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":"16137160","transaction_code":"A","transaction_date":"2026-01-19 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2026-01-20 21:41:00","snet_input_date":"2026-01-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-20 21:41:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-23T10:36:33.000000Z","updated_at":"2026-01-31T10:31:23.000000Z","inspection_violations":[{"id":18087748,"change_date":"2026-01-20 21:41:00","inspection_id":"86847013","insp_violation_id":"271326442","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"211197972","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-23T10:43:07.000000Z","updated_at":"2026-01-31T10:39:17.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":18169635,"change_date":"2026-01-20 21:41:00","inspection_id":"86847013","insp_unit_id":"211197972","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G81676","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV8DSFK1102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:29.000000Z","updated_at":"2026-01-31T10:04:08.000000Z"},{"id":18169636,"change_date":"2026-01-20 21:41:00","inspection_id":"86847013","insp_unit_id":"211197973","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"4WW3771","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:29.000000Z","updated_at":"2026-01-31T10:04:08.000000Z"},{"id":18169637,"change_date":"2026-01-20 21:41:00","inspection_id":"86847013","insp_unit_id":"211197974","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"4WW3768","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:29.000000Z","updated_at":"2026-01-31T10:04:08.000000Z"}]},{"id":10319786,"change_date":"2025-12-01 21:39:00","inspection_id":"86446481","dot_number":"4385189","report_state":"CA","report_number":"NAOF007357","insp_date":"2025-11-25 00:00:00","insp_start_time":"0821","insp_end_time":"0857","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE","county_code_state":"CA","county_code":"073","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONCRETOS Y AGREGADOS LOMA TOVA","shipping_paper_number":"A3957  A3958","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"107000","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":"16076176","transaction_code":"A","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234632,"change_date":"2025-12-01 21:39:00","inspection_id":"86446481","insp_unit_id":"210334996","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"35 WHT","insp_unit_license":"9G30814","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV9FDGP2148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:39.000000Z"},{"id":17234633,"change_date":"2025-12-01 21:39:00","inspection_id":"86446481","insp_unit_id":"210334997","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALLCO","insp_unit_company":"A5 WHT","insp_unit_license":"4SL1518","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BS2012TC152621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:39.000000Z"},{"id":17234634,"change_date":"2025-12-01 21:39:00","inspection_id":"86446481","insp_unit_id":"210334998","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"ALLCO","insp_unit_company":"A6 WHT","insp_unit_license":"4SL1519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9BP3024TC152622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:39.000000Z"}]},{"id":10111495,"change_date":"2025-11-04 21:41:00","inspection_id":"86227525","dot_number":"4385189","report_state":"CA","report_number":"UCIW001011","insp_date":"2025-10-30 00:00:00","insp_start_time":"1130","insp_end_time":"1152","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE","county_code_state":"CA","county_code":"073","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"188000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16043598","transaction_code":"C","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2025-11-03 21:40:00","snet_input_date":"2025-10-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-03 21:40:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-06T10:30:48.000000Z","updated_at":"2025-11-08T10:31:25.000000Z","inspection_violations":[{"id":16778641,"change_date":"2025-11-04 21:41:00","inspection_id":"86227525","insp_violation_id":"269730167","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"209840760","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-07T10:31:47.000000Z","updated_at":"2025-11-08T10:32:06.000000Z","normalized_code":"393100BC"},{"id":16778642,"change_date":"2025-11-04 21:41:00","inspection_id":"86227525","insp_violation_id":"269730168","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"209840761","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-07T10:31:47.000000Z","updated_at":"2025-11-08T10:32:06.000000Z","normalized_code":"393100BC"},{"id":16778643,"change_date":"2025-11-04 21:41:00","inspection_id":"86227525","insp_violation_id":"269730169","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"3","insp_unit_id":"209840762","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:47.000000Z","updated_at":"2025-11-08T10:32:06.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":16839147,"change_date":"2025-11-04 21:41:00","inspection_id":"86227525","insp_unit_id":"209840760","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G30684","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGADV8DLBW3611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:40.000000Z","updated_at":"2025-11-08T10:01:47.000000Z"},{"id":16839148,"change_date":"2025-11-04 21:41:00","inspection_id":"86227525","insp_unit_id":"209840761","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"4WW3771","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:40.000000Z","updated_at":"2025-11-08T10:01:47.000000Z"},{"id":16839149,"change_date":"2025-11-04 21:41:00","inspection_id":"86227525","insp_unit_id":"209840762","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"4WW3768","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:40.000000Z","updated_at":"2025-11-08T10:01:47.000000Z"}]},{"id":9746896,"change_date":"2025-09-22 21:39:00","inspection_id":"85843955","dot_number":"4385189","report_state":"CA","report_number":"ND4C007327","insp_date":"2025-09-12 00:00:00","insp_start_time":"1315","insp_end_time":"1345","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"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-09-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"108000","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":"15989007","transaction_code":"A","transaction_date":"2025-09-12 00:00:00","upload_date":"2025-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2025-09-22 21:39:00","snet_input_date":"2025-09-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-22 21:39:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:29.000000Z","updated_at":"2025-09-25T10:00:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16143324,"change_date":"2025-09-22 21:39:00","inspection_id":"85843955","insp_unit_id":"209081556","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT","insp_unit_license":"9G30684","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGADV8DLBW3611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:29.000000Z","updated_at":"2025-09-26T09:45:52.000000Z"},{"id":16143325,"change_date":"2025-09-22 21:39:00","inspection_id":"85843955","insp_unit_id":"209081557","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"WHT","insp_unit_license":"4WW3771","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:29.000000Z","updated_at":"2025-09-26T09:45:52.000000Z"},{"id":16143326,"change_date":"2025-09-22 21:39:00","inspection_id":"85843955","insp_unit_id":"209081558","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"WHT","insp_unit_license":"4WW3768","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:29.000000Z","updated_at":"2025-09-26T09:45:52.000000Z"}]},{"id":9747394,"change_date":"2025-09-22 21:39:00","inspection_id":"85844469","dot_number":"4385189","report_state":"CA","report_number":"UD90001555","insp_date":"2025-09-12 00:00:00","insp_start_time":"1130","insp_end_time":"1224","registration_date":null,"region":"PT","ci_status_code":"C","location":"9646","location_desc":"TECATE PLATFORM SCALES","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ANDRES MIRANDA","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-09-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"108000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15989017","transaction_code":"A","transaction_date":"2025-09-12 00:00:00","upload_date":"2025-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2025-09-22 21:39:00","snet_input_date":"2025-09-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-22 21:39:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:29.000000Z","updated_at":"2025-09-25T10:00:29.000000Z","inspection_violations":[{"id":16013261,"change_date":"2025-09-22 21:39:00","inspection_id":"85844469","insp_violation_id":"268850736","seq_no":"1","part_no":"393","part_no_section":"47B-BMBCBD-SA","insp_viol_unit":"1","insp_unit_id":"209082375","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA470872","created_at":"2025-09-25T10:15:47.000000Z","updated_at":"2025-09-26T10:16:22.000000Z","normalized_code":"39347BBMBCBDSA"}],"inspection_per_units":[{"id":16144107,"change_date":"2025-09-22 21:39:00","inspection_id":"85844469","insp_unit_id":"209082375","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G30684","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGADV8DLBW3611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:30.000000Z","updated_at":"2025-09-26T09:45:54.000000Z"},{"id":16144108,"change_date":"2025-09-22 21:39:00","inspection_id":"85844469","insp_unit_id":"209082376","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"4WW3771","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:30.000000Z","updated_at":"2025-09-26T09:45:54.000000Z"},{"id":16144109,"change_date":"2025-09-22 21:39:00","inspection_id":"85844469","insp_unit_id":"209082377","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"4WW3768","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:30.000000Z","updated_at":"2025-09-26T09:45:54.000000Z"}]},{"id":9670374,"change_date":"2025-09-12 21:50:00","inspection_id":"85763417","dot_number":"4385189","report_state":"CA","report_number":"ND4C007322","insp_date":"2025-09-10 00:00:00","insp_start_time":"1135","insp_end_time":"1155","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"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-09-12 21:50:00","post_acc_ind":"N","gross_comb_veh_wt":"106700","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":"15978490","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2025-09-12 21:50:00","snet_input_date":"2025-09-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-12 21:50:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-16T10:48:40.000000Z","updated_at":"2025-09-16T10:48:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16003111,"change_date":"2025-09-12 21:50:00","inspection_id":"85763417","insp_unit_id":"208930306","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT","insp_unit_license":"9H08082","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGBDV4ELFW6461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:04.000000Z","updated_at":"2025-09-16T09:56:39.000000Z"},{"id":16003112,"change_date":"2025-09-12 21:50:00","inspection_id":"85763417","insp_unit_id":"208930307","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ACE","insp_unit_company":"A3 WHT","insp_unit_license":"4UE9487","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A913865120074001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:04.000000Z","updated_at":"2025-09-16T09:56:39.000000Z"},{"id":16003113,"change_date":"2025-09-12 21:50:00","inspection_id":"85763417","insp_unit_id":"208930308","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"ACE","insp_unit_company":"A4 WHT","insp_unit_license":"4UE9488","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A923866520074001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:04.000000Z","updated_at":"2025-09-16T09:56:39.000000Z"}]},{"id":9688801,"change_date":"2025-09-15 21:41:00","inspection_id":"85782999","dot_number":"4385189","report_state":"CA","report_number":"ND4C007311","insp_date":"2025-09-08 00:00:00","insp_start_time":"0915","insp_end_time":"0950","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"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-09-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"108000","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":"15980154","transaction_code":"A","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2025-09-15 21:41:00","snet_input_date":"2025-09-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-15 21:41:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:00:42.000000Z","updated_at":"2025-09-18T10:00:42.000000Z","inspection_violations":[{"id":15890404,"change_date":"2025-09-15 21:41:00","inspection_id":"85782999","insp_violation_id":"268711745","seq_no":"1","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"1","insp_unit_id":"208966610","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:06.000000Z","updated_at":"2025-09-18T10:21:06.000000Z","normalized_code":"39348ABMBCBD"},{"id":15890405,"change_date":"2025-09-15 21:41:00","inspection_id":"85782999","insp_violation_id":"268711746","seq_no":"2","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"1","insp_unit_id":"208966610","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:06.000000Z","updated_at":"2025-09-18T10:21:06.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":15890406,"change_date":"2025-09-15 21:41:00","inspection_id":"85782999","insp_violation_id":"268711747","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"208966610","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:06.000000Z","updated_at":"2025-09-18T10:21:06.000000Z","normalized_code":"39345DB"},{"id":15890407,"change_date":"2025-09-15 21:41:00","inspection_id":"85782999","insp_violation_id":"268711748","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"208966610","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RN78279","created_at":"2025-09-18T10:21:06.000000Z","updated_at":"2025-09-18T10:21:06.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":16036380,"change_date":"2025-09-15 21:41:00","inspection_id":"85782999","insp_unit_id":"208966610","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"33 WHT","insp_unit_license":"9G30684","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGADV8DLBW3611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:34.000000Z","updated_at":"2025-09-18T09:45:34.000000Z"},{"id":16036381,"change_date":"2025-09-15 21:41:00","inspection_id":"85782999","insp_unit_id":"208966611","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"A9 WHT","insp_unit_license":"4WW3771","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:34.000000Z","updated_at":"2025-09-18T09:45:34.000000Z"},{"id":16036382,"change_date":"2025-09-15 21:41:00","inspection_id":"85782999","insp_unit_id":"208966612","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"A10 WHT","insp_unit_license":"4WW3768","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FRV764915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:34.000000Z","updated_at":"2025-09-18T09:45:34.000000Z"}]},{"id":9688802,"change_date":"2025-09-15 21:41:00","inspection_id":"85783000","dot_number":"4385189","report_state":"CA","report_number":"ND4C007312","insp_date":"2025-09-08 00:00:00","insp_start_time":"0950","insp_end_time":"1020","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONMEX","shipping_paper_number":"A3048","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-09-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"106700","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":"15980178","transaction_code":"A","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2025-09-15 21:41:00","snet_input_date":"2025-09-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-15 21:41:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"659125","created_at":"2025-09-18T10:00:42.000000Z","updated_at":"2025-09-18T10:00:42.000000Z","inspection_violations":[{"id":15890408,"change_date":"2025-09-15 21:41:00","inspection_id":"85783000","insp_violation_id":"268711749","seq_no":"1","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"208966613","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:06.000000Z","updated_at":"2025-09-18T10:21:06.000000Z","normalized_code":"3965BHWSL"},{"id":15890409,"change_date":"2025-09-15 21:41:00","inspection_id":"85783000","insp_violation_id":"268711750","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"3","insp_unit_id":"208966615","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:06.000000Z","updated_at":"2025-09-18T10:21:06.000000Z","normalized_code":"39345B2BAIR"},{"id":15890410,"change_date":"2025-09-15 21:41:00","inspection_id":"85783000","insp_violation_id":"268711751","seq_no":"3","part_no":"393","part_no_section":"47C-BSAMBD","insp_viol_unit":"3","insp_unit_id":"208966615","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:06.000000Z","updated_at":"2025-09-18T10:21:06.000000Z","normalized_code":"39347CBSAMBD"},{"id":15890411,"change_date":"2025-09-15 21:41:00","inspection_id":"85783000","insp_violation_id":"268711752","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"1","insp_unit_id":"208966613","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RN78280","created_at":"2025-09-18T10:21:06.000000Z","updated_at":"2025-09-18T10:21:06.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":16036383,"change_date":"2025-09-15 21:41:00","inspection_id":"85783000","insp_unit_id":"208966613","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT","insp_unit_license":"9H08082","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGBDV4ELFW6461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:34.000000Z","updated_at":"2025-09-18T09:45:34.000000Z"},{"id":16036384,"change_date":"2025-09-15 21:41:00","inspection_id":"85783000","insp_unit_id":"208966614","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ACE","insp_unit_company":"A3 WHT","insp_unit_license":"4UE9487","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A913865120074001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:34.000000Z","updated_at":"2025-09-18T09:45:34.000000Z"},{"id":16036385,"change_date":"2025-09-15 21:41:00","inspection_id":"85783000","insp_unit_id":"208966615","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"ACE","insp_unit_company":"A4 WHT","insp_unit_license":"4UE9488","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A923866520074001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:34.000000Z","updated_at":"2025-09-18T09:45:34.000000Z"}]},{"id":9326238,"change_date":"2025-08-04 21:39:00","inspection_id":"85401956","dot_number":"4385189","report_state":"CA","report_number":"NAOF007195","insp_date":"2025-07-30 00:00:00","insp_start_time":"1126","insp_end_time":"1215","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONCRETOS Y AGREGADOS LOMA TOVA","shipping_paper_number":"A2616  A2617","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15924483","transaction_code":"A","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2025-08-04 21:39:00","snet_input_date":"2025-07-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-04 21:39:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:55.000000Z","updated_at":"2025-08-08T10:00:59.000000Z","inspection_violations":[{"id":15135138,"change_date":"2025-08-04 21:39:00","inspection_id":"85401956","insp_violation_id":"267832767","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"208231589","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-07T10:45:46.000000Z","updated_at":"2025-08-08T10:44:21.000000Z","normalized_code":"3922SLLEQP"},{"id":15135139,"change_date":"2025-08-04 21:39:00","inspection_id":"85401956","insp_violation_id":"267832768","seq_no":"2","part_no":"393","part_no_section":"70C-CDTMLB","insp_viol_unit":"3","insp_unit_id":"208231591","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA470535","created_at":"2025-08-07T10:45:46.000000Z","updated_at":"2025-08-08T10:44:21.000000Z","normalized_code":"39370CCDTMLB"}],"inspection_per_units":[{"id":15359225,"change_date":"2025-08-04 21:39:00","inspection_id":"85401956","insp_unit_id":"208231589","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"42 WHT","insp_unit_license":"9H14008","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV8HDHV9512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:34.000000Z","updated_at":"2025-08-08T09:46:12.000000Z"},{"id":15359226,"change_date":"2025-08-04 21:39:00","inspection_id":"85401956","insp_unit_id":"208231590","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ACE","insp_unit_company":"A3 WHITE","insp_unit_license":"4EU9487","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A913865120074001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:34.000000Z","updated_at":"2025-08-08T09:46:12.000000Z"},{"id":15359227,"change_date":"2025-08-04 21:39:00","inspection_id":"85401956","insp_unit_id":"208231591","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"ACE","insp_unit_company":"A4 WHITE","insp_unit_license":"1A92386652","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A923866520074001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:34.000000Z","updated_at":"2025-08-08T09:46:12.000000Z"}]},{"id":9269952,"change_date":"2025-07-28 21:40:00","inspection_id":"85342673","dot_number":"4385189","report_state":"CA","report_number":"UD90001499","insp_date":"2025-07-25 00:00:00","insp_start_time":"1100","insp_end_time":"1140","registration_date":null,"region":"PT","ci_status_code":"C","location":"9646","location_desc":"OTAY MESA","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONCRETOS AGREGADOS","shipping_paper_number":"A2553","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-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"107000","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":"15915770","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2025-07-28 21:40:00","snet_input_date":"2025-07-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-28 21:40:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-31T10:00:40.000000Z","updated_at":"2025-08-01T10:41:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15259215,"change_date":"2025-07-28 21:40:00","inspection_id":"85342673","insp_unit_id":"208123754","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G81676","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV8DSFK1102","insp_unit_decal":"Y","insp_unit_decal_number":"35358260","created_at":"2025-08-01T09:45:38.000000Z","updated_at":"2025-08-01T09:45:38.000000Z"},{"id":15259216,"change_date":"2025-07-28 21:40:00","inspection_id":"85342673","insp_unit_id":"208123755","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GALLT","insp_unit_company":null,"insp_unit_license":"4WN2900","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1G9CD20102N029211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:38.000000Z","updated_at":"2025-08-01T09:45:38.000000Z"},{"id":15259217,"change_date":"2025-07-28 21:40:00","inspection_id":"85342673","insp_unit_id":"208123756","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"GALLT","insp_unit_company":null,"insp_unit_license":"4WJ4949","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1G92D20272N029212","insp_unit_decal":"Y","insp_unit_decal_number":"03535861","created_at":"2025-08-01T09:45:38.000000Z","updated_at":"2025-08-01T09:45:38.000000Z"}]},{"id":9268995,"change_date":"2025-07-28 21:40:00","inspection_id":"85341698","dot_number":"4385189","report_state":"CA","report_number":"NAOF007177","insp_date":"2025-07-23 00:00:00","insp_start_time":"1013","insp_end_time":"1054","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONCRETOS Y AGREGADOS","shipping_paper_number":"A2551  A2552","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-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"107000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15915187","transaction_code":"A","transaction_date":"2025-07-23 00:00:00","upload_date":"2025-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2025-07-28 21:40:00","snet_input_date":"2025-07-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-28 21:40:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"659125","created_at":"2025-07-31T10:00:39.000000Z","updated_at":"2025-08-01T10:41:48.000000Z","inspection_violations":[{"id":15021816,"change_date":"2025-07-28 21:40:00","inspection_id":"85341698","insp_violation_id":"267705192","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"208122067","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA470686","created_at":"2025-07-31T10:43:41.000000Z","updated_at":"2025-08-01T10:43:53.000000Z","normalized_code":"3922SLLEQP"},{"id":15021817,"change_date":"2025-07-28 21:40:00","inspection_id":"85341698","insp_violation_id":"267705193","seq_no":"2","part_no":"393","part_no_section":"43A-TPV","insp_viol_unit":"1","insp_unit_id":"208122067","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-31T10:43:41.000000Z","updated_at":"2025-08-01T10:43:53.000000Z","normalized_code":"39343ATPV"},{"id":15021818,"change_date":"2025-07-28 21:40:00","inspection_id":"85341698","insp_violation_id":"267705194","seq_no":"3","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"3","insp_unit_id":"208122069","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA470686","created_at":"2025-07-31T10:43:41.000000Z","updated_at":"2025-08-01T10:43:53.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":15257658,"change_date":"2025-07-28 21:40:00","inspection_id":"85341698","insp_unit_id":"208122067","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"44 WHT","insp_unit_license":"9G81676","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV8DSFK1102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:36.000000Z","updated_at":"2025-08-01T09:45:36.000000Z"},{"id":15257659,"change_date":"2025-07-28 21:40:00","inspection_id":"85341698","insp_unit_id":"208122068","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GALLT","insp_unit_company":"A7 YELLOW","insp_unit_license":"4WN2900","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1G9CD20102N029211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:36.000000Z","updated_at":"2025-08-01T09:45:36.000000Z"},{"id":15257660,"change_date":"2025-07-28 21:40:00","inspection_id":"85341698","insp_unit_id":"208122069","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"GALLT","insp_unit_company":"A8 YELLOW","insp_unit_license":"4WJ4949","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1G92D20272N029212","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:36.000000Z","updated_at":"2025-08-01T09:45:36.000000Z"}]},{"id":9146001,"change_date":"2025-07-14 21:41:00","inspection_id":"85212525","dot_number":"4385189","report_state":"CA","report_number":"ND4C007128","insp_date":"2025-07-10 00:00:00","insp_start_time":"1010","insp_end_time":"1035","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONMEX","shipping_paper_number":"A2257","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"100350","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":"15895506","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2025-07-14 21:41:00","snet_input_date":"2025-07-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-14 21:41:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:51.000000Z","updated_at":"2025-07-18T10:45:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15019509,"change_date":"2025-07-14 21:41:00","inspection_id":"85212525","insp_unit_id":"207865058","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"39 RED","insp_unit_license":"9H08142","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV7HSHN1753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:18.000000Z"},{"id":15019510,"change_date":"2025-07-14 21:41:00","inspection_id":"85212525","insp_unit_id":"207865059","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAGN","insp_unit_company":"A1 WHT","insp_unit_license":"4GS4299","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UNSD22125C034945","insp_unit_decal":"Y","insp_unit_decal_number":"35357792","created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:18.000000Z"},{"id":15019511,"change_date":"2025-07-14 21:41:00","inspection_id":"85212525","insp_unit_id":"207865060","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"DRAGN","insp_unit_company":"A2 WHT","insp_unit_license":"4KG8630","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UNSD22235C034946","insp_unit_decal":"Y","insp_unit_decal_number":"35357793","created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:18.000000Z"}]},{"id":9145368,"change_date":"2025-07-14 21:41:00","inspection_id":"85211885","dot_number":"4385189","report_state":"CA","report_number":"ND4C007119","insp_date":"2025-07-09 00:00:00","insp_start_time":"0815","insp_end_time":"0850","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONMEX INC","shipping_paper_number":"A2348","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"100350","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":"15896506","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2025-07-14 21:41:00","snet_input_date":"2025-07-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-14 21:41:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"659125","created_at":"2025-07-18T10:45:50.000000Z","updated_at":"2025-07-18T10:45:50.000000Z","inspection_violations":[{"id":14753164,"change_date":"2025-07-14 21:41:00","inspection_id":"85211885","insp_violation_id":"267398819","seq_no":"1","part_no":"393","part_no_section":"70D-CDTSDD","insp_viol_unit":"2","insp_unit_id":"207863886","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:20.000000Z","updated_at":"2025-07-18T10:47:46.000000Z","normalized_code":"39370DCDTSDD"}],"inspection_per_units":[{"id":15018370,"change_date":"2025-07-14 21:41:00","inspection_id":"85211885","insp_unit_id":"207863885","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"39 RED","insp_unit_license":"9H08142","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV7HSHN1753","insp_unit_decal":"Y","insp_unit_decal_number":"35357786","created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:14.000000Z"},{"id":15018371,"change_date":"2025-07-14 21:41:00","inspection_id":"85211885","insp_unit_id":"207863886","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAGN","insp_unit_company":"A1 WHT","insp_unit_license":"4GS4299","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UNSD22125C034945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:14.000000Z"},{"id":15018372,"change_date":"2025-07-14 21:41:00","inspection_id":"85211885","insp_unit_id":"207863887","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"DRAGN","insp_unit_company":"A2 WHT","insp_unit_license":"4KG8630","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UNSD22235C034946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:35.000000Z","updated_at":"2025-07-18T09:46:14.000000Z"}]},{"id":8819345,"change_date":"2025-06-04 21:41:00","inspection_id":"84867130","dot_number":"4385189","report_state":"CA","report_number":"UCIW000871","insp_date":"2025-06-02 00:00:00","insp_start_time":"1423","insp_end_time":"1442","registration_date":null,"region":"PT","ci_status_code":"C","location":"646","location_desc":"TECATE","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15848579","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"04385189","upload_search_indicator":null,"census_search_date":"2025-06-04 21:41:00","snet_input_date":"2025-06-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"ANDRES MIRANDA","insp_carrier_street":"1012 GRAND AVE","insp_carrier_city":"SPRING VALLEY","insp_carrier_state":"CA","insp_carrier_zip_code":"91977","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-07T10:01:10.000000Z","updated_at":"2025-06-09T10:00:50.000000Z","inspection_violations":[{"id":14114354,"change_date":"2025-06-04 21:41:00","inspection_id":"84867130","insp_violation_id":"266669374","seq_no":"1","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"207230789","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-07T10:17:03.000000Z","updated_at":"2025-06-08T10:18:02.000000Z","normalized_code":"3929AA1"}],"inspection_per_units":[{"id":14437363,"change_date":"2025-06-04 21:41:00","inspection_id":"84867130","insp_unit_id":"207230789","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9H14008","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKBGADV8HDHV9512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:20.000000Z","updated_at":"2025-06-08T09:46:13.000000Z"},{"id":14437364,"change_date":"2025-06-04 21:41:00","inspection_id":"84867130","insp_unit_id":"207230790","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"ACE","insp_unit_company":null,"insp_unit_license":"4UE9487","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A931865120074001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:20.000000Z","updated_at":"2025-06-08T09:46:13.000000Z"},{"id":14437365,"change_date":"2025-06-04 21:41:00","inspection_id":"84867130","insp_unit_id":"207230791","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"ACE","insp_unit_company":null,"insp_unit_license":"4UE9488","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A923866520074001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:20.000000Z","updated_at":"2025-06-08T09:46:13.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4385189\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4385189\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4385189\/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\/4385189\/inspections","per_page":100,"prev_page_url":null,"to":32,"total":32}