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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N100JLCessna 421 · S/N 421-0008N101LLPiper PA-28-181 · S/N 2843367N102CHEmbraer Executive EMB-505 · S/N 50500428N10749Cessna 150L · S/N 15075005N1083TMooney M20M · S/N 27-0023N108PBGulfstream Aerospace GVI (G650ER) · S/N 6473N109EABeech A36 · S/N E-2897N10BKMesserschmitt-Bolkow-Blohm GMB BO 105M · S/N 6051N10GPAviat A-1B · S/N 2016N111SZExtra Flugzeugproduktions UND EXTRA NG · S/N NG087N1146JMooney M20J · S/N 24-1197N115KGDassault FALCON 900EX · S/N 328N115TRBombardier BD-700-1A10 · S/N 9067N1161MMooney M20K · S/N 25-0657N116TLDehavilland DHC-3 · S/N 174N117JTBritish Aerospace BAE 125 SERIES 800A · S/N 258205N117KCCirrus Design SR22 · S/N 4536N1200GCessna 150L · S/N 15073901N120LWGulfstream Aerospace G-V · S/N 557N120SBGulfstream Aerospace G-IV · S/N 1462N121ABCirrus Design SR22T · S/N 10279N12236Cessna 172M · S/N 17261898N122BNBombardier BD-700-1A10 · S/N 9826N123DMCessna T210M · S/N 21062663N123KHDassault FALCON 7X · S/N 194N1253LConsolidated Aeronautics LAKE LA-4-200 · S/N 751N125NYAirbus Helicopters AS 350B3 · S/N 8745N1284PHawker Beechcraft G36 · S/N E-3988N128WFSocata TBM 700 · S/N 1093N12AJPilatus PC-24 · S/N 561Non-citizen corporation, flight hours not reportedN12WTCessna 421B · S/N 421B0829N130JEGulfstream Aerospace G-IV · S/N 1398N13259Cessna T182T · S/N T18208663N1337XDJI MAVIC PRO · S/N 08QDE3R0120330N13DQTextron 208B · S/N 208B5758N13PPilatus PC-12/47E · S/N 2156N1430XPiper PA-28R-200 · S/N 28R-7535279N153PWD W L K K B1-PW-5 · S/N 05.002.03N154MMAerovodochody L-29 DELFIN · S/N 591427N1580Iai GULFSTREAM G280 · S/N 2019N15868Piper PA-28-140 · S/N 28-7325182N159WHBombardier BD-100-1A10 · S/N 20017N15YGulfstream Aerospace G-IV · S/N 1318N161AMAviat A-1B · S/N 2161N16635Boeing E75N1 · S/N 758780N168ALLeeman Larry G RV-6A VANS ACFT · S/N 60168N169LMGlaser-Dirks Flugzeugbau DG-100G · S/N E169G135N171ZAero Commander 500-B · S/N 1450-159N175KACessna 172M · S/N 17262117N17ESBeech 58P · S/N TJ-488
Back to New York, NY