Puyallup, WA
Registered aircraft · 135
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 = 'PUYALLUP' 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 = 'PUYALLUP' 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.
N10819Stinson JR. S · S/N 8003N109DKKeel Danny A RV9 · S/N 91215N11290Cessna 150L · S/N 15075303N12110Cessna 172M · S/N 17261815N1219BLuscombe 8A · S/N 5846N131FHBucker-Jungman 131 · S/N 1011N1507QCessna 150L · S/N 15072807N15XABeech A36 · S/N E-732N165YPCessna 172R · S/N 17280752N169RWBeech B200 · S/N BB-1030N172PTCessna 172N · S/N 17270734N1816QCessna 177RG · S/N 177RG0216N1817QCessna 177RG · S/N 177RG0217N1879ECessna 340A · S/N 340A0658N191KASteven D Bailey/Steven W Baile RYAN STL · S/N 1000-30N1991PCessna 182P · S/N 18263326N20053Cessna 172M · S/N 17260965N20236Cessna 172M · S/N 17261120N20481Cessna 172M · S/N 17261324N20668Cessna 172M · S/N 17261475N21318Piper PA-44-180 · S/N 44-7995046N21332Cessna 182P · S/N 18261566N221TJCessna 172N · S/N 17271059N22429Cessna 172M · S/N 17264064N23288Piper J3C-65 · S/N 3043N2393CCessna 180 · S/N 30693N23DHCessna 182P · S/N 18264053N2417HEngineering & Research ERCOUPE 415-C · S/N 3042N2475XCessna 182H · S/N 18256375N254WGCessna A185F · S/N 18503572N2637CCessna R182 · S/N R18200188N26962Gulfstream American AA-5A · S/N AA5A0842N2714EAeronca 7AC · S/N 7AC-6294N29298Culver LCA · S/N 167N30901Piper J3C-65 · S/N 5176N3112BCessna 170B · S/N 25354N3155QCessna 182K · S/N 18258155N3208BPiper PA-22-135 · S/N 22-2035N3217CBeech E35 · S/N D-3881N323SFJames Ausbun KITFOX S7 STI · S/N KA20150451N33000Sindlinger HAWKER HURRICANE · S/N HH-1N36JCCessna 172M · S/N 17261759N3781XAero Commander 100 · S/N 275N385PCCummings Jp/Cummings RS CUMMINGS RV-9 · S/N 006N386DCGreenleaf Douglas J RV-6 · S/N 23355N3908JCessna 150G · S/N 15065208N3924TPiper PA-28R-180 · S/N 28R-30262N3987NMooney M20F · S/N 680153N401TFVans RV-12 · S/N 120664N4032DCessna 182A · S/N 34732
Back to Puyallup, WA