Registered aircraft · 19

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

N105TRInfinity Power Parachutes INFINITY CLASSIC · S/N IPP5-311Andrews Kevin M N113CLDiamond Aircraft Ind DA20-C1 · S/N C0013Built 1998 · Da Adventures LLC N1277KAero SP Z O O AT-4 LSA · S/N AT4-015Built 2008 · Andrews Kevin N1375WMooney M20C · S/N 2656Built 1963 · Andrews Kevin M N1981TPiper PA-28-180 · S/N 28-7105201Watson Barrett Consulting LLC N205SMooney M20J · S/N 24-3014Judson Alexander N216ASQuicksilver MX SPRINT TWO · S/N 428Binge Paul L N268WColumbia Aircraft Mfg LC42-550FG · S/N 42542Built 2006 · Golf Links Inc N2863MPiper PA-28-161 · S/N 28-7816318Built 1977 · Baillie Ryan B N2872EChampion AERONCA 7AC · S/N 7AC6455Built 1946 · Easterwood William D N305DWilliam Edwards JETEXEC · S/N 6774Edwards William N30689Piper PA-32RT-300 · S/N 32R-7885282Built 1978 · Pung Larry J N50264Bellanca 7ECA · S/N 1328-79Built 1979 · Hooper Kenneth R N528AWCirrus Design SR22T · S/N 9583Built 2023 · Rising Sunset LLC N6601ZGebeau Thomas J ZODIAC · S/N 001Built 2003 · Andrews Kevin M N84HHooper Kenneth R RV-8 · S/N 83277Built 2025 · Hooper Kenneth R N8862NPiper PA-28-140 · S/N 28-25717Built 1969 · Hatley Wayne S N899CTDiamond Aircraft Ind DA20-C1 · S/N C0099Built 2000 · Da Adventures LLC N904CTDiamond Aircraft Ind DA20-C1 · S/N C0104Da Adventures LLC

Back to Hermitage, TN