{"current_page":1,"data":[{"id":11555389,"change_date":"2026-04-14 21:38:00","inspection_id":"87478515","dot_number":"4175194","report_state":"NV","report_number":"7301029875","insp_date":"2026-03-26 00:00:00","insp_start_time":"1428","insp_end_time":"1458","registration_date":"2026-04-13 00:00:00","region":"PD","ci_status_code":"C","location":"2","location_desc":"NV","county_code_state":"NV","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GSD METALS","shipping_paper_number":"420252","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3154215","transaction_code":"C","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2026-04-02 21:39:00","snet_input_date":"2026-03-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-02 21:39:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-25T09:30:05.000000Z","updated_at":"2026-04-25T09:30:05.000000Z","inspection_violations":[{"id":20202413,"change_date":"2026-04-14 21:38:00","inspection_id":"87478515","insp_violation_id":"273584430","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"213001582","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-25T09:40:34.000000Z","updated_at":"2026-04-25T09:40:34.000000Z","normalized_code":"3922SLL"},{"id":20202414,"change_date":"2026-04-14 21:38:00","inspection_id":"87478515","insp_violation_id":"273584431","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"213001582","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-25T09:40:34.000000Z","updated_at":"2026-04-25T09:40:34.000000Z","normalized_code":"3922SLLIFTA"},{"id":20202415,"change_date":"2026-04-14 21:38:00","inspection_id":"87478515","insp_violation_id":"273584432","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"213001582","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-25T09:40:34.000000Z","updated_at":"2026-04-25T09:40:34.000000Z","normalized_code":"39617CPI"},{"id":20202416,"change_date":"2026-04-14 21:38:00","inspection_id":"87478515","insp_violation_id":"273584433","seq_no":"4","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"213001582","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-25T09:40:34.000000Z","updated_at":"2026-04-25T09:40:34.000000Z","normalized_code":"3929AA1"},{"id":20202417,"change_date":"2026-04-14 21:38:00","inspection_id":"87478515","insp_violation_id":"273584434","seq_no":"5","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"213001582","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-25T09:40:34.000000Z","updated_at":"2026-04-25T09:40:34.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":20202418,"change_date":"2026-04-14 21:38:00","inspection_id":"87478515","insp_violation_id":"273584435","seq_no":"6","part_no":"387","part_no_section":"301A","insp_viol_unit":"1","insp_unit_id":"213001582","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-25T09:40:34.000000Z","updated_at":"2026-04-25T09:40:34.000000Z","normalized_code":"387301A"},{"id":20202419,"change_date":"2026-04-14 21:38:00","inspection_id":"87478515","insp_violation_id":"273584436","seq_no":"7","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"213001583","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-25T09:40:34.000000Z","updated_at":"2026-04-25T09:40:34.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":20242145,"change_date":"2026-04-14 21:38:00","inspection_id":"87478515","insp_unit_id":"213001582","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"88","insp_unit_license":"9H22365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD53GSGU0946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-25T09:02:54.000000Z","updated_at":"2026-04-25T09:02:54.000000Z"},{"id":20242146,"change_date":"2026-04-14 21:38:00","inspection_id":"87478515","insp_unit_id":"213001583","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"4ER2720","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS24574A356601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-25T09:02:54.000000Z","updated_at":"2026-04-25T09:02:54.000000Z"}]},{"id":11395406,"change_date":"2026-03-20 21:39:00","inspection_id":"87310217","dot_number":"4175194","report_state":"OR","report_number":"AW43150350","insp_date":"2026-03-17 00:00:00","insp_start_time":"1257","insp_end_time":"1334","registration_date":null,"region":"PD","ci_status_code":"C","location":"10-08","location_desc":"MYRTLE CREEK OR","county_code_state":"OR","county_code":"019","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CRUZ TRUCKING","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3016878","transaction_code":"C","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2026-03-17 21:39:00","snet_input_date":"2026-03-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-17 21:39:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804-4365","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-20T09:42:30.000000Z","updated_at":"2026-03-31T09:30:16.000000Z","inspection_violations":[{"id":19267673,"change_date":"2026-03-20 21:39:00","inspection_id":"87310217","insp_violation_id":"272517945","seq_no":"1","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"212234606","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CE 512366","created_at":"2026-03-23T10:13:17.000000Z","updated_at":"2026-03-31T09:47:59.000000Z","normalized_code":"3929A2C"},{"id":19267674,"change_date":"2026-03-20 21:39:00","inspection_id":"87310217","insp_violation_id":"272517946","seq_no":"2","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"212234607","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:17.000000Z","updated_at":"2026-03-31T09:47:59.000000Z","normalized_code":"39355EB"},{"id":19267675,"change_date":"2026-03-20 21:39:00","inspection_id":"87310217","insp_violation_id":"272517947","seq_no":"3","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CE 512364","created_at":"2026-03-23T10:13:17.000000Z","updated_at":"2026-03-31T09:48:00.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":19566166,"change_date":"2026-03-20 21:39:00","inspection_id":"87310217","insp_unit_id":"212234606","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"01","insp_unit_license":"9H22365CA","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD53GSGU0946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:29:54.000000Z","updated_at":"2026-03-31T09:07:59.000000Z"},{"id":19566167,"change_date":"2026-03-20 21:39:00","inspection_id":"87310217","insp_unit_id":"212234607","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANSCRAFT","insp_unit_company":"26","insp_unit_license":"4FY8684","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS24574A356601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:29:54.000000Z","updated_at":"2026-03-31T09:07:59.000000Z"}]},{"id":11372500,"change_date":"2026-03-13 21:38:00","inspection_id":"87286204","dot_number":"4175194","report_state":"CA","report_number":"NBYS006675","insp_date":"2026-03-12 00:00:00","insp_start_time":"0902","insp_end_time":"0949","registration_date":null,"region":"PT","ci_status_code":"C","location":"223","location_desc":"DONNER PASS IF","county_code_state":"CA","county_code":"057","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SIMS METAL MANAGEMENT","shipping_paper_number":"TBHAIW","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16207196","transaction_code":"A","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2026-03-13 21:38:00","snet_input_date":"2026-03-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-13 21:38:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-16T09:39:18.000000Z","updated_at":"2026-03-24T09:31:24.000000Z","inspection_violations":[{"id":19165117,"change_date":"2026-03-13 21:38:00","inspection_id":"87286204","insp_violation_id":"272396795","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"RU02629","created_at":"2026-03-16T10:01:29.000000Z","updated_at":"2026-03-24T09:45:06.000000Z","normalized_code":"38323A2LCDLN"},{"id":19165118,"change_date":"2026-03-13 21:38:00","inspection_id":"87286204","insp_violation_id":"272396796","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"212128614","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RU02630","created_at":"2026-03-16T10:01:29.000000Z","updated_at":"2026-03-24T09:45:06.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":19472943,"change_date":"2026-03-13 21:38:00","inspection_id":"87286204","insp_unit_id":"212128614","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLU\/88","insp_unit_license":"9H22365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD53GSGU0946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:17:00.000000Z","updated_at":"2026-03-24T09:05:09.000000Z"},{"id":19472944,"change_date":"2026-03-13 21:38:00","inspection_id":"87286204","insp_unit_id":"212128615","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"SLV\/02","insp_unit_license":"4ER2720","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS24574A356601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:17:00.000000Z","updated_at":"2026-03-24T09:05:09.000000Z"}]},{"id":11088862,"change_date":"2026-02-09 21:39:00","inspection_id":"87000307","dot_number":"4175194","report_state":"CA","report_number":"UGJO000484","insp_date":"2026-02-05 00:00:00","insp_start_time":"1110","insp_end_time":"1310","registration_date":null,"region":"PT","ci_status_code":"C","location":"150","location_desc":"N\/B US-101 AT SHAMROCK","county_code_state":"CA","county_code":"045","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"9","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16162619","transaction_code":"A","transaction_date":"2026-02-05 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2026-02-09 21:39:00","snet_input_date":"2026-02-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-09 21:39:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"639833","created_at":"2026-02-12T10:37:08.000000Z","updated_at":"2026-02-20T10:31:20.000000Z","inspection_violations":[{"id":18562964,"change_date":"2026-02-09 21:39:00","inspection_id":"87000307","insp_violation_id":"271692164","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"211529681","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA430621","created_at":"2026-02-12T10:50:46.000000Z","updated_at":"2026-02-20T10:40:22.000000Z","normalized_code":"39347E"},{"id":18562960,"change_date":"2026-02-09 21:39:00","inspection_id":"87000307","insp_violation_id":"271692160","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"211529680","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:46.000000Z","updated_at":"2026-02-20T10:40:22.000000Z","normalized_code":"3922SLLEQP"},{"id":18562961,"change_date":"2026-02-09 21:39:00","inspection_id":"87000307","insp_violation_id":"271692161","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"211529680","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:46.000000Z","updated_at":"2026-02-20T10:40:22.000000Z","normalized_code":"39345DB"},{"id":18562962,"change_date":"2026-02-09 21:39:00","inspection_id":"87000307","insp_violation_id":"271692162","seq_no":"4","part_no":"396","part_no_section":"5-HL","insp_viol_unit":"2","insp_unit_id":"211529681","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-12T10:50:46.000000Z","updated_at":"2026-02-20T10:40:22.000000Z","normalized_code":"3965HL"},{"id":18562963,"change_date":"2026-02-09 21:39:00","inspection_id":"87000307","insp_violation_id":"271692163","seq_no":"5","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"211529681","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:46.000000Z","updated_at":"2026-02-20T10:40:22.000000Z","normalized_code":"39345DB"},{"id":18562965,"change_date":"2026-02-09 21:39:00","inspection_id":"87000307","insp_violation_id":"271692165","seq_no":"7","part_no":"393","part_no_section":"207F-SDAS","insp_viol_unit":"2","insp_unit_id":"211529681","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-12T10:50:46.000000Z","updated_at":"2026-02-20T10:40:22.000000Z","normalized_code":"393207FSDAS"},{"id":18562966,"change_date":"2026-02-09 21:39:00","inspection_id":"87000307","insp_violation_id":"271692166","seq_no":"8","part_no":"393","part_no_section":"201A-FRCLS","insp_viol_unit":"2","insp_unit_id":"211529681","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:46.000000Z","updated_at":"2026-02-20T10:40:22.000000Z","normalized_code":"393201AFRCLS"},{"id":18562967,"change_date":"2026-02-09 21:39:00","inspection_id":"87000307","insp_violation_id":"271692167","seq_no":"9","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"211529681","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-12T10:50:46.000000Z","updated_at":"2026-02-20T10:40:22.000000Z","normalized_code":"3963A1BOS"},{"id":18562959,"change_date":"2026-02-09 21:39:00","inspection_id":"87000307","insp_violation_id":"271692159","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211529680","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SQ52685","created_at":"2026-02-12T10:50:46.000000Z","updated_at":"2026-02-20T10:40:22.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":18908761,"change_date":"2026-02-09 21:39:00","inspection_id":"87000307","insp_unit_id":"211529680","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9F77811","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR5CSBF3449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:44.000000Z","updated_at":"2026-02-20T10:04:41.000000Z"},{"id":18908762,"change_date":"2026-02-09 21:39:00","inspection_id":"87000307","insp_unit_id":"211529681","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"4FY8684","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF45200X2003198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:44.000000Z","updated_at":"2026-02-20T10:04:41.000000Z"}]},{"id":10499857,"change_date":"2025-12-22 21:39:00","inspection_id":"86634649","dot_number":"4175194","report_state":"CA","report_number":"NDA2008056","insp_date":"2025-12-18 00:00:00","insp_start_time":"0803","insp_end_time":"0856","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"EB ANTELOPE SCALE","county_code_state":"CA","county_code":"067","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16105987","transaction_code":"A","transaction_date":"2025-12-18 00:00:00","upload_date":"2025-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2025-12-22 21:39:00","snet_input_date":"2025-12-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-22 21:39:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"639833","created_at":"2025-12-25T10:37:49.000000Z","updated_at":"2026-01-02T10:31:11.000000Z","inspection_violations":[{"id":17624118,"change_date":"2025-12-22 21:39:00","inspection_id":"86634649","insp_violation_id":"270850152","seq_no":"5","part_no":"393","part_no_section":"47D2-BLTBD","insp_viol_unit":"2","insp_unit_id":"210760866","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:59.000000Z","updated_at":"2026-01-02T10:31:58.000000Z","normalized_code":"39347D2BLTBD"},{"id":17624119,"change_date":"2025-12-22 21:39:00","inspection_id":"86634649","insp_violation_id":"270850153","seq_no":"6","part_no":"393","part_no_section":"75A1-TEPBM","insp_viol_unit":"2","insp_unit_id":"210760866","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:59.000000Z","updated_at":"2026-01-02T10:31:58.000000Z","normalized_code":"39375A1TEPBM"},{"id":17624120,"change_date":"2025-12-22 21:39:00","inspection_id":"86634649","insp_violation_id":"270850154","seq_no":"7","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"210760866","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:59.000000Z","updated_at":"2026-01-02T10:31:58.000000Z","normalized_code":"3939ALSML"},{"id":17624121,"change_date":"2025-12-22 21:39:00","inspection_id":"86634649","insp_violation_id":"270850155","seq_no":"8","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"210760866","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:59.000000Z","updated_at":"2026-01-02T10:31:58.000000Z","normalized_code":"3939ALLPL"},{"id":17624122,"change_date":"2025-12-22 21:39:00","inspection_id":"86634649","insp_violation_id":"270850156","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"210760865","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:59.000000Z","updated_at":"2026-01-02T10:31:58.000000Z","normalized_code":"3922SLL"},{"id":17624123,"change_date":"2025-12-22 21:39:00","inspection_id":"86634649","insp_violation_id":"270850157","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"210760865","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:59.000000Z","updated_at":"2026-01-02T10:31:58.000000Z","normalized_code":"39360C"},{"id":17624124,"change_date":"2025-12-22 21:39:00","inspection_id":"86634649","insp_violation_id":"270850158","seq_no":"3","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"210760865","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:59.000000Z","updated_at":"2026-01-02T10:31:58.000000Z","normalized_code":"39345B2BAIR"},{"id":17624125,"change_date":"2025-12-22 21:39:00","inspection_id":"86634649","insp_violation_id":"270850159","seq_no":"4","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"210760865","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:59.000000Z","updated_at":"2026-01-02T10:31:58.000000Z","normalized_code":"39311A1CSLRR"}],"inspection_per_units":[{"id":17581544,"change_date":"2025-12-22 21:39:00","inspection_id":"86634649","insp_unit_id":"210760865","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"88","insp_unit_license":"9H22365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD53GSGU0946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:45.000000Z","updated_at":"2026-01-02T10:01:14.000000Z"},{"id":17581545,"change_date":"2025-12-22 21:39:00","inspection_id":"86634649","insp_unit_id":"210760866","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4ER2720","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS24574A356601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:45.000000Z","updated_at":"2026-01-02T10:01:14.000000Z"}]},{"id":10205261,"change_date":"2025-11-14 21:41:00","inspection_id":"86326256","dot_number":"4175194","report_state":"CA","report_number":"NDLR006021","insp_date":"2025-11-13 00:00:00","insp_start_time":"1427","insp_end_time":"1450","registration_date":null,"region":"PT","ci_status_code":"C","location":"223","location_desc":"DONNER PASS CVEF","county_code_state":"CA","county_code":"057","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PICK N PULL AUTO DISMANTLERS","shipping_paper_number":"51202-51113SC12","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16058589","transaction_code":"A","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2025-11-14 21:41:00","snet_input_date":"2025-11-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-14 21:41:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:35.000000Z","updated_at":"2025-11-18T10:31:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17000000,"change_date":"2025-11-14 21:41:00","inspection_id":"86326256","insp_unit_id":"210041419","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"88\/BLU","insp_unit_license":"9H22365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD53GSGU0946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-17T10:01:28.000000Z","updated_at":"2025-11-18T10:01:55.000000Z"},{"id":17000001,"change_date":"2025-11-14 21:41:00","inspection_id":"86326256","insp_unit_id":"210041420","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"02\/FB","insp_unit_license":"4ER2720","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS24574A356601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-17T10:01:28.000000Z","updated_at":"2025-11-18T10:01:55.000000Z"}]},{"id":9367515,"change_date":"2025-08-08 21:40:00","inspection_id":"85445278","dot_number":"4175194","report_state":"CA","report_number":"UG2G001137","insp_date":"2025-08-07 00:00:00","insp_start_time":"1430","insp_end_time":"1505","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"FRESNO AREA","county_code_state":"CA","county_code":"019","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"3","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15930449","transaction_code":"A","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2025-08-08 21:40:00","snet_input_date":"2025-08-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-08 21:40:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"639833","created_at":"2025-08-12T10:44:17.000000Z","updated_at":"2025-08-12T10:44:17.000000Z","inspection_violations":[{"id":15218764,"change_date":"2025-08-08 21:40:00","inspection_id":"85445278","insp_violation_id":"267926218","seq_no":"1","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-08-11T10:45:39.000000Z","updated_at":"2025-08-12T10:45:58.000000Z","normalized_code":"3958A1HOSP"},{"id":15218765,"change_date":"2025-08-08 21:40:00","inspection_id":"85445278","insp_violation_id":"267926219","seq_no":"2","part_no":"393","part_no_section":"132C-CHVE","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"SD15881","created_at":"2025-08-11T10:45:39.000000Z","updated_at":"2025-08-12T10:45:58.000000Z","normalized_code":"393132CCHVE"},{"id":15218766,"change_date":"2025-08-08 21:40:00","inspection_id":"85445278","insp_violation_id":"267926220","seq_no":"3","part_no":"393","part_no_section":"48A-BLMACBD","insp_viol_unit":"1","insp_unit_id":"208311279","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-08-11T10:45:39.000000Z","updated_at":"2025-08-12T10:45:58.000000Z","normalized_code":"39348ABLMACBD"}],"inspection_per_units":[{"id":15433362,"change_date":"2025-08-08 21:40:00","inspection_id":"85445278","insp_unit_id":"208311279","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X BLU","insp_unit_license":"9F77811","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR5CSBF3449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:28.000000Z","updated_at":"2025-08-12T09:46:16.000000Z"},{"id":15433363,"change_date":"2025-08-08 21:40:00","inspection_id":"85445278","insp_unit_id":"208311280","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"2X SIL FB","insp_unit_license":"4FY8684","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF45200X2003198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:28.000000Z","updated_at":"2025-08-12T09:46:16.000000Z"}]},{"id":9034075,"change_date":"2025-06-30 21:39:00","inspection_id":"85094477","dot_number":"4175194","report_state":"CA","report_number":"NBAA008686","insp_date":"2025-06-27 00:00:00","insp_start_time":"1024","insp_end_time":"1052","registration_date":null,"region":"PT","ci_status_code":"C","location":"223","location_desc":"DONNER PASS CVEF","county_code_state":"CA","county_code":"057","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PICK & PULL","shipping_paper_number":"5020250627SC35","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15880522","transaction_code":"A","transaction_date":"2025-06-27 00:00:00","upload_date":"2025-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2025-06-30 21:39:00","snet_input_date":"2025-06-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-30 21:39:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-03T10:01:56.000000Z","updated_at":"2025-07-04T10:00:54.000000Z","inspection_violations":[{"id":14526872,"change_date":"2025-06-30 21:39:00","inspection_id":"85094477","insp_violation_id":"267138285","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"2","insp_unit_id":"207646192","insp_violation_category_id":"47","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-03T10:16:00.000000Z","updated_at":"2025-07-04T10:18:00.000000Z","normalized_code":"3922SLLED"},{"id":14526873,"change_date":"2025-06-30 21:39:00","inspection_id":"85094477","insp_violation_id":"267138286","seq_no":"2","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"2","insp_unit_id":"207646192","insp_violation_category_id":"47","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-03T10:16:00.000000Z","updated_at":"2025-07-04T10:18:00.000000Z","normalized_code":"3922SLLED"}],"inspection_per_units":[{"id":14818509,"change_date":"2025-06-30 21:39:00","inspection_id":"85094477","insp_unit_id":"207646191","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"88","insp_unit_license":"9H22365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD53GSGU0946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-03T09:45:42.000000Z","updated_at":"2025-07-04T09:46:13.000000Z"},{"id":14818510,"change_date":"2025-06-30 21:39:00","inspection_id":"85094477","insp_unit_id":"207646192","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"02","insp_unit_license":"4ER2720","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS24574A356601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-03T09:45:42.000000Z","updated_at":"2025-07-04T09:46:13.000000Z"}]},{"id":8993776,"change_date":"2025-06-26 21:41:00","inspection_id":"85052437","dot_number":"4175194","report_state":"CA","report_number":"N8MC010029","insp_date":"2025-06-16 00:00:00","insp_start_time":"1029","insp_end_time":"1115","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"7","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15864893","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2025-06-26 21:41:00","snet_input_date":"2025-06-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:41:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:01.000000Z","updated_at":"2025-06-30T10:01:01.000000Z","inspection_violations":[{"id":14463976,"change_date":"2025-06-26 21:41:00","inspection_id":"85052437","insp_violation_id":"267067633","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"207573080","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-29T10:16:49.000000Z","updated_at":"2025-06-30T10:18:04.000000Z","normalized_code":"3939ALTSI"},{"id":14463977,"change_date":"2025-06-26 21:41:00","inspection_id":"85052437","insp_violation_id":"267067634","seq_no":"2","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"207573080","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:49.000000Z","updated_at":"2025-06-30T10:18:04.000000Z","normalized_code":"3939ALSLI"},{"id":14463978,"change_date":"2025-06-26 21:41:00","inspection_id":"85052437","insp_violation_id":"267067635","seq_no":"3","part_no":"393","part_no_section":"209D-STPAL","insp_viol_unit":"1","insp_unit_id":"207573079","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-29T10:16:49.000000Z","updated_at":"2025-06-30T10:18:04.000000Z","normalized_code":"393209DSTPAL"},{"id":14463979,"change_date":"2025-06-26 21:41:00","inspection_id":"85052437","insp_violation_id":"267067636","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"207573080","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:49.000000Z","updated_at":"2025-06-30T10:18:04.000000Z","normalized_code":"39347E"},{"id":14463980,"change_date":"2025-06-26 21:41:00","inspection_id":"85052437","insp_violation_id":"267067637","seq_no":"5","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"207573080","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:49.000000Z","updated_at":"2025-06-30T10:18:04.000000Z","normalized_code":"39353BB"},{"id":14463981,"change_date":"2025-06-26 21:41:00","inspection_id":"85052437","insp_violation_id":"267067638","seq_no":"6","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"207573079","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:49.000000Z","updated_at":"2025-06-30T10:18:04.000000Z","normalized_code":"3963A1BALAC"},{"id":14463982,"change_date":"2025-06-26 21:41:00","inspection_id":"85052437","insp_violation_id":"267067639","seq_no":"7","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"207573079","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA666281","created_at":"2025-06-29T10:16:49.000000Z","updated_at":"2025-06-30T10:18:04.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":14750334,"change_date":"2025-06-26 21:41:00","inspection_id":"85052437","insp_unit_id":"207573079","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLU 1","insp_unit_license":"9F77811","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR5CSBF3449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:17.000000Z","updated_at":"2025-07-01T09:47:41.000000Z"},{"id":14750335,"change_date":"2025-06-26 21:41:00","inspection_id":"85052437","insp_unit_id":"207573080","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTR","insp_unit_company":null,"insp_unit_license":"4FY8684","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF45200X2003198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:17.000000Z","updated_at":"2025-07-01T09:47:41.000000Z"}]},{"id":8877326,"change_date":"2025-06-11 21:42:00","inspection_id":"84928567","dot_number":"4175194","report_state":"CA","report_number":"UFA3002561","insp_date":"2025-06-05 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"I-80 WB AG STATION","county_code_state":"CA","county_code":"061","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"15856686","transaction_code":"A","transaction_date":"2025-06-05 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2025-06-11 21:42:00","snet_input_date":"2025-06-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-11 21:42:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"639833","created_at":"2025-06-14T10:01:05.000000Z","updated_at":"2025-06-15T10:00:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14539751,"change_date":"2025-06-11 21:42:00","inspection_id":"84928567","insp_unit_id":"207342573","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"88","insp_unit_license":"9H22365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD53GSGU0946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:14.000000Z","updated_at":"2025-06-15T09:46:23.000000Z"},{"id":14539752,"change_date":"2025-06-11 21:42:00","inspection_id":"84928567","insp_unit_id":"207342574","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"02","insp_unit_license":"4ER2720","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS24574A356601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:14.000000Z","updated_at":"2025-06-15T09:46:23.000000Z"}]},{"id":8494825,"change_date":"2025-04-29 21:49:00","inspection_id":"84524657","dot_number":"4175194","report_state":"CA","report_number":"UF73002795","insp_date":"2025-04-27 00:00:00","insp_start_time":"1317","insp_end_time":"1342","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-29 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15799535","transaction_code":"A","transaction_date":"2025-04-27 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2025-04-29 21:49:00","snet_input_date":"2025-04-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-29 21:49:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-02T10:27:08.000000Z","updated_at":"2025-05-02T13:51:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13806591,"change_date":"2025-04-29 21:49:00","inspection_id":"84524657","insp_unit_id":"206541522","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9H22365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD53GSGU0946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:19:40.000000Z","updated_at":"2025-05-03T10:10:37.000000Z"}]},{"id":7923020,"change_date":"2025-02-20 21:41:00","inspection_id":"83922990","dot_number":"4175194","report_state":"CA","report_number":"ND5A007577","insp_date":"2025-02-20 00:00:00","insp_start_time":"0624","insp_end_time":"0645","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"15711078","transaction_code":"A","transaction_date":"2025-02-20 00:00:00","upload_date":"2025-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2025-02-20 21:41:00","snet_input_date":"2025-02-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-20 21:41:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:48.000000Z","updated_at":"2025-03-17T21:02:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12789670,"change_date":"2025-02-20 21:41:00","inspection_id":"83922990","insp_unit_id":"205427505","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"88\/BLU","insp_unit_license":"9H22365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD53GSGU0946","insp_unit_decal":"Y","insp_unit_decal_number":"34753263","created_at":"2025-03-17T23:56:16.000000Z","updated_at":"2025-03-17T23:56:16.000000Z"},{"id":12789671,"change_date":"2025-02-20 21:41:00","inspection_id":"83922990","insp_unit_id":"205427506","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"GRY","insp_unit_license":"4ER2720","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS24574A356601","insp_unit_decal":"Y","insp_unit_decal_number":"34753264","created_at":"2025-03-17T23:56:16.000000Z","updated_at":"2025-03-17T23:56:16.000000Z"}]},{"id":7731334,"change_date":"2025-01-28 21:39:00","inspection_id":"83721495","dot_number":"4175194","report_state":"CA","report_number":"UE5M004239","insp_date":"2025-01-21 00:00:00","insp_start_time":"1015","insp_end_time":"1045","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","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-01-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15680537","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2025-01-28 21:39:00","snet_input_date":"2025-01-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-28 21:39:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"639833","created_at":"2025-03-17T20:58:42.000000Z","updated_at":"2025-03-17T20:58:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12476334,"change_date":"2025-01-28 21:39:00","inspection_id":"83721495","insp_unit_id":"205050111","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"88","insp_unit_license":"9H22365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD53GSGU0946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:40.000000Z","updated_at":"2025-03-17T23:52:40.000000Z"},{"id":12476335,"change_date":"2025-01-28 21:39:00","inspection_id":"83721495","insp_unit_id":"205050112","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILI","insp_unit_company":null,"insp_unit_license":"4ER2720","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS24574A356601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:40.000000Z","updated_at":"2025-03-17T23:52:40.000000Z"}]},{"id":5118160,"change_date":"2024-02-22 21:43:00","inspection_id":"80922354","dot_number":"4175194","report_state":"CA","report_number":"UGGH000259","insp_date":"2024-02-21 00:00:00","insp_start_time":"0906","insp_end_time":"1020","registration_date":null,"region":"PT","ci_status_code":"C","location":"125","location_desc":"US-101 AT LITTLE RIVER SCALES","county_code_state":"CA","county_code":"023","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"6","oos_total":"4","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15245071","transaction_code":"A","transaction_date":"2024-02-21 00:00:00","upload_date":"2024-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"04175194","upload_search_indicator":null,"census_search_date":"2024-02-22 21:43:00","snet_input_date":"2024-02-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-22 21:43:00","insp_carrier_name":"BRANDON VENTURA GUATEMALA","insp_carrier_street":"719 S 45TH ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:52.000000Z","updated_at":"2025-03-17T20:03:52.000000Z","inspection_violations":[{"id":7892598,"change_date":"2024-02-22 21:43:00","inspection_id":"80922354","insp_violation_id":"257998378","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LK58969","created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3922"},{"id":7892599,"change_date":"2024-02-22 21:43:00","inspection_id":"80922354","insp_violation_id":"257998379","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199564350","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LK58969","created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3939A"},{"id":7892600,"change_date":"2024-02-22 21:43:00","inspection_id":"80922354","insp_violation_id":"257998380","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"199564349","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"39375A3"},{"id":7892601,"change_date":"2024-02-22 21:43:00","inspection_id":"80922354","insp_violation_id":"257998381","seq_no":"4","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"38323A2"},{"id":7892602,"change_date":"2024-02-22 21:43:00","inspection_id":"80922354","insp_violation_id":"257998382","seq_no":"5","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"2","insp_unit_id":"199564350","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"393205A"},{"id":7892603,"change_date":"2024-02-22 21:43:00","inspection_id":"80922354","insp_violation_id":"257998383","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199564349","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LK58969","created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8240018,"change_date":"2024-02-22 21:43:00","inspection_id":"80922354","insp_unit_id":"199564349","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9F77811","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR5CSBF3449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:42.000000Z","updated_at":"2025-03-17T23:09:42.000000Z"},{"id":8240019,"change_date":"2024-02-22 21:43:00","inspection_id":"80922354","insp_unit_id":"199564350","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RAVE","insp_unit_company":null,"insp_unit_license":"4AY3604","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1R1F04421FE850601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:42.000000Z","updated_at":"2025-03-17T23:09:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4175194\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4175194\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4175194\/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\/4175194\/inspections","per_page":100,"prev_page_url":null,"to":14,"total":14}