{"current_page":1,"data":[{"id":12367487,"change_date":"2026-07-06 21:38:00","inspection_id":"88329449","dot_number":"1292030","report_state":"NY","report_number":"EPO0400348","insp_date":"2026-07-02 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"STATEN ISLAND NY","county_code_state":"NY","county_code":"085","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":"2026-07-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"3692987","transaction_code":"A","transaction_date":"2026-07-06 00:00:00","upload_date":"2026-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2026-07-06 21:38:00","snet_input_date":"2026-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-06 21:38:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-09T09:40:24.000000Z","updated_at":"2026-07-09T09:40:24.000000Z","inspection_violations":[{"id":21525311,"change_date":"2026-07-06 21:38:00","inspection_id":"88329449","insp_violation_id":"275322161","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"214464092","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-09T09:58:24.000000Z","updated_at":"2026-07-09T09:58:24.000000Z","normalized_code":"39395A1"},{"id":21525312,"change_date":"2026-07-06 21:38:00","inspection_id":"88329449","insp_violation_id":"275322162","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"214464092","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-09T09:58:24.000000Z","updated_at":"2026-07-09T09:58:24.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":21476290,"change_date":"2026-07-06 21:38:00","inspection_id":"88329449","insp_unit_id":"214464092","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"69","insp_unit_license":"20832ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5HT8RDA27492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-09T09:15:59.000000Z","updated_at":"2026-07-09T09:15:59.000000Z"}]},{"id":12105614,"change_date":"2026-06-05 21:37:00","inspection_id":"88050163","dot_number":"1292030","report_state":"NY","report_number":"SPT3121778","insp_date":"2026-05-29 00:00:00","insp_start_time":"1259","insp_end_time":"1313","registration_date":null,"region":"ED","ci_status_code":"C","location":"80167M","location_desc":"SPRING VALLEY NY","county_code_state":"NY","county_code":"087","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":"2026-06-05 21:37: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":"3472929","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2026-06-05 21:37:00","snet_input_date":"2026-05-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-05 21:37:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-08T09:41:00.000000Z","updated_at":"2026-06-16T09:32:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21033476,"change_date":"2026-06-05 21:37:00","inspection_id":"88050163","insp_unit_id":"213928922","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"94345ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT2KDA04426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-08T09:18:11.000000Z","updated_at":"2026-06-16T09:05:19.000000Z"}]},{"id":11284956,"change_date":"2026-03-04 21:40:00","inspection_id":"87199871","dot_number":"1292030","report_state":"NY","report_number":"SPT3021627","insp_date":"2026-02-26 00:00:00","insp_start_time":"0525","insp_end_time":"0547","registration_date":"2026-02-27 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"SLOATSBURG NY","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":"U","pen_cen_match":"I","final_status_date":"2026-03-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48998","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2961231","transaction_code":"A","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2026-03-04 21:40:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-04 21:40:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-07T10:39:03.000000Z","updated_at":"2026-03-15T09:30:37.000000Z","inspection_violations":[{"id":18974871,"change_date":"2026-03-04 21:40:00","inspection_id":"87199871","insp_violation_id":"272185734","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211959046","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:33.000000Z","updated_at":"2026-03-15T09:41:13.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":19300465,"change_date":"2026-03-04 21:40:00","inspection_id":"87199871","insp_unit_id":"211959046","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"6","insp_unit_license":"25126JV","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXDJ76HX01818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:42.000000Z","updated_at":"2026-03-15T09:04:10.000000Z"}]},{"id":10574464,"change_date":"2026-01-06 21:38:00","inspection_id":"86712565","dot_number":"1292030","report_state":"NY","report_number":"D808501403","insp_date":"2026-01-06 00:00:00","insp_start_time":"1105","insp_end_time":"1124","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"CHESTER NY","county_code_state":"NY","county_code":"071","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":"2026-01-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"44400","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":"2728310","transaction_code":"A","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2026-01-06 21:38:00","snet_input_date":"2026-01-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-06 21:38:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-09T10:34:22.000000Z","updated_at":"2026-01-17T10:30:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17720652,"change_date":"2026-01-06 21:38:00","inspection_id":"86712565","insp_unit_id":"210923131","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"36","insp_unit_license":"20903SM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVMG3DV1JHJR3433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:50.000000Z","updated_at":"2026-01-17T10:00:33.000000Z"}]},{"id":10226362,"change_date":"2025-11-26 21:38:00","inspection_id":"86348334","dot_number":"1292030","report_state":"NY","report_number":"8L51000038","insp_date":"2025-11-17 00:00:00","insp_start_time":"1126","insp_end_time":"1214","registration_date":"2025-11-25 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"MONTGOMERY NY","county_code_state":"NY","county_code":"071","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-11-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"4","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2555282","transaction_code":"C","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-11-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-11-18 21:38:00","snet_input_date":"2025-11-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-18 21:38:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-21T10:31:43.000000Z","updated_at":"2025-11-30T10:30:22.000000Z","inspection_violations":[{"id":17214530,"change_date":"2025-11-26 21:38:00","inspection_id":"86348334","insp_violation_id":"270305576","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"LP20L0QBSP","created_at":"2025-11-29T10:32:26.000000Z","updated_at":"2025-11-30T10:30:37.000000Z","normalized_code":"39141APC"},{"id":17214531,"change_date":"2025-11-26 21:38:00","inspection_id":"86348334","insp_violation_id":"270305577","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"210273612","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"LP20L0QCP2","created_at":"2025-11-29T10:32:26.000000Z","updated_at":"2025-11-30T10:30:37.000000Z","normalized_code":"393100BC"},{"id":17214532,"change_date":"2025-11-26 21:38:00","inspection_id":"86348334","insp_violation_id":"270305578","seq_no":"3","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"210273612","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-29T10:32:26.000000Z","updated_at":"2025-11-30T10:30:37.000000Z","normalized_code":"3939ALHLI"},{"id":17214533,"change_date":"2025-11-26 21:38:00","inspection_id":"86348334","insp_violation_id":"270305579","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"210273612","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-29T10:32:26.000000Z","updated_at":"2025-11-30T10:30:37.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":17185955,"change_date":"2025-11-26 21:38:00","inspection_id":"86348334","insp_unit_id":"210273612","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"45","insp_unit_license":"64171NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT5MDA05993","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-29T10:01:33.000000Z","updated_at":"2025-11-30T10:00:24.000000Z"}]},{"id":9692112,"change_date":"2025-10-29 21:39:00","inspection_id":"85786428","dot_number":"1292030","report_state":"NY","report_number":"SPT3121210","insp_date":"2025-09-09 00:00:00","insp_start_time":"1534","insp_end_time":"1545","registration_date":"2025-10-28 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"SLOATSBURG NY","county_code_state":"NY","county_code":"087","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":"U","pen_cen_match":"I","final_status_date":"2025-09-16 21:39: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":"2280405","transaction_code":"C","transaction_date":"2025-09-15 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-09-16 21:39:00","snet_input_date":"2025-09-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-16 21:39:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:00:58.000000Z","updated_at":"2025-11-02T11:00:07.000000Z","inspection_violations":[{"id":16655998,"change_date":"2025-10-29 21:39:00","inspection_id":"85786428","insp_violation_id":"269578773","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":"2025-11-01T10:17:34.000000Z","updated_at":"2025-11-02T11:15:07.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":16719671,"change_date":"2025-10-29 21:39:00","inspection_id":"85786428","insp_unit_id":"209705523","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"57","insp_unit_license":"34844NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FD0X5HT7PEC92052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:46:55.000000Z","updated_at":"2025-11-02T10:45:08.000000Z"}]},{"id":9677603,"change_date":"2025-12-12 21:41:00","inspection_id":"85771031","dot_number":"1292030","report_state":"NY","report_number":"D808501249","insp_date":"2025-09-08 00:00:00","insp_start_time":"0800","insp_end_time":"0858","registration_date":"2025-10-28 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"MIDDLETOWN NY","county_code_state":"NY","county_code":"071","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-09-14 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"6","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2274418","transaction_code":"C","transaction_date":"2025-12-12 00:00:00","upload_date":"2025-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-09-14 21:33:00","snet_input_date":"2025-09-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-14 21:33:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-17T10:40:59.000000Z","updated_at":"2025-12-23T10:30:37.000000Z","inspection_violations":[{"id":16655977,"change_date":"2025-10-29 21:39:00","inspection_id":"85771031","insp_violation_id":"269578912","seq_no":"7","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"209705601","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LP20KR7ZJG","created_at":"2025-11-01T10:17:34.000000Z","updated_at":"2025-11-02T11:15:07.000000Z","normalized_code":"3963A1BOS"},{"id":17468402,"change_date":"2025-12-12 21:41:00","inspection_id":"85771031","insp_violation_id":"270649543","seq_no":"1","part_no":"393","part_no_section":"209D-STBSP","insp_viol_unit":"1","insp_unit_id":"210575377","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LP20KR7XZJ","created_at":"2025-12-15T10:33:39.000000Z","updated_at":"2025-12-23T10:31:12.000000Z","normalized_code":"393209DSTBSP"},{"id":17468403,"change_date":"2025-12-12 21:41:00","inspection_id":"85771031","insp_violation_id":"270649544","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210575377","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP20KR7X84","created_at":"2025-12-15T10:33:39.000000Z","updated_at":"2025-12-23T10:31:12.000000Z","normalized_code":"3922SLLSR"},{"id":17468404,"change_date":"2025-12-12 21:41:00","inspection_id":"85771031","insp_violation_id":"270649545","seq_no":"3","part_no":"393","part_no_section":"47D1-BRMMCHE-SA","insp_viol_unit":"1","insp_unit_id":"210575377","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LP20KR7Z8F","created_at":"2025-12-15T10:33:39.000000Z","updated_at":"2025-12-23T10:31:12.000000Z","normalized_code":"39347D1BRMMCHESA"},{"id":17468405,"change_date":"2025-12-12 21:41:00","inspection_id":"85771031","insp_violation_id":"270649546","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"210575377","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP20KR7XW4","created_at":"2025-12-15T10:33:39.000000Z","updated_at":"2025-12-23T10:31:12.000000Z","normalized_code":"3922SLLIFTA"},{"id":17468406,"change_date":"2025-12-12 21:41:00","inspection_id":"85771031","insp_violation_id":"270649547","seq_no":"5","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"210575377","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LP20KR7ZD6","created_at":"2025-12-15T10:33:39.000000Z","updated_at":"2025-12-23T10:31:12.000000Z","normalized_code":"39375GTAOW"},{"id":17468407,"change_date":"2025-12-12 21:41:00","inspection_id":"85771031","insp_violation_id":"270649548","seq_no":"6","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"210575377","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LP20KR7ZJG","created_at":"2025-12-15T10:33:39.000000Z","updated_at":"2025-12-23T10:31:12.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":17426597,"change_date":"2025-12-12 21:41:00","inspection_id":"85771031","insp_unit_id":"210575377","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"142","insp_unit_license":"81862NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FD0X5HT0LEC66046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-15T10:02:40.000000Z","updated_at":"2025-12-23T10:00:45.000000Z"}]},{"id":9282777,"change_date":"2025-09-11 21:41:00","inspection_id":"85356200","dot_number":"1292030","report_state":"NY","report_number":"SPT3071196","insp_date":"2025-07-23 00:00:00","insp_start_time":"1505","insp_end_time":"1524","registration_date":"2025-07-28 00:00:00","region":"ED","ci_status_code":"C","location":"80698M","location_desc":"SLOATSBURG NY","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":"U","pen_cen_match":"I","final_status_date":"2025-07-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"79200","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":"2059630","transaction_code":"C","transaction_date":"2025-07-29 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-07-30 21:40:00","snet_input_date":"2025-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-30 21:40:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:08.000000Z","updated_at":"2025-09-16T10:46:23.000000Z","inspection_violations":[{"id":15799453,"change_date":"2025-09-11 21:41:00","inspection_id":"85356200","insp_violation_id":"268602919","seq_no":"1","part_no":"390","part_no_section":"21TE2IV-D","insp_viol_unit":"1","insp_unit_id":"208867848","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:56:40.000000Z","updated_at":"2025-09-14T11:56:40.000000Z","normalized_code":"39021TE2IVD"}],"inspection_per_units":[{"id":15943686,"change_date":"2025-09-11 21:41:00","inspection_id":"85356200","insp_unit_id":"208867848","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"FY2403","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KKMBPDV4SLVL2605","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:31.000000Z","updated_at":"2025-09-15T09:52:46.000000Z"}]},{"id":8673596,"change_date":"2025-05-19 21:40:00","inspection_id":"84712982","dot_number":"1292030","report_state":"NY","report_number":"D808600988","insp_date":"2025-05-13 00:00:00","insp_start_time":"0743","insp_end_time":"0815","registration_date":null,"region":"ED","ci_status_code":"C","location":"80865M","location_desc":"WALLKILL NY","county_code_state":"NY","county_code":"071","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"1749333","transaction_code":"A","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-05-19 21:40:00","snet_input_date":"2025-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-19 21:40:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-22T10:01:29.000000Z","updated_at":"2025-05-23T10:04:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14169793,"change_date":"2025-05-19 21:40:00","inspection_id":"84712982","insp_unit_id":"206936163","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"41","insp_unit_license":"21983SM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KKMAXDV0LPLT2835","insp_unit_decal":"Y","insp_unit_decal_number":"35217465","created_at":"2025-05-22T09:46:01.000000Z","updated_at":"2025-05-23T09:49:25.000000Z"}]},{"id":8104420,"change_date":"2025-03-13 21:43:00","inspection_id":"84113542","dot_number":"1292030","report_state":"NY","report_number":"SPT3070752","insp_date":"2025-03-06 00:00:00","insp_start_time":"1319","insp_end_time":"1335","registration_date":null,"region":"ES","ci_status_code":"C","location":"80923M","location_desc":"HARRIMAN NY","county_code_state":"NY","county_code":"071","insp_level_id":"3","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-13 21:43: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":"1465005","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-03-13 21:43:00","snet_input_date":"2025-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-13 21:43:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:50.000000Z","updated_at":"2025-03-17T21:06:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13085300,"change_date":"2025-03-13 21:43:00","inspection_id":"84113542","insp_unit_id":"205778119","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"132","insp_unit_license":"94345ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT2KDA04426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:41.000000Z","updated_at":"2025-03-17T23:59:41.000000Z"}]},{"id":8067101,"change_date":"2025-03-10 21:38:00","inspection_id":"84074379","dot_number":"1292030","report_state":"NY","report_number":"SPT3070734","insp_date":"2025-03-04 00:00:00","insp_start_time":"0755","insp_end_time":"0816","registration_date":null,"region":"ES","ci_status_code":"C","location":"80923M","location_desc":"HARRIMAN NY","county_code_state":"NY","county_code":"071","insp_level_id":"2","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"76350","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1450687","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-03-10 21:38:00","snet_input_date":"2025-03-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-10 21:38:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:50.000000Z","updated_at":"2025-03-17T21:05:50.000000Z","inspection_violations":[{"id":12608067,"change_date":"2025-03-10 21:38:00","inspection_id":"84074379","insp_violation_id":"264914362","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205704079","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:42.000000Z","updated_at":"2025-03-17T22:07:42.000000Z","normalized_code":"3922SLLSR"},{"id":12608068,"change_date":"2025-03-10 21:38:00","inspection_id":"84074379","insp_violation_id":"264914363","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","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-17T22:07:42.000000Z","updated_at":"2025-03-17T22:07:42.000000Z","normalized_code":"3922SLLSIV"},{"id":12608069,"change_date":"2025-03-10 21:38:00","inspection_id":"84074379","insp_violation_id":"264914364","seq_no":"3","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"1T84K368WQ","created_at":"2025-03-17T22:07:42.000000Z","updated_at":"2025-03-17T22:07:42.000000Z","normalized_code":"38323A2LCDLN"},{"id":12608070,"change_date":"2025-03-10 21:38:00","inspection_id":"84074379","insp_violation_id":"264914365","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"205704079","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1T84K368M4","created_at":"2025-03-17T22:07:42.000000Z","updated_at":"2025-03-17T22:07:42.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":13025351,"change_date":"2025-03-10 21:38:00","inspection_id":"84074379","insp_unit_id":"205704079","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"27","insp_unit_license":"23688SM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVMG3DVXJHJR3429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:58.000000Z","updated_at":"2025-03-17T23:58:58.000000Z"}]},{"id":8017588,"change_date":"2025-03-04 21:38:00","inspection_id":"84022169","dot_number":"1292030","report_state":"NY","report_number":"SPF3070536","insp_date":"2025-02-26 00:00:00","insp_start_time":"0725","insp_end_time":"0745","registration_date":null,"region":"ES","ci_status_code":"C","location":"80865M","location_desc":"WALLKILL NY","county_code_state":"NY","county_code":"071","insp_level_id":"2","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","viol_total":"2","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":"1427488","transaction_code":"A","transaction_date":"2025-03-04 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-03-04 21:38:00","snet_input_date":"2025-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-04 21:38:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:32.000000Z","updated_at":"2025-03-17T21:04:32.000000Z","inspection_violations":[{"id":12530276,"change_date":"2025-03-04 21:38:00","inspection_id":"84022169","insp_violation_id":"264814958","seq_no":"1","part_no":"392","part_no_section":"2-SLLSIV","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-17T22:07:15.000000Z","updated_at":"2025-03-17T22:07:15.000000Z","normalized_code":"3922SLLSIV"},{"id":12530277,"change_date":"2025-03-04 21:38:00","inspection_id":"84022169","insp_violation_id":"264814959","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"205608709","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:15.000000Z","updated_at":"2025-03-17T22:07:15.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":12943825,"change_date":"2025-03-04 21:38:00","inspection_id":"84022169","insp_unit_id":"205608709","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"41","insp_unit_license":"21983SM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KKMAXDV0LPLT2835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:58.000000Z","updated_at":"2025-03-17T23:57:58.000000Z"}]},{"id":8018162,"change_date":"2025-03-04 21:38:00","inspection_id":"84022780","dot_number":"1292030","report_state":"NY","report_number":"SPC3010505","insp_date":"2025-02-25 00:00:00","insp_start_time":"1554","insp_end_time":"1629","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SLOATSBURG NY","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HYDROVAC EXCAVATING 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":"U","pen_cen_match":"I","final_status_date":"2025-03-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"77020","viol_total":"4","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1428094","transaction_code":"A","transaction_date":"2025-03-04 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-03-04 21:38:00","snet_input_date":"2025-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-04 21:38:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:33.000000Z","updated_at":"2025-03-17T21:04:33.000000Z","inspection_violations":[{"id":12531490,"change_date":"2025-03-04 21:38:00","inspection_id":"84022780","insp_violation_id":"264816346","seq_no":"1","part_no":"396","part_no_section":"3A1-TFCV","insp_viol_unit":"1","insp_unit_id":"205609717","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:07:16.000000Z","updated_at":"2025-03-17T22:07:16.000000Z","normalized_code":"3963A1TFCV"},{"id":12531491,"change_date":"2025-03-04 21:38:00","inspection_id":"84022780","insp_violation_id":"264816347","seq_no":"2","part_no":"396","part_no_section":"3A1-TFCV","insp_viol_unit":"1","insp_unit_id":"205609717","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:07:16.000000Z","updated_at":"2025-03-17T22:07:16.000000Z","normalized_code":"3963A1TFCV"},{"id":12531492,"change_date":"2025-03-04 21:38:00","inspection_id":"84022780","insp_violation_id":"264816348","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"205609717","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:16.000000Z","updated_at":"2025-03-17T22:07:16.000000Z","normalized_code":"39395F"},{"id":12531493,"change_date":"2025-03-04 21:38:00","inspection_id":"84022780","insp_violation_id":"264816349","seq_no":"4","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"205609717","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:07:16.000000Z","updated_at":"2025-03-17T22:07:16.000000Z","normalized_code":"3929A2C"}],"inspection_per_units":[{"id":12944764,"change_date":"2025-03-04 21:38:00","inspection_id":"84022780","insp_unit_id":"205609717","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"53","insp_unit_license":"14008SR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KKMBPDV7PLUF6252","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:58.000000Z","updated_at":"2025-03-17T23:57:58.000000Z"}]},{"id":7889984,"change_date":"2025-02-18 21:39:00","inspection_id":"83888412","dot_number":"1292030","report_state":"NY","report_number":"SPF3060465","insp_date":"2025-02-11 00:00:00","insp_start_time":"1415","insp_end_time":"1430","registration_date":null,"region":"ES","ci_status_code":"C","location":"80479M","location_desc":"HIGHLAND NY","county_code_state":"NY","county_code":"111","insp_level_id":"3","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1371892","transaction_code":"A","transaction_date":"2025-02-18 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-02-18 21:39:00","snet_input_date":"2025-02-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-18 21:39:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:59.000000Z","updated_at":"2025-03-17T21:01:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12735703,"change_date":"2025-02-18 21:39:00","inspection_id":"83888412","insp_unit_id":"205363171","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"52","insp_unit_license":"10038SR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPCXPEX2PD880640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:43.000000Z","updated_at":"2025-03-17T23:55:43.000000Z"}]},{"id":7799191,"change_date":"2025-02-06 21:40:00","inspection_id":"83793036","dot_number":"1292030","report_state":"NY","report_number":"SPK3050284","insp_date":"2025-01-30 00:00:00","insp_start_time":"1204","insp_end_time":"1224","registration_date":null,"region":"ES","ci_status_code":"C","location":"80789M","location_desc":"BREWSTER NY","county_code_state":"NY","county_code":"079","insp_level_id":"2","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"22495","viol_total":"2","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":"1329072","transaction_code":"A","transaction_date":"2025-02-06 00:00:00","upload_date":"2025-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-02-06 21:40:00","snet_input_date":"2025-01-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-06 21:40:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:58.000000Z","updated_at":"2025-03-17T20:59:58.000000Z","inspection_violations":[{"id":12188028,"change_date":"2025-02-06 21:40:00","inspection_id":"83793036","insp_violation_id":"264366484","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"205182767","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:28.000000Z","updated_at":"2025-03-17T22:05:28.000000Z","normalized_code":"3939ALRLI"},{"id":12188029,"change_date":"2025-02-06 21:40:00","inspection_id":"83793036","insp_violation_id":"264366485","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"205182767","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:28.000000Z","updated_at":"2025-03-17T22:05:28.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":12586365,"change_date":"2025-02-06 21:40:00","inspection_id":"83793036","insp_unit_id":"205182766","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"80951NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT5MDA05993","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:03.000000Z","updated_at":"2025-03-17T23:54:03.000000Z"},{"id":12586366,"change_date":"2025-02-06 21:40:00","inspection_id":"83793036","insp_unit_id":"205182767","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DOOSON","insp_unit_company":"AIR COMPRESSOR","insp_unit_license":"999999","insp_unit_license_state":"OT","insp_unit_vehicle_id_number":"000000000000000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:03.000000Z","updated_at":"2025-03-17T23:54:03.000000Z"}]},{"id":7778748,"change_date":"2025-02-04 21:39:00","inspection_id":"83771582","dot_number":"1292030","report_state":"NY","report_number":"SPE3070372","insp_date":"2025-01-28 00:00:00","insp_start_time":"1339","insp_end_time":"1357","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SLOATSBURG NY","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":"U","pen_cen_match":"I","final_status_date":"2025-02-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44400","viol_total":"2","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":"1320398","transaction_code":"A","transaction_date":"2025-02-04 00:00:00","upload_date":"2025-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-02-04 21:39:00","snet_input_date":"2025-01-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-04 21:39:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:35.000000Z","updated_at":"2025-03-17T20:59:35.000000Z","inspection_violations":[{"id":12154894,"change_date":"2025-02-04 21:39:00","inspection_id":"83771582","insp_violation_id":"264320701","seq_no":"1","part_no":"393","part_no_section":"55C1-B","insp_viol_unit":"1","insp_unit_id":"205142323","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:17.000000Z","updated_at":"2025-03-17T22:05:17.000000Z","normalized_code":"39355C1B"},{"id":12154895,"change_date":"2025-02-04 21:39:00","inspection_id":"83771582","insp_violation_id":"264320702","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"205142323","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:17.000000Z","updated_at":"2025-03-17T22:05:17.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":12553910,"change_date":"2025-02-04 21:39:00","inspection_id":"83771582","insp_unit_id":"205142323","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"36","insp_unit_license":"20903SM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVMG3DV1JHJR3433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:38.000000Z","updated_at":"2025-03-17T23:53:38.000000Z"}]},{"id":7779799,"change_date":"2025-02-04 21:39:00","inspection_id":"83772709","dot_number":"1292030","report_state":"NY","report_number":"D808500956","insp_date":"2025-01-28 00:00:00","insp_start_time":"0957","insp_end_time":"1135","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WEST NYACK NY","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":"U","pen_cen_match":"I","final_status_date":"2025-02-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","viol_total":"6","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":"1322015","transaction_code":"A","transaction_date":"2025-02-04 00:00:00","upload_date":"2025-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-02-04 21:39:00","snet_input_date":"2025-01-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-04 21:39:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:35.000000Z","updated_at":"2025-03-17T20:59:35.000000Z","inspection_violations":[{"id":12156932,"change_date":"2025-02-04 21:39:00","inspection_id":"83772709","insp_violation_id":"264323456","seq_no":"1","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"205144407","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"C237JZGNV4","created_at":"2025-03-17T22:05:17.000000Z","updated_at":"2025-03-17T22:05:17.000000Z","normalized_code":"3963A1F"},{"id":12156933,"change_date":"2025-02-04 21:39:00","inspection_id":"83772709","insp_violation_id":"264323457","seq_no":"2","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"205144407","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:17.000000Z","updated_at":"2025-03-17T22:05:17.000000Z","normalized_code":"3965BL"},{"id":12156934,"change_date":"2025-02-04 21:39:00","inspection_id":"83772709","insp_violation_id":"264323458","seq_no":"3","part_no":"393","part_no_section":"134B-CRHLC","insp_viol_unit":"1","insp_unit_id":"205144407","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"C237JZGM8Q","created_at":"2025-03-17T22:05:17.000000Z","updated_at":"2025-03-17T22:05:17.000000Z","normalized_code":"393134BCRHLC"},{"id":12156935,"change_date":"2025-02-04 21:39:00","inspection_id":"83772709","insp_violation_id":"264323459","seq_no":"4","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"205144407","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:17.000000Z","updated_at":"2025-03-17T22:05:17.000000Z","normalized_code":"39311A1LLPL"},{"id":12156936,"change_date":"2025-02-04 21:39:00","inspection_id":"83772709","insp_violation_id":"264323460","seq_no":"5","part_no":"393","part_no_section":"209D-STBSM","insp_viol_unit":"1","insp_unit_id":"205144407","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"C237JZGNK1","created_at":"2025-03-17T22:05:17.000000Z","updated_at":"2025-03-17T22:05:17.000000Z","normalized_code":"393209DSTBSM"},{"id":12156937,"change_date":"2025-02-04 21:39:00","inspection_id":"83772709","insp_violation_id":"264323461","seq_no":"6","part_no":"393","part_no_section":"209D-STBSP","insp_viol_unit":"1","insp_unit_id":"205144407","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"C237JZGNMV","created_at":"2025-03-17T22:05:17.000000Z","updated_at":"2025-03-17T22:05:17.000000Z","normalized_code":"393209DSTBSP"}],"inspection_per_units":[{"id":12555553,"change_date":"2025-02-04 21:39:00","inspection_id":"83772709","insp_unit_id":"205144407","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"132","insp_unit_license":"94345ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT2KDA04426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:41.000000Z","updated_at":"2025-03-17T23:53:41.000000Z"}]},{"id":7663693,"change_date":"2025-01-20 21:34:00","inspection_id":"83650685","dot_number":"1292030","report_state":"NY","report_number":"D808600763","insp_date":"2025-01-14 00:00:00","insp_start_time":"0724","insp_end_time":"0739","registration_date":null,"region":"ES","ci_status_code":"C","location":"80865M","location_desc":"WALLKILL NY","county_code_state":"NY","county_code":"071","insp_level_id":"3","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-20 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"1268897","transaction_code":"A","transaction_date":"2025-01-20 00:00:00","upload_date":"2025-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-01-20 21:34:00","snet_input_date":"2025-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-20 21:34:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:25.000000Z","updated_at":"2025-03-17T20:57:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12366205,"change_date":"2025-01-20 21:34:00","inspection_id":"83650685","insp_unit_id":"204918809","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"41","insp_unit_license":"21983SM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KKMAXDV0LPLT2835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:29.000000Z","updated_at":"2025-03-17T23:51:29.000000Z"}]},{"id":7663155,"change_date":"2025-01-20 21:34:00","inspection_id":"83650114","dot_number":"1292030","report_state":"NY","report_number":"SPT3070491","insp_date":"2025-01-13 00:00:00","insp_start_time":"1247","insp_end_time":"1302","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NANUET NY","county_code_state":"NY","county_code":"087","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-20 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"1268098","transaction_code":"A","transaction_date":"2025-01-20 00:00:00","upload_date":"2025-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2025-01-20 21:34:00","snet_input_date":"2025-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-20 21:34:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:25.000000Z","updated_at":"2025-03-17T20:57:25.000000Z","inspection_violations":[{"id":11972227,"change_date":"2025-01-20 21:34:00","inspection_id":"83650114","insp_violation_id":"264081900","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204917860","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12365338,"change_date":"2025-01-20 21:34:00","inspection_id":"83650114","insp_unit_id":"204917860","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"38","insp_unit_license":"20902SM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KKMAXDV5LPLT2832","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:29.000000Z","updated_at":"2025-03-17T23:51:29.000000Z"}]},{"id":7483645,"change_date":"2025-01-14 21:53:00","inspection_id":"83461652","dot_number":"1292030","report_state":"NY","report_number":"SPT3070415","insp_date":"2024-12-17 00:00:00","insp_start_time":"0748","insp_end_time":"0805","registration_date":null,"region":"ES","ci_status_code":"C","location":"80923M","location_desc":"HARRIMAN NY","county_code_state":"NY","county_code":"071","insp_level_id":"2","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"4","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":"1187662","transaction_code":"C","transaction_date":"2024-12-23 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2024-12-23 21:39:00","snet_input_date":"2024-12-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-23 21:39:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:17.000000Z","updated_at":"2025-03-17T20:52:17.000000Z","inspection_violations":[{"id":11698469,"change_date":"2025-01-14 21:53:00","inspection_id":"83461652","insp_violation_id":"263922008","seq_no":"1","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"204791932","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1T84JSZV73","created_at":"2025-03-17T22:02:57.000000Z","updated_at":"2025-03-17T22:02:57.000000Z","normalized_code":"39311A1LIL"},{"id":11698470,"change_date":"2025-01-14 21:53:00","inspection_id":"83461652","insp_violation_id":"263922009","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"204791932","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:57.000000Z","updated_at":"2025-03-17T22:02:57.000000Z","normalized_code":"3922SLLIFTA"},{"id":11698471,"change_date":"2025-01-14 21:53:00","inspection_id":"83461652","insp_violation_id":"263922010","seq_no":"3","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"204791932","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:57.000000Z","updated_at":"2025-03-17T22:02:57.000000Z","normalized_code":"39378AWS"},{"id":11698472,"change_date":"2025-01-14 21:53:00","inspection_id":"83461652","insp_violation_id":"263922011","seq_no":"4","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":"1T84JSZTWJ","created_at":"2025-03-17T22:02:57.000000Z","updated_at":"2025-03-17T22:02:57.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":12073310,"change_date":"2025-01-14 21:53:00","inspection_id":"83461652","insp_unit_id":"204791932","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"81862NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FD0X5HT0LEC66046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:18.000000Z","updated_at":"2025-03-17T23:48:18.000000Z"}]},{"id":6813385,"change_date":"2024-09-25 21:41:00","inspection_id":"82752542","dot_number":"1292030","report_state":"NY","report_number":"SPC3010038","insp_date":"2024-09-18 00:00:00","insp_start_time":"1448","insp_end_time":"1502","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SLOATSBURG NY","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":"U","pen_cen_match":"I","final_status_date":"2024-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"13997","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":"882566","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:13.000000Z","updated_at":"2025-03-17T20:38:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10987300,"change_date":"2024-09-25 21:41:00","inspection_id":"82752542","insp_unit_id":"203117803","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"66382NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDRF3HT4NDA01637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:48.000000Z","updated_at":"2025-03-17T23:36:48.000000Z"}]},{"id":6594833,"change_date":"2024-08-29 21:42:00","inspection_id":"82519544","dot_number":"1292030","report_state":"NY","report_number":"SPT0484036","insp_date":"2024-08-28 00:00:00","insp_start_time":"0741","insp_end_time":"0800","registration_date":null,"region":"ET","ci_status_code":"C","location":"80923B","location_desc":"WOODBURY INSPECTION SITE","county_code_state":"NY","county_code":"071","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":"N","pen_cen_match":null,"final_status_date":"2024-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2948011","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2024-08-29 21:42:00","snet_input_date":"2024-08-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-08-29 21:42:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:41.000000Z","updated_at":"2025-03-17T20:33:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10632002,"change_date":"2024-08-29 21:42:00","inspection_id":"82519544","insp_unit_id":"202649939","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"81862NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FD0X5HT0LEC66046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:07.000000Z","updated_at":"2025-03-17T23:33:07.000000Z"}]},{"id":6205024,"change_date":"2024-07-12 21:39:00","inspection_id":"82102996","dot_number":"1292030","report_state":"NY","report_number":"SPK0230462","insp_date":"2024-07-11 00:00:00","insp_start_time":"1443","insp_end_time":"1502","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789","location_desc":"SOUTHEAST","county_code_state":"NY","county_code":"079","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-07-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2936280","transaction_code":"A","transaction_date":"2024-07-12 00:00:00","upload_date":"2024-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2024-07-12 21:39:00","snet_input_date":"2024-07-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-12 21:39:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:45.000000Z","updated_at":"2025-03-17T20:25:45.000000Z","inspection_violations":[{"id":9637836,"change_date":"2024-07-12 21:39:00","inspection_id":"82102996","insp_violation_id":"260610125","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:37.000000Z","updated_at":"2025-03-17T21:52:37.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":9996110,"change_date":"2024-07-12 21:39:00","inspection_id":"82102996","insp_unit_id":"201855961","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"49864NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5HT6KEF26792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:36.000000Z","updated_at":"2025-03-17T23:26:36.000000Z"}]},{"id":6184980,"change_date":"2024-07-10 21:40:00","inspection_id":"82081533","dot_number":"1292030","report_state":"NY","report_number":"SPT0483871","insp_date":"2024-07-09 00:00:00","insp_start_time":"1434","insp_end_time":"1452","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-07-10 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":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2935418","transaction_code":"A","transaction_date":"2024-07-10 00:00:00","upload_date":"2024-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2024-07-10 21:40:00","snet_input_date":"2024-07-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-10 21:40:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:21.000000Z","updated_at":"2025-03-17T20:25:21.000000Z","inspection_violations":[{"id":9604625,"change_date":"2024-07-10 21:40:00","inspection_id":"82081533","insp_violation_id":"260562541","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201814934","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:30.000000Z","updated_at":"2025-03-17T21:52:30.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9963634,"change_date":"2024-07-10 21:40:00","inspection_id":"82081533","insp_unit_id":"201814934","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"80951NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT5MDA05993","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:14.000000Z","updated_at":"2025-03-17T23:26:14.000000Z"}]},{"id":6217763,"change_date":"2024-07-15 21:41:00","inspection_id":"82116680","dot_number":"1292030","report_state":"NY","report_number":"SPC0260945","insp_date":"2024-07-09 00:00:00","insp_start_time":"1540","insp_end_time":"1555","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":"HYDROVAC EXCAVATING","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-07-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2937013","transaction_code":"A","transaction_date":"2024-07-15 00:00:00","upload_date":"2024-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2024-07-15 21:41:00","snet_input_date":"2024-07-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:49.000000Z","updated_at":"2025-03-17T20:25:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10017417,"change_date":"2024-07-15 21:41:00","inspection_id":"82116680","insp_unit_id":"201883365","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"46","insp_unit_license":"66382NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDRF3HT4NDA01637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:48.000000Z","updated_at":"2025-03-17T23:26:48.000000Z"}]},{"id":5973207,"change_date":"2024-06-12 21:42:00","inspection_id":"81853345","dot_number":"1292030","report_state":"NY","report_number":"SPC0242850","insp_date":"2024-06-11 00:00:00","insp_start_time":"1535","insp_end_time":"1552","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":"HYDROVAC EXCAVATING 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-06-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"2928980","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2024-06-12 21:42:00","snet_input_date":"2024-06-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-12 21:42:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:06.000000Z","updated_at":"2025-03-17T20:21:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9621178,"change_date":"2024-06-12 21:42:00","inspection_id":"81853345","insp_unit_id":"201357093","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"46","insp_unit_license":"66382NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDRF3HT4NDA01637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:45.000000Z","updated_at":"2025-03-17T23:22:45.000000Z"}]},{"id":5982538,"change_date":"2024-06-13 21:42:00","inspection_id":"81863512","dot_number":"1292030","report_state":"NY","report_number":"SPE0274529","insp_date":"2024-06-11 00:00:00","insp_start_time":"1330","insp_end_time":"1405","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":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HYDROVAC EXCAVATING 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-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2929392","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"PO BOX 398","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:26.000000Z","updated_at":"2025-03-17T20:21:26.000000Z","inspection_violations":[{"id":9281468,"change_date":"2024-06-13 21:42:00","inspection_id":"81863512","insp_violation_id":"260066152","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201376342","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"39395A"},{"id":9281469,"change_date":"2024-06-13 21:42:00","inspection_id":"81863512","insp_violation_id":"260066153","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"201376342","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":9636026,"change_date":"2024-06-13 21:42:00","inspection_id":"81863512","insp_unit_id":"201376342","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"57","insp_unit_license":"34844NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FD0X5HT7PEC92052","insp_unit_decal":"Y","insp_unit_decal_number":"34017691","created_at":"2025-03-17T23:22:53.000000Z","updated_at":"2025-03-17T23:22:53.000000Z"}]},{"id":5776326,"change_date":"2024-05-17 21:40:00","inspection_id":"81639543","dot_number":"1292030","report_state":"NY","report_number":"SPC0226675","insp_date":"2024-04-24 00:00:00","insp_start_time":"1332","insp_end_time":"1353","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698","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":"HYDROVAC EXCAVATING 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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-17 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":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2924032","transaction_code":"A","transaction_date":"2024-05-17 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2024-05-17 21:40:00","snet_input_date":"2024-05-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-17 21:40:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"PO BOX 398","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:08.000000Z","updated_at":"2025-03-17T20:17:08.000000Z","inspection_violations":[{"id":8943159,"change_date":"2024-05-17 21:40:00","inspection_id":"81639543","insp_violation_id":"259569021","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200948750","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:16.000000Z","updated_at":"2025-03-17T21:49:16.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9303596,"change_date":"2024-05-17 21:40:00","inspection_id":"81639543","insp_unit_id":"200948750","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"45","insp_unit_license":"80951NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT5MDA05993","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:36.000000Z","updated_at":"2025-03-17T23:19:36.000000Z"}]},{"id":5303863,"change_date":"2024-03-18 21:38:00","inspection_id":"81124842","dot_number":"1292030","report_state":"NY","report_number":"SPT0473800","insp_date":"2024-03-15 00:00:00","insp_start_time":"1201","insp_end_time":"1216","registration_date":null,"region":"ET","ci_status_code":"C","location":"81478A","location_desc":"SPRING VALLEY EXIT 14N","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-03-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2912255","transaction_code":"A","transaction_date":"2024-03-15 00:00:00","upload_date":"2024-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2024-03-18 21:38:00","snet_input_date":"2024-03-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-18 21:38:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:52.000000Z","updated_at":"2025-03-17T20:07:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8541526,"change_date":"2024-03-18 21:38:00","inspection_id":"81124842","insp_unit_id":"199951737","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"52","insp_unit_license":"10038SR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPCXPEX2PD880640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:25.000000Z","updated_at":"2025-03-17T23:12:25.000000Z"}]},{"id":5060849,"change_date":"2024-02-15 21:42:00","inspection_id":"80859829","dot_number":"1292030","report_state":"NY","report_number":"SPT0421095","insp_date":"2024-02-09 00:00:00","insp_start_time":"0730","insp_end_time":"0800","registration_date":null,"region":"ET","ci_status_code":"C","location":"80923A","location_desc":"WOODBURY INSPECTION SITE","county_code_state":"NY","county_code":"071","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-02-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2907411","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2024-02-15 21:42:00","snet_input_date":"2024-02-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-15 21:42:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:02.000000Z","updated_at":"2025-03-17T20:03:02.000000Z","inspection_violations":[{"id":7801162,"change_date":"2024-02-15 21:42:00","inspection_id":"80859829","insp_violation_id":"257860282","seq_no":"1","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"199441898","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:45.000000Z","updated_at":"2025-03-17T21:43:45.000000Z","normalized_code":"39324A"}],"inspection_per_units":[{"id":8146402,"change_date":"2024-02-15 21:42:00","inspection_id":"80859829","insp_unit_id":"199441898","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"66382NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDRF3HT4NDA01637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:51.000000Z","updated_at":"2025-03-17T23:08:51.000000Z"}]},{"id":5038620,"change_date":"2024-02-13 21:41:00","inspection_id":"80835570","dot_number":"1292030","report_state":"NY","report_number":"SPE0311505","insp_date":"2024-02-07 00:00:00","insp_start_time":"1300","insp_end_time":"1325","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-02-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"72350","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":"2906647","transaction_code":"A","transaction_date":"2024-02-13 00:00:00","upload_date":"2024-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2024-02-13 21:41:00","snet_input_date":"2024-02-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-13 21:41:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:26.000000Z","updated_at":"2025-03-17T20:02:26.000000Z","inspection_violations":[{"id":7764988,"change_date":"2024-02-13 21:41:00","inspection_id":"80835570","insp_violation_id":"257808207","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199396885","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:33.000000Z","updated_at":"2025-03-17T21:43:33.000000Z","normalized_code":"3939A"},{"id":7764989,"change_date":"2024-02-13 21:41:00","inspection_id":"80835570","insp_violation_id":"257808208","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199396885","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:33.000000Z","updated_at":"2025-03-17T21:43:33.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8110630,"change_date":"2024-02-13 21:41:00","inspection_id":"80835570","insp_unit_id":"199396885","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"27","insp_unit_license":"23688SM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVMG3DVXJHJR3429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:30.000000Z","updated_at":"2025-03-17T23:08:30.000000Z"}]},{"id":4628309,"change_date":"2023-12-14 21:42:00","inspection_id":"80386904","dot_number":"1292030","report_state":"NY","report_number":"SPG0225028","insp_date":"2023-12-12 00:00:00","insp_start_time":"1417","insp_end_time":"1433","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":"2023-12-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2893157","transaction_code":"A","transaction_date":"2023-12-14 00:00:00","upload_date":"2023-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2023-12-14 21:42:00","snet_input_date":"2023-12-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-12-14 21:42:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:33.000000Z","updated_at":"2025-03-17T19:54:33.000000Z","inspection_violations":[{"id":7154716,"change_date":"2023-12-14 21:42:00","inspection_id":"80386904","insp_violation_id":"256878911","seq_no":"1","part_no":"391","part_no_section":"41(a)","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-03-17T21:40:33.000000Z","updated_at":"2025-03-17T21:40:33.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":7443990,"change_date":"2023-12-14 21:42:00","inspection_id":"80386904","insp_unit_id":"198501396","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"80951NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT5MDA05993","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:34.000000Z","updated_at":"2025-03-17T23:02:34.000000Z"}]},{"id":4019658,"change_date":"2023-09-21 21:40:00","inspection_id":"79714449","dot_number":"1292030","report_state":"NY","report_number":"SPT0420983","insp_date":"2023-09-19 00:00:00","insp_start_time":"1510","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698B","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":"2023-09-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"2871007","transaction_code":"A","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2023-09-21 21:40:00","snet_input_date":"2023-09-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-21 21:40:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:05.000000Z","updated_at":"2025-03-17T19:42:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6463091,"change_date":"2023-09-21 21:40:00","inspection_id":"79714449","insp_unit_id":"197157616","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"66382NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDRF3HT4NDA01637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:15.000000Z","updated_at":"2025-03-17T22:54:15.000000Z"}]},{"id":3785189,"change_date":"2023-08-21 21:41:00","inspection_id":"79453234","dot_number":"1292030","report_state":"NY","report_number":"SPT0472971","insp_date":"2023-08-19 00:00:00","insp_start_time":"1001","insp_end_time":"1016","registration_date":null,"region":"ET","ci_status_code":"C","location":"81478A","location_desc":"SPRING VALLEY TANDEM EXIT 14N","county_code_state":"NY","county_code":"087","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-08-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2860793","transaction_code":"A","transaction_date":"2023-08-19 00:00:00","upload_date":"2023-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2023-08-21 21:41:00","snet_input_date":"2023-08-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-21 21:41:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:39.000000Z","updated_at":"2025-03-17T19:37:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6085839,"change_date":"2023-08-21 21:41:00","inspection_id":"79453234","insp_unit_id":"196625835","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"10038SR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPCXPEX2PD880640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:09.000000Z","updated_at":"2025-03-17T22:51:09.000000Z"}]},{"id":3785033,"change_date":"2023-08-21 21:41:00","inspection_id":"79453062","dot_number":"1292030","report_state":"NY","report_number":"SPWK071155","insp_date":"2023-08-17 00:00:00","insp_start_time":"1350","insp_end_time":"1409","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789","location_desc":"SOUTHEAST (NB)","county_code_state":"NY","county_code":"079","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-08-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2860344","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2023-08-21 21:41:00","snet_input_date":"2023-08-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-21 21:41:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:39.000000Z","updated_at":"2025-03-17T19:37:39.000000Z","inspection_violations":[{"id":5839431,"change_date":"2023-08-21 21:41:00","inspection_id":"79453062","insp_violation_id":"254761090","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"3922"},{"id":5839432,"change_date":"2023-08-21 21:41:00","inspection_id":"79453062","insp_violation_id":"254761091","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6085621,"change_date":"2023-08-21 21:41:00","inspection_id":"79453062","insp_unit_id":"196625595","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"59487MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5HT3FEA35988","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:09.000000Z","updated_at":"2025-03-17T22:51:09.000000Z"}]},{"id":3586095,"change_date":"2023-07-25 21:40:00","inspection_id":"79230716","dot_number":"1292030","report_state":"NY","report_number":"SPWF090848","insp_date":"2023-07-24 00:00:00","insp_start_time":"0956","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"80569","location_desc":"NEWBURGH","county_code_state":"NY","county_code":"071","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-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13300","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":"2851036","transaction_code":"A","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2023-07-25 21:40:00","snet_input_date":"2023-07-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-25 21:40:00","insp_carrier_name":"HYDROVAC EXCAVATION INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:52.000000Z","updated_at":"2025-03-17T19:33:52.000000Z","inspection_violations":[{"id":5529131,"change_date":"2023-07-25 21:40:00","inspection_id":"79230716","insp_violation_id":"254255333","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9H0CQ63","created_at":"2025-03-17T21:32:38.000000Z","updated_at":"2025-03-17T21:32:38.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5765851,"change_date":"2023-07-25 21:40:00","inspection_id":"79230716","insp_unit_id":"196174141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"20832ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDRF3HT7CEB80084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:31.000000Z","updated_at":"2025-03-17T22:48:31.000000Z"}]},{"id":3463941,"change_date":"2023-07-10 21:41:00","inspection_id":"79093725","dot_number":"1292030","report_state":"NY","report_number":"SPF0166803","insp_date":"2023-07-07 00:00:00","insp_start_time":"1205","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":"80881A","location_desc":"WAWAYANDA (EB)","county_code_state":"NY","county_code":"071","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-07-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2844925","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":"01292030","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":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:40.000000Z","updated_at":"2025-03-17T19:31:40.000000Z","inspection_violations":[{"id":5341750,"change_date":"2023-07-10 21:41:00","inspection_id":"79093725","insp_violation_id":"253948849","seq_no":"1","part_no":"391","part_no_section":"41(a)-FPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:49.000000Z","updated_at":"2025-03-17T21:31:49.000000Z","normalized_code":"39141AFPC"}],"inspection_per_units":[{"id":5569695,"change_date":"2023-07-10 21:41:00","inspection_id":"79093725","insp_unit_id":"195898130","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"49864NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5HT6KEF26792","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":3339917,"change_date":"2023-06-22 21:41:00","inspection_id":"78954188","dot_number":"1292030","report_state":"NY","report_number":"SPA0275370","insp_date":"2023-06-13 00:00:00","insp_start_time":"1440","insp_end_time":"1502","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":"2023-06-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2839269","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2023-06-22 21:41:00","snet_input_date":"2023-06-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-22 21:41:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:58.000000Z","updated_at":"2025-03-17T19:28:58.000000Z","inspection_violations":[{"id":5150150,"change_date":"2023-06-22 21:41:00","inspection_id":"78954188","insp_violation_id":"253635994","seq_no":"1","part_no":"391","part_no_section":"41(a)","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-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"39141A"},{"id":5150151,"change_date":"2023-06-22 21:41:00","inspection_id":"78954188","insp_violation_id":"253635995","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195617625","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":5369305,"change_date":"2023-06-22 21:41:00","inspection_id":"78954188","insp_unit_id":"195617625","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"81862NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FD0X5HT0LEC66046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:21.000000Z","updated_at":"2025-03-17T22:45:21.000000Z"}]},{"id":3028561,"change_date":"2023-05-12 21:41:00","inspection_id":"78603009","dot_number":"1292030","report_state":"NY","report_number":"SPWK082168","insp_date":"2023-05-11 00:00:00","insp_start_time":"0629","insp_end_time":"0649","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789","location_desc":"INTERSTATE 84","county_code_state":"NY","county_code":"079","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":"2023-05-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","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":"2824584","transaction_code":"A","transaction_date":"2023-05-11 00:00:00","upload_date":"2023-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2023-05-12 21:41:00","snet_input_date":"2023-05-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-12 21:41:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"PO BOX 590","insp_carrier_city":"WALLKILL","insp_carrier_state":"NY","insp_carrier_zip_code":"12589","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:00.000000Z","updated_at":"2025-03-17T19:23:00.000000Z","inspection_violations":[{"id":4651244,"change_date":"2023-05-12 21:41:00","inspection_id":"78603009","insp_violation_id":"252787182","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194892517","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:40.000000Z","updated_at":"2025-03-17T21:28:40.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4872279,"change_date":"2023-05-12 21:41:00","inspection_id":"78603009","insp_unit_id":"194892516","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"49864NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5HT6KEF26792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:24.000000Z","updated_at":"2025-03-17T22:41:24.000000Z"},{"id":4872280,"change_date":"2023-05-12 21:41:00","inspection_id":"78603009","insp_unit_id":"194892517","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"UNREG","insp_unit_license_state":"OT","insp_unit_vehicle_id_number":"D021007JD","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:24.000000Z","updated_at":"2025-03-17T22:41:24.000000Z"}]},{"id":2738611,"change_date":"2023-04-05 21:41:00","inspection_id":"78274760","dot_number":"1292030","report_state":"NY","report_number":"8L28000276","insp_date":"2023-04-04 00:00:00","insp_start_time":"0755","insp_end_time":"0827","registration_date":null,"region":"ET","ci_status_code":"C","location":"80167","location_desc":"CLARKSTOWN","county_code_state":"NY","county_code":"087","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":"N","pen_cen_match":"I","final_status_date":"2023-04-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2812887","transaction_code":"A","transaction_date":"2023-04-05 00:00:00","upload_date":"2023-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2023-04-05 21:41:00","snet_input_date":"2023-04-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-04-05 21:41:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"PO BOX 398","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:01.000000Z","updated_at":"2025-03-17T19:17:01.000000Z","inspection_violations":[{"id":4204362,"change_date":"2023-04-05 21:41:00","inspection_id":"78274760","insp_violation_id":"252056950","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","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-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"39141A1"},{"id":4204363,"change_date":"2023-04-05 21:41:00","inspection_id":"78274760","insp_violation_id":"252056951","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194237017","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":4408074,"change_date":"2023-04-05 21:41:00","inspection_id":"78274760","insp_unit_id":"194237017","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"142","insp_unit_license":"81862NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FD0X5HT0LEC66046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:41.000000Z","updated_at":"2025-03-17T22:37:41.000000Z"}]},{"id":2453317,"change_date":"2023-02-27 21:41:00","inspection_id":"77949644","dot_number":"1292030","report_state":"NY","report_number":"SPWF031371","insp_date":"2023-02-23 00:00:00","insp_start_time":"0829","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":"80569","location_desc":"SR-17K AND I-84 E\/B","county_code_state":"NY","county_code":"071","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-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2802398","transaction_code":"A","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2023-02-27 21:41:00","snet_input_date":"2023-02-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-27 21:41:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:48.000000Z","updated_at":"2025-03-17T19:11:48.000000Z","inspection_violations":[{"id":3777053,"change_date":"2023-02-27 21:41:00","inspection_id":"77949644","insp_violation_id":"251345711","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193586844","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:45.000000Z","updated_at":"2025-03-17T21:24:45.000000Z","normalized_code":"3922"},{"id":3777054,"change_date":"2023-02-27 21:41:00","inspection_id":"77949644","insp_violation_id":"251345712","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193586844","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:45.000000Z","updated_at":"2025-03-17T21:24:45.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3947743,"change_date":"2023-02-27 21:41:00","inspection_id":"77949644","insp_unit_id":"193586844","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"45","insp_unit_license":"80951NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT5MDA05993","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:16.000000Z","updated_at":"2025-03-17T22:34:16.000000Z"}]},{"id":2405757,"change_date":"2023-02-21 21:40:00","inspection_id":"77895521","dot_number":"1292030","report_state":"NY","report_number":"SPT0482057","insp_date":"2023-02-16 00:00:00","insp_start_time":"1052","insp_end_time":"1111","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"I-87 SOUTH EXIT 15A","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2801061","transaction_code":"A","transaction_date":"2023-02-16 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":null,"census_search_date":"2023-02-21 21:40:00","snet_input_date":"2023-02-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-21 21:40:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:02.000000Z","updated_at":"2025-03-17T19:11:02.000000Z","inspection_violations":[{"id":3703324,"change_date":"2023-02-21 21:40:00","inspection_id":"77895521","insp_violation_id":"251225792","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4GFJ88S","created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"39141A"},{"id":3703325,"change_date":"2023-02-21 21:40:00","inspection_id":"77895521","insp_violation_id":"251225793","seq_no":"2","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"193480125","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":3871329,"change_date":"2023-02-21 21:40:00","inspection_id":"77895521","insp_unit_id":"193480125","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"94345ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT2KDA04426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:44.000000Z","updated_at":"2025-03-17T22:33:44.000000Z"}]},{"id":2355057,"change_date":"2023-02-13 21:42:00","inspection_id":"77837554","dot_number":"1292030","report_state":"NY","report_number":"SPT0432852","insp_date":"2023-02-07 00:00:00","insp_start_time":"1505","insp_end_time":"1541","registration_date":null,"region":"ET","ci_status_code":"C","location":"81465","location_desc":"SLOATSBURG N\/B","county_code_state":"NY","county_code":"087","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"77020","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2798176","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2023-02-13 21:42:00","snet_input_date":"2023-02-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-13 21:42:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:00.000000Z","updated_at":"2025-03-17T19:10:00.000000Z","inspection_violations":[{"id":3628011,"change_date":"2023-02-13 21:42:00","inspection_id":"77837554","insp_violation_id":"251091600","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"3922"},{"id":3628012,"change_date":"2023-02-13 21:42:00","inspection_id":"77837554","insp_violation_id":"251091601","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193359571","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4GDL2M7","created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"3922"},{"id":3628013,"change_date":"2023-02-13 21:42:00","inspection_id":"77837554","insp_violation_id":"251091602","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193359571","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"3922"},{"id":3628014,"change_date":"2023-02-13 21:42:00","inspection_id":"77837554","insp_violation_id":"251091603","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193359571","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3789900,"change_date":"2023-02-13 21:42:00","inspection_id":"77837554","insp_unit_id":"193359571","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"53","insp_unit_license":"4889914","insp_unit_license_state":"CO","insp_unit_vehicle_id_number":"5KKMBPDV7PLUF6252","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:07.000000Z","updated_at":"2025-03-17T22:33:07.000000Z"}]},{"id":2281952,"change_date":"2023-02-02 21:41:00","inspection_id":"77754153","dot_number":"1292030","report_state":"NY","report_number":"SPT0472347","insp_date":"2023-02-01 00:00:00","insp_start_time":"1530","insp_end_time":"1550","registration_date":null,"region":"ET","ci_status_code":"C","location":"81478A","location_desc":"SPRING VALLEY TANDEM EXIT 14N","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":"2023-02-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"81000","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":"2794884","transaction_code":"A","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2023-02-02 21:41:00","snet_input_date":"2023-02-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-02 21:41:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:50.000000Z","updated_at":"2025-03-17T19:08:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3672660,"change_date":"2023-02-02 21:41:00","inspection_id":"77754153","insp_unit_id":"193189429","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"40","insp_unit_license":"21984SM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KKPAVDV8LPMA2191","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:19.000000Z","updated_at":"2025-03-17T22:32:19.000000Z"}]},{"id":2270791,"change_date":"2023-02-01 21:40:00","inspection_id":"77741625","dot_number":"1292030","report_state":"NY","report_number":"0817013904","insp_date":"2023-01-31 00:00:00","insp_start_time":"1010","insp_end_time":"1027","registration_date":null,"region":"ET","ci_status_code":"C","location":"80167","location_desc":"CLARKSTOWN","county_code_state":"NY","county_code":"087","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":"N","pen_cen_match":"I","final_status_date":"2023-02-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13300","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":"2794143","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2023-02-01 21:40:00","snet_input_date":"2023-02-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-01 21:40:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"PO BOX 398","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:30.000000Z","updated_at":"2025-03-17T19:08:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3655478,"change_date":"2023-02-01 21:40:00","inspection_id":"77741625","insp_unit_id":"193166239","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"20832ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDRF3HT7CEB80084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:13.000000Z","updated_at":"2025-03-17T22:32:13.000000Z"}]},{"id":2138193,"change_date":"2023-01-13 21:39:00","inspection_id":"77589985","dot_number":"1292030","report_state":"NY","report_number":"SPG0205553","insp_date":"2023-01-11 00:00:00","insp_start_time":"1436","insp_end_time":"1505","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":"HYDROVAC EXCAVATING","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-01-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"2788591","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":"01292030","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":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","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":[{"id":3308801,"change_date":"2023-01-13 21:39:00","inspection_id":"77589985","insp_violation_id":"250561706","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","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-03-17T21:22:39.000000Z","updated_at":"2025-03-17T21:22:39.000000Z","normalized_code":"39141A1"},{"id":3308802,"change_date":"2023-01-13 21:39:00","inspection_id":"77589985","insp_violation_id":"250561707","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192860844","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4G9PKQ5","created_at":"2025-03-17T21:22:39.000000Z","updated_at":"2025-03-17T21:22:39.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3440734,"change_date":"2023-01-13 21:39:00","inspection_id":"77589985","insp_unit_id":"192860844","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"66382NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDRF3HT4NDA01637","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":2080955,"change_date":"2023-01-06 21:38:00","inspection_id":"77524247","dot_number":"1292030","report_state":"NY","report_number":"SPK0201528","insp_date":"2023-01-05 00:00:00","insp_start_time":"0847","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":"82005","location_desc":"HYDE PARK","county_code_state":"NY","county_code":"027","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"13300","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2785464","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2023-01-06 21:38:00","snet_input_date":"2023-01-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-06 21:38:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"84 RIDGE ROAD","insp_carrier_city":"MONTGOMERY","insp_carrier_state":"NY","insp_carrier_zip_code":"12549","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:05.000000Z","updated_at":"2025-03-17T19:05:05.000000Z","inspection_violations":[{"id":3220839,"change_date":"2023-01-06 21:38:00","inspection_id":"77524247","insp_violation_id":"250419009","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:17.000000Z","updated_at":"2025-03-17T21:22:17.000000Z","normalized_code":"3922"},{"id":3220840,"change_date":"2023-01-06 21:38:00","inspection_id":"77524247","insp_violation_id":"250419010","seq_no":"2","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"192729671","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:22:17.000000Z","updated_at":"2025-03-17T21:22:17.000000Z","normalized_code":"393100B"},{"id":3220841,"change_date":"2023-01-06 21:38:00","inspection_id":"77524247","insp_violation_id":"250419011","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192729671","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:17.000000Z","updated_at":"2025-03-17T21:22:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3348140,"change_date":"2023-01-06 21:38:00","inspection_id":"77524247","insp_unit_id":"192729671","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"20832ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDRF3HT7CEB80084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:58.000000Z","updated_at":"2025-03-17T22:29:58.000000Z"}]},{"id":1980403,"change_date":"2022-12-20 21:40:00","inspection_id":"77409665","dot_number":"1292030","report_state":"NY","report_number":"SPT0333993","insp_date":"2022-12-14 00:00:00","insp_start_time":"1625","insp_end_time":"1644","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":"HYDROVAC EXCAVATING","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-12-20 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":"2781616","transaction_code":"A","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2022-12-20 21:40:00","snet_input_date":"2022-12-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-20 21:40:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"2102 ROUTE 300","insp_carrier_city":"WALLKILL","insp_carrier_state":"NY","insp_carrier_zip_code":"12589","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:16.000000Z","updated_at":"2025-03-17T19:03:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3186123,"change_date":"2022-12-20 21:40:00","inspection_id":"77409665","insp_unit_id":"192500610","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"94345ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT2KDA04426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:49.000000Z","updated_at":"2025-03-17T22:28:49.000000Z"}]},{"id":1557617,"change_date":"2022-10-20 21:40:00","inspection_id":"76924999","dot_number":"1292030","report_state":"NY","report_number":"0811012448","insp_date":"2022-10-19 00:00:00","insp_start_time":"0837","insp_end_time":"0909","registration_date":null,"region":"ET","ci_status_code":"C","location":"80923","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-10-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13300","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2760813","transaction_code":"A","transaction_date":"2022-10-20 00:00:00","upload_date":"2022-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2022-10-20 21:40:00","snet_input_date":"2022-10-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-20 21:40:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"PO BOX 590","insp_carrier_city":"WALLKILL","insp_carrier_state":"NY","insp_carrier_zip_code":"12589","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:15.000000Z","updated_at":"2025-03-17T18:55:15.000000Z","inspection_violations":[{"id":2449391,"change_date":"2022-10-20 21:40:00","inspection_id":"76924999","insp_violation_id":"249138682","seq_no":"1","part_no":"391","part_no_section":"11(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"39111B1"},{"id":2449392,"change_date":"2022-10-20 21:40:00","inspection_id":"76924999","insp_violation_id":"249138683","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191540091","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":2506273,"change_date":"2022-10-20 21:40:00","inspection_id":"76924999","insp_unit_id":"191540091","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"23","insp_unit_license":"20832ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDRF3HT7CEB80084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:11.000000Z","updated_at":"2025-03-17T22:24:11.000000Z"}]},{"id":1482863,"change_date":"2022-10-11 21:41:00","inspection_id":"76838766","dot_number":"1292030","report_state":"NY","report_number":"0816014363","insp_date":"2022-10-07 00:00:00","insp_start_time":"1315","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":"80479","location_desc":"HIGHLAND (SB)","county_code_state":"NY","county_code":"111","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":"N","pen_cen_match":"I","final_status_date":"2022-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2757203","transaction_code":"A","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2022-10-11 21:41:00","snet_input_date":"2022-10-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-11 21:41:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"PO BOX 590","insp_carrier_city":"WALLKILL","insp_carrier_state":"NY","insp_carrier_zip_code":"12589","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:06.000000Z","updated_at":"2025-03-17T18:54:06.000000Z","inspection_violations":[{"id":2333887,"change_date":"2022-10-11 21:41:00","inspection_id":"76838766","insp_violation_id":"248939501","seq_no":"1","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"191363867","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:41.000000Z","updated_at":"2025-03-17T21:17:41.000000Z","normalized_code":"393209D"}],"inspection_per_units":[{"id":2386098,"change_date":"2022-10-11 21:41:00","inspection_id":"76838766","insp_unit_id":"191363867","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"132","insp_unit_license":"94345ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT2KDA04426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:21.000000Z","updated_at":"2025-03-17T22:23:21.000000Z"}]},{"id":993278,"change_date":"2022-08-09 21:40:00","inspection_id":"76269575","dot_number":"1292030","report_state":"NY","report_number":"SPF0165821","insp_date":"2022-08-03 00:00:00","insp_start_time":"1513","insp_end_time":"1528","registration_date":null,"region":"ET","ci_status_code":"C","location":"80569A","location_desc":"NEWBURGH (EXIT 17)","county_code_state":"NY","county_code":"071","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":"2022-08-09 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":"2736507","transaction_code":"A","transaction_date":"2022-08-09 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2022-08-09 21:40:00","snet_input_date":"2022-08-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-09 21:40:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"2102 ROUTE 300","insp_carrier_city":"WALLKILL","insp_carrier_state":"NY","insp_carrier_zip_code":"12589","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:07.000000Z","updated_at":"2025-03-17T18:45:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1598196,"change_date":"2022-08-09 21:40:00","inspection_id":"76269575","insp_unit_id":"190203282","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"49864NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5HT6KEF26792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:04.000000Z","updated_at":"2025-03-17T22:18:04.000000Z"}]},{"id":479289,"change_date":"2022-05-25 21:41:00","inspection_id":"75664542","dot_number":"1292030","report_state":"NY","report_number":"SPF0165563","insp_date":"2022-05-24 00:00:00","insp_start_time":"0845","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"80569A","location_desc":"NEWBURGH (EXIT 17)","county_code_state":"NY","county_code":"071","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":"2022-05-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"76350","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2710744","transaction_code":"A","transaction_date":"2022-05-25 00:00:00","upload_date":"2022-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01292030","upload_search_indicator":"M","census_search_date":"2022-05-25 21:41:00","snet_input_date":"2022-05-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-25 21:41:00","insp_carrier_name":"HYDROVAC EXCAVATING INC","insp_carrier_street":"PO BOX 590","insp_carrier_city":"WALLKILL","insp_carrier_state":"NY","insp_carrier_zip_code":"12589","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:01.000000Z","updated_at":"2025-03-17T18:36:01.000000Z","inspection_violations":[{"id":758350,"change_date":"2022-05-25 21:41:00","inspection_id":"75664542","insp_violation_id":"246059724","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:36.000000Z","updated_at":"2025-03-17T21:10:36.000000Z","normalized_code":"38323A2"},{"id":758351,"change_date":"2022-05-25 21:41:00","inspection_id":"75664542","insp_violation_id":"246059725","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188901592","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:36.000000Z","updated_at":"2025-03-17T21:10:36.000000Z","normalized_code":"3939A"},{"id":758352,"change_date":"2022-05-25 21:41:00","inspection_id":"75664542","insp_violation_id":"246059726","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188901592","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:36.000000Z","updated_at":"2025-03-17T21:10:36.000000Z","normalized_code":"39378"},{"id":758353,"change_date":"2022-05-25 21:41:00","inspection_id":"75664542","insp_violation_id":"246059727","seq_no":"4","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"188901592","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:36.000000Z","updated_at":"2025-03-17T21:10:36.000000Z","normalized_code":"39355D1"},{"id":758354,"change_date":"2022-05-25 21:41:00","inspection_id":"75664542","insp_violation_id":"246059728","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188901592","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:36.000000Z","updated_at":"2025-03-17T21:10:36.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":770768,"change_date":"2022-05-25 21:41:00","inspection_id":"75664542","insp_unit_id":"188901592","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"23688SM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVMG3DVXJHJR3429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:56.000000Z","updated_at":"2025-03-17T22:12:56.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1292030\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1292030\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1292030\/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\/1292030\/inspections","per_page":100,"prev_page_url":null,"to":52,"total":52}