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

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

N1783YArbc Inc DBA Lindstrand 77A · S/N 5549Built 2013 · Wagoner Benjamin A N1944CCessna 170B · S/N 26089Built 1953 · 1944 Charli LLC N243GBBenjamin A Wagoner LULU · S/N CCR77-01Built 2023 · Wagoner Benjamin A N32885Balloon Works FIREFLY 7B-15 · S/N F7B-380Marcia M Lombardi N34520Aeronca 65-TL · S/N 4070TBuilt 1940 · Thomas Robert B N34979Cessna 177B · S/N 17702131Built 1974 · Bouvier Richard N4051TBalloon Works FIREFLY 7 · S/N 7947Built 1979 · Lombardi Marcia M N4104EAeronca 11CC · S/N 11CC-13Built 1947 · Flint Gregory C N4236EAeronca 7AC · S/N 7AC-7154Registration pendingBuilt 1947 N46114Aeronca 0-58B · S/N 12133Built 1943 · Thomas Robert B N46857Aeronca 0-58B · S/N 058B8493Built 1943 · Thomas Robert B N496LBArbc Inc DBA Lindstrand 90A · S/N 5635Built 2017 · Wagoner Benjamin A N531WWWeniger Marc BOLLAND MW1 · S/N 001Built 2003 · Shamper Edward D N54151Cessna 172P · S/N 17274891Built 1981 · Silver City Flying Club Inc N55940Piper PA-28-140 · S/N 28-7325537Built 1973 · Zadrick Wayne J N66912Beech C24R · S/N MC794Mcintyre Daniel J N6905JPiper PA-28R-200 · S/N 28R-7635359Built 1976 · Double Delta Sierra LLC N7097VBalloon Works FIREFLY 7-15 · S/N F7-1070Built 1999 · Barr Michael E N757BGCessna R182 · S/N R18201267Built 1979 · Wallace Wayne W N812TMGrumman American Avn. AA-5 · S/N AA5-0794Built 1975 · Joslyn Robert A

Back to Bristol, CT