{"current_page":1,"data":[{"id":12247051,"change_date":"2026-06-22 21:39:00","inspection_id":"88205277","dot_number":"3250934","report_state":"CA","report_number":"UDXH001778","insp_date":"2026-06-22 00:00:00","insp_start_time":"0508","insp_end_time":"0530","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3593213","transaction_code":"A","transaction_date":"2026-06-22 00:00:00","upload_date":"2026-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2026-06-22 21:39:00","snet_input_date":"2026-06-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-22 21:39:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2026-06-25T09:38:45.000000Z","updated_at":"2026-07-03T09:30:32.000000Z","inspection_violations":[{"id":21316842,"change_date":"2026-06-22 21:39:00","inspection_id":"88205277","insp_violation_id":"275046735","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SN63476","created_at":"2026-06-25T09:55:49.000000Z","updated_at":"2026-07-03T09:42:18.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":21267998,"change_date":"2026-06-22 21:39:00","inspection_id":"88205277","insp_unit_id":"214217462","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"53256E4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC2KDKS1484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:05.000000Z","updated_at":"2026-07-05T09:01:26.000000Z"}]},{"id":11723669,"change_date":"2026-04-22 21:39:00","inspection_id":"87651324","dot_number":"3250934","report_state":"CA","report_number":"NCEB009648","insp_date":"2026-04-21 00:00:00","insp_start_time":"1319","insp_end_time":"1340","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":"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":"2026-04-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"16259068","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2026-04-22 21:39:00","snet_input_date":"2026-04-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-22 21:39:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:40:03.000000Z","updated_at":"2026-05-03T09:31:25.000000Z","inspection_violations":[{"id":20381846,"change_date":"2026-04-22 21:39:00","inspection_id":"87651324","insp_violation_id":"273787317","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"213166845","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:59:37.000000Z","updated_at":"2026-05-03T09:43:31.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":20400275,"change_date":"2026-04-22 21:39:00","inspection_id":"87651324","insp_unit_id":"213166845","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"221900 WHT","insp_unit_license":"53256E4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC2KDKS1484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:17:49.000000Z","updated_at":"2026-05-03T09:04:23.000000Z"}]},{"id":11243721,"change_date":"2026-02-26 21:42:00","inspection_id":"87156540","dot_number":"3250934","report_state":"CA","report_number":"NARW004194","insp_date":"2026-02-25 00:00:00","insp_start_time":"0932","insp_end_time":"0957","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16186073","transaction_code":"A","transaction_date":"2026-02-25 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2026-02-26 21:42:00","snet_input_date":"2026-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-26 21:42:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2026-03-01T10:39:09.000000Z","updated_at":"2026-03-09T09:32:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19221100,"change_date":"2026-02-26 21:42:00","inspection_id":"87156540","insp_unit_id":"211867714","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/2X","insp_unit_license":"36965A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT5HDHV3732","insp_unit_decal":"Y","insp_unit_decal_number":"35884328","created_at":"2026-03-01T10:15:51.000000Z","updated_at":"2026-03-09T09:10:38.000000Z"}]},{"id":11165822,"change_date":"2026-02-18 21:39:00","inspection_id":"87081269","dot_number":"3250934","report_state":"CA","report_number":"NEAH006521","insp_date":"2026-02-17 00:00:00","insp_start_time":"1329","insp_end_time":"1352","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"16174608","transaction_code":"A","transaction_date":"2026-02-17 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2026-02-18 21:39:00","snet_input_date":"2026-02-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-18 21:39:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2026-02-21T10:38:04.000000Z","updated_at":"2026-03-01T10:30:58.000000Z","inspection_violations":[{"id":18716240,"change_date":"2026-02-18 21:39:00","inspection_id":"87081269","insp_violation_id":"271881293","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"211695687","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:54.000000Z","updated_at":"2026-03-01T10:41:17.000000Z","normalized_code":"3939ALIL"},{"id":18716241,"change_date":"2026-02-18 21:39:00","inspection_id":"87081269","insp_violation_id":"271881294","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"211695687","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:54.000000Z","updated_at":"2026-03-01T10:41:17.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":19051212,"change_date":"2026-02-18 21:39:00","inspection_id":"87081269","insp_unit_id":"211695687","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"221900\/WHT","insp_unit_license":"53256E4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC2KDKS1484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:14:06.000000Z","updated_at":"2026-03-01T10:04:01.000000Z"}]},{"id":10782502,"change_date":"2026-01-15 21:41:00","inspection_id":"86808278","dot_number":"3250934","report_state":"CA","report_number":"NARW004051","insp_date":"2026-01-12 00:00:00","insp_start_time":"0926","insp_end_time":"0937","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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":"2026-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"16131746","transaction_code":"A","transaction_date":"2026-01-12 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2026-01-15 21:41:00","snet_input_date":"2026-01-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"36965A4","created_at":"2026-01-18T10:45:30.000000Z","updated_at":"2026-01-26T10:31:13.000000Z","inspection_violations":[{"id":18017627,"change_date":"2026-01-15 21:41:00","inspection_id":"86808278","insp_violation_id":"271240541","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"211118783","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA674643","created_at":"2026-01-18T11:04:49.000000Z","updated_at":"2026-01-26T10:32:06.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":18102219,"change_date":"2026-01-15 21:41:00","inspection_id":"86808278","insp_unit_id":"211118783","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/2X","insp_unit_license":"36965A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT5HDHV3732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:17:43.000000Z","updated_at":"2026-01-26T10:01:25.000000Z"}]},{"id":10337142,"change_date":"2025-12-02 21:39:00","inspection_id":"86464443","dot_number":"3250934","report_state":"CA","report_number":"UCTU002261","insp_date":"2025-11-30 00:00:00","insp_start_time":"0825","insp_end_time":"0831","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"16077559","transaction_code":"A","transaction_date":"2025-11-30 00:00:00","upload_date":"2025-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2025-12-02 21:39:00","snet_input_date":"2025-11-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-02 21:39:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-05T10:32:39.000000Z","updated_at":"2025-12-06T10:31:15.000000Z","inspection_violations":[{"id":17293086,"change_date":"2025-12-02 21:39:00","inspection_id":"86464443","insp_violation_id":"270414930","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"210372700","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA674453","created_at":"2025-12-05T10:33:35.000000Z","updated_at":"2025-12-06T10:32:07.000000Z","normalized_code":"3939ALHLI"},{"id":17293087,"change_date":"2025-12-02 21:39:00","inspection_id":"86464443","insp_violation_id":"270414931","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"210372700","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:35.000000Z","updated_at":"2025-12-06T10:32:07.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":17264630,"change_date":"2025-12-02 21:39:00","inspection_id":"86464443","insp_unit_id":"210372700","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT2X","insp_unit_license":"53256E4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC2KDKS1484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:03:01.000000Z","updated_at":"2025-12-06T10:01:18.000000Z"}]},{"id":10322401,"change_date":"2025-12-01 21:39:00","inspection_id":"86449140","dot_number":"3250934","report_state":"CA","report_number":"NE7S005445","insp_date":"2025-11-26 00:00:00","insp_start_time":"0735","insp_end_time":"0756","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16074263","transaction_code":"A","transaction_date":"2025-11-26 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-12-04T10:30:43.000000Z","updated_at":"2025-12-05T10:31:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17238560,"change_date":"2025-12-01 21:39:00","inspection_id":"86449140","insp_unit_id":"210339093","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHITE\/2AX","insp_unit_license":"53256E4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC2KDKS1484","insp_unit_decal":"Y","insp_unit_decal_number":"35615771","created_at":"2025-12-04T10:00:46.000000Z","updated_at":"2025-12-05T10:02:00.000000Z"}]},{"id":10319942,"change_date":"2025-12-01 21:39:00","inspection_id":"86446639","dot_number":"3250934","report_state":"CA","report_number":"NBGO009302","insp_date":"2025-11-25 00:00:00","insp_start_time":"0620","insp_end_time":"0640","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JAL TRUCKING","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-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16070842","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":"03250934","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":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234847,"change_date":"2025-12-01 21:39:00","inspection_id":"86446639","insp_unit_id":"210335217","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2\/WHT\/BOX","insp_unit_license":"53256E4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC2KDKS1484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:40.000000Z"}]},{"id":10112180,"change_date":"2025-11-04 21:40:00","inspection_id":"86228228","dot_number":"3250934","report_state":"CA","report_number":"UDXH001375","insp_date":"2025-11-03 00:00:00","insp_start_time":"0644","insp_end_time":"0720","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"8TH ST AND BRYANT ST","county_code_state":"CA","county_code":"075","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":"2025-11-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"16044522","transaction_code":"C","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2025-11-03 21:40:00","snet_input_date":"2025-11-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-03 21:40:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-11-06T10:30:49.000000Z","updated_at":"2025-11-08T10:30:56.000000Z","inspection_violations":[{"id":16770201,"change_date":"2025-11-04 21:40:00","inspection_id":"86228228","insp_violation_id":"269728836","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209839222","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:33.000000Z","updated_at":"2025-11-08T10:31:17.000000Z","normalized_code":"3922SLLSR"},{"id":16770202,"change_date":"2025-11-04 21:40:00","inspection_id":"86228228","insp_violation_id":"269728837","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"209839222","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-07T10:31:33.000000Z","updated_at":"2025-11-08T10:31:17.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":16830914,"change_date":"2025-11-04 21:40:00","inspection_id":"86228228","insp_unit_id":"209839222","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"03300M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162G7003134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:34.000000Z","updated_at":"2025-11-08T10:01:13.000000Z"}]},{"id":9117383,"change_date":"2025-07-10 21:39:00","inspection_id":"85182468","dot_number":"3250934","report_state":"CA","report_number":"UDBH003505","insp_date":"2025-07-10 00:00:00","insp_start_time":"0940","insp_end_time":"1034","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"US101 SB N OF LUCAS VALLEY","county_code_state":"CA","county_code":"041","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15892655","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2025-07-10 21:39:00","snet_input_date":"2025-07-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-10 21:39:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-14T10:46:53.000000Z","updated_at":"2025-07-14T10:46:53.000000Z","inspection_violations":[{"id":14696250,"change_date":"2025-07-10 21:39:00","inspection_id":"85182468","insp_violation_id":"267334214","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207809765","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:49.000000Z","updated_at":"2025-07-14T10:48:29.000000Z","normalized_code":"39347E"},{"id":14696251,"change_date":"2025-07-10 21:39:00","inspection_id":"85182468","insp_violation_id":"267334215","seq_no":"2","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"207809765","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-13T10:49:49.000000Z","updated_at":"2025-07-14T10:48:29.000000Z","normalized_code":"3963A1BOS"},{"id":14696252,"change_date":"2025-07-10 21:39:00","inspection_id":"85182468","insp_violation_id":"267334216","seq_no":"3","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"207809765","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RV63435","created_at":"2025-07-13T10:49:49.000000Z","updated_at":"2025-07-14T10:48:29.000000Z","normalized_code":"393203BCBP"},{"id":14696253,"change_date":"2025-07-10 21:39:00","inspection_id":"85182468","insp_violation_id":"267334217","seq_no":"4","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"207809765","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:49.000000Z","updated_at":"2025-07-14T10:48:29.000000Z","normalized_code":"393203BCBP"},{"id":14696254,"change_date":"2025-07-10 21:39:00","inspection_id":"85182468","insp_violation_id":"267334218","seq_no":"5","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"207809765","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:49.000000Z","updated_at":"2025-07-14T10:48:29.000000Z","normalized_code":"393203BCBP"},{"id":14696255,"change_date":"2025-07-10 21:39:00","inspection_id":"85182468","insp_violation_id":"267334219","seq_no":"6","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"207809765","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:49.000000Z","updated_at":"2025-07-14T10:48:29.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":14968100,"change_date":"2025-07-10 21:39:00","inspection_id":"85182468","insp_unit_id":"207809765","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"36965A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT5HDHV3732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:47:00.000000Z","updated_at":"2025-07-14T09:45:59.000000Z"}]},{"id":9127664,"change_date":"2025-07-11 21:40:00","inspection_id":"85193136","dot_number":"3250934","report_state":"CA","report_number":"UDBH003510","insp_date":"2025-07-10 00:00:00","insp_start_time":"1350","insp_end_time":"1416","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"US101 SB N OF LUCAS VALLEY","county_code_state":"CA","county_code":"041","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15893399","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2025-07-11 21:40:00","snet_input_date":"2025-07-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-11 21:40:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:09.000000Z","updated_at":"2025-07-16T10:45:02.000000Z","inspection_violations":[{"id":14718469,"change_date":"2025-07-11 21:40:00","inspection_id":"85193136","insp_violation_id":"267359350","seq_no":"1","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"207829640","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:49:00.000000Z","updated_at":"2025-07-16T10:46:42.000000Z","normalized_code":"393203BCBP"},{"id":14718470,"change_date":"2025-07-11 21:40:00","inspection_id":"85193136","insp_violation_id":"267359351","seq_no":"2","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"207829640","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:49:00.000000Z","updated_at":"2025-07-16T10:46:42.000000Z","normalized_code":"393203BCBP"},{"id":14718471,"change_date":"2025-07-11 21:40:00","inspection_id":"85193136","insp_violation_id":"267359352","seq_no":"3","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"207829640","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:49:00.000000Z","updated_at":"2025-07-16T10:46:42.000000Z","normalized_code":"393203BCBP"}],"inspection_per_units":[{"id":14986511,"change_date":"2025-07-11 21:40:00","inspection_id":"85193136","insp_unit_id":"207829640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"36965A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT5HDHV3732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:11.000000Z","updated_at":"2025-07-15T09:46:15.000000Z"}]},{"id":8748314,"change_date":"2025-05-27 21:39:00","inspection_id":"84791949","dot_number":"3250934","report_state":"CA","report_number":"UD4G003724","insp_date":"2025-05-26 00:00:00","insp_start_time":"0922","insp_end_time":"0935","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":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15836423","transaction_code":"A","transaction_date":"2025-05-26 00:00:00","upload_date":"2025-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2025-05-27 21:39:00","snet_input_date":"2025-05-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-27 21:39:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-05-30T10:00:39.000000Z","updated_at":"2025-05-31T10:01:10.000000Z","inspection_violations":[{"id":13965274,"change_date":"2025-05-27 21:39:00","inspection_id":"84791949","insp_violation_id":"266499220","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207087107","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SC10035","created_at":"2025-05-30T10:16:00.000000Z","updated_at":"2025-05-31T10:18:08.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14304710,"change_date":"2025-05-27 21:39:00","inspection_id":"84791949","insp_unit_id":"207087107","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"36965A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT5HDHV3732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:39.000000Z","updated_at":"2025-05-31T09:47:45.000000Z"}]},{"id":7677404,"change_date":"2025-01-21 21:40:00","inspection_id":"83665084","dot_number":"3250934","report_state":"CA","report_number":"NE7S004221","insp_date":"2025-01-18 00:00:00","insp_start_time":"0650","insp_end_time":"0720","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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-01-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15670386","transaction_code":"A","transaction_date":"2025-01-18 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T20:57:29.000000Z","updated_at":"2025-03-17T20:57:29.000000Z","inspection_violations":[{"id":11997730,"change_date":"2025-01-21 21:40:00","inspection_id":"83665084","insp_violation_id":"264113087","seq_no":"1","part_no":"393","part_no_section":"11A1-LFTSM","insp_viol_unit":"1","insp_unit_id":"204945014","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ 00600","created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39311A1LFTSM"},{"id":11997731,"change_date":"2025-01-21 21:40:00","inspection_id":"83665084","insp_violation_id":"264113088","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"204945014","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":12388614,"change_date":"2025-01-21 21:40:00","inspection_id":"83665084","insp_unit_id":"204945014","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2X\/WHT","insp_unit_license":"36965A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT5HDHV3732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:42.000000Z","updated_at":"2025-03-17T23:51:42.000000Z"}]},{"id":7490577,"change_date":"2024-12-23 21:40:00","inspection_id":"83468935","dot_number":"3250934","report_state":"CA","report_number":"UCTU002067","insp_date":"2024-12-21 00:00:00","insp_start_time":"1136","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15638452","transaction_code":"A","transaction_date":"2024-12-21 00:00:00","upload_date":"2024-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2024-12-23 21:40:00","snet_input_date":"2024-12-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-23 21:40:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:20.000000Z","updated_at":"2025-03-17T20:52:20.000000Z","inspection_violations":[{"id":11709154,"change_date":"2024-12-23 21:40:00","inspection_id":"83468935","insp_violation_id":"263639537","seq_no":"1","part_no":"393","part_no_section":"205C-WR","insp_viol_unit":"1","insp_unit_id":"204538150","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"VERBAL","created_at":"2025-03-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"393205CWR"},{"id":11709155,"change_date":"2024-12-23 21:40:00","inspection_id":"83468935","insp_violation_id":"263639538","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204538150","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"3922SLLSR"},{"id":11709156,"change_date":"2024-12-23 21:40:00","inspection_id":"83468935","insp_violation_id":"263639539","seq_no":"3","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"204538150","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"3939ALFTSI"},{"id":11709157,"change_date":"2024-12-23 21:40:00","inspection_id":"83468935","insp_violation_id":"263639540","seq_no":"4","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"204538150","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"3939ALLPL"},{"id":11709158,"change_date":"2024-12-23 21:40:00","inspection_id":"83468935","insp_violation_id":"263639541","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204538150","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"3922SLLSR"},{"id":11709159,"change_date":"2024-12-23 21:40:00","inspection_id":"83468935","insp_violation_id":"263639542","seq_no":"6","part_no":"392","part_no_section":"9BA-NOREGINTER","insp_viol_unit":"1","insp_unit_id":"204538150","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"3929BANOREGINTER"}],"inspection_per_units":[{"id":12084471,"change_date":"2024-12-23 21:40:00","inspection_id":"83468935","insp_unit_id":"204538150","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT2X","insp_unit_license":"36965A4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT5HDHV3732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:25.000000Z","updated_at":"2025-03-17T23:48:25.000000Z"}]},{"id":7223066,"change_date":"2024-11-18 21:41:00","inspection_id":"83187261","dot_number":"3250934","report_state":"CA","report_number":"NE02004960","insp_date":"2024-11-14 00:00:00","insp_start_time":"2142","insp_end_time":"2202","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15596956","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T20:46:48.000000Z","updated_at":"2025-03-17T20:46:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11651025,"change_date":"2024-11-18 21:41:00","inspection_id":"83187261","insp_unit_id":"203940309","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"YEL2X","insp_unit_license":"15677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT1FDGC0913","insp_unit_decal":"Y","insp_unit_decal_number":"34468616","created_at":"2025-03-17T23:43:45.000000Z","updated_at":"2025-03-17T23:43:45.000000Z"}]},{"id":6955028,"change_date":"2024-10-14 21:37:00","inspection_id":"82903007","dot_number":"3250934","report_state":"CA","report_number":"NE02004831","insp_date":"2024-10-10 00:00:00","insp_start_time":"2037","insp_end_time":"2104","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-14 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15555544","transaction_code":"A","transaction_date":"2024-10-10 00:00:00","upload_date":"2024-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2024-10-14 21:37:00","snet_input_date":"2024-10-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-14 21:37:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T20:41:03.000000Z","updated_at":"2025-03-17T20:41:03.000000Z","inspection_violations":[{"id":10844976,"change_date":"2024-10-14 21:37:00","inspection_id":"82903007","insp_violation_id":"262341622","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"38323A2"},{"id":10844977,"change_date":"2024-10-14 21:37:00","inspection_id":"82903007","insp_violation_id":"262341623","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203401812","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":11217900,"change_date":"2024-10-14 21:37:00","inspection_id":"82903007","insp_unit_id":"203401812","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"100778\/YEL2","insp_unit_license":"15677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT1FDGC0913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:08.000000Z","updated_at":"2025-03-17T23:39:08.000000Z"}]},{"id":6762466,"change_date":"2024-09-18 21:43:00","inspection_id":"82698007","dot_number":"3250934","report_state":"CA","report_number":"UCV3002301","insp_date":"2024-09-17 00:00:00","insp_start_time":"1706","insp_end_time":"1723","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15525511","transaction_code":"A","transaction_date":"2024-09-17 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2024-09-18 21:43:00","snet_input_date":"2024-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-18 21:43:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T20:37:18.000000Z","updated_at":"2025-03-17T20:37:18.000000Z","inspection_violations":[{"id":10530886,"change_date":"2024-09-18 21:43:00","inspection_id":"82698007","insp_violation_id":"261907570","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203015643","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW953520","created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10904730,"change_date":"2024-09-18 21:43:00","inspection_id":"82698007","insp_unit_id":"203015643","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2 AXLE","insp_unit_license":"15677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT1FDGC0913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:56.000000Z","updated_at":"2025-03-17T23:35:56.000000Z"}]},{"id":6783450,"change_date":"2024-09-20 21:43:00","inspection_id":"82720760","dot_number":"3250934","report_state":"CA","report_number":"NEEU002575","insp_date":"2024-09-17 00:00:00","insp_start_time":"0642","insp_end_time":"0710","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15528220","transaction_code":"A","transaction_date":"2024-09-17 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2024-09-20 21:43:00","snet_input_date":"2024-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-20 21:43:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:42.000000Z","updated_at":"2025-03-17T20:37:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10938824,"change_date":"2024-09-20 21:43:00","inspection_id":"82720760","insp_unit_id":"203058928","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT","insp_unit_license":"2438332","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWDT5HDHV3732","insp_unit_decal":"Y","insp_unit_decal_number":"34154350","created_at":"2025-03-17T23:36:18.000000Z","updated_at":"2025-03-17T23:36:18.000000Z"}]},{"id":6395707,"change_date":"2024-08-05 21:43:00","inspection_id":"82307154","dot_number":"3250934","report_state":"CA","report_number":"UBZU003802","insp_date":"2024-07-31 00:00:00","insp_start_time":"1250","insp_end_time":"1330","registration_date":null,"region":"PT","ci_status_code":"C","location":"891","location_desc":"CORDELIA CVEF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15471033","transaction_code":"A","transaction_date":"2024-07-31 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2024-08-05 21:43:00","snet_input_date":"2024-07-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-05 21:43:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T20:29:32.000000Z","updated_at":"2025-03-17T20:29:32.000000Z","inspection_violations":[{"id":9928463,"change_date":"2024-08-05 21:43:00","inspection_id":"82307154","insp_violation_id":"261024750","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202245214","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:01.000000Z","updated_at":"2025-03-17T21:54:01.000000Z","normalized_code":"39345B2"},{"id":9928464,"change_date":"2024-08-05 21:43:00","inspection_id":"82307154","insp_violation_id":"261024751","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"202245214","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:01.000000Z","updated_at":"2025-03-17T21:54:01.000000Z","normalized_code":"39360C"},{"id":9928465,"change_date":"2024-08-05 21:43:00","inspection_id":"82307154","insp_violation_id":"261024752","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202245214","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:01.000000Z","updated_at":"2025-03-17T21:54:01.000000Z","normalized_code":"3939A"},{"id":9928466,"change_date":"2024-08-05 21:43:00","inspection_id":"82307154","insp_violation_id":"261024753","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202245214","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:01.000000Z","updated_at":"2025-03-17T21:54:01.000000Z","normalized_code":"3939A"},{"id":9928467,"change_date":"2024-08-05 21:43:00","inspection_id":"82307154","insp_violation_id":"261024754","seq_no":"5","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:01.000000Z","updated_at":"2025-03-17T21:54:01.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":10307189,"change_date":"2024-08-05 21:43:00","inspection_id":"82307154","insp_unit_id":"202245214","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"15677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT1FDGC0913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:49.000000Z","updated_at":"2025-03-17T23:29:49.000000Z"}]},{"id":5192752,"change_date":"2024-03-01 21:40:00","inspection_id":"81003394","dot_number":"3250934","report_state":"CA","report_number":"NARW002090","insp_date":"2024-02-27 00:00:00","insp_start_time":"0723","insp_end_time":"0731","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15264799","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2024-03-01 21:40:00","snet_input_date":"2024-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-01 21:40:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T20:05:22.000000Z","updated_at":"2025-03-17T20:05:22.000000Z","inspection_violations":[{"id":8004326,"change_date":"2024-03-01 21:40:00","inspection_id":"81003394","insp_violation_id":"258163582","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199717716","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:42.000000Z","updated_at":"2025-03-17T21:44:42.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8361191,"change_date":"2024-03-01 21:40:00","inspection_id":"81003394","insp_unit_id":"199717716","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"YEL\/2X","insp_unit_license":"15677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT1FDGC0913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:45.000000Z","updated_at":"2025-03-17T23:10:45.000000Z"}]},{"id":5157305,"change_date":"2024-02-28 21:42:00","inspection_id":"80965214","dot_number":"3250934","report_state":"CA","report_number":"N8MC007983","insp_date":"2024-02-14 00:00:00","insp_start_time":"1015","insp_end_time":"1033","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":"2024-02-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15259512","transaction_code":"A","transaction_date":"2024-02-14 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2024-02-28 21:42:00","snet_input_date":"2024-02-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:42:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:36.000000Z","updated_at":"2025-03-17T20:04:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8304069,"change_date":"2024-02-28 21:42:00","inspection_id":"80965214","insp_unit_id":"199648427","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2X\/YEL","insp_unit_license":"15677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT1FDGC0913","insp_unit_decal":"Y","insp_unit_decal_number":"33574132","created_at":"2025-03-17T23:10:14.000000Z","updated_at":"2025-03-17T23:10:14.000000Z"}]},{"id":4979514,"change_date":"2024-02-05 21:40:00","inspection_id":"80770936","dot_number":"3250934","report_state":"CA","report_number":"NARW002008","insp_date":"2024-01-29 00:00:00","insp_start_time":"1105","insp_end_time":"1133","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15224392","transaction_code":"A","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2024-02-05 21:40:00","snet_input_date":"2024-01-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-05 21:40:00","insp_carrier_name":"JAL TRUCKING","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T20:01:17.000000Z","updated_at":"2025-03-17T20:01:17.000000Z","inspection_violations":[{"id":7671017,"change_date":"2024-02-05 21:40:00","inspection_id":"80770936","insp_violation_id":"257671779","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199273848","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:03.000000Z","updated_at":"2025-03-17T21:43:03.000000Z","normalized_code":"3939A"},{"id":7671018,"change_date":"2024-02-05 21:40:00","inspection_id":"80770936","insp_violation_id":"257671780","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199273848","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:03.000000Z","updated_at":"2025-03-17T21:43:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8014432,"change_date":"2024-02-05 21:40:00","inspection_id":"80770936","insp_unit_id":"199273848","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"YEL\/2X","insp_unit_license":"15677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT1FDGC0913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:38.000000Z","updated_at":"2025-03-17T23:07:38.000000Z"}]},{"id":4554795,"change_date":"2023-12-04 21:42:00","inspection_id":"80306181","dot_number":"3250934","report_state":"CA","report_number":"UF6X002334","insp_date":"2023-12-03 00:00:00","insp_start_time":"1440","insp_end_time":"1450","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15153904","transaction_code":"A","transaction_date":"2023-12-03 00:00:00","upload_date":"2023-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2023-12-04 21:42:00","snet_input_date":"2023-12-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-04 21:42:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T19:53:01.000000Z","updated_at":"2025-03-17T19:53:01.000000Z","inspection_violations":[{"id":7045178,"change_date":"2023-12-04 21:42:00","inspection_id":"80306181","insp_violation_id":"256705268","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198342927","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:01.000000Z","updated_at":"2025-03-17T21:40:01.000000Z","normalized_code":"3922"},{"id":7045179,"change_date":"2023-12-04 21:42:00","inspection_id":"80306181","insp_violation_id":"256705269","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:01.000000Z","updated_at":"2025-03-17T21:40:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7325649,"change_date":"2023-12-04 21:42:00","inspection_id":"80306181","insp_unit_id":"198342927","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X WHT","insp_unit_license":"03300M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162G7003134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:34.000000Z","updated_at":"2025-03-17T23:01:34.000000Z"}]},{"id":4414020,"change_date":"2023-11-13 21:42:00","inspection_id":"80151403","dot_number":"3250934","report_state":"CA","report_number":"NDUP004995","insp_date":"2023-11-02 00:00:00","insp_start_time":"1202","insp_end_time":"1237","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"3950 E\/B INTERSTATE 80","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15132021","transaction_code":"A","transaction_date":"2023-11-02 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2023-11-13 21:42:00","snet_input_date":"2023-11-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-13 21:42:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T19:50:19.000000Z","updated_at":"2025-03-17T19:50:19.000000Z","inspection_violations":[{"id":6831279,"change_date":"2023-11-13 21:42:00","inspection_id":"80151403","insp_violation_id":"256367830","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"198036081","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:53.000000Z","updated_at":"2025-03-17T21:38:53.000000Z","normalized_code":"39345B2"},{"id":6831280,"change_date":"2023-11-13 21:42:00","inspection_id":"80151403","insp_violation_id":"256367831","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198036081","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:53.000000Z","updated_at":"2025-03-17T21:38:53.000000Z","normalized_code":"3963A1"},{"id":6831281,"change_date":"2023-11-13 21:42:00","inspection_id":"80151403","insp_violation_id":"256367832","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198036081","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:53.000000Z","updated_at":"2025-03-17T21:38:53.000000Z","normalized_code":"3939A"},{"id":6831282,"change_date":"2023-11-13 21:42:00","inspection_id":"80151403","insp_violation_id":"256367833","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198036081","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:53.000000Z","updated_at":"2025-03-17T21:38:53.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7098950,"change_date":"2023-11-13 21:42:00","inspection_id":"80151403","insp_unit_id":"198036081","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"100778 2X","insp_unit_license":"15677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT1FDGC0913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:35.000000Z","updated_at":"2025-03-17T22:59:35.000000Z"}]},{"id":3851804,"change_date":"2023-08-28 21:43:00","inspection_id":"79527909","dot_number":"3250934","report_state":"CA","report_number":"UDLV002788","insp_date":"2023-08-28 00:00:00","insp_start_time":"0715","insp_end_time":"0731","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SFOBB TOLL PLAZA BUS ONLY LANE","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15041062","transaction_code":"A","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2023-08-28 21:43:00","snet_input_date":"2023-08-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-28 21:43:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T19:38:56.000000Z","updated_at":"2025-03-17T19:38:56.000000Z","inspection_violations":[{"id":5950104,"change_date":"2023-08-28 21:43:00","inspection_id":"79527909","insp_violation_id":"254937339","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MJ07925","created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6193086,"change_date":"2023-08-28 21:43:00","inspection_id":"79527909","insp_unit_id":"196774003","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"03300M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162G7003134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:02.000000Z","updated_at":"2025-03-17T22:52:02.000000Z"}]},{"id":3781373,"change_date":"2023-08-18 21:42:00","inspection_id":"79449078","dot_number":"3250934","report_state":"CA","report_number":"UF73001603","insp_date":"2023-08-17 00:00:00","insp_start_time":"1016","insp_end_time":"1031","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":"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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15026989","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2023-08-18 21:42:00","snet_input_date":"2023-08-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-18 21:42:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T19:37:38.000000Z","updated_at":"2025-03-17T19:37:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6080043,"change_date":"2023-08-18 21:42:00","inspection_id":"79449078","insp_unit_id":"196618524","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"03300M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162G7003134","insp_unit_decal":"Y","insp_unit_decal_number":"32845789","created_at":"2025-03-17T22:51:06.000000Z","updated_at":"2025-03-17T22:51:06.000000Z"}]},{"id":2374319,"change_date":"2023-02-14 21:42:00","inspection_id":"77859854","dot_number":"3250934","report_state":"CA","report_number":"N5Y3003997","insp_date":"2023-02-08 00:00:00","insp_start_time":"1241","insp_end_time":"1259","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":"JAL","shipping_paper_number":"133020723","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"14783785","transaction_code":"A","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2023-02-14 21:42:00","snet_input_date":"2023-02-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-14 21:42:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T19:10:22.000000Z","updated_at":"2025-03-17T19:10:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3820872,"change_date":"2023-02-14 21:42:00","inspection_id":"77859854","insp_unit_id":"193405728","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHI","insp_unit_license":"03300M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162G7003134","insp_unit_decal":"Y","insp_unit_decal_number":"32208949","created_at":"2025-03-17T22:33:22.000000Z","updated_at":"2025-03-17T22:33:22.000000Z"}]},{"id":1874399,"change_date":"2022-12-05 21:40:00","inspection_id":"77288347","dot_number":"3250934","report_state":"CA","report_number":"NE7S001548","insp_date":"2022-11-30 00:00:00","insp_start_time":"1104","insp_end_time":"1130","registration_date":null,"region":"PT","ci_status_code":"C","location":"370","location_desc":"OAKLAND AREA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"7","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14695680","transaction_code":"A","transaction_date":"2022-11-30 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2022-12-05 21:40:00","snet_input_date":"2022-11-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-05 21:40:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T19:01:08.000000Z","updated_at":"2025-03-17T19:01:08.000000Z","inspection_violations":[{"id":2919104,"change_date":"2022-12-05 21:40:00","inspection_id":"77288347","insp_violation_id":"249926432","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192266616","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"3963A1"},{"id":2919105,"change_date":"2022-12-05 21:40:00","inspection_id":"77288347","insp_violation_id":"249926433","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"192266616","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"39345"},{"id":2919106,"change_date":"2022-12-05 21:40:00","inspection_id":"77288347","insp_violation_id":"249926434","seq_no":"3","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"192266616","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"39345"},{"id":2919107,"change_date":"2022-12-05 21:40:00","inspection_id":"77288347","insp_violation_id":"249926435","seq_no":"4","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"192266616","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"39345"},{"id":2919108,"change_date":"2022-12-05 21:40:00","inspection_id":"77288347","insp_violation_id":"249926436","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192266616","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"3963A1"},{"id":2919109,"change_date":"2022-12-05 21:40:00","inspection_id":"77288347","insp_violation_id":"249926437","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192266616","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"3939A"},{"id":2919110,"change_date":"2022-12-05 21:40:00","inspection_id":"77288347","insp_violation_id":"249926438","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192266616","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3017090,"change_date":"2022-12-05 21:40:00","inspection_id":"77288347","insp_unit_id":"192266616","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"8P71436","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HTMMAAL89N044968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:39.000000Z","updated_at":"2025-03-17T22:27:39.000000Z"}]},{"id":1811858,"change_date":"2022-11-23 21:40:00","inspection_id":"77216936","dot_number":"3250934","report_state":"CA","report_number":"UFPH000673","insp_date":"2022-11-10 00:00:00","insp_start_time":"2030","insp_end_time":"2053","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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":"2022-11-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"14684551","transaction_code":"A","transaction_date":"2022-11-11 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2022-11-23 21:40:00","snet_input_date":"2022-11-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:00.000000Z","updated_at":"2025-03-17T19:00:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2914464,"change_date":"2022-11-23 21:40:00","inspection_id":"77216936","insp_unit_id":"192121677","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2XL WHT","insp_unit_license":"03300M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162G7003134","insp_unit_decal":"Y","insp_unit_decal_number":"31825860","created_at":"2025-03-17T22:26:56.000000Z","updated_at":"2025-03-17T22:26:56.000000Z"}]},{"id":1383054,"change_date":"2022-09-27 21:40:00","inspection_id":"76722895","dot_number":"3250934","report_state":"CA","report_number":"NCZ3004028","insp_date":"2022-09-22 00:00:00","insp_start_time":"0720","insp_end_time":"0738","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":"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":"2022-09-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14610642","transaction_code":"A","transaction_date":"2022-09-22 00:00:00","upload_date":"2022-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2022-09-27 21:40:00","snet_input_date":"2022-09-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-27 21:40:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T18:52:18.000000Z","updated_at":"2025-03-17T18:52:18.000000Z","inspection_violations":[{"id":2186056,"change_date":"2022-09-27 21:40:00","inspection_id":"76722895","insp_violation_id":"248684477","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"191134337","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"39375A3"},{"id":2186057,"change_date":"2022-09-27 21:40:00","inspection_id":"76722895","insp_violation_id":"248684478","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191134337","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"3939A"},{"id":2186058,"change_date":"2022-09-27 21:40:00","inspection_id":"76722895","insp_violation_id":"248684479","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191134337","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2227263,"change_date":"2022-09-27 21:40:00","inspection_id":"76722895","insp_unit_id":"191134337","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"03300M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162G7003134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:15.000000Z","updated_at":"2025-03-17T22:22:15.000000Z"}]},{"id":1309245,"change_date":"2022-09-16 21:41:00","inspection_id":"76637355","dot_number":"3250934","report_state":"CA","report_number":"UDLV001979","insp_date":"2022-09-16 00:00:00","insp_start_time":"0935","insp_end_time":"0952","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","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":"2022-09-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14597597","transaction_code":"A","transaction_date":"2022-09-16 00:00:00","upload_date":"2022-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2022-09-16 21:41:00","snet_input_date":"2022-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-16 21:41:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T18:50:50.000000Z","updated_at":"2025-03-17T18:50:50.000000Z","inspection_violations":[{"id":2073419,"change_date":"2022-09-16 21:41:00","inspection_id":"76637355","insp_violation_id":"248486457","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190958716","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2107564,"change_date":"2022-09-16 21:41:00","inspection_id":"76637355","insp_unit_id":"190958716","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"15677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT1FDGC0913","insp_unit_decal":"Y","insp_unit_decal_number":"31484232","created_at":"2025-03-17T22:21:27.000000Z","updated_at":"2025-03-17T22:21:27.000000Z"}]},{"id":1224843,"change_date":"2022-09-06 21:43:00","inspection_id":"76539280","dot_number":"3250934","report_state":"CA","report_number":"UCZC001430","insp_date":"2022-09-03 00:00:00","insp_start_time":"0730","insp_end_time":"0759","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK PS","county_code_state":"CA","county_code":"013","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14581101","transaction_code":"A","transaction_date":"2022-09-03 00:00:00","upload_date":"2022-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2022-09-06 21:43:00","snet_input_date":"2022-09-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-06 21:43:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:19.000000Z","updated_at":"2025-03-17T18:49:19.000000Z","inspection_violations":[{"id":1940548,"change_date":"2022-09-06 21:43:00","inspection_id":"76539280","insp_violation_id":"248245390","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190752993","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"3963A1"},{"id":1940549,"change_date":"2022-09-06 21:43:00","inspection_id":"76539280","insp_violation_id":"248245391","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190752993","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1971069,"change_date":"2022-09-06 21:43:00","inspection_id":"76539280","insp_unit_id":"190752993","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2X YLW","insp_unit_license":"15677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT1FDGC0913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:33.000000Z","updated_at":"2025-03-17T22:20:33.000000Z"}]},{"id":1104577,"change_date":"2022-08-22 21:43:00","inspection_id":"76399703","dot_number":"3250934","report_state":"CA","report_number":"NAYO004800","insp_date":"2022-08-19 00:00:00","insp_start_time":"1229","insp_end_time":"1254","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":"2022-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14560815","transaction_code":"A","transaction_date":"2022-08-19 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2022-08-22 21:43:00","snet_input_date":"2022-08-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-22 21:43:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T18:47:13.000000Z","updated_at":"2025-03-17T18:47:13.000000Z","inspection_violations":[{"id":1742088,"change_date":"2022-08-22 21:43:00","inspection_id":"76399703","insp_violation_id":"247905444","seq_no":"1","part_no":"396","part_no_section":"7","insp_viol_unit":"1","insp_unit_id":"190471251","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:08.000000Z","updated_at":"2025-03-17T21:15:08.000000Z","normalized_code":"3967"}],"inspection_per_units":[{"id":1777125,"change_date":"2022-08-22 21:43:00","inspection_id":"76399703","insp_unit_id":"190471251","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE","insp_unit_license":"8P77436","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HTMMAAL89N044968","insp_unit_decal":"Y","insp_unit_decal_number":"31541103","created_at":"2025-03-17T22:19:14.000000Z","updated_at":"2025-03-17T22:19:14.000000Z"}]},{"id":823574,"change_date":"2022-07-14 21:42:00","inspection_id":"76071216","dot_number":"3250934","report_state":"CA","report_number":"UDT4001148","insp_date":"2022-07-09 00:00:00","insp_start_time":"1205","insp_end_time":"1240","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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":"2022-07-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14508089","transaction_code":"A","transaction_date":"2022-07-14 00:00:00","upload_date":"2022-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2022-07-14 21:42:00","snet_input_date":"2022-07-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-14 21:42:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T18:42:16.000000Z","updated_at":"2025-03-17T18:42:16.000000Z","inspection_violations":[{"id":1299480,"change_date":"2022-07-14 21:42:00","inspection_id":"76071216","insp_violation_id":"247111120","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189791678","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KL 41000","created_at":"2025-03-17T21:13:06.000000Z","updated_at":"2025-03-17T21:13:06.000000Z","normalized_code":"3939A"},{"id":1299481,"change_date":"2022-07-14 21:42:00","inspection_id":"76071216","insp_violation_id":"247111121","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189791678","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:06.000000Z","updated_at":"2025-03-17T21:13:06.000000Z","normalized_code":"3939A"},{"id":1299482,"change_date":"2022-07-14 21:42:00","inspection_id":"76071216","insp_violation_id":"247111122","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189791678","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:06.000000Z","updated_at":"2025-03-17T21:13:06.000000Z","normalized_code":"39395A"},{"id":1299483,"change_date":"2022-07-14 21:42:00","inspection_id":"76071216","insp_violation_id":"247111123","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189791678","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:06.000000Z","updated_at":"2025-03-17T21:13:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1325252,"change_date":"2022-07-14 21:42:00","inspection_id":"76071216","insp_unit_id":"189791678","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2X\/YEL","insp_unit_license":"15677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT1FDGC0913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:21.000000Z","updated_at":"2025-03-17T22:16:21.000000Z"}]},{"id":576417,"change_date":"2022-06-09 21:43:00","inspection_id":"75779621","dot_number":"3250934","report_state":"CA","report_number":"UEV6001702","insp_date":"2022-06-06 00:00:00","insp_start_time":"1030","insp_end_time":"1121","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"I-80 W\/B AT ANTELOPE SCALES","county_code_state":"CA","county_code":"067","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14463132","transaction_code":"A","transaction_date":"2022-06-06 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2022-06-09 21:43:00","snet_input_date":"2022-06-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-09 21:43:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T18:37:48.000000Z","updated_at":"2025-03-17T18:37:48.000000Z","inspection_violations":[{"id":902165,"change_date":"2022-06-09 21:43:00","inspection_id":"75779621","insp_violation_id":"246352913","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189161329","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ELECTRONIC","created_at":"2025-03-17T21:11:16.000000Z","updated_at":"2025-03-17T21:11:16.000000Z","normalized_code":"3939A"},{"id":902166,"change_date":"2022-06-09 21:43:00","inspection_id":"75779621","insp_violation_id":"246352914","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189161329","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ELECTRONIC","created_at":"2025-03-17T21:11:16.000000Z","updated_at":"2025-03-17T21:11:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":927060,"change_date":"2022-06-09 21:43:00","inspection_id":"75779621","insp_unit_id":"189161329","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"8P71436","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HTMMAAL89N044968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:54.000000Z","updated_at":"2025-03-17T22:13:54.000000Z"}]},{"id":353836,"change_date":"2022-05-09 21:42:00","inspection_id":"75514948","dot_number":"3250934","report_state":"CA","report_number":"UC13002274","insp_date":"2022-05-05 00:00:00","insp_start_time":"1200","insp_end_time":"1245","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14418708","transaction_code":"A","transaction_date":"2022-05-05 00:00:00","upload_date":"2022-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2022-05-09 21:42:00","snet_input_date":"2022-05-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-09 21:42:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T18:33:41.000000Z","updated_at":"2025-03-17T18:33:41.000000Z","inspection_violations":[{"id":555867,"change_date":"2022-05-09 21:42:00","inspection_id":"75514948","insp_violation_id":"245687441","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188594697","insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KR57168","created_at":"2025-03-17T21:09:38.000000Z","updated_at":"2025-03-17T21:09:38.000000Z","normalized_code":"3922"},{"id":555868,"change_date":"2022-05-09 21:42:00","inspection_id":"75514948","insp_violation_id":"245687442","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"KR57168","created_at":"2025-03-17T21:09:38.000000Z","updated_at":"2025-03-17T21:09:38.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":572225,"change_date":"2022-05-09 21:42:00","inspection_id":"75514948","insp_unit_id":"188594697","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"YEL BOX","insp_unit_license":"15677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT1FDGC0913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:43.000000Z","updated_at":"2025-03-17T22:11:43.000000Z"}]},{"id":247879,"change_date":"2022-04-25 21:41:00","inspection_id":"75388724","dot_number":"3250934","report_state":"CA","report_number":"NDQ6005324","insp_date":"2022-04-21 00:00:00","insp_start_time":"0907","insp_end_time":"0932","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"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":"2022-04-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14398435","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03250934","upload_search_indicator":null,"census_search_date":"2022-04-25 21:41:00","snet_input_date":"2022-04-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-25 21:41:00","insp_carrier_name":"BRENDA Y LOPEZ","insp_carrier_street":"14250 WAKE AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94578","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"544055","created_at":"2025-03-17T18:31:53.000000Z","updated_at":"2025-03-17T18:31:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":402056,"change_date":"2022-04-25 21:41:00","inspection_id":"75388724","insp_unit_id":"188327621","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2X YELLOW","insp_unit_license":"15677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT1FDGC0913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:40.000000Z","updated_at":"2025-03-17T22:10:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3250934\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3250934\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3250934\/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\/3250934\/inspections","per_page":100,"prev_page_url":null,"to":37,"total":37}