Guthrie, OK

Registered aircraft · 48

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

N1008EBellanca 7ECA · S/N 1202-77Edwards Gregory SN133CCanadair T-33 · S/N 192Built 1956 · Spirit Wing Aviation LtdN13HSTaylorcraft F19 · S/N F-039Gregg Brian LN1531KLuscombe 8A · S/N 4258Mckinney Timothy ScottN17AHLearjet 25D · S/N 316Built 1980 · Spirit Wing Aviation LtdN181AZAir Creation BUGGY 582J · S/N T01070Built 2001 · Officer Kent WN19191Kaiser F5 · S/N F502Built 1946 · Radial Engines LtdN19192Fleetwings SEABIRD · S/N F-503Built 1950 · Radial Engines LtdN20464Cessna 172M · S/N 17261308Built 1972 · 8231 Tango Enterprises LLCN27217Porterfield CP-65 · S/N 714Case MarionN2985TAero Commander 100 · S/N 059Built 1967 · Huskey Ryan JN30191National Ballooning 858 · S/N 156Built 2006 · Kinser Aviation LLCN3050LCessna 310J · S/N 310J0050Built 1965 · Madison MitchellN318RDBacke Stephen A EXPRESS · S/N 1154Built 1999 · Case MarionN3616VCessna 140 · S/N 14884Built 1948 · Semler GregN3651ZPiper PA-22S-150 · S/N 22-7548Built 1960 · Crabtree Glenn EN36931Balloon Works FIREFLY 7-B · S/N F7B-109Kinser Aviation LLCN3750RCessna 172H · S/N 17255550Built 1966 · N3750r LLCN3931EAeronca 11BC · S/N 11BC-13Built 1947 · Storer Daniel AN43225Piper PA-34-220T · S/N 34-8433006Gann Clifton TN453DBDon A Baker BAKER-SKYBOLT · S/N 01Built 2012 · Aguirre-Y-Luker Grant ClimacoN50WKAdams Balloon A50S · S/N 027Kinser Aviation LLCN5162RCessna 172M · S/N 17263379Built 1974 · Ellis Harvey Airport IncN5165CBeech B35 · S/N D-2450Built 1950 · Huskey James RN5252KRyan NAVION B · S/N NAV-4-2152BBuilt 1950 · Tupper JoelN5901SBeech V35 · S/N D-8118Built 1966 · Sheffield KraigN6002YCameron Balloons US Z-90 · S/N 7044Built 2026 · Kinser Aviation LLCN61TDFronczak Richard RV6A · S/N 22464Built 1995 · Crick Christopher JN653DGCirrus Design SR22 · S/N 0522Built 2003 · Watson Dallas CN729LWSperberg Larry L RV-6 · S/N 20022Swanson Gary HN74TKAir Fly Balonismo E Inflaveis AF-SS-86 · S/N LP2023-04Built 2023 · Kinser Aviation LLCN766KWaco ASO · S/N 823Radial Engines LtdN775KWaco ASO · S/N A-95Curry Steve CN778WPHatch Gerald F RV-7 · S/N 73262Built 2010 · Officer Kent WN8098ACessna 170B · S/N 20950Built 1952 · Gann Clifton TN831JVSmith Jearld T RV-9A · S/N 91066Built 2008 · Yeo StuartN84EXBradley Latham CCK-2000 · S/N CCK-2000-0149Built 2026 · Latham BradleyN8953WPiper PA-28-235 · S/N 28-10526Built 1964 · Kinser Aviation LLCN89973Cessna 140 · S/N 9025Built 1946 · Seward Leasing IncN9083SBeech 58P · S/N TJ-152Built 1978 · Robinson Charley CN920HWaco GXE · S/N 2052Built 1929 · Curry Steve CN9220DPiper PA-22-160 · S/N 22-6280Ellis Harvey Airport IncN9502MMooney M20F · S/N 670079Built 1966 · Storer Daniel AN97295Cessna 182Q · S/N 18267047Built 1979 · J-Air LLCN981CSRans S-14 · S/N A122184Mcbride Terry LN9858MMaule M-4C · S/N 9CBuilt 1967 · Upton JamesN98GHHarr Glenn GREAT LKS 2TIA-GHS · S/N 001Wdbr Solutions LLCN998PWPiper PA-28-236 · S/N 28-7911170Built 1979 · Baker Toby J
Back to Guthrie, OK