Reston, VA
Registered aircraft · 46
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 = 'RESTON' 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 = 'RESTON' 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.
N102LWPiper PA-18 · S/N 18-4383N1047LMooney M20R · S/N 29-0320N13208Cessna 172M · S/N 17262575N20000Ryan NAVION A · S/N NAV-4-1787N201LEMooney M20J · S/N 24-0480N21ZZNavion NAVION G · S/N NAV-4-2405N23807Cessna 182S · S/N 18280468N291ASRaytheon B300 · S/N FL-332N317CDCirrus Design SR22 · S/N 0905N318WBCirrus Design SR22 · S/N 9378N3265CBeech E35 · S/N D-3931N335TJCessna 335 · S/N 335-0012N35GARaytheon B300 · S/N FL-413N372TACessna 172S · S/N 172S10372N3980HBoeing PT-13B · S/N 75167N405WKRaytheon B300 · S/N FL-405N418HPPiper PA46-500TP · S/N 4697418N45343Grumman American Avn. AA-5B · S/N AA5B1265N467CTFlight Design CTSW · S/N 07-04-14N46996Boeing A75N1 · S/N 75-3736N506KBRaytheon B300 · S/N FL-506N5650LBeech B36TC · S/N EA505N570BXFlight Design CTLS · S/N 08-04-12N57KSSorenson DEFIANT · S/N 86N585GGulfstream Aerospace GVII-G500 · S/N 72095N586GGulfstream Aerospace GVII-G500 · S/N 72106N587GGulfstream Aerospace GVII-G500 · S/N 72107N5UBSocata TB-20 TRINIDAD · S/N 1762N618CRBombardier CL-600-2B16 · S/N 5520N6657ZBeech F33A · S/N CE-874N747KPPiper PA-30 · S/N 30-1223N749RCCirrus Design SR22 · S/N 1044N7810CBeech A45 · S/N G-767N8068GCessna 177RG · S/N 177RG0068N811LJPiper PA-34-200T · S/N 34-7770383N828CJRaytheon B300 · S/N FL-406N831JSergent Don L GREAT LAKES 2T1A · S/N 9712-3-647N850MKSocata TBM 700 · S/N 403N874WJRichey David W RV-8A · S/N 82874N888FMRaytheon B300 · S/N FL-418N9402JPiper PA-28-180 · S/N 28-3508N954TPPennell Tom A DR-107 · S/N 94-0076N9664RBeech D50C · S/N DH-246N9873QCessna 172M · S/N 17265817N98WBFlorida Helicopter HUMMINGBIRD 260L · S/N 622N98WTHasz Michael GS-2 SPORTSMAN · S/N 7179
Back to Reston, VA