OpenAirDocs.org
Sterling, VA

Registered aircraft · 30

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

N130MDEurocopter EC 130 B4 · S/N 7549Built 2012 · Ec 130 II LLCN137LCCollins Leland F VANS RV9A · S/N 90334Built 2005 · Nine Kilo LLCN141TDDustin S Stern VANS ACFT INC RV-14A · S/N 140215Built 2022 · Stern Dustin SN1648FCessna 172H · S/N 17255043Bahizi Pierre NtwaliN172DRCessna 172R · S/N 17280272Built 1997 · Cunningham Darius LN1801ZCessna 210-5(205) · S/N 205-0001Built 1962 · Gould Robert R JrN28RVFoster Robert S RV6-A · S/N 21346Built 1995 · Johnson Kenneth AN32573Piper PA-28-151 · S/N 28-7515190Zarafshar KeyvanN327JHParajet MAVERICK MAX · S/N 005990Hayes JustinN3530ZCessna T182T · S/N T18208023Williams Alan GN362XMDJI MINI 3 · S/N 1581F5YHX235W0021VX6Carson MichaelN3674CDJI MAVIC 3 CLASSIC · S/N 1581F67PE231600300T8Carson MichaelN372AFCessna 182T · S/N 18281191Built 2003 · Flyslow Aviation LLCN4186HPiper PA-15 · S/N 15-69Built 1948 · Miller Paul DN4213KNavion NAVION A · S/N NAV-4-1213Built 1948 · Pontiff Elizabeth DN448KGPiper PA-32R-301 · S/N 32R-8113037Built 1981 · Tondi David MN495SCCirrus Design SR22 · S/N 10484Built 2025 · Optimum Aviation LLCN5273RCessna 172M · S/N 17263487Built 1974 · Clear Prop Aviation LLCN5451FPiper PA-32R-300 · S/N 32R-7780011Built 1976 · Virginia Aviators LLCN55BKPilatus PC-12 · S/N 160Built 1996 · Pc 12 LLCN6133JPiper PA-28-151 · S/N 28-7615310Arbello DannyN61676Cessna 172M · S/N 17264721Built 1975 · Vectors LLCN622CKBombardier BD-700-1A11 · S/N 9819Built 2018 · N622ck LLCN65491North American T-28B · S/N 138245Tondi David MN716PVCirrus Design SR22 · S/N 10236Built 2024 · Optimum G7 Aviation LLCN8225VPiper PA-28-181 · S/N 28-8290144Built 1982 · Runge Thomas AN85SKEurocopter EC 130 B4 · S/N 7388Built 2012 · Ec 130 LLCN88431Piper J3C-65 · S/N 16049Built 1946 · Tondi David MN918AWAnthony D Wilcox RV-12 · S/N 120673Built 2013 · Wilcox Anthony DN925JDEmbraer Executive EMB-505 · S/N 50500493Built 2018 · Otd Aviation LLC
Back to Sterling, VA