OpenAirDocs.org
Stratford, CT

Registered aircraft · 64

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

N100FVSikorsky S-100 · S/N 0001Built 2019 · Sikorsky Aircraft CorpN1431WBell 206A · S/N 374Built 1969 · C-Pan Aero LLCN1469TPiper PA-28R-200 · S/N 28R-7235297Built 1972 · Three Wing Flight School LLCN16DMPiper PA-23-150 · S/N 23-1157Built 1962 · Bordonaro Dominic LN176FXKeystone Helicopter S-76C · S/N 760646Built 2007 · Flexjet Vertical Lift LLCN201GYMooney M20J · S/N 24-0226Built 1977 · Brill Daniel CN21020Cessna 182P · S/N 18261364Built 1972 · Monteiro Armando DN2308TPiper PA-28R-200 · S/N 28R-7135200Built 1971 · Bugarchich Christopher ZN2495TPiper PA-28-180 · S/N 28-7205061Built 1971 · Avia Flight Academy LLCN276FXSikorsky S-76C · S/N 760509Built 2000 · Flexjet Vertical Lift LLCN277FXSikorsky S-76C-2 · S/N 760676Built 2007 · Flexjet Vertical Lift LLCN278FXKeystone Helicopter S-76C · S/N 760750Built 2008 · Flexjet Vertical Lift LLCN2884DPiper PA-28-161 · S/N 28-7916504Built 1979 · Three Wing Flight School LLCN314KPiper PA-31-350 · S/N 31-8352025Built 1983 · 314-K Associates LLCN317SXSikorsky S-92A · S/N 920317Sikorsky Aircraft CorpN318SXSikorsky S-92A · S/N 920318Sikorsky Aircraft CorpN319SXSikorsky S-92A · S/N 920319Sikorsky Aircraft CorpN320SXSikorsky S-92A · S/N 920320Sikorsky Aircraft CorpN321VPiper PA-28-180 · S/N 28-4665Built 1968 · Avia Flight Academy LLCN32369Piper PA-28-180 · S/N 28-7505054Built 1974 · Avia Flight Academy LLCN33550Piper PA-28-180 · S/N 28-7505157Built 1975 · Nutmeg Flying ClubN33CTPiper PA-28-181 · S/N 28-7890136Built 1977 · Three Wing Flight School LLCN411DDBell 206B · S/N 2837Built 1979 · Hbh Aircraft LLCN4170TPiper PA-28-181 · S/N 2843390Built 2000 · Vwfusco Aircraft Management LLCN4315YPiper PA-28-181 · S/N 28-8390089Built 1983 · Three Wing Flight School LLCN4332NPiper PA-28-161 · S/N 28-8416034Built 1983 · Three Wing Flight School LLCN45278Gulfstream American AA-5B · S/N AA5B1138Built 1979 · Becker Air LLCN454XPiper PA-28-181 · S/N 28-7890318Built 1978 · Three Wing Flight School LLCN5415XSikorsky S-76A · S/N 760199Built 1981 · Connecticut Air And Space CenterN54446Piper PA-28-151 · S/N 28-7415064Built 1973 · Avia Flight Academy LLCN600PVSikorsky UH-60A · S/N 79-23298Built 1980 · Sikorsky Aircraft CorpN626RBCessna 560 · S/N 560-0221Built 1993 · Millard Robert BN676FXSikorsky S-76D · S/N 761025Built 2013 · Flexjet Vertical Lift LLCN68007Cirrus Design SR22 · S/N 2354Built 2007 · N68007 LLCN69GZGame Composites GB1 GAMEBIRD · S/N 0049Built 2022 · Sikorsky Aircraft CorpN728LWDassault-Breguet FALCON 50 · S/N 3Built 1979 · Bleeker Holdings CorpN7378HPiper J3C-65 · S/N 20641Built 1946 · Goetz Robert JN744JNPiper PA-28-180 · S/N 28-5702Built 1970 · Avia Flight Academy LLCN759ZDCessna 182Q · S/N 18266381Built 1978 · N759zd LLCN760PVSikorsky S-76B · S/N 760425Built 1994 · Sikorsky Aircraft CorpN761DSikorsky S-76D · S/N 761001Built 2009 · Sikorsky Aircraft CorpN762DSikorsky S-76D · S/N 761002Built 2009 · Sikorsky Aircraft CorpN7633MSikorsky S-76D · S/N 761033Sikorsky Aircraft CorpN7634YSikorsky S-76D · S/N 761034Sikorsky Aircraft CorpN763DXSikorsky S-76D · S/N 761003Built 2011 · Sikorsky Aircraft CorpN7685CSikorsky S-76D · S/N 761085Sikorsky Aircraft CorpN7686QSikorsky S-76D · S/N 761086Sikorsky Aircraft CorpN7687LSikorsky S-76D · S/N 761087Sikorsky Aircraft CorpN7688PSikorsky S-76D · S/N 761088Sikorsky Aircraft CorpN7689LSikorsky S-76D · S/N 761089Sikorsky Aircraft Corp
Back to Stratford, CT