{"current_page":1,"data":[{"id":10275566,"change_date":"2025-12-05 21:42:00","inspection_id":"86400025","dot_number":"1782970","report_state":"NY","report_number":"5L51000021","insp_date":"2025-11-21 00:00:00","insp_start_time":"0737","insp_end_time":"0816","registration_date":"2025-12-04 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"NIAGARA FALLS NY","county_code_state":"NY","county_code":"063","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-24 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"11","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"2581360","transaction_code":"C","transaction_date":"2025-11-24 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01782970","upload_search_indicator":null,"census_search_date":"2025-11-24 21:38:00","snet_input_date":"2025-11-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-24 21:38:00","insp_carrier_name":"MUNICIPAL PIPE CO LLC","insp_carrier_street":"485 KENNEDY RD","insp_carrier_city":"CHEEKTOWAGA","insp_carrier_state":"NY","insp_carrier_zip_code":"14227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-27T10:30:33.000000Z","updated_at":"2025-12-09T10:30:24.000000Z","inspection_violations":[{"id":17340393,"change_date":"2025-12-05 21:42:00","inspection_id":"86400025","insp_violation_id":"270487385","seq_no":"1","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"210436851","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:36.000000Z","updated_at":"2025-12-09T10:30:47.000000Z","normalized_code":"39381H"},{"id":17340394,"change_date":"2025-12-05 21:42:00","inspection_id":"86400025","insp_violation_id":"270487386","seq_no":"2","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"210436851","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:36.000000Z","updated_at":"2025-12-09T10:30:47.000000Z","normalized_code":"3939ALBL"},{"id":17340395,"change_date":"2025-12-05 21:42:00","inspection_id":"86400025","insp_violation_id":"270487387","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"210436851","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:36.000000Z","updated_at":"2025-12-09T10:30:47.000000Z","normalized_code":"39395F"},{"id":17340396,"change_date":"2025-12-05 21:42:00","inspection_id":"86400025","insp_violation_id":"270487388","seq_no":"4","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"210436851","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:36.000000Z","updated_at":"2025-12-09T10:30:47.000000Z","normalized_code":"39021TCMC"},{"id":17340397,"change_date":"2025-12-05 21:42:00","inspection_id":"86400025","insp_violation_id":"270487389","seq_no":"5","part_no":"177","part_no_section":"834A-HMC","insp_viol_unit":"1","insp_unit_id":"210436851","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-08T10:32:36.000000Z","updated_at":"2025-12-09T10:30:47.000000Z","normalized_code":"177834AHMC"},{"id":17340398,"change_date":"2025-12-05 21:42:00","inspection_id":"86400025","insp_violation_id":"270487390","seq_no":"6","part_no":"393","part_no_section":"48A-BSRFSHE","insp_viol_unit":"1","insp_unit_id":"210436851","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:36.000000Z","updated_at":"2025-12-09T10:30:47.000000Z","normalized_code":"39348ABSRFSHE"},{"id":17340399,"change_date":"2025-12-05 21:42:00","inspection_id":"86400025","insp_violation_id":"270487391","seq_no":"7","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:36.000000Z","updated_at":"2025-12-09T10:30:47.000000Z","normalized_code":"3922SLLED"},{"id":17340400,"change_date":"2025-12-05 21:42:00","inspection_id":"86400025","insp_violation_id":"270487392","seq_no":"8","part_no":"392","part_no_section":"8-D","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-12-08T10:32:36.000000Z","updated_at":"2025-12-09T10:30:47.000000Z","normalized_code":"3928D"},{"id":17340401,"change_date":"2025-12-05 21:42:00","inspection_id":"86400025","insp_violation_id":"270487393","seq_no":"9","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210436851","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:36.000000Z","updated_at":"2025-12-09T10:30:47.000000Z","normalized_code":"3922SLLSR"},{"id":17340402,"change_date":"2025-12-05 21:42:00","inspection_id":"86400025","insp_violation_id":"270487394","seq_no":"10","part_no":"393","part_no_section":"201D-FR","insp_viol_unit":"1","insp_unit_id":"210436851","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:36.000000Z","updated_at":"2025-12-09T10:30:47.000000Z","normalized_code":"393201DFR"},{"id":17340403,"change_date":"2025-12-05 21:42:00","inspection_id":"86400025","insp_violation_id":"270487395","seq_no":"11","part_no":"392","part_no_section":"9A-DFSL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"55","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:36.000000Z","updated_at":"2025-12-09T10:30:47.000000Z","normalized_code":"3929ADFSL"}],"inspection_per_units":[{"id":17309799,"change_date":"2025-12-05 21:42:00","inspection_id":"86400025","insp_unit_id":"210436851","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"36555MG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZAARBW31CJ95739","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:01:56.000000Z","updated_at":"2025-12-09T10:00:31.000000Z"}]},{"id":9330401,"change_date":"2025-08-25 21:39:00","inspection_id":"85406261","dot_number":"1782970","report_state":"NY","report_number":"5L47000287","insp_date":"2025-08-04 00:00:00","insp_start_time":"1311","insp_end_time":"1329","registration_date":"2025-08-05 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"LANCASTER NY","county_code_state":"NY","county_code":"029","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-08-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"2086588","transaction_code":"C","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01782970","upload_search_indicator":null,"census_search_date":"2025-08-05 21:38:00","snet_input_date":"2025-08-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-05 21:38:00","insp_carrier_name":"MUNICIPAL PIPE CO LLC","insp_carrier_street":"485 KENNEDY RD","insp_carrier_city":"CHEEKTOWAGA","insp_carrier_state":"NY","insp_carrier_zip_code":"14227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-08T10:01:15.000000Z","updated_at":"2025-08-29T10:42:30.000000Z","inspection_violations":[{"id":15476760,"change_date":"2025-08-25 21:39:00","inspection_id":"85406261","insp_violation_id":"268228247","seq_no":"1","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"208563992","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-28T10:43:44.000000Z","updated_at":"2025-09-05T10:47:40.000000Z","normalized_code":"39395F"},{"id":15476761,"change_date":"2025-08-25 21:39:00","inspection_id":"85406261","insp_violation_id":"268228248","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"208563992","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-28T10:43:44.000000Z","updated_at":"2025-09-05T10:47:40.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":15661076,"change_date":"2025-08-25 21:39:00","inspection_id":"85406261","insp_unit_id":"208563992","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"27","insp_unit_license":"16810NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB3YSE78RF355455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-28T09:45:25.000000Z","updated_at":"2025-08-29T09:45:11.000000Z"}]},{"id":8793947,"change_date":"2025-06-02 21:39:00","inspection_id":"84840316","dot_number":"1782970","report_state":"NY","report_number":"D507901455","insp_date":"2025-06-02 00:00:00","insp_start_time":"1255","insp_end_time":"1307","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LACKAWANNA NY","county_code_state":"NY","county_code":"029","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-06-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1811769","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01782970","upload_search_indicator":null,"census_search_date":"2025-06-02 21:39:00","snet_input_date":"2025-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-02 21:39:00","insp_carrier_name":"MUNICIPAL PIPE CO LLC","insp_carrier_street":"485 KENNEDY RD","insp_carrier_city":"CHEEKTOWAGA","insp_carrier_state":"NY","insp_carrier_zip_code":"14227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-05T10:00:27.000000Z","updated_at":"2025-06-06T10:00:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14390394,"change_date":"2025-06-02 21:39:00","inspection_id":"84840316","insp_unit_id":"207179036","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"98350ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2XKMAD7X05M089947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:25.000000Z","updated_at":"2025-06-06T09:45:43.000000Z"}]},{"id":8801928,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","dot_number":"1782970","report_state":"NY","report_number":"D507005744","insp_date":"2025-06-02 00:00:00","insp_start_time":"1243","insp_end_time":"1312","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LACKAWANNA NY","county_code_state":"NY","county_code":"029","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-06-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"27200","viol_total":"14","oos_total":"5","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1814655","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01782970","upload_search_indicator":null,"census_search_date":"2025-06-03 21:40:00","snet_input_date":"2025-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-03 21:40:00","insp_carrier_name":"MUNICIPAL PIPE CO LLC","insp_carrier_street":"485 KENNEDY RD","insp_carrier_city":"CHEEKTOWAGA","insp_carrier_state":"NY","insp_carrier_zip_code":"14227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-06T10:01:03.000000Z","updated_at":"2025-06-07T10:00:21.000000Z","inspection_violations":[{"id":14079625,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625369","seq_no":"1","part_no":"392","part_no_section":"7A-D","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-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"3927AD"},{"id":14079626,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625370","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207194668","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"3922SLLSR"},{"id":14079627,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625371","seq_no":"3","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"207194669","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"39343DBMA"},{"id":14079628,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625372","seq_no":"4","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"2","insp_unit_id":"207194669","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"3963A1HCM"},{"id":14079629,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625373","seq_no":"5","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"207194668","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"39341BNPB"},{"id":14079630,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625374","seq_no":"6","part_no":"392","part_no_section":"8-D","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-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"3928D"},{"id":14079631,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625375","seq_no":"7","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"2","insp_unit_id":"207194669","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"39311A1LIL"},{"id":14079632,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625376","seq_no":"8","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-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"3922SLLSIV"},{"id":14079633,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625377","seq_no":"14","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"207194669","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"3939ALCL"},{"id":14079634,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625378","seq_no":"9","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"207194668","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"39395A1"},{"id":14079635,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625379","seq_no":"10","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"207194668","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"39395F"},{"id":14079636,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625380","seq_no":"11","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"207194668","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"3939ALRLI"},{"id":14079637,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625381","seq_no":"12","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"1","insp_unit_id":"207194668","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"39343DB"},{"id":14079638,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_violation_id":"266625382","seq_no":"13","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"207194669","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-06T10:16:33.000000Z","updated_at":"2025-06-07T10:17:07.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":14406548,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_unit_id":"207194668","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"24","insp_unit_license":"14219MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB3KYCY2HF238985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:43.000000Z","updated_at":"2025-06-07T09:45:24.000000Z"},{"id":14406549,"change_date":"2025-06-03 21:40:00","inspection_id":"84848647","insp_unit_id":"207194669","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"6","insp_unit_license":"CD16236","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"550FD2221FS007108","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:43.000000Z","updated_at":"2025-06-07T09:45:24.000000Z"}]},{"id":8566305,"change_date":"2025-05-07 21:43:00","inspection_id":"84600162","dot_number":"1782970","report_state":"NY","report_number":"D507101536","insp_date":"2025-05-07 00:00:00","insp_start_time":"1304","insp_end_time":"1329","registration_date":null,"region":"ED","ci_status_code":"C","location":"53035L","location_desc":"NIAGARA FALLS NY","county_code_state":"NY","county_code":"063","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-07 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"1","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":"1695862","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01782970","upload_search_indicator":null,"census_search_date":"2025-05-07 21:43:00","snet_input_date":"2025-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-07 21:43:00","insp_carrier_name":"MUNICIPAL PIPE CO LLC","insp_carrier_street":"485 KENNEDY RD","insp_carrier_city":"CHEEKTOWAGA","insp_carrier_state":"NY","insp_carrier_zip_code":"14227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-10T10:52:22.000000Z","updated_at":"2025-05-11T10:11:44.000000Z","inspection_violations":[{"id":13584747,"change_date":"2025-05-07 21:43:00","inspection_id":"84600162","insp_violation_id":"266051801","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":null,"created_at":"2025-05-09T11:11:36.000000Z","updated_at":"2025-05-10T11:23:18.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":13938323,"change_date":"2025-05-07 21:43:00","inspection_id":"84600162","insp_unit_id":"206679720","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"25","insp_unit_license":"28252NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB3YSEY4RF356286","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-05-10T10:15:44.000000Z","updated_at":"2025-05-11T02:52:26.000000Z"}]},{"id":7591027,"change_date":"2025-01-10 21:39:00","inspection_id":"83574353","dot_number":"1782970","report_state":"NY","report_number":"D507801099","insp_date":"2025-01-10 00:00:00","insp_start_time":"1258","insp_end_time":"1334","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NIAGARA FALLS NY","county_code_state":"NY","county_code":"063","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-01-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"4","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":"1234757","transaction_code":"A","transaction_date":"2025-01-10 00:00:00","upload_date":"2025-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01782970","upload_search_indicator":null,"census_search_date":"2025-01-10 21:39:00","snet_input_date":"2025-01-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-10 21:39:00","insp_carrier_name":"MUNICIPAL PIPE CO LLC","insp_carrier_street":"485 KENNEDY RD","insp_carrier_city":"CHEEKTOWAGA","insp_carrier_state":"NY","insp_carrier_zip_code":"14227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:42.000000Z","updated_at":"2025-03-17T20:55:42.000000Z","inspection_violations":[{"id":11867120,"change_date":"2025-01-10 21:39:00","inspection_id":"83574353","insp_violation_id":"263858405","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204744159","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3922SLLSR"},{"id":11867121,"change_date":"2025-01-10 21:39:00","inspection_id":"83574353","insp_violation_id":"263858406","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"204744159","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3939ALLPL"},{"id":11867122,"change_date":"2025-01-10 21:39:00","inspection_id":"83574353","insp_violation_id":"263858407","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"204744159","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"39021TB2DOT"},{"id":11867123,"change_date":"2025-01-10 21:39:00","inspection_id":"83574353","insp_violation_id":"263858408","seq_no":"4","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"204744159","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":12248401,"change_date":"2025-01-10 21:39:00","inspection_id":"83574353","insp_unit_id":"204744159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"66","insp_unit_license":"58130NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KKHAVDV0GPHK2316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:11.000000Z","updated_at":"2025-03-17T23:50:11.000000Z"}]},{"id":6662415,"change_date":"2024-09-06 21:40:00","inspection_id":"82591623","dot_number":"1782970","report_state":"NY","report_number":"D507800788","insp_date":"2024-09-04 00:00:00","insp_start_time":"1030","insp_end_time":"1105","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NIAGARA FALLS NY","county_code_state":"NY","county_code":"063","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25200","viol_total":"8","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":"819188","transaction_code":"A","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01782970","upload_search_indicator":null,"census_search_date":"2024-09-06 21:40:00","snet_input_date":"2024-09-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-06 21:40:00","insp_carrier_name":"MUNICIPAL PIPE CO LLC","insp_carrier_street":"485 KENNEDY RD","insp_carrier_city":"CHEEKTOWAGA","insp_carrier_state":"NY","insp_carrier_zip_code":"14227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:11.000000Z","updated_at":"2025-03-17T20:35:11.000000Z","inspection_violations":[{"id":10367731,"change_date":"2024-09-06 21:40:00","inspection_id":"82591623","insp_violation_id":"261650387","seq_no":"1","part_no":"393","part_no_section":"95(a)(1)","insp_viol_unit":"1","insp_unit_id":"202790763","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"39395A1"},{"id":10367732,"change_date":"2024-09-06 21:40:00","inspection_id":"82591623","insp_violation_id":"261650388","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"202790763","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"39395F"},{"id":10367733,"change_date":"2024-09-06 21:40:00","inspection_id":"82591623","insp_violation_id":"261650389","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202790763","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3939A"},{"id":10367734,"change_date":"2024-09-06 21:40:00","inspection_id":"82591623","insp_violation_id":"261650390","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202790764","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"39348A"},{"id":10367735,"change_date":"2024-09-06 21:40:00","inspection_id":"82591623","insp_violation_id":"261650391","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202790764","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3939A"},{"id":10367736,"change_date":"2024-09-06 21:40:00","inspection_id":"82591623","insp_violation_id":"261650392","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"202790764","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3963A1"},{"id":10367737,"change_date":"2024-09-06 21:40:00","inspection_id":"82591623","insp_violation_id":"261650393","seq_no":"7","part_no":"392","part_no_section":"7(a)","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:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3927A"},{"id":10367738,"change_date":"2024-09-06 21:40:00","inspection_id":"82591623","insp_violation_id":"261650394","seq_no":"8","part_no":"392","part_no_section":"8","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:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3928"}],"inspection_per_units":[{"id":10741753,"change_date":"2024-09-06 21:40:00","inspection_id":"82591623","insp_unit_id":"202790763","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"WHITE","insp_unit_license":"32491NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB3KYC8XFF593917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:14.000000Z","updated_at":"2025-03-17T23:34:14.000000Z"},{"id":10741754,"change_date":"2024-09-06 21:40:00","inspection_id":"82591623","insp_unit_id":"202790764","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"QUALITY TR","insp_unit_company":"15","insp_unit_license":"CB28703","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"550FD2226KS002884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:14.000000Z","updated_at":"2025-03-17T23:34:14.000000Z"}]},{"id":4180527,"change_date":"2023-10-12 21:41:00","inspection_id":"79893022","dot_number":"1782970","report_state":"NY","report_number":"5L39000580","insp_date":"2023-10-11 00:00:00","insp_start_time":"0952","insp_end_time":"1023","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"RIGA","county_code_state":"NY","county_code":"055","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-10-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2877593","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01782970","upload_search_indicator":"M","census_search_date":"2023-10-12 21:41:00","snet_input_date":"2023-10-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-12 21:41:00","insp_carrier_name":"MUNICIPAL PIPE CO LLC","insp_carrier_street":"485 KENNEDY RD","insp_carrier_city":"CHEEKTOWAGA","insp_carrier_state":"NY","insp_carrier_zip_code":"14227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:48.000000Z","updated_at":"2025-03-17T19:45:48.000000Z","inspection_violations":[{"id":6472444,"change_date":"2023-10-12 21:41:00","inspection_id":"79893022","insp_violation_id":"255792003","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":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"38323A2"},{"id":6472445,"change_date":"2023-10-12 21:41:00","inspection_id":"79893022","insp_violation_id":"255792004","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197516485","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3939A"},{"id":6472446,"change_date":"2023-10-12 21:41:00","inspection_id":"79893022","insp_violation_id":"255792005","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197516485","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"39378"},{"id":6472447,"change_date":"2023-10-12 21:41:00","inspection_id":"79893022","insp_violation_id":"255792006","seq_no":"4","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:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":6722566,"change_date":"2023-10-12 21:41:00","inspection_id":"79893022","insp_unit_id":"197516485","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"31947NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDZW96M3WVA11201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:22.000000Z","updated_at":"2025-03-17T22:56:22.000000Z"}]},{"id":3009764,"change_date":"2023-05-10 21:41:00","inspection_id":"78581554","dot_number":"1782970","report_state":"NY","report_number":"SPWA030765","insp_date":"2023-05-09 00:00:00","insp_start_time":"0836","insp_end_time":"0851","registration_date":null,"region":"ET","ci_status_code":"C","location":"50464","location_desc":"I-190 T\/LEWISTON","county_code_state":"NY","county_code":"063","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-05-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2824033","transaction_code":"A","transaction_date":"2023-05-09 00:00:00","upload_date":"2023-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01782970","upload_search_indicator":null,"census_search_date":"2023-05-10 21:41:00","snet_input_date":"2023-05-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-10 21:41:00","insp_carrier_name":"MUNICIPAL PIPE CO LLC","insp_carrier_street":"485 KENNEDY RD","insp_carrier_city":"CHEEKTOWAGA","insp_carrier_state":"NY","insp_carrier_zip_code":"14227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:37.000000Z","updated_at":"2025-03-17T19:22:37.000000Z","inspection_violations":[{"id":4623380,"change_date":"2023-05-10 21:41:00","inspection_id":"78581554","insp_violation_id":"252739033","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:34.000000Z","updated_at":"2025-03-17T21:28:34.000000Z","normalized_code":"3922"},{"id":4623381,"change_date":"2023-05-10 21:41:00","inspection_id":"78581554","insp_violation_id":"252739034","seq_no":"2","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"194849600","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:34.000000Z","updated_at":"2025-03-17T21:28:34.000000Z","normalized_code":"39021B"},{"id":4623382,"change_date":"2023-05-10 21:41:00","inspection_id":"78581554","insp_violation_id":"252739035","seq_no":"3","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:28:34.000000Z","updated_at":"2025-03-17T21:28:34.000000Z","normalized_code":"39141A"},{"id":4623383,"change_date":"2023-05-10 21:41:00","inspection_id":"78581554","insp_violation_id":"252739036","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194849600","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3GQ8CB8","created_at":"2025-03-17T21:28:34.000000Z","updated_at":"2025-03-17T21:28:34.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4842349,"change_date":"2023-05-10 21:41:00","inspection_id":"78581554","insp_unit_id":"194849600","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"33118NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZAARDU6DCFG1756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:09.000000Z","updated_at":"2025-03-17T22:41:09.000000Z"}]},{"id":1760329,"change_date":"2022-11-17 21:40:00","inspection_id":"77157541","dot_number":"1782970","report_state":"NY","report_number":"SPWA100793","insp_date":"2022-11-15 00:00:00","insp_start_time":"1138","insp_end_time":"1229","registration_date":null,"region":"ET","ci_status_code":"C","location":"50019","location_desc":"MOVED TO OLD FALLS RD","county_code_state":"NY","county_code":"029","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MUNICIPAL PIPE LLC","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-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"27500","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":"2769365","transaction_code":"A","transaction_date":"2022-11-17 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01782970","upload_search_indicator":"M","census_search_date":"2022-11-17 21:40:00","snet_input_date":"2022-11-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-17 21:40:00","insp_carrier_name":"MUNICIPAL PIPE LLC","insp_carrier_street":"485 KENNEDY RD","insp_carrier_city":"CHEEKTOWAGA","insp_carrier_state":"NY","insp_carrier_zip_code":"14227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:15.000000Z","updated_at":"2025-03-17T18:59:15.000000Z","inspection_violations":[{"id":2757232,"change_date":"2022-11-17 21:40:00","inspection_id":"77157541","insp_violation_id":"249652971","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":"0G3LSSJ","created_at":"2025-03-17T21:19:57.000000Z","updated_at":"2025-03-17T21:19:57.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":2831839,"change_date":"2022-11-17 21:40:00","inspection_id":"77157541","insp_unit_id":"192002412","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"32491NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB3KYC8XFF593917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:22.000000Z","updated_at":"2025-03-17T22:26:22.000000Z"},{"id":2831840,"change_date":"2022-11-17 21:40:00","inspection_id":"77157541","insp_unit_id":"192002413","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"QUAL","insp_unit_company":null,"insp_unit_license":"CB28703","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"550FD2226KS002884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:22.000000Z","updated_at":"2025-03-17T22:26:22.000000Z"}]},{"id":902699,"change_date":"2022-07-27 21:40:00","inspection_id":"76163334","dot_number":"1782970","report_state":"NY","report_number":"SPWA070673","insp_date":"2022-07-26 00:00:00","insp_start_time":"1044","insp_end_time":"1059","registration_date":null,"region":"ET","ci_status_code":"C","location":"50152","location_desc":"SR 78  TRANSIT RD CHEEKTOWAGA","county_code_state":"NY","county_code":"029","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"\\","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":"Y","pen_cen_match":null,"final_status_date":"2022-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"17450","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2731613","transaction_code":"A","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01782970","upload_search_indicator":"M","census_search_date":"2022-07-27 21:40:00","snet_input_date":"2022-07-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-27 21:40:00","insp_carrier_name":"MUNICIPAL PIPE LLC","insp_carrier_street":"485 KENNEDY RD","insp_carrier_city":"CHEEKTOWAGA","insp_carrier_state":"NY","insp_carrier_zip_code":"14227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:40.000000Z","updated_at":"2025-03-17T18:43:40.000000Z","inspection_violations":[{"id":1424341,"change_date":"2022-07-27 21:40:00","inspection_id":"76163334","insp_violation_id":"247341124","seq_no":"1","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"189986620","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:45.000000Z","updated_at":"2025-03-17T21:13:45.000000Z","normalized_code":"39021B"},{"id":1424342,"change_date":"2022-07-27 21:40:00","inspection_id":"76163334","insp_violation_id":"247341125","seq_no":"2","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"189986620","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:45.000000Z","updated_at":"2025-03-17T21:13:45.000000Z","normalized_code":"999"},{"id":1424343,"change_date":"2022-07-27 21:40:00","inspection_id":"76163334","insp_violation_id":"247341126","seq_no":"3","part_no":"392","part_no_section":"7(a)","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:13:45.000000Z","updated_at":"2025-03-17T21:13:45.000000Z","normalized_code":"3927A"},{"id":1424344,"change_date":"2022-07-27 21:40:00","inspection_id":"76163334","insp_violation_id":"247341127","seq_no":"4","part_no":"392","part_no_section":"8","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:13:45.000000Z","updated_at":"2025-03-17T21:13:45.000000Z","normalized_code":"3928"}],"inspection_per_units":[{"id":1452936,"change_date":"2022-07-27 21:40:00","inspection_id":"76163334","insp_unit_id":"189986620","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"81107ME","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCHK49K39E138270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:08.000000Z","updated_at":"2025-03-17T22:17:08.000000Z"},{"id":1452937,"change_date":"2022-07-27 21:40:00","inspection_id":"76163334","insp_unit_id":"189986621","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"LEE","insp_unit_company":null,"insp_unit_license":"EQUIPMENT","insp_unit_license_state":"OT","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:08.000000Z","updated_at":"2025-03-17T22:17:08.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1782970\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1782970\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1782970\/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\/1782970\/inspections","per_page":100,"prev_page_url":null,"to":11,"total":11}