OpenAirDocs.org
Roanoke, VA

Registered aircraft · 65

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

N1018QCessna LC42-550FG · S/N 421018Built 2009 · Lambert BrentN1032JAero Commander 112 · S/N 32Built 1973 · Kornegay Kenneth DN1079SMooney M20J · S/N 24-3169Built 1990 · Acorn Flying Club Of Roanoke LLCN107CZRaytheon 400A · S/N RK-462Built 2006 · Peri Jets IncN111EACessna 310R · S/N 310R0245Executive Air IncN11453Waco QCF-2 · S/N 3539Built 1931 · Callis Aviation LLCN177XSCessna 177B · S/N 17701669Built 1971 · Wilson Kent MN1932PGulfstream Aerospace GV-SP (G550) · S/N 5549Built 2016 · Mozart Investments IncN194VMooney M20R · S/N 29-0200Uphoff Jeffrey AN1TLCessna 150L · S/N 15075710Built 1974 · Lewis Thomas AN2095AChampion 7CCM · S/N 7DC-329Built 1956 · Lawrence David DN21RBBrammer Robert C OSPREY 1 · S/N 1000001Brammer Robert CN221EDCirrus Design SR22 · S/N 8774Built 2022 · E3av LLCN274EBCirrus Design SR22T · S/N 10239Built 2024 · Bakhit Aviation LLCN2920ZPiper PA-22-150 · S/N 22-6890Built 1959 · Bruch Robert AllenN30GBBeech H-18 · S/N BA-688Built 1964 · Mission Air Aviation LLCN310GBBeech C-45H · S/N AF-856Built 1954 · Mission Air Aviation LLCN320PDDoran Peter DDS LANCAIR 320 · S/N 333Kennedy Robert WN3221WPiper PA-32-260 · S/N 32-27Built 1965 · Ray Troy DN324BHTextron G36 · S/N E-4162Built 2025 · N324bh LLCN3266LCessna 172H · S/N 17256166Built 1967 · Wolverine LLCN35BCBell 427 · S/N 56025Built 2001 · Justice Coal Aviation LLCN377SMPiper PA-32R-300 · S/N 32R-7780223Built 1977 · Jrt Flying CoN38669Piper J3C-65 · S/N 7178Virginia Museum Of Transportation IncN41DLCessna 182T · S/N 18281142Built 2002 · Ldair IncN4259BBeech F35 · S/N D-4236Built 1955 · Rucker Paul DN4386PPiper PA-28-236 · S/N 28-8511004Salters Robert EN44749Piper PA-28-151 · S/N 28-7515021Built 1974 · Hoprich Jeffrey SN4622NCessna 182Q · S/N 18267281Built 1979 · Vmi Flight Co LLCN4655RPiper PA-28-140 · S/N 28-21410Built 1966 · Froeschl Christopher JN47BFTextron 525 · S/N 525-1171Built 2024 · Boxley Farrell Aviation LLCN4865MPiper PA-11 · S/N 11-383Built 1947 · Lawrence David DN5075ACessna 305A · S/N 21299Kahn David JN5134TChampion 7GCBC · S/N 75Built 1966 · Lawrence David DentonN5175GCessna 305A · S/N 22577Kahn David JN5241LPiper PA-28-180 · S/N 28-4536Built 1967 · Four One Lima IncN528BCCessna 560 · S/N 560-0230Built 1993 · Beech Creek Coal CorpN541AJDiamond Aircraft Ind DA 40 · S/N 40.541Radiant Flight LLCN5426CCessna T210N · S/N 21063749Built 1979 · Virginia Air IncN5886XPiper PA-18-150 · S/N 1809088Built 1994 · Peak Investments LLCN6133VBeech 35-C33 · S/N CD-863Built 1965 · Omni Directions IncN6195WPiper PA-28-140 · S/N 28-20225Built 1964 · Willis Lee AN63RMRon Milan SONEX · S/N 1037Built 2019 · Milan Ronald AN6752YBeech C24R · S/N MC-728Built 1980 · Prewitt Grady LeeN722MDBeech D17S · S/N 6750Built 1944 · Anderson Richard EN7260PPiper PA-24-250 · S/N 24-2436Built 1961 · Potts Leah MarieN733ENCessna 172N · S/N 17268239Built 1976 · Burr Ralph MN7367HPiper J3C-65 · S/N 20632Built 1946 · Callis James DavidN757DTCessna 152 · S/N 15279663Star City Aviation IncN7934WPiper PA-28-180 · S/N 28-1975Built 1964 · Air Roanoke Ltd
Back to Roanoke, VA