{"current_page":1,"data":[{"id":12401538,"change_date":"2026-07-09 21:42:00","inspection_id":"88358605","dot_number":"2691816","report_state":"CA","report_number":"UGHP001017","insp_date":"2026-07-09 00:00:00","insp_start_time":"1205","insp_end_time":"1225","registration_date":null,"region":"PD","ci_status_code":"C","location":"9347","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3719475","transaction_code":"A","transaction_date":"2026-07-09 00:00:00","upload_date":"2026-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2026-07-09 21:42:00","snet_input_date":"2026-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-09 21:42:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-13T09:39:25.000000Z","updated_at":"2026-07-20T09:31:19.000000Z","inspection_violations":[{"id":21578910,"change_date":"2026-07-09 21:42:00","inspection_id":"88358605","insp_violation_id":"275382155","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"214518182","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:55:59.000000Z","updated_at":"2026-07-20T09:45:22.000000Z","normalized_code":"3922SLLSIV"},{"id":21578909,"change_date":"2026-07-09 21:42:00","inspection_id":"88358605","insp_violation_id":"275382154","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214518182","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:55:59.000000Z","updated_at":"2026-07-20T09:45:22.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21544108,"change_date":"2026-07-09 21:42:00","inspection_id":"88358605","insp_unit_id":"214518182","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"64120K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT9NEC91414","insp_unit_decal":"Y","insp_unit_decal_number":"36526357","created_at":"2026-07-13T09:16:47.000000Z","updated_at":"2026-07-20T09:02:50.000000Z"}]},{"id":12147501,"change_date":"2026-06-10 21:44:00","inspection_id":"88096302","dot_number":"2691816","report_state":"CA","report_number":"UGL7000257","insp_date":"2026-06-10 00:00:00","insp_start_time":"0515","insp_end_time":"0615","registration_date":null,"region":"PS","ci_status_code":"C","location":"850","location_desc":"CA","county_code_state":"CA","county_code":"013","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":"EXE","hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"3508069","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:27.000000Z","updated_at":"2026-06-21T09:30:57.000000Z","inspection_violations":[{"id":21143186,"change_date":"2026-06-10 21:44:00","inspection_id":"88096302","insp_violation_id":"274815174","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"214014365","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SN26242","created_at":"2026-06-13T10:02:34.000000Z","updated_at":"2026-06-21T09:45:17.000000Z","normalized_code":"39021TB2DOT"},{"id":21143187,"change_date":"2026-06-10 21:44:00","inspection_id":"88096302","insp_violation_id":"274815175","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"214014365","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-13T10:02:34.000000Z","updated_at":"2026-06-21T09:45:17.000000Z","normalized_code":"393100BC"},{"id":21143188,"change_date":"2026-06-10 21:44:00","inspection_id":"88096302","insp_violation_id":"274815176","seq_no":"3","part_no":"171","part_no_section":"2E-HMGRMC","insp_viol_unit":"1","insp_unit_id":"214014365","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-13T10:02:34.000000Z","updated_at":"2026-06-21T09:45:17.000000Z","normalized_code":"1712EHMGRMC"}],"inspection_per_units":[{"id":21103299,"change_date":"2026-06-10 21:44:00","inspection_id":"88096302","insp_unit_id":"214014365","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"86770V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT4KEG17874","insp_unit_decal":"Y","insp_unit_decal_number":"36192161","created_at":"2026-06-13T09:17:51.000000Z","updated_at":"2026-06-21T09:02:07.000000Z"}]},{"id":8635955,"change_date":"2025-05-14 21:42:00","inspection_id":"84673234","dot_number":"2691816","report_state":"CA","report_number":"UEGX001626","insp_date":"2025-05-14 00:00:00","insp_start_time":"0540","insp_end_time":"0610","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I680 NB WALNUT CRK PLTFM SCALE","county_code_state":"CA","county_code":"013","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15819426","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2025-05-14 21:42:00","snet_input_date":"2025-05-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-05-17T10:05:34.000000Z","updated_at":"2025-05-18T10:07:05.000000Z","inspection_violations":[{"id":13733501,"change_date":"2025-05-14 21:42:00","inspection_id":"84673234","insp_violation_id":"266229514","seq_no":"1","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"206864715","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:28:07.000000Z","updated_at":"2025-05-18T10:35:11.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":14101668,"change_date":"2025-05-14 21:42:00","inspection_id":"84673234","insp_unit_id":"206864715","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"64108K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT7NEC91413","insp_unit_decal":"Y","insp_unit_decal_number":"35064249","created_at":"2025-05-17T09:49:27.000000Z","updated_at":"2025-05-18T09:52:49.000000Z"}]},{"id":7408278,"change_date":"2024-12-12 21:42:00","inspection_id":"83382380","dot_number":"2691816","report_state":"CA","report_number":"UEGX001113","insp_date":"2024-12-12 00:00:00","insp_start_time":"0600","insp_end_time":"0630","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"I680 NB WALNUT CRK PLTFM SCALE","county_code_state":"CA","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-12 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":"15627554","transaction_code":"A","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2024-12-12 21:42:00","snet_input_date":"2024-12-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-12 21:42:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-03-17T20:50:45.000000Z","updated_at":"2025-03-17T20:50:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11951087,"change_date":"2024-12-12 21:42:00","inspection_id":"83382380","insp_unit_id":"204362322","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"64108K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT7NEC91413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:57.000000Z","updated_at":"2025-03-17T23:46:57.000000Z"}]},{"id":6955118,"change_date":"2024-10-14 21:37:00","inspection_id":"82903100","dot_number":"2691816","report_state":"CA","report_number":"NE7S003769","insp_date":"2024-10-09 00:00:00","insp_start_time":"1741","insp_end_time":"1757","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-14 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15555583","transaction_code":"A","transaction_date":"2024-10-09 00:00:00","upload_date":"2024-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2024-10-14 21:37:00","snet_input_date":"2024-10-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-14 21:37:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-03-17T20:41:03.000000Z","updated_at":"2025-03-17T20:41:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11218034,"change_date":"2024-10-14 21:37:00","inspection_id":"82903100","insp_unit_id":"203401957","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE\/2AX","insp_unit_license":"09852Z3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162N7K00074","insp_unit_decal":"Y","insp_unit_decal_number":"34468002","created_at":"2025-03-17T23:39:08.000000Z","updated_at":"2025-03-17T23:39:08.000000Z"}]},{"id":6416175,"change_date":"2024-08-07 21:41:00","inspection_id":"82329192","dot_number":"2691816","report_state":"CA","report_number":"NF8R000183","insp_date":"2024-08-06 00:00:00","insp_start_time":"1745","insp_end_time":"1810","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15474502","transaction_code":"A","transaction_date":"2024-08-06 00:00:00","upload_date":"2024-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2024-08-07 21:41:00","snet_input_date":"2024-08-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-07 21:41:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:55.000000Z","updated_at":"2025-03-17T20:29:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10340767,"change_date":"2024-08-07 21:41:00","inspection_id":"82329192","insp_unit_id":"202287754","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"L070","insp_unit_license":"64120K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT9NEC91414","insp_unit_decal":"Y","insp_unit_decal_number":"34150642","created_at":"2025-03-17T23:30:10.000000Z","updated_at":"2025-03-17T23:30:10.000000Z"}]},{"id":5440534,"change_date":"2024-04-04 21:43:00","inspection_id":"81273850","dot_number":"2691816","report_state":"CA","report_number":"UCV3002084","insp_date":"2024-04-02 00:00:00","insp_start_time":"2106","insp_end_time":"2121","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-04-04 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15304974","transaction_code":"A","transaction_date":"2024-04-03 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2024-04-04 21:43:00","snet_input_date":"2024-04-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-04 21:43:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:38.000000Z","updated_at":"2025-03-17T20:10:38.000000Z","inspection_violations":[{"id":8398795,"change_date":"2024-04-04 21:43:00","inspection_id":"81273850","insp_violation_id":"258759778","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"200248513","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CW953123","created_at":"2025-03-17T21:46:37.000000Z","updated_at":"2025-03-17T21:46:37.000000Z","normalized_code":"39375A3"},{"id":8398796,"change_date":"2024-04-04 21:43:00","inspection_id":"81273850","insp_violation_id":"258759779","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200248513","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:37.000000Z","updated_at":"2025-03-17T21:46:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8763648,"change_date":"2024-04-04 21:43:00","inspection_id":"81273850","insp_unit_id":"200248513","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2 AXLE","insp_unit_license":"38007Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163F7003206","insp_unit_decal":"Y","insp_unit_decal_number":"33815013","created_at":"2025-03-17T23:14:30.000000Z","updated_at":"2025-03-17T23:14:30.000000Z"}]},{"id":4500806,"change_date":"2023-11-27 21:43:00","inspection_id":"80246739","dot_number":"2691816","report_state":"CA","report_number":"NEVK000223","insp_date":"2023-11-22 00:00:00","insp_start_time":"1642","insp_end_time":"1705","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15145681","transaction_code":"A","transaction_date":"2023-11-22 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2023-11-27 21:43:00","snet_input_date":"2023-11-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-27 21:43:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-03-17T19:52:09.000000Z","updated_at":"2025-03-17T19:52:09.000000Z","inspection_violations":[{"id":6967206,"change_date":"2023-11-27 21:43:00","inspection_id":"80246739","insp_violation_id":"256580919","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198227825","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"3922"},{"id":6967207,"change_date":"2023-11-27 21:43:00","inspection_id":"80246739","insp_violation_id":"256580920","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"198227825","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":7238807,"change_date":"2023-11-27 21:43:00","inspection_id":"80246739","insp_unit_id":"198227825","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"L059\/WHITE","insp_unit_license":"38007Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163F7003206","insp_unit_decal":"Y","insp_unit_decal_number":"33212848","created_at":"2025-03-17T23:00:48.000000Z","updated_at":"2025-03-17T23:00:48.000000Z"}]},{"id":4210095,"change_date":"2023-10-16 21:43:00","inspection_id":"79925780","dot_number":"2691816","report_state":"CA","report_number":"UD8N002987","insp_date":"2023-10-13 00:00:00","insp_start_time":"1015","insp_end_time":"1105","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"N\/OF RANCHO VENTUR., CUPERTINO","county_code_state":"CA","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15096924","transaction_code":"A","transaction_date":"2023-10-13 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2023-10-16 21:43:00","snet_input_date":"2023-10-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:15.000000Z","updated_at":"2025-03-17T19:46:15.000000Z","inspection_violations":[{"id":6518988,"change_date":"2023-10-16 21:43:00","inspection_id":"79925780","insp_violation_id":"255869095","seq_no":"1","part_no":"396","part_no_section":"7","insp_viol_unit":"1","insp_unit_id":"197584580","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CQ037204","created_at":"2025-03-17T21:37:24.000000Z","updated_at":"2025-03-17T21:37:24.000000Z","normalized_code":"3967"},{"id":6518989,"change_date":"2023-10-16 21:43:00","inspection_id":"79925780","insp_violation_id":"255869096","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197584580","insp_violation_category_id":"14","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":"3922"}],"inspection_per_units":[{"id":6770622,"change_date":"2023-10-16 21:43:00","inspection_id":"79925780","insp_unit_id":"197584580","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"25497L1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3FRPF7FAXBV054733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:46.000000Z","updated_at":"2025-03-17T22:56:46.000000Z"}]},{"id":3967666,"change_date":"2023-09-13 21:41:00","inspection_id":"79656934","dot_number":"2691816","report_state":"CA","report_number":"NBIJ004493","insp_date":"2023-09-12 00:00:00","insp_start_time":"0544","insp_end_time":"0623","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":"CON-QUEST CONST.","shipping_paper_number":"000000000000000","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-13 21:41: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":"15059713","transaction_code":"A","transaction_date":"2023-09-12 00:00:00","upload_date":"2023-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2023-09-13 21:41:00","snet_input_date":"2023-09-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-13 21:41:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-03-17T19:41:12.000000Z","updated_at":"2025-03-17T19:41:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6380154,"change_date":"2023-09-13 21:41:00","inspection_id":"79656934","insp_unit_id":"197041972","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"86770V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT4KEG17874","insp_unit_decal":"Y","insp_unit_decal_number":"32848918","created_at":"2025-03-17T22:53:35.000000Z","updated_at":"2025-03-17T22:53:35.000000Z"}]},{"id":3828973,"change_date":"2023-08-24 21:42:00","inspection_id":"79502285","dot_number":"2691816","report_state":"CA","report_number":"UDLV998953","insp_date":"2023-08-24 00:00:00","insp_start_time":"0630","insp_end_time":"0645","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-24 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":"15036112","transaction_code":"A","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2023-08-24 21:42:00","snet_input_date":"2023-08-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-24 21:42:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-03-17T19:38:31.000000Z","updated_at":"2025-03-17T19:38:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6156234,"change_date":"2023-08-24 21:42:00","inspection_id":"79502285","insp_unit_id":"196723122","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"L070","insp_unit_license":"64120K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT9NEC91414","insp_unit_decal":"Y","insp_unit_decal_number":"32859158","created_at":"2025-03-17T22:51:43.000000Z","updated_at":"2025-03-17T22:51:43.000000Z"}]},{"id":3807502,"change_date":"2023-08-22 21:44:00","inspection_id":"79478305","dot_number":"2691816","report_state":"CA","report_number":"UFJ5000479","insp_date":"2023-08-22 00:00:00","insp_start_time":"0559","insp_end_time":"0610","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"N\/B 680 WC SCALES","county_code_state":"CA","county_code":"013","insp_level_id":"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-22 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15031543","transaction_code":"A","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2023-08-22 21:44:00","snet_input_date":"2023-08-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-22 21:44:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-03-17T19:38:03.000000Z","updated_at":"2025-03-17T19:38:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6122058,"change_date":"2023-08-22 21:44:00","inspection_id":"79478305","insp_unit_id":"196675765","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"93978D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT5MEC68937","insp_unit_decal":"Y","insp_unit_decal_number":"32859349","created_at":"2025-03-17T22:51:26.000000Z","updated_at":"2025-03-17T22:51:26.000000Z"}]},{"id":3379459,"change_date":"2023-06-27 21:41:00","inspection_id":"78998694","dot_number":"2691816","report_state":"CA","report_number":"N9PI006363","insp_date":"2023-06-23 00:00:00","insp_start_time":"0603","insp_end_time":"0626","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"14961622","transaction_code":"A","transaction_date":"2023-06-23 00:00:00","upload_date":"2023-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2023-06-27 21:41:00","snet_input_date":"2023-06-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-27 21:41:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-03-17T19:29:49.000000Z","updated_at":"2025-03-17T19:29:49.000000Z","inspection_violations":[{"id":5211843,"change_date":"2023-06-27 21:41:00","inspection_id":"78998694","insp_violation_id":"253737378","seq_no":"1","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"1","insp_unit_id":"195707086","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3929A1"}],"inspection_per_units":[{"id":5433014,"change_date":"2023-06-27 21:41:00","inspection_id":"78998694","insp_unit_id":"195707086","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT L069","insp_unit_license":"64108K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT7NEC91413","insp_unit_decal":"Y","insp_unit_decal_number":"32552143","created_at":"2025-03-17T22:45:51.000000Z","updated_at":"2025-03-17T22:45:51.000000Z"}]},{"id":2401097,"change_date":"2023-02-17 21:40:00","inspection_id":"77890241","dot_number":"2691816","report_state":"CA","report_number":"UDLV002322","insp_date":"2023-02-17 00:00:00","insp_start_time":"0621","insp_end_time":"0631","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"MONUMENT OFF RAMP","county_code_state":"CA","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14788947","transaction_code":"A","transaction_date":"2023-02-17 00:00:00","upload_date":"2023-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2023-02-17 21:40:00","snet_input_date":"2023-02-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-17 21:40:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-03-17T19:11:01.000000Z","updated_at":"2025-03-17T19:11:01.000000Z","inspection_violations":[{"id":3697622,"change_date":"2023-02-17 21:40:00","inspection_id":"77890241","insp_violation_id":"251216406","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:24.000000Z","updated_at":"2025-03-17T21:24:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3863996,"change_date":"2023-02-17 21:40:00","inspection_id":"77890241","insp_unit_id":"193469917","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"L066","insp_unit_license":"93978D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT5MEC68937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:40.000000Z","updated_at":"2025-03-17T22:33:40.000000Z"}]},{"id":2309947,"change_date":"2023-02-06 21:42:00","inspection_id":"77785969","dot_number":"2691816","report_state":"CA","report_number":"NEAH001435","insp_date":"2023-02-01 00:00:00","insp_start_time":"1819","insp_end_time":"1834","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":"CON QUEST CONTRACTORS INC","shipping_paper_number":"64108K3","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14773564","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2023-02-06 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-06 21:42:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-03-17T19:09:15.000000Z","updated_at":"2025-03-17T19:09:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3718199,"change_date":"2023-02-06 21:42:00","inspection_id":"77785969","insp_unit_id":"193260246","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"L069\/WHT","insp_unit_license":"64108K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT7NEC91413","insp_unit_decal":"Y","insp_unit_decal_number":"32209213","created_at":"2025-03-17T22:32:38.000000Z","updated_at":"2025-03-17T22:32:38.000000Z"}]},{"id":1990241,"change_date":"2022-12-20 21:41:00","inspection_id":"77421000","dot_number":"2691816","report_state":"CA","report_number":"N9PI005426","insp_date":"2022-12-13 00:00:00","insp_start_time":"0643","insp_end_time":"0707","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"14715439","transaction_code":"A","transaction_date":"2022-12-13 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2022-12-20 21:41:00","snet_input_date":"2022-12-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-20 21:41:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-03-17T19:03:19.000000Z","updated_at":"2025-03-17T19:03:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3202410,"change_date":"2022-12-20 21:41:00","inspection_id":"77421000","insp_unit_id":"192525750","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT L072","insp_unit_license":"10427L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT5NEC91412","insp_unit_decal":"Y","insp_unit_decal_number":"31882283","created_at":"2025-03-17T22:28:56.000000Z","updated_at":"2025-03-17T22:28:56.000000Z"}]},{"id":1692756,"change_date":"2022-11-07 21:42:00","inspection_id":"77080118","dot_number":"2691816","report_state":"CA","report_number":"NEEU000616","insp_date":"2022-11-03 00:00:00","insp_start_time":"1700","insp_end_time":"1720","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14663859","transaction_code":"A","transaction_date":"2022-11-03 00:00:00","upload_date":"2022-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2022-11-07 21:42:00","snet_input_date":"2022-11-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-07 21:42:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-03-17T18:57:47.000000Z","updated_at":"2025-03-17T18:57:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2723423,"change_date":"2022-11-07 21:42:00","inspection_id":"77080118","insp_unit_id":"191850569","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"L069\/WHITE","insp_unit_license":"64108K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT7NEC91413","insp_unit_decal":"Y","insp_unit_decal_number":"31825902","created_at":"2025-03-17T22:25:39.000000Z","updated_at":"2025-03-17T22:25:39.000000Z"}]},{"id":1691554,"change_date":"2022-11-07 21:42:00","inspection_id":"77078830","dot_number":"2691816","report_state":"CA","report_number":"N9PI005287","insp_date":"2022-11-01 00:00:00","insp_start_time":"1210","insp_end_time":"1244","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"29490","viol_total":"6","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14666123","transaction_code":"A","transaction_date":"2022-11-01 00:00:00","upload_date":"2022-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2022-11-07 21:42:00","snet_input_date":"2022-11-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-07 21:42:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-03-17T18:57:46.000000Z","updated_at":"2025-03-17T18:57:46.000000Z","inspection_violations":[{"id":2653679,"change_date":"2022-11-07 21:42:00","inspection_id":"77078830","insp_violation_id":"249482062","seq_no":"1","part_no":"383","part_no_section":"91(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CW471605","created_at":"2025-03-17T21:19:29.000000Z","updated_at":"2025-03-17T21:19:29.000000Z","normalized_code":"38391A"},{"id":2653680,"change_date":"2022-11-07 21:42:00","inspection_id":"77078830","insp_violation_id":"249482063","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191848617","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:29.000000Z","updated_at":"2025-03-17T21:19:29.000000Z","normalized_code":"3922"},{"id":2653681,"change_date":"2022-11-07 21:42:00","inspection_id":"77078830","insp_violation_id":"249482064","seq_no":"3","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191848617","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:29.000000Z","updated_at":"2025-03-17T21:19:29.000000Z","normalized_code":"3929A"},{"id":2653682,"change_date":"2022-11-07 21:42:00","inspection_id":"77078830","insp_violation_id":"249482065","seq_no":"4","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"191848618","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:19:29.000000Z","updated_at":"2025-03-17T21:19:29.000000Z","normalized_code":"39343D"},{"id":2653683,"change_date":"2022-11-07 21:42:00","inspection_id":"77078830","insp_violation_id":"249482066","seq_no":"5","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"191848618","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:29.000000Z","updated_at":"2025-03-17T21:19:29.000000Z","normalized_code":"39348A"},{"id":2653684,"change_date":"2022-11-07 21:42:00","inspection_id":"77078830","insp_violation_id":"249482067","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"191848618","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CW471605","created_at":"2025-03-17T21:19:29.000000Z","updated_at":"2025-03-17T21:19:29.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2721679,"change_date":"2022-11-07 21:42:00","inspection_id":"77078830","insp_unit_id":"191848617","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT L066","insp_unit_license":"93978D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT5MEC68937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:39.000000Z","updated_at":"2025-03-17T22:25:39.000000Z"},{"id":2721680,"change_date":"2022-11-07 21:42:00","inspection_id":"77078830","insp_unit_id":"191848618","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PARH","insp_unit_company":"DUMP TRL","insp_unit_license":"4KF1315","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4P5D7142481121396","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:39.000000Z","updated_at":"2025-03-17T22:25:39.000000Z"}]},{"id":1242754,"change_date":"2022-09-08 21:39:00","inspection_id":"76560065","dot_number":"2691816","report_state":"CA","report_number":"ND6D003698","insp_date":"2022-09-06 00:00:00","insp_start_time":"1015","insp_end_time":"1047","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CON QUEST CONTRACTORS","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"143000","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":"14585363","transaction_code":"A","transaction_date":"2022-09-06 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2022-09-08 21:39:00","snet_input_date":"2022-09-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-08 21:39:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"394691","created_at":"2025-03-17T18:49:41.000000Z","updated_at":"2025-03-17T18:49:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2000113,"change_date":"2022-09-08 21:39:00","inspection_id":"76560065","insp_unit_id":"190796779","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"L040","insp_unit_license":"9E30747","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKDD40X19J253446","insp_unit_decal":"Y","insp_unit_decal_number":"31499717","created_at":"2025-03-17T22:20:45.000000Z","updated_at":"2025-03-17T22:20:45.000000Z"},{"id":2000114,"change_date":"2022-09-08 21:39:00","inspection_id":"76560065","insp_unit_id":"190796780","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANDO","insp_unit_company":"B038","insp_unit_license":"1WL6182","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH660UH5X1A09839","insp_unit_decal":"Y","insp_unit_decal_number":"31499718","created_at":"2025-03-17T22:20:45.000000Z","updated_at":"2025-03-17T22:20:45.000000Z"}]},{"id":426351,"change_date":"2022-05-18 21:44:00","inspection_id":"75601457","dot_number":"2691816","report_state":"CA","report_number":"UD8N001774","insp_date":"2022-05-18 00:00:00","insp_start_time":"0645","insp_end_time":"0730","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"S\/OF AUTO MALL PKWY., FREMONT","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-18 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","viol_total":"2","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14433095","transaction_code":"A","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2022-05-18 21:44:00","snet_input_date":"2022-05-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-18 21:44:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:08.000000Z","updated_at":"2025-03-17T18:35:08.000000Z","inspection_violations":[{"id":670221,"change_date":"2022-05-18 21:44:00","inspection_id":"75601457","insp_violation_id":"245903022","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"CQ035626","created_at":"2025-03-17T21:10:10.000000Z","updated_at":"2025-03-17T21:10:10.000000Z","normalized_code":"38323A2"},{"id":670222,"change_date":"2022-05-18 21:44:00","inspection_id":"75601457","insp_violation_id":"245903023","seq_no":"2","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"188775732","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CQ035627","created_at":"2025-03-17T21:10:10.000000Z","updated_at":"2025-03-17T21:10:10.000000Z","normalized_code":"39343D"}],"inspection_per_units":[{"id":687852,"change_date":"2022-05-18 21:44:00","inspection_id":"75601457","insp_unit_id":"188775731","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"52748Y2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT0LEC47332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:25.000000Z","updated_at":"2025-03-17T22:12:25.000000Z"},{"id":687853,"change_date":"2022-05-18 21:44:00","inspection_id":"75601457","insp_unit_id":"188775732","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"PJ","insp_unit_company":null,"insp_unit_license":"4PC2661","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4P5T82224F1234294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:25.000000Z","updated_at":"2025-03-17T22:12:25.000000Z"}]},{"id":412596,"change_date":"2022-05-17 21:44:00","inspection_id":"75585108","dot_number":"2691816","report_state":"CA","report_number":"UEXA001117","insp_date":"2022-05-17 00:00:00","insp_start_time":"0630","insp_end_time":"0651","registration_date":null,"region":"PT","ci_status_code":"C","location":"370","location_desc":"NB WALNUT CREEK","county_code_state":"CA","county_code":"013","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EMPTY","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14431983","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2022-05-17 21:44:00","snet_input_date":"2022-05-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-17 21:44:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:48.000000Z","updated_at":"2025-03-17T18:34:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":666256,"change_date":"2022-05-17 21:44:00","inspection_id":"75585108","insp_unit_id":"188743033","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT 2X","insp_unit_license":"64120K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT9NEC91414","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:18.000000Z","updated_at":"2025-03-17T22:12:18.000000Z"}]},{"id":273356,"change_date":"2022-04-27 21:41:00","inspection_id":"75419071","dot_number":"2691816","report_state":"CA","report_number":"UC7V000880","insp_date":"2022-04-27 00:00:00","insp_start_time":"0605","insp_end_time":"0628","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"SB 680   WALNUT  CREEK SCALES","county_code_state":"CA","county_code":"013","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14402215","transaction_code":"A","transaction_date":"2022-04-27 00:00:00","upload_date":"2022-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02691816","upload_search_indicator":null,"census_search_date":"2022-04-27 21:41:00","snet_input_date":"2022-04-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-27 21:41:00","insp_carrier_name":"CON QUEST CONTRACTORS INC","insp_carrier_street":"290 TOLAND ST","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94124","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:15.000000Z","updated_at":"2025-03-17T18:32:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":442871,"change_date":"2022-04-27 21:41:00","inspection_id":"75419071","insp_unit_id":"188388119","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X WHT","insp_unit_license":"64108K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X4GT7NEC91413","insp_unit_decal":"Y","insp_unit_decal_number":"31110987","created_at":"2025-03-17T22:10:55.000000Z","updated_at":"2025-03-17T22:10:55.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2691816\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2691816\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2691816\/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\/2691816\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}