{"current_page":1,"data":[{"id":12555199,"change_date":"2026-07-27 21:38:00","inspection_id":"88522439","dot_number":"2614731","report_state":"CA","report_number":"NCNG010434","insp_date":"2026-07-24 00:00:00","insp_start_time":"1545","insp_end_time":"1602","registration_date":null,"region":"PD","ci_status_code":"C","location":"366","location_desc":"CA","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","shipping_paper_number":"138176","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-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"3842026","transaction_code":"A","transaction_date":"2026-07-27 00:00:00","upload_date":"2026-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2026-07-27 21:38:00","snet_input_date":"2026-07-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-27 21:38:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2026-07-30T09:39:54.000000Z","updated_at":"2026-08-07T09:30:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21801131,"change_date":"2026-07-27 21:38:00","inspection_id":"88522439","insp_unit_id":"214829082","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE","insp_unit_license":"03779G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W172G7F00918","insp_unit_decal":"Y","insp_unit_decal_number":"36518503","created_at":"2026-07-30T09:17:14.000000Z","updated_at":"2026-08-07T09:01:28.000000Z"}]},{"id":12353344,"change_date":"2026-07-03 21:37:00","inspection_id":"88314473","dot_number":"2614731","report_state":"CA","report_number":"UF52000673","insp_date":"2026-07-02 00:00:00","insp_start_time":"1915","insp_end_time":"1930","registration_date":null,"region":"PD","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-03 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","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":"3677764","transaction_code":"A","transaction_date":"2026-07-03 00:00:00","upload_date":"2026-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2026-07-03 21:37:00","snet_input_date":"2026-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-03 21:37:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2026-07-06T09:43:20.000000Z","updated_at":"2026-07-14T09:32:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21452618,"change_date":"2026-07-03 21:37:00","inspection_id":"88314473","insp_unit_id":"214437307","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHI2X","insp_unit_license":"38804U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4T172C7W00264","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-06T09:21:36.000000Z","updated_at":"2026-07-14T09:04:14.000000Z"}]},{"id":12162751,"change_date":"2026-06-11 21:42:00","inspection_id":"88112631","dot_number":"2614731","report_state":"CA","report_number":"UEXA002656","insp_date":"2026-06-11 00:00:00","insp_start_time":"1000","insp_end_time":"1014","registration_date":null,"region":"PS","ci_status_code":"C","location":"347","location_desc":"CA","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COACH AUTO","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":"U","pen_cen_match":"I","final_status_date":"2026-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","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":"3522920","transaction_code":"A","transaction_date":"2026-06-11 00:00:00","upload_date":"2026-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2026-06-11 21:42:00","snet_input_date":"2026-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-11 21:42:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2026-06-15T09:41:35.000000Z","updated_at":"2026-06-22T09:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21127113,"change_date":"2026-06-11 21:42:00","inspection_id":"88112631","insp_unit_id":"214043664","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"38804U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4T172C7W00264","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-15T09:19:29.000000Z","updated_at":"2026-06-22T09:02:53.000000Z"}]},{"id":12091660,"change_date":"2026-06-04 21:45:00","inspection_id":"88035541","dot_number":"2614731","report_state":"CA","report_number":"NE8I005377","insp_date":"2026-06-01 00:00:00","insp_start_time":"1652","insp_end_time":"1712","registration_date":null,"region":"PS","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-06-04 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3460027","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2026-06-04 21:45:00","snet_input_date":"2026-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:45:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2026-06-07T09:40:42.000000Z","updated_at":"2026-06-16T09:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21010953,"change_date":"2026-06-04 21:45:00","inspection_id":"88035541","insp_unit_id":"213902821","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHITE","insp_unit_license":"37720E4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"Y","insp_unit_decal_number":"36190056","created_at":"2026-06-07T09:17:41.000000Z","updated_at":"2026-06-16T09:01:52.000000Z"}]},{"id":11228969,"change_date":"2026-02-25 21:49:00","inspection_id":"87141087","dot_number":"2614731","report_state":"CA","report_number":"UEW3000190","insp_date":"2026-02-24 00:00:00","insp_start_time":"1220","insp_end_time":"1250","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"WB 80 PLATFORM SCALES","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":"Y","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-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"16183786","transaction_code":"A","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2026-02-25 21:49:00","snet_input_date":"2026-02-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2026-02-28T10:39:30.000000Z","updated_at":"2026-03-08T09:32:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19194554,"change_date":"2026-02-25 21:49:00","inspection_id":"87141087","insp_unit_id":"211837694","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"03779G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W172G7F00918","insp_unit_decal":"Y","insp_unit_decal_number":"35886812","created_at":"2026-02-28T10:15:23.000000Z","updated_at":"2026-03-08T09:07:18.000000Z"}]},{"id":10849438,"change_date":"2026-01-23 21:39:00","inspection_id":"86878333","dot_number":"2614731","report_state":"CA","report_number":"UE03004572","insp_date":"2026-01-22 00:00:00","insp_start_time":"2100","insp_end_time":"2124","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"LIVERMORE","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":"2026-01-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16142186","transaction_code":"A","transaction_date":"2026-01-22 00:00:00","upload_date":"2026-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2026-01-23 21:39:00","snet_input_date":"2026-01-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-23 21:39:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2026-01-26T10:37:37.000000Z","updated_at":"2026-02-03T10:30:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18229055,"change_date":"2026-01-23 21:39:00","inspection_id":"86878333","insp_unit_id":"211267534","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2AX","insp_unit_license":"03779G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W172G7F00918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-26T10:09:58.000000Z","updated_at":"2026-02-03T10:03:14.000000Z"}]},{"id":10443793,"change_date":"2025-12-15 21:40:00","inspection_id":"86575990","dot_number":"2614731","report_state":"CA","report_number":"UD8R000139","insp_date":"2025-12-13 00:00:00","insp_start_time":"1045","insp_end_time":"1115","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":"2025-12-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16094824","transaction_code":"A","transaction_date":"2025-12-13 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2025-12-15 21:40:00","snet_input_date":"2025-12-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-15 21:40:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-12-18T10:30:51.000000Z","updated_at":"2025-12-26T10:31:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17471689,"change_date":"2025-12-15 21:40:00","inspection_id":"86575990","insp_unit_id":"210625209","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"56772X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165G7001233","insp_unit_decal":"Y","insp_unit_decal_number":"35618628","created_at":"2025-12-18T10:00:42.000000Z","updated_at":"2025-12-26T10:01:42.000000Z"}]},{"id":9942591,"change_date":"2025-10-14 21:42:00","inspection_id":"86049747","dot_number":"2614731","report_state":"CA","report_number":"N8AH006225","insp_date":"2025-10-13 00:00:00","insp_start_time":"1750","insp_end_time":"1808","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16017675","transaction_code":"A","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2025-10-14 21:42:00","snet_input_date":"2025-10-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-14 21:42:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2025-10-17T10:01:54.000000Z","updated_at":"2025-10-18T10:01:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16503930,"change_date":"2025-10-14 21:42:00","inspection_id":"86049747","insp_unit_id":"209471382","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT","insp_unit_license":"03778G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-17T09:46:58.000000Z","updated_at":"2025-10-18T09:46:50.000000Z"}]},{"id":9991535,"change_date":"2025-10-20 21:40:00","inspection_id":"86101206","dot_number":"2614731","report_state":"CA","report_number":"UE9B003361","insp_date":"2025-10-08 00:00:00","insp_start_time":"1642","insp_end_time":"1712","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-10-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16024238","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2025-10-20 21:40:00","snet_input_date":"2025-10-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-20 21:40:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-10-23T10:00:48.000000Z","updated_at":"2025-10-24T10:01:33.000000Z","inspection_violations":[{"id":16509885,"change_date":"2025-10-20 21:40:00","inspection_id":"86101206","insp_violation_id":"269412973","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"209566853","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:16:14.000000Z","updated_at":"2025-10-24T10:17:32.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":16591797,"change_date":"2025-10-20 21:40:00","inspection_id":"86101206","insp_unit_id":"209566853","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X WHT","insp_unit_license":"38804U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4T172C7W00264","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:46:03.000000Z","updated_at":"2025-10-24T09:46:51.000000Z"}]},{"id":9280100,"change_date":"2025-07-29 21:40:00","inspection_id":"85353381","dot_number":"2614731","report_state":"CA","report_number":"NCEB008408","insp_date":"2025-07-22 00:00:00","insp_start_time":"1912","insp_end_time":"1925","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15918025","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2025-07-29 21:40:00","snet_input_date":"2025-07-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-29 21:40:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2025-08-01T10:42:12.000000Z","updated_at":"2025-08-04T10:00:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15277372,"change_date":"2025-07-29 21:40:00","inspection_id":"85353381","insp_unit_id":"208143380","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE","insp_unit_license":"03778G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"Y","insp_unit_decal_number":"35369026","created_at":"2025-08-01T09:45:50.000000Z","updated_at":"2025-08-02T09:46:14.000000Z"}]},{"id":8899577,"change_date":"2025-06-13 21:41:00","inspection_id":"84952302","dot_number":"2614731","report_state":"CA","report_number":"NE8I004471","insp_date":"2025-06-11 00:00:00","insp_start_time":"1925","insp_end_time":"1944","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-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15860682","transaction_code":"A","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2025-06-13 21:41:00","snet_input_date":"2025-06-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-13 21:41:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-06-16T10:01:16.000000Z","updated_at":"2025-06-17T10:00:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14579895,"change_date":"2025-06-13 21:41:00","inspection_id":"84952302","insp_unit_id":"207386860","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHITE","insp_unit_license":"56773X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166G7001242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-16T09:46:43.000000Z","updated_at":"2025-06-17T09:46:10.000000Z"}]},{"id":8888801,"change_date":"2025-06-12 21:42:00","inspection_id":"84940727","dot_number":"2614731","report_state":"CA","report_number":"UDBL004520","insp_date":"2025-06-10 00:00:00","insp_start_time":"1343","insp_end_time":"1402","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 EASTBOUND, 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":"2025-06-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15858987","transaction_code":"A","transaction_date":"2025-06-10 00:00:00","upload_date":"2025-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2025-06-12 21:42:00","snet_input_date":"2025-06-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-12 21:42:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-06-15T10:01:14.000000Z","updated_at":"2025-06-16T10:00:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14561039,"change_date":"2025-06-12 21:42:00","inspection_id":"84940727","insp_unit_id":"207365935","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2XWHTBX","insp_unit_license":"56772X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165G7001233","insp_unit_decal":"Y","insp_unit_decal_number":"35063017","created_at":"2025-06-15T09:46:35.000000Z","updated_at":"2025-06-16T09:46:28.000000Z"}]},{"id":8621922,"change_date":"2025-05-13 21:41:00","inspection_id":"84658765","dot_number":"2614731","report_state":"CA","report_number":"NFHS000174","insp_date":"2025-05-07 00:00:00","insp_start_time":"2002","insp_end_time":"2055","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15816348","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2025-05-13 21:41:00","snet_input_date":"2025-05-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-13 21:41:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-05-17T10:04:23.000000Z","updated_at":"2025-05-17T10:09:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14077861,"change_date":"2025-05-13 21:41:00","inspection_id":"84658765","insp_unit_id":"206838998","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHT","insp_unit_license":"56772X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165G7001233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-16T09:49:53.000000Z","updated_at":"2025-05-17T09:51:51.000000Z"}]},{"id":8037603,"change_date":"2025-03-05 21:40:00","inspection_id":"84043287","dot_number":"2614731","report_state":"CA","report_number":"NDMK006072","insp_date":"2025-03-04 00:00:00","insp_start_time":"1102","insp_end_time":"1123","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-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15727733","transaction_code":"A","transaction_date":"2025-03-04 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2025-03-05 21:40:00","snet_input_date":"2025-03-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2025-03-17T21:04:59.000000Z","updated_at":"2025-03-17T21:04:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12976245,"change_date":"2025-03-05 21:40:00","inspection_id":"84043287","insp_unit_id":"205647503","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"03779G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W172G7F00918","insp_unit_decal":"Y","insp_unit_decal_number":"34774058","created_at":"2025-03-17T23:58:21.000000Z","updated_at":"2025-03-17T23:58:21.000000Z"}]},{"id":7846734,"change_date":"2025-02-11 21:40:00","inspection_id":"83843055","dot_number":"2614731","report_state":"CA","report_number":"NEAH004690","insp_date":"2025-02-05 00:00:00","insp_start_time":"1618","insp_end_time":"1631","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15699690","transaction_code":"A","transaction_date":"2025-02-05 00:00:00","upload_date":"2025-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2025-02-11 21:40:00","snet_input_date":"2025-02-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-03-17T21:01:10.000000Z","updated_at":"2025-03-17T21:01:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12664066,"change_date":"2025-02-11 21:40:00","inspection_id":"83843055","insp_unit_id":"205278989","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT","insp_unit_license":"03778G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"Y","insp_unit_decal_number":"34823635","created_at":"2025-03-17T23:54:52.000000Z","updated_at":"2025-03-17T23:54:52.000000Z"}]},{"id":7502383,"change_date":"2024-12-26 21:37:00","inspection_id":"83481322","dot_number":"2614731","report_state":"CA","report_number":"NF9T000662","insp_date":"2024-12-20 00:00:00","insp_start_time":"1502","insp_end_time":"1528","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-12-26 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"15642525","transaction_code":"A","transaction_date":"2024-12-20 00:00:00","upload_date":"2024-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2024-12-26 21:37:00","snet_input_date":"2024-12-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-26 21:37:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2025-03-17T20:52:39.000000Z","updated_at":"2025-03-17T20:52:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12103084,"change_date":"2024-12-26 21:37:00","inspection_id":"83481322","insp_unit_id":"204559802","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHT","insp_unit_license":"03779G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W172G7F00918","insp_unit_decal":"Y","insp_unit_decal_number":"34476381","created_at":"2025-03-17T23:48:37.000000Z","updated_at":"2025-03-17T23:48:37.000000Z"}]},{"id":7397065,"change_date":"2024-12-11 21:42:00","inspection_id":"83370595","dot_number":"2614731","report_state":"CA","report_number":"NBGW007298","insp_date":"2024-12-06 00:00:00","insp_start_time":"1552","insp_end_time":"1605","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-12-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15625663","transaction_code":"A","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2024-12-11 21:42:00","snet_input_date":"2024-12-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-11 21:42:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2025-03-17T20:50:20.000000Z","updated_at":"2025-03-17T20:50:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11932933,"change_date":"2024-12-11 21:42:00","inspection_id":"83370595","insp_unit_id":"204332947","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"1","insp_unit_license":"38804U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4T172C7W00264","insp_unit_decal":"Y","insp_unit_decal_number":"34517571","created_at":"2025-03-17T23:46:44.000000Z","updated_at":"2025-03-17T23:46:44.000000Z"}]},{"id":7186748,"change_date":"2024-11-13 21:40:00","inspection_id":"83148814","dot_number":"2614731","report_state":"CA","report_number":"N5Y3006669","insp_date":"2024-11-12 00:00:00","insp_start_time":"1430","insp_end_time":"1445","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":"COACH AUTOMOTIVE","shipping_paper_number":"MULTIPLE","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-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"15591791","transaction_code":"A","transaction_date":"2024-11-12 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2024-11-13 21:40:00","snet_input_date":"2024-11-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-13 21:40:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2025-03-17T20:46:00.000000Z","updated_at":"2025-03-17T20:46:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11592079,"change_date":"2024-11-13 21:40:00","inspection_id":"83148814","insp_unit_id":"203866671","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHI","insp_unit_license":"03778G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"Y","insp_unit_decal_number":"34515488","created_at":"2025-03-17T23:43:07.000000Z","updated_at":"2025-03-17T23:43:07.000000Z"}]},{"id":6830885,"change_date":"2024-09-26 21:41:00","inspection_id":"82771044","dot_number":"2614731","report_state":"CA","report_number":"UCOB006277","insp_date":"2024-09-25 00:00:00","insp_start_time":"1245","insp_end_time":"1317","registration_date":null,"region":"PT","ci_status_code":"C","location":"9391","location_desc":"E\/B I-580 LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15535913","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2024-09-26 21:41:00","snet_input_date":"2024-09-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-26 21:41:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2025-03-17T20:38:36.000000Z","updated_at":"2025-03-17T20:38:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11015744,"change_date":"2024-09-26 21:41:00","inspection_id":"82771044","insp_unit_id":"203152809","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"03779G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W172G7F00918","insp_unit_decal":"Y","insp_unit_decal_number":"34150986","created_at":"2025-03-17T23:37:06.000000Z","updated_at":"2025-03-17T23:37:06.000000Z"}]},{"id":6408038,"change_date":"2024-08-06 21:44:00","inspection_id":"82320444","dot_number":"2614731","report_state":"CA","report_number":"UEWW000278","insp_date":"2024-08-05 00:00:00","insp_start_time":"1947","insp_end_time":"2003","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-08-06 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","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":"15472928","transaction_code":"A","transaction_date":"2024-08-05 00:00:00","upload_date":"2024-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2024-08-06 21:44:00","snet_input_date":"2024-08-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-06 21:44:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2025-03-17T20:29:52.000000Z","updated_at":"2025-03-17T20:29:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10327226,"change_date":"2024-08-06 21:44:00","inspection_id":"82320444","insp_unit_id":"202270708","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X","insp_unit_license":"38804U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4T172C7W00264","insp_unit_decal":"Y","insp_unit_decal_number":"34197544","created_at":"2025-03-17T23:30:01.000000Z","updated_at":"2025-03-17T23:30:01.000000Z"}]},{"id":6010997,"change_date":"2024-06-17 21:46:00","inspection_id":"81894325","dot_number":"2614731","report_state":"CA","report_number":"NE7S003328","insp_date":"2024-06-13 00:00:00","insp_start_time":"1842","insp_end_time":"1858","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-17 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"15406259","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2024-06-17 21:46:00","snet_input_date":"2024-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-17 21:46:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-03-17T20:21:52.000000Z","updated_at":"2025-03-17T20:21:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9681624,"change_date":"2024-06-17 21:46:00","inspection_id":"81894325","insp_unit_id":"201453198","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE\/2AX","insp_unit_license":"03778G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"Y","insp_unit_decal_number":"33878427","created_at":"2025-03-17T23:23:21.000000Z","updated_at":"2025-03-17T23:23:21.000000Z"}]},{"id":5703243,"change_date":"2024-05-08 21:43:00","inspection_id":"81560392","dot_number":"2614731","report_state":"CA","report_number":"ND4P006912","insp_date":"2024-05-07 00:00:00","insp_start_time":"1611","insp_end_time":"1626","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-05-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15353698","transaction_code":"A","transaction_date":"2024-05-07 00:00:00","upload_date":"2024-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2024-05-08 21:43:00","snet_input_date":"2024-05-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-08 21:43:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"0262372","created_at":"2025-03-17T20:15:51.000000Z","updated_at":"2025-03-17T20:15:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9186082,"change_date":"2024-05-08 21:43:00","inspection_id":"81560392","insp_unit_id":"200798347","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE","insp_unit_license":"56773X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166G7001242","insp_unit_decal":"Y","insp_unit_decal_number":"33810429","created_at":"2025-03-17T23:18:30.000000Z","updated_at":"2025-03-17T23:18:30.000000Z"}]},{"id":5525673,"change_date":"2024-04-16 21:42:00","inspection_id":"81367134","dot_number":"2614731","report_state":"CA","report_number":"NDKW006184","insp_date":"2024-04-15 00:00:00","insp_start_time":"1550","insp_end_time":"1617","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-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15320146","transaction_code":"A","transaction_date":"2024-04-15 00:00:00","upload_date":"2024-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2024-04-16 21:42:00","snet_input_date":"2024-04-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-16 21:42:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-03-17T20:12:19.000000Z","updated_at":"2025-03-17T20:12:19.000000Z","inspection_violations":[{"id":8537725,"change_date":"2024-04-16 21:42:00","inspection_id":"81367134","insp_violation_id":"258966906","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"200428953","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:21.000000Z","updated_at":"2025-03-17T21:47:21.000000Z","normalized_code":"39021TB"},{"id":8537726,"change_date":"2024-04-16 21:42:00","inspection_id":"81367134","insp_violation_id":"258966907","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"200428953","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:21.000000Z","updated_at":"2025-03-17T21:47:21.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":8900994,"change_date":"2024-04-16 21:42:00","inspection_id":"81367134","insp_unit_id":"200428953","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X \/ WHT","insp_unit_license":"03779G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W172G7F00918","insp_unit_decal":"Y","insp_unit_decal_number":"33809501","created_at":"2025-03-17T23:15:50.000000Z","updated_at":"2025-03-17T23:15:50.000000Z"}]},{"id":5156998,"change_date":"2024-02-28 21:42:00","inspection_id":"80964891","dot_number":"2614731","report_state":"CA","report_number":"N5Y3005361","insp_date":"2024-01-23 00:00:00","insp_start_time":"1320","insp_end_time":"1335","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":"MULTIPLE DEALERSHIPS","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"15259132","transaction_code":"A","transaction_date":"2024-01-23 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2024-02-28 21:42:00","snet_input_date":"2024-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:42:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2025-03-17T20:04:36.000000Z","updated_at":"2025-03-17T20:04:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8303699,"change_date":"2024-02-28 21:42:00","inspection_id":"80964891","insp_unit_id":"199648005","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHI","insp_unit_license":"03778G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"Y","insp_unit_decal_number":"33571802","created_at":"2025-03-17T23:10:14.000000Z","updated_at":"2025-03-17T23:10:14.000000Z"}]},{"id":4646120,"change_date":"2023-12-15 21:39:00","inspection_id":"80406435","dot_number":"2614731","report_state":"CA","report_number":"UE7F001473","insp_date":"2023-12-11 00:00:00","insp_start_time":"1901","insp_end_time":"1928","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-12-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"15168927","transaction_code":"A","transaction_date":"2023-12-11 00:00:00","upload_date":"2023-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2023-12-15 21:39:00","snet_input_date":"2023-12-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-15 21:39:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-03-17T19:54:56.000000Z","updated_at":"2025-03-17T19:54:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7472439,"change_date":"2023-12-15 21:39:00","inspection_id":"80406435","insp_unit_id":"198539201","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X","insp_unit_license":"38804U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4T172C7W00264","insp_unit_decal":"Y","insp_unit_decal_number":"33212630","created_at":"2025-03-17T23:02:49.000000Z","updated_at":"2025-03-17T23:02:49.000000Z"}]},{"id":4318256,"change_date":"2023-10-30 21:43:00","inspection_id":"80045380","dot_number":"2614731","report_state":"CA","report_number":"NEAH002604","insp_date":"2023-10-24 00:00:00","insp_start_time":"1630","insp_end_time":"1645","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15117155","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2023-10-30 21:43:00","snet_input_date":"2023-10-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-30 21:43:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"0262372","created_at":"2025-03-17T19:48:25.000000Z","updated_at":"2025-03-17T19:48:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6945251,"change_date":"2023-10-30 21:43:00","inspection_id":"80045380","insp_unit_id":"197825137","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT","insp_unit_license":"03778G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"Y","insp_unit_decal_number":"33268890","created_at":"2025-03-17T22:58:18.000000Z","updated_at":"2025-03-17T22:58:18.000000Z"}]},{"id":4209054,"change_date":"2023-10-16 21:43:00","inspection_id":"79924679","dot_number":"2614731","report_state":"CA","report_number":"NC3S007305","insp_date":"2023-10-03 00:00:00","insp_start_time":"1216","insp_end_time":"1231","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-10-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15096936","transaction_code":"A","transaction_date":"2023-10-03 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2023-10-16 21:43:00","snet_input_date":"2023-10-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-03-17T19:46:14.000000Z","updated_at":"2025-03-17T19:46:14.000000Z","inspection_violations":[{"id":6517979,"change_date":"2023-10-16 21:43:00","inspection_id":"79924679","insp_violation_id":"255867988","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"197582828","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:24.000000Z","updated_at":"2025-03-17T21:37:24.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":6769023,"change_date":"2023-10-16 21:43:00","inspection_id":"79924679","insp_unit_id":"197582828","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT","insp_unit_license":"56773X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166G7001242","insp_unit_decal":"Y","insp_unit_decal_number":"33202992","created_at":"2025-03-17T22:56:44.000000Z","updated_at":"2025-03-17T22:56:44.000000Z"}]},{"id":3740293,"change_date":"2023-08-14 21:43:00","inspection_id":"79403344","dot_number":"2614731","report_state":"CA","report_number":"NCEB005743","insp_date":"2023-07-11 00:00:00","insp_start_time":"1753","insp_end_time":"1805","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-14 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":"15020272","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2023-08-14 21:43:00","snet_input_date":"2023-07-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-14 21:43:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2025-03-17T19:36:51.000000Z","updated_at":"2025-03-17T19:36:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6014302,"change_date":"2023-08-14 21:43:00","inspection_id":"79403344","insp_unit_id":"196525063","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE","insp_unit_license":"03778G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"Y","insp_unit_decal_number":"32914963","created_at":"2025-03-17T22:50:32.000000Z","updated_at":"2025-03-17T22:50:32.000000Z"}]},{"id":3474186,"change_date":"2023-07-10 21:43:00","inspection_id":"79105253","dot_number":"2614731","report_state":"CA","report_number":"UFPH000822","insp_date":"2023-07-06 00:00:00","insp_start_time":"2150","insp_end_time":"2215","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-07-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","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":"14973787","transaction_code":"A","transaction_date":"2023-07-06 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2023-07-10 21:43:00","snet_input_date":"2023-07-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-10 21:43:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2025-03-17T19:31:43.000000Z","updated_at":"2025-03-17T19:31:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5586586,"change_date":"2023-07-10 21:43:00","inspection_id":"79105253","insp_unit_id":"195922431","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2XL WHT","insp_unit_license":"38804U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4T172C7W00264","insp_unit_decal":"Y","insp_unit_decal_number":"32855062","created_at":"2025-03-17T22:47:06.000000Z","updated_at":"2025-03-17T22:47:06.000000Z"}]},{"id":3316918,"change_date":"2023-06-19 21:36:00","inspection_id":"78928445","dot_number":"2614731","report_state":"CA","report_number":"UFD9000973","insp_date":"2023-06-16 00:00:00","insp_start_time":"2020","insp_end_time":"2044","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-19 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"14948464","transaction_code":"A","transaction_date":"2023-06-16 00:00:00","upload_date":"2023-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2023-06-19 21:36:00","snet_input_date":"2023-06-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-19 21:36:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-03-17T19:28:34.000000Z","updated_at":"2025-03-17T19:28:34.000000Z","inspection_violations":[{"id":5116400,"change_date":"2023-06-19 21:36:00","inspection_id":"78928445","insp_violation_id":"253584979","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195568527","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KL41777","created_at":"2025-03-17T21:30:45.000000Z","updated_at":"2025-03-17T21:30:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5332538,"change_date":"2023-06-19 21:36:00","inspection_id":"78928445","insp_unit_id":"195568527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X WHI","insp_unit_license":"03778G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:03.000000Z","updated_at":"2025-03-17T22:45:03.000000Z"}]},{"id":2537718,"change_date":"2023-03-08 21:41:00","inspection_id":"78045513","dot_number":"2614731","report_state":"CA","report_number":"NDZ5003069","insp_date":"2023-03-07 00:00:00","insp_start_time":"1657","insp_end_time":"1721","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-03-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","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":"14811139","transaction_code":"A","transaction_date":"2023-03-07 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2023-03-08 21:41:00","snet_input_date":"2023-03-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-08 21:41:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"0262372","created_at":"2025-03-17T19:13:23.000000Z","updated_at":"2025-03-17T19:13:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4084855,"change_date":"2023-03-08 21:41:00","inspection_id":"78045513","insp_unit_id":"193779211","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT.","insp_unit_license":"38804U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4T172C7W00264","insp_unit_decal":"Y","insp_unit_decal_number":"32138832","created_at":"2025-03-17T22:35:15.000000Z","updated_at":"2025-03-17T22:35:15.000000Z"}]},{"id":2572239,"change_date":"2023-03-13 21:43:00","inspection_id":"78085100","dot_number":"2614731","report_state":"CA","report_number":"UEWW000010","insp_date":"2023-03-06 00:00:00","insp_start_time":"2013","insp_end_time":"2031","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"14816589","transaction_code":"A","transaction_date":"2023-03-06 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2023-03-13 21:43:00","snet_input_date":"2023-03-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-13 21:43:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"0262372","created_at":"2025-03-17T19:14:06.000000Z","updated_at":"2025-03-17T19:14:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4139922,"change_date":"2023-03-13 21:43:00","inspection_id":"78085100","insp_unit_id":"193856005","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHI","insp_unit_license":"03778G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"Y","insp_unit_decal_number":"32208387","created_at":"2025-03-17T22:35:40.000000Z","updated_at":"2025-03-17T22:35:40.000000Z"}]},{"id":2518856,"change_date":"2023-03-06 21:41:00","inspection_id":"78024203","dot_number":"2614731","report_state":"CA","report_number":"NDLU004876","insp_date":"2023-02-27 00:00:00","insp_start_time":"1752","insp_end_time":"1810","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY INSPECTION FACILITY","county_code_state":"CA","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"14808757","transaction_code":"A","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2023-03-06 21:41:00","snet_input_date":"2023-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-06 21:41:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-03-17T19:12:59.000000Z","updated_at":"2025-03-17T19:12:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4054387,"change_date":"2023-03-06 21:41:00","inspection_id":"78024203","insp_unit_id":"193736315","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT BOX","insp_unit_license":"03778G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:03.000000Z","updated_at":"2025-03-17T22:35:03.000000Z"}]},{"id":1701446,"change_date":"2022-11-08 21:38:00","inspection_id":"77090025","dot_number":"2614731","report_state":"CA","report_number":"UD8N002147","insp_date":"2022-11-08 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ INSPECTION FACILITY","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14667410","transaction_code":"A","transaction_date":"2022-11-08 00:00:00","upload_date":"2022-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2022-11-08 21:38:00","snet_input_date":"2022-11-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-08 21:38:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-03-17T18:58:09.000000Z","updated_at":"2025-03-17T18:58:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2737753,"change_date":"2022-11-08 21:38:00","inspection_id":"77090025","insp_unit_id":"191869945","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"03778G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:44.000000Z","updated_at":"2025-03-17T22:25:44.000000Z"}]},{"id":1013331,"change_date":"2022-08-10 21:40:00","inspection_id":"76292916","dot_number":"2614731","report_state":"CA","report_number":"UCKN001147","insp_date":"2022-08-10 00:00:00","insp_start_time":"1156","insp_end_time":"1205","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF SB","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14543550","transaction_code":"A","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2022-08-10 21:40:00","snet_input_date":"2022-08-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-10 21:40:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-03-17T18:45:27.000000Z","updated_at":"2025-03-17T18:45:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1630328,"change_date":"2022-08-10 21:40:00","inspection_id":"76292916","insp_unit_id":"190251165","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"03778G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W171G7F00926","insp_unit_decal":"Y","insp_unit_decal_number":"31484043","created_at":"2025-03-17T22:18:16.000000Z","updated_at":"2025-03-17T22:18:16.000000Z"}]},{"id":900866,"change_date":"2022-07-26 21:43:00","inspection_id":"76161253","dot_number":"2614731","report_state":"CA","report_number":"UF73000968","insp_date":"2022-07-22 00:00:00","insp_start_time":"1823","insp_end_time":"1831","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":"2022-07-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14521255","transaction_code":"A","transaction_date":"2022-07-22 00:00:00","upload_date":"2022-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2022-07-26 21:43:00","snet_input_date":"2022-07-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-26 21:43:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-03-17T18:43:40.000000Z","updated_at":"2025-03-17T18:43:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1450351,"change_date":"2022-07-26 21:43:00","inspection_id":"76161253","insp_unit_id":"189982948","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"56772X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165G7001233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:08.000000Z","updated_at":"2025-03-17T22:17:08.000000Z"}]},{"id":782332,"change_date":"2022-07-08 21:41:00","inspection_id":"76022897","dot_number":"2614731","report_state":"CA","report_number":"UBGJ003979","insp_date":"2022-07-05 00:00:00","insp_start_time":"1731","insp_end_time":"1807","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE PLATFORM","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-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14498676","transaction_code":"A","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2022-07-08 21:41:00","snet_input_date":"2022-07-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-08 21:41:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2025-03-17T18:41:33.000000Z","updated_at":"2025-03-17T18:41:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1258832,"change_date":"2022-07-08 21:41:00","inspection_id":"76022897","insp_unit_id":"189683935","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHT","insp_unit_license":"03779G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4W172G7F00918","insp_unit_decal":"Y","insp_unit_decal_number":"31474785","created_at":"2025-03-17T22:15:55.000000Z","updated_at":"2025-03-17T22:15:55.000000Z"}]},{"id":756083,"change_date":"2022-07-05 21:43:00","inspection_id":"75992311","dot_number":"2614731","report_state":"CA","report_number":"ND6S004208","insp_date":"2022-06-29 00:00:00","insp_start_time":"1319","insp_end_time":"1343","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14492382","transaction_code":"A","transaction_date":"2022-06-29 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2022-07-05 21:43:00","snet_input_date":"2022-06-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-05 21:43:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-03-17T18:40:56.000000Z","updated_at":"2025-03-17T18:40:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1216227,"change_date":"2022-07-05 21:43:00","inspection_id":"75992311","insp_unit_id":"189617402","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"56772X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165G7001233","insp_unit_decal":"Y","insp_unit_decal_number":"31099218","created_at":"2025-03-17T22:15:40.000000Z","updated_at":"2025-03-17T22:15:40.000000Z"}]},{"id":107221,"change_date":"2022-04-04 21:41:00","inspection_id":"75218981","dot_number":"2614731","report_state":"CA","report_number":"UFPH000530","insp_date":"2022-03-31 00:00:00","insp_start_time":"2005","insp_end_time":"2017","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-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","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":"14369584","transaction_code":"A","transaction_date":"2022-03-31 00:00:00","upload_date":"2022-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2022-04-04 21:41:00","snet_input_date":"2022-03-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-04 21:41:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":null,"created_at":"2025-03-17T18:29:28.000000Z","updated_at":"2025-03-17T18:29:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":173535,"change_date":"2022-04-04 21:41:00","inspection_id":"75218981","insp_unit_id":"187982805","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2XL WHT","insp_unit_license":"38804U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALB4T172C7W00264","insp_unit_decal":"Y","insp_unit_decal_number":"30788085","created_at":"2025-03-17T22:09:16.000000Z","updated_at":"2025-03-17T22:09:16.000000Z"}]},{"id":56810,"change_date":"2022-03-28 21:41:00","inspection_id":"75157735","dot_number":"2614731","report_state":"CA","report_number":"N9ZT003425","insp_date":"2022-03-18 00:00:00","insp_start_time":"1320","insp_end_time":"1340","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"LIVERMORE, CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"14360758","transaction_code":"A","transaction_date":"2022-03-18 00:00:00","upload_date":"2022-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02614731","upload_search_indicator":null,"census_search_date":"2022-03-28 21:41:00","snet_input_date":"2022-03-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-03-28 21:41:00","insp_carrier_name":"COACH AUTOMOTIVE RESTYLING OF NO CALIF INC","insp_carrier_street":"30017 AHERN AVE","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":"262372","created_at":"2025-03-17T18:28:28.000000Z","updated_at":"2025-03-17T18:28:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":92387,"change_date":"2022-03-28 21:41:00","inspection_id":"75157735","insp_unit_id":"187859994","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"56773X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166G7001242","insp_unit_decal":"Y","insp_unit_decal_number":"30783474","created_at":"2025-03-17T22:08:48.000000Z","updated_at":"2025-03-17T22:08:48.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2614731\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2614731\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2614731\/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\/2614731\/inspections","per_page":100,"prev_page_url":null,"to":40,"total":40}