OpenAirDocs.org
Stamford, CT

Registered aircraft · 34

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 = 'STAMFORD'
  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.

N106CKDassault FALCON 900EX · S/N 214Built 2008 · Blt Net Charter IncN121RFRockwell International 112TC · S/N 13048Built 1976 · Rafamedia LLCN155CCCubcrafters CC11-160 · S/N CC11-00408Meconiates AnthonyN16RCLake LA-4-200 · S/N 576Built 1973 · Lake N16rc Partners LLCN203PWMooney M20E · S/N 1281Wood Philip AN2098CCessna T182T · S/N T18208228Built 2004 · Lynch Stephen JN2233XPiper PA-28-181 · S/N 28-7990368Built 1979 · Spector ArnoldN228TYFlydoo Sarl WEDOO2000K · S/N WD200408KBuilt 2021 · Thank You Balloon Project CoN247WEBombardier BD-700-1A11 · S/N 9245Built 2007 · Wwe Jet Services IncN300CRDassault FALCON 7X · S/N 29Built 2007 · Crane CompanyN380ASCirrus Design SR22T · S/N 8997Built 2022 · Hacksaw Aviation LLCN3850GCessna 340A · S/N 340A0208Built 1976 · N3850g LLCN408BFBombardier CL-600-2B16 · S/N 5561Built 2003 · Ridge Crest Leasing LLCN4313FPiper PA-28-181 · S/N 28-7790011Built 1976 · Js Partner Consulting LLCN444CTPiper PA32-301FT · S/N 3232032Built 2004 · Leseviciute AudroneN446PCMooney M20R · S/N 29-0446Built 2006 · Statius-Muller Robert C TrusteeN449TMHawker Beechcraft 400A · S/N RK-573Built 2008 · Jersey Aviation LLCN460TMHawker Beechcraft 400A · S/N RK-516Built 2007 · Jersey Aviation LLCN482TMHawker Beechcraft 400A · S/N RK-538Built 2007 · Jersey Aviation LLCN489TMHawker Beechcraft 400A · S/N RK-559Built 2008 · Jersey Aviation LLCN491TMHawker Beechcraft 400A · S/N RK-564Built 2008 · Jersey Aviation LLCN527DKTextron T206H · S/N T20609722Built 2023 · Eci Staffing Solutions IncN540AMAtlas Stone FX3 CCX-2000 · S/N CCX-2000-0235Atlas Stone Fx3 LLCN54ZSBombardier BD-100-1A10 · S/N 21066Built 2025 · Suplay 5 LLCN5761ZGreat Lakes 2T-1A-2 · S/N 0834Built 1980 · Hannibal Aviation LLCN5842LAmerican AA-5 · S/N AA5-0042Built 1972 · Berner Walter T IIIN671UPRaytheon 400A · S/N RK-415Built 2005 · Jersey Aviation LLCN737WNCessna TR182 · S/N R18200891Built 1979 · Morton Jeremy R JrN7684NBeech V35A · S/N D-8867Built 1968 · Mccarthy Mitchell SN8052MCessna T210M · S/N 21062031Built 1977 · Echo Romeo LLCN829HMRaytheon 400A · S/N RK-461Jersey Aviation LLCN85FMEADS Socata TBM 700 · S/N 469Built 2008 · Atlas Stone Capital LLCN9221JPiper PA-28-180 · S/N 28-3291Built 1966 · Jgms Rose LLCN9284PPiper PA-24-260 · S/N 24-4784Built 1968 · Dickinson Malcolm
Back to Stamford, CT