{"current_page":1,"data":[{"id":11373066,"change_date":"2026-03-13 21:38:00","inspection_id":"87286778","dot_number":"2682568","report_state":"CA","report_number":"UEGX002627","insp_date":"2026-03-13 00:00:00","insp_start_time":"0750","insp_end_time":"0830","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I680 NB WALNUT CRK PLTFM SCALE","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16208134","transaction_code":"A","transaction_date":"2026-03-13 00:00:00","upload_date":"2026-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2026-03-13 21:38:00","snet_input_date":"2026-03-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-13 21:38:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"397006","created_at":"2026-03-16T09:39:20.000000Z","updated_at":"2026-03-24T09:31:30.000000Z","inspection_violations":[{"id":19165667,"change_date":"2026-03-13 21:38:00","inspection_id":"87286778","insp_violation_id":"272397397","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"212129568","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW892400","created_at":"2026-03-16T10:01:31.000000Z","updated_at":"2026-03-24T09:45:12.000000Z","normalized_code":"39395A1"},{"id":19165668,"change_date":"2026-03-13 21:38:00","inspection_id":"87286778","insp_violation_id":"272397398","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"212129568","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-16T10:01:31.000000Z","updated_at":"2026-03-24T09:45:12.000000Z","normalized_code":"3922SLL"},{"id":19165669,"change_date":"2026-03-13 21:38:00","inspection_id":"87286778","insp_violation_id":"272397399","seq_no":"3","part_no":"393","part_no_section":"110C-C","insp_viol_unit":"1","insp_unit_id":"212129568","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2026-03-16T10:01:31.000000Z","updated_at":"2026-03-24T09:45:12.000000Z","normalized_code":"393110CC"},{"id":19165670,"change_date":"2026-03-13 21:38:00","inspection_id":"87286778","insp_violation_id":"272397400","seq_no":"4","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"212129568","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2026-03-16T10:01:31.000000Z","updated_at":"2026-03-24T09:45:12.000000Z","normalized_code":"393100BC"},{"id":19165671,"change_date":"2026-03-13 21:38:00","inspection_id":"87286778","insp_violation_id":"272397401","seq_no":"5","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"212129568","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-16T10:01:31.000000Z","updated_at":"2026-03-24T09:45:12.000000Z","normalized_code":"3939ALSML"},{"id":19165672,"change_date":"2026-03-13 21:38:00","inspection_id":"87286778","insp_violation_id":"272397402","seq_no":"6","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"212129568","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-16T10:01:31.000000Z","updated_at":"2026-03-24T09:45:12.000000Z","normalized_code":"39311A1LLPL"},{"id":19165673,"change_date":"2026-03-13 21:38:00","inspection_id":"87286778","insp_violation_id":"272397403","seq_no":"7","part_no":"393","part_no_section":"11A1-LSML","insp_viol_unit":"1","insp_unit_id":"212129568","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-16T10:01:31.000000Z","updated_at":"2026-03-24T09:45:12.000000Z","normalized_code":"39311A1LSML"}],"inspection_per_units":[{"id":19473845,"change_date":"2026-03-13 21:38:00","inspection_id":"87286778","insp_unit_id":"212129568","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"25880D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN1LEC31615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:17:01.000000Z","updated_at":"2026-03-24T09:05:18.000000Z"}]},{"id":9842554,"change_date":"2025-10-02 21:43:00","inspection_id":"85944066","dot_number":"2682568","report_state":"CA","report_number":"UDBH003741","insp_date":"2025-10-01 00:00:00","insp_start_time":"1545","insp_end_time":"1618","registration_date":null,"region":"PT","ci_status_code":"C","location":"9360","location_desc":"101 SB BRAKE CHECK","county_code_state":"CA","county_code":"097","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"16003081","transaction_code":"A","transaction_date":"2025-10-01 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2025-10-02 21:43:00","snet_input_date":"2025-10-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-02 21:43:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"397006","created_at":"2025-10-05T10:02:01.000000Z","updated_at":"2025-10-05T10:02:01.000000Z","inspection_violations":[{"id":16206874,"change_date":"2025-10-02 21:43:00","inspection_id":"85944066","insp_violation_id":"269067966","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"209273542","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:50.000000Z","updated_at":"2025-10-05T10:17:50.000000Z","normalized_code":"39021TB1MC"},{"id":16206875,"change_date":"2025-10-02 21:43:00","inspection_id":"85944066","insp_violation_id":"269067967","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"209273542","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:50.000000Z","updated_at":"2025-10-05T10:17:50.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":16321633,"change_date":"2025-10-02 21:43:00","inspection_id":"85944066","insp_unit_id":"209273542","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2XL WHT","insp_unit_license":"25880D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN1LEC31615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:04.000000Z","updated_at":"2025-10-05T09:47:04.000000Z"}]},{"id":9840410,"change_date":"2025-10-02 21:42:00","inspection_id":"85941888","dot_number":"2682568","report_state":"CA","report_number":"NC7K010376","insp_date":"2025-09-30 00:00:00","insp_start_time":"1555","insp_end_time":"1620","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"16002451","transaction_code":"A","transaction_date":"2025-09-30 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2025-10-02 21:42:00","snet_input_date":"2025-09-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-02 21:42:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-05T10:01:58.000000Z","updated_at":"2025-10-05T10:01:58.000000Z","inspection_violations":[{"id":16204773,"change_date":"2025-10-02 21:42:00","inspection_id":"85941888","insp_violation_id":"269065766","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209269865","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:46.000000Z","updated_at":"2025-10-05T10:17:46.000000Z","normalized_code":"3939ALIL"},{"id":16204774,"change_date":"2025-10-02 21:42:00","inspection_id":"85941888","insp_violation_id":"269065767","seq_no":"2","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"209269865","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:46.000000Z","updated_at":"2025-10-05T10:17:46.000000Z","normalized_code":"39311A1LLPL"}],"inspection_per_units":[{"id":16318074,"change_date":"2025-10-02 21:42:00","inspection_id":"85941888","insp_unit_id":"209269865","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT 2X","insp_unit_license":"19962N2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GY4HEF49553","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:01.000000Z","updated_at":"2025-10-05T09:47:01.000000Z"}]},{"id":9843253,"change_date":"2025-10-02 21:43:00","inspection_id":"85944794","dot_number":"2682568","report_state":"CA","report_number":"UFYK000780","insp_date":"2025-09-26 00:00:00","insp_start_time":"1525","insp_end_time":"1545","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"16001712","transaction_code":"A","transaction_date":"2025-09-26 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2025-10-02 21:43:00","snet_input_date":"2025-09-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-02 21:43:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"397006","created_at":"2025-10-05T10:02:02.000000Z","updated_at":"2025-10-05T10:02:02.000000Z","inspection_violations":[{"id":16207672,"change_date":"2025-10-02 21:43:00","inspection_id":"85944794","insp_violation_id":"269068938","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209274810","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:51.000000Z","updated_at":"2025-10-05T10:17:51.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16322821,"change_date":"2025-10-02 21:43:00","inspection_id":"85944794","insp_unit_id":"209274810","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X WHI","insp_unit_license":"19962N2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GY4HEF49553","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:05.000000Z","updated_at":"2025-10-05T09:47:05.000000Z"}]},{"id":9227986,"change_date":"2025-07-23 21:42:00","inspection_id":"85298703","dot_number":"2682568","report_state":"CA","report_number":"NDMK006453","insp_date":"2025-07-22 00:00:00","insp_start_time":"0745","insp_end_time":"0811","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":"2025-07-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"15910457","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2025-07-23 21:42:00","snet_input_date":"2025-07-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-23 21:42:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:39.000000Z","updated_at":"2025-07-27T10:41:39.000000Z","inspection_violations":[{"id":14935949,"change_date":"2025-07-23 21:42:00","inspection_id":"85298703","insp_violation_id":"267608138","seq_no":"1","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"208041250","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:42.000000Z","updated_at":"2025-07-27T10:43:43.000000Z","normalized_code":"39021TCMC"}],"inspection_per_units":[{"id":15182741,"change_date":"2025-07-23 21:42:00","inspection_id":"85298703","insp_unit_id":"208041250","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"61728L1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GY0EEA17177","insp_unit_decal":"Y","insp_unit_decal_number":"35338271","created_at":"2025-07-26T09:46:33.000000Z","updated_at":"2025-07-27T09:46:18.000000Z"}]},{"id":9005855,"change_date":"2025-06-26 21:42:00","inspection_id":"85064829","dot_number":"2682568","report_state":"CA","report_number":"UEGX001728","insp_date":"2025-06-18 00:00:00","insp_start_time":"0650","insp_end_time":"0720","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I680 NB WALNUT CRK PLTFM SCALE","county_code_state":"CA","county_code":"013","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-06-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15874309","transaction_code":"A","transaction_date":"2025-06-18 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2025-06-26 21:42:00","snet_input_date":"2025-06-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:42:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"397006","created_at":"2025-06-30T10:01:13.000000Z","updated_at":"2025-06-30T10:01:13.000000Z","inspection_violations":[{"id":14475320,"change_date":"2025-06-26 21:42:00","inspection_id":"85064829","insp_violation_id":"267079877","seq_no":"1","part_no":"393","part_no_section":"110B3-C","insp_viol_unit":"1","insp_unit_id":"207593058","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-06-29T10:17:04.000000Z","updated_at":"2025-06-30T10:18:54.000000Z","normalized_code":"393110B3C"},{"id":14475321,"change_date":"2025-06-26 21:42:00","inspection_id":"85064829","insp_violation_id":"267079878","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"207593058","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-06-29T10:17:04.000000Z","updated_at":"2025-06-30T10:18:54.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":14769314,"change_date":"2025-06-26 21:42:00","inspection_id":"85064829","insp_unit_id":"207593058","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"25880D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN1LEC31615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:29.000000Z","updated_at":"2025-07-01T09:48:52.000000Z"}]},{"id":7985391,"change_date":"2025-02-27 21:42:00","inspection_id":"83988347","dot_number":"2682568","report_state":"CA","report_number":"UEGX001399","insp_date":"2025-02-27 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I680 NB WALNUT CRK PLTFM SCALE","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"15720411","transaction_code":"A","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2025-02-27 21:42:00","snet_input_date":"2025-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-27 21:42:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"397006","created_at":"2025-03-17T21:04:03.000000Z","updated_at":"2025-03-17T21:04:03.000000Z","inspection_violations":[{"id":12477742,"change_date":"2025-02-27 21:42:00","inspection_id":"83988347","insp_violation_id":"264749860","seq_no":"1","part_no":"177","part_no_section":"834A-HMC","insp_viol_unit":"1","insp_unit_id":"205547940","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"177834AHMC"},{"id":12477743,"change_date":"2025-02-27 21:42:00","inspection_id":"83988347","insp_violation_id":"264749861","seq_no":"2","part_no":"393","part_no_section":"110B1-C","insp_viol_unit":"1","insp_unit_id":"205547940","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"393110B1C"},{"id":12477744,"change_date":"2025-02-27 21:42:00","inspection_id":"83988347","insp_violation_id":"264749862","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"205547940","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"3939ALIL"},{"id":12477745,"change_date":"2025-02-27 21:42:00","inspection_id":"83988347","insp_violation_id":"264749863","seq_no":"4","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"205547940","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"39311A1LLPL"},{"id":12477746,"change_date":"2025-02-27 21:42:00","inspection_id":"83988347","insp_violation_id":"264749864","seq_no":"5","part_no":"393","part_no_section":"110B1-C","insp_viol_unit":"1","insp_unit_id":"205547940","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"393110B1C"}],"inspection_per_units":[{"id":12891325,"change_date":"2025-02-27 21:42:00","inspection_id":"83988347","insp_unit_id":"205547940","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"19962N2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GY4HEF49553","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:24.000000Z","updated_at":"2025-03-17T23:57:24.000000Z"}]},{"id":7958504,"change_date":"2025-02-25 21:40:00","inspection_id":"83960151","dot_number":"2682568","report_state":"CA","report_number":"NCNG008730","insp_date":"2025-02-12 00:00:00","insp_start_time":"0805","insp_end_time":"0835","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":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"15717012","transaction_code":"A","transaction_date":"2025-02-12 00:00:00","upload_date":"2025-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2025-02-25 21:40:00","snet_input_date":"2025-02-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-25 21:40:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"397006","created_at":"2025-03-17T21:03:19.000000Z","updated_at":"2025-03-17T21:03:19.000000Z","inspection_violations":[{"id":12436835,"change_date":"2025-02-25 21:40:00","inspection_id":"83960151","insp_violation_id":"264696118","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"1","insp_unit_id":"205494839","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"3922SLLED"}],"inspection_per_units":[{"id":12847329,"change_date":"2025-02-25 21:40:00","inspection_id":"83960151","insp_unit_id":"205494839","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"61728L1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GY0EEA17177","insp_unit_decal":"Y","insp_unit_decal_number":"34773721","created_at":"2025-03-17T23:56:55.000000Z","updated_at":"2025-03-17T23:56:55.000000Z"}]},{"id":6550497,"change_date":"2024-08-23 21:41:00","inspection_id":"82472378","dot_number":"2682568","report_state":"CA","report_number":"UEGX000761","insp_date":"2024-08-23 00:00:00","insp_start_time":"0840","insp_end_time":"0910","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CRK PLTFM SCALES","county_code_state":"CA","county_code":"013","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-08-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15494987","transaction_code":"A","transaction_date":"2024-08-23 00:00:00","upload_date":"2024-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2024-08-23 21:41:00","snet_input_date":"2024-08-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-23 21:41:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"397006","created_at":"2025-03-17T20:32:48.000000Z","updated_at":"2025-03-17T20:32:48.000000Z","inspection_violations":[{"id":10178522,"change_date":"2024-08-23 21:41:00","inspection_id":"82472378","insp_violation_id":"261381344","seq_no":"1","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"1","insp_unit_id":"202560300","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"393110B"},{"id":10178523,"change_date":"2024-08-23 21:41:00","inspection_id":"82472378","insp_violation_id":"261381345","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202560300","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"39395A"},{"id":10178524,"change_date":"2024-08-23 21:41:00","inspection_id":"82472378","insp_violation_id":"261381346","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202560300","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"3939A"},{"id":10178525,"change_date":"2024-08-23 21:41:00","inspection_id":"82472378","insp_violation_id":"261381347","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202560300","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"3939A"},{"id":10178526,"change_date":"2024-08-23 21:41:00","inspection_id":"82472378","insp_violation_id":"261381348","seq_no":"5","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"202560300","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW891149","created_at":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"39021TA"},{"id":10178527,"change_date":"2024-08-23 21:41:00","inspection_id":"82472378","insp_violation_id":"261381349","seq_no":"6","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"1","insp_unit_id":"202560300","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW891149","created_at":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"3929A1"},{"id":10178528,"change_date":"2024-08-23 21:41:00","inspection_id":"82472378","insp_violation_id":"261381350","seq_no":"7","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"202560300","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":10559995,"change_date":"2024-08-23 21:41:00","inspection_id":"82472378","insp_unit_id":"202560300","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"48082L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN3NED06317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:22.000000Z","updated_at":"2025-03-17T23:32:22.000000Z"}]},{"id":6264875,"change_date":"2024-07-19 21:38:00","inspection_id":"82167159","dot_number":"2682568","report_state":"CA","report_number":"UFUE000473","insp_date":"2024-07-19 00:00:00","insp_start_time":"0650","insp_end_time":"0703","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"WB I-580 AT FIRST ST","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15449494","transaction_code":"A","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2024-07-19 21:38:00","snet_input_date":"2024-07-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-19 21:38:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"397006","created_at":"2025-03-17T20:26:59.000000Z","updated_at":"2025-03-17T20:26:59.000000Z","inspection_violations":[{"id":9731630,"change_date":"2024-07-19 21:38:00","inspection_id":"82167159","insp_violation_id":"260747324","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"201979808","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ61283","created_at":"2025-03-17T21:53:05.000000Z","updated_at":"2025-03-17T21:53:05.000000Z","normalized_code":"39021TA"},{"id":9731631,"change_date":"2024-07-19 21:38:00","inspection_id":"82167159","insp_violation_id":"260747325","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201979808","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ61283","created_at":"2025-03-17T21:53:05.000000Z","updated_at":"2025-03-17T21:53:05.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":10093687,"change_date":"2024-07-19 21:38:00","inspection_id":"82167159","insp_unit_id":"201979808","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X WHI\/BLK","insp_unit_license":"25880D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN1LEC31615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:35.000000Z","updated_at":"2025-03-17T23:27:35.000000Z"}]},{"id":6264752,"change_date":"2024-07-19 21:38:00","inspection_id":"82167034","dot_number":"2682568","report_state":"CA","report_number":"UCU1000224","insp_date":"2024-07-17 00:00:00","insp_start_time":"1535","insp_end_time":"1615","registration_date":null,"region":"ET","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":"2024-07-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"15448964","transaction_code":"A","transaction_date":"2024-07-18 00:00:00","upload_date":"2024-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2024-07-19 21:38:00","snet_input_date":"2024-07-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-19 21:38:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:59.000000Z","updated_at":"2025-03-17T20:26:59.000000Z","inspection_violations":[{"id":9731538,"change_date":"2024-07-19 21:38:00","inspection_id":"82167034","insp_violation_id":"260747221","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"201979619","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA519693","created_at":"2025-03-17T21:53:05.000000Z","updated_at":"2025-03-17T21:53:05.000000Z","normalized_code":"39021TA"},{"id":9731539,"change_date":"2024-07-19 21:38:00","inspection_id":"82167034","insp_violation_id":"260747222","seq_no":"2","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"201979619","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:05.000000Z","updated_at":"2025-03-17T21:53:05.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":10093508,"change_date":"2024-07-19 21:38:00","inspection_id":"82167034","insp_unit_id":"201979619","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X WHT","insp_unit_license":"48082L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN3NED06317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:35.000000Z","updated_at":"2025-03-17T23:27:35.000000Z"}]},{"id":5554819,"change_date":"2024-04-19 21:39:00","inspection_id":"81398768","dot_number":"2682568","report_state":"CA","report_number":"NDMK005168","insp_date":"2024-04-18 00:00:00","insp_start_time":"0805","insp_end_time":"0824","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":"2024-04-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"15325706","transaction_code":"A","transaction_date":"2024-04-18 00:00:00","upload_date":"2024-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2024-04-19 21:39:00","snet_input_date":"2024-04-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-19 21:39:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:47.000000Z","updated_at":"2025-03-17T20:12:47.000000Z","inspection_violations":[{"id":8584815,"change_date":"2024-04-19 21:39:00","inspection_id":"81398768","insp_violation_id":"259036257","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"200488205","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA589708","created_at":"2025-03-17T21:47:36.000000Z","updated_at":"2025-03-17T21:47:36.000000Z","normalized_code":"39021TA"},{"id":8584816,"change_date":"2024-04-19 21:39:00","inspection_id":"81398768","insp_violation_id":"259036258","seq_no":"2","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"200488205","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:36.000000Z","updated_at":"2025-03-17T21:47:36.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":8947376,"change_date":"2024-04-19 21:39:00","inspection_id":"81398768","insp_unit_id":"200488205","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"48082L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN3NED06317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:15.000000Z","updated_at":"2025-03-17T23:16:15.000000Z"}]},{"id":5465049,"change_date":"2024-04-08 21:45:00","inspection_id":"81300495","dot_number":"2682568","report_state":"CA","report_number":"UEX8003691","insp_date":"2024-04-05 00:00:00","insp_start_time":"1500","insp_end_time":"1526","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE SCALE","county_code_state":"CA","county_code":"005","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-08 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"15309734","transaction_code":"A","transaction_date":"2024-04-05 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2024-04-08 21:45:00","snet_input_date":"2024-04-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-08 21:45:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"397006","created_at":"2025-03-17T20:11:08.000000Z","updated_at":"2025-03-17T20:11:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8802888,"change_date":"2024-04-08 21:45:00","inspection_id":"81300495","insp_unit_id":"200298553","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"61728L1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GY0EEA17177","insp_unit_decal":"Y","insp_unit_decal_number":"33812255","created_at":"2025-03-17T23:14:52.000000Z","updated_at":"2025-03-17T23:14:52.000000Z"}]},{"id":5237319,"change_date":"2024-03-07 21:39:00","inspection_id":"81052360","dot_number":"2682568","report_state":"CA","report_number":"NC7K008348","insp_date":"2024-03-05 00:00:00","insp_start_time":"1040","insp_end_time":"1115","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":"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":"2024-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15272161","transaction_code":"A","transaction_date":"2024-03-05 00:00:00","upload_date":"2024-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2024-03-07 21:39:00","snet_input_date":"2024-03-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-07 21:39:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:15.000000Z","updated_at":"2025-03-17T20:06:15.000000Z","inspection_violations":[{"id":8075236,"change_date":"2024-03-07 21:39:00","inspection_id":"81052360","insp_violation_id":"258268905","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"199810880","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"39021TA"},{"id":8075237,"change_date":"2024-03-07 21:39:00","inspection_id":"81052360","insp_violation_id":"258268906","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199810880","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3939A"},{"id":8075238,"change_date":"2024-03-07 21:39:00","inspection_id":"81052360","insp_violation_id":"258268907","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199810880","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3939A"},{"id":8075239,"change_date":"2024-03-07 21:39:00","inspection_id":"81052360","insp_violation_id":"258268908","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199810880","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3939A"},{"id":8075240,"change_date":"2024-03-07 21:39:00","inspection_id":"81052360","insp_violation_id":"258268909","seq_no":"5","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"199810880","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3929A2"},{"id":8075241,"change_date":"2024-03-07 21:39:00","inspection_id":"81052360","insp_violation_id":"258268910","seq_no":"6","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"199810880","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":8433542,"change_date":"2024-03-07 21:39:00","inspection_id":"81052360","insp_unit_id":"199810880","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT 2X","insp_unit_license":"48082L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN3NED06317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:24.000000Z","updated_at":"2025-03-17T23:11:24.000000Z"}]},{"id":5184995,"change_date":"2024-02-29 21:48:00","inspection_id":"80994939","dot_number":"2682568","report_state":"CA","report_number":"UDM7002969","insp_date":"2024-02-29 00:00:00","insp_start_time":"0805","insp_end_time":"0827","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I-680 NB K PLATFORM 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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"15264065","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2024-02-29 21:48:00","snet_input_date":"2024-02-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-29 21:48:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"397006","created_at":"2025-03-17T20:05:20.000000Z","updated_at":"2025-03-17T20:05:20.000000Z","inspection_violations":[{"id":7991000,"change_date":"2024-02-29 21:48:00","inspection_id":"80994939","insp_violation_id":"258143191","seq_no":"1","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"199701024","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW891323","created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"39375A1"}],"inspection_per_units":[{"id":8348495,"change_date":"2024-02-29 21:48:00","inspection_id":"80994939","insp_unit_id":"199701024","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"19962N2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GY4HEF49553","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:38.000000Z","updated_at":"2025-03-17T23:10:38.000000Z"}]},{"id":4829287,"change_date":"2024-01-12 21:44:00","inspection_id":"80606520","dot_number":"2682568","report_state":"CA","report_number":"UFJ5000558","insp_date":"2024-01-12 00:00:00","insp_start_time":"0819","insp_end_time":"0840","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"N\/B 680 WC SCALES","county_code_state":"CA","county_code":"013","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":"2024-01-12 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15198725","transaction_code":"A","transaction_date":"2024-01-12 00:00:00","upload_date":"2024-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2024-01-12 21:44:00","snet_input_date":"2024-01-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-12 21:44:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"397006","created_at":"2025-03-17T19:58:26.000000Z","updated_at":"2025-03-17T19:58:26.000000Z","inspection_violations":[{"id":7446303,"change_date":"2024-01-12 21:44:00","inspection_id":"80606520","insp_violation_id":"257331696","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MN69716","created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"3922"},{"id":7446304,"change_date":"2024-01-12 21:44:00","inspection_id":"80606520","insp_violation_id":"257331697","seq_no":"2","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"198953035","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"39021TA"},{"id":7446305,"change_date":"2024-01-12 21:44:00","inspection_id":"80606520","insp_violation_id":"257331698","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198953035","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"3922"},{"id":7446306,"change_date":"2024-01-12 21:44:00","inspection_id":"80606520","insp_violation_id":"257331699","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198953035","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":7769682,"change_date":"2024-01-12 21:44:00","inspection_id":"80606520","insp_unit_id":"198953035","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"25880D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN1LEC31615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:25.000000Z","updated_at":"2025-03-17T23:05:25.000000Z"}]},{"id":3782109,"change_date":"2023-08-18 21:42:00","inspection_id":"79449863","dot_number":"2682568","report_state":"CA","report_number":"NC7K007649","insp_date":"2023-08-16 00:00:00","insp_start_time":"1510","insp_end_time":"1535","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":"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":"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":"15027484","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2023-08-18 21:42:00","snet_input_date":"2023-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-18 21:42:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:39.000000Z","updated_at":"2025-03-17T19:37:39.000000Z","inspection_violations":[{"id":5834497,"change_date":"2023-08-18 21:42:00","inspection_id":"79449863","insp_violation_id":"254753940","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196619862","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"3922"},{"id":5834498,"change_date":"2023-08-18 21:42:00","inspection_id":"79449863","insp_violation_id":"254753941","seq_no":"2","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"196619862","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39021TA"},{"id":5834499,"change_date":"2023-08-18 21:42:00","inspection_id":"79449863","insp_violation_id":"254753942","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196619862","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":6081260,"change_date":"2023-08-18 21:42:00","inspection_id":"79449863","insp_unit_id":"196619862","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT 2X","insp_unit_license":"48129G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN1LDA14670","insp_unit_decal":"Y","insp_unit_decal_number":"32851979","created_at":"2025-03-17T22:51:06.000000Z","updated_at":"2025-03-17T22:51:06.000000Z"}]},{"id":3727869,"change_date":"2023-08-11 21:39:00","inspection_id":"79389463","dot_number":"2682568","report_state":"CA","report_number":"NC7K007599","insp_date":"2023-08-08 00:00:00","insp_start_time":"1543","insp_end_time":"1605","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":"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-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"15016968","transaction_code":"A","transaction_date":"2023-08-08 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:29.000000Z","updated_at":"2025-03-17T19:36:29.000000Z","inspection_violations":[{"id":5749740,"change_date":"2023-08-11 21:39:00","inspection_id":"79389463","insp_violation_id":"254617695","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196498147","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3922"},{"id":5749741,"change_date":"2023-08-11 21:39:00","inspection_id":"79389463","insp_violation_id":"254617696","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"196498147","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39021TB"},{"id":5749742,"change_date":"2023-08-11 21:39:00","inspection_id":"79389463","insp_violation_id":"254617697","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196498147","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5993940,"change_date":"2023-08-11 21:39:00","inspection_id":"79389463","insp_unit_id":"196498147","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT 2X","insp_unit_license":"61728L1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GY0EEA17177","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:21.000000Z","updated_at":"2025-03-17T22:50:21.000000Z"}]},{"id":3217233,"change_date":"2023-06-05 21:43:00","inspection_id":"78815783","dot_number":"2682568","report_state":"CA","report_number":"UF44003922","insp_date":"2023-06-02 00:00:00","insp_start_time":"1409","insp_end_time":"1421","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB NO MISSION GRADE CVEF","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14930338","transaction_code":"A","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2023-06-05 21:43:00","snet_input_date":"2023-06-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-05 21:43:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"397006","created_at":"2025-03-17T19:26:31.000000Z","updated_at":"2025-03-17T19:26:31.000000Z","inspection_violations":[{"id":4957422,"change_date":"2023-06-05 21:43:00","inspection_id":"78815783","insp_violation_id":"253306253","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MA56201","created_at":"2025-03-17T21:30:03.000000Z","updated_at":"2025-03-17T21:30:03.000000Z","normalized_code":"3922"},{"id":4957423,"change_date":"2023-06-05 21:43:00","inspection_id":"78815783","insp_violation_id":"253306254","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195334350","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MA56202","created_at":"2025-03-17T21:30:03.000000Z","updated_at":"2025-03-17T21:30:03.000000Z","normalized_code":"3922"},{"id":4957424,"change_date":"2023-06-05 21:43:00","inspection_id":"78815783","insp_violation_id":"253306255","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"195334350","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MA56202","created_at":"2025-03-17T21:30:03.000000Z","updated_at":"2025-03-17T21:30:03.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":5174202,"change_date":"2023-06-05 21:43:00","inspection_id":"78815783","insp_unit_id":"195334350","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X WHT","insp_unit_license":"61728L1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GY0EEA17177","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:46.000000Z","updated_at":"2025-03-17T22:43:46.000000Z"}]},{"id":1106981,"change_date":"2022-08-22 21:43:00","inspection_id":"76402398","dot_number":"2682568","report_state":"CA","report_number":"UDM7001818","insp_date":"2022-08-22 00:00:00","insp_start_time":"0805","insp_end_time":"0840","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I-680 NB K PLATFORM 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":"Y","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":"16500","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14559985","transaction_code":"A","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02682568","upload_search_indicator":null,"census_search_date":"2022-08-22 21:43:00","snet_input_date":"2022-08-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-22 21:43:00","insp_carrier_name":"A QUALITY PLUMBING & ELECTRIC INC","insp_carrier_street":"2261 RESEARCH DR","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94550","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"397006","created_at":"2025-03-17T18:47:13.000000Z","updated_at":"2025-03-17T18:47:13.000000Z","inspection_violations":[{"id":1744358,"change_date":"2022-08-22 21:43:00","inspection_id":"76402398","insp_violation_id":"247908157","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"190475473","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"39395F"},{"id":1744359,"change_date":"2022-08-22 21:43:00","inspection_id":"76402398","insp_violation_id":"247908158","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190475473","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CW890218","created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"39311"},{"id":1744360,"change_date":"2022-08-22 21:43:00","inspection_id":"76402398","insp_violation_id":"247908159","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190475473","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"39311"},{"id":1744361,"change_date":"2022-08-22 21:43:00","inspection_id":"76402398","insp_violation_id":"247908160","seq_no":"4","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"1","insp_unit_id":"190475473","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"3929A1"},{"id":1744362,"change_date":"2022-08-22 21:43:00","inspection_id":"76402398","insp_violation_id":"247908161","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190475473","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW890218","created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1780795,"change_date":"2022-08-22 21:43:00","inspection_id":"76402398","insp_unit_id":"190475473","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"48082L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GN3NED06317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:15.000000Z","updated_at":"2025-03-17T22:19:15.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2682568\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2682568\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2682568\/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\/2682568\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}