OpenAirDocs.org
Topeka, KS

Registered aircraft · 137

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.

N319RMRuss Moore RANS S-21 OUTBOUND · S/N 08220283Built 2024 · Moore Russ AN33MGCessna 182M · S/N 18259660Built 1969 · Topeka Flyers IncN345VJDouglas DC3C · S/N 34378Built 1945 · Vaerus Jet Sales LLCN37642North American AT-6 · S/N 10560American Flight Museum IncN400BHRaytheon 400A · S/N RK-407Built 2005 · Bbh Partnership LLCN407BALet L 33 SOLO · S/N 020602American Flight MuseumN4097HMooney M20K · S/N 25-0416Built 1980 · 1234g LLCN416DSDiamond Aircraft Ind DA 40 · S/N 40.533Built 2005 · Mile High Club LcN418BEArbc Inc DBA Lindstrand 105A · S/N 5573Built 2014 · Wildtiger Aerosports LLCN4196BRaven S55A · S/N S55A-931Built 1982 · Costello Paul EN446BALet L 33 SOLO · S/N 030608American Flight MuseumN4526UCessna 150D · S/N 15060526Built 1964 · Drewelow Kevin RN45441Cameron Balloons US V-77 · S/N 5904Wildtiger Aerosports LLCN4751KPilatus PC-12/47E · S/N 1429Built 2013 · Bartlett & West IncN481MMRaytheon 400A · S/N RK-469Three Ninety LLCN4835ZBeech E50 · S/N LH185Built 1959 · Combat Air Museum IncN486GTGrumman S2F-1 · S/N 136486Built 1954 · Combat Air MuseumN4983RCessna 172H · S/N 17256337American Flight MuseumN5182FCessna 172F · S/N 17253116Built 1965 · American Flight Museum IncN5199YNanchang China YAK-18A · S/N 2432002Built 1968 · American Flight MuseumN51CBBellanca 8KCAB · S/N 297-77Built 1977 · Pukach Greg VN526BBeech A35 · S/N D-1541Built 1948 · Putnam Michael CN528NPCessna 310R · S/N 310R0976Technical Applications & Consulting LLCN5291NCessna 182Q · S/N 18267623Built 1980 · Jdb Aviation LLCN5335WPiper PA-28 · S/N 28-392Built 1962 · Post 8 Flight Ops IncN54654Beech D-45 · S/N BG-247American Flight MuseumN550KSTextron 525B · S/N 525B0715Built 2024 · Kansas Highway PatrolN5673NRaven Industries RX6 · S/N RX6-306Built 1978 · Hannibal Robert AN56ZZBeech T-34A · S/N G-798American Flight Museum IncN5755RCessna 172G · S/N 17253424Built 1965 · Eshbaugh Melvin LN59564Bell 206B · S/N 1389Sale reportedBuilt 1974N5SMMooney M20E · S/N 21-0051Built 1974 · Bearss Gordon MN600HPTextron 208B · S/N 208B5764Built 2023 · Kansas Highway PatrolN60130Cessna 150J · S/N 15070093Hoffman Matthew TN61684Cessna 172M · S/N 17264728Built 1975 · Odyssey Aircraft LLCN6237YCessna T210N · S/N 21064303Built 1981 · Strategic Sourcing Solutions IncN630MDCirrus Design SR22 · S/N 1269Built 2005 · Deh IncN64470Consolidated Vultee BT-13 · S/N 5142Built 1942 · Mcfall Robert Leroy TrusteeN650HPAirbus Helicopters AS350B3 · S/N 9397Built 2024 · Kansas Highway PatrolN65466Consolidated Vultee BT-15 · S/N 3192Built 1942 · Mcfall Robert Leroy TrusteeN6568QAlon A2 · S/N A-68Built 1965 · Laliberte George A TrusteeN6569UMooney M20C · S/N 2351Xidis Nicholas JN6589DNavion NAVION A · S/N NAV-4-1702American Flight MuseumN6668MStinson 108-3 · S/N 108-4668Registration pendingBuilt 1948N670HPAirbus Helicopters AS350B3 · S/N 9483Built 2024 · Kansas Highway PatrolN67XTWorld SPIRIT · S/N AA061115042Built 2013 · Alee-Jay Enterprises IncN710ZDouglas DC3C · S/N 32914Built 1944 · Combat Air Museum IncN72LBArbc Inc DBA Lindstrand 77A · S/N 5537Built 2013 · Sheehy DanielleN7331TCessna 172A · S/N 46931Rothenberger Stanley DN74018Cameron Balloons US O-84 · S/N 5114Built 1985 · Harrison Darrin C
Back to Topeka, KS