OpenAirDocs.org
Lees Summit, MO

Registered aircraft · 81

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 = 'LEES SUMMIT'
  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.

N1253YCessna LC41-550FG · S/N 411133Built 2009 · Sallee Real Estate Investments LLCN142LMGerman Lloyd P RV-10 · S/N 41420Built 2015 · Lamm Aviation LcN1452GBeech 35-B33 · S/N CD-449Built 1962 · Putnam Mitchell DN151WPGill William J RV-7 · S/N 71494Built 2007 · Gill William JN1550DBeech F33A · S/N CE-1317Built 1989 · Alexander Air Consulting LLCN165ACessna 182Q · S/N 18267062Built 1979 · Mitchell Flying Club IncN167JKKoser John F SONEX · S/N 0167Built 2002 · Rickard Larry LN1852ZSchmitt Robert F KR2-S · S/N 847Built 2006 · Schmitt Robert FN187PSPitts S-2A · S/N 2187Built 1979 · Morrissey John C ColN2211LBeech C23 · S/N M-1882Kemp JohnN221ACPiper PA-31-350 · S/N 31-8152045Built 1980 · Austen Air LLCN227DSBeech F50 · S/N FH-74Built 1957 · L & P Air LLCN2304DPiper PA46R-350T · S/N 4692154Built 2010 · Bb4 Leasing LLCN2328KPiper PA-38-112 · S/N 38-79A0577Williams Robert WN233CWCirrus Design SR22T · S/N 2218Built 2020 · Heiser Equipment Rental LLCN246ALBeech A36 · S/N E-1412Built 1978 · Airor LLCN249RThorp T-18 · S/N 06Built 1972 · Fields TravisN2628HEngineering & Research ERCOUPE 415-C · S/N 3253Built 1946 · Becquer JordanN26APCessna 550 · S/N 550-0824Built 1997 · Millennium International LLCN3127VBeech 35 · S/N D-552Built 1947 · Tyner Steven P TrusteeN3181EAeronca 11AC · S/N 11AC-1522Wainwright Carter TN335JCCessna 172 · S/N 28785Built 1956 · Alexander Melodie AN339VRVashon RANGER R7 · S/N 10190Built 2022 · Tepper BrianN346KCessna 172R · S/N 17280064Built 1997 · Mitchell Flying Club IncN34PABeech A45 · S/N G-268Built 1955 · Cosentino William DN3768RCessna 172H · S/N 17255568Built 1966 · Stretz Scott PN3910MPiper PA-12 · S/N 12-2808Built 1947 · Hodges Larry WN4090QPiper PA-28-161 · S/N 28-7716171Wieczorek AlanN4336DPiper PA-32-301 · S/N 32-8406006Built 1983 · Wing Flying ClubN4339DPascoe Richard L PASCOE RV4 · S/N 2391Built 1992 · Sterk Ashton DN4397XPiper PA-28-151 · S/N 28-7615004C & D Media LLCN4437LCessna 172G · S/N 17254528Built 1966 · Thomas JohnN444MAUnderwood Harold THORP S-18 · S/N 1HUBuilt 2002 · First Order Aeronautics LLCN44GZBeech F33A · S/N CE1725Built 1993 · Opdahl Kirk JN464MSSchulze Michael F RV4 · S/N 1Built 2004 · Schulze Michael FN4667HMooney M20J · S/N 24-0845Built 1979 · Amazn Leasn IncN466PSDiamond Aircraft Ind DA 40 · S/N 40.464Residential Engineering Services LLCN47012Ryan Aeronautical ST3KR · S/N 1685Williams Robert WN475XPRaytheon 400A · S/N RK-475Built 2006 · L And P Air 1 LLCN479DRBeech 400A · S/N RK-61Built 1993 · L And P Air LLCN513RJEverett Elmo RV 6A · S/N 23922Built 1997 · Gurski Robert CN515FARainbow Skyreach BUSHCAT · S/N CH246CBuilt 2023 · Cortina Federico FN516TLSunderland Talbert B RV-7A · S/N 72467Built 2009 · Sunderland Talbert BN523HBMD Helicopters 500N · S/N LN105Built 2007 · Crg2 LLCN5321XNorth American T-28C · S/N 140542Built 1956 · L And P Air LLCN53236Cessna 172P · S/N 17274709Built 1981 · Principles Of Flight Training LLCN53LWLamb Phillip D RV-8 · S/N 82126Built 2009 · N53lw LLCN5434KCessna 560XL · S/N 560-5345Built 2003 · Kowalik Raymond J TrusteeN555ALRaytheon B300 · S/N FL-360Mcgraw Aviation LLCN558JVetterman Larry D RV-4 · S/N 706Built 1985 · Richley Robert C
Back to Lees Summit, MO