Enumclaw, WA
Registered aircraft · 49
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 = 'ENUMCLAW' 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 = 'ENUMCLAW' 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.
N104TRCessna A185F · S/N 18503212N1078APiper PA-18-135 · S/N 18-662N13PWGlasflugel STD LIBELLE 201B · S/N 189N157AJPzl-Swidnik PW-5 · S/N 17.10.018N195JLCessna 195 · S/N 7944N20366Cessna 172M · S/N 17261228N20520Cessna 172M · S/N 17261358N210WTCessna T210L · S/N 21059528N236MCChristler Melvin H CURRIE-WOT · S/N 01N2481GCessna 182B · S/N 51781N2513Cougar 1 · S/N 1513Registration revokedN2544YCessna 172D · S/N 17249844N2545MPiper PA-12 · S/N 12-931N2683DCessna 170B · S/N 20835N2746GCessna 182B · S/N 52046N274DBCessna 182K · S/N 18257629N2842PPiper PA-22-150 · S/N 22-3139N30640Piper PA-28R-201T · S/N 28R-7803369N32461Piper J3C-65 · S/N 5242N3300BPiper PA-22-135 · S/N 22-2114N35034Cessna 177B · S/N 17702170N3532PPiper PA-22 · S/N 22-3287N356WCVans RV-12IS · S/N 121304N3904PPiper PA-22-150 · S/N 22-3573N4034GMccausey Cam CHINOOK PLUS 2 · S/N 02198XSN412JNVans RV-12 · S/N 120577N4623JPiper PA-28R-180 · S/N 28R-30509N5030JAerostar International RXS-8 · S/N RXS8-3121N5124QAerostar International RX 8 · S/N RX8-3317N52920Piper J5C · S/N 5-1427N5624Stinson L-5 · S/N 42-99441N5754FPiper PA-28-140 · S/N 28-25057N589CBBryan Curtis L VANS RV-4 · S/N 589N6076FCessna 182P · S/N 18264091N63DTJones R E/Newell R J RV6A · S/N 23762N6819VAerostar Acft Corp Of Texas M20E · S/N 21-0006N6854UMooney M20C · S/N 2559N7150TCessna 172 · S/N 46750N7551SCessna 182Q · S/N 18265200N7597SCessna 182Q · S/N 18265246N766PWPzl-Swidnik PW-6U · S/N 78.03.06N8005HArbc Inc DBA Lindstrand 90A · S/N 5802N8111ZCessna 210-5(205) · S/N 205-0111N8286KStinson 108-1 · S/N 1081286N8457RCubcrafters CC11-160 · S/N CC11-00248N84840Cessna 172K · S/N 17258638N8585UCessna 172F · S/N 17252485N914BLet L-23 SUPER BLANIK · S/N 917914N9514PGeister Allan A CHALLENGER II · S/N QCACCH295
Back to Enumclaw, WA