OpenAirDocs.org
Purcellville, VA

Registered aircraft · 26

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

N109FNorth American NAVION L-17A · S/N NAV-4-839Built 1947 · Roos Patrick RN114CECommander 114-B · S/N 14640Built 1996 · Commander Air LLCN11CFBeech B50 · S/N CH-107Built 1954 · Krens Janet EN211KMDornier DO 27 A1 · S/N 211Built 1958 · Comanche Bloom Enterprises LLCN2144PMooney M20R · S/N 29-0160Built 1998 · Vanderhoof Brian LN218CTLarry R Scott VANS RV-8 · S/N 82757Built 2019 · Parsons WayneN2855JPiper PA-28-201T · S/N 28-7921069Built 1979 · King Dennis GN3181SCessna 182G · S/N 18255681Built 1964 · Wood David MN367CStinson 108-2 · S/N 108-3367Comanche Bloom Enterprises LLCN4198CRaven S-60A · S/N S60A-218Built 1982 · Vill Joseph E JrN42121Air Creation GTE582SL · S/N T04079Built 2004 · King Martyn GN4815JBeech 35-C33A · S/N CE-114Built 1966 · Rise Ronald B JrN4880TPiper PA-28-140 · S/N 28-7225229Built 1972 · Itechtives Company LLCN58CZPage Joseph E RV-7 · S/N 72965Built 2021 · Page Joseph EN613MMCirrus Design SR22 · S/N 1497Built 2005 · Come Fly With US LLCN67461Cessna 152 · S/N 15281848Built 1978 · Mclernon Connor JN69RDPiper PA-30 · S/N 30-183Built 1963 · Krens Janet EN733BZCessna 172N · S/N 17268180Built 1977 · Bz Partners IncN81201Fairchild 24W-46 · S/N W46102Built 1946 · Avdeev AlexeyN829WPDehavilland DHC-1 CHIPMUNK · S/N C1-0710Penderville John EdwardN84662Cessna 172K · S/N 17258569Built 1969 · Caverns Consulting LLCN84WGAndrew D Mechling SONEX · S/N 1054Built 2013 · Gingras Michael SN87HCJohn Franklin AURORA BUTTERFLY · S/N B146Built 2013 · Franklin John MN8837DPiper PA-22-150 · S/N 22-6007Built 1958 · Comanche Bloom Enterprises LLCN91512North American NAVION A · S/N NAV-4-307Built 1946 · Krens Janet EN961CMCirrus Design SF50 · S/N 0249Built 2021 · Shreve Mill LLC
Back to Purcellville, VA