OpenAirDocs.org
Kansas State University

Registered aircraft · 44

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

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_name = 'KANSAS STATE UNIVERSITY' OR list_contains(g.other_registrant_names, 'KANSAS STATE UNIVERSITY')
  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.

N1362YCessna 172C · S/N 17249062Built 1961 · Salina, KSN137MSBell 206B · S/N 2686Built 1979 · Salina, KSN1863WTextron 525B · S/N 525B0749Built 2025 · Salina, KSN230UAKansas State University DJI S900 · S/N 370050591Colby, KSN432MMMeyette Brian RV-7A · S/N 71008Salina, KSN50525Beech 65-A90 · S/N LJ159Salina, KSN5500WBellanca 8KCAB · S/N 432-78Built 1978 · Salina, KSN6010TCessna 162 · S/N 16200297Salina, KSN60669Cessna 162 · S/N 16200283Salina, KSN678WKDJI AGRAS T50 · S/N 1581F6BUB24850017PVHays, KSN802KSTextron 172S · S/N 172S13388Built 2025 · Salina, KSN803KSTextron 172S · S/N 172S13389Built 2025 · Salina, KSN804KSTextron 172S · S/N 172S13391Built 2025 · Salina, KSN805KSTextron 172S · S/N 172S13392Built 2025 · Salina, KSN816KSTextron 172S · S/N 172S13394Built 2025 · Salina, KSN835KSTextron 172S · S/N 172S12305Built 2019 · Salina, KSN836KSTextron 172S · S/N 172S12306Built 2019 · Salina, KSN836UPBeechcraft B300 · S/N FL-966Built 2014 · Salina, KSN837KSTextron 172S · S/N 172S12307Built 2019 · Salina, KSN838KSTextron 172S · S/N 172S12308Built 2019 · Salina, KSN839KSTextron 172S · S/N 172S12309Built 2019 · Salina, KSN840KSTextron 172S · S/N 172S12804Built 2022 · Salina, KSN841KSTextron 172S · S/N 172S12805Built 2022 · Salina, KSN842KSTextron 172S · S/N 172S12806Built 2022 · Salina, KSN843KSTextron 172S · S/N 172S12809Built 2022 · Salina, KSN844KSTextron 172S · S/N 172S12810Built 2022 · Salina, KSN846KSTextron 172S · S/N 172S12836Built 2022 · Salina, KSN847KSTextron 172S · S/N 172S12834Built 2022 · Salina, KSN848KSTextron 172S · S/N 172S12831Built 2022 · Salina, KSN849KSTextron 172S · S/N 172S12839Built 2022 · Salina, KSN852KSCirrus Design SR20 · S/N 2786Built 2021 · Salina, KSN853KSCirrus Design SR20 · S/N 8746Built 2022 · Salina, KSN854KSCirrus Design SR20 · S/N 8747Built 2022 · Salina, KSN855KSCirrus Design SR20 · S/N 8748Built 2022 · Salina, KSN856KSCirrus Design SR20 · S/N 8749Built 2022 · Salina, KSN860KSPiper PA-44-180 · S/N 4496572Built 2024 · Salina, KSN861KSPiper PA-44-180 · S/N 4496573Built 2024 · Salina, KSN862KSPiper PA-44-180 · S/N 4496586Built 2024 · Salina, KSN930KSSpektreworks COBALT 110G · S/N CB110-2B-1222-GVTOL-034Salina, KSN931KSSpektreworks COBALT 110G · S/N CB110-2B-1222-GVTOL-035Salina, KSN932KSHylio AG-272 · S/N 17906070251Salina, KSN933KSKansas State University TYRIAN · S/N TYRIAN-180Salina, KSN934KSKansas State University TYRIAN · S/N TYRIAN-182Salina, KSN935KSKansas State University TYRIAN · S/N TYRIAN-183Salina, KS
Back to Kansas State University