OpenAirDocs.org
Salem, VA

Registered aircraft · 53

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

N101DGBell 206B · S/N 3929Built 1986 · Summit Helicopters IncN1492SCessna 182P · S/N 18265039Built 1976 · Burr John RN171PSDiamond Aircraft Ind DA 40 · S/N 40.701Built 2006 · Diamond Air LLCN201EEMooney M20J · S/N 24-0076Built 1976 · National University Services IncN206BEBell 206B · S/N 2375Built 1978 · Summit Helicopters IncN206WLBell Helicopter Textron 206L-1 · S/N 45513Built 1980 · Summit Helicopters IncN223PMCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1085/USBuilt 2024 · Mountain Aviation LLCN249DSDiamond Aircraft Ind DA 40 · S/N 40.249Built 2002 · Mountain Aviation LLCN2773HBell 205A-1 · S/N 30296Built 1979 · Summit Helicopters IncN310FCCessna 310Q · S/N 310Q1140Built 1974 · Scott Jed LN31563Piper PA-28-161 · S/N 28-7816561Built 1978 · Hfd Aviation LLCN318CMBombardier BD-100-1A10 · S/N 20661Built 2016 · Carter Aviation LLCN3324FHiller UH-12E · S/N 1735Built 1964 · Summit Sales & Leasing IncN351LACostruzioni Aeronautiche Tecna P-MENTOR · S/N 1153/USBuilt 2025 · Mountain Aviation LLCN35SPScoda Aeronautica Ltda SUPER PETREL LS · S/N S0389Built 2022 · N35sp LLCN3616Cessna 560 · S/N 560-0571Built 2001 · Carter Machinery Co IncN36GPBennetter-Stevens STARDUSTER TOO · S/N SB-1Built 1973 · Quinn Daniel JN38CFDiamond Aircraft Ind DA 40 · S/N 40.567Mountain Aviation LLCN395JPDiamond Aircraft Ind DA 40 · S/N 40.410Built 2004 · Kane Aviation LLCN411VFRobinson Helicopter R44 · S/N 1307Built 2003 · May RickyN44MRBeech 200C · S/N BL-27Summit Helicopters IncN484PADiamond Aircraft Ind DA20-C1 · S/N C0258Built 2004 · Kane Aviation LLCN4898CCessna T210N · S/N 21063659Built 1979 · Palo Aerocraft IncN506MADiamond Aircraft Ind DA 40 · S/N 40.497Built 2005 · Kane Aviation LLCN5107YCessna T182T · S/N T18208099Built 2001 · Brown Peter BN511LSCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1155/USBuilt 2025 · Mountain Aviation LLCN524DSDiamond Aircraft Ind DA 40 · S/N 40.260Mountain Aviation LLCN535HAHiller UH-12E · S/N 5035Built 1977 · Summit Helicopters IncN541LACostruzioni Aeronautiche Tecna P-MENTOR · S/N 1154/USBuilt 2025 · Mountain Aviation LLCN5729DPiper PA-22-150 · S/N 22-4427Built 1956 · Lanzara Anne MN59479Bell 206B · S/N 1194Built 1973 · Summit Helicopters IncN6006KHiller UH-12E · S/N HA3083Summit HelicoptersN6032EHiller UH-12E · S/N 5232Built 1996 · Summit Helicopters IncN620JFSchempp-Hirth Flugzeugbau DUO DISCUS · S/N 004Built 2025 · Duo D LLCN620JJSchempp-Hirth Flugzeugbau VENTUS 3F · S/N 023 FSBuilt 2018 · Frantz James S JrN6344DBell 206-L4 · S/N 52008Built 1993 · Summit Helicopters IncN6717PPowers George PIPISTREL SINUS · S/N 221Built 2008 · Jutz William AnthonyN6848BPiper PA-22-150 · S/N 22-4147Painter William LN71616Cessna 182M · S/N 18259689Built 1969 · Summit Helicopters IncN7189RPiper PA-28-140 · S/N 28-21902Built 1966 · Plymale Winston Leigh JrN71HMBell 206-L4 · S/N 52114Built 1994 · Summit Helicopters IncN7223BBeech 58 · S/N TH-1443Built 1985 · American National University IncN8055FCessna 150F · S/N 15064155Built 1966 · Gerken James D JrN8588EAmerican General Acft AG5B · S/N AG5B-10011Built 1991 · Longaker Aviation LLCN8634EPiper PA-28-151 · S/N 28-7615144Built 1976 · Ferguson Bryan KN87WYPitts Aerobatics S-2B · S/N 5111Built 1986 · Carter Mark EN914GWCessna 510 · S/N 510-0146Built 2008 · Dunrovin Aviation LLCN914RFPiper PA-32R-301T · S/N 32R-8029054Built 1980 · Hbe Aviation LLCN941SHBell 206-L4 · S/N 52205Built 1998 · Summit Helicopters IncN94APHiller UH-12D · S/N 1211Built 1959 · Summit Helicopters Inc
Back to Salem, VA