Alexandria, VA
Registered aircraft · 749
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 = 'ALEXANDRIA' 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 = 'ALEXANDRIA' 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.
N109MYYonchak Mark A DR-109 · S/N 2000N11GDPiper J3C-65 · S/N 14847N1303HCirrus Design SR22 · S/N 3945N130ARLockheed EC130Q · S/N 162312N1310WJMB Aircraft S R O VL-3TE-1 · S/N VL-3-341N13703Cessna 172M · S/N 17262955N1390YCessna 172C · S/N 17249090N15223Piper PA-28-180 · S/N 28-7305037N15310Piper PA-28-140 · S/N 28-7325035N1652HPiper PA-32R-300 · S/N 32R-7780168N176RKTextron G58 · S/N TH-2532N182VCessna 182P · S/N 18263931N18DGGossen Richard JR CHRISTEN EAGLE-II · S/N GOSSEN-0001N200DRCirrus Design SR22 · S/N 4860N2126BLuscombe 8F · S/N 6553N214WMScoda Aeronautica Ltda SUPER PETREL LS · S/N S0364N2225Cirrus Design SR22 · S/N 4614N2225KLuscombe 8E · S/N 4952N222XPMarshall Greg J PANTHER LS · S/N 102N22847Cessna 150H · S/N 15068560N2317TPiper PA-28R-200 · S/N 28R-7135208N23480Cessna 182S · S/N 18280412N2607EAeronca 7AC · S/N 7AC-6190N316TMCirrus Design SR22T · S/N 0117N32HPitts Special S-1C · S/N 1512N32JCMooney M20J · S/N 24-0120N33612Dassault-Breguet FALCON 50 · S/N 196N34038Cessna 177B · S/N 17701608N3545WMargiotta Michael A RV-8 · S/N 83926N3734GRaytheon G36 · S/N E-3734N3742HMooney M20J · S/N 24-0918N37501Grumman American Avn. AA-5B · S/N AA5B-0408N3902RCessna 172H · S/N 17255402N3984DCessna 182A · S/N 34684N411WWAlexander Schleicher ASH 31 MI · S/N 31052N42267Cessna 182L · S/N 18258934N4484ZBoeing/Mays A75N1 · S/N 75-1869N4551XPiper PA-28R-200 · S/N 28R-7635075N4583TPiper PA-28R-200 · S/N 28R-7235099N45LSSpross Lester C VANS ACFT RV-4 · S/N 1106N46248Aeronca 0-58B · S/N 058B-1122N47424Piper PA-34-200T · S/N 34-7770394N476JBPiper PA-28R-201T · S/N 28R-7703419N48620Aeronca 0-58B · S/N 058B-7072N4958VCessna 172RG · S/N 172RG0427N4CFCessna T337G · S/N P3370038N4RCNorth American SNJ-6 · S/N 111957N501TTBoeing A75N1(PT17) · S/N 75500N5028VBellanca 8KCAB · S/N 445-78N5132QCessna 172M · S/N 17261760
Back to Alexandria, VA