OpenAirDocs.org
Shawnee, KS

Registered aircraft · 59

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 = 'KS' AND g.registrant_city = 'SHAWNEE'
  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.

N106VPCessna 560 · S/N 560-0628Built 2002 · Team Aero LLCN138TAIsrael Aircraft Industries GULFSTREAM 200 · S/N 134Team Aero LLCN170RSCessna 170A · S/N 19611Built 1950 · Wilson Benjamin AN171TACessna 550 · S/N 550-0951Built 2000 · Team Aero LLCN197ECLearjet 45 · S/N 197Team Aero LLCN198RMCrawford William R CHALLENGER II · S/N CH21193-1051Thompson Matt WN2001BBeech V35 · S/N D-8216Built 1966 · Bangert Computer Systems IncN2286DLearjet 45 · S/N 2091Team Aero LLCN22900Cessna 150H · S/N 15068601Built 1968 · Swanton Jed MN232TACessna 650 · S/N 650-0128Aviation Trading Partners LLCN247CSRockwell International NA-265-65 · S/N 465-27Built 1994 · Team Aero LLCN269JASchweizer 269C · S/N S1914Built 2008 · Team Aero LLCN30851Cessna 177B · S/N 17701502Built 1970 · Cohorst Jason PN319PMRaytheon G36 · S/N E-3695Team Aero LLCN34413Cessna 177B · S/N 17701791Built 1972 · Mms Flight LLCN34570Aeronca 65-CA · S/N C15561Vintage Aircraft Association Chapter 16N3621EAeronca 7AC-CONV · S/N 7AC-6950Built 1947 · Combs Ryan DN402VRDJI AGRAS T40 · S/N 64TBKBL002003EVerdant LLCN404VRDJI AGRAS T40 · S/N 64TBKBL002001HVerdant LLCN405VRDJI AGRAS T50 · S/N 7TNBMDH00404VZVerdant LLCN406VRDJI AGRAS T40 · S/N 64TBL7N0020024Verdant LLCN408VRDJI AGRAS T40 · S/N 64TBL6C002009MVerdant LLCN4357TPiper PA-28-180 · S/N 28-7205151Built 1971 · Worth Rodney DN440TARaytheon 400A · S/N RK-353Team Aero LLCN4584SBeech A36 · S/N E-751Built 1975 · Ad Astra Aviation LLCN45RKBeech 400A · S/N RK-43Team Aero LLCN4682JPiper PA-28R-180 · S/N 28R-30561Built 1968 · Ahz Aviation LLCN475CWCessna 560XL · S/N 560-5080Built 2000 · Team Aero LLCN47DLEdson Dean T LANCAIR 360 · S/N 608-320-354Fairley Michael LN509DMHawker Beechcraft BAE 125-800B · S/N 258056Team Aero LLCN54TACessna 560XL · S/N 560-5128Team Aero LLCN564TACessna 560XL · S/N 560-5249Team Aero LLCN5683FAlon A2 · S/N A-183Brady Robert MN5799QMooney M20E · S/N 758Built 1965 · Hanson Bryan RN5844KBeech 35-C33 · S/N CD-923Built 1965 · Motion Marketing IncN60CLBeech A60 · S/N P-201Built 1972 · Jubjub LLCN60GWSmith AEROSTAR 600 · S/N 60-0030Built 1969 · Bangert Computer Systems IncN650CZCessna 650 · S/N 650-7050Built 1995 · Team Aero LLCN650TBeech 95 · S/N TD-125Built 1958 · Thompson MattN6651BDJI PHANTOM 3 PROFESSION · S/N P76DCH22010920Billquist Amy LN6656WBeech A36 · S/N E-2075Built 1983 · Bonanza Partners Of Kc LLCN71547Luscombe 8A · S/N 2974Pratt Adam DN717CHCessna 550 · S/N 550-0825Built 1997 · Aviation Trading Partners LLCN71TARaytheon 400A · S/N RK-272Built 2000 · Plane Holdings LLCN7230LJones Thomas L RV 6A · S/N 21785Built 1998 · Lee Patrick GN738MCCessna 172N · S/N 17270076Moore Michael EN752JCDassault-Breguet FALCON 50 · S/N 28Built 1980 · Team Aero LLCN7556JPiper PA-28R-180 · S/N 28R-30933Built 1968 · Kern Aviation LLCN762ACDiamond Aircraft Ind DA 62 · S/N 62.193Built 2022 · Alpha Charlie Aviation LLCN8242LPiper PA-28RT-201T · S/N 28R-8031148Built 1980 · Williams Daniel M
Back to Shawnee, KS