OpenAirDocs.org
Buffalo, NY

Registered aircraft · 66

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'NY' AND g.registrant_city = 'BUFFALO'
  ORDER BY g.n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N100NUUnderkofler Norman P SONERAI IIL · S/N 1274Built 1991 · Strong James RN101BARobert E Ashmore JR VANS RV-7 · S/N 71336Built 2012 · Canty John Martin IIIN101VSGates Lear Jet 24D · S/N 218Built 1969 · Calspan CorporationN102VSGates Lear Jet 25B · S/N 180Built 1974 · Calspan CorpN103JLLearjet 31 · S/N 026Built 1990 · Thunderun Aviation CorpN10UBUniversity AT Buffalo WINGS 4039 · S/N 1426BQ04UB403904Guan ZhangyuN130RVCessna 150L · S/N 15072090Uddin NazimN139FSAero Vodochody L39C · S/N 432933Built 1984 · Black Pearl L39 LLCN171ARLearjet 31A · S/N 171Built 1999 · Thunderun Aviation CorpN178CFRaytheon 390 · S/N RB-178Built 2007 · Rb-178 LLCN203VSGates Learjet 25D · S/N 347Built 1981 · Calspan CorpN2096BPiper PA-28-236 · S/N 28-7911008Built 1978 · N2096b LLCN2148PPiper PA-32-300 · S/N 32-7940043Built 1979 · Horizon Aviation LLCN21971Cessna T182T · S/N T18208730Built 2007 · Mp Aviation LLCN23LKCessna A185F · S/N 185-03085Built 1976 · Hernandez Byron JrN278TTLearjet 31A · S/N 104Built 1995 · Thunderun Aviation CorpN304VSGates Learjet 25D · S/N 354Built 1981 · Calspan CorpN30505Burkhart Grob Flugzeugbau ASTIR CS · S/N 1279Built 1976 · Richter Thomas PN312RBBarcelona Russell J COZY IV · S/N MK-0077Built 2024 · Barcelona Russell JN3200ZPiper PA-22-150 · S/N 22-7140Built 1959 · Brady Michael EN3311HBainbridge Gerald J VANCRAFT · S/N 001Built 2007 · Bainbridge Gerald JN338SDAirbus Helicopters AS350B3 · S/N 9745Built 2025 · Erie County Sheriffs OfficeN338SFEurocopter AS 350 B2 · S/N 3480Built 2001 · Erie CountyN339SDAirbus Helicopters AS350B3 · S/N 9746Built 2025 · Erie County Sheriffs OfficeN3602WPiper PA-32-260 · S/N 32-500Built 1966 · Jeswald Joseph MN367PZGuan Zhangyu WINGS 4039 · S/N 1426BQ04UB403905Guan ZhangyuN367QZGuan Zhangyu WINGS 4039 · S/N 1426BQ04UB403903Guan ZhangyuN3686ZGuan Zhangyu WINGS 4039 · S/N 1426BQ04UB403919Guan ZhangyuN3688ZGuan Zhangyu WINGS 4039 · S/N 1426BQ04UB403920Guan ZhangyuN368NZGuan Zhangyu WINGS 4039 · S/N 1426BQ04UB403914Guan ZhangyuN368SZGuan Zhangyu WINGS 4039 · S/N 1426BQ04UB403911Guan ZhanyuN368WZGuan Zhangyu WINGS 4039 · S/N 1426BQ04UB403917Guan ZhangyuN368YZGuan Zhangyu WINGS 4039 · S/N 1426BQ04UB403916Guan ZhangyuN389PCPiper PA 46-350P · S/N 4636482Built 2010 · N1543t LLCN405VSLearjet 31A · S/N 226Built 2001 · Calspan CorporationN406VSLearjet 31A · S/N 206Calspan LLCN41GFPiper PA-28R-201T · S/N 28R-7703083Built 1977 · Mesmer Refrigeration IncN429YCBell Helicopter Textron Canada 429 · S/N 57172Built 2013 · Mercy Flight IncN43FGBarry Avent FG-1D · S/N BA45FG-1Built 1945 · Black Pearl 51 LLCN4617CCessna 210N · S/N 21063577Brookhaven CorpN47015Fairchild M-62A · S/N 4435792Registration revokedBuilt 1943 · Mohr Charles FN505TJBell Textron Canada 429 · S/N 57470Mercy Flight IncN506TJBell Helicopter Textron Canada 429 · S/N 57331Built 2017 · Mercy Flight IncN508TJBell Helicopter Textron Canada 429 · S/N 57333Built 2017 · Mercy Flight IncN509TJBell Textron Canada 429 · S/N 57456Built 2022 · Mercy Flight IncN51DHNorth American/Aero Classics P-51D · S/N 122-31302Built 1944 · Black Pearl 51 LLCN51MXNorth American F-51D · S/N 45-11559Built 1945 · Black Pearl Fighters LLCN551SKHPH GLASFLUGEL 304C · S/N 51-CBuilt 2002 · Wallach Jari HN56WAAdams Warren Hall RV-3 · S/N 603Built 1983 · Carter Cameron TN601CHGulfstream Aerospace GVII-G600 · S/N 73029Built 2020 · Management Services Inc
Back to Buffalo, NY