{"current_page":1,"data":[{"id":9356423,"change_date":"2025-08-07 21:40:00","inspection_id":"85433793","dot_number":"1882468","report_state":"CA","report_number":"NBYQ008065","insp_date":"2025-08-06 00:00:00","insp_start_time":"1920","insp_end_time":"1940","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"CONEJO IF","county_code_state":"CA","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15928021","transaction_code":"A","transaction_date":"2025-08-06 00:00:00","upload_date":"2025-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2025-08-07 21:40:00","snet_input_date":"2025-08-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-07 21:40:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"385004","created_at":"2025-08-12T10:44:01.000000Z","updated_at":"2025-08-12T10:44:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15413865,"change_date":"2025-08-07 21:40:00","inspection_id":"85433793","insp_unit_id":"208290291","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9H11604","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV5GSHG0559","insp_unit_decal":"Y","insp_unit_decal_number":"35366217","created_at":"2025-08-10T09:46:24.000000Z","updated_at":"2025-08-11T09:46:13.000000Z"}]},{"id":9107288,"change_date":"2025-07-09 21:43:00","inspection_id":"85171612","dot_number":"1882468","report_state":"CA","report_number":"UEL1001463","insp_date":"2025-07-09 00:00:00","insp_start_time":"0925","insp_end_time":"0954","registration_date":null,"region":"PT","ci_status_code":"C","location":"9750","location_desc":"GIANT","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15890852","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2025-07-09 21:43:00","snet_input_date":"2025-07-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-09 21:43:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-12T10:45:33.000000Z","updated_at":"2025-07-14T10:46:35.000000Z","inspection_violations":[{"id":14676173,"change_date":"2025-07-09 21:43:00","inspection_id":"85171612","insp_violation_id":"267311548","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207790046","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:22.000000Z","updated_at":"2025-07-13T10:49:22.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":14949866,"change_date":"2025-07-09 21:43:00","inspection_id":"85171612","insp_unit_id":"207790046","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"75710E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXFE3MDMZ0782","insp_unit_decal":"Y","insp_unit_decal_number":"35371257","created_at":"2025-07-12T09:45:59.000000Z","updated_at":"2025-07-13T09:46:47.000000Z"}]},{"id":9107329,"change_date":"2025-07-09 21:43:00","inspection_id":"85171655","dot_number":"1882468","report_state":"CA","report_number":"UEL1001466","insp_date":"2025-07-09 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"9750","location_desc":"GIANT","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15891467","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2025-07-09 21:43:00","snet_input_date":"2025-07-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-09 21:43:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-12T10:45:33.000000Z","updated_at":"2025-07-14T10:46:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14949935,"change_date":"2025-07-09 21:43:00","inspection_id":"85171655","insp_unit_id":"207790127","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9E56669","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV3DSFF3230","insp_unit_decal":"Y","insp_unit_decal_number":"35371258","created_at":"2025-07-12T09:45:59.000000Z","updated_at":"2025-07-13T09:46:47.000000Z"}]},{"id":9116786,"change_date":"2025-07-10 21:39:00","inspection_id":"85181840","dot_number":"1882468","report_state":"CA","report_number":"UEL1001468","insp_date":"2025-07-09 00:00:00","insp_start_time":"1135","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":"9750","location_desc":"GIANT","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15891891","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2025-07-10 21:39:00","snet_input_date":"2025-07-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-10 21:39:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-14T10:46:52.000000Z","updated_at":"2025-07-14T10:46:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14967133,"change_date":"2025-07-10 21:39:00","inspection_id":"85181840","insp_unit_id":"207808725","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9F72230","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV0HSJF7337","insp_unit_decal":"Y","insp_unit_decal_number":"35371259","created_at":"2025-07-13T09:46:59.000000Z","updated_at":"2025-07-14T09:45:56.000000Z"}]},{"id":5648804,"change_date":"2024-05-01 21:43:00","inspection_id":"81501141","dot_number":"1882468","report_state":"CA","report_number":"UEL1999400","insp_date":"2024-04-30 00:00:00","insp_start_time":"1045","insp_end_time":"1103","registration_date":null,"region":"PT","ci_status_code":"C","location":"9750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15343133","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2024-05-01 21:43:00","snet_input_date":"2024-04-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-01 21:43:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:42.000000Z","updated_at":"2025-03-17T20:14:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9098580,"change_date":"2024-05-01 21:43:00","inspection_id":"81501141","insp_unit_id":"200683125","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"PTW-2","insp_unit_license":"35823R3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXDT9GHHR1611","insp_unit_decal":"Y","insp_unit_decal_number":"33866725","created_at":"2025-03-17T23:17:39.000000Z","updated_at":"2025-03-17T23:17:39.000000Z"}]},{"id":5602043,"change_date":"2024-04-25 21:43:00","inspection_id":"81450157","dot_number":"1882468","report_state":"CA","report_number":"UE3A001543","insp_date":"2024-04-25 00:00:00","insp_start_time":"1040","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"801","location_desc":"SAN BERNARDINO AREA","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","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":"15335419","transaction_code":"A","transaction_date":"2024-04-25 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2024-04-25 21:43:00","snet_input_date":"2024-04-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"385004","created_at":"2025-03-17T20:13:50.000000Z","updated_at":"2025-03-17T20:13:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9023653,"change_date":"2024-04-25 21:43:00","inspection_id":"81450157","insp_unit_id":"200586405","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"WEST","insp_unit_company":null,"insp_unit_license":"4JZ9676","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16WTE20188A136241","insp_unit_decal":"Y","insp_unit_decal_number":"33877032","created_at":"2025-03-17T23:16:57.000000Z","updated_at":"2025-03-17T23:16:57.000000Z"}]},{"id":5184367,"change_date":"2024-02-29 21:48:00","inspection_id":"80994267","dot_number":"1882468","report_state":"CA","report_number":"UD9W003733","insp_date":"2024-02-28 00:00:00","insp_start_time":"0800","insp_end_time":"0837","registration_date":null,"region":"PT","ci_status_code":"C","location":"840","location_desc":"17333 VAN BUREN BLVD","county_code_state":"CA","county_code":"065","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-02-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"15263906","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2024-02-29 21:48:00","snet_input_date":"2024-02-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-29 21:48:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:20.000000Z","updated_at":"2025-03-17T20:05:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8347551,"change_date":"2024-02-29 21:48:00","inspection_id":"80994267","insp_unit_id":"199699958","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4","insp_unit_license":"9C17187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJAHAS11LH79274","insp_unit_decal":"Y","insp_unit_decal_number":"33588255","created_at":"2025-03-17T23:10:38.000000Z","updated_at":"2025-03-17T23:10:38.000000Z"}]},{"id":5184368,"change_date":"2024-02-29 21:48:00","inspection_id":"80994268","dot_number":"1882468","report_state":"CA","report_number":"UD9W003734","insp_date":"2024-02-28 00:00:00","insp_start_time":"0840","insp_end_time":"0904","registration_date":null,"region":"PT","ci_status_code":"C","location":"840","location_desc":"17333 VAN BUREN BLVD","county_code_state":"CA","county_code":"065","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-02-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15262249","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2024-02-29 21:48:00","snet_input_date":"2024-02-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-29 21:48:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:20.000000Z","updated_at":"2025-03-17T20:05:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8347552,"change_date":"2024-02-29 21:48:00","inspection_id":"80994268","insp_unit_id":"199699959","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GREY4","insp_unit_license":"01441P2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXFE2KHKJ6271","insp_unit_decal":"Y","insp_unit_decal_number":"33588256","created_at":"2025-03-17T23:10:38.000000Z","updated_at":"2025-03-17T23:10:38.000000Z"}]},{"id":5184369,"change_date":"2024-02-29 21:48:00","inspection_id":"80994269","dot_number":"1882468","report_state":"CA","report_number":"UD9W003735","insp_date":"2024-02-28 00:00:00","insp_start_time":"0905","insp_end_time":"0925","registration_date":null,"region":"PT","ci_status_code":"C","location":"840","location_desc":"17333 VAN BUREN BLVD","county_code_state":"CA","county_code":"065","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-02-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15262274","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2024-02-29 21:48:00","snet_input_date":"2024-02-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-29 21:48:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:20.000000Z","updated_at":"2025-03-17T20:05:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8347553,"change_date":"2024-02-29 21:48:00","inspection_id":"80994269","insp_unit_id":"199699960","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GREY5","insp_unit_license":"79543D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXFE1MDMZ0781","insp_unit_decal":"Y","insp_unit_decal_number":"33588257","created_at":"2025-03-17T23:10:38.000000Z","updated_at":"2025-03-17T23:10:38.000000Z"}]},{"id":5168479,"change_date":"2024-02-28 21:43:00","inspection_id":"80976820","dot_number":"1882468","report_state":"CA","report_number":"UEL1001048","insp_date":"2024-02-27 00:00:00","insp_start_time":"1130","insp_end_time":"1203","registration_date":null,"region":"PT","ci_status_code":"C","location":"9750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"15261290","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2024-02-28 21:43:00","snet_input_date":"2024-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"385004","created_at":"2025-03-17T20:04:57.000000Z","updated_at":"2025-03-17T20:04:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8321336,"change_date":"2024-02-28 21:43:00","inspection_id":"80976820","insp_unit_id":"199666942","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"21992A2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0W5HT2GEC23899","insp_unit_decal":"Y","insp_unit_decal_number":"33581157","created_at":"2025-03-17T23:10:25.000000Z","updated_at":"2025-03-17T23:10:25.000000Z"}]},{"id":5168480,"change_date":"2024-02-28 21:43:00","inspection_id":"80976821","dot_number":"1882468","report_state":"CA","report_number":"UEL1001049","insp_date":"2024-02-27 00:00:00","insp_start_time":"1212","insp_end_time":"1248","registration_date":null,"region":"PT","ci_status_code":"C","location":"9750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15259163","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2024-02-28 21:43:00","snet_input_date":"2024-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:57.000000Z","updated_at":"2025-03-17T20:04:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8321337,"change_date":"2024-02-28 21:43:00","inspection_id":"80976821","insp_unit_id":"199666943","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"SHORTY1","insp_unit_license":"9E56669","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV3DSFF3230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:25.000000Z","updated_at":"2025-03-17T23:10:25.000000Z"},{"id":8321338,"change_date":"2024-02-28 21:43:00","inspection_id":"80976821","insp_unit_id":"199666944","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREA","insp_unit_company":null,"insp_unit_license":"4UU2037","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0623GK258916","insp_unit_decal":"Y","insp_unit_decal_number":"33581158","created_at":"2025-03-17T23:10:25.000000Z","updated_at":"2025-03-17T23:10:25.000000Z"}]},{"id":5168481,"change_date":"2024-02-28 21:43:00","inspection_id":"80976822","dot_number":"1882468","report_state":"CA","report_number":"UEL1001050","insp_date":"2024-02-27 00:00:00","insp_start_time":"1253","insp_end_time":"1349","registration_date":null,"region":"PT","ci_status_code":"C","location":"9750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15258279","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2024-02-28 21:43:00","snet_input_date":"2024-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:57.000000Z","updated_at":"2025-03-17T20:04:57.000000Z","inspection_violations":[{"id":7965259,"change_date":"2024-02-28 21:43:00","inspection_id":"80976822","insp_violation_id":"258106032","seq_no":"1","part_no":"393","part_no_section":"70(b)(1)(i)","insp_viol_unit":"1","insp_unit_id":"199666945","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:30.000000Z","updated_at":"2025-03-17T21:44:30.000000Z","normalized_code":"39370B1I"},{"id":7965260,"change_date":"2024-02-28 21:43:00","inspection_id":"80976822","insp_violation_id":"258106033","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199666946","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:30.000000Z","updated_at":"2025-03-17T21:44:30.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8321339,"change_date":"2024-02-28 21:43:00","inspection_id":"80976822","insp_unit_id":"199666945","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9F54124","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV5GSHG0559","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:25.000000Z","updated_at":"2025-03-17T23:10:25.000000Z"},{"id":8321340,"change_date":"2024-02-28 21:43:00","inspection_id":"80976822","insp_unit_id":"199666946","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4RL3141","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B3LL174727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:25.000000Z","updated_at":"2025-03-17T23:10:25.000000Z"}]},{"id":5168482,"change_date":"2024-02-28 21:43:00","inspection_id":"80976823","dot_number":"1882468","report_state":"CA","report_number":"UEL1001051","insp_date":"2024-02-27 00:00:00","insp_start_time":"1401","insp_end_time":"1420","registration_date":null,"region":"PT","ci_status_code":"C","location":"9750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"15258658","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2024-02-28 21:43:00","snet_input_date":"2024-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:57.000000Z","updated_at":"2025-03-17T20:04:57.000000Z","inspection_violations":[{"id":7965261,"change_date":"2024-02-28 21:43:00","inspection_id":"80976823","insp_violation_id":"258106034","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199666947","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:30.000000Z","updated_at":"2025-03-17T21:44:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8321341,"change_date":"2024-02-28 21:43:00","inspection_id":"80976823","insp_unit_id":"199666947","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"550-2","insp_unit_license":"62381Z1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0W5HTXGEC33418","insp_unit_decal":"Y","insp_unit_decal_number":"33581159","created_at":"2025-03-17T23:10:25.000000Z","updated_at":"2025-03-17T23:10:25.000000Z"}]},{"id":5168615,"change_date":"2024-02-28 21:43:00","inspection_id":"80976976","dot_number":"1882468","report_state":"CA","report_number":"UEL1001052","insp_date":"2024-02-27 00:00:00","insp_start_time":"1420","insp_end_time":"1445","registration_date":null,"region":"PT","ci_status_code":"C","location":"9750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15260470","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2024-02-28 21:43:00","snet_input_date":"2024-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:57.000000Z","updated_at":"2025-03-17T20:04:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8321554,"change_date":"2024-02-28 21:43:00","inspection_id":"80976976","insp_unit_id":"199667194","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GREY 6","insp_unit_license":"75710E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXFE3MDMZ0782","insp_unit_decal":"Y","insp_unit_decal_number":"33581160","created_at":"2025-03-17T23:10:25.000000Z","updated_at":"2025-03-17T23:10:25.000000Z"}]},{"id":5128205,"change_date":"2024-02-23 21:42:00","inspection_id":"80933340","dot_number":"1882468","report_state":"CA","report_number":"UEL1001046","insp_date":"2024-02-22 00:00:00","insp_start_time":"1430","insp_end_time":"1510","registration_date":null,"region":"PT","ci_status_code":"C","location":"9750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"141250","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":"15247473","transaction_code":"A","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2024-02-23 21:42:00","snet_input_date":"2024-02-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-23 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:12.000000Z","updated_at":"2025-03-17T20:04:12.000000Z","inspection_violations":[{"id":7908008,"change_date":"2024-02-23 21:42:00","inspection_id":"80933340","insp_violation_id":"258020626","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199584480","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:13.000000Z","updated_at":"2025-03-17T21:44:13.000000Z","normalized_code":"3939A"},{"id":7908009,"change_date":"2024-02-23 21:42:00","inspection_id":"80933340","insp_violation_id":"258020627","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199584481","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:13.000000Z","updated_at":"2025-03-17T21:44:13.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8256095,"change_date":"2024-02-23 21:42:00","inspection_id":"80933340","insp_unit_id":"199584480","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"SHORTY1","insp_unit_license":"9E56669","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV3DSFF3230","insp_unit_decal":"Y","insp_unit_decal_number":"33580808","created_at":"2025-03-17T23:09:50.000000Z","updated_at":"2025-03-17T23:09:50.000000Z"},{"id":8256096,"change_date":"2024-02-23 21:42:00","inspection_id":"80933340","insp_unit_id":"199584481","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":null,"insp_unit_license":"4ND7612","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4WW5482A8E6621679","insp_unit_decal":"Y","insp_unit_decal_number":"33580807","created_at":"2025-03-17T23:09:50.000000Z","updated_at":"2025-03-17T23:09:50.000000Z"}]},{"id":5128214,"change_date":"2024-02-23 21:42:00","inspection_id":"80933349","dot_number":"1882468","report_state":"CA","report_number":"UEL1001047","insp_date":"2024-02-22 00:00:00","insp_start_time":"1510","insp_end_time":"1550","registration_date":null,"region":"PT","ci_status_code":"C","location":"9750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15247799","transaction_code":"A","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2024-02-23 21:42:00","snet_input_date":"2024-02-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-23 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:12.000000Z","updated_at":"2025-03-17T20:04:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8256108,"change_date":"2024-02-23 21:42:00","inspection_id":"80933349","insp_unit_id":"199584493","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2035-1","insp_unit_license":"8U42245","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NPLHN6X98M754996","insp_unit_decal":"Y","insp_unit_decal_number":"33580806","created_at":"2025-03-17T23:09:50.000000Z","updated_at":"2025-03-17T23:09:50.000000Z"}]},{"id":3851930,"change_date":"2023-08-28 21:43:00","inspection_id":"79528042","dot_number":"1882468","report_state":"CA","report_number":"UCTO001564","insp_date":"2023-08-28 00:00:00","insp_start_time":"1030","insp_end_time":"1050","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15041550","transaction_code":"A","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-08-28 21:43:00","snet_input_date":"2023-08-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-28 21:43:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:56.000000Z","updated_at":"2025-03-17T19:38:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6193264,"change_date":"2023-08-28 21:43:00","inspection_id":"79528042","insp_unit_id":"196774198","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9F54124","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV5GSHG0559","insp_unit_decal":"Y","insp_unit_decal_number":"32922429","created_at":"2025-03-17T22:52:02.000000Z","updated_at":"2025-03-17T22:52:02.000000Z"}]},{"id":3125002,"change_date":"2023-05-23 21:43:00","inspection_id":"78711600","dot_number":"1882468","report_state":"CA","report_number":"UCTO001431","insp_date":"2023-05-19 00:00:00","insp_start_time":"1310","insp_end_time":"1340","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","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":"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":"Y","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":"80000","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":"14911110","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":"01882468","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":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:56.000000Z","updated_at":"2025-03-17T19:24:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5026464,"change_date":"2023-05-23 21:43:00","inspection_id":"78711600","insp_unit_id":"195107310","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"MNTR","insp_unit_company":null,"insp_unit_license":"4MH4036","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5MC125310D5136105","insp_unit_decal":"Y","insp_unit_decal_number":"32552792","created_at":"2025-03-17T22:42:38.000000Z","updated_at":"2025-03-17T22:42:38.000000Z"}]},{"id":2400785,"change_date":"2023-02-17 21:40:00","inspection_id":"77889907","dot_number":"1882468","report_state":"CA","report_number":"UD9W003032","insp_date":"2023-02-17 00:00:00","insp_start_time":"0740","insp_end_time":"0810","registration_date":null,"region":"PT","ci_status_code":"C","location":"840","location_desc":"17333 VAN BUREN BLVD","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14789852","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":"01882468","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":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:01.000000Z","updated_at":"2025-03-17T19:11:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3863566,"change_date":"2023-02-17 21:40:00","inspection_id":"77889907","insp_unit_id":"193469436","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5\/WHT","insp_unit_license":"79543D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXFE1MDMZ0781","insp_unit_decal":"Y","insp_unit_decal_number":"32220223","created_at":"2025-03-17T22:33:40.000000Z","updated_at":"2025-03-17T22:33:40.000000Z"}]},{"id":2400786,"change_date":"2023-02-17 21:40:00","inspection_id":"77889908","dot_number":"1882468","report_state":"CA","report_number":"UD9W003033","insp_date":"2023-02-17 00:00:00","insp_start_time":"0811","insp_end_time":"0836","registration_date":null,"region":"PT","ci_status_code":"C","location":"840","location_desc":"17333 VAN BUREN BLVD","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14789366","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":"01882468","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":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:01.000000Z","updated_at":"2025-03-17T19:11:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3863567,"change_date":"2023-02-17 21:40:00","inspection_id":"77889908","insp_unit_id":"193469437","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4","insp_unit_license":"01441P2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXFE2KHKJ6271","insp_unit_decal":"Y","insp_unit_decal_number":"32220224","created_at":"2025-03-17T22:33:40.000000Z","updated_at":"2025-03-17T22:33:40.000000Z"}]},{"id":2400787,"change_date":"2023-02-17 21:40:00","inspection_id":"77889909","dot_number":"1882468","report_state":"CA","report_number":"UD9W003034","insp_date":"2023-02-17 00:00:00","insp_start_time":"0837","insp_end_time":"0908","registration_date":null,"region":"PT","ci_status_code":"C","location":"840","location_desc":"17333 VAN BUREN BLVD","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"88000","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":"14789853","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":"01882468","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":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:01.000000Z","updated_at":"2025-03-17T19:11:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3863568,"change_date":"2023-02-17 21:40:00","inspection_id":"77889909","insp_unit_id":"193469438","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"T4","insp_unit_license":"9C17187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJAHAS11LH79274","insp_unit_decal":"Y","insp_unit_decal_number":"32220225","created_at":"2025-03-17T22:33:40.000000Z","updated_at":"2025-03-17T22:33:40.000000Z"},{"id":3863569,"change_date":"2023-02-17 21:40:00","inspection_id":"77889909","insp_unit_id":"193469439","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESTM","insp_unit_company":"PT1","insp_unit_license":"4JZ9676","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16WTE20188A136241","insp_unit_decal":"Y","insp_unit_decal_number":"32220226","created_at":"2025-03-17T22:33:40.000000Z","updated_at":"2025-03-17T22:33:40.000000Z"}]},{"id":2401636,"change_date":"2023-02-17 21:40:00","inspection_id":"77890829","dot_number":"1882468","report_state":"CA","report_number":"UEG9000380","insp_date":"2023-02-17 00:00:00","insp_start_time":"0910","insp_end_time":"0945","registration_date":null,"region":"PT","ci_status_code":"C","location":"840","location_desc":"17333 VAN BUREN BLVD","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"14789610","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":"01882468","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":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:01.000000Z","updated_at":"2025-03-17T19:11:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3864775,"change_date":"2023-02-17 21:40:00","inspection_id":"77890829","insp_unit_id":"193470806","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"WANC","insp_unit_company":"TT2","insp_unit_license":"4KH9215","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV482U3VL425170","insp_unit_decal":"Y","insp_unit_decal_number":"32220227","created_at":"2025-03-17T22:33:40.000000Z","updated_at":"2025-03-17T22:33:40.000000Z"}]},{"id":2401637,"change_date":"2023-02-17 21:40:00","inspection_id":"77890830","dot_number":"1882468","report_state":"CA","report_number":"UEG9000381","insp_date":"2023-02-17 00:00:00","insp_start_time":"0951","insp_end_time":"1021","registration_date":null,"region":"PT","ci_status_code":"C","location":"840","location_desc":"17333 VAN BUREN BLVD","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"67200","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":"14789885","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":"01882468","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":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:01.000000Z","updated_at":"2025-03-17T19:11:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3864776,"change_date":"2023-02-17 21:40:00","inspection_id":"77890830","insp_unit_id":"193470807","insp_unit_type_id":"14","insp_unit_number":"1","insp_unit_make":"CIMC","insp_unit_company":"TRLZ 403738","insp_unit_license":"4MS2132","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"LJRC4126X61019868","insp_unit_decal":"Y","insp_unit_decal_number":"32220228","created_at":"2025-03-17T22:33:40.000000Z","updated_at":"2025-03-17T22:33:40.000000Z"}]},{"id":2401638,"change_date":"2023-02-17 21:40:00","inspection_id":"77890831","dot_number":"1882468","report_state":"CA","report_number":"UEG9000382","insp_date":"2023-02-17 00:00:00","insp_start_time":"1022","insp_end_time":"1050","registration_date":null,"region":"PT","ci_status_code":"C","location":"840","location_desc":"17333 VAN BUREN BLVD","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"14789588","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":"01882468","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":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:01.000000Z","updated_at":"2025-03-17T19:11:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3864777,"change_date":"2023-02-17 21:40:00","inspection_id":"77890831","insp_unit_id":"193470808","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"VANR","insp_unit_company":"ST1","insp_unit_license":"4HG6643","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5V8VA53277M708551","insp_unit_decal":"Y","insp_unit_decal_number":"32220229","created_at":"2025-03-17T22:33:40.000000Z","updated_at":"2025-03-17T22:33:40.000000Z"}]},{"id":2279351,"change_date":"2023-02-01 21:42:00","inspection_id":"77751241","dot_number":"1882468","report_state":"CA","report_number":"UCTO001334","insp_date":"2023-02-01 00:00:00","insp_start_time":"0905","insp_end_time":"0920","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"93200","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":"14765804","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669245,"change_date":"2023-02-01 21:42:00","inspection_id":"77751241","insp_unit_id":"193184941","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9E56669","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV3DSFF3230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"},{"id":3669246,"change_date":"2023-02-01 21:42:00","inspection_id":"77751241","insp_unit_id":"193184942","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAIL","insp_unit_company":null,"insp_unit_license":"4LV7621","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1PT07ANE9X9014135","insp_unit_decal":"Y","insp_unit_decal_number":"32216613","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279394,"change_date":"2023-02-01 21:42:00","inspection_id":"77751285","dot_number":"1882468","report_state":"CA","report_number":"UCTO001335","insp_date":"2023-02-01 00:00:00","insp_start_time":"0920","insp_end_time":"0940","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"49000","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":"14766330","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669305,"change_date":"2023-02-01 21:42:00","inspection_id":"77751285","insp_unit_id":"193185003","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"00517P2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXFE4KHKJ6272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"},{"id":3669306,"change_date":"2023-02-01 21:42:00","inspection_id":"77751285","insp_unit_id":"193185004","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FLEM","insp_unit_company":null,"insp_unit_license":"4RZ4186","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1F9SS1415F1025817","insp_unit_decal":"Y","insp_unit_decal_number":"32216638","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279395,"change_date":"2023-02-01 21:42:00","inspection_id":"77751286","dot_number":"1882468","report_state":"CA","report_number":"UCTO001336","insp_date":"2023-02-01 00:00:00","insp_start_time":"0940","insp_end_time":"0955","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"90000","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":"14766395","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669307,"change_date":"2023-02-01 21:42:00","inspection_id":"77751286","insp_unit_id":"193185005","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"4KP5846","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRDM02285M700956","insp_unit_decal":"Y","insp_unit_decal_number":"32216639","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279396,"change_date":"2023-02-01 21:42:00","inspection_id":"77751287","dot_number":"1882468","report_state":"CA","report_number":"UCTO001337","insp_date":"2023-02-01 00:00:00","insp_start_time":"1000","insp_end_time":"1015","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"51000","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":"14766543","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669308,"change_date":"2023-02-01 21:42:00","inspection_id":"77751287","insp_unit_id":"193185006","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"00517P2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXFE4KHKJ6272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"},{"id":3669309,"change_date":"2023-02-01 21:42:00","inspection_id":"77751287","insp_unit_id":"193185007","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JAG","insp_unit_company":null,"insp_unit_license":"4RZ4167","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1J9HSHG26JH358567","insp_unit_decal":"Y","insp_unit_decal_number":"32216640","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279397,"change_date":"2023-02-01 21:42:00","inspection_id":"77751288","dot_number":"1882468","report_state":"CA","report_number":"UCTO001338","insp_date":"2023-02-01 00:00:00","insp_start_time":"1035","insp_end_time":"1050","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"47000","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":"14765914","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669310,"change_date":"2023-02-01 21:42:00","inspection_id":"77751288","insp_unit_id":"193185008","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"8U42245","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NPLHN6X98M754996","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"},{"id":3669311,"change_date":"2023-02-01 21:42:00","inspection_id":"77751288","insp_unit_id":"193185009","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JAG","insp_unit_company":null,"insp_unit_license":"4VB6343","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1J9HSGF26PH358606","insp_unit_decal":"Y","insp_unit_decal_number":"32216641","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279434,"change_date":"2023-02-01 21:42:00","inspection_id":"77751327","dot_number":"1882468","report_state":"CA","report_number":"UCTO001339","insp_date":"2023-02-01 00:00:00","insp_start_time":"1050","insp_end_time":"1105","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"51000","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":"14766070","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669370,"change_date":"2023-02-01 21:42:00","inspection_id":"77751327","insp_unit_id":"193185072","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"75710E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXFE3MDMZ0782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"},{"id":3669371,"change_date":"2023-02-01 21:42:00","inspection_id":"77751327","insp_unit_id":"193185073","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KENT","insp_unit_company":null,"insp_unit_license":"4RW1370","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1K9BU3832J1236407","insp_unit_decal":"Y","insp_unit_decal_number":"32216642","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279435,"change_date":"2023-02-01 21:42:00","inspection_id":"77751328","dot_number":"1882468","report_state":"CA","report_number":"UCTO001340","insp_date":"2023-02-01 00:00:00","insp_start_time":"1105","insp_end_time":"1120","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"45000","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":"14766272","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669372,"change_date":"2023-02-01 21:42:00","inspection_id":"77751328","insp_unit_id":"193185074","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"00517P2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXFE4KHKJ6272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"},{"id":3669373,"change_date":"2023-02-01 21:42:00","inspection_id":"77751328","insp_unit_id":"193185075","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RICH","insp_unit_company":null,"insp_unit_license":"4TX4032","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1K9BU2529M1236382","insp_unit_decal":"Y","insp_unit_decal_number":"32216643","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279436,"change_date":"2023-02-01 21:42:00","inspection_id":"77751329","dot_number":"1882468","report_state":"CA","report_number":"UCTO001341","insp_date":"2023-02-01 00:00:00","insp_start_time":"1130","insp_end_time":"1145","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"39000","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":"14765756","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669374,"change_date":"2023-02-01 21:42:00","inspection_id":"77751329","insp_unit_id":"193185076","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"8U42245","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NPLHN6X98M754996","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"},{"id":3669375,"change_date":"2023-02-01 21:42:00","inspection_id":"77751329","insp_unit_id":"193185077","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOWB","insp_unit_company":null,"insp_unit_license":"4JJ5626","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1B9CF34T8KB051844","insp_unit_decal":"Y","insp_unit_decal_number":"32216644","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279437,"change_date":"2023-02-01 21:42:00","inspection_id":"77751330","dot_number":"1882468","report_state":"CA","report_number":"UCTO001342","insp_date":"2023-02-01 00:00:00","insp_start_time":"1150","insp_end_time":"1205","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"47000","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":"14765850","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669376,"change_date":"2023-02-01 21:42:00","inspection_id":"77751330","insp_unit_id":"193185078","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"75710E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXFE3MDMZ0782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"},{"id":3669377,"change_date":"2023-02-01 21:42:00","inspection_id":"77751330","insp_unit_id":"193185079","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JAG","insp_unit_company":null,"insp_unit_license":"4VB6344","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1J9HSGF24PH358605","insp_unit_decal":"Y","insp_unit_decal_number":"32216645","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279471,"change_date":"2023-02-01 21:42:00","inspection_id":"77751367","dot_number":"1882468","report_state":"CA","report_number":"UCTO001343","insp_date":"2023-02-01 00:00:00","insp_start_time":"1205","insp_end_time":"1220","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"67200","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":"14766136","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669421,"change_date":"2023-02-01 21:42:00","inspection_id":"77751367","insp_unit_id":"193185126","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"CIMC","insp_unit_company":null,"insp_unit_license":"4MS2127","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"LJRC4126X61019966","insp_unit_decal":"Y","insp_unit_decal_number":"32216646","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279109,"change_date":"2023-02-01 21:42:00","inspection_id":"77750973","dot_number":"1882468","report_state":"CA","report_number":"UCTO001314","insp_date":"2023-01-31 00:00:00","insp_start_time":"0905","insp_end_time":"0930","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"14764349","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3668901,"change_date":"2023-02-01 21:42:00","inspection_id":"77750973","insp_unit_id":"193184543","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9E56669","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV3DSFF3230","insp_unit_decal":"Y","insp_unit_decal_number":"32216616","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"},{"id":3668902,"change_date":"2023-02-01 21:42:00","inspection_id":"77750973","insp_unit_id":"193184544","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DOON","insp_unit_company":null,"insp_unit_license":"4HF3842","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1D9BG532671609755","insp_unit_decal":"Y","insp_unit_decal_number":"32216617","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279149,"change_date":"2023-02-01 21:42:00","inspection_id":"77751014","dot_number":"1882468","report_state":"CA","report_number":"UCTO001316","insp_date":"2023-01-31 00:00:00","insp_start_time":"0955","insp_end_time":"1010","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"NON","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-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14764168","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3668955,"change_date":"2023-02-01 21:42:00","inspection_id":"77751014","insp_unit_id":"193184600","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"8U42245","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NPLHN6X98M754996","insp_unit_decal":"Y","insp_unit_decal_number":"32216620","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279150,"change_date":"2023-02-01 21:42:00","inspection_id":"77751015","dot_number":"1882468","report_state":"CA","report_number":"UCTO001317","insp_date":"2023-01-31 00:00:00","insp_start_time":"1005","insp_end_time":"1025","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"NON","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-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14763944","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3668956,"change_date":"2023-02-01 21:42:00","inspection_id":"77751015","insp_unit_id":"193184601","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"35823R3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXDT9GHHR1611","insp_unit_decal":"Y","insp_unit_decal_number":"32216621","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279151,"change_date":"2023-02-01 21:42:00","inspection_id":"77751016","dot_number":"1882468","report_state":"CA","report_number":"UCTO001318","insp_date":"2023-01-31 00:00:00","insp_start_time":"1020","insp_end_time":"1035","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"NON","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-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14764571","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3668957,"change_date":"2023-02-01 21:42:00","inspection_id":"77751016","insp_unit_id":"193184602","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"00517P2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXFE4KHKJ6272","insp_unit_decal":"Y","insp_unit_decal_number":"32216622","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279188,"change_date":"2023-02-01 21:42:00","inspection_id":"77751060","dot_number":"1882468","report_state":"CA","report_number":"UCTO001319","insp_date":"2023-01-31 00:00:00","insp_start_time":"1035","insp_end_time":"1050","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"NON","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-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14764220","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669014,"change_date":"2023-02-01 21:42:00","inspection_id":"77751060","insp_unit_id":"193184671","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"75710E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXFE3MDMZ0782","insp_unit_decal":"Y","insp_unit_decal_number":"32216623","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279189,"change_date":"2023-02-01 21:42:00","inspection_id":"77751061","dot_number":"1882468","report_state":"CA","report_number":"UCTO001320","insp_date":"2023-01-31 00:00:00","insp_start_time":"1050","insp_end_time":"1105","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"14763894","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669015,"change_date":"2023-02-01 21:42:00","inspection_id":"77751061","insp_unit_id":"193184672","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9E56669","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV3DSFF3230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"},{"id":3669016,"change_date":"2023-02-01 21:42:00","inspection_id":"77751061","insp_unit_id":"193184673","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"4TP2645","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTE5320X91086807","insp_unit_decal":"Y","insp_unit_decal_number":"32216624","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279190,"change_date":"2023-02-01 21:42:00","inspection_id":"77751062","dot_number":"1882468","report_state":"CA","report_number":"UCTO001321","insp_date":"2023-01-31 00:00:00","insp_start_time":"1110","insp_end_time":"1125","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"14764376","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669017,"change_date":"2023-02-01 21:42:00","inspection_id":"77751062","insp_unit_id":"193184674","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"RICH","insp_unit_company":null,"insp_unit_license":"4RW1369","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1K9FU493XJ1236399","insp_unit_decal":"Y","insp_unit_decal_number":"32216625","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279191,"change_date":"2023-02-01 21:42:00","inspection_id":"77751063","dot_number":"1882468","report_state":"CA","report_number":"UCTO001322","insp_date":"2023-01-31 00:00:00","insp_start_time":"1125","insp_end_time":"1140","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 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":"14764320","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669018,"change_date":"2023-02-01 21:42:00","inspection_id":"77751063","insp_unit_id":"193184675","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"21992A2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0W5HT2GEC23899","insp_unit_decal":"Y","insp_unit_decal_number":"32216626","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279241,"change_date":"2023-02-01 21:42:00","inspection_id":"77751117","dot_number":"1882468","report_state":"CA","report_number":"UCTO001323","insp_date":"2023-01-31 00:00:00","insp_start_time":"1140","insp_end_time":"1155","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"71200","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":"14764377","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669099,"change_date":"2023-02-01 21:42:00","inspection_id":"77751117","insp_unit_id":"193184765","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9E56669","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV3DSFF3230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"},{"id":3669100,"change_date":"2023-02-01 21:42:00","inspection_id":"77751117","insp_unit_id":"193184766","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RICH","insp_unit_company":null,"insp_unit_license":"4RW1368","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1K9FU4938J1236398","insp_unit_decal":"Y","insp_unit_decal_number":"32216627","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279242,"change_date":"2023-02-01 21:42:00","inspection_id":"77751118","dot_number":"1882468","report_state":"CA","report_number":"UCTO001324","insp_date":"2023-01-31 00:00:00","insp_start_time":"1200","insp_end_time":"1215","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","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":"14764590","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669101,"change_date":"2023-02-01 21:42:00","inspection_id":"77751118","insp_unit_id":"193184767","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"MANN","insp_unit_company":null,"insp_unit_license":"4TX5838","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1K9FU5339M1236381","insp_unit_decal":"Y","insp_unit_decal_number":"32216628","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279243,"change_date":"2023-02-01 21:42:00","inspection_id":"77751119","dot_number":"1882468","report_state":"CA","report_number":"UCTO001325","insp_date":"2023-01-31 00:00:00","insp_start_time":"1220","insp_end_time":"1235","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"71200","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":"14764583","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669102,"change_date":"2023-02-01 21:42:00","inspection_id":"77751119","insp_unit_id":"193184768","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9E56669","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV3DSFF3230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"},{"id":3669103,"change_date":"2023-02-01 21:42:00","inspection_id":"77751119","insp_unit_id":"193184769","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANN","insp_unit_company":null,"insp_unit_license":"4TX5839","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1K9FU5337M1236380","insp_unit_decal":"Y","insp_unit_decal_number":"32216629","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279244,"change_date":"2023-02-01 21:42:00","inspection_id":"77751120","dot_number":"1882468","report_state":"CA","report_number":"UCTO001326","insp_date":"2023-01-31 00:00:00","insp_start_time":"1230","insp_end_time":"1245","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 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":"14765416","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669104,"change_date":"2023-02-01 21:42:00","inspection_id":"77751120","insp_unit_id":"193184770","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"62381Z1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0W5HTXGEC33418","insp_unit_decal":"Y","insp_unit_decal_number":"32216630","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279299,"change_date":"2023-02-01 21:42:00","inspection_id":"77751183","dot_number":"1882468","report_state":"CA","report_number":"UCTO001327","insp_date":"2023-01-31 00:00:00","insp_start_time":"1250","insp_end_time":"1305","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"14765305","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669177,"change_date":"2023-02-01 21:42:00","inspection_id":"77751183","insp_unit_id":"193184864","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4LV7572","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS24832U724001","insp_unit_decal":"Y","insp_unit_decal_number":"32216631","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279301,"change_date":"2023-02-01 21:42:00","inspection_id":"77751185","dot_number":"1882468","report_state":"CA","report_number":"UCTO001329","insp_date":"2023-01-31 00:00:00","insp_start_time":"1325","insp_end_time":"1335","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","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":"14765177","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669179,"change_date":"2023-02-01 21:42:00","inspection_id":"77751185","insp_unit_id":"193184866","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"4MU4429","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTE5220151077014","insp_unit_decal":"Y","insp_unit_decal_number":"32216633","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279302,"change_date":"2023-02-01 21:42:00","inspection_id":"77751186","dot_number":"1882468","report_state":"CA","report_number":"UCTO001330","insp_date":"2023-01-31 00:00:00","insp_start_time":"1340","insp_end_time":"1355","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"14765216","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669180,"change_date":"2023-02-01 21:42:00","inspection_id":"77751186","insp_unit_id":"193184867","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4RR1404","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV482W69L261047","insp_unit_decal":"Y","insp_unit_decal_number":"32216634","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279349,"change_date":"2023-02-01 21:42:00","inspection_id":"77751238","dot_number":"1882468","report_state":"CA","report_number":"UCTO001331","insp_date":"2023-01-31 00:00:00","insp_start_time":"1400","insp_end_time":"1415","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"14764731","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669242,"change_date":"2023-02-01 21:42:00","inspection_id":"77751238","insp_unit_id":"193184937","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"4RW1371","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0621JT122821","insp_unit_decal":"Y","insp_unit_decal_number":"32216635","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2279350,"change_date":"2023-02-01 21:42:00","inspection_id":"77751239","dot_number":"1882468","report_state":"CA","report_number":"UCTO001332","insp_date":"2023-01-31 00:00:00","insp_start_time":"1420","insp_end_time":"1435","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"93200","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":"14765338","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2023-02-01 21:42:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:33.000000Z","updated_at":"2025-03-17T19:08:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3669243,"change_date":"2023-02-01 21:42:00","inspection_id":"77751239","insp_unit_id":"193184938","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9E56669","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV3DSFF3230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"},{"id":3669244,"change_date":"2023-02-01 21:42:00","inspection_id":"77751239","insp_unit_id":"193184939","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"4CP2719","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1PT07ANM6X9002922","insp_unit_decal":"Y","insp_unit_decal_number":"32216636","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":900551,"change_date":"2022-07-26 21:42:00","inspection_id":"76160899","dot_number":"1882468","report_state":"CA","report_number":"UCTO001179","insp_date":"2022-07-26 00:00:00","insp_start_time":"1029","insp_end_time":"1045","registration_date":null,"region":"PT","ci_status_code":"C","location":"750","location_desc":"ALL CLEAN","county_code_state":"CA","county_code":"083","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"14522351","transaction_code":"A","transaction_date":"2022-07-26 00:00:00","upload_date":"2022-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2022-07-26 21:42:00","snet_input_date":"2022-07-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-26 21:42:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:40.000000Z","updated_at":"2025-03-17T18:43:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1449868,"change_date":"2022-07-26 21:42:00","inspection_id":"76160899","insp_unit_id":"189982388","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9E56669","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV3DSFF3230","insp_unit_decal":"Y","insp_unit_decal_number":"31544961","created_at":"2025-03-17T22:17:06.000000Z","updated_at":"2025-03-17T22:17:06.000000Z"}]},{"id":363091,"change_date":"2022-05-10 21:41:00","inspection_id":"75525905","dot_number":"1882468","report_state":"CA","report_number":"N9XE003599","insp_date":"2022-05-09 00:00:00","insp_start_time":"0743","insp_end_time":"0754","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"CONEJO  S\/B","county_code_state":"CA","county_code":"111","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"UNKNOW","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"45000","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":"14420437","transaction_code":"A","transaction_date":"2022-05-09 00:00:00","upload_date":"2022-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01882468","upload_search_indicator":null,"census_search_date":"2022-05-10 21:41:00","snet_input_date":"2022-05-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-10 21:41:00","insp_carrier_name":"ALL CLEAN WATER SOLUTIONS LLC","insp_carrier_street":"665 BETTERAVIA RD","insp_carrier_city":"SANTA MARIA","insp_carrier_state":"CA","insp_carrier_zip_code":"93455","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:58.000000Z","updated_at":"2025-03-17T18:33:58.000000Z","inspection_violations":[{"id":570762,"change_date":"2022-05-10 21:41:00","inspection_id":"75525905","insp_violation_id":"245715400","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188617898","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:43.000000Z","updated_at":"2025-03-17T21:09:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":587455,"change_date":"2022-05-10 21:41:00","inspection_id":"75525905","insp_unit_id":"188617898","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"IV","insp_unit_license":"01441P2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXFE2KHKJ6271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:48.000000Z","updated_at":"2025-03-17T22:11:48.000000Z"},{"id":587456,"change_date":"2022-05-10 21:41:00","inspection_id":"75525905","insp_unit_id":"188617899","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"RICD","insp_unit_company":"4","insp_unit_license":"4TX4033","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1K9BU2520M1236383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:48.000000Z","updated_at":"2025-03-17T22:11:48.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/1882468\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/1882468\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/1882468\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/1882468\/inspections","per_page":100,"prev_page_url":null,"to":53,"total":53}