Mcalester, OK

Registered aircraft · 26

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

N113CKJacobs Donald RV6-A · S/N 22378Built 2003 · Morgan Joel EN175VCCessna 175B · S/N 17556798Built 1960 · Cashmere Aviation LLCN1925QCessna 177RG · S/N 177RG0325Built 1973 · Reagan Amber JN210GMCessna 210L · S/N 21061393Built 1976 · Stipe Leslie WayneN236MKPiper PA-28-236 · S/N 28-7911321Built 1979 · Allford JohnN2724WMooney M20C · S/N 3338Built 1966 · Hebert David DN295DBButler Donald R RV-6A · S/N 21523Augter Gary KN335HCJohansen Halvor U HATZ · S/N 022Built 2006 · Otis Stephen HN425DVCessna 425 · S/N 425-0232Built 1985 · Verner David WN505WPZenith Acft ZODIAC 601 XL · S/N 6-4756Built 2005 · Wright Alvin DN6025DCessna 182T · S/N 18281830Built 2006 · Morgan Joel EN6264ACessna 182 · S/N 33064Built 1956 · Turley Joseph DN71012Piper J3C-65 · S/N 18028Otis Stephen HN7121SCessna 182P · S/N 18265065Built 1976 · Cashmere Aviation LLCN7271XCessna 182S · S/N 18280518First renewal noticeBuilt 1999 · Aeolian LLCN738WLCessna 172N · S/N 17270293Built 1978 · Brenair IncN7585SCessna 182Q · S/N 18265234Built 1976 · Hayes John MartinN75TCirrus Design SR22T · S/N 9007Built 2022 · Coal Creek Avaition LLCN7879Glasflugel H 301 LIBELLE · S/N 24Built 1966 · Thurber Charles H JrN7944CPiper PA-28-181 · S/N 28-7690091Augter Gary KN85EVEvo Enterprises EVOLUTION · S/N EVO-0085Built 2014 · Evo Enterprises LLCN8706RR. J. Begin DSA-1 · S/N RJB-1Built 1962 · Defrange Dennis DN8741TCessna 182C · S/N 52641Built 1960 · Tolman Jeremy CharlesN915PPDJI AGRAS T20P · S/N 1581F5745234L0C1D02DAgra Tech Drones LLCN923PTCirrus Design SR22 · S/N 4531Built 2017 · Miller Light Investments LLCN98218Piper PA-28-140 · S/N 28-26114Built 1969 · Engleman Roy J
Back to Mcalester, OK