OpenAirDocs.org
Herndon, VA

Registered aircraft · 25

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

N11531Cessna 150L · S/N 15075493Ireland Lois TrusteeN14205Cessna 182T · S/N 18281889Built 2007 · Dfi Aviation Services LLCN15251Piper PA-28-235 · S/N 28-7310027Built 1972 · Thompson Roger CN1538SBeech P35 · S/N D-6985Built 1962 · Deneve Allen JN1617QCessna 150L · S/N 15072917Aljanabi Mohammed KhalidN164SJCessna 182S · S/N 18280064Built 1997 · Friedman MatthewN16DVAmerican Champion 8KCAB · S/N 1193-2021Built 2021 · Decathlon LLCN193FBMooney M20S · S/N 30-0054Built 2000 · Diamond Sage LLCN2647LCessna 172H · S/N 17255847Built 1967 · Commonwealth Aviation Services LLCN343BFCirrus Design SR22T · S/N 9380Built 2023 · Threesup LLCN3644NPiper J3C-65 · S/N 22903Built 1946 · Loehrke Timothy DN4153NCessna 140 · S/N 13875Built 1947 · Aljanabi Mohammed KhalidN4411EDJI AGRAS T20 · S/N 39MBHAM001007TUnconventional Concepts IncN555AZPiper PA-28-140 · S/N 28-26585Built 1969 · N555az LLCN56989Piper PA-28-180 · S/N 28-7405040Built 1973 · Kenny Zachary DN57THBoeing A75N1(PT17) · S/N 75-4240Lydick Carl DN600NXEmbraer EMB-550 · S/N 55020128Built 2020 · Akima LLCN6244TCessna 150E · S/N 15060944Built 1964 · Aljanabi Mohammed KN6517UMooney M20C · S/N 2300Built 1962 · Nova Accounting LLCN6757UMooney M20C · S/N 2479Built 1963 · Scherger Mark AN714VZCessna 152 · S/N 15279479Built 1977 · Sojka Brian ZN8280TCessna 175B · S/N 17556980Swift Raptor Aviation LLCN8567NPiper PA-28-235 · S/N 28-11365Built 1970 · Weekend Aviators LtdN878ACAmerican Champion 8KCAB · S/N 878-2001Built 2001 · Decathlon LLCN967DPCirrus Design SR20 · S/N 1287Built 2003 · Act2 Aviation LLC
Back to Herndon, VA