Shelton, WA
Registered aircraft · 47
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 = 'SHELTON' 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 = 'SHELTON' 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.
N1138VBroussard BROUSSARD MH 1521 · S/N 287N152ZGlade M Ross PORTO AVN GRP RISEN · S/N 35N200KSCessna 208B · S/N 208B0001N2148WCessna T206H · S/N T20608421N224DHRemos REMOS G-3/600 · S/N 183N224TSFlight Design CTSW · S/N 05-11-08N2307XCessna 182H · S/N 18256207N262TMCirrus Design SR22T · S/N 9051N28BGPiper PA-31T · S/N 31T-7720005First renewal noticeN2987CCessna 180 · S/N 30887N3185QCessna 182K · S/N 18258185N321LDTaylorcraft BC12-D · S/N 10544N3320DCessna 180 · S/N 32118N3445SCessna 182J · S/N 18255845N3694UCessna 182G · S/N 18255094First renewal noticeN3763UCessna 182G · S/N 18255163N3914DCessna 182A · S/N 34614N399RBReese Rick Lee SAFARI · S/N 2137N4471CCerretani Casey C BEARHAWK FOUR · S/N CCM448-99-100N482BAIcon A5 · S/N 00092N5063GHughes Helicopters HUGHES 369D · S/N 711021DN510PAHughes Helicopters HUGHES 369D · S/N 811073DN5110VStarduster S-100 · S/N 10N557XWHaynes Joel R VANS RV-7A · S/N 70030N5885ECessna 150 · S/N 17385N605JGRaytheon B300 · S/N FL-158N6074BCessna 182A · S/N 34074N612ESCessna 182P · S/N 18262270N661WACessna 208B · S/N 208B0661N669JWDehavilland DHC-6-200 · S/N 088N683MCubcrafters CC11-160 · S/N CC11-00239N7162GCessna 172K · S/N 17258862N722DSAviat A-1C-180 · S/N 3385N7248KPiper PA-18 · S/N 18-134N72CTFlight Design CTSW · S/N 06-11-10N744DLLoucks Barner D 1650R EROS · S/N 1068First renewal noticeN7476RPiper PA-28-140 · S/N 28-22026N747LRLevy Rene I RV-7 · S/N 70226N7509TCessna 172A · S/N 47109N7580CChisholm JR William G ZENITH 650 · S/N 65-7467N78672Cessna 172K · S/N 17257713N8070Maule M-5-235C · S/N 8070CN84628Cessna 172K · S/N 17258552N8588TCessna 182C · S/N 52488N8961ZCessna 172M · S/N 17262110N947DBLuke Aikins AIKINS BALLOON · S/N 001N9490GJerry Enslow 300L HUMMINGBIRD · S/N 2401
Back to Shelton, WA