OpenAirDocs.org
Fredericksburg, VA

Registered aircraft · 126

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

N10146Cessna 150L · S/N 15074808Built 1973 · Meredith Jonathan SN1028GCessna T182T · S/N T18208381Built 2005 · Creed Brian HN102FPColumbia Aircraft Mfg LC42-550FG · S/N 42511Built 2006 · N9817k LLCN1045EAeronca 7AC · S/N 7AC-4596Built 1946 · Cramer David CN109RLLarner Raymond L STEWART S-51D · S/N 120Shannon Air Museum LLCN11417Aeronca C-2 · S/N A151Built 1931 · Shannon Air Museum LLCN1248HMark B Horton RV14A · S/N 141086Built 2025 · Horton MarkN1248SCessna 182P · S/N 18264817Built 1976 · Bodolay John MN1258XMooney M20E · S/N 131Built 1963 · Compton Nathaniel BrandonN12628Piper E-2 · S/N 33Built 1932 · Shannon Air Museum LLCN12737Cessna 172M · S/N 17262218Built 1973 · Nageotte Randy KN133BUBucker Jungmeister BU 133 · S/N 251Built 1941 · Shannon Air Museum LLCN14640Aeronca C-3 · S/N 526Shannon Air Museum LLCN147BDDixon Brandon VANS RV-7A · S/N 70388Built 2003 · Nageotte Randy KN16099Vultee V-1A SPECIAL · S/N 25Built 1936 · Shannon Air Museum LLCN16QHughes 369HS · S/N 1290227SRegistration pendingN172MDCessna 172M · S/N 17263421Built 1974 · Dc Aerial Photos IncN1735DCessna 170A · S/N 20178Oxford Glenn HN177PCCessna 177B · S/N 17701472Janney Tyson DN182MWTextron 182T · S/N 18283281Built 2024 · Mcadam BradN19123Fairchild 24 G · S/N 2983Shannon Air Museum LLCN1916SSpad VII · S/N B9913Built 1917 · Shannon Air Museum LLCN1926Garber HEATH SUPER PARASOL · S/N 31919Shannon Air Museum LLCN200XQBurnette Jr/Burnette/Wright TRI QUICKIE 200 · S/N 2725Shannon Air Museum LLCN2040PBeech V35B · S/N D-10183Built 1978 · Trb Aviation LLCN204GSSpecketer Gary L RV10 · S/N 40274Built 2008 · Booth William F SrN207AULiberty Aerospace LIBERTY XL-2 · S/N 0105Built 2008 · Hale John WN21135Stinson SR-10G · S/N 5903Built 1937 · Shannon Air Museum LLCN220RLRalph Lee Ragsdale MURPHY REBEL · S/N 171Built 2019 · Nichols Michael AN237Bellanca CH400 SKYROCKET · S/N 187Shannon Air Museum LLCN2400GTextron T240 · S/N T24002137N2400g LLCN24672Beech B24R · S/N MC-154Built 1973 · Gurgainous Larry KN2671HSchweizer SGS 1-35C · S/N 71Built 1976 · Hatfield Michael ON28AADouglas DC3A · S/N 2239Built 1940 · Shannon Air Museum LLCN296ACAmerican Champion 8KCAB · S/N 770-96Newton Thomas L JrN2NGGoretsas Michael D RV-8A · S/N 81420Built 2009 · Goretsas Michael DN2QTBoone M P/Boucher R A VANS ACFT RV4 · S/N 2930Boucher BobbiN303JABeech 95-A55 · S/N TC-385Built 1962 · Nx Aviation LLCN316DYMichael W Morgan MONNETT MONI · S/N 00316Morgan Michael WN3173GNorth American AT-6G · S/N 49-3087Built 1958 · Finger 4 Flight LLCN31LGlasflugel STD LIBELLE 201B · S/N 401Built 1973 · N31l LLCN32398Rearwin 175 · S/N 1524Cramer David CN323TJCessna T303 · S/N T30300243Built 1983 · Guardian Wings LLCN328HRBeech V35B · S/N D-10269Built 1979 · Shuster DavidN32DGMooney M20K · S/N 25-1128Built 1987 · Rous LLCN333BBPiper PA-34-200 · S/N 34-7250279Denecke Robert WN33RNCessna 210E · S/N 21058533Built 1964 · Murphey John LN3447PPiper PA-23-160 · S/N 23-1418Built 1958 · Simonovich Sheldon KN345RNRandy Nageotte AIRCAM · S/N AC259Nageotte Randy KN356VRVashon RANGER R7 · S/N 10208Built 2023 · Rauch Karl W
Back to Fredericksburg, VA