Albany, NY

Registered aircraft · 45

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 = 'ALBANY'
  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.

N108SUCessna 172P · S/N 17275001Built 1981 · Hardy JamesN10985Bellanca 7ACA · S/N 45-72Lozier Kurt TN11SPBell 407 · S/N 53530Built 2002 · State Of New YorkN129SPBell UH-1H · S/N 70-16205New York State PoliceN12SPBell 430 · S/N 49069Built 2000 · New York State PoliceN139JDJames Denooyer MTO SPORT · S/N M01396Built 2017 · Denooyer JamesN153ASPiper PA-28R-200 · S/N 28R-7635436Built 1976 · Bowen Arrow Aviation IncN1548TBeech A36 · S/N E-2482Built 1989 · Wd21 Aviation Holdings LLCN16SPBell 407 · S/N 53532Built 2002 · State Of New YorkN174SPBell UH-1H · S/N 63-12997New York State PoliceN177RFSchempp-Hirth STANDARD CIRRUS · S/N 272Built 1972 · Jones Gary RN17SPBell 407 · S/N 53444Built 2000 · New York State PoliceN188SWGulfstream Aerospace GVII-G500 · S/N 72018Built 2018 · Af Holdings IncN18SPBell 407 · S/N 53533Built 2002 · State Of New YorkN19SPBell UH-1H · S/N 64-13666New York State PoliceN20SPBell 430 · S/N 49070Built 2000 · New York State PoliceN224SPBell UH-1H · S/N 73-21721New York State Police Aviation UnitN3342UCessna 182F · S/N 18254742Built 1963 · Robert Smith Associates IncN350NYHawker Beechcraft B300 · S/N FL-539Built 2007 · State Of New YorkN361NYTextron B300 · S/N FL-1285Built 2022 · State Of New YorkN40CQPurple Honker SINUS SRO · S/N 392Jones Gary RN427SPBell 430 · S/N 49083Built 2001 · State Of New YorkN432NYBell 430 · S/N 49087Built 2001 · State Of New YorkN434BYCirrus Design SF50 · S/N 0413Bird-Dog Aviation LLCN454JDAutogyro CAVALON · S/N V00483Built 2021 · Denooyer JamesN4550UCessna 150D · S/N 15060550Built 1964 · Greene County Holdings LLCN472EMRaytheon 400A · S/N RK-472Built 2006 · Carver Air LLCN5226JCessna 172N · S/N 17273740Built 1980 · Mcgreen John RN5237LPiper PA-28-180 · S/N 28-4531Built 1967 · Air Sicko LLCN5766QMooney M20C · S/N 3085Salmon Jerome LN5SBEmbraer Executive EMB-500 · S/N 50000418Built 2020 · Carver Air LLCN605Partenavia P 68 OBSERVER · S/N 321-15/OBBuilt 1984 · New York State PoliceN61SACirrus Design SR22 · S/N 0677Sierra Alpha Holdings LLCN61SPBell UH-1H · S/N 74-22370New York State PoliceN626RAGulfstream Aerospace GV-SP (G550) · S/N 5176Built 2007 · Mavir LLCN627PSDiamond Aircraft Ind DA 40 NG · S/N 40.NC257Built 2023 · Symphony Of Sora LLCN7004GCessna 172K · S/N 17258704Built 1969 · Mcgreen John RN7348GCessna 172K · S/N 17259048Built 1970 · Hardy James HN767NECzech Aircraft Works Spol Sro SPORTCRUISER · S/N 07SC045Built 2007 · Jorgensen Jay GN8041DGlasflugel STANDARD LIBELLE · S/N 440Lozier Kurt TN82SBPilatus PC-12/47E · S/N 1281Built 2011 · Airborne Wake Riders LLCN8424LCessna 172I · S/N 17256624Built 1968 · Mcgreen John RN8616BCessna 172 · S/N 36316Built 1957 · Stewart JoelN89ZQCirrus Design SF50 · S/N 0560Built 2024 · Zq Holdings I LLCN915YDMagni Gyro M24 ORION · S/N 24148654Denooyer James
Back to Albany, NY