Registered aircraft · 18

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

N103FCColyaer SL S100 FREEDOM · S/N 130-001-026Saltz Robert M N149DFPiaggio P149E · S/N 348Nelson Jim N15523Piper PA-28R-200 · S/N 28R-7335065Built 1972 · Derryberry Clay N1649APiper PA-22 · S/N 22-412Built 1952 · Hudgin James P N16PHHudgin James P LANCAIR 320 · S/N 376-320-131-17PBuilt 1994 · Hudgin James P N2269PMooney M20F · S/N 670152Built 1966 · Blackwell Steve N3435UCessna 182F · S/N 18254835Built 1963 · Jackson Terry W N3496HErco 415-C · S/N 4121Blackwell Steve N3816NBeech A35 · S/N D-1045Built 1947 · Bailey James N444CCBeech F33A · S/N CE-845Built 1979 · Von Almen James Martin N582KSPereyra Arnet AVENTURA HP · S/N APHP0005Saltz Robert M N6401APiper PA-38-112 · S/N 38-78A0416Lynch Rick W N816MDOwens Rick RANS S-12 · S/N 0891121Saltz Robert M N820RMSchleicher ASW-20 · S/N 20367Murphy Ron N88LFMusson Merle D VARIEZE · S/N 2078Built 1980 · Bailey James L N90032Head Balloons AX8-105 · S/N 521Built 2024 · Grimes Robert A N901RVShannon Stan VANS ACFT RV9A · S/N 90001Built 2003 · Kyzer William P N902KRAndrew Philip Richardson SOLO SYSTEM ACE · S/N 005Built 2021 · Grimes Robert A

Back to Lewisburg, TN