Great Falls, VA
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 = 'VA' AND g.registrant_city = 'GREAT FALLS' 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 = 'GREAT FALLS' 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.
N1060RRaytheon A36 · S/N E-3040N106FSocata TB 10 · S/N 592N1416RCirrus Design SR22 · S/N 4975N15PDMooney M20R · S/N 29-0492N1677JPiper PA-28-140 · S/N 28-24078N189BAmerican Champion 7GCBC · S/N 1246-98N223BBRaytheon A36 · S/N E-3340N224MFLoyd Remus MODIFIED RV4 · S/N 12171903N228BSCirrus Design SF50 · S/N 0040N23VMTextron T206H · S/N T20609533N240RJAmerican Champion 8KCAB · S/N 1103-2010N30PNCirrus Design SR20 · S/N 2739N316BCCirrus Design SR22 · S/N 10358N329RMCirrus Design SR22 · S/N 3776N333GXEpic E1000 · S/N K026N350XPPiper PA 46-350P · S/N 4636652N3592FCessna 182J · S/N 18257592N368MTGulfstream Aerospace GVII-G500 · S/N 72166N4220TPiper PA-32-300 · S/N 32-7240057N520WKCirrus Design SR22 · S/N 3797N5245HYakovlev YAK-55M · S/N 930908N5682VPiper PA-28-181 · S/N 28-7790496N588AMCessna T240 · S/N T24002053N600PGBeech B-60 · S/N P-502N625TBMooney M20S · S/N 30-0061N6801SBeech V35B · S/N D-9849N7222FPiper PA-42-1000 · S/N 42-5527036N751AACessna 750 · S/N 750-0068N823PVCirrus Design SR22 · S/N 1383N960BBCompagnie Daher TBM 700 · S/N 1437N987NGExtra Flugzeugproduktions UND EXTRA NG · S/N NG022
Back to Great Falls, VA