Great Neck, NY
Registered aircraft · 23
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 = 'GREAT NECK' 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 = 'GREAT NECK' 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.
N110ABDassault FALCON 2000 · S/N 125N200QBeech F33A · S/N CE-339N220DFDassault FALCON 2000 · S/N 69N290MXDassault-Breguet FALCON 50 · S/N 199N347MTEurocopter Deutschland EC 135 P2+ · S/N 1147N358CYGulfstream Aerospace G-1159A · S/N 358N4272SBeech V35B · S/N D-9959N44WGBombardier BD-700-1A10 · S/N 9046N473FLRaytheon 400A · S/N RK-397N500LRCanadair CL-600-2B16 · S/N 5012N50SNDassault MYSTERE-FALCON 50 · S/N 310N516MCGulfstream Aerospace G-IV (G400) · S/N 1531N58AJGulfstream Aerospace GIV-X (G450) · S/N 4188N58JEGulfstream Aerospace G-IV · S/N 1350N77FKGulfstream Aerospace G-IV · S/N 1357N807DDCanadair CL-600-2B16 · S/N 5161N813MFCirrus Design SR22 · S/N 10109N815EJIcon A5 · S/N 00157N826RPGulfstream Aerospace G-IV · S/N 1507N83974Piper PA-28-181 · S/N 28-8190254N855PRGolden Flyer Construoes Ltda SEAMAX M-22 · S/N 121N88GDDassault FALCON 2000 · S/N 30N900SNDassault FALCON 900 EX · S/N 117
Back to Great Neck, NY