Registered aircraft · 17

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'SIMSBURY' ORDER BY g.n_number

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

N16RDCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 07SC083Ndb LLC N16RKKoger Ralph H RV-6A · S/N 20254Built 1995 · 4bravo9 LLC N25AWCessna 182E · S/N 18253616Built 1961 · Mukherjee Kaustuv N3133QPiper PA-28-161 · S/N 28-7716138Built 1977 · Learn 2 Fly Ct LLC N4244HMooney M20J · S/N 24-0679Built 1978 · Leung Henry C N45319Gulfstream American AA-5B · S/N AA5B1168Built 1979 · Dale Timothy N46964Cessna 152 · S/N 15283152Built 1979 · Simsbury Aviation Services LLC N6229PPiper PA-24-250 · S/N 24-1332Built 1959 · A2a Aviation Inc N6284PPiper PA-24-250 · S/N 24-1394Built 1959 · Thomson William O N636HBAeroprakt Mfg SP Z O O A32 · S/N 330Built 2024 · Chamberlain Donald R N7259FPiper PA-28-151 · S/N 28-7715205Built 1976 · Learn 2 Fly Ct LLC N733UTCessna 172N · S/N 17268565Built 1977 · Omartian Robert A N8473WPiper PA-28-180 · S/N 28-2715Simsbury Aviation Services LLC N88WSPerner/Pitts S1S · S/N 1Built 1974 · Chamberlain Donald R N925RVStucklen Frederic W RV-6A · S/N 21508Built 1993 · Palazzo Jeffrey S N9430BCessna 175 · S/N 55230Built 1958 · Future Flyers Of Connecticut LLC N9999KAeroprakt Manufacturing SP Zoo A22LS · S/N 420Built 2021 · 99k LLC

Back to Simsbury, CT