OpenAirDocs.org
Stafford, VA

Registered aircraft · 37

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

N100WGBell Helicopter Textron Canada 429 · S/N 57341Total Helicopters UnlimitedN10EXMooney M20J · S/N 24-1047Built 1980 · Drachen Air LLCN11855Sling SLING LSA · S/N 434ABuilt 2025 · Jones Steven AN1956FCessna 172N · S/N 17273046Built 1979 · Penzo Michael AN1972VCessna 120 · S/N 14183Built 1947 · Absolute Ceiling Leasing LLCN2053XCessna 182H · S/N 18256153Built 1965 · Golden Richard JN2061NCessna 140 · S/N 12297Sale reportedBuilt 1947N2341PPiper PA-38-112 · S/N 38-79A0952Johnson Freddie IIIN2491TPiper PA-28-140 · S/N 28-7225078Built 1971 · Lichtman Bruce AN25017Fantasy Air Sro ALLEGRO 2000 · S/N 06-230Built 2006 · Reiser Christopher BrockN30043Cessna 177 · S/N 17701045Built 1968 · Singer Mark DN317TDCessna LC42-550FG · S/N 421016Built 2009 · Ellmore Floyd LesterN324FDBell Helicopter Textron Canada 429 · S/N 57346Built 2018 · Total Helicopters UnlimitedN32702Piper PA-28-151 · S/N 28-7515222Built 1974 · Eagle Air Group LLCN3537YCessna 182F · S/N 18254437Built 1963 · Caton Robert MN3NLPiper PA-28-180 · S/N 28-1826Built 1964 · Baez RafaelN4106NMooney M20C · S/N 680035Built 1968 · Gioia Matthew MN425MGBeech S35 · S/N D-7813Grinnan MichaelN42977Christopher Jule Wagner TUCANO LSA · S/N TR 2112Built 2025 · Wagner Christopher JN4376SPiper PA-32-301 · S/N 32-8406019Built 1984 · Dubyk NickoliN5513VPiper PA-28-161 · S/N 28-7716181Built 1977 · Renaldo Michael TN5524WPiper PA-28-150 · S/N 28-614Built 1962 · Hoe David SN64RGSpezio Sport DAL-1 · S/N RG163Built 1971 · Krushinski Joseph MN71184Jones Steven A ZODIAC CH 601 HD · S/N 63835Built 2002 · Jones Steven AN72436Ward Thomas J VANS RV-9A · S/N 91036Built 2008 · Ward Thomas JN7331GBell Textron Canada 429 · S/N 57442Built 2021 · Total Helicopters UnlimitedN73449Boeing A75N1(PT17) · S/N 75-3546Built 1942 · Flying Dutchman Aircraft Holdings LLCN760JJN401sc AIRCAM · S/N AC-176Built 2015 · Nageotte Randy KN7649WPiper PA-28-180 · S/N 28-1625Patterson Cameron LN7699JPiper PA-28R-180 · S/N 28R-31099Built 1969 · Hamilton John BN81ACWhite MODEL P · S/N AW-1Built 1971 · Krushinski Joseph MN8234PPiper PA-28-161 · S/N 28-8016354Built 1980 · Martinez Carlos MN8929UCessna 150M · S/N 15078023Built 1976 · Krushinski Joseph MN8955YPiper PA-39 · S/N 39-115Built 1971 · Carter Howard A IIIN964JCMooney M20F · S/N 22-1355Built 1976 · Iceman Air LLCN983SVBell Helicopter Textron Canada 429 · S/N 57348Total Helicopters UnlimitedN988FYBell Textron Canada 429 · S/N 57444Built 2021 · Total Helicopters Unlimited
Back to Stafford, VA