Washougal, WA
Registered aircraft · 41
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 = 'WA' AND g.registrant_city = 'WASHOUGAL' 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 = 'WA' AND g.registrant_city = 'WASHOUGAL' 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.
N122MAMitsubishi MU-2B-20 · S/N 207N12433Nord STAMPE SV4C · S/N 23N12EHHelsop-Stitts Playmate SA-11A · S/N 48N150AJCessna 150M · S/N 15076664N159CStinson 108-2 · S/N 108-3159N18075Cessna 180J · S/N 18052511N206JDCessna P206D · S/N P206-0536N247RJR Russel Steiner VANS RV7A · S/N 73575N2826ACessna 180 · S/N 30026N30451Piper J3C-65 · S/N 4840N3218JCessna 150G · S/N 15065918N3238ZPiper PA-22-150 · S/N 22-7183N3265DCessna 180 · S/N 32063N34686Stinson 10A · S/N 7986N35118Rambo Steve SR5XP · S/N 2527N40KRDavid K Domeyer LIL FOKKER D7 · S/N 1N4394FPiper PA-28-151 · S/N 28-7715032N4466RCessna 172M · S/N 17263208N4794VBoeing A75N1(PT17) · S/N 75-5631N49595Piper J3C-65 · S/N G-113N49ABRockwell International 112TC · S/N 13066N5096XChampion 7KCAB · S/N 142N5300HPiper PA-16 · S/N 16-111N53157Boeing A75N1(PT17) · S/N 75-1942N543XAeromot AMT-200(SUPR XIMNGO) · S/N 200046N5881DPiper PA-18A 150 · S/N 18-5305N60HAStrauch Henry/Alice GLASAIR · S/N 219N624STVans RV-12IS · S/N 12181N7131CWsk-Pzl Warzawa-Okecie PZL-104 WILGA 80 · S/N CF20890884N7274GCessna 150L · S/N 15074632N731DBeech C35 · S/N D-3001N734FQCessna 172N · S/N 17268823N8255PPiper PA-24 · S/N 24-3509N8637HNorth American NAVION · S/N NAV-4-637N86669Stits PLAYBOY SA-3A · S/N P-706N8990Glasflugel STANDARD LIBELLE · S/N 9N89PPTl-Ultralight S R O TL 2000 STING S4 · S/N 18 ST 480N9185HCessna 172M · S/N 17265999N9356XCessna 182E · S/N 18253756N97548Stinson 108 · S/N 108548N991RSBrian Peck RV-14 · S/N 140872
Back to Washougal, WA