OpenAirDocs.org
Benton, TN

Registered aircraft · 16

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
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 = 'BENTON'
  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.

N1002ZSchleicher Alexander K 7 · S/N 984Built 1961 · Arnold Sarah DN147JASchempp-Hirth DISCUS CS · S/N 147-CSBuilt 1994 · Arnold Jason AN1515BSchleicher ASW-15B · S/N 15450Built 1976 · Chilhowee Soaring Association IncN17934Schweizer SGS 1-26E · S/N 564Built 1973 · Arnold Jason AN222SKPiper PA-17 · S/N 17-75Built 1948 · Arnold Sarah DianeN2399UPiper PA-25-235 · S/N 25-5429Built 1972 · Chilhowee Soaring Association IncN2414LSzybowcowy Zaklad Doswiadczaln 41A JANTAR STANDARD · S/N B929Built 1979 · Chilhowee Soaring Association IncN2750HSchweizer SGS 2-33A · S/N 450Built 1976 · Chilhowee Soaring Association IncN327PWZaklad Szybowcowy Jezow PW-6U · S/N 78.05.06Built 2017 · Chilhowee Soaring Association IncN3280SLet BLANIK L-13 · S/N 025429Built 1973 · Arnold Sarah DN410PWPzl-Swidnik PW-5 · S/N 1707006Built 1997 · Chilhowee Soaring Association IncN4732YPiper PA-25-235 · S/N 25-4480Chilhowee Soaring Association IncN547CMSchempp-Hirth VENTUS 2A · S/N 125Built 2002 · Arnold Sarah DN8279HCallair A-9 · S/N 1148Built 1965 · Chilhowee Soaring Association IncN929MSchleicher ASW-20C · S/N 20707Built 1983 · Arnold Jason AN9865ESchweizer SGS 2-32 · S/N 30Chilhowee Soaring Association Inc
Back to Benton, TN