Ashburn, VA
Registered aircraft · 42
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 = 'ASHBURN' 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.
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 = 'ASHBURN' ORDER BY g.n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N11000Cirrus Design SR22T · S/N 11000N124GRVans RV-12 · S/N 120610N129MAPiper PA-28-181 · S/N 2890219N12ENCirrus Design SR22 · S/N 10837N132VRVashon RANGER R7 · S/N 10132N1361RGrumman American Avn. AA-5 · S/N AA5-0761N1434QVashon RANGER R7 · S/N 10188N17REBeech F33A · S/N CE-1128N18990Beech C23 · S/N M-1993N21VACreus Ruben VELOCITY SE-FG · S/N SUV 113N2303ZBeech 23 · S/N M-6N242SFBeech V35B · S/N D-10064N2928WBell 206B · S/N 752N2941LPiper PA-28-161 · S/N 28-7916564N3972WPiper PA-32-260 · S/N 32-889N4191HFleet 80 · S/N 187N424GBCirrus Design SR22T · S/N 11507N42MDMooney M20R · S/N 29-0178N430MHVans RV-12 · S/N 120659N4325VPiper PA-28-161 · S/N 28-8416017N462TWWebster Thomas A RV-7A · S/N 70462N500WRaytheon G36 · S/N E-3630N512APCirrus Design SR22 · S/N 1889N520TDCirrus Design SF50 · S/N 0636N5306ECessna 172N · S/N 17271832N5506GCessna 150J · S/N 15071006N5640BCessna 182 · S/N 33640N57413Mooney M20J · S/N 24-1450N6128ECessna 172 · S/N 46228N612JPCessna 310N · S/N 310N-0116N619ABGrumman American Avn. GA-7 · S/N GA7-0068N6341TCessna 172S · S/N 172S10843N6354KCessna 150M · S/N 15077660N6928QBeech A23A · S/N M-1070N72545Cessna 140 · S/N 9715N774GWPilatus PC-12/47 · S/N 774N8086ACessna 170B · S/N 20938N8373YPiper PA-28-181 · S/N 28-8190215N843TLLatitude Engineering HQ-60 · S/N 005N902TVCirrus Design SR20 · S/N 2542N9451NPiper PA-28R-200 · S/N 28R-35166N9564RBeech K35 · S/N D-6119
Back to Ashburn, VA