OpenAirDocs.org
Newalla, 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 = 'NEWALLA'
  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.

N13JMJack Martin CH750 · S/N 001Built 2017 · Gallardo Luis DN18069Cessna 150L · S/N 15073771Built 1972 · Olandese Donald JN184DCChapman Gregory C RV-8A · S/N 80744Built 2018 · Chapman Gregory CN1922VCessna 172M · S/N 17263796Built 1974 · Rogers Randall JN201CNMooney M20J · S/N 24-0441Built 1978 · Camp Teresa A TrusteeN232BERans S6-S · S/N 03051645Built 2007 · Am Flying Club LLCN261RMMartin J R / Olandese D J RV-9 · S/N 91507Built 2011 · Olandese Donald JN2980ABeech V35B · S/N D-10154Built 1978 · West David RN3244HForney 415-C · S/N 3869Built 1946 · Manning Gary DN333GJSchweizer 269C-1 · S/N 0056Oliver Enterprises LLCN3960UCessna 150E · S/N 15061360Built 1965 · Drebes Jeffrey GN4104Mooney M-18LA · S/N 138Built 1953 · Lewis Charles WN4616ZPiper PA-22-108 · S/N 22-8130Built 1961 · Best David EugeneN5040BBeech F35 · S/N D-4307Built 1955 · Farley Steven DN5162NNorthwing APACHE SPORT · S/N 411155Built 2005 · Brown Jeffrey LN52758Cessna 182P · S/N 18262825Built 1974 · Luse David CN60687Cessna 150J · S/N 15070501Built 1969 · Luse Benjamin TN610PSCzech Sport PIPER SPORT · S/N P1001013Built 2010 · West Charles TN6134NBeech A23-24 · S/N MA-345Chris Bellinger Dvm LLCN65DRJ D Calhoun VANS ACFT RV6A · S/N 60196Built 2002 · Klr Services LLCN7088RScott A Martin VANS RV7A · S/N 71388Martin ScottN767TXHaverlah Dennis W RV-7A · S/N VAN 71761Built 2007 · Lomheim Douglas SN773SHCessna 140 · S/N 11512Built 1946 · Lochman Marty RN781DMMarshall B Alexander RV-9A · S/N 91995Built 2021 · Alexander Donna CN7869LBeech V35 · S/N D-8293Built 1966 · Crawford ScottN79104Cessna 172K · S/N 17257884Built 1969 · Roman Nose Flying Club IncN7983GCessna 172L · S/N 17259683Built 1971 · Luse David CN8244TCrutcher Charles S BABY LAKES · S/N 9503 - J - 1188BBuilt 2001 · Seebach Jeffrey DN87359Engineering & Research ERCOUPE 415-D · S/N 532Built 1946 · Manning GaryN92462Piper J3C-65 · S/N 16932Built 1946 · Olandese Donald JN9772BBest D E/Ebel R L AVID FLYER 86B · S/N 232Best David EN9791UGrumman American Avn. AA-5A · S/N AA5A-0191Built 1976 · Woods JoeN9979UGrumman American Avn. AA-1C · S/N AA1C0173Built 1978 · Best David EN99VDonegan Benton RV-6A · S/N 60232Built 2002 · Chapman Gregory C
Back to Newalla, OK