OpenAirDocs.org
Saint Louis, MO

Registered aircraft · 318

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

N100GKCessna T210L · S/N 210-59905Built 1973 · Lewis David BN102DSCessna 510 · S/N 510-0095Built 2008 · Maria Squared Aviation LLCN102DVBurkhart Grob Flugzeugbau G102 STANDARD III · S/N 5641SSaint Louis Soaring AssociationN107GCYakovlev YAK 52 · S/N 833800Built 1983 · Historic Aircraft Restoration MuseumN1096Heimberger Robert J MAGNI M16 PLUS · S/N 16202526Built 2020 · Heimberger Robert JN115DDRobinson Helicopter R22 BETA · S/N 3494Ded Aviation LLCN1173AMooney M20J · S/N 24-1333Built 1982 · Pouk Douglas AN119VMonocoupe 90 · S/N 628First renewal noticeBuilt 1932 · Historic Aircraft Restoration MuseumN119WJCirrus Design SR22 · S/N 3978Lauber Land Developers LLCN11VGBeech V35B · S/N D-9891Built 1976 · Sage Aviation LLCN1205MDassault FALCON 2000EX · S/N 359Built 2019 · Rex Industrial CorpN120JCBombardier BD-100-1A10 · S/N 20069Built 2005 · Southwestern Jet IncN122ERCessna 525B · S/N 525B0030Built 2005 · Advisors Aviation LLCN122THEurocopter COLIBRI EC 120B · S/N 1017Built 1998 · Mwn Holdings LLCN124FRCessna 172N · S/N 17273814Built 1980 · Lauber Ronald JN125DAAirbus Helicopters AS350B3 · S/N 9154Built 2022 · Payne David L TrusteeN12WBCirrus Design SR22 · S/N 9981Built 2024 · Old Man Aviation LLCN13009Cessna 172M · S/N 17262442Built 1973 · Laffey Joseph CN131UAmerican General Acft AG5B · S/N 10163Built 1993 · Crawford Edward J DBAN136CAConvair 440 · S/N 400Aviation Business CorpN138VAPiper PA-28-181 · S/N 28020112Built 2023 · Mysky LLCN13904Piper PA-18-150 · S/N 18-8970Built 1971 · St Louis Soaring Assoc IncN142DHPegasus SUPER SPORT · S/N 7717Built 2000 · Brown Timothy RN150MBBombardier BD-100-1A10 · S/N 20166Built 2007 · W5 Equipment Leasing LLCN151SSBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1501Built 1977 · St Louis Soaring Association IncN1525Aero Commander 685 · S/N 12022Built 1973 · Aviaton Business CorporationN1579QCessna 150L · S/N 15072879Built 1971 · Chastain Elizabeth AN157CWIniziative Industriali Italian SKY ARROW 650TCN · S/N CN001Ford JeremyN1611NFunk B85C · S/N 411First renewal noticeBuilt 1947 · Historic Aircraft Restoration MuseumN164RWCubcrafters CC11-160 · S/N CC11-00217Built 2012 · Big Blessing LLCN166EGArthur E Graves ZENITH STOL CH750 · S/N 75-10840Built 2022 · Graves Arthur EN17ASGlasflugel STD LIBELLE 201B · S/N 419Built 1973 · Marcus Barry AN180NGPilatus PC-12/47E · S/N 1800Cwa LLCN184HJHonda HA-420 · S/N 42000184Built 2020 · Tpc Aviation LLCN1852HCessna 310C · S/N 35952Built 1959 · I Fly Stl LLCN18642Monocoupe 110 · S/N 6W53First renewal noticeBuilt 1933 · Historic Aircraft Restoration MuseumN1878CLearjet 45 · S/N 519Built 2015 · Caleres IncN1927Driggs DART II · S/N 6First renewal noticeBuilt 1927 · Historic Aircraft Restoration MuseumN193KCCirrus Design SR22 · S/N 8857Built 2022 · Big Blessing II LLCN1981HPiper PA-32-260 · S/N 32-7700013Registration pendingBuilt 1977N19JNSchleicher ASW-19B · S/N 19294Built 1979 · Brannan Patrick SN1AWBeech N35 · S/N D-6617Built 1960 · Koedam Robert EN1YZL-Bird CCX-2000 · S/N CCX-2000-0016Built 2017 · Skyworks LLCN201TTMooney M20J · S/N 24-0235Built 1977 · Moore James RyanN203ASYakovlev YAK 52 · S/N 867207First renewal noticeBuilt 1986 · Historic Aircraft Restoration MuseumN2045BLuscombe 8F · S/N 6472Built 1948 · Hearst Jeffrey AN206FSIai GULFSTREAM G280 · S/N 2198Built 2019 · Commerce BankN206JACessna 206H · S/N 20608014Built 1999 · Fabick John DN2071PPiper PA-23 · S/N 23-658Built 1956 · Aviation Business CorpN210SWCessna 210L · S/N 21061068Built 1975 · Sierra Whiskey Aircraft LLC
Back to Saint Louis, MO