OpenAirDocs.org
Hartford, CT

Registered aircraft · 36

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

N105SPCessna 182R · S/N 18268425Built 1984 · Department Of Emergency Svcs & Public ProtectionN107SPCessna 182R · S/N 18268427Built 1984 · Department Of Emergency Svc & Public ProtectionN113PFCessna 172R · S/N 17280401Built 1998 · Premier Flight Center LLCN145HHEurocopter Deutschland MBB-BK 117 C-2 · S/N 9236Built 2009 · Hartford HospitalN146HHAirbus Helicopters Deutschland MBB-BK 117 C-2 · S/N 9737Built 2016 · Hartford HospitalN15JEPiper PA-23-250 · S/N 27-2494Built 1964 · Premier Flight Center LLCN2476MPiper PA-28-161 · S/N 28-7816286Built 1977 · Premier Flight Center LLCN3077MPiper PA-28-161 · S/N 28-7816335Built 1977 · Premier Flight Center LLCN312HCBombardier BD-100-1A10 · S/N 20880Built 2021 · US Bank Na TrusteeN344RSGulfstream Aerospace GV-SP (G550) · S/N 5444Built 2013 · U S Bank Na TrusteeN347NAIai GULFSTREAM G280 · S/N 2134Built 2017 · US Bank Na TrusteeN356ESCessna 172R · S/N 17280051Built 1997 · Premier Flight Center LLCN359GSIai GULFSTREAM G280 · S/N 2135Built 2017 · US Bank Na TrusteeN3845LBeech 95-B55 (T42A) · S/N TC-2378Built 1981 · Donq LLCN401SPBell OH-58A · S/N 71-20412Connecticut State PoliceN402SPBell OH-58A · S/N 70-15607Connecticut State PoliceN414TERaytheon 390 · S/N RB-4Built 2001 · Laz Air LLCN506PATextron T206H · S/N T20609556Built 2018 · State Of ConnecticutN5299DCessna 172N · S/N 17272501Built 1979 · Premier Flight Center LLCN533LADiamond Aircraft Ind DA 40 NG · S/N 40.NC303Built 2024 · Clearsky Aviation LLCN594LPPulford Linda C LP65 · S/N 1Built 1994 · Sager Christian TN59JCPiper PA-31-350 · S/N 31-7952181Built 1979 · Pegasus Air Charter LLCN610EABeech D55 · S/N TE-719Built 1969 · Harvard CorpN650VCGulfstream Aerospace GVI (G650ER) · S/N 6244Built 2016 · U S Bank Na TrusteeN702GTBoeing 777F16 · S/N 38091Built 2012 · U S Bank Na TrusteeN703GTBoeing 777F16 · S/N 41518Built 2012 · US Bank Na TrusteeN787DVGulfstream Aerospace GVI (G650ER) · S/N 6563Built 2023 · US Bank Na TrusteeN791NHDJI INSPIRE 1 · S/N W13DCC17030651Hartford Financial Services GroupN828HJPiper PA-31-350 · S/N 31-8052160Built 1980 · Pegasus Air Charter LLCN843SDassault FALCON 7X · S/N 197Built 2013 · US Bank National Association TrusteeN84RRPipistrel D O O ALPHA ELECTRO · S/N 963 AE 60Built 2021 · Hartford Aviation Technologies Of Ct LLCN960DTIai GULFSTREAM G280 · S/N 2096Built 2016 · U S Bank Na TrusteeN971MTDassault FALCON 2000EX · S/N 326Built 2016 · US Bank Na TrusteeN972SCBombardier BD-100-1A10 · S/N 20888Built 2021 · US Bank Na TrusteeN974SZGulfstream Aerospace GV-SP (G550) · S/N 5545Built 2016 · US Bank Na TrusteeN975MTDassault FALCON 2000EX · S/N 333Built 2016 · US Bank National Association Owner Trustee
Back to Hartford, CT