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 = 'TN' AND g.registrant_city = 'DICKSON' 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 = 'TN' AND g.registrant_city = 'DICKSON'
  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 = 'TN' AND g.registrant_city = 'DICKSON'
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.

N1363YCessna 172C · S/N 17249063Built 1961 · Drobnis Adam R N1444RGrumman American Avn. AA-1B · S/N AA1B-0544Built 1975 · Rye Steve V N260JEElashik-Spezio TU-HOLER · S/N JE-1Mccutchen David W N2728QPiper PA-28-181 · S/N 28-7790416Built 1977 · Danmick Holdings LLC N2999TAero Commander 100 · S/N 039Built 1966 · Anderson Richard C N300RMPiper PA-32-300 · S/N 32-7140003Built 1970 · Hiscall Enterprises Inc N374KCPiper PA 46-350P · S/N 4636374Built 2005 · Hostetter Swinea Aviation LLC N525DDBeech B-55 · S/N TC-1890Built 1975 · Moore Stephen K N5269RMooney M20K · S/N 25-1188Charles Hamptons A-1 Signs Inc N5429LGrumman American Avn. AA-5 · S/N AA5-0502Gardner T Larry N6883SAero Commander 680 · S/N 680-407-83Built 1956 · Webb Ronald G N7024PPiper PA-24-180 · S/N 24-2170Anderson Richard N78177Schempp-Hirth KA8B · S/N 1/8049Miller Steven T N787PMCessna T182T · S/N T18208429Built 2005 · Jacobs Philip N7911XCessna 172B · S/N 17248411Built 1961 · Rice David L N8479WPiper PA-28-180 · S/N 28-2723Built 1965 · Mckinnon Mel N864SBBaylor Steward L VANS RV7 · S/N 71772Built 2006 · Davis William S N911DHBeech C35 · S/N D-3322Built 1952 · Allison Joshua S N9291XJohnson Vernon R DOMINATOR TWO GYRO · S/N 02Built 2004 · Mccutchen David W N9852RBeech M35 · S/N D-6400Built 1960 · Everready Aviation LLC

Back to Dickson, TN