OpenAirDocs.org
Memphis, MO

Registered aircraft · 18

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

N2199UCessna A188A · S/N 18800799Wood James DBAN244LAAir Tractor AT-602 · S/N 602-1244Built 2014 · Woodline Aviation LLCN26109Piper J3C-65 · S/N 4046Built 1939 · Martin Devon RN26868Piper J3C-65 · S/N 4252Built 1941 · Musser Alvin M JrN4412QCessna A188A · S/N 18800812Built 1971 · Woods Flying Service LLCN446SDGteex Revolution INDEPENDENCE 19 · S/N 212985300C6F4Superior Drone LLCN4627HPiper PA-17 · S/N 17-42Built 1948 · Martin Devon RN5738BPheasant H-10 · S/N 118Built 2004 · Scotland County Historical SocietyN602DAAir Tractor AT-602 · S/N 602-1230Built 2013 · Woodline Aviation LLCN6385HBellanca 17-30 · S/N 30104Eds Used Machinery LLCN6408ECessna 172 · S/N 46508Built 1959 · Morgan Lloyd JN6970XCessna 172B · S/N 17247870Built 1960 · 4 Generation Aviation LLCN7014UPowrachute PEGASUS · S/N A264 PEGBuilt 2003 · Howard Dennis VN75298Piper PA-32R-300 · S/N 32R-7680287Registration pendingN83282Aeronca 7AC · S/N 7AC1949Registration revokedBuilt 1946 · Orton EdsonN8530NPiper PA-28-235 · S/N 28-11329Built 1969 · Good Curvin MN95376Piper PA-28-140 · S/N 28-25905Built 1969 · Team K Outfitters LLCN9841MMaule M-4C · S/N 3CBuilt 1966 · Musser Alvin M Jr
Back to Memphis, MO