{"current_page":1,"data":[{"id":12401376,"change_date":"2026-07-09 21:42:00","inspection_id":"88358436","dot_number":"2948137","report_state":"CA","report_number":"NCCL007900","insp_date":"2026-07-08 00:00:00","insp_start_time":"0940","insp_end_time":"1020","registration_date":null,"region":"PD","ci_status_code":"C","location":"347","location_desc":"CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"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":"130350","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":"3719254","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":"02948137","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":"777 TRUCKING INC","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"662137","created_at":"2026-07-13T09:39:25.000000Z","updated_at":"2026-07-20T09:31:18.000000Z","inspection_violations":[{"id":21578633,"change_date":"2026-07-09 21:42:00","inspection_id":"88358436","insp_violation_id":"275381814","seq_no":"1","part_no":"393","part_no_section":"47B-BMBCAD-SA","insp_viol_unit":"1","insp_unit_id":"214517922","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-13T09:55:58.000000Z","updated_at":"2026-07-20T09:45:18.000000Z","normalized_code":"39347BBMBCADSA"},{"id":21578634,"change_date":"2026-07-09 21:42:00","inspection_id":"88358436","insp_violation_id":"275381815","seq_no":"2","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"214517922","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:55:58.000000Z","updated_at":"2026-07-20T09:45:18.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":21543874,"change_date":"2026-07-09 21:42:00","inspection_id":"88358436","insp_unit_id":"214517922","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2 RED 3X","insp_unit_license":"9E31444","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH4BN295744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:47.000000Z","updated_at":"2026-07-20T09:02:50.000000Z"},{"id":21543875,"change_date":"2026-07-09 21:42:00","inspection_id":"88358436","insp_unit_id":"214517923","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"305FLTBD 2X","insp_unit_license":"4PU4997","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W1BGB3B9TE308908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:47.000000Z","updated_at":"2026-07-20T09:02:50.000000Z"}]},{"id":9000283,"change_date":"2025-06-26 21:41:00","inspection_id":"85059040","dot_number":"2948137","report_state":"CA","report_number":"NEAH005371","insp_date":"2025-06-17 00:00:00","insp_start_time":"0826","insp_end_time":"0857","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"15870572","transaction_code":"A","transaction_date":"2025-06-17 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02948137","upload_search_indicator":null,"census_search_date":"2025-06-26 21:41:00","snet_input_date":"2025-06-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:41:00","insp_carrier_name":"ADAN A MENDEZ SOLA","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"498968","created_at":"2025-06-30T10:01:08.000000Z","updated_at":"2025-06-30T10:01:08.000000Z","inspection_violations":[{"id":14469407,"change_date":"2025-06-26 21:41:00","inspection_id":"85059040","insp_violation_id":"267073344","seq_no":"1","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"2","insp_unit_id":"207583511","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:56.000000Z","updated_at":"2025-06-30T10:18:28.000000Z","normalized_code":"393207ASAPPCBLM"}],"inspection_per_units":[{"id":14760277,"change_date":"2025-06-26 21:41:00","inspection_id":"85059040","insp_unit_id":"207583510","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2\/RED","insp_unit_license":"9E31444","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH4BN295744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:23.000000Z","updated_at":"2025-07-01T09:48:19.000000Z"},{"id":14760278,"change_date":"2025-06-26 21:41:00","inspection_id":"85059040","insp_unit_id":"207583511","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"FLTBD","insp_unit_license":"4PU4997","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W1BGB3B9TE308908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:23.000000Z","updated_at":"2025-07-01T09:48:19.000000Z"}]},{"id":8830672,"change_date":"2025-06-05 21:42:00","inspection_id":"84879184","dot_number":"2948137","report_state":"CA","report_number":"UEXA002394","insp_date":"2025-06-05 00:00:00","insp_start_time":"0650","insp_end_time":"0710","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"777 LOGISTICS","shipping_paper_number":"Y","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"114350","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":"15849142","transaction_code":"A","transaction_date":"2025-06-05 00:00:00","upload_date":"2025-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02948137","upload_search_indicator":null,"census_search_date":"2025-06-05 21:42:00","snet_input_date":"2025-06-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-05 21:42:00","insp_carrier_name":"ADAN A MENDEZ SOLA","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"498968","created_at":"2025-06-09T10:01:09.000000Z","updated_at":"2025-06-09T10:01:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14457703,"change_date":"2025-06-05 21:42:00","inspection_id":"84879184","insp_unit_id":"207252706","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"RED","insp_unit_license":"9E31444","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"X","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-08T09:46:30.000000Z","updated_at":"2025-06-09T09:46:11.000000Z"},{"id":14457704,"change_date":"2025-06-05 21:42:00","inspection_id":"84879184","insp_unit_id":"207252707","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"FB","insp_unit_license":"4PU4997","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"X","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-08T09:46:30.000000Z","updated_at":"2025-06-09T09:46:11.000000Z"}]},{"id":8840161,"change_date":"2025-06-06 21:40:00","inspection_id":"84889101","dot_number":"2948137","report_state":"CA","report_number":"UE1B001866","insp_date":"2025-06-05 00:00:00","insp_start_time":"0515","insp_end_time":"0552","registration_date":null,"region":"PT","ci_status_code":"C","location":"310","location_desc":"S\/B MARIN SCALES","county_code_state":"CA","county_code":"041","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"15850998","transaction_code":"A","transaction_date":"2025-06-05 00:00:00","upload_date":"2025-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02948137","upload_search_indicator":null,"census_search_date":"2025-06-06 21:40:00","snet_input_date":"2025-06-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-06 21:40:00","insp_carrier_name":"ADAN A MENDEZ SOLA","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"498968","created_at":"2025-06-09T10:01:21.000000Z","updated_at":"2025-06-10T10:00:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14474155,"change_date":"2025-06-06 21:40:00","inspection_id":"84889101","insp_unit_id":"207270533","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3XRED","insp_unit_license":"9E31444","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH4BN295744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-09T09:46:21.000000Z","updated_at":"2025-06-10T09:46:06.000000Z"},{"id":14474156,"change_date":"2025-06-06 21:40:00","inspection_id":"84889101","insp_unit_id":"207270534","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WLSON","insp_unit_company":"2X","insp_unit_license":"4PU4997","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W1BGB3B9TE308908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-09T09:46:21.000000Z","updated_at":"2025-06-10T09:46:06.000000Z"}]},{"id":8798969,"change_date":"2025-06-02 21:40:00","inspection_id":"84845524","dot_number":"2948137","report_state":"CA","report_number":"UDR4005695","insp_date":"2025-05-30 00:00:00","insp_start_time":"0810","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"150","location_desc":"UKIAH AREA -","county_code_state":"CA","county_code":"045","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":"2025-06-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15843908","transaction_code":"A","transaction_date":"2025-05-30 00:00:00","upload_date":"2025-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02948137","upload_search_indicator":null,"census_search_date":"2025-06-02 21:40:00","snet_input_date":"2025-05-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-02 21:40:00","insp_carrier_name":"ADAN A MENDEZ SOLA","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"498968","created_at":"2025-06-05T10:00:34.000000Z","updated_at":"2025-06-06T10:00:49.000000Z","inspection_violations":[{"id":14070820,"change_date":"2025-06-02 21:40:00","inspection_id":"84845524","insp_violation_id":"266619472","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-05T10:15:48.000000Z","updated_at":"2025-06-06T10:16:18.000000Z","normalized_code":"3922SLLS2"},{"id":14070821,"change_date":"2025-06-02 21:40:00","inspection_id":"84845524","insp_violation_id":"266619473","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"207189420","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-05T10:15:48.000000Z","updated_at":"2025-06-06T10:16:18.000000Z","normalized_code":"3922SLLSR"},{"id":14070822,"change_date":"2025-06-02 21:40:00","inspection_id":"84845524","insp_violation_id":"266619474","seq_no":"3","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"207189420","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA431737","created_at":"2025-06-05T10:15:48.000000Z","updated_at":"2025-06-06T10:16:18.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":14070823,"change_date":"2025-06-02 21:40:00","inspection_id":"84845524","insp_violation_id":"266619475","seq_no":"4","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"2","insp_unit_id":"207189420","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-05T10:15:48.000000Z","updated_at":"2025-06-06T10:16:18.000000Z","normalized_code":"39311A1LLPL"},{"id":14070824,"change_date":"2025-06-02 21:40:00","inspection_id":"84845524","insp_violation_id":"266619476","seq_no":"5","part_no":"393","part_no_section":"201A-FRMC","insp_viol_unit":"2","insp_unit_id":"207189420","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"RT75534","created_at":"2025-06-05T10:15:48.000000Z","updated_at":"2025-06-06T10:16:18.000000Z","normalized_code":"393201AFRMC"}],"inspection_per_units":[{"id":14399217,"change_date":"2025-06-02 21:40:00","inspection_id":"84845524","insp_unit_id":"207189420","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"305","insp_unit_license":"4PU4997","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W1BGB3B9TE308908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:30.000000Z","updated_at":"2025-06-06T09:46:15.000000Z"},{"id":14399218,"change_date":"2025-06-02 21:40:00","inspection_id":"84845524","insp_unit_id":"207189421","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2","insp_unit_license":"9E31444","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH4BN295744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:30.000000Z","updated_at":"2025-06-06T09:46:15.000000Z"}]},{"id":7305908,"change_date":"2024-11-30 21:33:00","inspection_id":"83274796","dot_number":"2948137","report_state":"CA","report_number":"NDUP006521","insp_date":"2024-11-26 00:00:00","insp_start_time":"1325","insp_end_time":"1349","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"3950 E\/B INTERSTATE 80","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"15606875","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02948137","upload_search_indicator":null,"census_search_date":"2024-11-30 21:33:00","snet_input_date":"2024-11-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"ADAN A MENDEZ SOLA","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"498968","created_at":"2025-03-17T20:48:33.000000Z","updated_at":"2025-03-17T20:48:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11785512,"change_date":"2024-11-30 21:33:00","inspection_id":"83274796","insp_unit_id":"204109722","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3777 3X","insp_unit_license":"9E31444","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH4BN295744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:10.000000Z","updated_at":"2025-03-17T23:45:10.000000Z"},{"id":11785513,"change_date":"2024-11-30 21:33:00","inspection_id":"83274796","insp_unit_id":"204109723","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"#531 2X","insp_unit_license":"4WK5323","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAP0627FT602531","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:10.000000Z","updated_at":"2025-03-17T23:45:10.000000Z"}]},{"id":5781682,"change_date":"2024-05-17 21:41:00","inspection_id":"81645328","dot_number":"2948137","report_state":"CA","report_number":"NDA2006133","insp_date":"2024-04-30 00:00:00","insp_start_time":"1736","insp_end_time":"1755","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50350","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":"15368200","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02948137","upload_search_indicator":null,"census_search_date":"2024-05-17 21:41:00","snet_input_date":"2024-04-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-17 21:41:00","insp_carrier_name":"ADAN A MENDEZ SOLA","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"498968","created_at":"2025-03-17T20:17:27.000000Z","updated_at":"2025-03-17T20:17:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9312326,"change_date":"2024-05-17 21:41:00","inspection_id":"81645328","insp_unit_id":"200960801","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"RED VOLVO","insp_unit_license":"9E31444","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH4BN295744","insp_unit_decal":"Y","insp_unit_decal_number":"33810067","created_at":"2025-03-17T23:19:42.000000Z","updated_at":"2025-03-17T23:19:42.000000Z"}]},{"id":5626952,"change_date":"2024-04-29 21:44:00","inspection_id":"81477483","dot_number":"2948137","report_state":"CA","report_number":"UD3C000293","insp_date":"2024-04-24 00:00:00","insp_start_time":"1200","insp_end_time":"1225","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-29 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"15338916","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02948137","upload_search_indicator":null,"census_search_date":"2024-04-29 21:44:00","snet_input_date":"2024-04-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-29 21:44:00","insp_carrier_name":"ADAN A MENDEZ SOLA","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"498968","created_at":"2025-03-17T20:14:17.000000Z","updated_at":"2025-03-17T20:14:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9063916,"change_date":"2024-04-29 21:44:00","inspection_id":"81477483","insp_unit_id":"200638101","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9E31444","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH4BN295744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:19.000000Z","updated_at":"2025-03-17T23:17:19.000000Z"},{"id":9063917,"change_date":"2024-04-29 21:44:00","inspection_id":"81477483","insp_unit_id":"200638102","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"W39434","insp_unit_license":"427279Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3V532C5KT680504","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:19.000000Z","updated_at":"2025-03-17T23:17:19.000000Z"}]},{"id":5263121,"change_date":"2024-03-11 21:44:00","inspection_id":"81080416","dot_number":"2948137","report_state":"CA","report_number":"NF37000048","insp_date":"2024-03-08 00:00:00","insp_start_time":"1540","insp_end_time":"1555","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-11 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"15275825","transaction_code":"A","transaction_date":"2024-03-08 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02948137","upload_search_indicator":null,"census_search_date":"2024-03-11 21:44:00","snet_input_date":"2024-03-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-11 21:44:00","insp_carrier_name":"ADAN A MENDEZ SOLA","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"498968","created_at":"2025-03-17T20:07:03.000000Z","updated_at":"2025-03-17T20:07:03.000000Z","inspection_violations":[{"id":8117242,"change_date":"2024-03-11 21:44:00","inspection_id":"81080416","insp_violation_id":"258328670","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199862780","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:13.000000Z","updated_at":"2025-03-17T21:45:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8475388,"change_date":"2024-03-11 21:44:00","inspection_id":"81080416","insp_unit_id":"199862780","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9E31444","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH4BN295744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:49.000000Z","updated_at":"2025-03-17T23:11:49.000000Z"},{"id":8475389,"change_date":"2024-03-11 21:44:00","inspection_id":"81080416","insp_unit_id":"199862781","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"790","insp_unit_license":"4KU3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1S12E95341E473996","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:49.000000Z","updated_at":"2025-03-17T23:11:49.000000Z"}]},{"id":5207485,"change_date":"2024-03-04 21:42:00","inspection_id":"81019554","dot_number":"2948137","report_state":"CA","report_number":"NCAT003867","insp_date":"2024-02-29 00:00:00","insp_start_time":"1743","insp_end_time":"1801","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ARDAGH GLASS","shipping_paper_number":"8002839365","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-03-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"15267165","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02948137","upload_search_indicator":null,"census_search_date":"2024-03-04 21:42:00","snet_input_date":"2024-02-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-04 21:42:00","insp_carrier_name":"ADAN A MENDEZ SOLA","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"498968","created_at":"2025-03-17T20:05:45.000000Z","updated_at":"2025-03-17T20:05:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8385224,"change_date":"2024-03-04 21:42:00","inspection_id":"81019554","insp_unit_id":"199747291","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"RED\/3XL","insp_unit_license":"9E31444","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH4BN295744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:59.000000Z","updated_at":"2025-03-17T23:10:59.000000Z"},{"id":8385225,"change_date":"2024-03-04 21:42:00","inspection_id":"81019554","insp_unit_id":"199747292","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"920","insp_unit_license":"4RG8694","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532WX8L096862","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:59.000000Z","updated_at":"2025-03-17T23:10:59.000000Z"}]},{"id":5163359,"change_date":"2024-02-28 21:43:00","inspection_id":"80971468","dot_number":"2948137","report_state":"CA","report_number":"NDUP005396","insp_date":"2024-02-06 00:00:00","insp_start_time":"1304","insp_end_time":"1337","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"15251193","transaction_code":"A","transaction_date":"2024-02-06 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02948137","upload_search_indicator":null,"census_search_date":"2024-02-28 21:43:00","snet_input_date":"2024-02-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"ADAN A MENDEZ SOLA","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"498968","created_at":"2025-03-17T20:04:56.000000Z","updated_at":"2025-03-17T20:04:56.000000Z","inspection_violations":[{"id":7960397,"change_date":"2024-02-28 21:43:00","inspection_id":"80971468","insp_violation_id":"258100569","seq_no":"1","part_no":"393","part_no_section":"207(b)","insp_viol_unit":"2","insp_unit_id":"199658192","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:29.000000Z","updated_at":"2025-03-17T21:44:29.000000Z","normalized_code":"393207B"}],"inspection_per_units":[{"id":8313280,"change_date":"2024-02-28 21:43:00","inspection_id":"80971468","insp_unit_id":"199658191","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X RED","insp_unit_license":"9E31444","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH4BN295744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:20.000000Z","updated_at":"2025-03-17T23:10:20.000000Z"},{"id":8313281,"change_date":"2024-02-28 21:43:00","inspection_id":"80971468","insp_unit_id":"199658192","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"W92917 2X","insp_unit_license":"113467T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1P0620MJ228496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:20.000000Z","updated_at":"2025-03-17T23:10:20.000000Z"}]},{"id":3979316,"change_date":"2023-09-14 21:42:00","inspection_id":"79669784","dot_number":"2948137","report_state":"CA","report_number":"UDBH002087","insp_date":"2023-09-14 00:00:00","insp_start_time":"1330","insp_end_time":"1401","registration_date":null,"region":"PT","ci_status_code":"C","location":"360","location_desc":"LAKEVILLE RD N OF SR37","county_code_state":"CA","county_code":"097","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15062431","transaction_code":"A","transaction_date":"2023-09-14 00:00:00","upload_date":"2023-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02948137","upload_search_indicator":null,"census_search_date":"2023-09-14 21:42:00","snet_input_date":"2023-09-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-14 21:42:00","insp_carrier_name":"ADAN A MENDEZ SOLA","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"498968","created_at":"2025-03-17T19:41:16.000000Z","updated_at":"2025-03-17T19:41:16.000000Z","inspection_violations":[{"id":6154145,"change_date":"2023-09-14 21:42:00","inspection_id":"79669784","insp_violation_id":"255283819","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"3922"},{"id":6154146,"change_date":"2023-09-14 21:42:00","inspection_id":"79669784","insp_violation_id":"255283820","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MD56324","created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6398710,"change_date":"2023-09-14 21:42:00","inspection_id":"79669784","insp_unit_id":"197068976","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9E31444","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH4BN295744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:43.000000Z","updated_at":"2025-03-17T22:53:43.000000Z"},{"id":6398711,"change_date":"2023-09-14 21:42:00","inspection_id":"79669784","insp_unit_id":"197068977","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"113467T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1P0620MJ228496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:43.000000Z","updated_at":"2025-03-17T22:53:43.000000Z"}]},{"id":3679096,"change_date":"2023-08-04 21:41:00","inspection_id":"79335166","dot_number":"2948137","report_state":"CA","report_number":"UE5M003015","insp_date":"2023-07-27 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"15008805","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02948137","upload_search_indicator":null,"census_search_date":"2023-08-04 21:41:00","snet_input_date":"2023-07-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"ADAN A MENDEZ SOLA","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"498968","created_at":"2025-03-17T19:35:20.000000Z","updated_at":"2025-03-17T19:35:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5915177,"change_date":"2023-08-04 21:41:00","inspection_id":"79335166","insp_unit_id":"196383664","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9D74974","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDV0BSAX7215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:44.000000Z","updated_at":"2025-03-17T22:49:44.000000Z"},{"id":5915178,"change_date":"2023-08-04 21:41:00","inspection_id":"79335166","insp_unit_id":"196383665","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"BK9524","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JJV532W05L942413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:44.000000Z","updated_at":"2025-03-17T22:49:44.000000Z"}]},{"id":3127187,"change_date":"2023-05-23 21:43:00","inspection_id":"78713950","dot_number":"2948137","report_state":"CA","report_number":"UE5M002835","insp_date":"2023-05-19 00:00:00","insp_start_time":"1110","insp_end_time":"1123","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14914592","transaction_code":"A","transaction_date":"2023-05-19 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02948137","upload_search_indicator":null,"census_search_date":"2023-05-23 21:43:00","snet_input_date":"2023-05-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-23 21:43:00","insp_carrier_name":"ADAN A MENDEZ SOLA","insp_carrier_street":"2830 APACHE ST","insp_carrier_city":"SANTA ROSA","insp_carrier_state":"CA","insp_carrier_zip_code":"95403","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:57.000000Z","updated_at":"2025-03-17T19:24:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5029957,"change_date":"2023-05-23 21:43:00","inspection_id":"78713950","insp_unit_id":"195111182","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9D74974","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDV0BSAX7215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:38.000000Z","updated_at":"2025-03-17T22:42:38.000000Z"},{"id":5029958,"change_date":"2023-05-23 21:43:00","inspection_id":"78713950","insp_unit_id":"195111183","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4RG8689","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W88L096858","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:38.000000Z","updated_at":"2025-03-17T22:42:38.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2948137\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2948137\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2948137\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2948137\/inspections","per_page":100,"prev_page_url":null,"to":14,"total":14}