{"current_page":1,"data":[{"id":11800522,"change_date":"2026-05-01 21:40:00","inspection_id":"87733487","dot_number":"111374","report_state":"NY","report_number":"D507501704","insp_date":"2026-04-29 00:00:00","insp_start_time":"1006","insp_end_time":"1028","registration_date":null,"region":"ED","ci_status_code":"C","location":"40714E","location_desc":"CHURCHVILLE NY","county_code_state":"NY","county_code":"055","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":"2026-05-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3241837","transaction_code":"A","transaction_date":"2026-05-01 00:00:00","upload_date":"2026-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2026-05-01 21:40:00","snet_input_date":"2026-04-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-01 21:40:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-04T09:41:16.000000Z","updated_at":"2026-05-12T09:30:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20526705,"change_date":"2026-05-01 21:40:00","inspection_id":"87733487","insp_unit_id":"213329380","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"FR20R","insp_unit_license":"71881NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-04T09:19:50.000000Z","updated_at":"2026-05-12T09:02:20.000000Z"}]},{"id":11705315,"change_date":"2026-04-21 21:38:00","inspection_id":"87631950","dot_number":"111374","report_state":"NY","report_number":"SPE3011328","insp_date":"2026-04-14 00:00:00","insp_start_time":"1356","insp_end_time":"1412","registration_date":null,"region":"ED","ci_status_code":"C","location":"50361M","location_desc":"HAMBURG NY","county_code_state":"NY","county_code":"029","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":"2026-04-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3187091","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2026-04-21 21:38:00","snet_input_date":"2026-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-21 21:38:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:37:17.000000Z","updated_at":"2026-05-02T09:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20370144,"change_date":"2026-04-21 21:38:00","inspection_id":"87631950","insp_unit_id":"213129893","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"IT13B2","insp_unit_license":"81059MA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN2DH148277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:13:21.000000Z","updated_at":"2026-05-02T09:02:27.000000Z"}]},{"id":11293446,"change_date":"2026-03-05 21:39:00","inspection_id":"87208801","dot_number":"111374","report_state":"NY","report_number":"SPE3051286","insp_date":"2026-02-26 00:00:00","insp_start_time":"1047","insp_end_time":"1102","registration_date":null,"region":"ES","ci_status_code":"C","location":"40857W","location_desc":"VICTOR NY","county_code_state":"NY","county_code":"069","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COMMERCIAL PIPE & SUPPLY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2963834","transaction_code":"A","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2026-03-05 21:39:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-05 21:39:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-08T09:44:02.000000Z","updated_at":"2026-03-16T09:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19316230,"change_date":"2026-03-05 21:39:00","inspection_id":"87208801","insp_unit_id":"211977922","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"FR20R","insp_unit_license":"71881NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-08T09:25:09.000000Z","updated_at":"2026-03-16T09:02:14.000000Z"}]},{"id":11213440,"change_date":"2026-02-24 21:39:00","inspection_id":"87124795","dot_number":"111374","report_state":"NY","report_number":"SPA3021377","insp_date":"2026-02-17 00:00:00","insp_start_time":"0936","insp_end_time":"0950","registration_date":"2026-02-23 00:00:00","region":"ES","ci_status_code":"C","location":"40647R","location_desc":"CORFU NY","county_code_state":"NY","county_code":"037","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COMMERCIAL PIPE & SUPPLY CORP","shipping_paper_number":"870150","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2924577","transaction_code":"A","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2026-02-24 21:39:00","snet_input_date":"2026-02-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-24 21:39:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-27T10:37:42.000000Z","updated_at":"2026-03-07T10:30:19.000000Z","inspection_violations":[{"id":18805643,"change_date":"2026-02-24 21:39:00","inspection_id":"87124795","insp_violation_id":"271980204","seq_no":"1","part_no":"393","part_no_section":"110C-C","insp_viol_unit":"1","insp_unit_id":"211784304","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-02-27T10:53:40.000000Z","updated_at":"2026-03-07T10:39:55.000000Z","normalized_code":"393110CC"}],"inspection_per_units":[{"id":19148946,"change_date":"2026-02-24 21:39:00","inspection_id":"87124795","insp_unit_id":"211784304","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"IT17","insp_unit_license":"35479PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMN3HH658057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-27T10:13:16.000000Z","updated_at":"2026-03-07T10:02:49.000000Z"}]},{"id":10777053,"change_date":"2026-01-15 21:41:00","inspection_id":"86802564","dot_number":"111374","report_state":"NY","report_number":"D507501453","insp_date":"2026-01-12 00:00:00","insp_start_time":"1339","insp_end_time":"1357","registration_date":null,"region":"ES","ci_status_code":"C","location":"50011M","location_desc":"ALLEGANY NY","county_code_state":"NY","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2770794","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2026-01-15 21:41:00","snet_input_date":"2026-01-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-18T10:45:05.000000Z","updated_at":"2026-01-26T10:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18093230,"change_date":"2026-01-15 21:41:00","inspection_id":"86802564","insp_unit_id":"211107209","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1T-13","insp_unit_license":"21568PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HSHXSJR2DH465871","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:16:54.000000Z","updated_at":"2026-01-26T10:00:49.000000Z"},{"id":18093231,"change_date":"2026-01-15 21:41:00","inspection_id":"86802564","insp_unit_id":"211107210","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"2858D8","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC21262XBP011995","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:16:54.000000Z","updated_at":"2026-01-26T10:00:49.000000Z"}]},{"id":10213384,"change_date":"2025-12-02 21:38:00","inspection_id":"86334788","dot_number":"111374","report_state":"NY","report_number":"SPA3080949","insp_date":"2025-11-10 00:00:00","insp_start_time":"1047","insp_end_time":"1104","registration_date":"2025-12-01 00:00:00","region":"ES","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":"COMMERCIAL PIPE & SUPPLY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2550020","transaction_code":"C","transaction_date":"2025-11-16 00:00:00","upload_date":"2025-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2025-11-17 21:39:00","snet_input_date":"2025-11-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-17 21:39:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-20T10:30:27.000000Z","updated_at":"2025-12-06T10:30:07.000000Z","inspection_violations":[{"id":17275375,"change_date":"2025-12-02 21:38:00","inspection_id":"86334788","insp_violation_id":"270385543","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8A26KZZTJB","created_at":"2025-12-05T10:33:05.000000Z","updated_at":"2025-12-06T10:30:15.000000Z","normalized_code":"39216D"},{"id":17275376,"change_date":"2025-12-02 21:38:00","inspection_id":"86334788","insp_violation_id":"270385544","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"210348879","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:05.000000Z","updated_at":"2025-12-06T10:30:15.000000Z","normalized_code":"3922SLLIFTA"},{"id":17275377,"change_date":"2025-12-02 21:38:00","inspection_id":"86334788","insp_violation_id":"270385545","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"210348879","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:05.000000Z","updated_at":"2025-12-06T10:30:15.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":17248435,"change_date":"2025-12-02 21:38:00","inspection_id":"86334788","insp_unit_id":"210348879","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"38607PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB7RS074756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:02:46.000000Z","updated_at":"2025-12-06T10:00:09.000000Z"}]},{"id":10104250,"change_date":"2025-12-02 21:38:00","inspection_id":"86219995","dot_number":"111374","report_state":"NY","report_number":"D507005986","insp_date":"2025-11-03 00:00:00","insp_start_time":"0910","insp_end_time":"0927","registration_date":"2025-12-01 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"CHEEKTOWAGA 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-11-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2495495","transaction_code":"C","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2025-11-03 21:39:00","snet_input_date":"2025-11-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-03 21:39:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-06T10:30:39.000000Z","updated_at":"2025-12-06T10:30:05.000000Z","inspection_violations":[{"id":17274482,"change_date":"2025-12-02 21:38:00","inspection_id":"86219995","insp_violation_id":"270385858","seq_no":"1","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-05T10:33:03.000000Z","updated_at":"2025-12-06T10:30:09.000000Z","normalized_code":"3928D"},{"id":17274483,"change_date":"2025-12-02 21:38:00","inspection_id":"86219995","insp_violation_id":"270385859","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"210349128","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:03.000000Z","updated_at":"2025-12-06T10:30:09.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":17248002,"change_date":"2025-12-02 21:38:00","inspection_id":"86219995","insp_unit_id":"210349128","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"IT13B2","insp_unit_license":"81059MA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN2DH148277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:02:46.000000Z","updated_at":"2025-12-06T10:00:08.000000Z"}]},{"id":9898126,"change_date":"2025-11-10 21:38:00","inspection_id":"86002440","dot_number":"111374","report_state":"NY","report_number":"D507901770","insp_date":"2025-10-09 00:00:00","insp_start_time":"0907","insp_end_time":"0930","registration_date":"2025-11-07 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"LACKAWANNA 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-10-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132350","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2388590","transaction_code":"C","transaction_date":"2025-10-09 00:00:00","upload_date":"2025-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2025-10-09 21:40:00","snet_input_date":"2025-10-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-09 21:40:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-12T10:01:55.000000Z","updated_at":"2025-11-14T10:30:04.000000Z","inspection_violations":[{"id":16861313,"change_date":"2025-11-10 21:38:00","inspection_id":"86002440","insp_violation_id":"269840885","seq_no":"1","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-11-13T10:30:40.000000Z","updated_at":"2025-11-14T10:30:09.000000Z","normalized_code":"3929ADFSL"},{"id":16861314,"change_date":"2025-11-10 21:38:00","inspection_id":"86002440","insp_violation_id":"269840886","seq_no":"2","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"1","insp_unit_id":"209933003","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-13T10:30:40.000000Z","updated_at":"2025-11-14T10:30:09.000000Z","normalized_code":"39348ABMBCBD"},{"id":16861315,"change_date":"2025-11-10 21:38:00","inspection_id":"86002440","insp_violation_id":"269840887","seq_no":"3","part_no":"393","part_no_section":"110B3-C","insp_viol_unit":"2","insp_unit_id":"209933004","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LA28KVK757","created_at":"2025-11-13T10:30:40.000000Z","updated_at":"2025-11-14T10:30:09.000000Z","normalized_code":"393110B3C"},{"id":16861316,"change_date":"2025-11-10 21:38:00","inspection_id":"86002440","insp_violation_id":"269840888","seq_no":"4","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"2","insp_unit_id":"209933004","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-13T10:30:40.000000Z","updated_at":"2025-11-14T10:30:09.000000Z","normalized_code":"393104F3C"},{"id":16861317,"change_date":"2025-11-10 21:38:00","inspection_id":"86002440","insp_violation_id":"269840889","seq_no":"5","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"209933004","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LA28KVK895","created_at":"2025-11-13T10:30:40.000000Z","updated_at":"2025-11-14T10:30:09.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":16913050,"change_date":"2025-11-10 21:38:00","inspection_id":"86002440","insp_unit_id":"209933003","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"21568PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HSHXSJR2DH465871","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:30.000000Z","updated_at":"2025-11-14T10:00:06.000000Z"},{"id":16913051,"change_date":"2025-11-10 21:38:00","inspection_id":"86002440","insp_unit_id":"209933004","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"4577D9","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC214825CK013810","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:30.000000Z","updated_at":"2025-11-14T10:00:06.000000Z"}]},{"id":9894690,"change_date":"2025-11-04 21:39:00","inspection_id":"85998791","dot_number":"111374","report_state":"NY","report_number":"SPT3081042","insp_date":"2025-10-02 00:00:00","insp_start_time":"0902","insp_end_time":"0956","registration_date":"2025-11-03 00:00:00","region":"ED","ci_status_code":"C","location":"40504M","location_desc":"MANCHESTER NY","county_code_state":"NY","county_code":"069","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"FULTON THERMAL CORPORATION","shipping_paper_number":"863409","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-10-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"128280","viol_total":"3","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":"2385617","transaction_code":"C","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2025-10-09 21:40:00","snet_input_date":"2025-10-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-09 21:40:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-12T10:01:50.000000Z","updated_at":"2025-11-08T10:30:07.000000Z","inspection_violations":[{"id":16759726,"change_date":"2025-11-04 21:39:00","inspection_id":"85998791","insp_violation_id":"269707278","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"209817071","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:16.000000Z","updated_at":"2025-11-08T10:30:15.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":16759727,"change_date":"2025-11-04 21:39:00","inspection_id":"85998791","insp_violation_id":"269707279","seq_no":"2","part_no":"392","part_no_section":"9BA-INACTIVE","insp_viol_unit":"1","insp_unit_id":"209817071","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-07T10:31:16.000000Z","updated_at":"2025-11-08T10:30:15.000000Z","normalized_code":"3929BAINACTIVE"},{"id":16759728,"change_date":"2025-11-04 21:39:00","inspection_id":"85998791","insp_violation_id":"269707280","seq_no":"3","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"209817072","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:16.000000Z","updated_at":"2025-11-08T10:30:15.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":16817930,"change_date":"2025-11-04 21:39:00","inspection_id":"85998791","insp_unit_id":"209817072","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANAC","insp_unit_company":null,"insp_unit_license":"2858D8","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC21262XBP011995","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:26.000000Z","updated_at":"2025-11-08T10:00:11.000000Z"},{"id":16817929,"change_date":"2025-11-04 21:39:00","inspection_id":"85998791","insp_unit_id":"209817071","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"FR20B","insp_unit_license":"45403PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJHLDV5LSMD3197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:26.000000Z","updated_at":"2025-11-08T10:00:11.000000Z"}]},{"id":9517503,"change_date":"2025-10-29 21:39:00","inspection_id":"85603036","dot_number":"111374","report_state":"NY","report_number":"SPA3090205","insp_date":"2025-08-20 00:00:00","insp_start_time":"0955","insp_end_time":"1032","registration_date":"2025-10-28 00:00:00","region":"ED","ci_status_code":"C","location":"50011M","location_desc":"ALLEGANY NY","county_code_state":"NY","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"COMMERCIAL PIPE AND SUPPLY","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2182649","transaction_code":"C","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2025-08-27 21:39:00","snet_input_date":"2025-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-27 21:39:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-05T10:47:08.000000Z","updated_at":"2025-11-02T11:00:07.000000Z","inspection_violations":[{"id":16655798,"change_date":"2025-10-29 21:39:00","inspection_id":"85603036","insp_violation_id":"269578832","seq_no":"1","part_no":"392","part_no_section":"9BA-INACTIVE","insp_viol_unit":"1","insp_unit_id":"209705551","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-01T10:17:33.000000Z","updated_at":"2025-11-02T11:15:06.000000Z","normalized_code":"3929BAINACTIVE"},{"id":16655799,"change_date":"2025-10-29 21:39:00","inspection_id":"85603036","insp_violation_id":"269578833","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"209705551","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-01T10:17:33.000000Z","updated_at":"2025-11-02T11:15:06.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":16719572,"change_date":"2025-10-29 21:39:00","inspection_id":"85603036","insp_unit_id":"209705551","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"SST24B","insp_unit_license":"24038NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT5REE76964","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:46:55.000000Z","updated_at":"2025-11-02T10:45:08.000000Z"}]},{"id":9313588,"change_date":"2025-12-05 21:42:00","inspection_id":"85388626","dot_number":"111374","report_state":"NY","report_number":"D507501178","insp_date":"2025-07-31 00:00:00","insp_start_time":"1343","insp_end_time":"1357","registration_date":"2025-10-24 00:00:00","region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-02 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2076731","transaction_code":"C","transaction_date":"2025-08-02 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2025-08-02 21:33:00","snet_input_date":"2025-07-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-02 21:33:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-06T10:43:39.000000Z","updated_at":"2025-12-09T10:30:14.000000Z","inspection_violations":[{"id":17336606,"change_date":"2025-12-05 21:42:00","inspection_id":"85388626","insp_violation_id":"270488345","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"210437522","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:28.000000Z","updated_at":"2025-12-09T10:30:23.000000Z","normalized_code":"39019B2BIENNIAL"}],"inspection_per_units":[{"id":17307511,"change_date":"2025-12-05 21:42:00","inspection_id":"85388626","insp_unit_id":"210437522","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"FR20R","insp_unit_license":"14064ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:01:51.000000Z","updated_at":"2025-12-09T10:00:18.000000Z"}]},{"id":8576507,"change_date":"2025-05-08 21:40:00","inspection_id":"84610818","dot_number":"111374","report_state":"NY","report_number":"SPE3010551","insp_date":"2025-05-01 00:00:00","insp_start_time":"1310","insp_end_time":"1326","registration_date":null,"region":"ED","ci_status_code":"C","location":"40504M","location_desc":"MANCHESTER NY","county_code_state":"NY","county_code":"069","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1699484","transaction_code":"A","transaction_date":"2025-05-08 00:00:00","upload_date":"2025-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2025-05-08 21:40:00","snet_input_date":"2025-05-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-08 21:40:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-11T10:21:03.000000Z","updated_at":"2025-05-12T10:02:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13997931,"change_date":"2025-05-08 21:40:00","inspection_id":"84610818","insp_unit_id":"206752176","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"FR20R","insp_unit_license":"14064ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-11T03:54:02.000000Z","updated_at":"2025-05-12T09:49:16.000000Z"}]},{"id":8207306,"change_date":"2025-03-26 21:40:00","inspection_id":"84222505","dot_number":"111374","report_state":"NY","report_number":"D507901237","insp_date":"2025-03-19 00:00:00","insp_start_time":"0942","insp_end_time":"1004","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":"2025-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1513579","transaction_code":"A","transaction_date":"2025-03-26 00:00:00","upload_date":"2025-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2025-03-26 21:40:00","snet_input_date":"2025-03-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-26 21:40:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-29T10:20:59.000000Z","updated_at":"2025-03-30T10:34:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13271410,"change_date":"2025-03-26 21:40:00","inspection_id":"84222505","insp_unit_id":"205984022","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"41378PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMN9HH473690","insp_unit_decal":"Y","insp_unit_decal_number":"34947043","created_at":"2025-03-29T10:02:41.000000Z","updated_at":"2025-03-30T09:56:17.000000Z"}]},{"id":7990105,"change_date":"2025-02-28 21:41:00","inspection_id":"83993355","dot_number":"111374","report_state":"NY","report_number":"D306100986","insp_date":"2025-02-24 00:00:00","insp_start_time":"1351","insp_end_time":"1413","registration_date":null,"region":"ES","ci_status_code":"C","location":"60056M","location_desc":"BATH 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":"2025-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1413788","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2025-02-28 21:41:00","snet_input_date":"2025-02-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-28 21:41:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:05.000000Z","updated_at":"2025-03-17T21:04:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12899226,"change_date":"2025-02-28 21:41:00","inspection_id":"83993355","insp_unit_id":"205556871","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"FR20R","insp_unit_license":"14064ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:28.000000Z","updated_at":"2025-03-17T23:57:28.000000Z"}]},{"id":7858590,"change_date":"2025-02-13 21:40:00","inspection_id":"83855475","dot_number":"111374","report_state":"NY","report_number":"SPE4030036","insp_date":"2025-02-06 00:00:00","insp_start_time":"1055","insp_end_time":"1111","registration_date":null,"region":"ES","ci_status_code":"C","location":"60117T","location_desc":"CAMPBELL NY","county_code_state":"NY","county_code":"101","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COMMERCIAL  PIPE AND SUPPLY CORP","shipping_paper_number":"849549","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1355850","transaction_code":"A","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2025-02-13 21:40:00","snet_input_date":"2025-02-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-13 21:40:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:14.000000Z","updated_at":"2025-03-17T21:01:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12683655,"change_date":"2025-02-13 21:40:00","inspection_id":"83855475","insp_unit_id":"205301952","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"FR20R","insp_unit_license":"14064ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:05.000000Z","updated_at":"2025-03-17T23:55:05.000000Z"}]},{"id":7858717,"change_date":"2025-02-13 21:40:00","inspection_id":"83855607","dot_number":"111374","report_state":"NY","report_number":"SPA3080377","insp_date":"2025-02-06 00:00:00","insp_start_time":"1242","insp_end_time":"1257","registration_date":null,"region":"ES","ci_status_code":"C","location":"60056M","location_desc":"BATH 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":"2025-02-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1355870","transaction_code":"A","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2025-02-13 21:40:00","snet_input_date":"2025-02-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-13 21:40:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:14.000000Z","updated_at":"2025-03-17T21:01:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12683857,"change_date":"2025-02-13 21:40:00","inspection_id":"83855607","insp_unit_id":"205302170","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"14064ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:05.000000Z","updated_at":"2025-03-17T23:55:05.000000Z"}]},{"id":7459327,"change_date":"2024-12-19 21:40:00","inspection_id":"83436043","dot_number":"111374","report_state":"NY","report_number":"D507500634","insp_date":"2024-12-19 00:00:00","insp_start_time":"1123","insp_end_time":"1146","registration_date":null,"region":"ES","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":"2024-12-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1175771","transaction_code":"A","transaction_date":"2024-12-19 00:00:00","upload_date":"2024-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2024-12-19 21:40:00","snet_input_date":"2024-12-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-19 21:40:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:36.000000Z","updated_at":"2025-03-17T20:51:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12033948,"change_date":"2024-12-19 21:40:00","inspection_id":"83436043","insp_unit_id":"204475460","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"IT13B2","insp_unit_license":"81059MA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN2DH148277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:53.000000Z","updated_at":"2025-03-17T23:47:53.000000Z"}]},{"id":7122068,"change_date":"2024-11-05 21:38:00","inspection_id":"83080276","dot_number":"111374","report_state":"NY","report_number":"SPA4060006","insp_date":"2024-10-29 00:00:00","insp_start_time":"1007","insp_end_time":"1019","registration_date":null,"region":"ED","ci_status_code":"C","location":"40644","location_desc":"PAVILION NY","county_code_state":"NY","county_code":"037","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MORTON SALT","shipping_paper_number":"844440","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-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14968","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":"1020531","transaction_code":"A","transaction_date":"2024-11-05 00:00:00","upload_date":"2024-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2024-11-05 21:38:00","snet_input_date":"2024-10-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-05 21:38:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:38.000000Z","updated_at":"2025-03-17T20:44:38.000000Z","inspection_violations":[{"id":11122790,"change_date":"2024-11-05 21:38:00","inspection_id":"83080276","insp_violation_id":"262729592","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:00.000000Z","updated_at":"2025-03-17T22:00:00.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":11486979,"change_date":"2024-11-05 21:38:00","inspection_id":"83080276","insp_unit_id":"203737858","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"14064ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:01.000000Z","updated_at":"2025-03-17T23:42:01.000000Z"}]},{"id":6977354,"change_date":"2024-10-17 21:41:00","inspection_id":"82926673","dot_number":"111374","report_state":"NY","report_number":"5L50000008","insp_date":"2024-10-16 00:00:00","insp_start_time":"1403","insp_end_time":"1439","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MOUNT MORRIS NY","county_code_state":"NY","county_code":"051","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-10-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"954462","transaction_code":"A","transaction_date":"2024-10-17 00:00:00","upload_date":"2024-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2024-10-17 21:41:00","snet_input_date":"2024-10-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-17 21:41:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:27.000000Z","updated_at":"2025-03-17T20:41:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11253920,"change_date":"2024-10-17 21:41:00","inspection_id":"82926673","insp_unit_id":"203448406","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"IT17B","insp_unit_license":"41378PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMN9HH473690","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-03-17T23:39:28.000000Z","updated_at":"2025-03-17T23:39:28.000000Z"}]},{"id":6698340,"change_date":"2024-09-11 21:40:00","inspection_id":"82629879","dot_number":"111374","report_state":"NY","report_number":"SPD0236178","insp_date":"2024-09-10 00:00:00","insp_start_time":"1311","insp_end_time":"1334","registration_date":null,"region":"ET","ci_status_code":"C","location":"30382A","location_desc":"HASTINGS (SB)","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2950070","transaction_code":"A","transaction_date":"2024-09-11 00:00:00","upload_date":"2024-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2024-09-11 21:40:00","snet_input_date":"2024-09-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-11 21:40:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:42.000000Z","updated_at":"2025-03-17T20:35:42.000000Z","inspection_violations":[{"id":10428100,"change_date":"2024-09-11 21:40:00","inspection_id":"82629879","insp_violation_id":"261738193","seq_no":"1","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:30.000000Z","updated_at":"2025-03-17T21:56:30.000000Z","normalized_code":"3928"}],"inspection_per_units":[{"id":10800443,"change_date":"2024-09-11 21:40:00","inspection_id":"82629879","insp_unit_id":"202866187","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"MC23B","insp_unit_license":"38607PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB7RS074756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:50.000000Z","updated_at":"2025-03-17T23:34:50.000000Z"}]},{"id":6524980,"change_date":"2024-08-21 21:42:00","inspection_id":"82445237","dot_number":"111374","report_state":"NY","report_number":"SPWE040684","insp_date":"2024-08-20 00:00:00","insp_start_time":"0851","insp_end_time":"0913","registration_date":null,"region":"ET","ci_status_code":"C","location":"40714","location_desc":"I 490 WEST","county_code_state":"NY","county_code":"055","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COMMERCIAL PIPE ANS SUPPLY CORP","shipping_paper_number":"T49496","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2946201","transaction_code":"A","transaction_date":"2024-08-21 00:00:00","upload_date":"2024-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2024-08-21 21:42:00","snet_input_date":"2024-08-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-08-21 21:42:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:20.000000Z","updated_at":"2025-03-17T20:32:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10518544,"change_date":"2024-08-21 21:42:00","inspection_id":"82445237","insp_unit_id":"202506775","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"FR20R","insp_unit_license":"14064ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:56.000000Z","updated_at":"2025-03-17T23:31:56.000000Z"}]},{"id":6292983,"change_date":"2024-07-24 21:41:00","inspection_id":"82197351","dot_number":"111374","report_state":"NY","report_number":"M602003976","insp_date":"2024-07-18 00:00:00","insp_start_time":"1033","insp_end_time":"1044","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"AVON NY","county_code_state":"NY","county_code":"051","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-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"679319","transaction_code":"A","transaction_date":"2024-07-24 00:00:00","upload_date":"2024-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2024-07-24 21:41:00","snet_input_date":"2024-07-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-24 21:41:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:24.000000Z","updated_at":"2025-03-17T20:27:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10139914,"change_date":"2024-07-24 21:41:00","inspection_id":"82197351","insp_unit_id":"202036987","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"FR20R","insp_unit_license":"14064ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:01.000000Z","updated_at":"2025-03-17T23:28:01.000000Z"}]},{"id":5978884,"change_date":"2024-06-13 21:41:00","inspection_id":"81859515","dot_number":"111374","report_state":"NY","report_number":"D507005187","insp_date":"2024-06-12 00:00:00","insp_start_time":"1359","insp_end_time":"1418","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CHEEKTOWAGA 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":"2024-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"565737","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2024-06-13 21:41:00","snet_input_date":"2024-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-13 21:41:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:07.000000Z","updated_at":"2025-03-17T20:21:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9630190,"change_date":"2024-06-13 21:41:00","inspection_id":"81859515","insp_unit_id":"201369086","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"SST11B","insp_unit_license":"54790NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GT5BEC10151","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:50.000000Z","updated_at":"2025-03-17T23:22:50.000000Z"}]},{"id":5729409,"change_date":"2024-05-13 21:41:00","inspection_id":"81588756","dot_number":"111374","report_state":"NY","report_number":"SPE0330403","insp_date":"2024-05-08 00:00:00","insp_start_time":"1226","insp_end_time":"1252","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":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COMMERCIAL PIPE","shipping_paper_number":"834838","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-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2922913","transaction_code":"A","transaction_date":"2024-05-13 00:00:00","upload_date":"2024-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2024-05-13 21:41:00","snet_input_date":"2024-05-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-13 21:41:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:18.000000Z","updated_at":"2025-03-17T20:16:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9227947,"change_date":"2024-05-13 21:41:00","inspection_id":"81588756","insp_unit_id":"200853271","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"IT17","insp_unit_license":"35479PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMN3HH658057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:52.000000Z","updated_at":"2025-03-17T23:18:52.000000Z"}]},{"id":5346527,"change_date":"2024-03-22 21:39:00","inspection_id":"81171325","dot_number":"111374","report_state":"NY","report_number":"5L37000590","insp_date":"2024-03-22 00:00:00","insp_start_time":"0915","insp_end_time":"0937","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TONAWANDA 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":"2024-03-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"337788","transaction_code":"A","transaction_date":"2024-03-22 00:00:00","upload_date":"2024-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2024-03-22 21:39:00","snet_input_date":"2024-03-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-22 21:39:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:39.000000Z","updated_at":"2025-03-17T20:08:39.000000Z","inspection_violations":[{"id":8250094,"change_date":"2024-03-22 21:39:00","inspection_id":"81171325","insp_violation_id":"258529879","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"200040275","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:54.000000Z","updated_at":"2025-03-17T21:45:54.000000Z","normalized_code":"3939ALIL"},{"id":8250095,"change_date":"2024-03-22 21:39:00","inspection_id":"81171325","insp_violation_id":"258529880","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"200040275","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:54.000000Z","updated_at":"2025-03-17T21:45:54.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":8610213,"change_date":"2024-03-22 21:39:00","inspection_id":"81171325","insp_unit_id":"200040275","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"54790NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GT5BEC10151","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:06.000000Z","updated_at":"2025-03-17T23:13:06.000000Z"}]},{"id":4915558,"change_date":"2024-01-29 21:38:00","inspection_id":"80700812","dot_number":"111374","report_state":"NY","report_number":"D507900315","insp_date":"2024-01-29 00:00:00","insp_start_time":"0945","insp_end_time":"1012","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"CHURCHVILLE NY","county_code_state":"NY","county_code":"055","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-01-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"201241","transaction_code":"A","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2024-01-29 21:38:00","snet_input_date":"2024-01-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-29 21:38:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:04.000000Z","updated_at":"2025-03-17T20:00:04.000000Z","inspection_violations":[{"id":7573514,"change_date":"2024-01-29 21:38:00","inspection_id":"80700812","insp_violation_id":"257527349","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"199138291","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:32.000000Z","updated_at":"2025-03-17T21:42:32.000000Z","normalized_code":"39375A3TAOL"},{"id":7573515,"change_date":"2024-01-29 21:38:00","inspection_id":"80700812","insp_violation_id":"257527350","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"199138291","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:32.000000Z","updated_at":"2025-03-17T21:42:32.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":7910054,"change_date":"2024-01-29 21:38:00","inspection_id":"80700812","insp_unit_id":"199138291","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"14064ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:43.000000Z","updated_at":"2025-03-17T23:06:43.000000Z"}]},{"id":4891006,"change_date":"2024-01-24 21:44:00","inspection_id":"80674037","dot_number":"111374","report_state":"NY","report_number":"D507004913","insp_date":"2024-01-23 00:00:00","insp_start_time":"1105","insp_end_time":"1122","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"AMHERST NY","county_code_state":"NY","county_code":"029","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-01-24 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"192804","transaction_code":"A","transaction_date":"2024-01-24 00:00:00","upload_date":"2024-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2024-01-24 21:44:00","snet_input_date":"2024-01-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-24 21:44:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:38.000000Z","updated_at":"2025-03-17T19:59:38.000000Z","inspection_violations":[{"id":7536494,"change_date":"2024-01-24 21:44:00","inspection_id":"80674037","insp_violation_id":"257468370","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:20.000000Z","updated_at":"2025-03-17T21:42:20.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":7869775,"change_date":"2024-01-24 21:44:00","inspection_id":"80674037","insp_unit_id":"199084003","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1T13B","insp_unit_license":"81059MA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN2DH148277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:19.000000Z","updated_at":"2025-03-17T23:06:19.000000Z"}]},{"id":4800421,"change_date":"2024-01-10 21:43:00","inspection_id":"80574914","dot_number":"111374","report_state":"NY","report_number":"D507800187","insp_date":"2024-01-08 00:00:00","insp_start_time":"1223","insp_end_time":"1337","registration_date":null,"region":"ES","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":"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-01-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"168012","transaction_code":"A","transaction_date":"2024-01-10 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2024-01-10 21:43:00","snet_input_date":"2024-01-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-10 21:43:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:59.000000Z","updated_at":"2025-03-17T19:57:59.000000Z","inspection_violations":[{"id":7405506,"change_date":"2024-01-10 21:43:00","inspection_id":"80574914","insp_violation_id":"257268578","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:45.000000Z","updated_at":"2025-03-17T21:41:45.000000Z","normalized_code":"38323A2LCDLN"},{"id":7405507,"change_date":"2024-01-10 21:43:00","inspection_id":"80574914","insp_violation_id":"257268579","seq_no":"2","part_no":"392","part_no_section":"9A-DFSL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:45.000000Z","updated_at":"2025-03-17T21:41:45.000000Z","normalized_code":"3929ADFSL"},{"id":7405508,"change_date":"2024-01-10 21:43:00","inspection_id":"80574914","insp_violation_id":"257268580","seq_no":"3","part_no":"393","part_no_section":"110B3-C","insp_viol_unit":"1","insp_unit_id":"198892647","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:45.000000Z","updated_at":"2025-03-17T21:41:45.000000Z","normalized_code":"393110B3C"}],"inspection_per_units":[{"id":7723407,"change_date":"2024-01-10 21:43:00","inspection_id":"80574914","insp_unit_id":"198892647","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"IT13B","insp_unit_license":"81059MA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN2DH148277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:01.000000Z","updated_at":"2025-03-17T23:05:01.000000Z"}]},{"id":4308363,"change_date":"2023-10-30 21:42:00","inspection_id":"80034415","dot_number":"111374","report_state":"NY","report_number":"D507100039","insp_date":"2023-10-27 00:00:00","insp_start_time":"1421","insp_end_time":"1448","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","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":"2023-10-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"79766","transaction_code":"A","transaction_date":"2023-10-30 00:00:00","upload_date":"2023-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2023-10-30 21:42:00","snet_input_date":"2023-10-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-30 21:42:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:21.000000Z","updated_at":"2025-03-17T19:48:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6929099,"change_date":"2023-10-30 21:42:00","inspection_id":"80034415","insp_unit_id":"197802377","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"14064ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-03-17T22:58:08.000000Z","updated_at":"2025-03-17T22:58:08.000000Z"}]},{"id":4088870,"change_date":"2023-09-29 21:39:00","inspection_id":"79791655","dot_number":"111374","report_state":"NY","report_number":"SPWE140063","insp_date":"2023-09-28 00:00:00","insp_start_time":"0912","insp_end_time":"0933","registration_date":null,"region":"ET","ci_status_code":"C","location":"40714A","location_desc":"RIGA (EB)","county_code_state":"NY","county_code":"055","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2873986","transaction_code":"A","transaction_date":"2023-09-29 00:00:00","upload_date":"2023-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2023-09-29 21:39:00","snet_input_date":"2023-09-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-29 21:39:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:38.000000Z","updated_at":"2025-03-17T19:43:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6573692,"change_date":"2023-09-29 21:39:00","inspection_id":"79791655","insp_unit_id":"197312354","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"IT17","insp_unit_license":"35479PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMN3HH658057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:09.000000Z","updated_at":"2025-03-17T22:55:09.000000Z"}]},{"id":3854502,"change_date":"2023-08-29 21:41:00","inspection_id":"79530835","dot_number":"111374","report_state":"NY","report_number":"SPWE130695","insp_date":"2023-08-29 00:00:00","insp_start_time":"0752","insp_end_time":"0809","registration_date":null,"region":"ET","ci_status_code":"C","location":"40714B","location_desc":"RIGA (WB)","county_code_state":"NY","county_code":"055","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":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2863788","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":"00111374","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":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","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":6197033,"change_date":"2023-08-29 21:41:00","inspection_id":"79530835","insp_unit_id":"196778871","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"14064ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","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":3797757,"change_date":"2023-08-22 21:42:00","inspection_id":"79467277","dot_number":"111374","report_state":"NY","report_number":"5L34000222","insp_date":"2023-08-21 00:00:00","insp_start_time":"1217","insp_end_time":"1222","registration_date":null,"region":"ET","ci_status_code":"C","location":"50361","location_desc":"HAMBURG 2","county_code_state":"NY","county_code":"029","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-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2861029","transaction_code":"A","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2023-08-22 21:42:00","snet_input_date":"2023-08-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-22 21:42:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:44.000000Z","updated_at":"2025-03-17T19:37:44.000000Z","inspection_violations":[{"id":5858621,"change_date":"2023-08-22 21:42:00","inspection_id":"79467277","insp_violation_id":"254792485","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196654059","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6106140,"change_date":"2023-08-22 21:42:00","inspection_id":"79467277","insp_unit_id":"196654059","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"SST11","insp_unit_license":"20845ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GT5BEC10151","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:19.000000Z","updated_at":"2025-03-17T22:51:19.000000Z"}]},{"id":3896687,"change_date":"2023-09-05 21:40:00","inspection_id":"79577908","dot_number":"111374","report_state":"NY","report_number":"SPE0243250","insp_date":"2023-08-15 00:00:00","insp_start_time":"0805","insp_end_time":"0820","registration_date":null,"region":"ET","ci_status_code":"C","location":"40714B","location_desc":"RIGA (WB)","county_code_state":"NY","county_code":"055","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2864906","transaction_code":"A","transaction_date":"2023-09-05 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2023-09-05 21:40:00","snet_input_date":"2023-09-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-05 21:40:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:45.000000Z","updated_at":"2025-03-17T19:39:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6264733,"change_date":"2023-09-05 21:40:00","inspection_id":"79577908","insp_unit_id":"196883164","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"14064ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:37.000000Z","updated_at":"2025-03-17T22:52:37.000000Z"}]},{"id":3752773,"change_date":"2023-08-16 21:38:00","inspection_id":"79417007","dot_number":"111374","report_state":"NY","report_number":"SPE0273885","insp_date":"2023-08-14 00:00:00","insp_start_time":"1250","insp_end_time":"1310","registration_date":null,"region":"ET","ci_status_code":"C","location":"30765","location_desc":"SENECA FALLS","county_code_state":"NY","county_code":"099","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"EVANS COMETICS","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-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2858957","transaction_code":"A","transaction_date":"2023-08-14 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":null,"census_search_date":"2023-08-16 21:38:00","snet_input_date":"2023-08-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-16 21:38:00","insp_carrier_name":"COMMERCIAL PIPE AND SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:55.000000Z","updated_at":"2025-03-17T19:36:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6034095,"change_date":"2023-08-16 21:38:00","inspection_id":"79417007","insp_unit_id":"196553393","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"NONE","insp_unit_license":"14064ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:42.000000Z","updated_at":"2025-03-17T22:50:42.000000Z"}]},{"id":3189281,"change_date":"2023-06-01 21:42:00","inspection_id":"78784163","dot_number":"111374","report_state":"NY","report_number":"SPWE110933","insp_date":"2023-05-31 00:00:00","insp_start_time":"0748","insp_end_time":"0803","registration_date":null,"region":"ET","ci_status_code":"C","location":"40714","location_desc":"I-490 WEST","county_code_state":"NY","county_code":"055","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COMMERCIAL PIPE AND SUPPLY CORP","shipping_paper_number":"818912","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2831005","transaction_code":"A","transaction_date":"2023-06-01 00:00:00","upload_date":"2023-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2023-06-01 21:42:00","snet_input_date":"2023-06-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-01 21:42:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:06.000000Z","updated_at":"2025-03-17T19:26:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5129527,"change_date":"2023-06-01 21:42:00","inspection_id":"78784163","insp_unit_id":"195249826","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"IT17","insp_unit_license":"59971PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMN3HH658057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:24.000000Z","updated_at":"2025-03-17T22:43:24.000000Z"}]},{"id":3009593,"change_date":"2023-05-10 21:41:00","inspection_id":"78581360","dot_number":"111374","report_state":"NY","report_number":"0515008111","insp_date":"2023-05-09 00:00:00","insp_start_time":"1157","insp_end_time":"1219","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2823917","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":"00111374","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":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207-1920","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:37.000000Z","updated_at":"2025-03-17T19:22:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4842111,"change_date":"2023-05-10 21:41:00","inspection_id":"78581360","insp_unit_id":"194849314","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"IT17","insp_unit_license":"59971PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMN3HH658057","insp_unit_decal":"Y","insp_unit_decal_number":"NODECALS","created_at":"2025-03-17T22:41:09.000000Z","updated_at":"2025-03-17T22:41:09.000000Z"}]},{"id":2550257,"change_date":"2023-03-10 21:40:00","inspection_id":"78059701","dot_number":"111374","report_state":"NY","report_number":"SPT0355683","insp_date":"2023-03-02 00:00:00","insp_start_time":"1326","insp_end_time":"1341","registration_date":null,"region":"ET","ci_status_code":"C","location":"40055A","location_desc":"BATAVIA (EXIT 48)","county_code_state":"NY","county_code":"037","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2805467","transaction_code":"A","transaction_date":"2023-03-10 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2023-03-10 21:40:00","snet_input_date":"2023-03-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-10 21:40:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:42.000000Z","updated_at":"2025-03-17T19:13:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4104597,"change_date":"2023-03-10 21:40:00","inspection_id":"78059701","insp_unit_id":"193806643","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"11139MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:24.000000Z","updated_at":"2025-03-17T22:35:24.000000Z"}]},{"id":1724542,"change_date":"2022-11-14 21:41:00","inspection_id":"77116585","dot_number":"111374","report_state":"NY","report_number":"SPC0158523","insp_date":"2022-11-01 00:00:00","insp_start_time":"1257","insp_end_time":"1318","registration_date":null,"region":"ET","ci_status_code":"C","location":"30423","location_desc":"STATE ROUTE 13 N\/B T\/ITHACA","county_code_state":"NY","county_code":"109","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COMMERCIAL PIPE AND SUPPLY CORP","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2767413","transaction_code":"A","transaction_date":"2022-11-14 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2022-11-14 21:41:00","snet_input_date":"2022-11-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-14 21:41:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:32.000000Z","updated_at":"2025-03-17T18:58:32.000000Z","inspection_violations":[{"id":2701483,"change_date":"2022-11-14 21:41:00","inspection_id":"77116585","insp_violation_id":"249561275","seq_no":"1","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"1","insp_unit_id":"191920737","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"39355C2"},{"id":2701484,"change_date":"2022-11-14 21:41:00","inspection_id":"77116585","insp_violation_id":"249561276","seq_no":"2","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"1","insp_unit_id":"191920737","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"393110B"}],"inspection_per_units":[{"id":2774087,"change_date":"2022-11-14 21:41:00","inspection_id":"77116585","insp_unit_id":"191920737","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"11139MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:58.000000Z","updated_at":"2025-03-17T22:25:58.000000Z"}]},{"id":1092696,"change_date":"2022-08-22 21:41:00","inspection_id":"76385918","dot_number":"111374","report_state":"NY","report_number":"SPA0274748","insp_date":"2022-08-10 00:00:00","insp_start_time":"1130","insp_end_time":"1153","registration_date":null,"region":"ET","ci_status_code":"C","location":"40647B","location_desc":"RTS 5 AND 77","county_code_state":"NY","county_code":"037","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2742291","transaction_code":"A","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2022-08-22 21:41:00","snet_input_date":"2022-08-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-22 21:41:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:55.000000Z","updated_at":"2025-03-17T18:46:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1757218,"change_date":"2022-08-22 21:41:00","inspection_id":"76385918","insp_unit_id":"190440603","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"IT17B","insp_unit_license":"38592PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMN9HH473690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:06.000000Z","updated_at":"2025-03-17T22:19:06.000000Z"}]},{"id":776045,"change_date":"2022-07-08 21:40:00","inspection_id":"76015593","dot_number":"111374","report_state":"NY","report_number":"0518000451","insp_date":"2022-07-07 00:00:00","insp_start_time":"1010","insp_end_time":"1054","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-07-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2724982","transaction_code":"A","transaction_date":"2022-07-08 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2022-07-08 21:40:00","snet_input_date":"2022-07-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-08 21:40:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:16.000000Z","updated_at":"2025-03-17T18:41:16.000000Z","inspection_violations":[{"id":1226338,"change_date":"2022-07-08 21:40:00","inspection_id":"76015593","insp_violation_id":"246967756","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189667051","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3939A"},{"id":1226339,"change_date":"2022-07-08 21:40:00","inspection_id":"76015593","insp_violation_id":"246967757","seq_no":"2","part_no":"393","part_no_section":"207(c)","insp_viol_unit":"1","insp_unit_id":"189667051","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"393207C"}],"inspection_per_units":[{"id":1248660,"change_date":"2022-07-08 21:40:00","inspection_id":"76015593","insp_unit_id":"189667051","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"11139MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:51.000000Z","updated_at":"2025-03-17T22:15:51.000000Z"}]},{"id":744379,"change_date":"2022-07-05 21:41:00","inspection_id":"75978770","dot_number":"111374","report_state":"NY","report_number":"SPWE080824","insp_date":"2022-06-28 00:00:00","insp_start_time":"0704","insp_end_time":"0720","registration_date":null,"region":"ET","ci_status_code":"C","location":"40714B","location_desc":"RIGA (WB)","county_code_state":"NY","county_code":"055","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2723927","transaction_code":"A","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2022-07-05 21:41:00","snet_input_date":"2022-07-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-05 21:41:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:52.000000Z","updated_at":"2025-03-17T18:40:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1196369,"change_date":"2022-07-05 21:41:00","inspection_id":"75978770","insp_unit_id":"189588868","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"11139MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:32.000000Z","updated_at":"2025-03-17T22:15:32.000000Z"}]},{"id":97255,"change_date":"2022-04-04 21:40:00","inspection_id":"75206958","dot_number":"111374","report_state":"NY","report_number":"0518000250","insp_date":"2022-04-01 00:00:00","insp_start_time":"0940","insp_end_time":"1019","registration_date":null,"region":"ET","ci_status_code":"C","location":"50830M","location_desc":"TONAWANDA (S GRAND IS. BR)","county_code_state":"NY","county_code":"029","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"2691455","transaction_code":"A","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2022-04-04 21:40:00","snet_input_date":"2022-04-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-04 21:40:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:11.000000Z","updated_at":"2025-03-17T18:29:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":157217,"change_date":"2022-04-04 21:40:00","inspection_id":"75206958","insp_unit_id":"187958974","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"SST11","insp_unit_license":"20845ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GT5BEC10151","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:11.000000Z","updated_at":"2025-03-17T22:09:11.000000Z"}]},{"id":40848,"change_date":"2022-03-29 21:41:00","inspection_id":"75137343","dot_number":"111374","report_state":"NY","report_number":"SPG0234163","insp_date":"2022-03-23 00:00:00","insp_start_time":"1401","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354A","location_desc":"GROVELAND (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-25 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2689101","transaction_code":"C","transaction_date":"2022-03-29 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00111374","upload_search_indicator":"M","census_search_date":"2022-03-25 21:31:00","snet_input_date":"2022-03-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-03-25 21:31:00","insp_carrier_name":"COMMERCIAL PIPE & SUPPLY CORP","insp_carrier_street":"1920 ELMWOOD AVE","insp_carrier_city":"BUFFALO","insp_carrier_state":"NY","insp_carrier_zip_code":"14207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:23.000000Z","updated_at":"2025-03-17T18:28:23.000000Z","inspection_violations":[{"id":58276,"change_date":"2022-03-29 21:41:00","inspection_id":"75137343","insp_violation_id":"244824834","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"187863910","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"3939A"},{"id":58277,"change_date":"2022-03-29 21:41:00","inspection_id":"75137343","insp_violation_id":"244824835","seq_no":"3","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"1","insp_unit_id":"187863910","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"393203B"}],"inspection_per_units":[{"id":65710,"change_date":"2022-03-29 21:41:00","inspection_id":"75137343","insp_unit_id":"187863910","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"11139MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD2XLDMG9687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:40.000000Z","updated_at":"2025-03-17T22:08:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/111374\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/111374\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/111374\/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\/111374\/inspections","per_page":100,"prev_page_url":null,"to":43,"total":43}