OpenAirDocs.org
Memphis, TN

Registered aircraft · 1,014

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

N101FEBoeing 767-3S2F · S/N 42706Built 2013 · Federal Express CorpN102DWCirrus Design SR22 · S/N 1750Built 2006 · Flyboy Aviation LLCN102FEBoeing 767-3S2F · S/N 42707Built 2013 · Federal Express CorpN103FEBoeing 767-3S2F · S/N 43544Built 2013 · Federal Express CorpN104FEBoeing 767-3S2F · S/N 42708Federal Express CorpN105FEBoeing 767-300F · S/N 64055Built 2019 · Federal Express CorpN106FEBoeing 767-3S2F · S/N 42709Built 2014 · Federal Express CorpN107FEBoeing 767-3S2F · S/N 44377Built 2014 · Federal Express CorpN108FEBoeing 767-3S2F · S/N 44378Built 2014 · Federal Express CorpN109ATPiper PA-32-300 · S/N 32-7540042Built 1974 · Aguillard Robert NN109FEBoeing 767-3S2F · S/N 42710Built 2014 · Federal Express CorpN109SBeech 95 · S/N TD-140Built 1958 · Greenair CorpN10SEBombardier BD-100-1A10 · S/N 20973Built 2023 · Radair LLCN110FEBoeing 767-3S2F · S/N 43542Built 2014 · Federal Express CorpN111FEBoeing 767-300F · S/N 64060Built 2020 · Federal Express CorpN112FEBoeing 767-3S2F · S/N 43543Built 2015 · Federal Express CorpN1132TBeech B-55 · S/N TC-1962Built 1976 · Peck Russell CN113FEBoeing 767-3S2F · S/N 42711Built 2015 · Federal Express CorpN114FEBoeing 767-3S2F · S/N 42712Built 2015 · Federal Express CorpN115FEBoeing 767-3S2F · S/N 42713Built 2015 · Federal Express CorpN117FEBoeing 767-3S2F · S/N 44379Built 2015 · Federal Express CorpN118FEBoeing 767-3S2F · S/N 42714Built 2015 · Federal Express CorpN1190ZAmerican General Acft AG5B · S/N 10012Double L Auto Sales LLCN119FEBoeing 767-300F · S/N 64057Built 2019 · Federal Express CorpN120FEBoeing 767-3S2F · S/N 44380Built 2015 · Federal Express CorporationN121FEBoeing 767-3S2F · S/N 43545Built 2015 · Federal Express CorpN122FEBoeing 767-3S2F · S/N 42715Built 2015 · Federal Express CorpN123FEBoeing 767-3S2F · S/N 42716Built 2015 · Federal Express CorpN124FEBoeing 767-3S2F · S/N 43546Built 2015 · Federal Express CorpN125FEBoeing 767-3S2F · S/N 42717Built 2015 · Federal Express CorpN126FEBoeing 767-3S2F · S/N 42718Built 2015 · Federal Express CorpN127FEBoeing 767-3S2F · S/N 43547Built 2015 · Federal Express CorpN128FEBoeing 767-3S2F · S/N 42719Built 2015 · Federal Express CorpN129FEBoeing 767-3S2F · S/N 43548Built 2015 · Federal Express CorpN12FDBombardier CL-600-2B16 · S/N 6121Built 2018 · N12fd LLCN130FEBoeing 767-3S2F · S/N 42720Built 2016 · Federal Express CorpN131FEBoeing 767-3S2F · S/N 61205Built 2016 · Federal Express CorpN131KRBombardier BD-100-1A10 · S/N 20855Built 2020 · Str Holdings LLCN132FEBoeing 767-3S2F · S/N 42721Built 2016 · Federal Express CorpN1330WMooney M20E · S/N 218Built 1963 · Pepke MarkN133FEBoeing 767-3S2F · S/N 43549Built 2016 · Federal Express CorpN134FEBoeing 767-3S2F · S/N 43550Built 2016 · Federal Express CorpN135FEBoeing 767-3S2F · S/N 42722Built 2016 · Federal Express CorpN136FEBoeing 767-300F · S/N 64058Built 2019 · Federal Express CorpN137FEBoeing 767-3S2F · S/N 61206Built 2016 · Federal Express CorpN138FEBoeing 767-300F · S/N 42723Built 2016 · Federal Express CorpN139FEBoeing 767-300F · S/N 43538Built 2016 · Federal Express CorpN140FEBoeing 767-300F · S/N 43541Built 2016 · Federal Express CorpN141FEBoeing 767-300F · S/N 42724Built 2016 · Federal Express CorpN142FEBoeing 767-300F · S/N 42725Built 2016 · Federal Express Corp
Back to Memphis, TN