Greenwich, CT
Registered aircraft · 54
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 = 'CT' AND g.registrant_city = 'GREENWICH' 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 = 'CT' AND g.registrant_city = 'GREENWICH' 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.
N107XSFolland GNAT T.MK.1 · S/N XS107N114BDDassault FALCON 7X · S/N 42N117MSBombardier BD-700-1A11 · S/N 9386N121PWCirrus Design SR22 · S/N 10747N123BMCirrus Design SR22 · S/N 3513N124MBCirrus Design SR22 · S/N 10310N172DHBeechcraft G58 · S/N TH-2403N182DCCessna 182RG · S/N 182R02006N1946GCessna 421B · S/N 421B0846N207MJMorane-Saulnier MS760B · S/N 02N225FWBombardier BD-100-1A10 · S/N 20725N229MHRobinson Helicopter R22 BETA · S/N 1441N277JHBombardier BD-100-1A10 · S/N 20796N280BDDassault MYSTERE-FALCON 50 · S/N 332N300EJCessna 310Q · S/N 310Q1156N303TFDassault FALCON 2000EX · S/N 44N306TCCessna A185F · S/N 18503061N373SRCirrus Design SR22 · S/N 2743N3875MPiper PA-12 · S/N 12-2786N406MHBeech 35-C33A · S/N CE-33N417CSBombardier BD-700-1A11 · S/N 9255N425TSTextron 525B · S/N 525B0589N4532PGulfstream American AA-5B · S/N AA5B1175N492HBBell Helicopter Textron Canada 407 · S/N 54425N508ELCessna 525C · S/N 525C0187N533XPFolland GNAT T.MK.1 · S/N XP533N556RWAmerican Champion 8KCAB · S/N 1093-2010N55ALIai GULFSTREAM G280 · S/N 2037N588MSchleicher KA 6 E · S/N 4049N60PMPiper PA 46-350P · S/N 4636744N617EAGulfstream Aerospace G-V · S/N 693N6228NCessna 172S · S/N 172S10695N6395ZCessna TU206G · S/N U20606266N664GBBeech 95-B55 · S/N TC-2093N664MVTextron 525C · S/N 525C0270N671WBGulfstream Aerospace GVIII-G800 · S/N 88015N672WVDassault FALCON 900 EX · S/N 280N675WBAgustawestland Philadelphia AW139 · S/N 41504N67WBGulfstream Aerospace GVIII-G800 · S/N 88017N705JSEADS Socata TBM 700 · S/N 195N718HSRaytheon A36 · S/N E-3462N7881DPiper PA-18 · S/N 18-6041N8276XPiper PA-28-181 · S/N 28-8190057N831KXCessna 172S · S/N 172S11107N85WBCirrus Design SR22 · S/N 2294N889TDDassault FALCON 900 EX · S/N 171N900BTTextron 525C · S/N 525C0224N902DSDiamond Aircraft Ind DA 40 · S/N 40.982N9287MCessna 172S · S/N 172S11112N950DMGulfstream Aerospace GVII-G600 · S/N 73059
Back to Greenwich, CT