Anacortes, WA
Registered aircraft · 106
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 = 'ANACORTES' 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 = 'ANACORTES' 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.
N105SGlasflugel STANDARD LIBELLE · S/N 118N106CMMclean Clarence D F1 ROCKET · S/N 0011N10ZSJohn S Durbrow VANS RV-3B · S/N 11379N13333Cessna 172M · S/N 17262677N139ZAAero Vodochody L-39ZA · S/N 734105N158VTravel Air 4000 · S/N 1397N1668GChampion 7ECA · S/N 641N16TXMurphree David H RV-6 · S/N 22657N1912XCessna 182H · S/N 18256012N19JFJonathan E Fay CH 750 CRUZER · S/N 75-10766N20196Cessna 172M · S/N 17261088N201LBBecker Lawrence D SCORPION · S/N 201N202LBBecker Lawrence D BECKER COUGAR · S/N 1N21XJCirrus Design SR20 · S/N 2019N2260Maule M-7-260C · S/N 30035CN22WZSmith David B MONTANAN SUPERCUB · S/N 001N234BWCessna P210N · S/N P21000290N2431MPiper PA-12 · S/N 12-1675N2493YCessna 172D · S/N 17249793N26315Aeronca 65-LA · S/N LA-7810N2682ABeech V35A · S/N D-9045N2714DCessna 170B · S/N 25256N2765XCessna 180H · S/N 18051565N2771WMooney M20E · S/N 1057N28446Grumman American Avn. AA-5B · S/N AA5B0614N29502Taylorcraft BC-65 · S/N 2303N296DMPiper PA-28R-200 · S/N 28R-7635033N2998Aero Vodochody L29 · S/N 294683N29JWIsrael Aircraft Industries GULFSTREAM G150 · S/N 205N3014GPiper PA-28-236 · S/N 28-7911072N3020SPiper PA-28-161 · S/N 28-7916295N33035Siewert Irving HATZ CB-1 · S/N 409N33201Piper J3C-65 · S/N 5909N34710Cessna 177B · S/N 17701949N34MTBeech D-45 · S/N BG-417N35BMBeech V35B · S/N D-9191N364CFCubcrafters CC11-160 · S/N CC11-00364N375WCessna A185F · S/N 18503598N390MFOMF OMF-100-160 · S/N 0039N399TARaytheon A36 · S/N E-3311N4023WWsk-Pzl Warzawa-Okecie PZL-104 WILGA 80 · S/N CF 21910930N416DDDecker Richard A AVID - DECKER · S/N 632875N42376Cessna 180J · S/N 18052348N4237HPiper PA-14 · S/N 14-40N454SLSteven Lynn VANS RV-7A · S/N 73353N4651GCessna 172N · S/N 17273277N4790DCessna 182A · S/N 34890N4841CCessna A185F · S/N 18502609N48XLake LA-4-200 · S/N 560N491CXJohnson Lytle D NORTH STAR · S/N 121
Back to Anacortes, WA