{"current_page":1,"data":[{"id":10806118,"change_date":"2026-01-30 21:38:00","inspection_id":"86832994","dot_number":"480940","report_state":"CT","report_number":"1147002487","insp_date":"2026-01-17 00:00:00","insp_start_time":"0835","insp_end_time":"0910","registration_date":"2026-01-30 00:00:00","region":"ET","ci_status_code":"C","location":"057S","location_desc":"GREENWICH SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"AQUIFER DRILLING","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"763678","transaction_code":"C","transaction_date":"2026-01-17 00:00:00","upload_date":"2026-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2026-01-20 21:39:00","snet_input_date":"2026-01-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-01-20 21:39:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-23T10:36:08.000000Z","updated_at":"2026-02-10T10:31:05.000000Z","inspection_violations":[{"id":18228288,"change_date":"2026-01-30 21:38:00","inspection_id":"86832994","insp_violation_id":"271500765","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:46:46.000000Z","updated_at":"2026-02-10T10:39:38.000000Z","normalized_code":"3922SLLTCD"},{"id":18228289,"change_date":"2026-01-30 21:38:00","inspection_id":"86832994","insp_violation_id":"271500766","seq_no":"2","part_no":"392","part_no_section":"9A-DFSL","insp_viol_unit":"1","insp_unit_id":"211352490","insp_violation_category_id":"55","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:46:46.000000Z","updated_at":"2026-02-10T10:39:38.000000Z","normalized_code":"3929ADFSL"}],"inspection_per_units":[{"id":18301471,"change_date":"2026-01-30 21:38:00","inspection_id":"86832994","insp_unit_id":"211352490","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"25-19310","insp_unit_license":"YASV348","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1GDL7E1C63F519310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-02T10:10:01.000000Z","updated_at":"2026-02-10T10:03:46.000000Z"}]},{"id":9702794,"change_date":"2025-09-17 21:40:00","inspection_id":"85797514","dot_number":"480940","report_state":"NY","report_number":"0L11500589","insp_date":"2025-09-11 00:00:00","insp_start_time":"0839","insp_end_time":"0859","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SYOSSET NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2025-09-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20940","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":"2287903","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2025-09-17 21:40:00","snet_input_date":"2025-09-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-17 21:40:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:41.000000Z","updated_at":"2025-09-23T10:01:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16063009,"change_date":"2025-09-17 21:40:00","inspection_id":"85797514","insp_unit_id":"208993683","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"57331MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDAF57R88ED22724","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:46.000000Z","updated_at":"2025-09-21T09:45:19.000000Z"},{"id":16063010,"change_date":"2025-09-17 21:40:00","inspection_id":"85797514","insp_unit_id":"208993684","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BOBCAT","insp_unit_company":"PA185V","insp_unit_license":"620536T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"4FVCCAAA9SU518575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:46.000000Z","updated_at":"2025-09-21T09:45:19.000000Z"}]},{"id":8251332,"change_date":"2025-03-31 21:40:00","inspection_id":"84268351","dot_number":"480940","report_state":"NY","report_number":"SPL3060378","insp_date":"2025-03-25 00:00:00","insp_start_time":"0749","insp_end_time":"0804","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"YAPHANK NY","county_code_state":"NY","county_code":"103","insp_level_id":"2","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2025-03-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1534221","transaction_code":"A","transaction_date":"2025-03-31 00:00:00","upload_date":"2025-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2025-03-31 21:40:00","snet_input_date":"2025-03-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-31 21:40:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-03T10:04:14.000000Z","updated_at":"2025-04-04T10:17:09.000000Z","inspection_violations":[{"id":12959400,"change_date":"2025-03-31 21:40:00","inspection_id":"84268351","insp_violation_id":"265343841","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:21:29.000000Z","updated_at":"2025-04-04T10:31:46.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":13352851,"change_date":"2025-03-31 21:40:00","inspection_id":"84268351","insp_unit_id":"206071330","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"TRANSTAR","insp_unit_company":"358","insp_unit_license":"94117ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTJSSKK4GH071936","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-03T09:51:37.000000Z","updated_at":"2025-04-04T09:52:57.000000Z"}]},{"id":8080023,"change_date":"2025-03-11 21:40:00","inspection_id":"84087991","dot_number":"480940","report_state":"NY","report_number":"D012101935","insp_date":"2025-03-11 00:00:00","insp_start_time":"1022","insp_end_time":"1049","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"OLD WESTBURY NY","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2025-03-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1457654","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2025-03-11 21:40:00","snet_input_date":"2025-03-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-11 21:40:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:14.000000Z","updated_at":"2025-03-17T21:06:14.000000Z","inspection_violations":[{"id":12628288,"change_date":"2025-03-11 21:40:00","inspection_id":"84087991","insp_violation_id":"264940369","seq_no":"1","part_no":"393","part_no_section":"130C-CHVE","insp_viol_unit":"1","insp_unit_id":"205728035","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:07:49.000000Z","updated_at":"2025-03-17T22:07:49.000000Z","normalized_code":"393130CCHVE"}],"inspection_per_units":[{"id":13045825,"change_date":"2025-03-11 21:40:00","inspection_id":"84087991","insp_unit_id":"205728035","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"11895NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JN782S50010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:14.000000Z","updated_at":"2025-03-17T23:59:14.000000Z"}]},{"id":7658737,"change_date":"2025-01-18 21:33:00","inspection_id":"83645446","dot_number":"480940","report_state":"NY","report_number":"0L08000840","insp_date":"2025-01-17 00:00:00","insp_start_time":"1720","insp_end_time":"1741","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"DIX HILLS NY","county_code_state":"NY","county_code":"103","insp_level_id":"3","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2025-01-18 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","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":"1264140","transaction_code":"A","transaction_date":"2025-01-18 00:00:00","upload_date":"2025-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2025-01-18 21:33:00","snet_input_date":"2025-01-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-18 21:33:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:04.000000Z","updated_at":"2025-03-17T20:57:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12358111,"change_date":"2025-01-18 21:33:00","inspection_id":"83645446","insp_unit_id":"204909858","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"22 60338","insp_unit_license":"68103ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMKAAR9FH660338","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:22.000000Z","updated_at":"2025-03-17T23:51:22.000000Z"}]},{"id":7375850,"change_date":"2024-12-10 21:40:00","inspection_id":"83348384","dot_number":"480940","report_state":"CT","report_number":"3076003129","insp_date":"2024-12-10 00:00:00","insp_start_time":"0819","insp_end_time":"0858","registration_date":null,"region":"ET","ci_status_code":"C","location":"057S","location_desc":"GREENWICH SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","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-12-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"726119","transaction_code":"A","transaction_date":"2024-12-10 00:00:00","upload_date":"2024-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2024-12-10 21:40:00","snet_input_date":"2024-12-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-10 21:40:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:50.000000Z","updated_at":"2025-03-17T20:49:50.000000Z","inspection_violations":[{"id":11523351,"change_date":"2024-12-10 21:40:00","inspection_id":"83348384","insp_violation_id":"263348413","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"204285950","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V131383 2","created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"3922SLLIFTA"},{"id":11523352,"change_date":"2024-12-10 21:40:00","inspection_id":"83348384","insp_violation_id":"263348414","seq_no":"2","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"204285950","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V131383 2","created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":11898567,"change_date":"2024-12-10 21:40:00","inspection_id":"83348384","insp_unit_id":"204285950","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"25-19310","insp_unit_license":"67096NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GDL7E1C63F519310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:22.000000Z","updated_at":"2025-03-17T23:46:22.000000Z"}]},{"id":7375881,"change_date":"2025-02-13 21:39:00","inspection_id":"83348417","dot_number":"480940","report_state":"CT","report_number":"3090004269","insp_date":"2024-12-10 00:00:00","insp_start_time":"0813","insp_end_time":"0902","registration_date":"2025-02-13 00:00:00","region":"ET","ci_status_code":"C","location":"057S","location_desc":"GREENWICH SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"103418","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"726092","transaction_code":"C","transaction_date":"2024-12-10 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2024-12-10 21:40:00","snet_input_date":"2024-12-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-10 21:40:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:50.000000Z","updated_at":"2025-03-17T20:49:50.000000Z","inspection_violations":[{"id":11523427,"change_date":"2025-02-13 21:39:00","inspection_id":"83348417","insp_violation_id":"264492796","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"205298346","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V131382 1","created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"3922SLLIFTA"},{"id":11523428,"change_date":"2025-02-13 21:39:00","inspection_id":"83348417","insp_violation_id":"264492797","seq_no":"2","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"205298346","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V131382 1","created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"3969D2FTF"},{"id":11523429,"change_date":"2025-02-13 21:39:00","inspection_id":"83348417","insp_violation_id":"264492798","seq_no":"3","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"205298346","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":11898608,"change_date":"2025-02-13 21:39:00","inspection_id":"83348417","insp_unit_id":"205298346","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"423","insp_unit_license":"68441MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHC3DC66HW53169","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:22.000000Z","updated_at":"2025-03-17T23:46:22.000000Z"},{"id":11898609,"change_date":"2025-02-13 21:39:00","inspection_id":"83348417","insp_unit_id":"205298347","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"BF22267","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"112H8V344EL079284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:22.000000Z","updated_at":"2025-03-17T23:46:22.000000Z"}]},{"id":7274978,"change_date":"2024-12-24 21:35:00","inspection_id":"83242046","dot_number":"480940","report_state":"NJ","report_number":"SPPQI02737","insp_date":"2024-11-23 00:00:00","insp_start_time":"1028","insp_end_time":"1054","registration_date":"2024-12-10 00:00:00","region":"ET","ci_status_code":"C","location":"2113","location_desc":"KNOLWTON WEIIGHT STATION","county_code_state":"NJ","county_code":"041","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","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-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1248234","transaction_code":"C","transaction_date":"2024-11-23 00:00:00","upload_date":"2024-12-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2024-11-25 21:43:00","snet_input_date":"2024-11-23 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-11-25 21:43:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:44.000000Z","updated_at":"2025-03-17T20:47:44.000000Z","inspection_violations":[{"id":11372375,"change_date":"2024-12-24 21:35:00","inspection_id":"83242046","insp_violation_id":"263645723","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"204543951","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"39378AWS"},{"id":11372376,"change_date":"2024-12-24 21:35:00","inspection_id":"83242046","insp_violation_id":"263645724","seq_no":"2","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"204543951","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":11734403,"change_date":"2024-12-24 21:35:00","inspection_id":"83242046","insp_unit_id":"204543951","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHT\/204-1","insp_unit_license":"38308NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPSL70X5BD134450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:36.000000Z","updated_at":"2025-03-17T23:44:36.000000Z"}]},{"id":7130993,"change_date":"2025-01-29 21:40:00","inspection_id":"83089732","dot_number":"480940","report_state":"NY","report_number":"0L89000251","insp_date":"2024-11-06 00:00:00","insp_start_time":"0900","insp_end_time":"1026","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GARDEN CITY NY","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2024-11-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"23800","viol_total":"9","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1025875","transaction_code":"C","transaction_date":"2024-11-06 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2024-11-06 21:39:00","snet_input_date":"2024-11-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-06 21:39:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:40.000000Z","updated_at":"2025-03-17T20:44:40.000000Z","inspection_violations":[{"id":11139639,"change_date":"2025-01-29 21:40:00","inspection_id":"83089732","insp_violation_id":"264224631","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"205051775","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"G366JNLZM6","created_at":"2025-03-17T22:00:01.000000Z","updated_at":"2025-03-17T22:00:01.000000Z","normalized_code":"39021TB2DOT"},{"id":11139640,"change_date":"2025-01-29 21:40:00","inspection_id":"83089732","insp_violation_id":"264224632","seq_no":"2","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"2","insp_unit_id":"205051776","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"G366JNLZF5","created_at":"2025-03-17T22:00:01.000000Z","updated_at":"2025-03-17T22:00:01.000000Z","normalized_code":"3963A1HCM"},{"id":11139641,"change_date":"2025-01-29 21:40:00","inspection_id":"83089732","insp_violation_id":"264224633","seq_no":"3","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"205051775","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"G366JNLZH5","created_at":"2025-03-17T22:00:01.000000Z","updated_at":"2025-03-17T22:00:01.000000Z","normalized_code":"3922SLLIFTA"},{"id":11139642,"change_date":"2025-01-29 21:40:00","inspection_id":"83089732","insp_violation_id":"264224634","seq_no":"4","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"205051775","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"G366JNLZPB","created_at":"2025-03-17T22:00:01.000000Z","updated_at":"2025-03-17T22:00:01.000000Z","normalized_code":"39021TB1MC"},{"id":11139643,"change_date":"2025-01-29 21:40:00","inspection_id":"83089732","insp_violation_id":"264224635","seq_no":"5","part_no":"393","part_no_section":"11A1-LCHL","insp_viol_unit":"1","insp_unit_id":"205051775","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"G366JNLXN6","created_at":"2025-03-17T22:00:01.000000Z","updated_at":"2025-03-17T22:00:01.000000Z","normalized_code":"39311A1LCHL"},{"id":11139644,"change_date":"2025-01-29 21:40:00","inspection_id":"83089732","insp_violation_id":"264224636","seq_no":"6","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"205051775","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"G366JNLZ69","created_at":"2025-03-17T22:00:01.000000Z","updated_at":"2025-03-17T22:00:01.000000Z","normalized_code":"3939ALTSI"},{"id":11139645,"change_date":"2025-01-29 21:40:00","inspection_id":"83089732","insp_violation_id":"264224637","seq_no":"7","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"2","insp_unit_id":"205051776","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"G366JNLZ8P","created_at":"2025-03-17T22:00:01.000000Z","updated_at":"2025-03-17T22:00:01.000000Z","normalized_code":"39375GTAOW"},{"id":11139646,"change_date":"2025-01-29 21:40:00","inspection_id":"83089732","insp_violation_id":"264224638","seq_no":"8","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"2","insp_unit_id":"205051776","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"G366JNLZBW","created_at":"2025-03-17T22:00:01.000000Z","updated_at":"2025-03-17T22:00:01.000000Z","normalized_code":"39375GTAOW"},{"id":11139647,"change_date":"2025-01-29 21:40:00","inspection_id":"83089732","insp_violation_id":"264224639","seq_no":"9","part_no":"390","part_no_section":"21TE2IV-D","insp_viol_unit":"1","insp_unit_id":"205051775","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"G366JNLZK1","created_at":"2025-03-17T22:00:01.000000Z","updated_at":"2025-03-17T22:00:01.000000Z","normalized_code":"39021TE2IVD"}],"inspection_per_units":[{"id":11501494,"change_date":"2025-01-29 21:40:00","inspection_id":"83089732","insp_unit_id":"205051775","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"PMJ9476","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1GC1YLE79MF241272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:10.000000Z","updated_at":"2025-03-17T23:42:10.000000Z"},{"id":11501495,"change_date":"2025-01-29 21:40:00","inspection_id":"83089732","insp_unit_id":"205051776","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ECONOLINE","insp_unit_company":null,"insp_unit_license":"BL20072","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"42ETPBB29H1000062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:10.000000Z","updated_at":"2025-03-17T23:42:10.000000Z"}]},{"id":6401087,"change_date":"2024-08-06 21:43:00","inspection_id":"82312970","dot_number":"480940","report_state":"NY","report_number":"SPH0120004","insp_date":"2024-07-31 00:00:00","insp_start_time":"0800","insp_end_time":"0827","registration_date":null,"region":"ET","ci_status_code":"C","location":"08749M","location_desc":"SAUGRATIES TEXT STOP","county_code_state":"NY","county_code":"111","insp_level_id":"2","service_center":"EA","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-08-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"2942468","transaction_code":"A","transaction_date":"2024-08-06 00:00:00","upload_date":"2024-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":"M","census_search_date":"2024-08-06 21:43:00","snet_input_date":"2024-08-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-08-06 21:43:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:50.000000Z","updated_at":"2025-03-17T20:29:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10315691,"change_date":"2024-08-06 21:43:00","inspection_id":"82312970","insp_unit_id":"202256075","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"21-50010","insp_unit_license":"11895NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JN782S50010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:55.000000Z","updated_at":"2025-03-17T23:29:55.000000Z"}]},{"id":6006087,"change_date":"2024-06-17 21:43:00","inspection_id":"81889095","dot_number":"480940","report_state":"NY","report_number":"SPE0311753","insp_date":"2024-06-13 00:00:00","insp_start_time":"0758","insp_end_time":"0813","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","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-06-17 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":"2930434","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":"M","census_search_date":"2024-06-17 21:43:00","snet_input_date":"2024-06-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-17 21:43:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:51.000000Z","updated_at":"2025-03-17T20:21:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9673555,"change_date":"2024-06-17 21:43:00","inspection_id":"81889095","insp_unit_id":"201423889","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"63213NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXDU5EHFS5704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:15.000000Z","updated_at":"2025-03-17T23:23:15.000000Z"}]},{"id":5704616,"change_date":"2024-06-28 21:38:00","inspection_id":"81561832","dot_number":"480940","report_state":"CT","report_number":"3020000318","insp_date":"2024-05-09 00:00:00","insp_start_time":"0933","insp_end_time":"1117","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"NONE","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-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"707035","transaction_code":"C","transaction_date":"2024-06-28 00:00:00","upload_date":"2024-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2024-05-09 21:41:00","snet_input_date":"2024-05-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-05-09 21:41:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:52.000000Z","updated_at":"2025-03-17T20:15:52.000000Z","inspection_violations":[{"id":8824894,"change_date":"2024-06-28 21:38:00","inspection_id":"81561832","insp_violation_id":"260362834","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201635638","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V127707-1","created_at":"2025-03-17T21:48:42.000000Z","updated_at":"2025-03-17T21:48:42.000000Z","normalized_code":"3922"},{"id":8824895,"change_date":"2024-06-28 21:38:00","inspection_id":"81561832","insp_violation_id":"260362835","seq_no":"2","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"201635638","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:42.000000Z","updated_at":"2025-03-17T21:48:42.000000Z","normalized_code":"393205C"},{"id":8824896,"change_date":"2024-06-28 21:38:00","inspection_id":"81561832","insp_violation_id":"260362836","seq_no":"3","part_no":"396","part_no_section":"5(a)","insp_viol_unit":"1","insp_unit_id":"201635638","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:42.000000Z","updated_at":"2025-03-17T21:48:42.000000Z","normalized_code":"3965A"},{"id":8824897,"change_date":"2024-06-28 21:38:00","inspection_id":"81561832","insp_violation_id":"260362837","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201635638","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:42.000000Z","updated_at":"2025-03-17T21:48:42.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":9188224,"change_date":"2024-06-28 21:38:00","inspection_id":"81561832","insp_unit_id":"201635638","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"423","insp_unit_license":"68441MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHC3DC66HW53169","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:30.000000Z","updated_at":"2025-03-17T23:18:30.000000Z"}]},{"id":5704651,"change_date":"2024-05-09 21:41:00","inspection_id":"81561868","dot_number":"480940","report_state":"CT","report_number":"3129004872","insp_date":"2024-05-09 00:00:00","insp_start_time":"0825","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"707045","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2024-05-09 21:41:00","snet_input_date":"2024-05-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-05-09 21:41:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:52.000000Z","updated_at":"2025-03-17T20:15:52.000000Z","inspection_violations":[{"id":8824991,"change_date":"2024-05-09 21:41:00","inspection_id":"81561868","insp_violation_id":"259395891","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200800830","insp_violation_category_id":"47","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V127704-5","created_at":"2025-03-17T21:48:42.000000Z","updated_at":"2025-03-17T21:48:42.000000Z","normalized_code":"3922"},{"id":8824992,"change_date":"2024-05-09 21:41:00","inspection_id":"81561868","insp_violation_id":"259395892","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200800830","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V127704-5","created_at":"2025-03-17T21:48:42.000000Z","updated_at":"2025-03-17T21:48:42.000000Z","normalized_code":"3922"},{"id":8824993,"change_date":"2024-05-09 21:41:00","inspection_id":"81561868","insp_violation_id":"259395893","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200800830","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V127704-5","created_at":"2025-03-17T21:48:42.000000Z","updated_at":"2025-03-17T21:48:42.000000Z","normalized_code":"3922"},{"id":8824994,"change_date":"2024-05-09 21:41:00","inspection_id":"81561868","insp_violation_id":"259395894","seq_no":"4","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"200800830","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:42.000000Z","updated_at":"2025-03-17T21:48:42.000000Z","normalized_code":"39341"},{"id":8824995,"change_date":"2024-05-09 21:41:00","inspection_id":"81561868","insp_violation_id":"259395895","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200800830","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V127704-5","created_at":"2025-03-17T21:48:42.000000Z","updated_at":"2025-03-17T21:48:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9188274,"change_date":"2024-05-09 21:41:00","inspection_id":"81561868","insp_unit_id":"200800830","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2519310","insp_unit_license":"67096NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GDL7E1C63F519310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:30.000000Z","updated_at":"2025-03-17T23:18:30.000000Z"}]},{"id":4772060,"change_date":"2024-01-05 21:45:00","inspection_id":"80543884","dot_number":"480940","report_state":"NY","report_number":"SPG0206595","insp_date":"2024-01-03 00:00:00","insp_start_time":"1550","insp_end_time":"1650","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697A","location_desc":"QUEENSBURY (NB)","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"AQUIFER DRILLING AND TESTING INC","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-01-05 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2897104","transaction_code":"A","transaction_date":"2024-01-03 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2024-01-05 21:45:00","snet_input_date":"2024-01-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-05 21:45:00","insp_carrier_name":"AQUIFER DRILLING AND TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:17.000000Z","updated_at":"2025-03-17T19:57:17.000000Z","inspection_violations":[{"id":7364117,"change_date":"2024-01-05 21:45:00","inspection_id":"80543884","insp_violation_id":"257205029","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198831246","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:34.000000Z","updated_at":"2025-03-17T21:41:34.000000Z","normalized_code":"3922"},{"id":7364118,"change_date":"2024-01-05 21:45:00","inspection_id":"80543884","insp_violation_id":"257205030","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198831246","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:34.000000Z","updated_at":"2025-03-17T21:41:34.000000Z","normalized_code":"3922"},{"id":7364119,"change_date":"2024-01-05 21:45:00","inspection_id":"80543884","insp_violation_id":"257205031","seq_no":"3","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"198831246","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:34.000000Z","updated_at":"2025-03-17T21:41:34.000000Z","normalized_code":"39375G"},{"id":7364120,"change_date":"2024-01-05 21:45:00","inspection_id":"80543884","insp_violation_id":"257205032","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198831246","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:34.000000Z","updated_at":"2025-03-17T21:41:34.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":7676741,"change_date":"2024-01-05 21:45:00","inspection_id":"80543884","insp_unit_id":"198831246","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"10370NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FT7W3BT9BED05654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:37.000000Z","updated_at":"2025-03-17T23:04:37.000000Z"},{"id":7676742,"change_date":"2024-01-05 21:45:00","inspection_id":"80543884","insp_unit_id":"198831247","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"CC22113","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"16V1C272XP2214561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:37.000000Z","updated_at":"2025-03-17T23:04:37.000000Z"}]},{"id":4067324,"change_date":"2023-09-27 21:41:00","inspection_id":"79767651","dot_number":"480940","report_state":"NY","report_number":"SPC0179254","insp_date":"2023-09-26 00:00:00","insp_start_time":"0949","insp_end_time":"1027","registration_date":null,"region":"ET","ci_status_code":"C","location":"90777A","location_desc":"SIDNEY (EB)","county_code_state":"NY","county_code":"025","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2873328","transaction_code":"A","transaction_date":"2023-09-27 00:00:00","upload_date":"2023-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":"M","census_search_date":"2023-09-27 21:41:00","snet_input_date":"2023-09-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-27 21:41:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:11.000000Z","updated_at":"2025-03-17T19:43:11.000000Z","inspection_violations":[{"id":6297842,"change_date":"2023-09-27 21:41:00","inspection_id":"79767651","insp_violation_id":"255513755","seq_no":"1","part_no":"395","part_no_section":"22(h)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:21.000000Z","updated_at":"2025-03-17T21:36:21.000000Z","normalized_code":"39522H2"},{"id":6297843,"change_date":"2023-09-27 21:41:00","inspection_id":"79767651","insp_violation_id":"255513756","seq_no":"2","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:21.000000Z","updated_at":"2025-03-17T21:36:21.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":6539490,"change_date":"2023-09-27 21:41:00","inspection_id":"79767651","insp_unit_id":"197263669","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"348","insp_unit_license":"55781ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3FRXF75W45V131761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:52.000000Z","updated_at":"2025-03-17T22:54:52.000000Z"}]},{"id":3464115,"change_date":"2023-07-10 21:41:00","inspection_id":"79093915","dot_number":"480940","report_state":"NY","report_number":"SPWD111481","insp_date":"2023-07-07 00:00:00","insp_start_time":"1255","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":"30611","location_desc":"I-81 ONONDAGA","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","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-07-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","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":"2844980","transaction_code":"A","transaction_date":"2023-07-07 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2023-07-10 21:41:00","snet_input_date":"2023-07-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-10 21:41:00","insp_carrier_name":"AQUIFER DRILLING AND TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:40.000000Z","updated_at":"2025-03-17T19:31:40.000000Z","inspection_violations":[{"id":5341952,"change_date":"2023-07-10 21:41:00","inspection_id":"79093915","insp_violation_id":"253949099","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:49.000000Z","updated_at":"2025-03-17T21:31:49.000000Z","normalized_code":"39282A1"},{"id":5341953,"change_date":"2023-07-10 21:41:00","inspection_id":"79093915","insp_violation_id":"253949100","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195898410","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:49.000000Z","updated_at":"2025-03-17T21:31:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5569942,"change_date":"2023-07-10 21:41:00","inspection_id":"79093915","insp_unit_id":"195898410","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"27-05654","insp_unit_license":"57330MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FT7W3BT9BED05654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:57.000000Z","updated_at":"2025-03-17T22:46:57.000000Z"}]},{"id":2591522,"change_date":"2023-05-08 21:41:00","inspection_id":"78107007","dot_number":"480940","report_state":"NY","report_number":"0L47001819","insp_date":"2023-03-15 00:00:00","insp_start_time":"1125","insp_end_time":"1151","registration_date":null,"region":"ET","ci_status_code":"C","location":"03050","location_desc":"E\/B RT 25, JERICHO","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"Y","pen_cen_match":"I","final_status_date":"2023-03-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"11400","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":"2807069","transaction_code":"C","transaction_date":"2023-05-08 00:00:00","upload_date":"2023-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":"M","census_search_date":"2023-03-16 21:42:00","snet_input_date":"2023-03-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-16 21:42:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:29.000000Z","updated_at":"2025-03-17T19:14:29.000000Z","inspection_violations":[{"id":3986141,"change_date":"2023-05-08 21:41:00","inspection_id":"78107007","insp_violation_id":"252673155","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194791677","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K070GJDQZC","created_at":"2025-03-17T21:25:42.000000Z","updated_at":"2025-03-17T21:25:42.000000Z","normalized_code":"3922"},{"id":3986142,"change_date":"2023-05-08 21:41:00","inspection_id":"78107007","insp_violation_id":"252673156","seq_no":"2","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"194791677","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K070GJDRC8","created_at":"2025-03-17T21:25:42.000000Z","updated_at":"2025-03-17T21:25:42.000000Z","normalized_code":"393203A"}],"inspection_per_units":[{"id":4171042,"change_date":"2023-05-08 21:41:00","inspection_id":"78107007","insp_unit_id":"194791677","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"72087NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GBJC34214E328629","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:54.000000Z","updated_at":"2025-03-17T22:35:54.000000Z"}]},{"id":2383628,"change_date":"2023-02-16 21:41:00","inspection_id":"77870361","dot_number":"480940","report_state":"CT","report_number":"3070004331","insp_date":"2023-02-15 00:00:00","insp_start_time":"0904","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"0","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-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"666705","transaction_code":"A","transaction_date":"2023-02-15 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2023-02-16 21:41:00","snet_input_date":"2023-02-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-16 21:41:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:41.000000Z","updated_at":"2025-03-17T19:10:41.000000Z","inspection_violations":[{"id":3670625,"change_date":"2023-02-16 21:41:00","inspection_id":"77870361","insp_violation_id":"251166234","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193426373","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y993816-3","created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"3922"},{"id":3670626,"change_date":"2023-02-16 21:41:00","inspection_id":"77870361","insp_violation_id":"251166235","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193426373","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y993816-3","created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"3922"},{"id":3670627,"change_date":"2023-02-16 21:41:00","inspection_id":"77870361","insp_violation_id":"251166236","seq_no":"3","part_no":"393","part_no_section":"75(f)","insp_viol_unit":"1","insp_unit_id":"193426373","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"39375F"}],"inspection_per_units":[{"id":3835737,"change_date":"2023-02-16 21:41:00","inspection_id":"77870361","insp_unit_id":"193426373","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"94118ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTJSSKK0GH071934","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:29.000000Z","updated_at":"2025-03-17T22:33:29.000000Z"}]},{"id":2137934,"change_date":"2023-01-13 21:39:00","inspection_id":"77589703","dot_number":"480940","report_state":"NY","report_number":"0L82000393","insp_date":"2023-01-12 00:00:00","insp_start_time":"1022","insp_end_time":"1023","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LIE WB EXIT 44 (SYOSSET)","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"AQUIFER DRILLING TESTING INC","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":"Y","pen_cen_match":"I","final_status_date":"2023-01-13 21:39: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":"2788592","transaction_code":"A","transaction_date":"2023-01-13 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":"M","census_search_date":"2023-01-13 21:39:00","snet_input_date":"2023-01-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-13 21:39:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:55.000000Z","updated_at":"2025-03-17T19:05:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3440382,"change_date":"2023-01-13 21:39:00","inspection_id":"77589703","insp_unit_id":"192860449","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"37737MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTJSSKK7GH071932","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:40.000000Z","updated_at":"2025-03-17T22:30:40.000000Z"}]},{"id":2101022,"change_date":"2023-01-10 21:39:00","inspection_id":"77547369","dot_number":"480940","report_state":"MA","report_number":"CE00006084","insp_date":"2023-01-09 00:00:00","insp_start_time":"1628","insp_end_time":"1639","registration_date":null,"region":"ET","ci_status_code":"C","location":"236S","location_desc":"S-NORTHAMPTON","county_code_state":"MA","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"Y","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-01-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"458380","transaction_code":"A","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":"M","census_search_date":"2023-01-10 21:39:00","snet_input_date":"2023-01-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-01-10 21:39:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:28.000000Z","updated_at":"2025-03-17T19:05:28.000000Z","inspection_violations":[{"id":3253506,"change_date":"2023-01-10 21:39:00","inspection_id":"77547369","insp_violation_id":"250471275","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":"VERBAL","created_at":"2025-03-17T21:22:24.000000Z","updated_at":"2025-03-17T21:22:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3380965,"change_date":"2023-01-10 21:39:00","inspection_id":"77547369","insp_unit_id":"192775701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"480940","insp_unit_license":"17687MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPSL70X5BD134450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:14.000000Z","updated_at":"2025-03-17T22:30:14.000000Z"}]},{"id":2001827,"change_date":"2022-12-22 21:39:00","inspection_id":"77434156","dot_number":"480940","report_state":"NY","report_number":"0L67001116","insp_date":"2022-12-21 00:00:00","insp_start_time":"1137","insp_end_time":"1148","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B 135 EXIT 13W SYOSSET","county_code_state":"NY","county_code":"059","insp_level_id":"2","service_center":"EA","census_source_id":"4","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":"Y","pen_cen_match":"I","final_status_date":"2022-12-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2782525","transaction_code":"A","transaction_date":"2022-12-22 00:00:00","upload_date":"2022-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":"M","census_search_date":"2022-12-22 21:39:00","snet_input_date":"2022-12-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-22 21:39:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:38.000000Z","updated_at":"2025-03-17T19:03:38.000000Z","inspection_violations":[{"id":3107729,"change_date":"2022-12-22 21:39:00","inspection_id":"77434156","insp_violation_id":"250235333","seq_no":"1","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"192550552","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":3220310,"change_date":"2022-12-22 21:39:00","inspection_id":"77434156","insp_unit_id":"192550552","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"37737MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTJSSKK7GH071932","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:04.000000Z","updated_at":"2025-03-17T22:29:04.000000Z"}]},{"id":1588403,"change_date":"2023-01-05 21:39:00","inspection_id":"76960318","dot_number":"480940","report_state":"NY","report_number":"NY20000192","insp_date":"2022-10-24 00:00:00","insp_start_time":"1330","insp_end_time":"1422","registration_date":null,"region":"ET","ci_status_code":"C","location":"X2034","location_desc":"THROGS NECK BRIDGE (SB)","county_code_state":"NY","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"Y","pen_cen_match":"I","final_status_date":"2022-10-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2762433","transaction_code":"C","transaction_date":"2023-01-05 00:00:00","upload_date":"2023-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":"M","census_search_date":"2022-10-25 21:40:00","snet_input_date":"2022-10-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-25 21:40:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:56.000000Z","updated_at":"2025-03-17T18:55:56.000000Z","inspection_violations":[{"id":2496228,"change_date":"2023-01-05 21:39:00","inspection_id":"76960318","insp_violation_id":"250398407","seq_no":"1","part_no":"393","part_no_section":"55(a)","insp_viol_unit":"1","insp_unit_id":"192708929","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453071504","created_at":"2025-03-17T21:18:41.000000Z","updated_at":"2025-03-17T21:18:41.000000Z","normalized_code":"39355A"},{"id":2496229,"change_date":"2023-01-05 21:39:00","inspection_id":"76960318","insp_violation_id":"250398408","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"192708929","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453071518","created_at":"2025-03-17T21:18:41.000000Z","updated_at":"2025-03-17T21:18:41.000000Z","normalized_code":"39395F"},{"id":2496230,"change_date":"2023-01-05 21:39:00","inspection_id":"76960318","insp_violation_id":"250398409","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192708929","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453071521","created_at":"2025-03-17T21:18:41.000000Z","updated_at":"2025-03-17T21:18:41.000000Z","normalized_code":"39311"},{"id":2496231,"change_date":"2023-01-05 21:39:00","inspection_id":"76960318","insp_violation_id":"250398410","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192708929","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453071535","created_at":"2025-03-17T21:18:41.000000Z","updated_at":"2025-03-17T21:18:41.000000Z","normalized_code":"39311"},{"id":2496232,"change_date":"2023-01-05 21:39:00","inspection_id":"76960318","insp_violation_id":"250398411","seq_no":"6","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192708929","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453071549","created_at":"2025-03-17T21:18:41.000000Z","updated_at":"2025-03-17T21:18:41.000000Z","normalized_code":"3929A"},{"id":2496233,"change_date":"2023-01-05 21:39:00","inspection_id":"76960318","insp_violation_id":"250398412","seq_no":"7","part_no":"393","part_no_section":"130(b)","insp_viol_unit":"1","insp_unit_id":"192708929","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453071552","created_at":"2025-03-17T21:18:41.000000Z","updated_at":"2025-03-17T21:18:41.000000Z","normalized_code":"393130B"},{"id":2496234,"change_date":"2023-01-05 21:39:00","inspection_id":"76960318","insp_violation_id":"250398413","seq_no":"8","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"192708929","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453071566","created_at":"2025-03-17T21:18:41.000000Z","updated_at":"2025-03-17T21:18:41.000000Z","normalized_code":"3929"}],"inspection_per_units":[{"id":2555887,"change_date":"2023-01-05 21:39:00","inspection_id":"76960318","insp_unit_id":"192708929","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"11894NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GDJG31U961151873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:32.000000Z","updated_at":"2025-03-17T22:24:32.000000Z"}]},{"id":1430816,"change_date":"2022-10-04 21:40:00","inspection_id":"76778310","dot_number":"480940","report_state":"NJ","report_number":"SPQEI02078","insp_date":"2022-09-02 00:00:00","insp_start_time":"1125","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":"1916","location_desc":"OGDENSBURG FIREHOUSE","county_code_state":"NJ","county_code":"037","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-04 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":"1119287","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2022-10-04 21:40:00","snet_input_date":"2022-09-02 00:00:00","source_office":"1NJS001","mcmis_add_date":"2022-10-04 21:40:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:04.000000Z","updated_at":"2025-03-17T18:53:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2303352,"change_date":"2022-10-04 21:40:00","inspection_id":"76778310","insp_unit_id":"191245125","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"63199NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT4FEB37494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:46.000000Z","updated_at":"2025-03-17T22:22:46.000000Z"}]},{"id":716052,"change_date":"2022-06-29 21:41:00","inspection_id":"75945458","dot_number":"480940","report_state":"NY","report_number":"1020000530","insp_date":"2022-06-28 00:00:00","insp_start_time":"0914","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":"01221","location_desc":"HEMPSTEAD TOWN LOT","county_code_state":"NY","county_code":"059","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"AQUIFER DRILLING AND TESTING INC","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":"I","final_status_date":"2022-06-29 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":"2721059","transaction_code":"A","transaction_date":"2022-06-29 00:00:00","upload_date":"2022-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":"M","census_search_date":"2022-06-29 21:41:00","snet_input_date":"2022-06-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-29 21:41:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:13.000000Z","updated_at":"2025-03-17T18:40:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1150684,"change_date":"2022-06-29 21:41:00","inspection_id":"75945458","insp_unit_id":"189517868","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"358","insp_unit_license":"94117ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTJSSKK4GH071936","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:17.000000Z","updated_at":"2025-03-17T22:15:17.000000Z"}]},{"id":589537,"change_date":"2022-06-13 21:41:00","inspection_id":"75795170","dot_number":"480940","report_state":"CT","report_number":"3097004490","insp_date":"2022-06-13 00:00:00","insp_start_time":"0839","insp_end_time":"0926","registration_date":null,"region":"ET","ci_status_code":"C","location":"152SN","location_desc":"WATERFORD SCALE N\/B","county_code_state":"CT","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"AQUIFER DRILLING","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":"2022-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"646260","transaction_code":"A","transaction_date":"2022-06-13 00:00:00","upload_date":"2022-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":null,"census_search_date":"2022-06-13 21:41:00","snet_input_date":"2022-06-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-06-13 21:41:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:05.000000Z","updated_at":"2025-03-17T18:38:05.000000Z","inspection_violations":[{"id":924677,"change_date":"2022-06-13 21:41:00","inspection_id":"75795170","insp_violation_id":"246398287","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"189194294","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"39345D"},{"id":924678,"change_date":"2022-06-13 21:41:00","inspection_id":"75795170","insp_violation_id":"246398288","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":947244,"change_date":"2022-06-13 21:41:00","inspection_id":"75795170","insp_unit_id":"189194294","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"309","insp_unit_license":"42963JW","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2FZACFDC65AU61155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:02.000000Z","updated_at":"2025-03-17T22:14:02.000000Z"}]},{"id":528596,"change_date":"2022-06-02 21:41:00","inspection_id":"75723165","dot_number":"480940","report_state":"NY","report_number":"0816014089","insp_date":"2022-06-01 00:00:00","insp_start_time":"0850","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"80923M","location_desc":"HARRIMAN TOLL PLAZA","county_code_state":"NY","county_code":"071","insp_level_id":"2","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"6","oos_total":"4","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2713033","transaction_code":"A","transaction_date":"2022-06-02 00:00:00","upload_date":"2022-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":"M","census_search_date":"2022-06-02 21:41:00","snet_input_date":"2022-06-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-02 21:41:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:03.000000Z","updated_at":"2025-03-17T18:37:03.000000Z","inspection_violations":[{"id":834898,"change_date":"2022-06-02 21:41:00","inspection_id":"75723165","insp_violation_id":"246205530","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:57.000000Z","updated_at":"2025-03-17T21:10:57.000000Z","normalized_code":"3958A1"},{"id":834899,"change_date":"2022-06-02 21:41:00","inspection_id":"75723165","insp_violation_id":"246205531","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189028249","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:57.000000Z","updated_at":"2025-03-17T21:10:57.000000Z","normalized_code":"3939A"},{"id":834900,"change_date":"2022-06-02 21:41:00","inspection_id":"75723165","insp_violation_id":"246205532","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"189028249","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:57.000000Z","updated_at":"2025-03-17T21:10:57.000000Z","normalized_code":"39021TB"},{"id":834901,"change_date":"2022-06-02 21:41:00","inspection_id":"75723165","insp_violation_id":"246205533","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189028249","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:57.000000Z","updated_at":"2025-03-17T21:10:57.000000Z","normalized_code":"3939A"},{"id":834902,"change_date":"2022-06-02 21:41:00","inspection_id":"75723165","insp_violation_id":"246205534","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"189028249","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:57.000000Z","updated_at":"2025-03-17T21:10:57.000000Z","normalized_code":"39375A3"},{"id":834903,"change_date":"2022-06-02 21:41:00","inspection_id":"75723165","insp_violation_id":"246205535","seq_no":"6","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"189028249","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:57.000000Z","updated_at":"2025-03-17T21:10:57.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":850480,"change_date":"2022-06-02 21:41:00","inspection_id":"75723165","insp_unit_id":"189028249","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"315","insp_unit_license":"84876MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2NPLLZ0X37M659783","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:27.000000Z","updated_at":"2025-03-17T22:13:27.000000Z"}]},{"id":391093,"change_date":"2022-06-23 21:39:00","inspection_id":"75559163","dot_number":"480940","report_state":"ME","report_number":"9270001621","insp_date":"2022-05-16 00:00:00","insp_start_time":"1626","insp_end_time":"1709","registration_date":"2022-05-24 00:00:00","region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"N\/A","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":"I","final_status_date":"2022-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14400","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"346195","transaction_code":"C","transaction_date":"2022-06-23 00:00:00","upload_date":"2022-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00480940","upload_search_indicator":"M","census_search_date":"2022-06-13 21:41:00","snet_input_date":"2022-05-16 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-05-16 21:42:00","insp_carrier_name":"AQUIFER DRILLING & TESTING INC","insp_carrier_street":"75 EAST 2ND STREET","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:26.000000Z","updated_at":"2025-03-17T18:34:26.000000Z","inspection_violations":[{"id":611138,"change_date":"2022-06-23 21:39:00","inspection_id":"75559163","insp_violation_id":"246667704","seq_no":"1","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:53.000000Z","updated_at":"2025-03-17T21:09:53.000000Z","normalized_code":"3958F1"},{"id":611139,"change_date":"2022-06-23 21:39:00","inspection_id":"75559163","insp_violation_id":"246667705","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"189419763","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:53.000000Z","updated_at":"2025-03-17T21:09:53.000000Z","normalized_code":"39021TB"},{"id":611140,"change_date":"2022-06-23 21:39:00","inspection_id":"75559163","insp_violation_id":"246667706","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189419764","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:53.000000Z","updated_at":"2025-03-17T21:09:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":631774,"change_date":"2022-06-23 21:39:00","inspection_id":"75559163","insp_unit_id":"189419763","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"72087NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GBJC34214E328629","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:04.000000Z","updated_at":"2025-03-17T22:12:04.000000Z"},{"id":631775,"change_date":"2022-06-23 21:39:00","inspection_id":"75559163","insp_unit_id":"189419764","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"INGE","insp_unit_company":null,"insp_unit_license":"NOTDISPLAYED","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"325420UJL295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:04.000000Z","updated_at":"2025-03-17T22:12:04.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/480940\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/480940\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/480940\/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\/480940\/inspections","per_page":100,"prev_page_url":null,"to":27,"total":27}