OpenAirDocs.org
Topeka, KS

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

N101JNRowley-Curtiss JN4D2 REPLICA · S/N R101Built 1969 · Combat Air MuseumN1029GGiroux Guy AIR CAM · S/N AC-060Built 2001 · Giroux Guy MN1139QS C Aerostar S A YAK-52 · S/N 833713Built 1983 · American Flight MuseumN118JRJoy Ride STRATMAN-VANS RV-8 · S/N 81183Jrs Equity LLCN1214TPiper PA-28-180 · S/N 28-7205268Built 1972 · Post 8 Flight Opps IncN122DQCassutt III M · S/N 589-12Built 1981 · Oliver Taylor RN124KUDestiny Powered Parachutes DESTINY XLT · S/N 2C0352RWBBuilt 2001 · Latimer James AN1324YCessna 172C · S/N 17249024Built 1961 · Ruoff Timothy DN1418Meek David S SUN DEVIL · S/N DSM IIBuilt 1985 · Meek Rodney BN143TCCessna 210-5 · S/N 205-0064Built 1962 · Harris William DN15784Meyers OTW · S/N 1Built 1935 · Combat Air Museum IncN15YYMikoyan MIG-15BIS · S/N 1B01016Built 1955 · Combat Air Museum IncN163GDSmith Gregory H PULSAR 582 · S/N 157Built 1995 · Smith Gregory HN170PRyan Aeronautical ST3KR · S/N 1566Pt-22 IncN1818JPiper PA-28-140 · S/N 28-24248Built 1968 · Davey Aaron AN1893NLearjet 45 · S/N 172Built 2001 · Newcomer Leasing LLCN2041LBeech C23 · S/N M-1849Built 1976 · Slik Air LLCN2051LBeech B24R · S/N MC-436Built 1976 · Parker Joyce AN208EKCessna 208B · S/N 208B1015Built 2003 · Technical Applications & Consulting LLCN2097ZCessna 150C · S/N 15059897Built 1963 · Schieferecke JeanineN212DPNorth American T-28A · S/N 49-1616Built 1949 · American Flight Museum IncN2203BFirefly Balloons FIREFLY 7B-15 · S/N F7B-2009Goodnow Connie RN2210VFirefly Balloons FIREFLY 8B-15 · S/N F8B-2053Built 2003 · Crabtree Elliott SN222RGBeech 58 · S/N TH-1698Built 1994 · Vaerus Jet Sales LLCN2232GCessna 182A · S/N 51532Bigler MarkN2266LPutnam Michael Charles CASSUTT SPORT · S/N 1Putnam Michael CN233RJJohnson Richard Lee JOHNSON-HATZ CB-1 · S/N 233Johnson Richard LeeN24167Funk B75L · S/N 193Laible Lawrence SrN241KSCessna 172M · S/N 17262602Built 1973 · Crane Kermit JN245AEBombardier BD-100-1A10 · S/N 20245Built 2008 · N318mm LLCN246TFCessna TR182 · S/N R18201677Morgan Daniel DN2495LDestiny Powered Parachute BLUE 2000 · S/N 1C0249Built 2003 · Mohler Dennis EN2503KLuscombe 8E · S/N 5230Built 1947 · Mcfall Robert Leroy TrusteeN250CWCessna 182R · S/N 18268273Built 1982 · 250 Charlie Whiskey LLCN2588GBalloon Works FIREFLY 7-15 · S/N F7-868Goodnow Tony AN25966Balloon Works FIREFLY 7-15 · S/N F7-855Emerson Sterling LN259PCPilatus PC-12/47E · S/N 1259Built 2010 · New Mfis Holdings LLCN277KEPilatus PC-24 · S/N 257Built 2022 · Klaton Transportation LLCN2805JDouglas DC3C-R-1830-90C · S/N 20835Built 1944 · American Flight Museum IncN292EWBalloon Works FIREFLY 7 · S/N F7-294Carlson Emily KN294CHCanadian Car & Foundry HARVARD MK IV · S/N CCF-4-85Built 1947 · Combat Air Museum IncN3011YCessna 182E · S/N 18254011Built 1962 · Strategic Sourcing Solutions IncN3018KLindstrand Balloons 90A · S/N 5094Built 1999 · Harrison Darrin CN307WPPilatus PC-12/45 · S/N 297Built 1999 · Ag Transit LLCN311TLCessna 182R · S/N 18267937Built 1981 · M & N Enterprises LLCN3150NCessna 140 · S/N 13408Built 1947 · Putnam Michael CN3171LBalloon Works FIREFLY 8B-15 · S/N F8B-493Built 1996 · Goodnow Tony AN318KSRaytheon 400A · S/N RK191Built 1998 · Vaerus Jet Sales LLCN319RMRuss Moore RANS S-21 OUTBOUND · S/N 08220283Built 2024 · Moore Russ AN33MGCessna 182M · S/N 18259660Built 1969 · Topeka Flyers Inc
Back to Topeka, KS