{"current_page":1,"data":[{"id":10275484,"change_date":"2025-11-25 21:38:00","inspection_id":"86399942","dot_number":"1142630","report_state":"NY","report_number":"D306001734","insp_date":"2025-11-19 00:00:00","insp_start_time":"1019","insp_end_time":"1054","registration_date":"2025-11-24 00:00:00","region":"ES","ci_status_code":"C","location":"31085","location_desc":"ITHACA NY","county_code_state":"NY","county_code":"109","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"WENZEL","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-24 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2581337","transaction_code":"C","transaction_date":"2025-11-24 00:00:00","upload_date":"2025-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":null,"census_search_date":"2025-11-24 21:38:00","snet_input_date":"2025-11-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-24 21:38:00","insp_carrier_name":"JOHN F AND JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-27T10:30:32.000000Z","updated_at":"2025-11-29T10:30:22.000000Z","inspection_violations":[{"id":17192649,"change_date":"2025-11-25 21:38:00","inspection_id":"86399942","insp_violation_id":"270282437","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210252042","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-28T10:32:34.000000Z","updated_at":"2025-11-29T10:30:25.000000Z","normalized_code":"3922SLLSR"},{"id":17192650,"change_date":"2025-11-25 21:38:00","inspection_id":"86399942","insp_violation_id":"270282438","seq_no":"2","part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"210252042","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-28T10:32:34.000000Z","updated_at":"2025-11-29T10:30:25.000000Z","normalized_code":"39330B"}],"inspection_per_units":[{"id":17167987,"change_date":"2025-11-25 21:38:00","inspection_id":"86399942","insp_unit_id":"210252042","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"3","insp_unit_license":"70606NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB2MS070106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-28T10:01:32.000000Z","updated_at":"2025-11-29T10:00:28.000000Z"}]},{"id":7183025,"change_date":"2024-11-13 21:39:00","inspection_id":"83144869","dot_number":"1142630","report_state":"NY","report_number":"SPD3060168","insp_date":"2024-11-06 00:00:00","insp_start_time":"1240","insp_end_time":"1311","registration_date":null,"region":"ES","ci_status_code":"C","location":"30445S","location_desc":"TULLY NY","county_code_state":"NY","county_code":"067","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"WENZEL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1048195","transaction_code":"A","transaction_date":"2024-11-13 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":null,"census_search_date":"2024-11-13 21:39:00","snet_input_date":"2024-11-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-13 21:39:00","insp_carrier_name":"JOHN F AND JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:59.000000Z","updated_at":"2025-03-17T20:45:59.000000Z","inspection_violations":[{"id":11224763,"change_date":"2024-11-13 21:39:00","inspection_id":"83144869","insp_violation_id":"262868878","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"203858090","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:29.000000Z","updated_at":"2025-03-17T22:00:29.000000Z","normalized_code":"393100BC"},{"id":11224764,"change_date":"2024-11-13 21:39:00","inspection_id":"83144869","insp_violation_id":"262868879","seq_no":"2","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"203858090","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"D310JNMB6T","created_at":"2025-03-17T22:00:29.000000Z","updated_at":"2025-03-17T22:00:29.000000Z","normalized_code":"39311A1LLPL"}],"inspection_per_units":[{"id":11585998,"change_date":"2024-11-13 21:39:00","inspection_id":"83144869","insp_unit_id":"203858090","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"71696NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHCYFE9LHLJ1304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:04.000000Z","updated_at":"2025-03-17T23:43:04.000000Z"}]},{"id":7066815,"change_date":"2024-10-29 21:41:00","inspection_id":"83021650","dot_number":"1142630","report_state":"NY","report_number":"SPE3010154","insp_date":"2024-10-22 00:00:00","insp_start_time":"1442","insp_end_time":"1500","registration_date":null,"region":"ED","ci_status_code":"C","location":"60117M","location_desc":"CAMPBELL NY","county_code_state":"NY","county_code":"101","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-10-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"995286","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":null,"census_search_date":"2024-10-29 21:41:00","snet_input_date":"2024-10-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-29 21:41:00","insp_carrier_name":"JOHN F AND JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:25.000000Z","updated_at":"2025-03-17T20:43:25.000000Z","inspection_violations":[{"id":11031380,"change_date":"2024-10-29 21:41:00","inspection_id":"83021650","insp_violation_id":"262602983","seq_no":"1","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"203627678","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":11397323,"change_date":"2024-10-29 21:41:00","inspection_id":"83021650","insp_unit_id":"203627678","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"99900NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHCYFE0KHKC7446","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:00.000000Z","updated_at":"2025-03-17T23:41:00.000000Z"}]},{"id":7067233,"change_date":"2024-10-29 21:41:00","inspection_id":"83022108","dot_number":"1142630","report_state":"NY","report_number":"SPE3070111","insp_date":"2024-10-22 00:00:00","insp_start_time":"1503","insp_end_time":"1513","registration_date":null,"region":"ED","ci_status_code":"C","location":"60117M","location_desc":"CAMPBELL NY","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"JOHN F JP WENZEL","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-10-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"84000","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":"995749","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":null,"census_search_date":"2024-10-29 21:41:00","snet_input_date":"2024-10-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-29 21:41:00","insp_carrier_name":"JOHN F AND JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:26.000000Z","updated_at":"2025-03-17T20:43:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11397996,"change_date":"2024-10-29 21:41:00","inspection_id":"83022108","insp_unit_id":"203628431","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"55","insp_unit_license":"39196NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2AX04C2BM010623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:01.000000Z","updated_at":"2025-03-17T23:41:01.000000Z"}]},{"id":6917376,"change_date":"2024-10-09 21:40:00","inspection_id":"82862934","dot_number":"1142630","report_state":"NY","report_number":"SPF3020138","insp_date":"2024-10-03 00:00:00","insp_start_time":"0730","insp_end_time":"0750","registration_date":null,"region":"ED","ci_status_code":"C","location":"60585E","location_desc":"NICHOLS NY","county_code_state":"NY","county_code":"107","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-10-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"84000","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":"926704","transaction_code":"A","transaction_date":"2024-10-09 00:00:00","upload_date":"2024-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":null,"census_search_date":"2024-10-09 21:40:00","snet_input_date":"2024-10-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-09 21:40:00","insp_carrier_name":"JOHN F AND JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:16.000000Z","updated_at":"2025-03-17T20:40:16.000000Z","inspection_violations":[{"id":10781139,"change_date":"2024-10-09 21:40:00","inspection_id":"82862934","insp_violation_id":"262256563","seq_no":"1","part_no":"393","part_no_section":"95(a)(4)","insp_viol_unit":"1","insp_unit_id":"203327072","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:15.000000Z","updated_at":"2025-03-17T21:58:15.000000Z","normalized_code":"39395A4"},{"id":10781140,"change_date":"2024-10-09 21:40:00","inspection_id":"82862934","insp_violation_id":"262256564","seq_no":"2","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"203327072","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:15.000000Z","updated_at":"2025-03-17T21:58:15.000000Z","normalized_code":"39311A1"}],"inspection_per_units":[{"id":11156242,"change_date":"2024-10-09 21:40:00","inspection_id":"82862934","insp_unit_id":"203327072","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"39196NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2AX04C2BM010623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:33.000000Z","updated_at":"2025-03-17T23:38:33.000000Z"}]},{"id":6834244,"change_date":"2024-09-27 21:39:00","inspection_id":"82774608","dot_number":"1142630","report_state":"NY","report_number":"D306100503","insp_date":"2024-09-25 00:00:00","insp_start_time":"1112","insp_end_time":"1144","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"VAN ETTEN NY","county_code_state":"NY","county_code":"015","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-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"891030","transaction_code":"A","transaction_date":"2024-09-27 00:00:00","upload_date":"2024-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":null,"census_search_date":"2024-09-27 21:39:00","snet_input_date":"2024-09-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-27 21:39:00","insp_carrier_name":"JOHN F AND JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:37.000000Z","updated_at":"2025-03-17T20:38:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11021181,"change_date":"2024-09-27 21:39:00","inspection_id":"82774608","insp_unit_id":"203158858","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"55","insp_unit_license":"39196NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2AX04C2BM010623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:09.000000Z","updated_at":"2025-03-17T23:37:09.000000Z"}]},{"id":5683163,"change_date":"2024-05-07 21:41:00","inspection_id":"81538432","dot_number":"1142630","report_state":"NY","report_number":"D306100078","insp_date":"2024-05-03 00:00:00","insp_start_time":"0642","insp_end_time":"0704","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BATH NY","county_code_state":"NY","county_code":"101","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":"2024-05-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"458642","transaction_code":"A","transaction_date":"2024-05-07 00:00:00","upload_date":"2024-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":null,"census_search_date":"2024-05-07 21:41:00","snet_input_date":"2024-05-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-07 21:41:00","insp_carrier_name":"JOHN F AND JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:27.000000Z","updated_at":"2025-03-17T20:15:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9153657,"change_date":"2024-05-07 21:41:00","inspection_id":"81538432","insp_unit_id":"200755896","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"48275ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWF36R58EA57742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:10.000000Z","updated_at":"2025-03-17T23:18:10.000000Z"}]},{"id":5675230,"change_date":"2024-05-06 21:43:00","inspection_id":"81529941","dot_number":"1142630","report_state":"NY","report_number":"SPE0330359","insp_date":"2024-04-24 00:00:00","insp_start_time":"1000","insp_end_time":"1053","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354A","location_desc":"CO RT 64 W\/B","county_code_state":"NY","county_code":"015","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":"Y","pen_cen_match":null,"final_status_date":"2024-05-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"210521","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":"2922059","transaction_code":"A","transaction_date":"2024-05-06 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":"M","census_search_date":"2024-05-06 21:43:00","snet_input_date":"2024-05-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-06 21:43:00","insp_carrier_name":"JOHN F AND JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:07.000000Z","updated_at":"2025-03-17T20:15:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9140721,"change_date":"2024-05-06 21:43:00","inspection_id":"81529941","insp_unit_id":"200738758","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETR","insp_unit_company":"23","insp_unit_license":"23639PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPWP4EX7CD142683","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:04.000000Z","updated_at":"2025-03-17T23:18:04.000000Z"},{"id":9140722,"change_date":"2024-05-06 21:43:00","inspection_id":"81529941","insp_unit_id":"200738759","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"23","insp_unit_license":"CF35174","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"40FSK5331B1031273","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:04.000000Z","updated_at":"2025-03-17T23:18:04.000000Z"}]},{"id":4591585,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","dot_number":"1142630","report_state":"PA","report_number":"P509334110","insp_date":"2023-12-07 00:00:00","insp_start_time":"1120","insp_end_time":"1230","registration_date":"2023-12-12 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"ON ROOSEVELT HWY 1756 FEET NOR","county_code_state":"PA","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"WENZEL CONTRACTORS 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":"2023-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19900","viol_total":"12","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2404162","transaction_code":"C","transaction_date":"2023-12-07 00:00:00","upload_date":"2023-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":null,"census_search_date":"2023-12-08 21:41:00","snet_input_date":"2023-12-07 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-12-08 21:41:00","insp_carrier_name":"JOHN F AND JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:48.000000Z","updated_at":"2025-03-17T19:53:48.000000Z","inspection_violations":[{"id":7101094,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_violation_id":"256849277","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"198472990","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0503155-2","created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"39021TB"},{"id":7101095,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_violation_id":"256849278","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198472990","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0503156-3","created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"39617C"},{"id":7101096,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_violation_id":"256849279","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198472990","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0503157-4","created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"39395A"},{"id":7101097,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_violation_id":"256849280","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"198472990","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0503158-5","created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"39395F"},{"id":7101098,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_violation_id":"256849281","seq_no":"5","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"198472990","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0503159-6","created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"39360D"},{"id":7101099,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_violation_id":"256849282","seq_no":"6","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":"TA0503160-0","created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"39141A1"},{"id":7101100,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_violation_id":"256849283","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198472991","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0503161-1","created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"3922"},{"id":7101101,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_violation_id":"256849284","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198472991","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0503162-2","created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"39617C"},{"id":7101102,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_violation_id":"256849285","seq_no":"9","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"198472991","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"TA0503163-3","created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"39343"},{"id":7101103,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_violation_id":"256849286","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198472991","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0503164-4","created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"3939A"},{"id":7101104,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_violation_id":"256849287","seq_no":"11","part_no":"393","part_no_section":"130(b)","insp_viol_unit":"2","insp_unit_id":"198472991","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"TA0503165-5","created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"393130B"},{"id":7101105,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_violation_id":"256849288","seq_no":"12","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198472991","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"TA0503166-6","created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":7385096,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_unit_id":"198472990","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"83832MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GC1KVEY9JF245727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:05.000000Z","updated_at":"2025-03-17T23:02:05.000000Z"},{"id":7385097,"change_date":"2023-12-12 21:42:00","inspection_id":"80346659","insp_unit_id":"198472991","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SURT","insp_unit_company":null,"insp_unit_license":"CA15127","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW1D122XM4307259","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:05.000000Z","updated_at":"2025-03-17T23:02:05.000000Z"}]},{"id":3970724,"change_date":"2023-09-14 21:40:00","inspection_id":"79660219","dot_number":"1142630","report_state":"NY","report_number":"0326001441","insp_date":"2023-09-13 00:00:00","insp_start_time":"0916","insp_end_time":"0949","registration_date":null,"region":"ET","ci_status_code":"C","location":"32021","location_desc":"ITHACA CEMETARY","county_code_state":"NY","county_code":"109","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"DANDY","shipping_paper_number":"708264","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-09-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2868277","transaction_code":"A","transaction_date":"2023-09-14 00:00:00","upload_date":"2023-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":"M","census_search_date":"2023-09-14 21:40:00","snet_input_date":"2023-09-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-14 21:40:00","insp_carrier_name":"JOHN F & JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:13.000000Z","updated_at":"2025-03-17T19:41:13.000000Z","inspection_violations":[{"id":6141419,"change_date":"2023-09-14 21:40:00","inspection_id":"79660219","insp_violation_id":"255260733","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"197047958","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:42.000000Z","updated_at":"2025-03-17T21:35:42.000000Z","normalized_code":"39348A"},{"id":6141420,"change_date":"2023-09-14 21:40:00","inspection_id":"79660219","insp_violation_id":"255260734","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197047958","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:42.000000Z","updated_at":"2025-03-17T21:35:42.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":6384607,"change_date":"2023-09-14 21:40:00","inspection_id":"79660219","insp_unit_id":"197047958","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"55","insp_unit_license":"39196NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2AX04C2BM010623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:36.000000Z","updated_at":"2025-03-17T22:53:36.000000Z"}]},{"id":4000055,"change_date":"2023-09-19 21:39:00","inspection_id":"79692699","dot_number":"1142630","report_state":"NY","report_number":"SPC0159322","insp_date":"2023-09-13 00:00:00","insp_start_time":"1418","insp_end_time":"1449","registration_date":null,"region":"ET","ci_status_code":"C","location":"32021","location_desc":"STATE ROUTE 13 S\/B C\/ITHACA","county_code_state":"NY","county_code":"109","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"WENZEL","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-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2869574","transaction_code":"A","transaction_date":"2023-09-19 00:00:00","upload_date":"2023-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":"M","census_search_date":"2023-09-19 21:39:00","snet_input_date":"2023-09-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-19 21:39:00","insp_carrier_name":"JOHN F & JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:58.000000Z","updated_at":"2025-03-17T19:41:58.000000Z","inspection_violations":[{"id":6188642,"change_date":"2023-09-19 21:39:00","inspection_id":"79692699","insp_violation_id":"255339960","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197115277","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:53.000000Z","updated_at":"2025-03-17T21:35:53.000000Z","normalized_code":"3922"},{"id":6188643,"change_date":"2023-09-19 21:39:00","inspection_id":"79692699","insp_violation_id":"255339961","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197115277","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:53.000000Z","updated_at":"2025-03-17T21:35:53.000000Z","normalized_code":"3922"},{"id":6188644,"change_date":"2023-09-19 21:39:00","inspection_id":"79692699","insp_violation_id":"255339962","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197115277","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:53.000000Z","updated_at":"2025-03-17T21:35:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6431879,"change_date":"2023-09-19 21:39:00","inspection_id":"79692699","insp_unit_id":"197115277","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PKR5576","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FVHCYD29KHKU0063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:00.000000Z","updated_at":"2025-03-17T22:54:00.000000Z"}]},{"id":3854492,"change_date":"2023-08-29 21:41:00","inspection_id":"79530825","dot_number":"1142630","report_state":"NY","report_number":"SPE0330049","insp_date":"2023-08-03 00:00:00","insp_start_time":"1058","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":"E0850","location_desc":"COLLEGE AVE","county_code_state":"NY","county_code":"015","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-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"2863571","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":"M","census_search_date":"2023-08-29 21:41:00","snet_input_date":"2023-08-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-29 21:41:00","insp_carrier_name":"JOHN F & JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:57.000000Z","updated_at":"2025-03-17T19:38:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6197023,"change_date":"2023-08-29 21:41:00","inspection_id":"79530825","insp_unit_id":"196778860","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PKR5576","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FVHCYD29KHKU0063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:04.000000Z","updated_at":"2025-03-17T22:52:04.000000Z"}]},{"id":2939925,"change_date":"2023-05-02 21:40:00","inspection_id":"78502580","dot_number":"1142630","report_state":"NY","report_number":"SPWE031014","insp_date":"2023-03-01 00:00:00","insp_start_time":"1510","insp_end_time":"1525","registration_date":null,"region":"ET","ci_status_code":"C","location":"60117A","location_desc":"CAMPBELL (EB)","county_code_state":"NY","county_code":"101","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-05-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2821086","transaction_code":"A","transaction_date":"2023-05-02 00:00:00","upload_date":"2023-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":"M","census_search_date":"2023-05-02 21:40:00","snet_input_date":"2023-05-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-02 21:40:00","insp_carrier_name":"JOHN F & JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:58.000000Z","updated_at":"2025-03-17T19:20:58.000000Z","inspection_violations":[{"id":4514726,"change_date":"2023-05-02 21:40:00","inspection_id":"78502580","insp_violation_id":"252560350","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:28:01.000000Z","updated_at":"2025-03-17T21:28:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4730163,"change_date":"2023-05-02 21:40:00","inspection_id":"78502580","insp_unit_id":"194692722","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"35477MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C63RRGL5KG727017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:18.000000Z","updated_at":"2025-03-17T22:40:18.000000Z"}]},{"id":1857564,"change_date":"2022-12-02 21:40:00","inspection_id":"77268967","dot_number":"1142630","report_state":"NY","report_number":"SPC0158612","insp_date":"2022-12-01 00:00:00","insp_start_time":"0740","insp_end_time":"0809","registration_date":null,"region":"ET","ci_status_code":"C","location":"60585A","location_desc":"NICHOLS (EB)","county_code_state":"NY","county_code":"107","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"WENZEL","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-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2776010","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":"M","census_search_date":"2022-12-02 21:40:00","snet_input_date":"2022-12-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-02 21:40:00","insp_carrier_name":"JOHN F & JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:47.000000Z","updated_at":"2025-03-17T19:00:47.000000Z","inspection_violations":[{"id":2894802,"change_date":"2022-12-02 21:40:00","inspection_id":"77268967","insp_violation_id":"249884669","seq_no":"1","part_no":"383","part_no_section":"71(h)","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:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"38371H"},{"id":2894803,"change_date":"2022-12-02 21:40:00","inspection_id":"77268967","insp_violation_id":"249884670","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192226177","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4G59FNB","created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"39395A"},{"id":2894804,"change_date":"2022-12-02 21:40:00","inspection_id":"77268967","insp_violation_id":"249884671","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"192226177","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4G59G77","created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"39395F"},{"id":2894805,"change_date":"2022-12-02 21:40:00","inspection_id":"77268967","insp_violation_id":"249884672","seq_no":"4","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"192226177","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":2988911,"change_date":"2022-12-02 21:40:00","inspection_id":"77268967","insp_unit_id":"192226177","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"48275ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWF36R58EA57742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:27.000000Z","updated_at":"2025-03-17T22:27:27.000000Z"}]},{"id":1443633,"change_date":"2022-10-05 21:40:00","inspection_id":"76793023","dot_number":"1142630","report_state":"NY","report_number":"SPWE100753","insp_date":"2022-10-04 00:00:00","insp_start_time":"1020","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":"60117A","location_desc":"CAMPBELL (EB)","county_code_state":"NY","county_code":"101","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"WENZEL","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-10-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"210520","viol_total":"2","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2755874","transaction_code":"A","transaction_date":"2022-10-05 00:00:00","upload_date":"2022-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01142630","upload_search_indicator":"M","census_search_date":"2022-10-05 21:40:00","snet_input_date":"2022-10-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-05 21:40:00","insp_carrier_name":"JOHN F & JOHN P WENZEL CONTRACTORS INC","insp_carrier_street":"170 PRESCOTT AVE","insp_carrier_city":"ELMIRA HEIGHTS","insp_carrier_state":"NY","insp_carrier_zip_code":"14903","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:23.000000Z","updated_at":"2025-03-17T18:53:23.000000Z","inspection_violations":[{"id":2274058,"change_date":"2022-10-05 21:40:00","inspection_id":"76793023","insp_violation_id":"248837660","seq_no":"1","part_no":"391","part_no_section":"49(j)","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:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"39149J"},{"id":2274059,"change_date":"2022-10-05 21:40:00","inspection_id":"76793023","insp_violation_id":"248837661","seq_no":"2","part_no":"383","part_no_section":"91(a)","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:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"38391A"}],"inspection_per_units":[{"id":2323827,"change_date":"2022-10-05 21:40:00","inspection_id":"76793023","insp_unit_id":"191274208","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"23","insp_unit_license":"16948PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPWP4EX7CD142683","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:54.000000Z","updated_at":"2025-03-17T22:22:54.000000Z"},{"id":2323828,"change_date":"2022-10-05 21:40:00","inspection_id":"76793023","insp_unit_id":"191274209","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"14","insp_unit_license":"CB85251","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"40FSK5331B1031273","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:54.000000Z","updated_at":"2025-03-17T22:22:54.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1142630\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1142630\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1142630\/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\/1142630\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}