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

N14XZJordan Christopher Long J2 · S/N JL04Long Jordan N218SBArbc Inc DBA Lindstrand 90A · S/N 5632Built 2016 · Spirit Ballooning LLC N234EJJordan Christopher Long BB1 · S/N JL03Long Jordan C N2432MPiper PA-12 · S/N 12-1530Bunce John N277MMPiper PA-28-140 · S/N 28-7325295Solan Richard J N3028TLindstrand Balloons 90A · S/N 5098Built 1999 · Spirit Ballooning LLC N4507EChampion 7CCM · S/N 7CCM-113Built 1948 · Taylor John N4568MPiper PA-11 · S/N 11-71Built 1947 · Solan Richard J N51PKJordan Christopher Long J3 · S/N JL05Long Jordan N56914Boeing A75N1(PT17) · S/N 75-2101Built 1942 · Segalla William E N603JDJordan Christopher Long K1 · S/N JL02Long Jordan C N664JJabiru USA Sport J230-SP · S/N 572Built 2008 · Long Darrel Steven N7183EFoote James Innes JR RV-4 · S/N 1328Built 1991 · Stanton Ralph H Jr N740ZLJordan Christopher Long J1 · S/N JL01Built 2016 · Long Jordan Christopher N7788DPiper PA-18 · S/N 18-5987Built 1957 · Bunce John D N9134ZBoland Brian J TRAVELER · S/N 94Built 1996 · Spirit Ballooning LLC N922LDLong Darrel Steven S70 · S/N L001Built 1994 · Long Darrel S

Back to Canaan, CT