{"current_page":1,"data":[{"id":11321811,"change_date":"2026-03-09 21:36:00","inspection_id":"87238504","dot_number":"475493","report_state":"NY","report_number":"SPE3011267","insp_date":"2026-03-02 00:00:00","insp_start_time":"0910","insp_end_time":"0925","registration_date":null,"region":"ES","ci_status_code":"C","location":"40714E","location_desc":"CHURCHVILLE NY","county_code_state":"NY","county_code":"055","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-03-09 21:36: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":"2980414","transaction_code":"A","transaction_date":"2026-03-08 00:00:00","upload_date":"2026-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2026-03-09 21:36:00","snet_input_date":"2026-03-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-09 21:36:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-12T09:40:19.000000Z","updated_at":"2026-03-20T09:30:14.000000Z","inspection_violations":[{"id":19056579,"change_date":"2026-03-09 21:36:00","inspection_id":"87238504","insp_violation_id":"272283090","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"212038316","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-12T10:01:38.000000Z","updated_at":"2026-03-20T09:43:11.000000Z","normalized_code":"3922SLLIFTA"},{"id":19056580,"change_date":"2026-03-09 21:36:00","inspection_id":"87238504","insp_violation_id":"272283091","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"212038316","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-12T10:01:38.000000Z","updated_at":"2026-03-20T09:43:11.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":19371095,"change_date":"2026-03-09 21:36:00","inspection_id":"87238504","insp_unit_id":"212038316","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"MC25","insp_unit_license":"54298PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4TS078657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-12T09:21:03.000000Z","updated_at":"2026-03-20T09:02:49.000000Z"}]},{"id":11090939,"change_date":"2026-02-10 21:38:00","inspection_id":"87002498","dot_number":"475493","report_state":"NY","report_number":"D507501521","insp_date":"2026-02-09 00:00:00","insp_start_time":"1003","insp_end_time":"1021","registration_date":null,"region":"ES","ci_status_code":"C","location":"40714E","location_desc":"CHURCHVILLE NY","county_code_state":"NY","county_code":"055","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-02-10 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":"2867219","transaction_code":"A","transaction_date":"2026-02-10 00:00:00","upload_date":"2026-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2026-02-10 21:38:00","snet_input_date":"2026-02-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-10 21:38:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-13T10:37:49.000000Z","updated_at":"2026-02-21T10:30:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18913316,"change_date":"2026-02-10 21:38:00","inspection_id":"87002498","insp_unit_id":"211533676","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"MC25","insp_unit_license":"54298PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4TS078657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-13T10:15:34.000000Z","updated_at":"2026-02-21T10:03:00.000000Z"}]},{"id":10880137,"change_date":"2026-01-29 21:37:00","inspection_id":"86910546","dot_number":"475493","report_state":"NY","report_number":"SPA3070736","insp_date":"2026-01-22 00:00:00","insp_start_time":"1310","insp_end_time":"1326","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-29 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2822419","transaction_code":"A","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2026-01-29 21:37:00","snet_input_date":"2026-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-29 21:37:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-01T10:35:41.000000Z","updated_at":"2026-02-10T10:30:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18286148,"change_date":"2026-01-29 21:37:00","inspection_id":"86910546","insp_unit_id":"211334779","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"MC24L","insp_unit_license":"40111PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB5RS074755","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-01T10:10:36.000000Z","updated_at":"2026-02-09T10:00:58.000000Z"}]},{"id":10637296,"change_date":"2026-01-13 21:40:00","inspection_id":"86778501","dot_number":"475493","report_state":"PA","report_number":"E130601364","insp_date":"2026-01-13 00:00:00","insp_start_time":"0916","insp_end_time":"0938","registration_date":null,"region":"ET","ci_status_code":"C","location":"088","location_desc":"I90 WB MM 32 HARBORCREEK TWP-","county_code_state":"PA","county_code":"049","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"LAKES PIPES & SUPPLY CORP","shipping_paper_number":"NF-574132","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2567215","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2026-01-13 21:40:00","snet_input_date":"2026-01-13 00:00:00","source_office":"1PAS001","mcmis_add_date":"2026-01-13 21:40:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-16T10:36:04.000000Z","updated_at":"2026-01-24T10:30:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17841602,"change_date":"2026-01-13 21:40:00","inspection_id":"86778501","insp_unit_id":"211056816","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"MC24L","insp_unit_license":"40111PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB5RS074755","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:40.000000Z","updated_at":"2026-01-24T10:02:21.000000Z"}]},{"id":10784415,"change_date":"2026-02-02 21:38:00","inspection_id":"86810224","dot_number":"475493","report_state":"NY","report_number":"SPA3081094","insp_date":"2026-01-09 00:00:00","insp_start_time":"1107","insp_end_time":"1118","registration_date":"2026-01-30 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":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"DIVERSIFIED MANUFACTURING","shipping_paper_number":"100769","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":"2026-01-16 21:39: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":"2772771","transaction_code":"C","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2026-01-16 21:39:00","snet_input_date":"2026-01-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-16 21:39:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-19T10:36:48.000000Z","updated_at":"2026-02-13T10:30:06.000000Z","inspection_violations":[{"id":18257321,"change_date":"2026-02-02 21:38:00","inspection_id":"86810224","insp_violation_id":"271544161","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":"2026-02-05T10:45:05.000000Z","updated_at":"2026-02-13T10:39:09.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":18330000,"change_date":"2026-02-02 21:38:00","inspection_id":"86810224","insp_unit_id":"211392200","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"40111PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB5RS074755","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-05T10:08:33.000000Z","updated_at":"2026-02-13T10:05:22.000000Z"}]},{"id":10502843,"change_date":"2025-12-23 21:38:00","inspection_id":"86637704","dot_number":"475493","report_state":"NY","report_number":"SPA3070671","insp_date":"2025-12-16 00:00:00","insp_start_time":"0901","insp_end_time":"0921","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SILVER CREEK NY","county_code_state":"NY","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LAKES PIPE AND SUPPLY CORP","shipping_paper_number":"NF-573552","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-12-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2690576","transaction_code":"A","transaction_date":"2025-12-22 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2025-12-23 21:38:00","snet_input_date":"2025-12-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-23 21:38:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-26T10:38:32.000000Z","updated_at":"2026-01-03T10:30:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17588261,"change_date":"2025-12-23 21:38:00","inspection_id":"86637704","insp_unit_id":"210766017","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"4011PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB5RS074755","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:27.000000Z","updated_at":"2026-01-03T10:00:20.000000Z"}]},{"id":8754223,"change_date":"2025-05-28 21:42:00","inspection_id":"84798198","dot_number":"475493","report_state":"NY","report_number":"D507801556","insp_date":"2025-05-28 00:00:00","insp_start_time":"0904","insp_end_time":"0957","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-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","viol_total":"6","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":"1790955","transaction_code":"A","transaction_date":"2025-05-28 00:00:00","upload_date":"2025-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2025-05-28 21:42:00","snet_input_date":"2025-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-28 21:42:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-31T10:01:23.000000Z","updated_at":"2025-06-01T10:00:25.000000Z","inspection_violations":[{"id":13977138,"change_date":"2025-05-28 21:42:00","inspection_id":"84798198","insp_violation_id":"266512587","seq_no":"1","part_no":"392","part_no_section":"9BA-INACTIVE","insp_viol_unit":"1","insp_unit_id":"207098363","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-31T10:17:02.000000Z","updated_at":"2025-06-01T10:17:30.000000Z","normalized_code":"3929BAINACTIVE"},{"id":13977139,"change_date":"2025-05-28 21:42:00","inspection_id":"84798198","insp_violation_id":"266512588","seq_no":"2","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"207098363","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-31T10:17:02.000000Z","updated_at":"2025-06-01T10:17:30.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":13977140,"change_date":"2025-05-28 21:42:00","inspection_id":"84798198","insp_violation_id":"266512589","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"207098363","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-31T10:17:02.000000Z","updated_at":"2025-06-01T10:17:30.000000Z","normalized_code":"3939ALIL"},{"id":13977141,"change_date":"2025-05-28 21:42:00","inspection_id":"84798198","insp_violation_id":"266512590","seq_no":"4","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"207098363","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-31T10:17:02.000000Z","updated_at":"2025-06-01T10:17:30.000000Z","normalized_code":"3939ALRLI"},{"id":13977142,"change_date":"2025-05-28 21:42:00","inspection_id":"84798198","insp_violation_id":"266512591","seq_no":"5","part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"207098363","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-31T10:17:02.000000Z","updated_at":"2025-06-01T10:17:30.000000Z","normalized_code":"39330B"},{"id":13977143,"change_date":"2025-05-28 21:42:00","inspection_id":"84798198","insp_violation_id":"266512592","seq_no":"6","part_no":"393","part_no_section":"110B3-C","insp_viol_unit":"1","insp_unit_id":"207098363","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-31T10:17:02.000000Z","updated_at":"2025-06-01T10:17:30.000000Z","normalized_code":"393110B3C"}],"inspection_per_units":[{"id":14315101,"change_date":"2025-05-28 21:42:00","inspection_id":"84798198","insp_unit_id":"207098363","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"MC24L","insp_unit_license":"40111PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB5RS074755","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:46.000000Z","updated_at":"2025-06-01T09:47:03.000000Z"}]},{"id":7315854,"change_date":"2024-12-02 21:39:00","inspection_id":"83285167","dot_number":"475493","report_state":"NY","report_number":"SPE3080130","insp_date":"2024-11-25 00:00:00","insp_start_time":"1355","insp_end_time":"1411","registration_date":null,"region":"ES","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":"2024-12-02 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":"1109445","transaction_code":"A","transaction_date":"2024-12-02 00:00:00","upload_date":"2024-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2024-12-02 21:39:00","snet_input_date":"2024-11-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-02 21:39:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:36.000000Z","updated_at":"2025-03-17T20:48:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11801551,"change_date":"2024-12-02 21:39:00","inspection_id":"83285167","insp_unit_id":"204127516","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"IT07","insp_unit_license":"32302PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN67H508882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:20.000000Z","updated_at":"2025-03-17T23:45:20.000000Z"}]},{"id":6860087,"change_date":"2024-10-01 21:42:00","inspection_id":"82802034","dot_number":"475493","report_state":"NY","report_number":"D306000801","insp_date":"2024-09-30 00:00:00","insp_start_time":"1255","insp_end_time":"1352","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BATH NY","county_code_state":"NY","county_code":"101","insp_level_id":"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-01 21:42: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":"902578","transaction_code":"A","transaction_date":"2024-10-01 00:00:00","upload_date":"2024-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2024-10-01 21:42:00","snet_input_date":"2024-09-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-01 21:42:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:22.000000Z","updated_at":"2025-03-17T20:39:22.000000Z","inspection_violations":[{"id":10684760,"change_date":"2024-10-01 21:42:00","inspection_id":"82802034","insp_violation_id":"262119969","seq_no":"1","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"203209119","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"39378A"},{"id":10684761,"change_date":"2024-10-01 21:42:00","inspection_id":"82802034","insp_violation_id":"262119970","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"203209119","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":11062804,"change_date":"2024-10-01 21:42:00","inspection_id":"82802034","insp_unit_id":"203209119","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"IT07","insp_unit_license":"32302PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN67H508882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:34.000000Z","updated_at":"2025-03-17T23:37:34.000000Z"}]},{"id":6458194,"change_date":"2024-08-13 21:42:00","inspection_id":"82374083","dot_number":"475493","report_state":"PA","report_number":"E403422615","insp_date":"2024-08-13 00:00:00","insp_start_time":"0925","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":"090","location_desc":"I90 WB MM 46 NORTH EAST TWP -","county_code_state":"PA","county_code":"049","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"LAKES PIPE AND SUPPY 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":"2024-08-13 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":"2461354","transaction_code":"A","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2024-08-13 21:42:00","snet_input_date":"2024-08-13 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-08-13 21:42:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:44.000000Z","updated_at":"2025-03-17T20:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10409609,"change_date":"2024-08-13 21:42:00","inspection_id":"82374083","insp_unit_id":"202373084","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"FR20","insp_unit_license":"28831PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:51.000000Z","updated_at":"2025-03-17T23:30:51.000000Z"}]},{"id":6227510,"change_date":"2024-07-16 21:43:00","inspection_id":"82127256","dot_number":"475493","report_state":"NY","report_number":"SPE0229383","insp_date":"2024-07-15 00:00:00","insp_start_time":"1159","insp_end_time":"1216","registration_date":null,"region":"ET","ci_status_code":"C","location":"60056B","location_desc":"BATH (WB)","county_code_state":"NY","county_code":"101","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-16 21:43: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":"2937352","transaction_code":"A","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":"M","census_search_date":"2024-07-16 21:43:00","snet_input_date":"2024-07-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-16 21:43:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:12.000000Z","updated_at":"2025-03-17T20:26:12.000000Z","inspection_violations":[{"id":9675264,"change_date":"2024-07-16 21:43:00","inspection_id":"82127256","insp_violation_id":"260664837","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201903400","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:48.000000Z","updated_at":"2025-03-17T21:52:48.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10033698,"change_date":"2024-07-16 21:43:00","inspection_id":"82127256","insp_unit_id":"201903400","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"49155NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GT4EEB11387","insp_unit_decal":"Y","insp_unit_decal_number":"34337975","created_at":"2025-03-17T23:26:57.000000Z","updated_at":"2025-03-17T23:26:57.000000Z"}]},{"id":6085093,"change_date":"2024-06-26 21:43:00","inspection_id":"81974213","dot_number":"475493","report_state":"PA","report_number":"E135417735","insp_date":"2024-06-25 00:00:00","insp_start_time":"0940","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"EXIT 32 WB OFF RAMP","county_code_state":"PA","county_code":"049","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"WABTEC","shipping_paper_number":"NF551892","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2452578","transaction_code":"A","transaction_date":"2024-06-25 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2024-06-26 21:43:00","snet_input_date":"2024-06-25 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:21.000000Z","updated_at":"2025-03-17T20:23:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9801056,"change_date":"2024-06-26 21:43:00","inspection_id":"81974213","insp_unit_id":"201608948","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"20","insp_unit_license":"28831PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:32.000000Z","updated_at":"2025-03-17T23:24:32.000000Z"}]},{"id":6035915,"change_date":"2024-06-20 21:43:00","inspection_id":"81921219","dot_number":"475493","report_state":"NY","report_number":"SPA0276404","insp_date":"2024-06-19 00:00:00","insp_start_time":"1040","insp_end_time":"1102","registration_date":null,"region":"ET","ci_status_code":"C","location":"80881A","location_desc":"ALLEGANY REST AREA","county_code_state":"NY","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2930855","transaction_code":"A","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":"M","census_search_date":"2024-06-20 21:43:00","snet_input_date":"2024-06-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-20 21:43:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:17.000000Z","updated_at":"2025-03-17T20:22:17.000000Z","inspection_violations":[{"id":9363497,"change_date":"2024-06-20 21:43:00","inspection_id":"81921219","insp_violation_id":"260209641","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"201503975","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:19.000000Z","updated_at":"2025-03-17T21:51:19.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":9721453,"change_date":"2024-06-20 21:43:00","inspection_id":"81921219","insp_unit_id":"201503975","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"20","insp_unit_license":"28831PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:44.000000Z","updated_at":"2025-03-17T23:23:44.000000Z"}]},{"id":6040641,"change_date":"2024-06-20 21:44:00","inspection_id":"81926363","dot_number":"475493","report_state":"PA","report_number":"E951417093","insp_date":"2024-06-18 00:00:00","insp_start_time":"0940","insp_end_time":"1001","registration_date":null,"region":"ET","ci_status_code":"C","location":"088","location_desc":"I90 WB MM 32 HARBORCREEK TWP-","county_code_state":"PA","county_code":"049","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":"N","pen_cen_match":null,"final_status_date":"2024-06-20 21:44: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":"2450896","transaction_code":"A","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2024-06-20 21:44:00","snet_input_date":"2024-06-18 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-06-20 21:44:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:34.000000Z","updated_at":"2025-03-17T20:22:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9729251,"change_date":"2024-06-20 21:44:00","inspection_id":"81926363","insp_unit_id":"201514246","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"FR20","insp_unit_license":"28831PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:47.000000Z","updated_at":"2025-03-17T23:23:47.000000Z"}]},{"id":5915509,"change_date":"2024-06-05 21:41:00","inspection_id":"81790664","dot_number":"475493","report_state":"NY","report_number":"SPA3020058","insp_date":"2024-05-30 00:00:00","insp_start_time":"0959","insp_end_time":"1005","registration_date":null,"region":"ED","ci_status_code":"C","location":"50011","location_desc":"ALLEGANY NY","county_code_state":"NY","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LAKES PIPE & SUPPLY CORP","shipping_paper_number":"NF-551335","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-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":"542582","transaction_code":"A","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2024-06-05 21:41:00","snet_input_date":"2024-05-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-05 21:41:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:52.000000Z","updated_at":"2025-03-17T20:19:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9527934,"change_date":"2024-06-05 21:41:00","inspection_id":"81790664","insp_unit_id":"201239163","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"IT07","insp_unit_license":"32302PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN67H508882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:49.000000Z","updated_at":"2025-03-17T23:21:49.000000Z"}]},{"id":5563055,"change_date":"2024-04-22 21:40:00","inspection_id":"81407735","dot_number":"475493","report_state":"NY","report_number":"SPA0350776","insp_date":"2024-04-16 00:00:00","insp_start_time":"0915","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":"52036","location_desc":"NATIONAL GRID LOT","county_code_state":"NY","county_code":"063","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LAKES PIPE AND SUPPLY","shipping_paper_number":"40963","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-04-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"2918737","transaction_code":"A","transaction_date":"2024-04-22 00:00:00","upload_date":"2024-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":"M","census_search_date":"2024-04-22 21:40:00","snet_input_date":"2024-04-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-22 21:40:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:06.000000Z","updated_at":"2025-03-17T20:13:06.000000Z","inspection_violations":[{"id":8598626,"change_date":"2024-04-22 21:40:00","inspection_id":"81407735","insp_violation_id":"259054403","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200504273","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:38.000000Z","updated_at":"2025-03-17T21:47:38.000000Z","normalized_code":"3939A"},{"id":8598627,"change_date":"2024-04-22 21:40:00","inspection_id":"81407735","insp_violation_id":"259054404","seq_no":"2","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"1","insp_unit_id":"200504273","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:47:38.000000Z","updated_at":"2025-03-17T21:47:38.000000Z","normalized_code":"393100A"}],"inspection_per_units":[{"id":8961013,"change_date":"2024-04-22 21:40:00","inspection_id":"81407735","insp_unit_id":"200504273","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"49155NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GT4EEB11387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:23.000000Z","updated_at":"2025-03-17T23:16:23.000000Z"}]},{"id":5379552,"change_date":"2024-03-27 21:42:00","inspection_id":"81207220","dot_number":"475493","report_state":"NY","report_number":"SPT0385862","insp_date":"2024-03-20 00:00:00","insp_start_time":"1359","insp_end_time":"1414","registration_date":null,"region":"ET","ci_status_code":"C","location":"50361","location_desc":"BLASDELL (EXIT 56)","county_code_state":"NY","county_code":"029","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LAKES PIPE AND SUPPLY CORP","shipping_paper_number":"NF 549001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-27 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":"2913114","transaction_code":"A","transaction_date":"2024-03-20 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2024-03-27 21:42:00","snet_input_date":"2024-03-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-27 21:42:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:07.000000Z","updated_at":"2025-03-17T20:09:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8663678,"change_date":"2024-03-27 21:42:00","inspection_id":"81207220","insp_unit_id":"200110655","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"20","insp_unit_license":"28831PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:34.000000Z","updated_at":"2025-03-17T23:13:34.000000Z"}]},{"id":5131285,"change_date":"2024-02-26 21:41:00","inspection_id":"80936739","dot_number":"475493","report_state":"NY","report_number":"D507800365","insp_date":"2024-02-22 00:00:00","insp_start_time":"1018","insp_end_time":"1040","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NIAGARA FALLS NY","county_code_state":"NY","county_code":"063","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"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-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"268315","transaction_code":"A","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2024-02-26 21:41:00","snet_input_date":"2024-02-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-26 21:41:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:13.000000Z","updated_at":"2025-03-17T20:04:13.000000Z","inspection_violations":[{"id":7912872,"change_date":"2024-02-26 21:41:00","inspection_id":"80936739","insp_violation_id":"258027299","seq_no":"1","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"199590873","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:13.000000Z","updated_at":"2025-03-17T21:44:13.000000Z","normalized_code":"39341BNPB"},{"id":7912873,"change_date":"2024-02-26 21:41:00","inspection_id":"80936739","insp_violation_id":"258027300","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","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:44:13.000000Z","updated_at":"2025-03-17T21:44:13.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":8261381,"change_date":"2024-02-26 21:41:00","inspection_id":"80936739","insp_unit_id":"199590873","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"SST14","insp_unit_license":"49155NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GT4EEB11387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:52.000000Z","updated_at":"2025-03-17T23:09:52.000000Z"}]},{"id":5134141,"change_date":"2024-02-26 21:42:00","inspection_id":"80939900","dot_number":"475493","report_state":"NY","report_number":"SPA0350709","insp_date":"2024-02-22 00:00:00","insp_start_time":"0830","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":"50903","location_desc":"BELL AREO SPACE","county_code_state":"NY","county_code":"063","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LAKES PIPE","shipping_paper_number":"546744","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2909045","transaction_code":"A","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2024-02-26 21:42:00","snet_input_date":"2024-02-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-26 21:42:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:14.000000Z","updated_at":"2025-03-17T20:04:14.000000Z","inspection_violations":[{"id":7916813,"change_date":"2024-02-26 21:42:00","inspection_id":"80939900","insp_violation_id":"258032931","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199596385","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:13.000000Z","updated_at":"2025-03-17T21:44:13.000000Z","normalized_code":"3939A"},{"id":7916814,"change_date":"2024-02-26 21:42:00","inspection_id":"80939900","insp_violation_id":"258032932","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"199596385","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:13.000000Z","updated_at":"2025-03-17T21:44:13.000000Z","normalized_code":"39375A3"},{"id":7916815,"change_date":"2024-02-26 21:42:00","inspection_id":"80939900","insp_violation_id":"258032933","seq_no":"3","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"1","insp_unit_id":"199596385","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:44:13.000000Z","updated_at":"2025-03-17T21:44:13.000000Z","normalized_code":"393100A"}],"inspection_per_units":[{"id":8265940,"change_date":"2024-02-26 21:42:00","inspection_id":"80939900","insp_unit_id":"199596385","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"IT07","insp_unit_license":"32302PA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN67H508882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:55.000000Z","updated_at":"2025-03-17T23:09:55.000000Z"}]},{"id":4411617,"change_date":"2023-11-13 21:42:00","inspection_id":"80148823","dot_number":"475493","report_state":"PA","report_number":"E951331320","insp_date":"2023-11-09 00:00:00","insp_start_time":"0954","insp_end_time":"1016","registration_date":null,"region":"ET","ci_status_code":"C","location":"443","location_desc":"SR0290\/BAYFRONT CONNECTOR WEST","county_code_state":"PA","county_code":"049","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":"N","pen_cen_match":null,"final_status_date":"2023-11-13 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":"2396158","transaction_code":"A","transaction_date":"2023-11-09 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2023-11-13 21:42:00","snet_input_date":"2023-11-09 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-11-13 21:42:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:18.000000Z","updated_at":"2025-03-17T19:50:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7095245,"change_date":"2023-11-13 21:42:00","inspection_id":"80148823","insp_unit_id":"198031032","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"28831PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:35.000000Z","updated_at":"2025-03-17T22:59:35.000000Z"}]},{"id":3921009,"change_date":"2023-09-07 21:40:00","inspection_id":"79604989","dot_number":"475493","report_state":"NY","report_number":"SPA0258475","insp_date":"2023-09-05 00:00:00","insp_start_time":"1021","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":"60117A","location_desc":"CAMPBELL (EB)","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LAKES PIPE AND 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":"N","pen_cen_match":null,"final_status_date":"2023-09-07 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":"2865689","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":"M","census_search_date":"2023-09-07 21:40:00","snet_input_date":"2023-09-07 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-07 21:40:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:25.000000Z","updated_at":"2025-03-17T19:40:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6304792,"change_date":"2023-09-07 21:40:00","inspection_id":"79604989","insp_unit_id":"196937397","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"20","insp_unit_license":"28831PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:57.000000Z","updated_at":"2025-03-17T22:52:57.000000Z"}]},{"id":2682270,"change_date":"2023-03-29 21:41:00","inspection_id":"78209424","dot_number":"475493","report_state":"NY","report_number":"SPWE031024","insp_date":"2023-03-28 00:00:00","insp_start_time":"1000","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"40714B","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-03-29 21:41: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":"2810961","transaction_code":"A","transaction_date":"2023-03-29 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":"M","census_search_date":"2023-03-29 21:41:00","snet_input_date":"2023-03-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-29 21:41:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:11.000000Z","updated_at":"2025-03-17T19:16:11.000000Z","inspection_violations":[{"id":4121211,"change_date":"2023-03-29 21:41:00","inspection_id":"78209424","insp_violation_id":"251918146","seq_no":"1","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"194111920","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:19.000000Z","updated_at":"2025-03-17T21:26:19.000000Z","normalized_code":"39021B"}],"inspection_per_units":[{"id":4318538,"change_date":"2023-03-29 21:41:00","inspection_id":"78209424","insp_unit_id":"194111920","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"49155NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4GT4EEB11387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:01.000000Z","updated_at":"2025-03-17T22:37:01.000000Z"}]},{"id":2102062,"change_date":"2023-01-10 21:40:00","inspection_id":"77548558","dot_number":"475493","report_state":"NY","report_number":"SPE0227510","insp_date":"2023-01-09 00:00:00","insp_start_time":"1005","insp_end_time":"1041","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":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-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":"2786799","transaction_code":"A","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":"M","census_search_date":"2023-01-10 21:40:00","snet_input_date":"2023-01-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-10 21:40:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:29.000000Z","updated_at":"2025-03-17T19:05:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3382371,"change_date":"2023-01-10 21:40:00","inspection_id":"77548558","insp_unit_id":"192777647","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"20","insp_unit_license":"28831PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"Y","insp_unit_decal_number":"32340108","created_at":"2025-03-17T22:30:14.000000Z","updated_at":"2025-03-17T22:30:14.000000Z"}]},{"id":1482690,"change_date":"2022-10-11 21:41:00","inspection_id":"76838583","dot_number":"475493","report_state":"US","report_number":"1483230017","insp_date":"2022-10-06 00:00:00","insp_start_time":"1156","insp_end_time":"1223","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ALLEGANY NY REST AREA","county_code_state":"NY","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NF-527902","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"11485","transaction_code":"A","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2022-10-11 21:41:00","snet_input_date":"2022-10-11 00:00:00","source_office":"1NYD001","mcmis_add_date":"2022-10-11 21:41:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:06.000000Z","updated_at":"2025-03-17T18:54:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2385847,"change_date":"2022-10-11 21:41:00","inspection_id":"76838583","insp_unit_id":"191363577","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"83960PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:21.000000Z","updated_at":"2025-03-17T22:23:21.000000Z"}]},{"id":1154290,"change_date":"2022-08-29 21:41:00","inspection_id":"76457590","dot_number":"475493","report_state":"NY","report_number":"0519000427","insp_date":"2022-08-25 00:00:00","insp_start_time":"1012","insp_end_time":"1038","registration_date":null,"region":"ET","ci_status_code":"C","location":"50011M","location_desc":"ALLEGANY REST AREA (WB)","county_code_state":"NY","county_code":"009","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-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":"2744240","transaction_code":"A","transaction_date":"2022-08-29 00:00:00","upload_date":"2022-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":"M","census_search_date":"2022-08-29 21:41:00","snet_input_date":"2022-08-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-29 21:41:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:57.000000Z","updated_at":"2025-03-17T18:47:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1855558,"change_date":"2022-08-29 21:41:00","inspection_id":"76457590","insp_unit_id":"190584774","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"20","insp_unit_license":"83960PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:47.000000Z","updated_at":"2025-03-17T22:19:47.000000Z"}]},{"id":1050302,"change_date":"2022-08-17 21:39:00","inspection_id":"76335936","dot_number":"475493","report_state":"NY","report_number":"SPE0282349","insp_date":"2022-08-16 00:00:00","insp_start_time":"0935","insp_end_time":"0955","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":"LAKES 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-08-17 21:39: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":"2740330","transaction_code":"A","transaction_date":"2022-08-17 00:00:00","upload_date":"2022-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":"M","census_search_date":"2022-08-17 21:39:00","snet_input_date":"2022-08-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-17 21:39:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"3525 HYDE PARK BLVD","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:11.000000Z","updated_at":"2025-03-17T18:46:11.000000Z","inspection_violations":[{"id":1655371,"change_date":"2022-08-17 21:39:00","inspection_id":"76335936","insp_violation_id":"247754820","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190342040","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1690050,"change_date":"2022-08-17 21:39:00","inspection_id":"76335936","insp_unit_id":"190342040","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"20","insp_unit_license":"83960PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:40.000000Z","updated_at":"2025-03-17T22:18:40.000000Z"}]},{"id":890137,"change_date":"2022-07-26 21:41:00","inspection_id":"76148622","dot_number":"475493","report_state":"NY","report_number":"SPA0257242","insp_date":"2022-07-25 00:00:00","insp_start_time":"1245","insp_end_time":"1310","registration_date":null,"region":"ET","ci_status_code":"C","location":"50243A","location_desc":"DUNKIRK (EXIT 59)","county_code_state":"NY","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LAKES 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-07-26 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":"2731071","transaction_code":"A","transaction_date":"2022-07-26 00:00:00","upload_date":"2022-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":"M","census_search_date":"2022-07-26 21:41:00","snet_input_date":"2022-07-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-26 21:41:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:23.000000Z","updated_at":"2025-03-17T18:43:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1432991,"change_date":"2022-07-26 21:41:00","inspection_id":"76148622","insp_unit_id":"189956832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"20","insp_unit_license":"83960PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"Y","insp_unit_decal_number":"31687908","created_at":"2025-03-17T22:17:00.000000Z","updated_at":"2025-03-17T22:17:00.000000Z"}]},{"id":805070,"change_date":"2022-07-13 21:39:00","inspection_id":"76049228","dot_number":"475493","report_state":"NY","report_number":"SPE0273073","insp_date":"2022-07-12 00:00:00","insp_start_time":"1017","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":"40658","location_desc":"PHELPS-ROADSIDE","county_code_state":"NY","county_code":"069","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"VANCE","shipping_paper_number":"NF524565","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-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"2726350","transaction_code":"A","transaction_date":"2022-07-13 00:00:00","upload_date":"2022-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":"M","census_search_date":"2022-07-13 21:39:00","snet_input_date":"2022-07-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-13 21:39:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:56.000000Z","updated_at":"2025-03-17T18:41:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1295430,"change_date":"2022-07-13 21:39:00","inspection_id":"76049228","insp_unit_id":"189743819","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"13","insp_unit_license":"16452PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMSAAR2DH465193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:09.000000Z","updated_at":"2025-03-17T22:16:09.000000Z"}]},{"id":423044,"change_date":"2022-05-18 21:44:00","inspection_id":"75597695","dot_number":"475493","report_state":"PA","report_number":"E107213741","insp_date":"2022-05-17 00:00:00","insp_start_time":"0805","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":"088","location_desc":"I90 WB MM 32 HARBORCREEK TWP-","county_code_state":"PA","county_code":"049","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":"N","pen_cen_match":null,"final_status_date":"2022-05-18 21:44: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":"2254789","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2022-05-18 21:44:00","snet_input_date":"2022-05-17 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-05-18 21:44:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:07.000000Z","updated_at":"2025-03-17T18:35:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":682932,"change_date":"2022-05-18 21:44:00","inspection_id":"75597695","insp_unit_id":"188768448","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"83960PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"Y","insp_unit_decal_number":"31308178","created_at":"2025-03-17T22:12:23.000000Z","updated_at":"2025-03-17T22:12:23.000000Z"}]},{"id":236484,"change_date":"2022-04-22 21:45:00","inspection_id":"75375066","dot_number":"475493","report_state":"PA","report_number":"E130211157","insp_date":"2022-04-21 00:00:00","insp_start_time":"1322","insp_end_time":"1342","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"BAYFRONT CONNECTOR MEASURING 2","county_code_state":"PA","county_code":"049","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":"N","pen_cen_match":null,"final_status_date":"2022-04-22 21:45: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":"2248662","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2022-04-22 21:45:00","snet_input_date":"2022-04-21 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-04-22 21:45:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:36.000000Z","updated_at":"2025-03-17T18:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":383529,"change_date":"2022-04-22 21:45:00","inspection_id":"75375066","insp_unit_id":"188300224","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"83960PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:34.000000Z","updated_at":"2025-03-17T22:10:34.000000Z"}]},{"id":166889,"change_date":"2022-04-18 21:42:00","inspection_id":"75291901","dot_number":"475493","report_state":"PA","report_number":"E951210251","insp_date":"2022-04-12 00:00:00","insp_start_time":"0807","insp_end_time":"0835","registration_date":"2022-04-18 00:00:00","region":"ET","ci_status_code":"C","location":"443","location_desc":"SR0290\/BAYFRONT CONNECTOR WEST","county_code_state":"PA","county_code":"049","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":"N","pen_cen_match":null,"final_status_date":"2022-04-13 21:40: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":"2245972","transaction_code":"C","transaction_date":"2022-04-12 00:00:00","upload_date":"2022-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00475493","upload_search_indicator":null,"census_search_date":"2022-04-13 21:40:00","snet_input_date":"2022-04-12 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-04-13 21:40:00","insp_carrier_name":"LAKES PIPE AND SUPPLY CORP","insp_carrier_street":"P O BOX 429","insp_carrier_city":"NIAGARA FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14302","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:29.000000Z","updated_at":"2025-03-17T18:30:29.000000Z","inspection_violations":[{"id":250360,"change_date":"2022-04-18 21:42:00","inspection_id":"75291901","insp_violation_id":"245213780","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188202127","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:12.000000Z","updated_at":"2025-03-17T21:08:12.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":270478,"change_date":"2022-04-18 21:42:00","inspection_id":"75291901","insp_unit_id":"188202127","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"83960PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD21LDMG9688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:50.000000Z","updated_at":"2025-03-17T22:09:50.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/475493\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/475493\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/475493\/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\/475493\/inspections","per_page":100,"prev_page_url":null,"to":31,"total":31}