Millington, TN

Registered aircraft · 23

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

N107PHBell 206B · S/N 2789Built 1979 · Southern Helicopter Service IncN115RJGulfstream Aerospace LP GULFSTREAM 100 · S/N 153Built 2004 · 7192 Locke Road LLCN16810Bell 206B · S/N 2231Built 1977 · Southern Helicopter Services IncN21281Cessna 182P · S/N 18261535Built 1972 · Horne Randall WN2159GCessna 182A · S/N 51459Kirchoff Kevin BN39992Taylorcraft BC12-D · S/N 6651Built 1945 · Bradford Raymond SN400USCessna T182T · S/N T18208276Built 2004 · United States Aviation Underwriters IncN4028GBeech D-45 · S/N BG-9Built 1955 · United States Navy (Owner)N46246Cessna 172I · S/N 17257133Built 1968 · Pidgeon J Everett IIIN50KUGulfstream Aerospace G-V · S/N 659Built 2001 · Under The Stars LLCN5171KCessna 172N · S/N 17273998Built 1980 · Brewer Curtis EN5202FCessna 172F · S/N 17253189Built 1965 · United States Air Force (Owner)N52ZBell 206B · S/N 2251Southern Helicopter Service IncN54635Cessna 172P · S/N 17275018Built 1981 · Memphis Navy Flying ClubN58CRCessna 182T · S/N 18281544Built 2005 · 7192 Locke Road LLCN738NHCessna 172N · S/N 17270104Built 1978 · US Navy Commander Navy Installation CommandN75738Buckeye DREAM MACHINE · S/N 4097Built 1998 · Shoemaker James ON76654Cessna 120 · S/N 11094Pidgeon James EN7869NCessna R172E · S/N R172-0260Sale reportedBuilt 1967N7FSSmith Arthur Fox LONG EZ · S/N 387Built 1994 · Calvet David RN8413CPiper PA-28R-200 · S/N 28R-7635159Built 1976 · Brown Lawrence LN8509VBuckeye DREAM MACHINE · S/N 4066Built 1998 · Shoemaker James O'FarrellN9492BCessna 175 · S/N 55292Built 1958 · Pack Charles
Back to Millington, TN