White Salmon, WA
Registered aircraft · 37
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 = 'WHITE SALMON' 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 = 'WHITE SALMON' 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.
N104UBritt Reed GLASTAR · S/N 5400N115WWWilliston Everett S GLASAIR III · S/N 3087N128YHelicopteres Guimbal CABRI G2 · S/N 1128N132USXag V40 · S/N 81022356A78NN142TPiper PA-18 · S/N 18-2256N1726PPiper PA-22-150 · S/N 22-2516N229PWJohn M Toudouze RANS S-21 · S/N 02200088N242CDCool/Deboer STARDUSTER TOO SA300 · S/N 1N247ZHWilson Jeffrey B ESCAPADE · S/N JAES C0042N26KTTom Hamilton KITFOX S7 · S/N KT2021N300WFCessna 182S · S/N 18280015N30760Jones Tim/Preuss George RV6A · S/N 60476N311DPfeiffer Don A RV8 · S/N 81159N32986Piper J5A · S/N 5-424N35343Cessna T206H · S/N T20608284N40303Maule M-4-180C · S/N 3006CN5057LBellanca 8KCAB · S/N 547-79N510VCessna 310L · S/N 310L-0113N5175DPiper PA-18-150 · S/N 18-8438N518SWPiper PA-18A 150 · S/N 18-4389N5274DCessna 180A · S/N 50172N5646HPiper PA-16 · S/N 16-257N607DWWhite David E RANS S-6ES · S/N 10061773N612KEEvektor-Aerotechnik SPORTSTAR · S/N 20060704N6290VCessna 172RG · S/N 172RG0610N6989BPiper PA-18A 150 · S/N 18-5111N711UDCessna 305C (0-1E) · S/N 24580N7264HCessna T206H · S/N T20608103N7766SSchweizer SGS 2-33A · S/N 136N79PKCessna A185F · S/N 18503837N8235CKramp Eugene H RV-6A · S/N 22581N8246ZCessna 210-5(205) · S/N 205-0246N8370UCessna 172F · S/N 17252270N912MDDuensing M J RV-4 · S/N 912N928HCessna 172E · S/N 17251734N9534DPiper PA-22-160 · S/N 22-6450N969EZMaule M-7-235C · S/N 25070C
Back to White Salmon, WA