OpenAirDocs.org
Charleston, WV

Registered aircraft · 58

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 = 'WV' AND g.registrant_city = 'CHARLESTON'
  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.

N100HNAirbus Helicopters Deutschland EC135 P3 · S/N 2291Built 2025 · Healthnet Aeromedical Services IncN131HNAirbus Helicopters MBB-BK 117 C-2 · S/N 9861Built 2020 · Healthnet Aeromedical Services IncN132HNEurocopter Deutschland EC 135 P2+ · S/N 0839Built 2009 · Healthnet Aeromedical Services IncN135HNAirbus Helicopters MBB-BK 117 C-2 · S/N 9847Built 2020 · Healthnet Aeromedical Services IncN139HNAirbus Helicopters Deutschland EC135 P3 · S/N 2293Built 2025 · Healthnet Aeromedical Services IncN157SMCessna 182S · S/N 18280157Built 1998 · Humphreys James FN17077Cessna 150L · S/N 15073257Built 1972 · Shehl George William IIIN182RJCessna 182P · S/N 18261514Built 1972 · Farpointe Aviation LLCN1972ECessna 172N · S/N 17271106Martin George CN1WVHawker Beechcraft B300 · S/N FL-527Built 2007 · State Of West VirginiaN21227Cessna 182P · S/N 18261500Built 1972 · Fly21227 LLCN2136ZPiper PA-28RT-201 · S/N 28R-7918111Built 1979 · Porta Frank TN21LDCessna 182G · S/N 18255173Built 1963 · Caswell BruceN222HNAirbus Helicopters Deutschland EC135 P3 · S/N 2289Built 2025 · Healthnet Aeromedical Services IncN237DSDiamond Aircraft Ind DA 40 · S/N 40.592Built 2005 · Young Mark KN249RRGrumman American Avn. AA-5B · S/N AA5B-0497Chrest Harry David JrN25XBDailey Peter J XENOS MOTORGLIDER · S/N X0010Dailey Peter JN286TWHonda HA-420 · S/N 42000101Built 2018 · Executive Aviation LLCN333WVSam Silverstein III LANCAIR ES · S/N 200Built 2012 · Silverstein Sam IIIN3454JCessna 150G · S/N 15066154Built 1967 · Islanders Flying ClubN35WVBeech F35 · S/N D-4273Built 1955 · N35wv LLCN362SRCirrus Design SR22 · S/N 1999Built 2006 · Aviation Guys LLCN3729BBeech 77 · S/N WA-140Built 1980 · Fredericks William DN37478Cessna 421C · S/N 421C0415Ghareeb Enterprises IncN375RGJames W Hosey TUCANO R · S/N TR-2103Built 2022 · Uldrich Thomas Grant IIN3968HErcoupe 415-CD · S/N 4669Built 1947 · Cannon Christopher CN3WVBell 407 · S/N 53713Built 2006 · State Of West VirginiaN4077YCessna 182 · S/N 18265351Built 1977 · Walker Air LLCN458MGCessna T182T · S/N T18208393Built 2005 · Flywheel LLCN4899PPiper PA-23-250 · S/N 27-487Revoked, canceledBuilt 1961 · C E S CorporationN5156SPiper PA-28-180 · S/N 28-7105010Knopf Kenneth EN54471Piper PA-28-180 · S/N 28-7405057Built 1973 · Jamerson Scott CN55340Piper PA-28-180 · S/N 28-7305363Built 1973 · Air55 LLCN55CVBeech E-55 · S/N TE-1114Built 1977 · Cavu LLCN58580Cessna 182P · S/N 18262153Built 1973 · Trgn LLCN5WVBell 206-L4 · S/N 52279Built 2003 · State Of West VirginiaN600HNAirbus Helicopters Deutschland EC135 P3 · S/N 2288Built 2024 · Healthnet Aeromedical Services IncN61752Cessna 172M · S/N 17264774Built 1975 · Lee Robert EricN651EMCessna 650 · S/N 650-0030Built 1984 · Wv Jet Experience LLCN65GSPiper PA 31P 350 · S/N 31P-8414016Built 1983 · Cheyenne Air LLCN6727SBeech A36 · S/N E-2100Built 1983 · Kt Aero LLCN68VVCessna 177 · S/N 17700898Built 1968 · White Mark EN6WVBell 206B · S/N 3138State Of West Virgina Dept Of AvnN716BSCirrus Design SR22 · S/N 4869Built 2019 · Oz Fund Investments LLCN735KTCessna 182Q · S/N 18265491Built 1977 · Ede Transport LLCN787MKCirrus Design SR22T · S/N 1300Built 2016 · Oms Aviation LLCN800HNEurocopter Deutschland EC 135 P2+ · S/N 1119Built 2013 · Healthnet Aeromedical Services IncN80366Cessna 172M · S/N 17266553Built 1976 · Steranka Paul O JrN8067LCessna 172H · S/N 17256267Built 1967 · Aviation Guys LLCN83410Aeronca 7AC · S/N 7AC-2077Built 1946 · Peters William D Jr
Back to Charleston, WV