OpenAirDocs.org
Plainville, CT

Registered aircraft · 20

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

N164SWPiper PA-28-181 · S/N 28-7690077Built 1975 · New England Aviation LLCN181DJPiper PA-28-181 · S/N 28-7790415Built 1977 · New England Aviation LLCN21ETBeech A36 · S/N E-889Built 1976 · Depucchio Mark VN274DTCessna 525B · S/N 525B0210Built 2008 · Central Connecticut Aircraft LLCN288JBSocata TBM 700 · S/N 1054Built 2015 · Central Connecticut Aircraft LLCN29NERobinson Helicopter R22 MARINER · S/N 0691MBuilt 1987 · Yankee Helicopters LLCN308TWCessna 550 · S/N 550-0044Built 1979 · Central Connecticut Aircraft LLCN3956MPiper PA-28-161 · S/N 28-7816390Built 1978 · New England Aviation LLCN45002Piper PA-31-350 · S/N 31-8052161Built 1980 · New England Aviation Air Charters LLCN4807JCessna 172N · S/N 17273680Built 1979 · New England Aviation LLCN5212KCessna 172P · S/N 17274012Built 1980 · New England Aviation LLCN522WDCessna 425 · S/N 4250015Built 1980 · Pegasus Air LLCN526TRRobinson Helicopter R44 II · S/N 10922Built 2005 · Yankee Helicopters LLCN5298KCessna 172P · S/N 17274051Built 1980 · New England Aviation LLCN608BRCirrus Design SR20 · S/N 1512Built 2005 · Armwings LLCN6256CPiper PA-28R-201 · S/N 28R-7837154Built 1978 · King David MN63512Cessna 172P · S/N 17275447Built 1981 · New England Aviation LLCN694KMRaytheon B200 · S/N BB-1922Carling Technologies IncN7667QCessna 310Q · S/N 310Q0446Built 1972 · Bergenty William F DBAN878YERobinson Helicopter R44 II · S/N 12214Built 2008 · Yankee Helicopters LLC
Back to Plainville, CT