OpenAirDocs.org
Parsons, KS

Registered aircraft · 38

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

N1146EAeronca 7AC · S/N 7AC4702Built 1946 · Mj Consulting IncN115BCRainbow Sky Reach BUSHCAT · S/N CH199CBuilt 2017 · Hochstedler Wilford LN134DDAviat A-1C-200 · S/N 3015Built 2008 · N134dd LLCN1485UCessna 172M · S/N 17267152Built 1976 · Class A Aviators IncN1595LBeech V35B · S/N D-9869Built 1976 · Clemens Jerry WN1680BLuscombe 11A · S/N 11-186Built 1948 · Pearce Rick AlanN21575Piper J3C-65 · S/N 2472Registration pendingBuilt 1938N228MAAustin Michael James KITFOX · S/N 228Brown Troy SN2540PPiper PA-22-150 · S/N 22-2903Built 1955 · Reed Michael DN28486Luscombe 8A · S/N 1353Built 1940 · Reed Michael DN3037WDJI AGRAS T50 · S/N 63YBLAW0020044Hochstedler WilfordN327LJAeroprakt Mfg SP Z O O A32 · S/N 086Built 2019 · Hochstedler Wilford LN36812Aeronca 65-TAC · S/N C1571TAAllen Walter DN3758XAero Commander 100-180 · S/N 5072Built 1968 · Steenrod Kenneth AlroyN3860XAero Commander 100 · S/N 155Built 1967 · Overall Aviators LLCN4100WXag P150 · S/N 186324P182235023RR10Hochstedler Wilford LN4106WDJI AGRAS T100 · S/N 1581F8ZLC25AU002982KHochstedler WilfordN4133WPiper PA-32-300 · S/N 32-40199Built 1967 · Hochstedler Wilford LN4152WDJI AGRAS T100 · S/N 1581F8ZLC2556002467PHochstedler WilfordN461EPRaytheon C90A · S/N LJ-1697Greenbush Seed & Supply IncN4777JBeech A23-19 · S/N MB-224Built 1967 · Howell Michael AN4885ZPiper PA-22-108 · S/N 22-8467Built 1961 · Reed Michael DN540PPiper PA-31-310 · S/N 31-65Steenrod Kenneth AN5505WPiper PA-28-160 · S/N 28-592Built 1962 · Perez Daniel EN5965PRicky A Pearce CHRISTAVIA MK4 · S/N 16Built 2018 · Pearce Ricky AN647UCDJI PHANTOM 3 ADVANCED · S/N P76DCD18010544Captain James GN6735WPiper PA-28-140 · S/N 28-20854Registration pendingBuilt 1965N675WHTalos Drones T60X · S/N 2104F7EZB251J001891BHochstedler WilfordN696TBTroy S Brown VANS ACFT INC RV-7 · S/N 73428Built 2019 · Brown Troy SN80211Pearce Rick A KOLB MARK 3 · S/N M304-3-00040Built 2006 · Pearce Rick AN811MPPearce Michael RANS S-12 · S/N 0293382Webb David CN85962Aeronca 11AC · S/N 11AC-380Perez Daniel EN8865UCessna 172F · S/N 17252780Registration pendingBuilt 1965N8976RG A Vanderheyden E A A MODEL P · S/N GGV 001Built 1979 · Steenrod Kenneth AllenN93BYChampion 7KCAB · S/N 129Built 1968 · Pearce Ricky AN9457UCessna 150M · S/N 15078405Built 1976 · Clemens Jerry WN9709DPiper PA-22-160 · S/N 22-6621Built 1959 · Pearce RickyN99WAAllen Walter D ARFRAMES UNLTD T-2 · S/N WA0001Allen Walter D
Back to Parsons, KS