{"current_page":1,"data":[{"id":10442467,"change_date":"2025-12-15 21:40:00","inspection_id":"86574628","dot_number":"2607022","report_state":"CA","report_number":"NE5C001897","insp_date":"2025-12-12 00:00:00","insp_start_time":"1025","insp_end_time":"1102","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-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"16095680","transaction_code":"A","transaction_date":"2025-12-12 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2025-12-15 21:40:00","snet_input_date":"2025-12-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-15 21:40:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-12-18T10:30:49.000000Z","updated_at":"2025-12-26T10:31:23.000000Z","inspection_violations":[{"id":18490297,"change_date":null,"inspection_id":"86574628","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":18674305,"change_date":null,"inspection_id":"86574628","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"40246L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF5GT1NED54712","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10346410,"change_date":"2025-12-04 21:38:00","inspection_id":"86474083","dot_number":"2607022","report_state":"CA","report_number":"UEGX002302","insp_date":"2025-12-03 00:00:00","insp_start_time":"0740","insp_end_time":"0810","registration_date":null,"region":"PT","ci_status_code":"C","location":"365","location_desc":"I-80 E\/B JEO CORDELIA SCALES","county_code_state":"CA","county_code":"095","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":"2025-12-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16081089","transaction_code":"C","transaction_date":"2025-12-03 00:00:00","upload_date":"2025-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2025-12-03 21:39:00","snet_input_date":"2025-12-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-03 21:39:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-12-06T10:31:40.000000Z","updated_at":"2025-12-08T10:30:57.000000Z","inspection_violations":[{"id":18489074,"change_date":null,"inspection_id":"86474083","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":18673356,"change_date":null,"inspection_id":"86474083","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"26428F2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0W4GT6HEC25166","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8124387,"change_date":"2025-03-14 21:41:00","inspection_id":"84134595","dot_number":"2607022","report_state":"CA","report_number":"UE03003899","insp_date":"2025-03-13 00:00:00","insp_start_time":"0603","insp_end_time":"0630","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"LIVERMORE","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":"2025-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15740409","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2025-03-14 21:41:00","snet_input_date":"2025-03-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-14 21:41:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:07:04.000000Z","updated_at":"2025-03-17T21:07:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13117636,"change_date":"2025-03-14 21:41:00","inspection_id":"84134595","insp_unit_id":"205817211","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3AX RED","insp_unit_license":"43677Y3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKDLP9X0EJ411142","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-18T00:00:01.000000Z","updated_at":"2025-03-18T00:00:01.000000Z"}]},{"id":8113869,"change_date":"2025-03-13 21:44:00","inspection_id":"84123504","dot_number":"2607022","report_state":"CA","report_number":"UE03003891","insp_date":"2025-03-12 00:00:00","insp_start_time":"0730","insp_end_time":"0747","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"LIVERMORE","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":"2025-03-13 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"15738929","transaction_code":"A","transaction_date":"2025-03-12 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2025-03-13 21:44:00","snet_input_date":"2025-03-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-13 21:44:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:53.000000Z","updated_at":"2025-03-17T21:06:53.000000Z","inspection_violations":[{"id":12687154,"change_date":"2025-03-13 21:44:00","inspection_id":"84123504","insp_violation_id":"265033557","seq_no":"1","part_no":"393","part_no_section":"11A1-LCL","insp_viol_unit":"1","insp_unit_id":"205796366","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA513679","created_at":"2025-03-17T22:08:09.000000Z","updated_at":"2025-03-17T22:08:09.000000Z","normalized_code":"39311A1LCL"}],"inspection_per_units":[{"id":13100575,"change_date":"2025-03-13 21:44:00","inspection_id":"84123504","insp_unit_id":"205796366","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3AX RED","insp_unit_license":"43677Y3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKDLP9X0EJ411142","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:51.000000Z","updated_at":"2025-03-17T23:59:51.000000Z"},{"id":13100576,"change_date":"2025-03-13 21:44:00","inspection_id":"84123504","insp_unit_id":"205796367","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RELI","insp_unit_company":"2AX","insp_unit_license":"4BL6360","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1REFA5207PC931277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:51.000000Z","updated_at":"2025-03-17T23:59:51.000000Z"}]},{"id":7341169,"change_date":"2024-12-04 21:42:00","inspection_id":"83311844","dot_number":"2607022","report_state":"CA","report_number":"NDCK002400","insp_date":"2024-12-02 00:00:00","insp_start_time":"1132","insp_end_time":"1241","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"5","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-12-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"15617250","transaction_code":"A","transaction_date":"2024-12-02 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2024-12-04 21:42:00","snet_input_date":"2024-12-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-04 21:42:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11842324,"change_date":"2024-12-04 21:42:00","inspection_id":"83311844","insp_unit_id":"204192420","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9F04727","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKDL40X5DJ349196","insp_unit_decal":"Y","insp_unit_decal_number":"34471251","created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"}]},{"id":7341430,"change_date":"2024-12-04 21:42:00","inspection_id":"83312112","dot_number":"2607022","report_state":"CA","report_number":"NDCK002397","insp_date":"2024-12-02 00:00:00","insp_start_time":"0722","insp_end_time":"0814","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"5","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-12-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15617247","transaction_code":"A","transaction_date":"2024-12-02 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2024-12-04 21:42:00","snet_input_date":"2024-12-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-04 21:42:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11842668,"change_date":"2024-12-04 21:42:00","inspection_id":"83312112","insp_unit_id":"204192792","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1187","insp_unit_license":"10723Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X1CM311187","insp_unit_decal":"Y","insp_unit_decal_number":"34471252","created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"}]},{"id":7341431,"change_date":"2024-12-04 21:42:00","inspection_id":"83312113","dot_number":"2607022","report_state":"CA","report_number":"NDCK002398","insp_date":"2024-12-02 00:00:00","insp_start_time":"0822","insp_end_time":"0904","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"5","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-12-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15617248","transaction_code":"A","transaction_date":"2024-12-02 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2024-12-04 21:42:00","snet_input_date":"2024-12-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-04 21:42:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11842669,"change_date":"2024-12-04 21:42:00","inspection_id":"83312113","insp_unit_id":"204192793","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"40248L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X5GT2NED54715","insp_unit_decal":"Y","insp_unit_decal_number":"34471253","created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"}]},{"id":7341432,"change_date":"2024-12-04 21:42:00","inspection_id":"83312114","dot_number":"2607022","report_state":"CA","report_number":"NDCK002399","insp_date":"2024-12-02 00:00:00","insp_start_time":"0920","insp_end_time":"1018","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"5","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-12-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"15617249","transaction_code":"A","transaction_date":"2024-12-02 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2024-12-04 21:42:00","snet_input_date":"2024-12-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-04 21:42:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11842670,"change_date":"2024-12-04 21:42:00","inspection_id":"83312114","insp_unit_id":"204192794","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"9195","insp_unit_license":"41644M1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKDL40X3DJ349195","insp_unit_decal":"Y","insp_unit_decal_number":"34471250","created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"}]},{"id":7407757,"change_date":"2024-12-12 21:42:00","inspection_id":"83381833","dot_number":"2607022","report_state":"CA","report_number":"NDCK002401","insp_date":"2024-12-02 00:00:00","insp_start_time":"1253","insp_end_time":"1333","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"5","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-12-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"15626446","transaction_code":"A","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2024-12-12 21:42:00","snet_input_date":"2024-12-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-12 21:42:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T20:50:45.000000Z","updated_at":"2025-03-17T20:50:45.000000Z","inspection_violations":[{"id":11574963,"change_date":"2024-12-12 21:42:00","inspection_id":"83381833","insp_violation_id":"263437747","seq_no":"1","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"1","insp_unit_id":"204361389","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"39345B2B"}],"inspection_per_units":[{"id":11950232,"change_date":"2024-12-12 21:42:00","inspection_id":"83381833","insp_unit_id":"204361389","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"FELLI","insp_unit_company":"FT75","insp_unit_license":"4HN3010","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FTTA382881029680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:57.000000Z","updated_at":"2025-03-17T23:46:57.000000Z"}]},{"id":5900883,"change_date":"2024-06-03 21:43:00","inspection_id":"81774745","dot_number":"2607022","report_state":"CA","report_number":"NEYV000602","insp_date":"2024-05-30 00:00:00","insp_start_time":"1140","insp_end_time":"1212","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-03 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"15386397","transaction_code":"A","transaction_date":"2024-05-30 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2024-06-03 21:43:00","snet_input_date":"2024-05-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-03 21:43:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:47.000000Z","updated_at":"2025-03-17T20:19:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9504363,"change_date":"2024-06-03 21:43:00","inspection_id":"81774745","insp_unit_id":"201208539","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X \/ WHT","insp_unit_license":"59623R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPVL79X0CD164408","insp_unit_decal":"Y","insp_unit_decal_number":"33812594","created_at":"2025-03-17T23:21:35.000000Z","updated_at":"2025-03-17T23:21:35.000000Z"}]},{"id":5648760,"change_date":"2024-05-01 21:43:00","inspection_id":"81501093","dot_number":"2607022","report_state":"CA","report_number":"NEYV000496","insp_date":"2024-04-30 00:00:00","insp_start_time":"1620","insp_end_time":"1650","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15343800","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2024-05-01 21:43:00","snet_input_date":"2024-04-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-01 21:43:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:42.000000Z","updated_at":"2025-03-17T20:14:42.000000Z","inspection_violations":[{"id":8737252,"change_date":"2024-05-01 21:43:00","inspection_id":"81501093","insp_violation_id":"259264880","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200683049","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"39395A"},{"id":8737253,"change_date":"2024-05-01 21:43:00","inspection_id":"81501093","insp_violation_id":"259264881","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200683049","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"39311"},{"id":8737254,"change_date":"2024-05-01 21:43:00","inspection_id":"81501093","insp_violation_id":"259264882","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200683049","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"3963A1"},{"id":8737255,"change_date":"2024-05-01 21:43:00","inspection_id":"81501093","insp_violation_id":"259264883","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"200683049","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":9098511,"change_date":"2024-05-01 21:43:00","inspection_id":"81501093","insp_unit_id":"200683049","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X \/ WHT","insp_unit_license":"59623R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPVL79X0CD164408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:39.000000Z","updated_at":"2025-03-17T23:17:39.000000Z"}]},{"id":5601775,"change_date":"2024-04-25 21:43:00","inspection_id":"81449873","dot_number":"2607022","report_state":"CA","report_number":"UCU1000061","insp_date":"2024-04-23 00:00:00","insp_start_time":"1530","insp_end_time":"1558","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":"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-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"15334676","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2024-04-25 21:43:00","snet_input_date":"2024-04-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:50.000000Z","updated_at":"2025-03-17T20:13:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9023240,"change_date":"2024-04-25 21:43:00","inspection_id":"81449873","insp_unit_id":"200585961","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X WHI","insp_unit_license":"59623R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPVL79X0CD164408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:57.000000Z","updated_at":"2025-03-17T23:16:57.000000Z"}]},{"id":4250332,"change_date":"2023-10-20 21:41:00","inspection_id":"79970101","dot_number":"2607022","report_state":"CA","report_number":"UFJ5000524","insp_date":"2023-10-20 00:00:00","insp_start_time":"0724","insp_end_time":"0735","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":"2023-10-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15105484","transaction_code":"A","transaction_date":"2023-10-20 00:00:00","upload_date":"2023-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2023-10-20 21:41:00","snet_input_date":"2023-10-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-20 21:41:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T19:47:04.000000Z","updated_at":"2025-03-17T19:47:04.000000Z","inspection_violations":[{"id":6581581,"change_date":"2023-10-20 21:41:00","inspection_id":"79970101","insp_violation_id":"255970772","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":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3922"},{"id":6581582,"change_date":"2023-10-20 21:41:00","inspection_id":"79970101","insp_violation_id":"255970773","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197673674","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6835295,"change_date":"2023-10-20 21:41:00","inspection_id":"79970101","insp_unit_id":"197673674","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"40246L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF5GT1NED54712","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:19.000000Z","updated_at":"2025-03-17T22:57:19.000000Z"}]},{"id":3494950,"change_date":"2023-07-12 21:42:00","inspection_id":"79128541","dot_number":"2607022","report_state":"CA","report_number":"UF44004110","insp_date":"2023-07-11 00:00:00","insp_start_time":"1614","insp_end_time":"1622","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-07-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14978240","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2023-07-12 21:42:00","snet_input_date":"2023-07-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-12 21:42:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T19:32:06.000000Z","updated_at":"2025-03-17T19:32:06.000000Z","inspection_violations":[{"id":5389644,"change_date":"2023-07-12 21:42:00","inspection_id":"79128541","insp_violation_id":"254028486","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":"MA58617","created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5619768,"change_date":"2023-07-12 21:42:00","inspection_id":"79128541","insp_unit_id":"195969234","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"45597X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X5GT9LEC42684","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:21.000000Z","updated_at":"2025-03-17T22:47:21.000000Z"}]},{"id":3493622,"change_date":"2023-07-12 21:41:00","inspection_id":"79127123","dot_number":"2607022","report_state":"CA","report_number":"NCEB005735","insp_date":"2023-07-07 00:00:00","insp_start_time":"1807","insp_end_time":"1826","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":"2023-07-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"14975939","transaction_code":"A","transaction_date":"2023-07-07 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2023-07-12 21:41:00","snet_input_date":"2023-07-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-12 21:41:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:06.000000Z","updated_at":"2025-03-17T19:32:06.000000Z","inspection_violations":[{"id":5388492,"change_date":"2023-07-12 21:41:00","inspection_id":"79127123","insp_violation_id":"254027101","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195967097","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":5617860,"change_date":"2023-07-12 21:41:00","inspection_id":"79127123","insp_unit_id":"195967097","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"7785 WHITE","insp_unit_license":"53742T2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL70X9KJ367785","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:20.000000Z","updated_at":"2025-03-17T22:47:20.000000Z"}]},{"id":3347809,"change_date":"2023-06-22 21:43:00","inspection_id":"78963125","dot_number":"2607022","report_state":"CA","report_number":"NC7K007435","insp_date":"2023-06-21 00:00:00","insp_start_time":"1245","insp_end_time":"1305","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-22 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":"14955581","transaction_code":"A","transaction_date":"2023-06-21 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2023-06-22 21:43:00","snet_input_date":"2023-06-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-22 21:43:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:21.000000Z","updated_at":"2025-03-17T19:29:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5381982,"change_date":"2023-06-22 21:43:00","inspection_id":"78963125","insp_unit_id":"195636820","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHT 2X","insp_unit_license":"28105H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HM6XXFM265963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:27.000000Z","updated_at":"2025-03-17T22:45:27.000000Z"}]},{"id":3124519,"change_date":"2023-05-23 21:43:00","inspection_id":"78711091","dot_number":"2607022","report_state":"CA","report_number":"NCPN004097","insp_date":"2023-05-18 00:00:00","insp_start_time":"1801","insp_end_time":"1814","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":"2023-05-23 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":"14912992","transaction_code":"A","transaction_date":"2023-05-18 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2023-05-23 21:43:00","snet_input_date":"2023-05-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-23 21:43:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T19:24:56.000000Z","updated_at":"2025-03-17T19:24:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5025762,"change_date":"2023-05-23 21:43:00","inspection_id":"78711091","insp_unit_id":"195106547","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHT","insp_unit_license":"89854U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HM6X7LM675535","insp_unit_decal":"Y","insp_unit_decal_number":"32548543","created_at":"2025-03-17T22:42:38.000000Z","updated_at":"2025-03-17T22:42:38.000000Z"}]},{"id":3060463,"change_date":"2023-05-16 21:43:00","inspection_id":"78638846","dot_number":"2607022","report_state":"CA","report_number":"UDLV002516","insp_date":"2023-05-16 00:00:00","insp_start_time":"0545","insp_end_time":"0617","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"14904035","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2023-05-16 21:43:00","snet_input_date":"2023-05-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-16 21:43:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T19:23:43.000000Z","updated_at":"2025-03-17T19:23:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4923806,"change_date":"2023-05-16 21:43:00","inspection_id":"78638846","insp_unit_id":"194967030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"59623R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPVL79X0CD164408","insp_unit_decal":"Y","insp_unit_decal_number":"32477666","created_at":"2025-03-17T22:41:48.000000Z","updated_at":"2025-03-17T22:41:48.000000Z"}]},{"id":3057410,"change_date":"2023-05-16 21:43:00","inspection_id":"78635541","dot_number":"2607022","report_state":"CA","report_number":"NC7K007281","insp_date":"2023-05-10 00:00:00","insp_start_time":"1402","insp_end_time":"1437","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-16 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":"14900760","transaction_code":"A","transaction_date":"2023-05-10 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2023-05-16 21:43:00","snet_input_date":"2023-05-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-16 21:43:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:26.000000Z","updated_at":"2025-03-17T19:23:26.000000Z","inspection_violations":[{"id":4698819,"change_date":"2023-05-16 21:43:00","inspection_id":"78635541","insp_violation_id":"252868327","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"194961500","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"39021TA"},{"id":4698820,"change_date":"2023-05-16 21:43:00","inspection_id":"78635541","insp_violation_id":"252868328","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"194961500","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":4918845,"change_date":"2023-05-16 21:43:00","inspection_id":"78635541","insp_unit_id":"194961500","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHT 2X","insp_unit_license":"28105H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HM6XXFM265963","insp_unit_decal":"Y","insp_unit_decal_number":"32468000","created_at":"2025-03-17T22:41:46.000000Z","updated_at":"2025-03-17T22:41:46.000000Z"}]},{"id":2485607,"change_date":"2023-03-01 21:42:00","inspection_id":"77986526","dot_number":"2607022","report_state":"CA","report_number":"N9ZT004273","insp_date":"2023-02-17 00:00:00","insp_start_time":"1330","insp_end_time":"1400","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"LIVERMORE, CA","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-03-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"14802992","transaction_code":"A","transaction_date":"2023-02-17 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2023-03-01 21:42:00","snet_input_date":"2023-02-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-01 21:42:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:30.000000Z","updated_at":"2025-03-17T19:12:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4000094,"change_date":"2023-03-01 21:42:00","inspection_id":"77986526","insp_unit_id":"193661035","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"53742T2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL70X9KJ367785","insp_unit_decal":"Y","insp_unit_decal_number":"32141674","created_at":"2025-03-17T22:34:40.000000Z","updated_at":"2025-03-17T22:34:40.000000Z"}]},{"id":1991228,"change_date":"2022-12-20 21:41:00","inspection_id":"77422078","dot_number":"2607022","report_state":"CA","report_number":"UF44003323","insp_date":"2022-12-19 00:00:00","insp_start_time":"0718","insp_end_time":"0754","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 SB JNO WASHINGTON","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14714962","transaction_code":"A","transaction_date":"2022-12-19 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2022-12-20 21:41:00","snet_input_date":"2022-12-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-20 21:41:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T19:03:20.000000Z","updated_at":"2025-03-17T19:03:20.000000Z","inspection_violations":[{"id":3091548,"change_date":"2022-12-20 21:41:00","inspection_id":"77422078","insp_violation_id":"250209028","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192527319","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CK018618","created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"3922"},{"id":3091549,"change_date":"2022-12-20 21:41:00","inspection_id":"77422078","insp_violation_id":"250209029","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192527319","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CK018618","created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39311"},{"id":3091550,"change_date":"2022-12-20 21:41:00","inspection_id":"77422078","insp_violation_id":"250209030","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192527319","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CK018618","created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"3963A1"},{"id":3091551,"change_date":"2022-12-20 21:41:00","inspection_id":"77422078","insp_violation_id":"250209031","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192527319","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LR36595","created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"3922"},{"id":3091552,"change_date":"2022-12-20 21:41:00","inspection_id":"77422078","insp_violation_id":"250209032","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192527319","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3203762,"change_date":"2022-12-20 21:41:00","inspection_id":"77422078","insp_unit_id":"192527319","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"53742T2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKZL70X9KJ367785","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:56.000000Z","updated_at":"2025-03-17T22:28:56.000000Z"}]},{"id":1620835,"change_date":"2022-10-27 21:42:00","inspection_id":"76997722","dot_number":"2607022","report_state":"CA","report_number":"NDN6006282","insp_date":"2022-10-25 00:00:00","insp_start_time":"1100","insp_end_time":"1124","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-10-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"14653354","transaction_code":"A","transaction_date":"2022-10-25 00:00:00","upload_date":"2022-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2022-10-27 21:42:00","snet_input_date":"2022-10-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-27 21:42:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T18:56:37.000000Z","updated_at":"2025-03-17T18:56:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2607773,"change_date":"2022-10-27 21:42:00","inspection_id":"76997722","insp_unit_id":"191687532","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4X WHITE","insp_unit_license":"41644M1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKDL40X3DJ349195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:52.000000Z","updated_at":"2025-03-17T22:24:52.000000Z"}]},{"id":1417586,"change_date":"2022-09-30 21:40:00","inspection_id":"76763159","dot_number":"2607022","report_state":"CA","report_number":"UF44003079","insp_date":"2022-09-29 00:00:00","insp_start_time":"1158","insp_end_time":"1245","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"DOUGHERTY JNO I-580","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"14616919","transaction_code":"A","transaction_date":"2022-09-29 00:00:00","upload_date":"2022-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2022-09-30 21:40:00","snet_input_date":"2022-09-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-30 21:40:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T18:52:44.000000Z","updated_at":"2025-03-17T18:52:44.000000Z","inspection_violations":[{"id":2234351,"change_date":"2022-09-30 21:40:00","inspection_id":"76763159","insp_violation_id":"248770619","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191214041","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LR39267","created_at":"2025-03-17T21:17:14.000000Z","updated_at":"2025-03-17T21:17:14.000000Z","normalized_code":"3922"},{"id":2234352,"change_date":"2022-09-30 21:40:00","inspection_id":"76763159","insp_violation_id":"248770620","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191214041","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CK018509","created_at":"2025-03-17T21:17:14.000000Z","updated_at":"2025-03-17T21:17:14.000000Z","normalized_code":"39311"},{"id":2234353,"change_date":"2022-09-30 21:40:00","inspection_id":"76763159","insp_violation_id":"248770621","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191214041","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CK018509","created_at":"2025-03-17T21:17:14.000000Z","updated_at":"2025-03-17T21:17:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2282035,"change_date":"2022-09-30 21:40:00","inspection_id":"76763159","insp_unit_id":"191214041","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"41644M1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKDL40X3DJ349195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:37.000000Z","updated_at":"2025-03-17T22:22:37.000000Z"}]},{"id":1069063,"change_date":"2022-08-17 21:41:00","inspection_id":"76358117","dot_number":"2607022","report_state":"CA","report_number":"UCZC001386","insp_date":"2022-08-16 00:00:00","insp_start_time":"0900","insp_end_time":"0915","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"680 SB AT SYCAMORE RD","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":"2022-08-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"14551747","transaction_code":"A","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2022-08-17 21:41:00","snet_input_date":"2022-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-17 21:41:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T18:46:32.000000Z","updated_at":"2025-03-17T18:46:32.000000Z","inspection_violations":[{"id":1686513,"change_date":"2022-08-17 21:41:00","inspection_id":"76358117","insp_violation_id":"247805585","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190385437","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:53.000000Z","updated_at":"2025-03-17T21:14:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1720262,"change_date":"2022-08-17 21:41:00","inspection_id":"76358117","insp_unit_id":"190385437","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4X WHT","insp_unit_license":"41644M1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NKDL40X3DJ349195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:51.000000Z","updated_at":"2025-03-17T22:18:51.000000Z"}]},{"id":803707,"change_date":"2022-07-13 21:40:00","inspection_id":"76047665","dot_number":"2607022","report_state":"CA","report_number":"UD8N001846","insp_date":"2022-07-11 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"SARATOGA AVE. O\/R","county_code_state":"CA","county_code":"085","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":"2022-07-12 21:40: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":"14502614","transaction_code":"C","transaction_date":"2022-07-11 00:00:00","upload_date":"2022-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2022-07-12 21:40:00","snet_input_date":"2022-07-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-12 21:40:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"381019","created_at":"2025-03-17T18:41:55.000000Z","updated_at":"2025-03-17T18:41:55.000000Z","inspection_violations":[{"id":1268335,"change_date":"2022-07-13 21:40:00","inspection_id":"76047665","insp_violation_id":"247076193","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":null,"created_at":"2025-03-17T21:12:59.000000Z","updated_at":"2025-03-17T21:12:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1293466,"change_date":"2022-07-13 21:40:00","inspection_id":"76047665","insp_unit_id":"189762310","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"28105H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HM6XXFM265963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:07.000000Z","updated_at":"2025-03-17T22:16:07.000000Z"}]},{"id":152555,"change_date":"2022-04-11 21:41:00","inspection_id":"75274741","dot_number":"2607022","report_state":"CA","report_number":"UEX8001958","insp_date":"2022-04-06 00:00:00","insp_start_time":"1524","insp_end_time":"1537","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":"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":"2022-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"14379485","transaction_code":"A","transaction_date":"2022-04-06 00:00:00","upload_date":"2022-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2022-04-11 21:41:00","snet_input_date":"2022-04-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-11 21:41:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:10.000000Z","updated_at":"2025-03-17T18:30:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":247262,"change_date":"2022-04-11 21:41:00","inspection_id":"75274741","insp_unit_id":"188096580","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"59623R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPVL79X0CD164408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:42.000000Z","updated_at":"2025-03-17T22:09:42.000000Z"}]},{"id":115311,"change_date":"2022-04-05 21:40:00","inspection_id":"75228587","dot_number":"2607022","report_state":"CA","report_number":"UD8N001659","insp_date":"2022-04-05 00:00:00","insp_start_time":"0950","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"N\/OF CAMDEN AVE., SAN JOSE","county_code_state":"CA","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14373119","transaction_code":"A","transaction_date":"2022-04-05 00:00:00","upload_date":"2022-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02607022","upload_search_indicator":null,"census_search_date":"2022-04-05 21:40:00","snet_input_date":"2022-04-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-05 21:40:00","insp_carrier_name":"AQUA GUNITE INC","insp_carrier_street":"5830 S NAYLOR RD","insp_carrier_city":"LIVERMORE","insp_carrier_state":"CA","insp_carrier_zip_code":"94551","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"381019","created_at":"2025-03-17T18:29:30.000000Z","updated_at":"2025-03-17T18:29:30.000000Z","inspection_violations":[{"id":170797,"change_date":"2022-04-05 21:40:00","inspection_id":"75228587","insp_violation_id":"244981562","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":null,"created_at":"2025-03-17T21:07:51.000000Z","updated_at":"2025-03-17T21:07:51.000000Z","normalized_code":"3922"},{"id":170798,"change_date":"2022-04-05 21:40:00","inspection_id":"75228587","insp_violation_id":"244981563","seq_no":"2","part_no":"396","part_no_section":"7","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CQ035596","created_at":"2025-03-17T21:07:51.000000Z","updated_at":"2025-03-17T21:07:51.000000Z","normalized_code":"3967"}],"inspection_per_units":[{"id":186824,"change_date":"2022-04-05 21:40:00","inspection_id":"75228587","insp_unit_id":"188003117","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"28105H1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HM6XXFM265963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:21.000000Z","updated_at":"2025-03-17T22:09:21.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2607022\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2607022\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2607022\/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\/2607022\/inspections","per_page":100,"prev_page_url":null,"to":27,"total":27}