OpenAirDocs.org
Chesterfield, MO

Registered aircraft · 136

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

N10136Cessna 150L · S/N 15074803Built 1973 · Rowe MichaelN101KFBombardier CL-600-2B16 · S/N 5564Travers 6 LLCN104PJKoo Carlos Chang LANCAIR IV-P · S/N LIV-491St Louis Sports Car Company IncN110EXDassault FALCON 900 EX · S/N 71Built 2000 · Km 900 LLCN111WCCwian Walter D RV-8 · S/N 429Built 1999 · N111wc LLCN1194HPiper PA-28R-201T · S/N 28R-7703016Crnic Paul CN11CKKing Charles R CHRISTEN EAGLE II · S/N KING0001Built 1981 · Eagle Aeroworks LLCN12076Aero Vodochody L39C · S/N 432927Built 1984 · Jetstar LLCN12549Cessna 550 · S/N 550-0501Surdex CorpN136TTCessna LC41-550FG · S/N 411161Built 2010 · Tyulyaev Vitaly NN140CCessna 140 · S/N 12501Wind Paul KN1544CCessna 172S · S/N 172S8365Built 2000 · Elite Approach LLCN157XLCessna 560XL · S/N 560-6157Built 2013 · Frontenac Properties IncN166BBeech G33 · S/N CD-1293Built 1972 · Wings Of Hope IncN1695WBeech V35B · S/N D-9393Built 1972 · Von Seggern Robert JN173SDAmerican Champion 8KCAB · S/N 1108-2011Built 2011 · Mountain Aerobatics LLCN176USHawker Beechcraft HAWKER 900XP · S/N HA-0029Built 2007 · Jd76 Air LLCN185TSCessna A185F · S/N 18504245Parks Timothy RN1860HPiper PA-32-300 · S/N 32-7740043Built 1977 · Nighthawks Sanity LLCN200LAviat A-1C-200 · S/N 3154Built 2012 · Huskys LLCN206KYCessna U206B · S/N U206-0676Built 1966 · Wings Of HopeN2071MPiper PA-28R-201 · S/N 28R-7837064Built 1977 · Budd Aircraft Enterprises IncN209HPHawker Beechcraft HAWKER 750 · S/N HB-26Built 2008 · Edison Acquisitions LLCN20DUSocata TB 10 · S/N 529Built 1985 · Wings Of HopeN214KPRaytheon 58 · S/N TH-1894Built 1999 · Bnb Aviation LLCN223SCCessna TU206F · S/N U20601999Built 1973 · Surdex CorpN2245UPiper PA-28-161 · S/N 28-7916133Built 1979 · Farris Gregory AN226CWCirrus Design SF50 · S/N 0744Built 2026 · Spirit Vision Jet LLCN2279NCessna 120 · S/N 12519Built 1947 · Bunnell Dale LN22TUWilliam Edward Warren XET MESQUITOE · S/N MXE1335F18BBuilt 2019 · Murphy John R TrusteeN24783Cessna 172R · S/N 17281029Built 2001 · Elite Approach LLCN2557UCessna 172D · S/N 17250157Built 1963 · Wings Of HopeN2673TPiper PA-28-235 · S/N 28-E11Built 1972 · Zweig William DN270CLCessna 208B · S/N 208B0232Registration pendingBuilt 1990N27GHTextron 182T · S/N 18283019Built 2017 · Nelson Aviation LLCN2NLDassault FALCON 900EX · S/N 017Built 1997 · Centurion Investments IncN2NQCessna 441 · S/N 441-0307Built 1982 · Surdex CorpN30546Cessna 177A · S/N 17701318Built 1968 · Brady Dennis J JrN305RSCessna 172S · S/N 172S8834Built 2001 · Elite Approach LLCN30FKVoice Of Victory VANS RV7A · S/N 73331Built 2012 · N30fk LLCN30GHRaytheon G36 · S/N E-3761Built 2007 · Avientur LLCN30TLCessna 172S · S/N 172S10183Built 2006 · Elite Approach LLCN311BLCubcrafters CC11-160 · S/N CC11-00370Built 2015 · N311bl LLCN314SJDassault MYSTERE FALCON 900 · S/N 115Built 1992 · Hrm Aviation LLCN3191UCessna 182F · S/N 18254591Built 1963 · Wings Of HopeN31AWCessna 414 · S/N 414-0803Built 1975 · Restoration DentalN320MAAviat A-1B · S/N 2147Built 2001 · Mist Air LLCN3252KGlobe GC-1B · S/N 1245Built 1946 · Crnic Paul CN334WCessna U206F · S/N U20603331Built 1976 · Centurion Investments Inc DBAN33KDWaco YMF · S/N F5-003Built 1986 · Crnic Paul C
Back to Chesterfield, MO