Washington, DC
Registered aircraft · 393
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 = 'DC' AND g.registrant_city = 'WASHINGTON' 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 = 'DC' AND g.registrant_city = 'WASHINGTON' 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.
N200RVVans RV-12 · S/N 120449N201RFMooney M20J · S/N 24-0135N203ZAirbus Helicopters AS350B3 · S/N 8811N208EBCessna 208B · S/N 208B1047N2108JAirbus Helicopters AS350B3 · S/N 9200N213LBLancair LC42-550FG · S/N 42051N2179WMooney M20S · S/N 30-0033N218QBeechcraft B300C · S/N FM-62N219GMBeech 58 · S/N TH-1536N220WWExperimental Aircraft Assn WAIEX · S/N WXB66OWWN22367Sikorsky UH-60A · S/N 82-23670N223MSMooney M20M · S/N 27-0340N2262TCessna A185E · S/N 185-1420N2273VCessna 140 · S/N 14504N233SKSikorsky UH-60A · S/N 79-23321N23423Sikorsky UH-60A · S/N 80-23423N236MJGulfstream Aerospace GVI (G650ER) · S/N 6579N237CACessna 206H · S/N 20608239N242AAmerican Eurocopter AS350B3 · S/N 7176N242THMoravan Z242L · S/N 0676N2431LCessna 172H · S/N 17255631N24548Sikorsky UH-60L · S/N 86-24548N247SHPilatus PC-12/47E · S/N 2367N2506KLuscombe 8E · S/N 5233N251JTextron B300C · S/N FM-100N252CWStaudacher S600 F · S/N 31N253LGGeneral Atomics MQ9A · S/N 09-4063N260HPAviation Specialties Unlimited CHALLENGER III · S/N 0001N261NAirbus Helicopters AS350B3 · S/N 8916N2658Airbus Helicopters AS350B3 · S/N 8959N267AAmerican Eurocopter AS350B3 · S/N 7222N2691PConsolidated Aeronautics LAKE LA-4-200 · S/N 896First renewal noticeN26ERChristen Industries PITTS S-2B · S/N 5044N28022Bellanca 17-30A · S/N 78-30881N285RSDJI MAVIC AIR · S/N 0K1CF8U3AH5BE5N28KXSukhoi SU-26 · S/N 06-06N28QWPiper PA-28-140 · S/N 28-7425223N2907AAirbus Helicopters AS350B3 · S/N 9216N290MUJames J Mueller MUELLER 90 · S/N 2016-90N296SAirbus Helicopters AS350B3 · S/N 8850N313AWRaytheon B300 · S/N FL-391N314AWRaytheon B300 · S/N FL-387N314SUBalloon Repairs Of East Texas 31A · S/N 001-31N315AWBeech B300 · S/N FL-91N315KMCanadian Vickers PBY5A · S/N CV333N31EJGeneral Atomics MQ-9 BLOCK 1 · S/N GA-6-1013N322VAirbus Helicopters AS350B3 · S/N 8719N324AWPilatus PC-12/47E · S/N 2453N32592Piper PA-28-180 · S/N 28-7505075N3262MCessna 550 · S/N 550-0652
Back to Washington, DC