OpenAirDocs.org
St Louis, MO

Registered aircraft · 24

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 = 'ST LOUIS'
  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.

N1521WBalloon Works FIREFLY 7 · S/N 11055Built 1981 · Mcnabb Donald IN30121Eaa BIPLANE · S/N 601Built 1968 · Jokerst KennethN309KBBombardier CL-600-2B16 · S/N 5418First renewal noticeBuilt 1999 · 1637 N Warson Aviation LLCN31692Dart GC · S/N 66First renewal noticeBuilt 1946 · Stix Albert I SrN316KDCirrus Design SR22T · S/N 10513Built 2025 · Rcjh7 LLCN398MECessna 182S · S/N 18280877Built 2000 · Desalvo DennisN4313HPiper PA-15 · S/N 15-97First renewal noticeBuilt 1948 · Stix Albert IN432SSPilatus PC-12/47E · S/N 2083Built 2021 · Ririe Holdings LLCN436WCurtiss Wright SEDAN 15-D · S/N 15C-2001First renewal noticeBuilt 1931 · Stix Albert I IIIN478MMRaytheon 390 · S/N RB-87Rhgoldeneye LLCN48587Ryan Aeronautical ST3KR · S/N 2073First renewal noticeBuilt 1942 · Stix Albert IN48FBDassault FALCON 2000 · S/N 11Built 1995 · Wkc CorpN543LBNorth American SNJ-5 · S/N 52017First renewal noticeBuilt 1959 · Stix Albert IN54681Raven S-60A · S/N S60A-112Built 1974 · Mcnabb Donald IN5521NBoeing B75N1 · S/N 75-7931Built 1943 · Stix AlbertN553PCPiper PA-44-180 · S/N 4496072Built 2001 · Saint Louis UniversityN556CECirrus Design SR22 · S/N 3653Built 2010 · St Patrick Reserves LLCN600DHEmbraer EMB-550 · S/N 55020258Built 2026 · Drury Development CorpN620PCDiamond Aircraft Ind DA20-C1 · S/N C0464Built 2007 · Saint Louis UniversityN7274RBeech V35B · S/N D-9721Built 1975 · Chastain Phillip LN8048QPiper PA-34-220T · S/N 34-8233064Wings Of HopeN9163TCessna T206H · S/N T20608975Built 2010 · Mcc Investments LLCN962VFairchild KR-21 · S/N 1053First renewal noticeBuilt 1929 · Stix Albert IN964KParks P-1 · S/N 198-16Parks College Of Saint Louis University
Back to St Louis, MO