OpenAirDocs.org
Fairmont, WV

Registered aircraft · 31

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

N1005QCessna 310H · S/N 310H0005Registration pendingN106ETCessna 172S · S/N 172S8563Built 2000 · Fairmont State UniversityN107BACessna 172N · S/N 17269320Fairmont State UniversityN1372UCessna 172M · S/N 17267043Built 1976 · Ferguson Joseph L IIN138TBeech B35 · S/N D-2566Built 1950 · Onderko George CN15PCCarr Patrick L RV-4 · S/N 1214Built 1997 · Carr Patrick LN15WVChampion 7ECA · S/N 667Built 1969 · Whiskey Victor Aviation LLCN1884VCessna 172M · S/N 17263781Built 1974 · Murphy Edward LN214JMPiper PA-28R-201T · S/N 28R-7703059Built 1977 · Visions In Design LLCN2791WMooney M20E · S/N 1069Toothman JohnN27BLTextron 172S · S/N 172S12467Built 2020 · Fairmont State UniversityN282RFCessna 182M · S/N 18259466Built 1968 · Devault Michael EN317PZPiper PA-23-250 · S/N 27-8054047Built 1980 · Fairmont State UniversityN4134CStinson 108-3 · S/N 108-5134Built 1950 · Moore Dennis RN464RCessna 182N · S/N 18260464Wilson Aaron IN464WTTextron 172S · S/N 172S12861Built 2022 · Fairmont State UniversityN5179VCessna 172RG · S/N 172RG0460Built 1980 · Fairmont State UniversityN58673Cessna 182P · S/N 18262226Built 1973 · Nawrocki Daniel NN642THTextron 172S · S/N 172S12642Built 2021 · Fairmont State UniversityN716THTextron 172S · S/N 172S12008Built 2017 · Fairmont State UniversityN739NCCessna 172N · S/N 17270665Built 1978 · Fairmont State UniversityN764BKCessna 172M · S/N 17266891Built 1976 · Fairmont State UniversityN7773PPiper PA-24-250 · S/N 24-2989Built 1962 · Jenkins John RN7813WPiper PA-28-180 · S/N 28-1821Built 1964 · Mnt Aviation LLCN8177TCessna 175B · S/N 17556877Registration pendingBuilt 1960N8186NPiper PA-28-140 · S/N 28-25383Built 1969 · Morris Thomas LN82757Piper PA-28-161 · S/N 28-8116054Registration pendingBuilt 1980N8959JPiper PA-28-180 · S/N 28-2980Registration pendingN926MKPiper PA-28-140 · S/N 28-7125138Built 1971 · Toothman John CN9320WPiper PA-28-235 · S/N 28-11002Built 1967 · Manzo Anthony MichaelN9790JPiper PA-28-180 · S/N 28-3992Built 1967 · Sheets Martin C
Back to Fairmont, WV