OpenAirDocs.org
Front Royal, VA

Registered aircraft · 29

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 = 'FRONT ROYAL'
  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.

N10WLBalloon Works FIREFLY 8B-15 · S/N F8B-592Blue Ridge Hot Air Balloons LLCN1997YMooney M20E · S/N 284Built 1964 · Mcculley Lowell BruceN2578VBalloon Works FIREFLY 8B-15 · S/N F8B-480Waddell Paul PatrickN25902Balloon Works FIREFLY 8 · S/N F8-406Blue Ridge Hot Air Balloons LLCN27035Balloon Works FIREFLY 6 · S/N 632Blue Ridge Hot Air Balloons LLCN3120YBalloon Works FIREFLY 7-15 · S/N F7-910Built 1996 · Blue Ridge Hot Air Balloons LLCN316CCCub Crafters CC11-100 · S/N CC11-00077Built 2008 · Lacy William SN321KAlexander Schleicher ASK 21 · S/N 21875Skyline Soaring Club IncN325ADSchempp-Hirth DISCUS CS · S/N 259CSBuilt 1999 · Skyline Soaring Club IncN32866Balloon Works FIREFLY 7B-15 · S/N F7B-365Blue Ridge Hot Air Balloons LLCN341KSSchleicher ASK-21 · S/N 21752Built 2002 · Skyline Soaring Club IncN3525UCessna 172S · S/N 172S8826Built 2001 · Randolph Macon AcademyN3752SCessna 172E · S/N 17250952Built 1963 · Hutchins Mary EllenN424BYPiper PA-25-260 · S/N 25-4640Built 1968 · Skyline Soaring Club IncN505CCPzl-Swidnik PW-5 · S/N 1706016Built 1996 · Skyline Soaring Club IncN5206MCessna 152 · S/N 15284504Built 1980 · Aeropaws Aviation LLCN520RJSchempp-Hirth DISCUS CS · S/N 217CSBuilt 1996 · Skyline Soaring Club IncN5436KRyan NAVION B · S/N NAV-4-2336BBuilt 1951 · Rogers Philip WN5511Tl-Ultralight Sro STING S4 · S/N 13ST399Built 2013 · Jarvis StoneyN6085SAviat A-1 · S/N 1236Built 1993 · Skyline Soaring Club IncN6970ACessna 172 · S/N 29070Built 1956 · Aeropaws Aviation LLCN70724Balloon Works FIREFLY 8 · S/N F8-436Blue Ridge Hot Air Balloons LLCN71114Cessna 182M · S/N 18259499Built 1968 · Aeropaws Aviation LLCN715JLRobinson Helicopter R44 II · S/N 11315Built 2006 · Jll Aviation LLCN796SEJohn M ELY VANS RV-7A · S/N 74603Built 2020 · Ely John MN8081NKoethler Herman CHALLENGER II · S/N CH2-1106-CW-2769Built 2007 · Roe Sean LN82346Piper PA-18-150 · S/N 18-7709162Ross DouglasN841SPCessna 172S · S/N 172S8746Built 2001 · Randolph Macon AcademyN9464LAmerican AA-1A · S/N AA1A-0264Built 1971 · Lehman Logan R
Back to Front Royal, VA