New York, NY

Registered aircraft · 479

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 = 'NEW YORK'
  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.

N100JLCessna 421 · S/N 421-0008Bytelogics IncN101LLPiper PA-28-181 · S/N 2843367Built 2000 · Tribeca Aviation LLCN102CHEmbraer Executive EMB-505 · S/N 50500428Built 2017 · Wheels Up Partners LLCN10749Cessna 150L · S/N 15075005Atg Capital Management LLCN1083TMooney M20M · S/N 27-0023Built 1989 · Baer MatthewN108PBGulfstream Aerospace GVI (G650ER) · S/N 6473Built 2021 · Rex Asset Management LLCN109EABeech A36 · S/N E-2897Built 1994 · Degiarde Robert PN10BKMesserschmitt-Bolkow-Blohm GMB BO 105M · S/N 6051Built 1981 · Riley JakeN10GPAviat A-1B · S/N 2016Built 1999 · Maule Club CorporationN111SZExtra Flugzeugproduktions UND EXTRA NG · S/N NG087Built 2025 · Epic Ridge Aviation LLCN1146JMooney M20J · S/N 24-1197Built 1981 · Adam SpencerN115KGDassault FALCON 900EX · S/N 328Built 2022 · Falcon N115kg LLCN115TRBombardier BD-700-1A10 · S/N 9067Built 2000 · Tasco LLCN1161MMooney M20K · S/N 25-0657Built 1982 · Red Climb Transition LLCN116TLDehavilland DHC-3 · S/N 174Built 1956 · Tordrillo Mountain Aviation LLCN117JTBritish Aerospace BAE 125 SERIES 800A · S/N 258205Built 1992 · Colcot Aviation LLCN117KCCirrus Design SR22 · S/N 4536Built 2017 · Elektra Air LLCN1200GCessna 150L · S/N 15073901Built 1972 · Hartmann Kaiser RobertN120LWGulfstream Aerospace G-V · S/N 557Built 1998 · N120lw LLCN120SBGulfstream Aerospace G-IV · S/N 1462Built 2001 · Hrs Aircraft LLCN121ABCirrus Design SR22T · S/N 10279Built 2024 · Abl Jets LLCN12236Cessna 172M · S/N 17261898Built 1973 · Wolak Filip ON122BNBombardier BD-700-1A10 · S/N 9826Trfo LLCN123DMCessna T210M · S/N 21062663Jacquin Philip FinkN123KHDassault FALCON 7X · S/N 194Built 2013 · 485 Industrial LLCN1253LConsolidated Aeronautics LAKE LA-4-200 · S/N 751Built 1976 · Tuttle David LN125NYAirbus Helicopters AS 350B3 · S/N 8745Built 2019 · Office Of Vector Surveillance And ControlN1284PHawker Beechcraft G36 · S/N E-3988Built 2013 · Twostars Aviation LLCN128WFSocata TBM 700 · S/N 1093Built 2015 · Jla Equipment LLCN12AJPilatus PC-24 · S/N 561Non-citizen corporation, flight hours not reportedBuilt 2025 · Lexa International CorpN12WTCessna 421B · S/N 421B0829Built 1974 · Mtzb CorpN130JEGulfstream Aerospace G-IV · S/N 1398Built 2000 · Reserve Jets Acquisitions LLCN13259Cessna T182T · S/N T18208663Built 2006 · Nuthatch Air Services LLCN1337XDJI MAVIC PRO · S/N 08QDE3R0120330Romeo Tyler AN13DQTextron 208B · S/N 208B5758Built 2023 · Thaddeus Alistair LcN13PPilatus PC-12/47E · S/N 2156Built 2022 · Jcngx LLCN1430XPiper PA-28R-200 · S/N 28R-7535279Built 1975 · Ruggiero Matthew JN153PWD W L K K B1-PW-5 · S/N 05.002.03Built 2006 · Czarnocha BronislawN154MMAerovodochody L-29 DELFIN · S/N 591427Built 1965 · Riley JacobN1580Iai GULFSTREAM G280 · S/N 2019Built 2013 · Jpair LLCN15868Piper PA-28-140 · S/N 28-7325182Built 1972 · Mogan & White IncN159WHBombardier BD-100-1A10 · S/N 20017Built 2004 · Yas II (US) Mockingbird LLCN15YGulfstream Aerospace G-IV · S/N 1318Built 1997 · Apa Stream LLCN161AMAviat A-1B · S/N 2161De Boissard KarenN16635Boeing E75N1 · S/N 758780Built 1967 · Jeepers LLCN168ALLeeman Larry G RV-6A VANS ACFT · S/N 60168Built 2000 · Wittman MatthewN169LMGlaser-Dirks Flugzeugbau DG-100G · S/N E169G135Built 1984 · Gottlieb JacquelineN171ZAero Commander 500-B · S/N 1450-159Built 1964 · Caribbean Flyers LLCN175KACessna 172M · S/N 17262117Built 1973 · Air Cruiser LLCN17ESBeech 58P · S/N TJ-488Built 1985 · Crimson Aviation LLC
Back to New York, NY