{"current_page":1,"data":[{"id":10048775,"change_date":"2025-10-27 21:39:00","inspection_id":"86161440","dot_number":"2805882","report_state":"CA","report_number":"NDHX006676","insp_date":"2025-10-22 00:00:00","insp_start_time":"0705","insp_end_time":"0730","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AG WATER COMPANY","shipping_paper_number":"20177998","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-27 21:39: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":"16033214","transaction_code":"A","transaction_date":"2025-10-22 00:00:00","upload_date":"2025-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02805882","upload_search_indicator":null,"census_search_date":"2025-10-27 21:39:00","snet_input_date":"2025-10-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-27 21:39:00","insp_carrier_name":"ACQUA CONCEPTS INC","insp_carrier_street":"2665 S CHESTNUT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93725","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"439967","created_at":"2025-10-30T10:00:51.000000Z","updated_at":"2025-11-01T10:01:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16697095,"change_date":"2025-10-27 21:39:00","inspection_id":"86161440","insp_unit_id":"209681145","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"27","insp_unit_license":"41114L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXFC3PDNL2239","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-30T09:45:57.000000Z","updated_at":"2025-10-31T09:46:41.000000Z"}]},{"id":8181276,"change_date":"2025-03-21 21:40:00","inspection_id":"84194532","dot_number":"2805882","report_state":"CA","report_number":"NAHY007620","insp_date":"2025-03-21 00:00:00","insp_start_time":"0338","insp_end_time":"0403","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AG WATER","shipping_paper_number":"20177248","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-21 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":"15749182","transaction_code":"A","transaction_date":"2025-03-21 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02805882","upload_search_indicator":null,"census_search_date":"2025-03-21 21:40:00","snet_input_date":"2025-03-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-21 21:40:00","insp_carrier_name":"ACQUA CONCEPTS INC","insp_carrier_street":"2665 S CHESTNUT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93725","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"439967","created_at":"2025-03-24T10:28:08.000000Z","updated_at":"2025-03-25T10:11:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13224591,"change_date":"2025-03-21 21:40:00","inspection_id":"84194532","insp_unit_id":"205933294","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"27\/WHITE","insp_unit_license":"41114L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXFC3PDNL2239","insp_unit_decal":"Y","insp_unit_decal_number":"34782865","created_at":"2025-03-24T10:19:57.000000Z","updated_at":"2025-03-25T10:03:07.000000Z"}]},{"id":7876362,"change_date":"2025-02-14 21:40:00","inspection_id":"83874010","dot_number":"2805882","report_state":"CA","report_number":"UC13004664","insp_date":"2025-02-13 00:00:00","insp_start_time":"0730","insp_end_time":"0800","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15703702","transaction_code":"A","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02805882","upload_search_indicator":null,"census_search_date":"2025-02-14 21:40:00","snet_input_date":"2025-02-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-14 21:40:00","insp_carrier_name":"ACQUA CONCEPTS INC","insp_carrier_street":"2665 S CHESTNUT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93725","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"439967","created_at":"2025-03-17T21:01:36.000000Z","updated_at":"2025-03-17T21:01:36.000000Z","inspection_violations":[{"id":12309063,"change_date":"2025-02-14 21:40:00","inspection_id":"83874010","insp_violation_id":"264532585","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK90148","created_at":"2025-03-17T22:06:05.000000Z","updated_at":"2025-03-17T22:06:05.000000Z","normalized_code":"3922SLL"},{"id":12309064,"change_date":"2025-02-14 21:40:00","inspection_id":"83874010","insp_violation_id":"264532586","seq_no":"2","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"205337266","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK90149","created_at":"2025-03-17T22:06:05.000000Z","updated_at":"2025-03-17T22:06:05.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":12712723,"change_date":"2025-02-14 21:40:00","inspection_id":"83874010","insp_unit_id":"205337266","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"SB WHT 20","insp_unit_license":"227646G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C7WRMBL5KG617135","insp_unit_decal":"Y","insp_unit_decal_number":"34779645","created_at":"2025-03-17T23:55:24.000000Z","updated_at":"2025-03-17T23:55:24.000000Z"}]},{"id":7223746,"change_date":"2024-11-18 21:41:00","inspection_id":"83187957","dot_number":"2805882","report_state":"CA","report_number":"NCNK008118","insp_date":"2024-11-15 00:00:00","insp_start_time":"0700","insp_end_time":"0713","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ACQUA CONCEPTS INC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15596237","transaction_code":"A","transaction_date":"2024-11-15 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02805882","upload_search_indicator":null,"census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"ACQUA CONCEPTS INC","insp_carrier_street":"2665 S CHESTNUT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93725","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"439967","created_at":"2025-03-17T20:46:48.000000Z","updated_at":"2025-03-17T20:46:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11652019,"change_date":"2024-11-18 21:41:00","inspection_id":"83187957","insp_unit_id":"203941386","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"WHT\/20","insp_unit_license":"27646G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C7WRMBL5KG617135","insp_unit_decal":"Y","insp_unit_decal_number":"34484711","created_at":"2025-03-17T23:43:45.000000Z","updated_at":"2025-03-17T23:43:45.000000Z"}]},{"id":7417075,"change_date":"2024-12-13 21:41:00","inspection_id":"83391595","dot_number":"2805882","report_state":"CA","report_number":"NDRU001275","insp_date":"2024-11-07 00:00:00","insp_start_time":"0733","insp_end_time":"0819","registration_date":null,"region":"PT","ci_status_code":"C","location":"155","location_desc":"ARBUCKLE","county_code_state":"CA","county_code":"011","insp_level_id":"5","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-12-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","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":"15627966","transaction_code":"A","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02805882","upload_search_indicator":null,"census_search_date":"2024-12-13 21:41:00","snet_input_date":"2024-11-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-13 21:41:00","insp_carrier_name":"ACQUA CONCEPTS INC","insp_carrier_street":"2665 S CHESTNUT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93725","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"439967","created_at":"2025-03-17T20:50:48.000000Z","updated_at":"2025-03-17T20:50:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11965599,"change_date":"2024-12-13 21:41:00","inspection_id":"83391595","insp_unit_id":"204385912","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1","insp_unit_license":"9941Z23","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GB3CVCG4KF138123","insp_unit_decal":"Y","insp_unit_decal_number":"34456318","created_at":"2025-03-17T23:47:06.000000Z","updated_at":"2025-03-17T23:47:06.000000Z"}]},{"id":6916284,"change_date":"2024-10-08 21:42:00","inspection_id":"82861769","dot_number":"2805882","report_state":"CA","report_number":"ND6D006220","insp_date":"2024-10-02 00:00:00","insp_start_time":"0503","insp_end_time":"0528","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AG WATER CHEMICAL","shipping_paper_number":"20176955","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-08 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":"15548911","transaction_code":"A","transaction_date":"2024-10-02 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02805882","upload_search_indicator":null,"census_search_date":"2024-10-08 21:42:00","snet_input_date":"2024-10-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"ACQUA CONCEPTS INC","insp_carrier_street":"2665 S CHESTNUT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93725","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"439967","created_at":"2025-03-17T20:40:16.000000Z","updated_at":"2025-03-17T20:40:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11154497,"change_date":"2024-10-08 21:42:00","inspection_id":"82861769","insp_unit_id":"203324984","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"27","insp_unit_license":"41114L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXFC3PDNL2239","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:30.000000Z","updated_at":"2025-03-17T23:38:30.000000Z"}]},{"id":5192021,"change_date":"2024-03-01 21:40:00","inspection_id":"81002625","dot_number":"2805882","report_state":"CA","report_number":"UFG0000970","insp_date":"2024-03-01 00:00:00","insp_start_time":"0715","insp_end_time":"0730","registration_date":null,"region":"PT","ci_status_code":"C","location":"9420","location_desc":"DELANO, CA","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AG WATER CHEMICAL","shipping_paper_number":"20176187","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15265698","transaction_code":"A","transaction_date":"2024-03-01 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02805882","upload_search_indicator":null,"census_search_date":"2024-03-01 21:40:00","snet_input_date":"2024-03-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-01 21:40:00","insp_carrier_name":"ACQUA CONCEPTS INC","insp_carrier_street":"2665 S CHESTNUT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93725","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:22.000000Z","updated_at":"2025-03-17T20:05:22.000000Z","inspection_violations":[{"id":8003634,"change_date":"2024-03-01 21:40:00","inspection_id":"81002625","insp_violation_id":"258162808","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:42.000000Z","updated_at":"2025-03-17T21:44:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8360056,"change_date":"2024-03-01 21:40:00","inspection_id":"81002625","insp_unit_id":"199716487","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"21","insp_unit_license":"65265C3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GTU9DET8MZ151848","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:45.000000Z","updated_at":"2025-03-17T23:10:45.000000Z"}]},{"id":4188935,"change_date":"2023-10-12 21:42:00","inspection_id":"79902395","dot_number":"2805882","report_state":"CA","report_number":"UECE005236","insp_date":"2023-10-12 00:00:00","insp_start_time":"0925","insp_end_time":"0945","registration_date":null,"region":"PT","ci_status_code":"C","location":"252","location_desc":"SR-104 EOF CARILLION BLVD","county_code_state":"CA","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","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":"15094268","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02805882","upload_search_indicator":null,"census_search_date":"2023-10-12 21:42:00","snet_input_date":"2023-10-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-12 21:42:00","insp_carrier_name":"ACQUA CONCEPTS INC","insp_carrier_street":"2665 S CHESTNUT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93725","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"439967","created_at":"2025-03-17T19:45:51.000000Z","updated_at":"2025-03-17T19:45:51.000000Z","inspection_violations":[{"id":6486384,"change_date":"2023-10-12 21:42:00","inspection_id":"79902395","insp_violation_id":"255815661","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197537319","insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:18.000000Z","updated_at":"2025-03-17T21:37:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6736675,"change_date":"2023-10-12 21:42:00","inspection_id":"79902395","insp_unit_id":"197537319","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"79045N2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GB3CVCG4KF138123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:29.000000Z","updated_at":"2025-03-17T22:56:29.000000Z"}]},{"id":3727872,"change_date":"2023-08-11 21:39:00","inspection_id":"79389466","dot_number":"2805882","report_state":"CA","report_number":"NCNY005862","insp_date":"2023-08-10 00:00:00","insp_start_time":"0652","insp_end_time":"0727","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AG WATER CHEMICAL","shipping_paper_number":"20175816","cargo_tank":null,"hazmat_placard_req":"Y","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-08-11 21:39: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":"15016058","transaction_code":"A","transaction_date":"2023-08-10 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02805882","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"ACQUA CONCEPTS INC","insp_carrier_street":"2665 S CHESTNUT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93725","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"439967","created_at":"2025-03-17T19:36:29.000000Z","updated_at":"2025-03-17T19:36:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5993945,"change_date":"2023-08-11 21:39:00","inspection_id":"79389466","insp_unit_id":"196498152","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"26\/WHT","insp_unit_license":"48214H2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACXFC8JHJL9144","insp_unit_decal":"Y","insp_unit_decal_number":"32869302","created_at":"2025-03-17T22:50:21.000000Z","updated_at":"2025-03-17T22:50:21.000000Z"}]},{"id":2290293,"change_date":"2023-02-06 21:41:00","inspection_id":"77763785","dot_number":"2805882","report_state":"CA","report_number":"ND6D004107","insp_date":"2023-02-01 00:00:00","insp_start_time":"0724","insp_end_time":"0745","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AG WATER CHEMICAL","shipping_paper_number":"20175124","cargo_tank":null,"hazmat_placard_req":"Y","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-02 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":"14767389","transaction_code":"C","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02805882","upload_search_indicator":null,"census_search_date":"2023-02-02 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-02 21:42:00","insp_carrier_name":"ACQUA CONCEPTS INC","insp_carrier_street":"2665 S CHESTNUT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93725","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"439967","created_at":"2025-03-17T19:08:52.000000Z","updated_at":"2025-03-17T19:08:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3686089,"change_date":"2023-02-06 21:41:00","inspection_id":"77763785","insp_unit_id":"193254221","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"20","insp_unit_license":"27646G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C7WRMBL5KG617135","insp_unit_decal":"Y","insp_unit_decal_number":"32157072","created_at":"2025-03-17T22:32:25.000000Z","updated_at":"2025-03-17T22:32:25.000000Z"}]},{"id":939747,"change_date":"2022-08-01 21:40:00","inspection_id":"76207157","dot_number":"2805882","report_state":"CA","report_number":"UC13002497","insp_date":"2022-08-01 00:00:00","insp_start_time":"0620","insp_end_time":"0645","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"OTH","hazmat_placard_req":"Y","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-08-01 21:40: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":"14529845","transaction_code":"A","transaction_date":"2022-08-01 00:00:00","upload_date":"2022-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02805882","upload_search_indicator":null,"census_search_date":"2022-08-01 21:40:00","snet_input_date":"2022-08-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-01 21:40:00","insp_carrier_name":"ACQUA CONCEPTS INC","insp_carrier_street":"2665 S CHESTNUT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93725","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"439967","created_at":"2025-03-17T18:44:07.000000Z","updated_at":"2025-03-17T18:44:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1512781,"change_date":"2022-08-01 21:40:00","inspection_id":"76207157","insp_unit_id":"190076841","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"WHT SB","insp_unit_license":"27646G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C7WRMBL5KG617135","insp_unit_decal":"Y","insp_unit_decal_number":"31487334","created_at":"2025-03-17T22:17:31.000000Z","updated_at":"2025-03-17T22:17:31.000000Z"}]},{"id":782980,"change_date":"2022-07-08 21:41:00","inspection_id":"76023619","dot_number":"2805882","report_state":"CA","report_number":"NBH0005036","insp_date":"2022-07-05 00:00:00","insp_start_time":"0720","insp_end_time":"0733","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"11400","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":"14497993","transaction_code":"A","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02805882","upload_search_indicator":null,"census_search_date":"2022-07-08 21:41:00","snet_input_date":"2022-07-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-08 21:41:00","insp_carrier_name":"ACQUA CONCEPTS INC","insp_carrier_street":"2665 S CHESTNUT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93725","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"439967","created_at":"2025-03-17T18:41:33.000000Z","updated_at":"2025-03-17T18:41:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1259816,"change_date":"2022-07-08 21:41:00","inspection_id":"76023619","insp_unit_id":"189685062","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"24","insp_unit_license":"13708X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GBJC34U57E179602","insp_unit_decal":"Y","insp_unit_decal_number":"31487903","created_at":"2025-03-17T22:15:55.000000Z","updated_at":"2025-03-17T22:15:55.000000Z"}]},{"id":724977,"change_date":"2022-06-29 21:42:00","inspection_id":"75955948","dot_number":"2805882","report_state":"CA","report_number":"NCNK004695","insp_date":"2022-06-28 00:00:00","insp_start_time":"0714","insp_end_time":"0730","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AG WATER CHEMICAL","shipping_paper_number":"20174573","cargo_tank":null,"hazmat_placard_req":"Y","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-06-29 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":"14488960","transaction_code":"A","transaction_date":"2022-06-28 00:00:00","upload_date":"2022-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02805882","upload_search_indicator":null,"census_search_date":"2022-06-29 21:42:00","snet_input_date":"2022-06-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-29 21:42:00","insp_carrier_name":"ACQUA CONCEPTS INC","insp_carrier_street":"2665 S CHESTNUT AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93725","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"439967","created_at":"2025-03-17T18:40:30.000000Z","updated_at":"2025-03-17T18:40:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1165413,"change_date":"2022-06-29 21:42:00","inspection_id":"75955948","insp_unit_id":"189539846","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/27","insp_unit_license":"41114L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACXFC3PDNL2239","insp_unit_decal":"Y","insp_unit_decal_number":"31133224","created_at":"2025-03-17T22:15:22.000000Z","updated_at":"2025-03-17T22:15:22.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2805882\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2805882\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2805882\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2805882\/inspections","per_page":100,"prev_page_url":null,"to":13,"total":13}