OpenAirDocs.org
Derby, KS

Registered aircraft · 70

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

N10820Cessna 150L · S/N 15075062Built 1973 · Wojteczko Jason AN1130CPiper PA-22-135 · S/N 22-965Built 1953 · Law David LN17CWAviation Education SONERAI 1 · S/N 3CW-5Built 1977 · Rundel SteveN184SSBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 5532SBuilt 1981 · Chilcott Bret AN2007VTextron 182T · S/N 18283338Built 2026 · Compass Rose Aviation LLCN211BACessna 172N · S/N 17270071Built 1977 · Wojteczko Jason AN231BGMooney M20K · S/N 25-0015Built 1978 · Wojteczko Jason AN2336GCessna 182B · S/N 51636Logue Elmer SN2399HPiper PA-18-150 · S/N 18-7909180Built 1979 · Applegate Crist AmberN2746SCessna 150G · S/N 15066646Built 1967 · Bryant Stan MN2810DRaven S55A · S/N S55A-1103Irvin Ronald LN3025KPiper PA-28RT-201 · S/N 28R-7918023Built 1978 · Wojteczko Jason AN3165MMooney Collin E CHALLENGER II · S/N CH2-1000-2018Built 2002 · Kellogg S AndrewN3418GCessna 310R · S/N 310R0826Built 1976 · Oppermann William AN3549SCessna 172E · S/N 17250749Built 1963 · Schott Roy WN356DHTextron 182T · S/N 18283356Built 2026 · Compass Rose Aviation LLCN3712QBeech 35-C33A · S/N CE-133Built 1966 · Thomas Gregory O TrusteeN3770Bellanca 8KCAB · S/N 204-75Joebravo Aviation LLCN4066BKuipers Abram VANS RV6 · S/N 23198Built 2007 · Kuipers Abram BN4150SBeech F33A · S/N CE-566Built 1975 · Dirks Ricky BN42855Cessna 182L · S/N 18259216Wojteczko Jason AN435TACessna 182T · S/N 18281035Built 2001 · Panther Med LLCN4497KRyan NAVION · S/N NAV-4-1497Built 1948 · York James BN458LBBeedy Lyle G RV-6 · S/N 20695Built 2011 · Beedy Lyle GN4608NStinson VULTEE V-77 · S/N 77-197Built 1943 · Chilcott BretN469DCCessna 182Q · S/N 18266646Built 1979 · Law David LN47986Fairchild M-62A · S/N T42-3157Daniel Hardy L JrN48047Fairchild M-62A · S/N 6803AEDaniel Hardy L JrN4949NCessna 182Q · S/N 18267474Built 1979 · Compass Rose AviationN5059BBeech F35 · S/N D-4266Built 1955 · Mcleod LeeN5123MTaylorcraft BC12-D · S/N 10423Built 1946 · Hershberger Anthony MN53760Taylorcraft DCO-65 · S/N 5496Built 1943 · Miller Rodger FN53765Taylorcraft DCO-65 · S/N 5231Built 1959 · Miller Rodger FN5935PPiper PA-24 · S/N 24-1025Built 1959 · Daniel Hardy L JrN5940ECessna 150 · S/N 17440Built 1959 · Horton BillN59597Fairchild M-62A · S/N T43-5831Daniel Hardy LN60051Textron 182T · S/N 18283355Built 2026 · Compass Rose Aviation LLCN6005STextron 182T · S/N 18283354Built 2026 · Compass Rose Aviation LLCN60860Cessna 150J · S/N 15070627Built 1969 · Joebravo Aviation LLCN609MJArcher-Zenith ZODIAC CH 601 XL · S/N 5745Built 2008 · Archer Matthew WN61012Fairchild M-62A · S/N 9714AEDaniel Hardy LN6175XFairchild M-62A · S/N T42-1389Daniel Hardy L JrN6205ECessna 172 · S/N 46305Built 1958 · Mcwilliams Michael WN6220ECessna 172 · S/N 46320Built 1958 · Stoudt Kristen DN6220NCessna 182R · S/N 18267803Built 1980 · Schmidt Paul DN6268NCessna 182R · S/N 18267814Built 1981 · Compass Rose AviationN6325CPiper PA-28R-201T · S/N 28R-7803220Built 1978 · Curtis Aviation LLCN6596WPiper PA-28-140 · S/N 28-20686Built 1965 · N6596w LLCN6654HCessna 172M · S/N 17265525Built 1975 · Bertapelle Joseph RN66LCBeech A36 · S/N E-1050Built 1977 · Business Jet Consultants LLC
Back to Derby, KS