OpenAirDocs.org
Chickasha, OK

Registered aircraft · 34

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

N1042MBoeing B75N1 · S/N 75-7136Dusters And Sprayers Supply IncN10681Cessna 150L · S/N 15074970Built 1973 · Chickasha Wings IncN1345PPiper PA-23-150 · S/N 23-391Built 1955 · Chickasha Wings IncN17XTCrousore Terry KR-2 · S/N TC1Gipson Ronnie RN2284PPiper PA-23-150 · S/N 23-895Built 1957 · Chickasha Wings IncN23661David R Ames RANS S-19 · S/N 080900077Chickasha Wings IncN24GHBeech 95-A55 · S/N TC-404Built 1963 · Williams Mitchell LN3055XCessna 150F · S/N 15064455Built 1966 · Chickasha Wings IncN330STCirrus Design SR22T · S/N 11292Built 2026 · Bon Air LLCN333AFCessna 172L · S/N 17260403Built 1972 · Chickasha Wings IncN4049RBalloon Works FIREFLY 5 · S/N 510Built 1979 · Claypole David CN4049UCessna 150E · S/N 15061449Built 1965 · Catero IncN4473UCessna 150D · S/N 15060473Chickasha Wings IncN47375Piper J3C-65 · S/N 10743Built 1943 · Gleckler James MN5477SCessna 337B · S/N 337-0577Built 1966 · Chickasha Wings IncN5651RCessna 172F · S/N 17253279Built 1965 · Chickasha Wings IncN5710NBoeing B75N1 · S/N 75-8071Dusters & Sprayers Supply IncN5918XBrantly B-2 · S/N 54Riley Luther RN5991WPiper PA-28-140 · S/N 28-24795Built 1968 · Chickasha Wings IncN61251Cessna 150J · S/N 15070916Built 1969 · Chickasha Wings IncN625FSSocata TBM 700 · S/N 154Built 1999 · Ag Solutions Group Intermediate CorpN6476UMooney M20C · S/N 2223Built 1962 · Foster William B JrN6682KGrumman Acft ENG Cor-Schweizer G-164B · S/N 416BBuilt 1978 · Dickenson Mike JN6733QGrumman Acft ENG Cor-Schweizer G-164B · S/N 247BDickenson MjN6797ECessna 172N · S/N 17272069Built 1978 · Joe Bob NelsonN686AGTextron G36 · S/N E-4085Built 2016 · Bon Air LLCN7101ACessna 172 · S/N 29201Built 1956 · Chickasha Wings IncN7206XCessna 150A · S/N 15059306Chickasha Wings IncN736QFCessna R172K · S/N R1722699Built 1977 · Williams Mitchell LN8483LCessna 172I · S/N 17256683Built 1968 · Chickasha Wings IncN86278Aeronca 11AC · S/N 11AC-83Built 1946 · Veley Larry DN86703Bellanca 14-13 · S/N 1064Sale reportedBuilt 1946N87023Engineering & Research ERCOUPE 415-C · S/N 196Chickasha Wings IncN95BRPiper PA-28-140 · S/N 28-25841Built 1969 · Chickasha Wings Inc
Back to Chickasha, OK