{"current_page":1,"data":[{"id":11121626,"change_date":"2026-02-12 21:41:00","inspection_id":"87034706","dot_number":"3361798","report_state":"CA","report_number":"N97H006008","insp_date":"2026-02-06 00:00:00","insp_start_time":"0730","insp_end_time":"0800","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","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":"16168207","transaction_code":"A","transaction_date":"2026-02-06 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2026-02-12 21:41:00","snet_input_date":"2026-02-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-12 21:41:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO LLC","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2026-02-15T10:38:51.000000Z","updated_at":"2026-02-23T10:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18968616,"change_date":"2026-02-12 21:41:00","inspection_id":"87034706","insp_unit_id":"211599806","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"1327","insp_unit_license":"16593C4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"W1X8ND353RT188771","insp_unit_decal":"Y","insp_unit_decal_number":"35878182","created_at":"2026-02-15T10:20:12.000000Z","updated_at":"2026-02-23T10:03:49.000000Z"}]},{"id":11121666,"change_date":"2026-02-12 21:41:00","inspection_id":"87034747","dot_number":"3361798","report_state":"CA","report_number":"N97H006009","insp_date":"2026-02-06 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","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":"16168208","transaction_code":"A","transaction_date":"2026-02-06 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2026-02-12 21:41:00","snet_input_date":"2026-02-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-12 21:41:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO LLC","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2026-02-15T10:38:51.000000Z","updated_at":"2026-02-23T10:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18968680,"change_date":"2026-02-12 21:41:00","inspection_id":"87034747","insp_unit_id":"211599871","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"1428","insp_unit_license":"50660F4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"W1X8ND356RT189980","insp_unit_decal":"Y","insp_unit_decal_number":"35878183","created_at":"2026-02-15T10:20:12.000000Z","updated_at":"2026-02-23T10:03:49.000000Z"}]},{"id":11121625,"change_date":"2026-02-12 21:41:00","inspection_id":"87034705","dot_number":"3361798","report_state":"CA","report_number":"N97H006007","insp_date":"2026-02-06 00:00:00","insp_start_time":"0700","insp_end_time":"0730","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","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":"16168206","transaction_code":"A","transaction_date":"2026-02-06 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2026-02-12 21:41:00","snet_input_date":"2026-02-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-12 21:41:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO LLC","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2026-02-15T10:38:51.000000Z","updated_at":"2026-02-23T10:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18968615,"change_date":"2026-02-12 21:41:00","inspection_id":"87034705","insp_unit_id":"211599805","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"1226","insp_unit_license":"47570Y3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"W1X8DD3Y5NT084113","insp_unit_decal":"Y","insp_unit_decal_number":"35878181","created_at":"2026-02-15T10:20:12.000000Z","updated_at":"2026-02-23T10:03:49.000000Z"}]},{"id":7947001,"change_date":"2025-02-24 21:40:00","inspection_id":"83948172","dot_number":"3361798","report_state":"CA","report_number":"N97H004938","insp_date":"2025-02-06 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","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":"15713390","transaction_code":"A","transaction_date":"2025-02-06 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2025-02-24 21:40:00","snet_input_date":"2025-02-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-24 21:40:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T21:03:15.000000Z","updated_at":"2025-03-17T21:03:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12828899,"change_date":"2025-02-24 21:40:00","inspection_id":"83948172","insp_unit_id":"205473215","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"1226","insp_unit_license":"47570Y3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"W1X8DD3Y5NT084113","insp_unit_decal":"Y","insp_unit_decal_number":"34765034","created_at":"2025-03-17T23:56:42.000000Z","updated_at":"2025-03-17T23:56:42.000000Z"}]},{"id":7947288,"change_date":"2025-02-24 21:40:00","inspection_id":"83948464","dot_number":"3361798","report_state":"CA","report_number":"N97H004936","insp_date":"2025-02-06 00:00:00","insp_start_time":"0700","insp_end_time":"0730","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","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":"15713388","transaction_code":"A","transaction_date":"2025-02-06 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2025-02-24 21:40:00","snet_input_date":"2025-02-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-24 21:40:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T21:03:15.000000Z","updated_at":"2025-03-17T21:03:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12829294,"change_date":"2025-02-24 21:40:00","inspection_id":"83948464","insp_unit_id":"205473625","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"1327","insp_unit_license":"16593C4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"W1X8ND353RT188771","insp_unit_decal":"Y","insp_unit_decal_number":"34765035","created_at":"2025-03-17T23:56:42.000000Z","updated_at":"2025-03-17T23:56:42.000000Z"}]},{"id":7947289,"change_date":"2025-02-24 21:40:00","inspection_id":"83948465","dot_number":"3361798","report_state":"CA","report_number":"N97H004937","insp_date":"2025-02-06 00:00:00","insp_start_time":"0730","insp_end_time":"0800","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","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":"15713389","transaction_code":"A","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2025-02-24 21:40:00","snet_input_date":"2025-02-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-24 21:40:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T21:03:15.000000Z","updated_at":"2025-03-17T21:03:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12829295,"change_date":"2025-02-24 21:40:00","inspection_id":"83948465","insp_unit_id":"205473626","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"1024","insp_unit_license":"63113G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"WDAPF1DD4GP320961","insp_unit_decal":"Y","insp_unit_decal_number":"34765033","created_at":"2025-03-17T23:56:42.000000Z","updated_at":"2025-03-17T23:56:42.000000Z"}]},{"id":6811781,"change_date":"2024-09-24 21:42:00","inspection_id":"82750830","dot_number":"3361798","report_state":"CA","report_number":"UEIN000584","insp_date":"2024-09-21 00:00:00","insp_start_time":"1250","insp_end_time":"1330","registration_date":null,"region":"PT","ci_status_code":"C","location":"455","location_desc":"YOSEMITE NATIONAL PARK","county_code_state":"CA","county_code":"043","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"9990","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":"15533217","transaction_code":"A","transaction_date":"2024-09-24 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2024-09-24 21:42:00","snet_input_date":"2024-09-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-24 21:42:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T20:38:13.000000Z","updated_at":"2025-03-17T20:38:13.000000Z","inspection_violations":[{"id":10607211,"change_date":"2024-09-24 21:42:00","inspection_id":"82750830","insp_violation_id":"262016547","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203114874","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:22.000000Z","updated_at":"2025-03-17T21:57:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10984678,"change_date":"2024-09-24 21:42:00","inspection_id":"82750830","insp_unit_id":"203114874","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"1024","insp_unit_license":"63113G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"WDAPF1DD4GP320961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:45.000000Z","updated_at":"2025-03-17T23:36:45.000000Z"}]},{"id":6800949,"change_date":"2024-09-23 21:41:00","inspection_id":"82739356","dot_number":"3361798","report_state":"CA","report_number":"UEKJ000640","insp_date":"2024-09-20 00:00:00","insp_start_time":"1250","insp_end_time":"1320","registration_date":null,"region":"PT","ci_status_code":"C","location":"9455","location_desc":"YOSEMITE VALLEY","county_code_state":"CA","county_code":"043","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","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":"15531570","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2024-09-23 21:41:00","snet_input_date":"2024-09-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-23 21:41:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T20:38:09.000000Z","updated_at":"2025-03-17T20:38:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10967166,"change_date":"2024-09-23 21:41:00","inspection_id":"82739356","insp_unit_id":"203092209","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"1226","insp_unit_license":"47570Y3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"W1X8DD3Y5NT084113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:36.000000Z","updated_at":"2025-03-17T23:36:36.000000Z"}]},{"id":6811768,"change_date":"2024-09-24 21:42:00","inspection_id":"82750814","dot_number":"3361798","report_state":"CA","report_number":"UEIN000579","insp_date":"2024-09-20 00:00:00","insp_start_time":"1305","insp_end_time":"1345","registration_date":null,"region":"PT","ci_status_code":"C","location":"455","location_desc":"YOSEMITE NATIONAL PARK","county_code_state":"CA","county_code":"043","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","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":"15533150","transaction_code":"A","transaction_date":"2024-09-24 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2024-09-24 21:42:00","snet_input_date":"2024-09-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-24 21:42:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO LLC","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T20:38:13.000000Z","updated_at":"2025-03-17T20:38:13.000000Z","inspection_violations":[{"id":10607199,"change_date":"2024-09-24 21:42:00","inspection_id":"82750814","insp_violation_id":"262016532","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203114848","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:22.000000Z","updated_at":"2025-03-17T21:57:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10984657,"change_date":"2024-09-24 21:42:00","inspection_id":"82750814","insp_unit_id":"203114848","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"822","insp_unit_license":"09599D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"WDAPF4CCXD5787366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:45.000000Z","updated_at":"2025-03-17T23:36:45.000000Z"}]},{"id":5290181,"change_date":"2024-03-14 21:42:00","inspection_id":"81109882","dot_number":"3361798","report_state":"CA","report_number":"N97H004015","insp_date":"2024-02-29 00:00:00","insp_start_time":"0700","insp_end_time":"0730","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","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":"15282308","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2024-03-14 21:42:00","snet_input_date":"2024-02-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-14 21:42:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T20:07:29.000000Z","updated_at":"2025-03-17T20:07:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8519290,"change_date":"2024-03-14 21:42:00","inspection_id":"81109882","insp_unit_id":"199923381","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"1125","insp_unit_license":"44524M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"WDAPF4CC2D5814561","insp_unit_decal":"Y","insp_unit_decal_number":"33526688","created_at":"2025-03-17T23:12:12.000000Z","updated_at":"2025-03-17T23:12:12.000000Z"}]},{"id":5290182,"change_date":"2024-03-14 21:42:00","inspection_id":"81109883","dot_number":"3361798","report_state":"CA","report_number":"N97H004016","insp_date":"2024-02-29 00:00:00","insp_start_time":"0730","insp_end_time":"0800","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"9990","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":"15281995","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2024-03-14 21:42:00","snet_input_date":"2024-02-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-14 21:42:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T20:07:29.000000Z","updated_at":"2025-03-17T20:07:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8519291,"change_date":"2024-03-14 21:42:00","inspection_id":"81109883","insp_unit_id":"199923382","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"1024","insp_unit_license":"63113G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"WDAPF1DD4GP320961","insp_unit_decal":"Y","insp_unit_decal_number":"33526689","created_at":"2025-03-17T23:12:12.000000Z","updated_at":"2025-03-17T23:12:12.000000Z"}]},{"id":5290183,"change_date":"2024-03-14 21:42:00","inspection_id":"81109884","dot_number":"3361798","report_state":"CA","report_number":"N97H004017","insp_date":"2024-02-29 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","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":"15282024","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2024-03-14 21:42:00","snet_input_date":"2024-02-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-14 21:42:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T20:07:29.000000Z","updated_at":"2025-03-17T20:07:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8519292,"change_date":"2024-03-14 21:42:00","inspection_id":"81109884","insp_unit_id":"199923383","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"923","insp_unit_license":"66919J2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"WDAPF4CC8E5845055","insp_unit_decal":"Y","insp_unit_decal_number":"33526690","created_at":"2025-03-17T23:12:12.000000Z","updated_at":"2025-03-17T23:12:12.000000Z"}]},{"id":2994546,"change_date":"2023-05-08 21:43:00","inspection_id":"78564559","dot_number":"3361798","report_state":"CA","report_number":"N97H002998","insp_date":"2023-03-30 00:00:00","insp_start_time":"1630","insp_end_time":"1700","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","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":"14889972","transaction_code":"A","transaction_date":"2023-03-30 00:00:00","upload_date":"2023-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2023-05-08 21:43:00","snet_input_date":"2023-03-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-08 21:43:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T19:22:17.000000Z","updated_at":"2025-03-17T19:22:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4818317,"change_date":"2023-05-08 21:43:00","inspection_id":"78564559","insp_unit_id":"194817141","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"1125","insp_unit_license":"44524M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"WDAPF4CC2D5814561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:57.000000Z","updated_at":"2025-03-17T22:40:57.000000Z"}]},{"id":2556255,"change_date":"2023-03-10 21:41:00","inspection_id":"78066630","dot_number":"3361798","report_state":"CA","report_number":"N97H002907","insp_date":"2023-03-01 00:00:00","insp_start_time":"0700","insp_end_time":"0730","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"9990","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":"14814837","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2023-03-10 21:41:00","snet_input_date":"2023-03-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-10 21:41:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T19:13:44.000000Z","updated_at":"2025-03-17T19:13:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4114659,"change_date":"2023-03-10 21:41:00","inspection_id":"78066630","insp_unit_id":"193821913","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"1024","insp_unit_license":"63113G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"WDAPF1DD4GP320961","insp_unit_decal":"Y","insp_unit_decal_number":"32134273","created_at":"2025-03-17T22:35:29.000000Z","updated_at":"2025-03-17T22:35:29.000000Z"}]},{"id":2556256,"change_date":"2023-03-10 21:41:00","inspection_id":"78066631","dot_number":"3361798","report_state":"CA","report_number":"N97H002908","insp_date":"2023-03-01 00:00:00","insp_start_time":"0730","insp_end_time":"0800","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","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":"14814805","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2023-03-10 21:41:00","snet_input_date":"2023-03-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-10 21:41:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T19:13:44.000000Z","updated_at":"2025-03-17T19:13:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4114660,"change_date":"2023-03-10 21:41:00","inspection_id":"78066631","insp_unit_id":"193821914","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"923","insp_unit_license":"66919J2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"WDAPF4CC8E5845055","insp_unit_decal":"Y","insp_unit_decal_number":"32134274","created_at":"2025-03-17T22:35:29.000000Z","updated_at":"2025-03-17T22:35:29.000000Z"}]},{"id":2556307,"change_date":"2023-03-10 21:41:00","inspection_id":"78066687","dot_number":"3361798","report_state":"CA","report_number":"N97H002909","insp_date":"2023-03-01 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","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":"14814581","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2023-03-10 21:41:00","snet_input_date":"2023-03-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-10 21:41:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T19:13:44.000000Z","updated_at":"2025-03-17T19:13:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4114734,"change_date":"2023-03-10 21:41:00","inspection_id":"78066687","insp_unit_id":"193822000","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"822","insp_unit_license":"09599D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"WDAPF4CCXD5787366","insp_unit_decal":"Y","insp_unit_decal_number":"32134275","created_at":"2025-03-17T22:35:29.000000Z","updated_at":"2025-03-17T22:35:29.000000Z"}]},{"id":734118,"change_date":"2022-06-30 21:42:00","inspection_id":"75966708","dot_number":"3361798","report_state":"CA","report_number":"UELY000582","insp_date":"2022-06-30 00:00:00","insp_start_time":"1206","insp_end_time":"1230","registration_date":null,"region":"PT","ci_status_code":"C","location":"9410","location_desc":"YOSEMITE NATIONAL PARK","county_code_state":"CA","county_code":"043","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"9990","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":"14489910","transaction_code":"A","transaction_date":"2022-06-30 00:00:00","upload_date":"2022-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2022-06-30 21:42:00","snet_input_date":"2022-06-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-30 21:42:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"556309","created_at":"2025-03-17T18:40:33.000000Z","updated_at":"2025-03-17T18:40:33.000000Z","inspection_violations":[{"id":1156545,"change_date":"2022-06-30 21:42:00","inspection_id":"75966708","insp_violation_id":"246842195","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"189562515","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:23.000000Z","updated_at":"2025-03-17T21:12:23.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":1180224,"change_date":"2022-06-30 21:42:00","inspection_id":"75966708","insp_unit_id":"189562515","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":null,"insp_unit_license":"63113G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"WDAPF1DD4GP320961","insp_unit_decal":"Y","insp_unit_decal_number":"31125708","created_at":"2025-03-17T22:15:27.000000Z","updated_at":"2025-03-17T22:15:27.000000Z"}]},{"id":758194,"change_date":"2022-07-05 21:43:00","inspection_id":"75994666","dot_number":"3361798","report_state":"CA","report_number":"UELY000583","insp_date":"2022-06-30 00:00:00","insp_start_time":"1235","insp_end_time":"1253","registration_date":null,"region":"PT","ci_status_code":"C","location":"9401","location_desc":"YOSEMITE NATIONAL PARK","county_code_state":"CA","county_code":"043","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"11030","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14491441","transaction_code":"A","transaction_date":"2022-06-30 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03361798","upload_search_indicator":null,"census_search_date":"2022-07-05 21:43:00","snet_input_date":"2022-06-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-05 21:43:00","insp_carrier_name":"BEST BAY AREA TOURS OF SAN FRANCISCO","insp_carrier_street":"235 CRESTA VISTA DR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94127","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:56.000000Z","updated_at":"2025-03-17T18:40:56.000000Z","inspection_violations":[{"id":1195905,"change_date":"2022-07-05 21:43:00","inspection_id":"75994666","insp_violation_id":"246910248","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1219560,"change_date":"2022-07-05 21:43:00","inspection_id":"75994666","insp_unit_id":"189621225","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MERZ","insp_unit_company":"923","insp_unit_license":"66919J2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"WDAPF4CC8E5845055","insp_unit_decal":"Y","insp_unit_decal_number":"31125711","created_at":"2025-03-17T22:15:40.000000Z","updated_at":"2025-03-17T22:15:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3361798\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3361798\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3361798\/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\/3361798\/inspections","per_page":100,"prev_page_url":null,"to":18,"total":18}