OpenAirDocs.org
Johnson, KS

Registered aircraft · 45

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

N111MSBeech V35 · S/N D-8249Built 1966 · Mid America Sprayers IncN11HTBeech V35 · S/N D-8534Built 1967 · Jet X Leasing IncN1221CCubcrafters CC11-160 · S/N CC11-00394Built 2015 · Ac Ag Management LLCN126FThrash Frank J SA100 · S/N 1Built 1967 · Gerard Luke TN1353SCessna 182P · S/N 18264916Herrick Kendall DN1535SBeech P35 · S/N D-6982Built 1962 · Gerard Aircraft IncN182GRCessna 182R · S/N 18268120Built 1981 · Senestraro Daniel E TrusteeN1QYBeech 35-B33 · S/N CD-798Built 1964 · Jet X Leasing IncN1UZBeech S35 · S/N D-7420Built 1964 · Jet X Leasing IncN1VXSmith Mike XP-99 · S/N 001Built 1982 · Mid America Sprayers IncN2007TCessna 182K · S/N 18258171Winger Raymond EN234SSCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 08SC115Built 2008 · Ace Drilling LLCN23AZCessna A185F · S/N 18502499Built 1974 · Nix Jacob DBAN2474LEa Vision EA J100 · S/N EAVUAV5025863134l Farms LLCN250KSAerospatiale GAZELLE SA341F2 · S/N 1598Built 1977 · Kramer EricN3082XPiper PA-18-150 · S/N 18-4668Built 1957 · Jet X Leasing IncN3365SCessna 210J · S/N 21059165Built 1969 · Winger Cattle Co IncN359VFPilatus PC-12/47E · S/N 1359Built 2012 · Legacy Air LLCN3707QBeech V35 · S/N D-8368Built 1966 · Troutman ShaunN38338Piper PA-32R-300 · S/N 32R-7780416Built 1977 · Rafter W Ranches LLCN4059SBeech V35B · S/N D-9705Built 1974 · Kramer Harvesting LLCN456RWCessna 140A · S/N 15550Built 1950 · Wenman Bradford HN459ETTerhune Thomas A LONG EZ · S/N 1686Built 1990 · Gerard Luke TN46234Ryan Aeronautical ST3KR · S/N 1074Built 1941 · Kendrick Bret AN4689XCessna 150G · S/N 15064739Built 1966 · Gerard Aircraft IncN49SWWesley C Nelson PATRIOT · S/N 010Nelson Wesley CN514SBWsk-Pzl-Mielec TS-11 ISKRA · S/N IH-0514Built 1970 · Troutman Shaun LN5684PPiper PA-24-250 · S/N 24-756Built 1959 · Ace Drilling LLCN582SAPowrachute PC 2000 · S/N A215POWArnold StevenN5QEAirnew QUESTAIR VENTURE · S/N 15Troutman Shawn LN61948Cessna T206H · S/N T20608868Built 2008 · Ac Ag Management LLCN627PAPiper PA 46-350P · S/N 4636627Built 2014 · Big Sky Leasing LLCN6931TBeech A36 · S/N E-2167Built 1984 · Smith John DN758TYCessna R172K · S/N R17233585 Star FarmsN761ANCessna 210M · S/N 21062103Built 1977 · Winger Cattle Company IncN814SWCessna 340 · S/N 340-0197Wenman Bradford HarrisN822Mid America Sprayers/Smith M 20 · S/N 007Built 1994 · Troutman Shaun LN8471DPiper PA-32R-301T · S/N 32R-8229013Built 1981 · Ace Drilling LLCN8KXBacon Roger D QUESTAIR #20 VENTURE · S/N 37Built 1992 · Troutman Shaun LN9144XCessna 182D · S/N 18253544Built 1961 · Winsome Ag Services LLCN96938Taylorcraft BC12-D · S/N 9238Built 1946 · Roark William MN9885VCessna 172M · S/N 17264547Built 1974 · Nix Jacob DBAN98EJBreiter-Bakken VARIEZE · S/N 953Gerard Luke TN9927TCessna 182D · S/N 18253027Built 1960 · Hauser Thomas RN9MSMsa MS 46 TP · S/N 001Modification Specialists LLC
Back to Johnson, KS