{"current_page":1,"data":[{"id":12518816,"change_date":"2026-07-22 21:43:00","inspection_id":"88483976","dot_number":"2734185","report_state":"CA","report_number":"NARW004532","insp_date":"2026-06-24 00:00:00","insp_start_time":"1146","insp_end_time":"1207","registration_date":null,"region":"PD","ci_status_code":"C","location":"347","location_desc":"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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-22 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":"3623284","transaction_code":"A","transaction_date":"2026-07-22 00:00:00","upload_date":"2026-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":"2026-07-22 21:43:00","snet_input_date":"2026-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-22 21:43:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2026-07-25T09:41:37.000000Z","updated_at":"2026-08-02T09:31:04.000000Z","inspection_violations":[{"id":21793991,"change_date":"2026-07-22 21:43:00","inspection_id":"88483976","insp_violation_id":"275664384","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"214758832","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-25T10:02:28.000000Z","updated_at":"2026-08-02T09:43:18.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":21740647,"change_date":"2026-07-22 21:43:00","inspection_id":"88483976","insp_unit_id":"214758832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"4\/WHT2X","insp_unit_license":"38316M4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTEUMML1VS284128","insp_unit_decal":"Y","insp_unit_decal_number":"36190212","created_at":"2026-07-25T09:20:42.000000Z","updated_at":"2026-08-03T09:02:41.000000Z"}]},{"id":11972275,"change_date":"2026-05-20 21:41:00","inspection_id":"87909098","dot_number":"2734185","report_state":"CA","report_number":"NE7S006025","insp_date":"2026-05-08 00:00:00","insp_start_time":"1230","insp_end_time":"1252","registration_date":null,"region":"PS","ci_status_code":"C","location":"347","location_desc":"CA","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":"U","pen_cen_match":"I","final_status_date":"2026-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"3367796","transaction_code":"A","transaction_date":"2026-05-20 00:00:00","upload_date":"2026-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":"2026-05-20 21:41:00","snet_input_date":"2026-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-20 21:41:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2026-05-23T09:42:53.000000Z","updated_at":"2026-06-01T09:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20815351,"change_date":"2026-05-20 21:41:00","inspection_id":"87909098","insp_unit_id":"213662977","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"20869P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMMLXGL743288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:23.000000Z","updated_at":"2026-06-01T09:02:40.000000Z"}]},{"id":11746680,"change_date":"2026-04-24 21:41:00","inspection_id":"87676204","dot_number":"2734185","report_state":"CA","report_number":"NE7S005954","insp_date":"2026-04-21 00:00:00","insp_start_time":"1415","insp_end_time":"1436","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-24 21:41: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":"16261545","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-24 21:41:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2026-04-27T09:42:40.000000Z","updated_at":"2026-05-05T09:31:57.000000Z","inspection_violations":[{"id":20424017,"change_date":"2026-04-24 21:41:00","inspection_id":"87676204","insp_violation_id":"273851385","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"213222299","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:07:18.000000Z","updated_at":"2026-05-05T09:45:29.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":20438348,"change_date":"2026-04-24 21:41:00","inspection_id":"87676204","insp_unit_id":"213222299","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"81475L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML9GL139859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:21:44.000000Z","updated_at":"2026-05-05T09:05:05.000000Z"}]},{"id":11599736,"change_date":"2026-04-08 21:38:00","inspection_id":"87526583","dot_number":"2734185","report_state":"CA","report_number":"NDZ5006540","insp_date":"2026-04-02 00:00:00","insp_start_time":"1620","insp_end_time":"1658","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-08 21:38: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":"16238071","transaction_code":"A","transaction_date":"2026-04-02 00:00:00","upload_date":"2026-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-08 21:38:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"152644","created_at":"2026-04-11T09:42:45.000000Z","updated_at":"2026-04-19T09:33:45.000000Z","inspection_violations":[{"id":19617986,"change_date":"2026-04-08 21:38:00","inspection_id":"87526583","insp_violation_id":"272947402","seq_no":"1","part_no":"390","part_no_section":"21TE2IV-D","insp_viol_unit":"1","insp_unit_id":"212613918","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:03:37.000000Z","updated_at":"2026-04-18T10:49:40.000000Z","normalized_code":"39021TE2IVD"}],"inspection_per_units":[{"id":19882775,"change_date":"2026-04-08 21:38:00","inspection_id":"87526583","insp_unit_id":"212613918","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT.","insp_unit_license":"26671K4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTEUMML9VS149060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:48.000000Z","updated_at":"2026-04-18T09:39:34.000000Z"}]},{"id":11479924,"change_date":"2026-03-25 21:40:00","inspection_id":"87399004","dot_number":"2734185","report_state":"CA","report_number":"NEID003804","insp_date":"2026-03-23 00:00:00","insp_start_time":"1626","insp_end_time":"1655","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":"2026-03-25 21:40: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":"16222718","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-25 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2026-03-28T09:44:52.000000Z","updated_at":"2026-04-05T09:33:36.000000Z","inspection_violations":[{"id":19379533,"change_date":"2026-03-25 21:40:00","inspection_id":"87399004","insp_violation_id":"272643863","seq_no":"1","part_no":"390","part_no_section":"21TE2IV-D","insp_viol_unit":"1","insp_unit_id":"212339993","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:09.000000Z","updated_at":"2026-04-05T10:02:16.000000Z","normalized_code":"39021TE2IVD"}],"inspection_per_units":[{"id":19663953,"change_date":"2026-03-25 21:40:00","inspection_id":"87399004","insp_unit_id":"212339993","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT\/26","insp_unit_license":"26672K4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTEUMML9VS149074","insp_unit_decal":"Y","insp_unit_decal_number":"35881754","created_at":"2026-03-28T09:23:04.000000Z","updated_at":"2026-04-05T09:19:37.000000Z"}]},{"id":11348230,"change_date":"2026-03-11 21:39:00","inspection_id":"87266234","dot_number":"2734185","report_state":"CA","report_number":"NE7S005839","insp_date":"2026-03-10 00:00:00","insp_start_time":"1913","insp_end_time":"1938","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"16205030","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-11 21:39:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2026-03-14T09:38:23.000000Z","updated_at":"2026-03-22T09:33:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19420942,"change_date":"2026-03-11 21:39:00","inspection_id":"87266234","insp_unit_id":"212092202","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"81475L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML9GL139859","insp_unit_decal":"Y","insp_unit_decal_number":"35884784","created_at":"2026-03-14T09:15:00.000000Z","updated_at":"2026-03-22T09:13:25.000000Z"}]},{"id":11208939,"change_date":"2026-02-23 21:39:00","inspection_id":"87120132","dot_number":"2734185","report_state":"CA","report_number":"NEVK002314","insp_date":"2026-02-19 00:00:00","insp_start_time":"1431","insp_end_time":"1442","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"16178662","transaction_code":"A","transaction_date":"2026-02-19 00:00:00","upload_date":"2026-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-23 21:39:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2026-02-26T10:37:03.000000Z","updated_at":"2026-03-06T10:31:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19140699,"change_date":"2026-02-23 21:39:00","inspection_id":"87120132","insp_unit_id":"211776000","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL226\/WHITE","insp_unit_license":"81475L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML9GL139859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:18.000000Z","updated_at":"2026-03-06T10:04:00.000000Z"}]},{"id":11131917,"change_date":"2026-02-13 21:39:00","inspection_id":"87045424","dot_number":"2734185","report_state":"CA","report_number":"NARW004158","insp_date":"2026-02-12 00:00:00","insp_start_time":"0951","insp_end_time":"1016","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"16170491","transaction_code":"A","transaction_date":"2026-02-12 00:00:00","upload_date":"2026-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-13 21:39:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2026-02-16T10:38:49.000000Z","updated_at":"2026-02-24T10:31:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18989308,"change_date":"2026-02-13 21:39:00","inspection_id":"87045424","insp_unit_id":"211623694","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL227WHT2X","insp_unit_license":"81671L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML5GL139860","insp_unit_decal":"Y","insp_unit_decal_number":"35884309","created_at":"2026-02-16T10:15:06.000000Z","updated_at":"2026-02-24T10:03:40.000000Z"}]},{"id":10782535,"change_date":"2026-01-15 21:41:00","inspection_id":"86808312","dot_number":"2734185","report_state":"CA","report_number":"NARW004058","insp_date":"2026-01-13 00:00:00","insp_start_time":"1203","insp_end_time":"1227","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-15 21:41: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":"16131774","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2026-01-18T10:45:30.000000Z","updated_at":"2026-01-26T10:31:13.000000Z","inspection_violations":[{"id":18017644,"change_date":"2026-01-15 21:41:00","inspection_id":"86808312","insp_violation_id":"271240560","seq_no":"1","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"211118831","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:04:49.000000Z","updated_at":"2026-01-26T10:32:06.000000Z","normalized_code":"39345DBAAL"}],"inspection_per_units":[{"id":18102264,"change_date":"2026-01-15 21:41:00","inspection_id":"86808312","insp_unit_id":"211118831","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL262\/WHT2X","insp_unit_license":"20870P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL743289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:17:43.000000Z","updated_at":"2026-01-26T10:01:26.000000Z"}]},{"id":10451726,"change_date":"2025-12-16 21:38:00","inspection_id":"86584289","dot_number":"2734185","report_state":"CA","report_number":"NFDX001558","insp_date":"2025-12-15 00:00:00","insp_start_time":"1605","insp_end_time":"1655","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ADVANCED INSTALLATION SERVICES INC","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-12-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"16097545","transaction_code":"A","transaction_date":"2025-12-15 00:00:00","upload_date":"2025-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-16 21:38:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-12-19T10:31:56.000000Z","updated_at":"2025-12-27T10:31:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17489585,"change_date":"2025-12-16 21:38:00","inspection_id":"86584289","insp_unit_id":"210645019","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT\/PL629","insp_unit_license":"15636Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEWMMM1ML151457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-19T10:02:22.000000Z","updated_at":"2025-12-27T10:01:19.000000Z"}]},{"id":9084316,"change_date":"2025-07-07 21:40:00","inspection_id":"85147463","dot_number":"2734185","report_state":"CA","report_number":"UGHP000282","insp_date":"2025-07-07 00:00:00","insp_start_time":"0720","insp_end_time":"0735","registration_date":null,"region":"PT","ci_status_code":"C","location":"9347","location_desc":"S\/B NIMITZ SCALE","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15888353","transaction_code":"A","transaction_date":"2025-07-07 00:00:00","upload_date":"2025-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-07 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:41.000000Z","updated_at":"2025-07-11T10:44:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14907595,"change_date":"2025-07-07 21:40:00","inspection_id":"85147463","insp_unit_id":"207742206","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"20870P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL743289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:30.000000Z","updated_at":"2025-07-11T09:46:30.000000Z"}]},{"id":9017234,"change_date":"2025-06-27 21:39:00","inspection_id":"85076699","dot_number":"2734185","report_state":"CA","report_number":"UDI1003056","insp_date":"2025-06-27 00:00:00","insp_start_time":"1200","insp_end_time":"1220","registration_date":null,"region":"PT","ci_status_code":"C","location":"211","location_desc":"ANTELOPE PLATFORM SCALE WB","county_code_state":"CA","county_code":"067","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-27 21:39: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":"15879023","transaction_code":"A","transaction_date":"2025-06-27 00:00:00","upload_date":"2025-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-27 21:39:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:27.000000Z","updated_at":"2025-07-03T10:00:58.000000Z","inspection_violations":[{"id":14495214,"change_date":"2025-06-27 21:39:00","inspection_id":"85076699","insp_violation_id":"267102484","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207614231","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TBD","created_at":"2025-06-30T10:17:54.000000Z","updated_at":"2025-07-02T10:16:28.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14788906,"change_date":"2025-06-27 21:39:00","inspection_id":"85076699","insp_unit_id":"207614231","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"81474L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL068561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:41.000000Z","updated_at":"2025-07-01T09:50:07.000000Z"}]},{"id":9106614,"change_date":"2025-07-09 21:43:00","inspection_id":"85170915","dot_number":"2734185","report_state":"CA","report_number":"N8AH005889","insp_date":"2025-06-27 00:00:00","insp_start_time":"1340","insp_end_time":"1353","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":"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-07-09 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":"15890672","transaction_code":"A","transaction_date":"2025-06-27 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-09 21:43:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-07-12T10:45:32.000000Z","updated_at":"2025-07-14T10:46:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14948892,"change_date":"2025-07-09 21:43:00","inspection_id":"85170915","insp_unit_id":"207788999","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL459","insp_unit_license":"23527M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML2KL556460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:58.000000Z","updated_at":"2025-07-13T09:46:43.000000Z"}]},{"id":9002772,"change_date":"2025-06-26 21:42:00","inspection_id":"85061608","dot_number":"2734185","report_state":"CA","report_number":"UD6V000348","insp_date":"2025-06-15 00:00:00","insp_start_time":"0854","insp_end_time":"0928","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"EB 580 LIVERMORE CVEF","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":"N","traffic_enf":"N","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":"26000","viol_total":"2","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":"15867081","transaction_code":"A","transaction_date":"2025-06-15 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:10.000000Z","updated_at":"2025-06-30T10:01:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14764432,"change_date":"2025-06-26 21:42:00","inspection_id":"85061608","insp_unit_id":"207587816","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2 AXL WHT","insp_unit_license":"23527M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML2KL556460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:26.000000Z","updated_at":"2025-07-01T09:48:35.000000Z"}]},{"id":8829825,"change_date":"2025-06-05 21:42:00","inspection_id":"84878310","dot_number":"2734185","report_state":"CA","report_number":"NE7S004748","insp_date":"2025-06-02 00:00:00","insp_start_time":"1601","insp_end_time":"1628","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-06-05 21:42: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":"15849106","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-05 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-06-09T10:01:08.000000Z","updated_at":"2025-06-09T10:01:08.000000Z","inspection_violations":[{"id":14134944,"change_date":"2025-06-05 21:42:00","inspection_id":"84878310","insp_violation_id":"266692646","seq_no":"1","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"1","insp_unit_id":"207251291","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:17:05.000000Z","updated_at":"2025-06-09T10:16:28.000000Z","normalized_code":"3922SLLDL"}],"inspection_per_units":[{"id":14456370,"change_date":"2025-06-05 21:42:00","inspection_id":"84878310","insp_unit_id":"207251291","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"21473N3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL068558","insp_unit_decal":"Y","insp_unit_decal_number":"35061567","created_at":"2025-06-08T09:46:29.000000Z","updated_at":"2025-06-09T09:46:06.000000Z"}]},{"id":8706214,"change_date":"2025-05-21 21:42:00","inspection_id":"84747329","dot_number":"2734185","report_state":"CA","report_number":"NEAH005210","insp_date":"2025-05-15 00:00:00","insp_start_time":"1344","insp_end_time":"1406","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15830140","transaction_code":"A","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-05-24T10:04:38.000000Z","updated_at":"2025-05-25T10:07:32.000000Z","inspection_violations":[{"id":13877562,"change_date":"2025-05-21 21:42:00","inspection_id":"84747329","insp_violation_id":"266391505","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"207000295","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:28:52.000000Z","updated_at":"2025-05-25T10:27:54.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":14227110,"change_date":"2025-05-21 21:42:00","inspection_id":"84747329","insp_unit_id":"207000295","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL212\/WHT","insp_unit_license":"81938L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML3GL068559","insp_unit_decal":"Y","insp_unit_decal_number":"35094783","created_at":"2025-05-24T09:50:01.000000Z","updated_at":"2025-05-25T09:53:29.000000Z"}]},{"id":8417512,"change_date":"2025-04-18 21:40:00","inspection_id":"84443267","dot_number":"2734185","report_state":"CA","report_number":"N5Y3007328","insp_date":"2025-04-16 00:00:00","insp_start_time":"0635","insp_end_time":"0700","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":"NEW PIVOT INTERIORS","shipping_paper_number":"S1045460011","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-04-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15786745","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-18 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-04-21T10:26:19.000000Z","updated_at":"2025-04-23T10:03:36.000000Z","inspection_violations":[{"id":13282542,"change_date":"2025-04-18 21:40:00","inspection_id":"84443267","insp_violation_id":"265712669","seq_no":"1","part_no":"393","part_no_section":"209D-STPAL","insp_viol_unit":"1","insp_unit_id":"206392043","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA669414","created_at":"2025-04-20T11:17:20.000000Z","updated_at":"2025-04-22T10:34:41.000000Z","normalized_code":"393209DSTPAL"},{"id":13282543,"change_date":"2025-04-18 21:40:00","inspection_id":"84443267","insp_violation_id":"265712670","seq_no":"2","part_no":"393","part_no_section":"75A1-TFBMF","insp_viol_unit":"1","insp_unit_id":"206392043","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA669414","created_at":"2025-04-20T11:17:20.000000Z","updated_at":"2025-04-22T10:34:41.000000Z","normalized_code":"39375A1TFBMF"}],"inspection_per_units":[{"id":13667100,"change_date":"2025-04-18 21:40:00","inspection_id":"84443267","insp_unit_id":"206392043","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHI","insp_unit_license":"81475L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML9GL139859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:18:32.000000Z","updated_at":"2025-04-22T10:06:42.000000Z"}]},{"id":8442781,"change_date":"2025-04-22 21:41:00","inspection_id":"84470096","dot_number":"2734185","report_state":"CA","report_number":"NBGO008210","insp_date":"2025-04-16 00:00:00","insp_start_time":"1031","insp_end_time":"1048","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":"NEW PIVOT INTERIORS","shipping_paper_number":"S1045460011","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-04-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15789423","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-22 21:41:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-26T10:27:31.000000Z","updated_at":"2025-04-26T10:27:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13712046,"change_date":"2025-04-22 21:41:00","inspection_id":"84470096","insp_unit_id":"206440778","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT\/BOX","insp_unit_license":"81475L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML9GL139859","insp_unit_decal":"Y","insp_unit_decal_number":"35089993","created_at":"2025-04-25T10:15:06.000000Z","updated_at":"2025-04-26T10:08:00.000000Z"}]},{"id":8181899,"change_date":"2025-03-21 21:40:00","inspection_id":"84195172","dot_number":"2734185","report_state":"CA","report_number":"NDZ5005450","insp_date":"2025-03-13 00:00:00","insp_start_time":"1432","insp_end_time":"1502","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-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15749830","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-21 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-03-24T10:28:10.000000Z","updated_at":"2025-03-25T10:11:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13225483,"change_date":"2025-03-21 21:40:00","inspection_id":"84195172","insp_unit_id":"205934251","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL629","insp_unit_license":"15636Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEWMMM1ML151457","insp_unit_decal":"Y","insp_unit_decal_number":"34775147","created_at":"2025-03-24T10:20:50.000000Z","updated_at":"2025-03-25T10:04:06.000000Z"}]},{"id":8038770,"change_date":"2025-03-05 21:40:00","inspection_id":"84044482","dot_number":"2734185","report_state":"CA","report_number":"UE7F001849","insp_date":"2025-03-03 00:00:00","insp_start_time":"1202","insp_end_time":"1236","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-05 21:40: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":"15727449","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:00.000000Z","updated_at":"2025-03-17T21:05:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12978049,"change_date":"2025-03-05 21:40:00","inspection_id":"84044482","insp_unit_id":"205649396","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2X","insp_unit_license":"81474L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL068561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:22.000000Z","updated_at":"2025-03-17T23:58:22.000000Z"}]},{"id":8038669,"change_date":"2025-03-05 21:40:00","inspection_id":"84044375","dot_number":"2734185","report_state":"CA","report_number":"UE9B002923","insp_date":"2025-03-01 00:00:00","insp_start_time":"0958","insp_end_time":"1029","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15728314","transaction_code":"A","transaction_date":"2025-03-01 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"2734185","created_at":"2025-03-17T21:05:00.000000Z","updated_at":"2025-03-17T21:05:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12977902,"change_date":"2025-03-05 21:40:00","inspection_id":"84044375","insp_unit_id":"205649238","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT PL226","insp_unit_license":"81475L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML9GL139859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:22.000000Z","updated_at":"2025-03-17T23:58:22.000000Z"}]},{"id":8036805,"change_date":"2025-03-05 21:40:00","inspection_id":"84042478","dot_number":"2734185","report_state":"CA","report_number":"NBH6006498","insp_date":"2025-02-27 00:00:00","insp_start_time":"0607","insp_end_time":"0630","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-05 21:40: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":"15728223","transaction_code":"A","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-03-17T21:04:59.000000Z","updated_at":"2025-03-17T21:04:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12974991,"change_date":"2025-03-05 21:40:00","inspection_id":"84042478","insp_unit_id":"205646199","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL459","insp_unit_license":"23527M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML2KL556460","insp_unit_decal":"Y","insp_unit_decal_number":"34774296","created_at":"2025-03-17T23:58:18.000000Z","updated_at":"2025-03-17T23:58:18.000000Z"}]},{"id":7947015,"change_date":"2025-02-24 21:40:00","inspection_id":"83948186","dot_number":"2734185","report_state":"CA","report_number":"NARW003158","insp_date":"2025-02-21 00:00:00","insp_start_time":"0808","insp_end_time":"0834","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-02-24 21:40: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":"15713887","transaction_code":"A","transaction_date":"2025-02-21 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-24 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-03-17T21:03:15.000000Z","updated_at":"2025-03-17T21:03:15.000000Z","inspection_violations":[{"id":12417670,"change_date":"2025-02-24 21:40:00","inspection_id":"83948186","insp_violation_id":"264671516","seq_no":"1","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"205473236","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA672623","created_at":"2025-03-17T22:06:38.000000Z","updated_at":"2025-03-17T22:06:38.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":12828919,"change_date":"2025-02-24 21:40:00","inspection_id":"83948186","insp_unit_id":"205473236","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL214\/WHT2X","insp_unit_license":"81474L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL068561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:42.000000Z","updated_at":"2025-03-17T23:56:42.000000Z"}]},{"id":7958014,"change_date":"2025-02-25 21:40:00","inspection_id":"83959648","dot_number":"2734185","report_state":"CA","report_number":"NBH6006436","insp_date":"2025-02-13 00:00:00","insp_start_time":"0801","insp_end_time":"0815","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":"N","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":"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":"15715537","transaction_code":"A","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-25 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-03-17T21:03:19.000000Z","updated_at":"2025-03-17T21:03:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12846603,"change_date":"2025-02-25 21:40:00","inspection_id":"83959648","insp_unit_id":"205494070","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL459","insp_unit_license":"23527M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML2KL556460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:55.000000Z","updated_at":"2025-03-17T23:56:55.000000Z"}]},{"id":7441837,"change_date":"2024-12-17 21:40:00","inspection_id":"83417684","dot_number":"2734185","report_state":"CA","report_number":"NATH004281","insp_date":"2024-12-16 00:00:00","insp_start_time":"0700","insp_end_time":"0732","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-17 21:40: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":"15632816","transaction_code":"A","transaction_date":"2024-12-16 00:00:00","upload_date":"2024-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-17 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-03-17T20:51:30.000000Z","updated_at":"2025-03-17T20:51:30.000000Z","inspection_violations":[{"id":11629248,"change_date":"2024-12-17 21:40:00","inspection_id":"83417684","insp_violation_id":"263529284","seq_no":"1","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"204439723","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"3939AHLLH"}],"inspection_per_units":[{"id":12005478,"change_date":"2024-12-17 21:40:00","inspection_id":"83417684","insp_unit_id":"204439723","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"81938L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML3GL068559","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:34.000000Z","updated_at":"2025-03-17T23:47:34.000000Z"}]},{"id":7310910,"change_date":"2024-11-30 21:33:00","inspection_id":"83279963","dot_number":"2734185","report_state":"CA","report_number":"NEEU002722","insp_date":"2024-11-27 00:00:00","insp_start_time":"0916","insp_end_time":"0945","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15610876","transaction_code":"A","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:35.000000Z","updated_at":"2025-03-17T20:48:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11793352,"change_date":"2024-11-30 21:33:00","inspection_id":"83279963","insp_unit_id":"204118081","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL262\/WHT","insp_unit_license":"20870P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL743289","insp_unit_decal":"Y","insp_unit_decal_number":"34467847","created_at":"2025-03-17T23:45:13.000000Z","updated_at":"2025-03-17T23:45:13.000000Z"}]},{"id":7311586,"change_date":"2024-11-30 21:33:00","inspection_id":"83280654","dot_number":"2734185","report_state":"CA","report_number":"NEVK001217","insp_date":"2024-11-26 00:00:00","insp_start_time":"1500","insp_end_time":"1523","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-30 21:33: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":"15611411","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"Y","insp_carrier_state_id":"599512","created_at":"2025-03-17T20:48:35.000000Z","updated_at":"2025-03-17T20:48:35.000000Z","inspection_violations":[{"id":11429978,"change_date":"2024-11-30 21:33:00","inspection_id":"83280654","insp_violation_id":"263157816","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"204119293","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":11794500,"change_date":"2024-11-30 21:33:00","inspection_id":"83280654","insp_unit_id":"204119293","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL262\/WHITE","insp_unit_license":"20870P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL743289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:13.000000Z","updated_at":"2025-03-17T23:45:13.000000Z"}]},{"id":7051235,"change_date":"2024-10-25 21:41:00","inspection_id":"83005233","dot_number":"2734185","report_state":"CA","report_number":"NEC6000130","insp_date":"2024-10-24 00:00:00","insp_start_time":"1415","insp_end_time":"1429","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15570551","transaction_code":"A","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-25 21:41:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"Y","insp_carrier_state_id":"599512","created_at":"2025-03-17T20:43:02.000000Z","updated_at":"2025-03-17T20:43:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11372095,"change_date":"2024-10-25 21:41:00","inspection_id":"83005233","insp_unit_id":"203597883","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL629\/WHT","insp_unit_license":"15636Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEWMMM1ML151457","insp_unit_decal":"Y","insp_unit_decal_number":"34514588","created_at":"2025-03-17T23:40:46.000000Z","updated_at":"2025-03-17T23:40:46.000000Z"}]},{"id":7064468,"change_date":"2024-10-28 21:40:00","inspection_id":"83019194","dot_number":"2734185","report_state":"CA","report_number":"NEVK001109","insp_date":"2024-10-24 00:00:00","insp_start_time":"1445","insp_end_time":"1501","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-28 21:40: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":"15573975","transaction_code":"A","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-28 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"Y","insp_carrier_state_id":"599512","created_at":"2025-03-17T20:43:25.000000Z","updated_at":"2025-03-17T20:43:25.000000Z","inspection_violations":[{"id":11028563,"change_date":"2024-10-28 21:40:00","inspection_id":"83019194","insp_violation_id":"262599413","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"203623487","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":11393588,"change_date":"2024-10-28 21:40:00","inspection_id":"83019194","insp_unit_id":"203623487","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL214\/WHITE","insp_unit_license":"81474L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL068561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:57.000000Z","updated_at":"2025-03-17T23:40:57.000000Z"}]},{"id":7029068,"change_date":"2024-10-23 21:43:00","inspection_id":"82981685","dot_number":"2734185","report_state":"CA","report_number":"NDMK005717","insp_date":"2024-10-08 00:00:00","insp_start_time":"0539","insp_end_time":"0605","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-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":"15565421","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-23 21:43:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:38.000000Z","updated_at":"2025-03-17T20:42:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11336327,"change_date":"2024-10-23 21:43:00","inspection_id":"82981685","insp_unit_id":"203554566","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"81671L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML5GL139860","insp_unit_decal":"Y","insp_unit_decal_number":"34471903","created_at":"2025-03-17T23:40:24.000000Z","updated_at":"2025-03-17T23:40:24.000000Z"}]},{"id":6857329,"change_date":"2024-09-30 21:42:00","inspection_id":"82799024","dot_number":"2734185","report_state":"CA","report_number":"UFYK000033","insp_date":"2024-09-27 00:00:00","insp_start_time":"0734","insp_end_time":"0756","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 E\/B, LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15538957","transaction_code":"A","transaction_date":"2024-09-27 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-30 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11058329,"change_date":"2024-09-30 21:42:00","inspection_id":"82799024","insp_unit_id":"203203678","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL459","insp_unit_license":"23527M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML2KL556460","insp_unit_decal":"Y","insp_unit_decal_number":"34152161","created_at":"2025-03-17T23:37:31.000000Z","updated_at":"2025-03-17T23:37:31.000000Z"}]},{"id":6493219,"change_date":"2024-08-16 21:40:00","inspection_id":"82411470","dot_number":"2734185","report_state":"CA","report_number":"NDKW006760","insp_date":"2024-08-15 00:00:00","insp_start_time":"2045","insp_end_time":"2110","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":"2024-08-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15486323","transaction_code":"A","transaction_date":"2024-08-15 00:00:00","upload_date":"2024-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-16 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"Y","insp_carrier_state_id":"599512","created_at":"2025-03-17T20:31:36.000000Z","updated_at":"2025-03-17T20:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10466793,"change_date":"2024-08-16 21:40:00","inspection_id":"82411470","insp_unit_id":"202444396","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL211","insp_unit_license":"21473N3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL068558","insp_unit_decal":"Y","insp_unit_decal_number":"34150127","created_at":"2025-03-17T23:31:26.000000Z","updated_at":"2025-03-17T23:31:26.000000Z"}]},{"id":6323724,"change_date":"2024-07-26 21:40:00","inspection_id":"82230165","dot_number":"2734185","report_state":"CA","report_number":"NE02004542","insp_date":"2024-07-23 00:00:00","insp_start_time":"1351","insp_end_time":"1409","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15458751","transaction_code":"A","transaction_date":"2024-07-23 00:00:00","upload_date":"2024-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-26 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"Y","insp_carrier_state_id":"599512","created_at":"2025-03-17T20:28:13.000000Z","updated_at":"2025-03-17T20:28:13.000000Z","inspection_violations":[{"id":9818809,"change_date":"2024-07-26 21:40:00","inspection_id":"82230165","insp_violation_id":"260871613","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202100175","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:28.000000Z","updated_at":"2025-03-17T21:53:28.000000Z","normalized_code":"3922"},{"id":9818810,"change_date":"2024-07-26 21:40:00","inspection_id":"82230165","insp_violation_id":"260871614","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202100175","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:28.000000Z","updated_at":"2025-03-17T21:53:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10189522,"change_date":"2024-07-26 21:40:00","inspection_id":"82230165","insp_unit_id":"202100175","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL226\/W2X","insp_unit_license":"81475L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML9GL139859","insp_unit_decal":"Y","insp_unit_decal_number":"34153353","created_at":"2025-03-17T23:28:31.000000Z","updated_at":"2025-03-17T23:28:31.000000Z"}]},{"id":6278958,"change_date":"2024-07-22 21:42:00","inspection_id":"82182325","dot_number":"2734185","report_state":"CA","report_number":"NEVK000834","insp_date":"2024-07-18 00:00:00","insp_start_time":"1716","insp_end_time":"1734","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15449835","transaction_code":"A","transaction_date":"2024-07-18 00:00:00","upload_date":"2024-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-22 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"Y","insp_carrier_state_id":"599512","created_at":"2025-03-17T20:27:04.000000Z","updated_at":"2025-03-17T20:27:04.000000Z","inspection_violations":[{"id":9753523,"change_date":"2024-07-22 21:42:00","inspection_id":"82182325","insp_violation_id":"260777480","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202007798","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:11.000000Z","updated_at":"2025-03-17T21:53:11.000000Z","normalized_code":"3922"},{"id":9753524,"change_date":"2024-07-22 21:42:00","inspection_id":"82182325","insp_violation_id":"260777481","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202007798","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:11.000000Z","updated_at":"2025-03-17T21:53:11.000000Z","normalized_code":"3939A"},{"id":9753525,"change_date":"2024-07-22 21:42:00","inspection_id":"82182325","insp_violation_id":"260777482","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202007798","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CW952731","created_at":"2025-03-17T21:53:11.000000Z","updated_at":"2025-03-17T21:53:11.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":10116915,"change_date":"2024-07-22 21:42:00","inspection_id":"82182325","insp_unit_id":"202007798","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL227\/WHITE","insp_unit_license":"81671L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML5GL139860","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:49.000000Z","updated_at":"2025-03-17T23:27:49.000000Z"}]},{"id":6065321,"change_date":"2024-06-24 21:43:00","inspection_id":"81952913","dot_number":"2734185","report_state":"CA","report_number":"NE7S003353","insp_date":"2024-06-20 00:00:00","insp_start_time":"0706","insp_end_time":"0727","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15416455","transaction_code":"A","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-24 21:43:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"Y","insp_carrier_state_id":"599512","created_at":"2025-03-17T20:22:58.000000Z","updated_at":"2025-03-17T20:22:58.000000Z","inspection_violations":[{"id":9410815,"change_date":"2024-06-24 21:43:00","inspection_id":"81952913","insp_violation_id":"260281101","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201566326","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"3922"},{"id":9410816,"change_date":"2024-06-24 21:43:00","inspection_id":"81952913","insp_violation_id":"260281102","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"201566326","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":9769132,"change_date":"2024-06-24 21:43:00","inspection_id":"81952913","insp_unit_id":"201566326","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"81938L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML3GL068559","insp_unit_decal":"Y","insp_unit_decal_number":"33878446","created_at":"2025-03-17T23:24:11.000000Z","updated_at":"2025-03-17T23:24:11.000000Z"}]},{"id":5648989,"change_date":"2024-05-01 21:43:00","inspection_id":"81501330","dot_number":"2734185","report_state":"CA","report_number":"NE7S003131","insp_date":"2024-04-29 00:00:00","insp_start_time":"1400","insp_end_time":"1429","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15344193","transaction_code":"A","transaction_date":"2024-04-29 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-01 21:43:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"Y","insp_carrier_state_id":"599512","created_at":"2025-03-17T20:14:42.000000Z","updated_at":"2025-03-17T20:14:42.000000Z","inspection_violations":[{"id":8737481,"change_date":"2024-05-01 21:43:00","inspection_id":"81501330","insp_violation_id":"259265129","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200683433","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"39345B2"},{"id":8737482,"change_date":"2024-05-01 21:43:00","inspection_id":"81501330","insp_violation_id":"259265130","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200683433","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":9098865,"change_date":"2024-05-01 21:43:00","inspection_id":"81501330","insp_unit_id":"200683433","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"20870P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL743289","insp_unit_decal":"Y","insp_unit_decal_number":"33815377","created_at":"2025-03-17T23:17:39.000000Z","updated_at":"2025-03-17T23:17:39.000000Z"}]},{"id":5554560,"change_date":"2024-04-19 21:39:00","inspection_id":"81398501","dot_number":"2734185","report_state":"CA","report_number":"ND6S006994","insp_date":"2024-04-18 00:00:00","insp_start_time":"1225","insp_end_time":"1251","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":"2024-04-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15326149","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":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-19 21:39:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"Y","insp_carrier_state_id":"599512","created_at":"2025-03-17T20:12:47.000000Z","updated_at":"2025-03-17T20:12:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8946972,"change_date":"2024-04-19 21:39:00","inspection_id":"81398501","insp_unit_id":"200487763","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"23527M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML2KL556460","insp_unit_decal":"Y","insp_unit_decal_number":"33808733","created_at":"2025-03-17T23:16:15.000000Z","updated_at":"2025-03-17T23:16:15.000000Z"}]},{"id":4667289,"change_date":"2023-12-19 21:42:00","inspection_id":"80429691","dot_number":"2734185","report_state":"CA","report_number":"NBIJ004840","insp_date":"2023-12-14 00:00:00","insp_start_time":"0611","insp_end_time":"0629","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":"2023-12-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15172972","transaction_code":"A","transaction_date":"2023-12-14 00:00:00","upload_date":"2023-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-19 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-03-17T19:55:22.000000Z","updated_at":"2025-03-17T19:55:22.000000Z","inspection_violations":[{"id":7215517,"change_date":"2023-12-19 21:42:00","inspection_id":"80429691","insp_violation_id":"256972554","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198584196","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7506936,"change_date":"2023-12-19 21:42:00","inspection_id":"80429691","insp_unit_id":"198584196","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL227","insp_unit_license":"81671L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML5GL139860","insp_unit_decal":"Y","insp_unit_decal_number":"33206519","created_at":"2025-03-17T23:03:07.000000Z","updated_at":"2025-03-17T23:03:07.000000Z"}]},{"id":4513289,"change_date":"2023-11-28 21:42:00","inspection_id":"80260385","dot_number":"2734185","report_state":"CA","report_number":"UEXA001991","insp_date":"2023-11-27 00:00:00","insp_start_time":"0730","insp_end_time":"0743","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AIS","shipping_paper_number":"Y","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-11-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15146015","transaction_code":"A","transaction_date":"2023-11-27 00:00:00","upload_date":"2023-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-28 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:13.000000Z","updated_at":"2025-03-17T19:52:13.000000Z","inspection_violations":[{"id":6983355,"change_date":"2023-11-28 21:42:00","inspection_id":"80260385","insp_violation_id":"256605680","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198253614","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3922"},{"id":6983356,"change_date":"2023-11-28 21:42:00","inspection_id":"80260385","insp_violation_id":"256605681","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198253614","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7258802,"change_date":"2023-11-28 21:42:00","inspection_id":"80260385","insp_unit_id":"198253614","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"23527M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML2KL556460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:57.000000Z","updated_at":"2025-03-17T23:00:57.000000Z"}]},{"id":4396674,"change_date":"2023-11-09 21:41:00","inspection_id":"80132226","dot_number":"2734185","report_state":"CA","report_number":"NEEU001650","insp_date":"2023-11-03 00:00:00","insp_start_time":"1551","insp_end_time":"1621","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":"2023-11-09 21:41: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":"15129265","transaction_code":"A","transaction_date":"2023-11-03 00:00:00","upload_date":"2023-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-09 21:41:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-03-17T19:49:54.000000Z","updated_at":"2025-03-17T19:49:54.000000Z","inspection_violations":[{"id":6803945,"change_date":"2023-11-09 21:41:00","inspection_id":"80132226","insp_violation_id":"256324799","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197997844","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KL42071","created_at":"2025-03-17T21:38:46.000000Z","updated_at":"2025-03-17T21:38:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7070879,"change_date":"2023-11-09 21:41:00","inspection_id":"80132226","insp_unit_id":"197997844","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL211\/WHT","insp_unit_license":"21473N3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL068558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:22.000000Z","updated_at":"2025-03-17T22:59:22.000000Z"}]},{"id":3807136,"change_date":"2023-08-22 21:44:00","inspection_id":"79477911","dot_number":"2734185","report_state":"CA","report_number":"UCV3001898","insp_date":"2023-08-22 00:00:00","insp_start_time":"0038","insp_end_time":"0051","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-22 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15030813","transaction_code":"A","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-22 21:44:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:03.000000Z","updated_at":"2025-03-17T19:38:03.000000Z","inspection_violations":[{"id":5874571,"change_date":"2023-08-22 21:44:00","inspection_id":"79477911","insp_violation_id":"254817705","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196675131","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW951272","created_at":"2025-03-17T21:34:18.000000Z","updated_at":"2025-03-17T21:34:18.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6121491,"change_date":"2023-08-22 21:44:00","inspection_id":"79477911","insp_unit_id":"196675131","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2 AXLE","insp_unit_license":"81475L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML9GL129859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:26.000000Z","updated_at":"2025-03-17T22:51:26.000000Z"}]},{"id":3625042,"change_date":"2023-07-28 21:42:00","inspection_id":"79274413","dot_number":"2734185","report_state":"CA","report_number":"UD9R001145","insp_date":"2023-07-25 00:00:00","insp_start_time":"1145","insp_end_time":"1154","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-28 21:42: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":"14999674","transaction_code":"A","transaction_date":"2023-07-25 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-28 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:32.000000Z","updated_at":"2025-03-17T19:34:32.000000Z","inspection_violations":[{"id":5590919,"change_date":"2023-07-28 21:42:00","inspection_id":"79274413","insp_violation_id":"254357739","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196262827","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:54.000000Z","updated_at":"2025-03-17T21:32:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5828364,"change_date":"2023-07-28 21:42:00","inspection_id":"79274413","insp_unit_id":"196262827","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2 AX WHI","insp_unit_license":"81475L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML9GL129859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:01.000000Z","updated_at":"2025-03-17T22:49:01.000000Z"}]},{"id":3540403,"change_date":"2023-09-06 21:44:00","inspection_id":"79179378","dot_number":"2734185","report_state":"CA","report_number":"UCV3001857","insp_date":"2023-07-17 00:00:00","insp_start_time":"2300","insp_end_time":"2321","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-18 21:43: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":"14986944","transaction_code":"C","transaction_date":"2023-09-05 00:00:00","upload_date":"2023-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-18 21:43:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:06.000000Z","updated_at":"2025-03-17T19:33:06.000000Z","inspection_violations":[{"id":5458518,"change_date":"2023-09-06 21:44:00","inspection_id":"79179378","insp_violation_id":"255124121","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW954039","created_at":"2025-03-17T21:32:18.000000Z","updated_at":"2025-03-17T21:32:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5692645,"change_date":"2023-09-06 21:44:00","inspection_id":"79179378","insp_unit_id":"196934494","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2 AXLE","insp_unit_license":"81475L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML9GL139859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:55.000000Z","updated_at":"2025-03-17T22:47:55.000000Z"}]},{"id":3379588,"change_date":"2023-06-27 21:41:00","inspection_id":"78998831","dot_number":"2734185","report_state":"CA","report_number":"NBH6004641","insp_date":"2023-06-26 00:00:00","insp_start_time":"0748","insp_end_time":"0820","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-27 21:41: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":"14960536","transaction_code":"A","transaction_date":"2023-06-26 00:00:00","upload_date":"2023-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-27 21:41:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:49.000000Z","updated_at":"2025-03-17T19:29:49.000000Z","inspection_violations":[{"id":5211923,"change_date":"2023-06-27 21:41:00","inspection_id":"78998831","insp_violation_id":"253737465","seq_no":"1","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"1","insp_unit_id":"195707313","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"37611D1"},{"id":5211924,"change_date":"2023-06-27 21:41:00","inspection_id":"78998831","insp_violation_id":"253737466","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195707313","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5433228,"change_date":"2023-06-27 21:41:00","inspection_id":"78998831","insp_unit_id":"195707313","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PR379","insp_unit_license":"77630N2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTEUMML9KH049839","insp_unit_decal":"Y","insp_unit_decal_number":"32465829","created_at":"2025-03-17T22:45:51.000000Z","updated_at":"2025-03-17T22:45:51.000000Z"}]},{"id":3197132,"change_date":"2023-06-01 21:43:00","inspection_id":"78793141","dot_number":"2734185","report_state":"CA","report_number":"NEEU001179","insp_date":"2023-05-31 00:00:00","insp_start_time":"1601","insp_end_time":"1633","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":"2023-06-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"14926518","transaction_code":"A","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-01 21:43:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"152644","created_at":"2025-03-17T19:26:09.000000Z","updated_at":"2025-03-17T19:26:09.000000Z","inspection_violations":[{"id":4925790,"change_date":"2023-06-01 21:43:00","inspection_id":"78793141","insp_violation_id":"253226426","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195269866","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:56.000000Z","updated_at":"2025-03-17T21:29:56.000000Z","normalized_code":"3922"},{"id":4925791,"change_date":"2023-06-01 21:43:00","inspection_id":"78793141","insp_violation_id":"253226427","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"195269866","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:56.000000Z","updated_at":"2025-03-17T21:29:56.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":5142507,"change_date":"2023-06-01 21:43:00","inspection_id":"78793141","insp_unit_id":"195269866","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL459\/WHT","insp_unit_license":"23527M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML2KL556460","insp_unit_decal":"Y","insp_unit_decal_number":"32474371","created_at":"2025-03-17T22:43:31.000000Z","updated_at":"2025-03-17T22:43:31.000000Z"}]},{"id":3017074,"change_date":"2023-05-10 21:42:00","inspection_id":"78589890","dot_number":"2734185","report_state":"CA","report_number":"NE28003351","insp_date":"2023-05-09 00:00:00","insp_start_time":"1600","insp_end_time":"1646","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":"2023-05-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"14895105","transaction_code":"A","transaction_date":"2023-05-09 00:00:00","upload_date":"2023-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-10 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"152644","created_at":"2025-03-17T19:22:40.000000Z","updated_at":"2025-03-17T19:22:40.000000Z","inspection_violations":[{"id":4634332,"change_date":"2023-05-10 21:42:00","inspection_id":"78589890","insp_violation_id":"252758658","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194866342","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:35.000000Z","updated_at":"2025-03-17T21:28:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4853954,"change_date":"2023-05-10 21:42:00","inspection_id":"78589890","insp_unit_id":"194866342","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL630","insp_unit_license":"9F23417","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDXTZN8MN151458","insp_unit_decal":"Y","insp_unit_decal_number":"32462297","created_at":"2025-03-17T22:41:14.000000Z","updated_at":"2025-03-17T22:41:14.000000Z"},{"id":4853955,"change_date":"2023-05-10 21:42:00","inspection_id":"78589890","insp_unit_id":"194866343","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"543943","insp_unit_license":"4LT5664","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C0XT033662","insp_unit_decal":"Y","insp_unit_decal_number":"32462298","created_at":"2025-03-17T22:41:14.000000Z","updated_at":"2025-03-17T22:41:14.000000Z"}]},{"id":2921199,"change_date":"2023-04-28 21:39:00","inspection_id":"78481792","dot_number":"2734185","report_state":"CA","report_number":"NBIJ004017","insp_date":"2023-04-27 00:00:00","insp_start_time":"0615","insp_end_time":"0650","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":"2023-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14878642","transaction_code":"A","transaction_date":"2023-04-27 00:00:00","upload_date":"2023-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-28 21:39:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"152644","created_at":"2025-03-17T19:20:52.000000Z","updated_at":"2025-03-17T19:20:52.000000Z","inspection_violations":[{"id":4483506,"change_date":"2023-04-28 21:39:00","inspection_id":"78481792","insp_violation_id":"252515174","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194652288","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:55.000000Z","updated_at":"2025-03-17T21:27:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4699812,"change_date":"2023-04-28 21:39:00","inspection_id":"78481792","insp_unit_id":"194652288","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL226","insp_unit_license":"81475L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML9GL139859","insp_unit_decal":"Y","insp_unit_decal_number":"32461146","created_at":"2025-03-17T22:40:02.000000Z","updated_at":"2025-03-17T22:40:02.000000Z"}]},{"id":2618307,"change_date":"2023-03-20 21:41:00","inspection_id":"78137459","dot_number":"2734185","report_state":"CA","report_number":"NCCL004568","insp_date":"2023-03-13 00:00:00","insp_start_time":"1145","insp_end_time":"1225","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14823451","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-20 21:41:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-03-17T19:14:54.000000Z","updated_at":"2025-03-17T19:14:54.000000Z","inspection_violations":[{"id":4027475,"change_date":"2023-03-20 21:41:00","inspection_id":"78137459","insp_violation_id":"251766720","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"193966528","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"39345D"},{"id":4027476,"change_date":"2023-03-20 21:41:00","inspection_id":"78137459","insp_violation_id":"251766721","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193966528","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"3922"},{"id":4027477,"change_date":"2023-03-20 21:41:00","inspection_id":"78137459","insp_violation_id":"251766722","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193966528","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":4215224,"change_date":"2023-03-20 21:41:00","inspection_id":"78137459","insp_unit_id":"193966528","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL211WHT2X","insp_unit_license":"21473N3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL068558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:15.000000Z","updated_at":"2025-03-17T22:36:15.000000Z"}]},{"id":2618794,"change_date":"2023-03-20 21:41:00","inspection_id":"78137977","dot_number":"2734185","report_state":"CA","report_number":"NE8I002010","insp_date":"2023-03-13 00:00:00","insp_start_time":"1543","insp_end_time":"1626","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":"2023-03-20 21:41: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":"14823568","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-20 21:41:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:54.000000Z","updated_at":"2025-03-17T19:14:54.000000Z","inspection_violations":[{"id":4027989,"change_date":"2023-03-20 21:41:00","inspection_id":"78137977","insp_violation_id":"251767293","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193967310","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":4215914,"change_date":"2023-03-20 21:41:00","inspection_id":"78137977","insp_unit_id":"193967310","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL21\/WHITE","insp_unit_license":"21473N3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL068558","insp_unit_decal":"Y","insp_unit_decal_number":"32148265","created_at":"2025-03-17T22:36:15.000000Z","updated_at":"2025-03-17T22:36:15.000000Z"}]},{"id":2527548,"change_date":"2023-03-07 21:42:00","inspection_id":"78034081","dot_number":"2734185","report_state":"CA","report_number":"NCCL004539","insp_date":"2023-03-03 00:00:00","insp_start_time":"1005","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"14810966","transaction_code":"A","transaction_date":"2023-03-03 00:00:00","upload_date":"2023-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-07 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"152644","created_at":"2025-03-17T19:13:19.000000Z","updated_at":"2025-03-17T19:13:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4068499,"change_date":"2023-03-07 21:42:00","inspection_id":"78034081","insp_unit_id":"193756886","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT 2X","insp_unit_license":"20869P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMMLXGL743288","insp_unit_decal":"Y","insp_unit_decal_number":"32148018","created_at":"2025-03-17T22:35:09.000000Z","updated_at":"2025-03-17T22:35:09.000000Z"}]},{"id":2527944,"change_date":"2023-03-07 21:42:00","inspection_id":"78034509","dot_number":"2734185","report_state":"CA","report_number":"NE7S001858","insp_date":"2023-03-03 00:00:00","insp_start_time":"0800","insp_end_time":"0840","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":"2023-03-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14810764","transaction_code":"A","transaction_date":"2023-03-03 00:00:00","upload_date":"2023-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-07 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"152644","created_at":"2025-03-17T19:13:19.000000Z","updated_at":"2025-03-17T19:13:19.000000Z","inspection_violations":[{"id":3886489,"change_date":"2023-03-07 21:42:00","inspection_id":"78034509","insp_violation_id":"251530777","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"193757512","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CW 951402","created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":4069044,"change_date":"2023-03-07 21:42:00","inspection_id":"78034509","insp_unit_id":"193757512","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"20869P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMMLXGL743288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:09.000000Z","updated_at":"2025-03-17T22:35:09.000000Z"}]},{"id":2463444,"change_date":"2023-02-27 21:42:00","inspection_id":"77961195","dot_number":"2734185","report_state":"CA","report_number":"NE7S001827","insp_date":"2023-02-21 00:00:00","insp_start_time":"0843","insp_end_time":"0917","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":"2023-02-27 21:42: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":"14799198","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-27 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"152644","created_at":"2025-03-17T19:12:06.000000Z","updated_at":"2025-03-17T19:12:06.000000Z","inspection_violations":[{"id":3793268,"change_date":"2023-02-27 21:42:00","inspection_id":"77961195","insp_violation_id":"251371084","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193609919","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3964809,"change_date":"2023-02-27 21:42:00","inspection_id":"77961195","insp_unit_id":"193609919","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"81671L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML5GL139860","insp_unit_decal":"Y","insp_unit_decal_number":"32147929","created_at":"2025-03-17T22:34:23.000000Z","updated_at":"2025-03-17T22:34:23.000000Z"}]},{"id":2320306,"change_date":"2023-02-07 21:41:00","inspection_id":"77797703","dot_number":"2734185","report_state":"CA","report_number":"UFA3000400","insp_date":"2023-02-02 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"PT","ci_status_code":"C","location":"882","location_desc":"WB ANTELPOPE SCALE","county_code_state":"CA","county_code":"067","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"14774950","transaction_code":"A","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-07 21:41:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"152644","created_at":"2025-03-17T19:09:35.000000Z","updated_at":"2025-03-17T19:09:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3734614,"change_date":"2023-02-07 21:41:00","inspection_id":"77797703","insp_unit_id":"193283036","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL214","insp_unit_license":"81474L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL068561","insp_unit_decal":"Y","insp_unit_decal_number":"32131692","created_at":"2025-03-17T22:32:44.000000Z","updated_at":"2025-03-17T22:32:44.000000Z"}]},{"id":1811035,"change_date":"2022-11-23 21:40:00","inspection_id":"77216047","dot_number":"2734185","report_state":"CA","report_number":"UBVX002021","insp_date":"2022-11-22 00:00:00","insp_start_time":"1555","insp_end_time":"1621","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"MARIN AREA","county_code_state":"CA","county_code":"041","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":"2022-11-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"14684040","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-03-17T19:00:00.000000Z","updated_at":"2025-03-17T19:00:00.000000Z","inspection_violations":[{"id":2832739,"change_date":"2022-11-23 21:40:00","inspection_id":"77216047","insp_violation_id":"249780684","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"192120337","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW639125","created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39021TB"},{"id":2832740,"change_date":"2022-11-23 21:40:00","inspection_id":"77216047","insp_violation_id":"249780685","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192120337","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LU76094","created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2913253,"change_date":"2022-11-23 21:40:00","inspection_id":"77216047","insp_unit_id":"192120337","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL261","insp_unit_license":"20869P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMMLXGL743288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:56.000000Z","updated_at":"2025-03-17T22:26:56.000000Z"}]},{"id":1827374,"change_date":"2022-11-28 21:42:00","inspection_id":"77234635","dot_number":"2734185","report_state":"CA","report_number":"NE8I001659","insp_date":"2022-11-21 00:00:00","insp_start_time":"1422","insp_end_time":"1512","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14686476","transaction_code":"A","transaction_date":"2022-11-21 00:00:00","upload_date":"2022-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-28 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"152644","created_at":"2025-03-17T19:00:20.000000Z","updated_at":"2025-03-17T19:00:20.000000Z","inspection_violations":[{"id":2854780,"change_date":"2022-11-28 21:42:00","inspection_id":"77234635","insp_violation_id":"249815218","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192156368","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:31.000000Z","updated_at":"2025-03-17T21:20:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2940154,"change_date":"2022-11-28 21:42:00","inspection_id":"77234635","insp_unit_id":"192156368","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"PL262","insp_unit_license":"16224W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL743289","insp_unit_decal":"Y","insp_unit_decal_number":"31826452","created_at":"2025-03-17T22:27:08.000000Z","updated_at":"2025-03-17T22:27:08.000000Z"}]},{"id":1491925,"change_date":"2022-10-11 21:42:00","inspection_id":"76849405","dot_number":"2734185","report_state":"CA","report_number":"NE7S001392","insp_date":"2022-10-07 00:00:00","insp_start_time":"0821","insp_end_time":"0846","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-11 21:42: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":"14628798","transaction_code":"A","transaction_date":"2022-10-07 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-11 21:42:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"599512","created_at":"2025-03-17T18:54:09.000000Z","updated_at":"2025-03-17T18:54:09.000000Z","inspection_violations":[{"id":2348749,"change_date":"2022-10-11 21:42:00","inspection_id":"76849405","insp_violation_id":"248966867","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191387117","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2401179,"change_date":"2022-10-11 21:42:00","inspection_id":"76849405","insp_unit_id":"191387117","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"81474L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL068561","insp_unit_decal":"Y","insp_unit_decal_number":"31825376","created_at":"2025-03-17T22:23:27.000000Z","updated_at":"2025-03-17T22:23:27.000000Z"}]},{"id":676360,"change_date":"2022-06-22 21:41:00","inspection_id":"75898521","dot_number":"2734185","report_state":"CA","report_number":"NEEU000240","insp_date":"2022-06-21 00:00:00","insp_start_time":"2004","insp_end_time":"2036","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"14479074","transaction_code":"A","transaction_date":"2022-06-22 00:00:00","upload_date":"2022-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-22 21:41:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:33.000000Z","updated_at":"2025-03-17T18:39:33.000000Z","inspection_violations":[{"id":1064375,"change_date":"2022-06-22 21:41:00","inspection_id":"75898521","insp_violation_id":"246666023","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189418155","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:01.000000Z","updated_at":"2025-03-17T21:12:01.000000Z","normalized_code":"3922"},{"id":1064376,"change_date":"2022-06-22 21:41:00","inspection_id":"75898521","insp_violation_id":"246666024","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189418155","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:01.000000Z","updated_at":"2025-03-17T21:12:01.000000Z","normalized_code":"3963A1"},{"id":1064377,"change_date":"2022-06-22 21:41:00","inspection_id":"75898521","insp_violation_id":"246666025","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189418155","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW952105","created_at":"2025-03-17T21:12:01.000000Z","updated_at":"2025-03-17T21:12:01.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1087118,"change_date":"2022-06-22 21:41:00","inspection_id":"75898521","insp_unit_id":"189418155","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"PL227\/2X","insp_unit_license":"BW82C13","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML5GL139860","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:53.000000Z","updated_at":"2025-03-17T22:14:53.000000Z"}]},{"id":464524,"change_date":"2022-05-23 21:43:00","inspection_id":"75646998","dot_number":"2734185","report_state":"CA","report_number":"NARW000393","insp_date":"2022-05-19 00:00:00","insp_start_time":"1353","insp_end_time":"1418","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"14439878","transaction_code":"A","transaction_date":"2022-05-19 00:00:00","upload_date":"2022-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02734185","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-23 21:43:00","insp_carrier_name":"ADVANCED INSTALLATION SERVICES INC","insp_carrier_street":"2855 VOLPEY WAY","insp_carrier_city":"UNION CITY","insp_carrier_state":"CA","insp_carrier_zip_code":"94587","insp_colonia":null,"docket_number":"944853","insp_interstate":"N","insp_carrier_state_id":"152644","created_at":"2025-03-17T18:35:56.000000Z","updated_at":"2025-03-17T18:35:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":748680,"change_date":"2022-05-23 21:43:00","inspection_id":"75646998","insp_unit_id":"188867989","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT\/2X","insp_unit_license":"16224W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML1GL743289","insp_unit_decal":"Y","insp_unit_decal_number":"31107182","created_at":"2025-03-17T22:12:48.000000Z","updated_at":"2025-03-17T22:12:48.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2734185\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2734185\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2734185\/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\/2734185\/inspections","per_page":100,"prev_page_url":null,"to":58,"total":58}