OpenAirDocs.org
Roanoke, TX

Registered aircraft · 74

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 = 'TX' AND g.registrant_city = 'ROANOKE'
  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.

N11182Cessna 182Q · S/N 18266815Built 1979 · Smith BrianN143JSBoeing A75 · S/N 75-5556Built 1943 · Mcclain Aviation LLCN15JWBeech 95 · S/N TD-225Built 1959 · Tri-Cap InternationalN18407Stinson SR-9C · S/N 5313Built 1937 · Riedl Mark CN185BCCessna 185 · S/N 1850021Built 1961 · Shackelford John SN202MJEagleston John H RV-8A · S/N 80550Frizzell Kay MN2241UBrantly B-2B · S/N 482Built 1968 · Latimer Mark AN249AMMarshall Allan W HIPERBIPE SNS-7 · S/N 249Built 1981 · Shackelford John S JrN2572PPiper PA-18A 150 · S/N 18-4312Registration pendingN2717ABeech V35A · S/N D-9049Built 1969 · Mitchell MatthewN279WMClayton E Mcmartin II RV-8 · S/N 83392Built 2021 · Mcmartin Cutler JN302ACessna M337B · S/N 68-11055Built 1969 · Zavoina Lawrence D JrN3075KPiper PA-28-161 · S/N 28-7916239Built 1978 · Baker James BN333NTBeech B95A · S/N TD-515Built 1962 · Koerner Norman HN33UPCessna 320 · S/N 320-0078Built 1961 · Aero Valley Properties LLCN3473John Irvin Linder JR PIETENPOL · S/N 001Built 2022 · Richmond Randy WN3519RBeech A23 · S/N M-673Caskey Kenneth PN3571Consolidated Vultee BT-13A · S/N 3571Shackelford John S JrN35745Piper J5A · S/N 5-747Smith Robert DN3781QBeech V35 · S/N D-8417Built 1967 · Welch Michael RN38834Piper J3F-65 · S/N 7321Built 1941 · Shackelford John S JrN393ECJim Kimball Enterprises PITTS MODEL 12 · S/N 222Built 2004 · Shackelford John JrN3960KPiper PA-28-140 · S/N 28-23839Registration pendingBuilt 1967N39SFHawker SEA FURY TMK 20 · S/N 37542Built 1949 · Shackelford John S JrN40EBeech D17S · S/N 6685Built 1944 · Shackelford John S JrN429GLBeech 95-B55 (T42A) · S/N TC-868Built 1965 · Hamilton Verlon DN43451Piper PA-32-300 · S/N 32-7440127Built 1974 · Redwood Air LLCN4355XPiper PA-28R-200 · S/N 28R-7635020Built 1975 · Redman Peter JN44045Taylorcraft DCO-65 · S/N L-5713Built 1943 · Pvb36 Leasing LLCN44GHDouglas SUPER R4D-8 · S/N 43393Flight Data IncN4597WRockwell International 112TC · S/N 13087Built 1976 · Pelupessy Richard AN476ABridges Glenn J SKYOTE · S/N 89Built 2009 · Shackelford John S JrN50GKPiper PA46-500TP · S/N 4697376Built 2008 · Redwood Air LLCN5303GCessna 305A · S/N 21781Built 1951 · Trotter SteveN5407HPiper PA-14 · S/N 14-522Built 1949 · Pye JenniferN5702GCessna 150K · S/N 15071202Built 1969 · Randolph-Graham Monica LN5752YPiper PA-23-250 · S/N 27-2877Shackelford John S JrN5870UPiper PA-28-140 · S/N 28-26702Built 1970 · White Thomas AN5887SBeech S35 · S/N D-7760Built 1965 · Mcmartin Cutler JN611ABCanadair CL-600-2B16 · S/N 5324Built 1997 · Pollard Spares LLCN61LWBeech F33A · S/N CE-897Built 1980 · Weaver Lonnie JN61TCirrus Design SF50 · S/N 0259Built 2021 · Handwerk Aviation LLCN6207UMooney M20C · S/N 2046Latimer Mark AN636CHHawker Beechcraft G36 · S/N E-3859Built 2008 · Hr Hoss LLCN6410SCessna 150H · S/N 15067210Built 1967 · Saunders Aviation LLCN65096Boeing A75N1(PT17) · S/N 75-3632Built 1942 · Shackelford John S JrN6647KGrumman G-44A · S/N 1206Built 1941 · Shackelford John S JrN691WTCessna 340A · S/N 340A0703Built 1979 · Pvb36 Leasing LLCN711LJBellanca 17-31 · S/N 32-17Ivie CalvinN7273RBeech A36 · S/N E-634Harwood Nathan S
Back to Roanoke, TX