OpenAirDocs.org
Guymon, 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 = 'GUYMON'
  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.

N1185KDJI AGRAS T40 · S/N 64TBL2100201A9Tb2 Drones LLCN1249SCessna 182P · S/N 18264818Built 1976 · Clemans Alan JN149JTThompson Jack CHRISTEN EAGLE II · S/N THOMPSON 0001Built 1986 · Panhandle Associates IncN15015Piper PA-32-300 · S/N 32-7240133Harbison Ricky WN164QBerger David W LANCAIR 320 · S/N 341/349Downing Paul RN170DNNeland Richard L DAYTONA SUPER CUB · S/N DC-04Delta Charley Lease LLCN1912CCessna 170B · S/N 26057Built 1953 · N1912c Flyers LLCN242NGPilatus PC-12/47E · S/N 1242Built 2010 · Panhandle Telecommunication Systems IncN2676GCessna 182B · S/N 51976Built 1959 · Holland Ross DN302MJCessna 425 · S/N 425-0120Built 1980 · 425 Partners LLCN311MAMooney M20K · S/N 25-2011Built 1997 · Wilkins Ralph StevenN3332UCessna 182F · S/N 18254732Built 1963 · Ming Greg AN3560YCessna 182F · S/N 18254460Built 1962 · Triple J&M Flying LLCN4742Jack Pollack SWICK-T · S/N 1Sale reportedN4747WRockwell International 114 · S/N 14077Built 1976 · Fronterhouse Dwayne RN4751DCessna 182A · S/N 34851Built 1957 · Moore Johnathan DN4806SPiper PA-32-260 · S/N 32-1190Built 1969 · Johnson Mack WN6099PPiper PA 46-350P · S/N 4636468Built 2010 · Cudd Bradley ShaneN7025CPiper PA-28-181 · S/N 28-7690050Built 1975 · Downing Gregg RN71235Balloon Works FIREFLY 7 · S/N F7-457Miller Royce DN712KBellanca 8KCAB · S/N 389-78Wing John DavidN7234NBeech A36 · S/N E-2248Built 1985 · Brazell Chad RN7609YPiper PA-30 · S/N 30-680Built 1964 · Downing Gregg RN7982DBeech H35 · S/N D-5262Built 1957 · Black David BN8178RBeech A36 · S/N E-594Built 1974 · W L Landess LLCN9YFLake Larry C 8 LAKE EXPERIMENTAL · S/N L-36027-36ABuilt 1999 · Panhandle Associates Inc
Back to Guymon, OK