OpenAirDocs.org
Powell, TN

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

N113SDDiamond Aircraft Ind DA 40 · S/N 40.1011Built 2008 · Cavu Pilot LLCN1625QCessna 150L · S/N 15072925Registration pendingN18686Cessna 150L · S/N 15074041Built 1972 · Duvoisin Tom JrN1976DBeech C35 · S/N D-3190Built 1956 · Robertson William JrN239VBeech 35 · S/N D-683Built 1947 · Lomax John EN25RBBergeron Raymond C KR-2 · S/N 1Bergeron Raymond CN3318SRonald M Slosberg RV-14A · S/N 140562Built 2020 · Slosberg Ronald MN33530Piper PA-28R-200 · S/N 28R-7535157Built 1975 · Lapointe Curtiss JamesN3356VCessna 150M · S/N 15076471Built 1974 · Cavu Pilot LLCN350DRBeech B300 · S/N FL63Built 1991 · Deroyal Industries IncN3745LCessna 172G · S/N 17253914Built 1965 · Maxey Lonnie CN388DHCirrus Design SR22 · S/N 3280Built 2008 · Cavu Pilot LLCN48FACessna 150F · S/N 15061895Built 1965 · Cavu Pilot LLCN51365Cessna 150J · S/N 15069953Built 1968 · Cavu Pilot LLCN5247QCessna 150L · S/N 15073147Cavu Pilot LLCN5965GCessna 150K · S/N 15071465Cavu Pilot LLCN605SNTextron 525 · S/N 525-1097Built 2021 · Ebj Air LLCN7188PPiper PA-24 · S/N 24-2358Backcourse Flyers IncN7346GCessna 172K · S/N 17259046Built 1970 · Bentley Darrell HowardN77906Luscombe 8A · S/N 3633Built 1946 · Smith Steve G
Back to Powell, TN