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.

N110ABDassault FALCON 2000 · S/N 125Built 2000 · Tbf Group Aviation LLCN200QBeech F33A · S/N CE-339Built 1971 · Bluth Marshall SN220DFDassault FALCON 2000 · S/N 69Built 1998 · Falcon Aviation Z LLCN290MXDassault-Breguet FALCON 50 · S/N 199Jbs Aviation LLCN347MTEurocopter Deutschland EC 135 P2+ · S/N 1147Built 2013 · North Shore-Lij And Yale New Haven Health MedicalN358CYGulfstream Aerospace G-1159A · S/N 358Bondio LLCN4272SBeech V35B · S/N D-9959Built 1976 · Schechter StuartN44WGBombardier BD-700-1A10 · S/N 9046Built 2000 · Falcon Aviation Z LLCN473FLRaytheon 400A · S/N RK-397Built 2004 · Nam Jet LLCN500LRCanadair CL-600-2B16 · S/N 5012Built 1987 · Nam Jet LLCN50SNDassault MYSTERE-FALCON 50 · S/N 310Built 2000 · First Quality Falcon LLCN516MCGulfstream Aerospace G-IV (G400) · S/N 1531Built 2004 · Pjk Aviation LLCN58AJGulfstream Aerospace GIV-X (G450) · S/N 4188Built 2010 · Se Sfj LLCN58JEGulfstream Aerospace G-IV · S/N 1350Built 1998 · Kamali Aviation LLCN77FKGulfstream Aerospace G-IV · S/N 1357Built 1998 · Ocean Aviation 26 LLCN807DDCanadair CL-600-2B16 · S/N 5161Built 1994 · Falcon Aviation Z LLCN813MFCirrus Design SR22 · S/N 10109Built 2024 · Seamax America LLCN815EJIcon A5 · S/N 00157Built 2022 · Arcadia Capital Management LLCN826RPGulfstream Aerospace G-IV · S/N 1507Built 2003 · Tbf Group Aviation LLCN83974Piper PA-28-181 · S/N 28-8190254Built 1981 · Otoole Airways LLCN855PRGolden Flyer Construoes Ltda SEAMAX M-22 · S/N 121Built 2014 · Sea Max America LLCN88GDDassault FALCON 2000 · S/N 30Built 1996 · Kamali Aviation LLCN900SNDassault FALCON 900 EX · S/N 117Built 2002 · Sn117 LLC
Back to Great Neck, NY