OpenAirDocs.org
Kingfisher, OK

Registered aircraft · 27

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 = 'OK' AND g.registrant_city = 'KINGFISHER'
  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.

N106GGHoward DGA-15P · S/N 760Built 1943 · Grubb Gary GN114TTDinsmore TORNADO · S/N T92503COHK0040Built 1995 · Pyle Lester DN140FBDitlow VANS ACFT INC RV-8 · S/N 83444Built 2015 · Ditlow LLCN188MSShanklin Max RV10 · S/N 40162Built 2008 · Forman And Forman Aviation LLCN1942WStinson VULTEE V-77 · S/N 77-307Hangar 10 Flying MuseumN1TJCompagnie Daher TBM 700 · S/N 1338Cowboy Air LLCN2070BLuscombe 8E · S/N 6497Built 1948 · Gilbert Jill WN2194VCessna 140 · S/N 14423Built 1948 · Ditlow LLCN302JDCirrus Design SR22T · S/N 10423Built 2025 · Neoair LLCN344CKarber Harold CLASSIC · S/N C052Karber HaroldN3575UPiper PA-28-181 · S/N 28-8090198Built 1979 · J P Aviation LLCN39844Bellanca 17-30A · S/N 73-30513Built 1972 · Aero-Spray IncN4152XRockwell International S-2R · S/N 1928RBuilt 1974 · Aero Spray IncN4499GQuad City Ultralight Acft LIGHT SPORT SPECIAL · S/N CH2-1206-LSS-0109First renewal noticePyle Lester DN455MVCirrus Design SR22 · S/N 4307Built 2016 · Grand Sierra Investments LLCN4570DBeech G35 · S/N D-4735Built 1956 · Espolt Steven RN4896KCessna P210N · S/N P21000358Built 1979 · Braxtal LLCN516LDDavis Martin A CHALLENGER II · S/N CH2-0210-LSS-0168Built 2011 · Pyle Lester DN637JMMcfadden John P JR MUSTANG II · S/N 9701Karber Harold DN65327James A Benton EXCALIBUR · S/N 12843Kale James RN711PFPiper PA-32-300 · S/N 32-7340061Taylor MontyN717KEKale James Raymond MINIMAX 1600R · S/N 001Kale James RN721WBeech V35B · S/N D-9361Built 1972 · Top Flight Aviation LLCN7394NCessna 182P · S/N 18263177Built 1974 · Pritchett Randal MN7559JPiper PA-28R-180 · S/N 28R-30937Built 1968 · Hale Edward LN845JCirrus Design SR22 · S/N 1365Built 2005 · Matthews MichaelN880BWWest Barry WEST KTFX IV 1200 CL · S/N C96010137Built 2000 · Pyle Lester D
Back to Kingfisher, OK