OpenAirDocs.org
Colby, KS

Registered aircraft · 31

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

N10YRCessna T206H · S/N T2068011Built 1999 · Aj Aviation LLCN13399Cessna 172M · S/N 17262729Built 1973 · Great Plains Spraying IncN1610FCessna 172H · S/N 17255005Built 1966 · Frahm Lon RN1620FDJI AGRAS T50 · S/N 1581F6BUB245Q001C58YFrahm Lon RN1651VCessna 120 · S/N 13823Built 1947 · Kistler Harvey SN176BKCessna 525B · S/N 525B0232Built 2008 · Wildcat Aviation LLCN1821ZCessna T182T · S/N T18208435Built 2005 · Tubbs George LN2160CCessna 195B · S/N 16145Built 1954 · Stephenson Stephanie VN217PFAmerican Champion 8KCAB · S/N 784-97Built 1997 · Bixenman Kenneth JN2202YPiper PA-28-236 · S/N 28-7911147Stanley Aviation LLCN230UAKansas State University DJI S900 · S/N 370050591Kansas State UniversityN2398VBeckley Chet RANS S-7 · S/N 0799273Beckley Chet RN2689JCessna T188C · S/N T18803497TBuilt 1979 · Finley Taylor JN2852NPilatus PC-12/47E · S/N 1075Built 2008 · Frahm Aviation LLCN3061NThrush S2R-G10 · S/N G10-174Built 2012 · Great Plains Spraying IncN3776LCessna 172G · S/N 17253945Built 1965 · Stramel Bert JonN3872RCessna 172H · S/N 17255372Built 1966 · S&Sa Aviation LLCN4104CStinson 108-3 · S/N 108-5104Built 1949 · Ostmeyer Mark GN415KSSchroeder Kriss S7S · S/N 1204387Built 2006 · Kls IncN42628Piper J3C-65 · S/N 14919Built 1945 · Bell Robert CN4858PCessna P210N · S/N P21000122Built 1978 · Great Plains Spraying IncN6133XAyres S2R-G10 · S/N G10-121Bixenman Colleen RN7364MCessna 175 · S/N 55664Built 1958 · Frahm Lon RN77202Cessna 140 · S/N 11664Built 1946 · Ostmeyer Mark GN777TVCessna 182Q · S/N 18265360Built 1977 · Top Ag IncN84MGNevada Flyboys LLP RV-10 · S/N 40854Built 2010 · Schroeder Mike JN8506QCessna TU206F · S/N U20603363Bell Robert CN93331Hickey Jerry E SLINGSHOT · S/N SS-022Built 2007 · Kistler Cory SN9534SChampion 7ECA · S/N 297Built 1965 · Ball Ronald CN97233Cessna 182Q · S/N 18267026Built 1979 · Frahm Lon RN98VJCub Crafters CC11-100 · S/N CC11-00085Built 2009 · Kistler Harvey S Trustee
Back to Colby, KS