Sequim, WA
Registered aircraft · 116
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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 = 'SEQUIM' 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 = 'SEQUIM' 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.
N107JMMink James ZODIAC 601 XL · S/N 6-5658N1084LMooney M20J · S/N 24-3394N10SSGlobe GC-1B · S/N 203N111TYLake LA-4-200 · S/N 468N1143UCessna 140 · S/N 11652N120LMMckone Laurel A VANS RV9A · S/N 90120N125RWPanda Ventures SPORTSMAN GS-2 · S/N 7378N1689DCessna 170B · S/N 20331N17ZAYakovlev YAK-3M · S/N 0470102N182SLCessna 182P · S/N 18261078N189SCSix Chuter West LEGEND XL · S/N 3149N19936Cessna 172M · S/N 17260870N20111Cessna 172M · S/N 17261019N202MKCampbell Michael W G-202 · S/N G-2020011N20419Six Chuter SR7 XL · S/N 99-2201-SR7XLN20439Cessna 172M · S/N 17261289N2100Oman Lee GEE BEE R-1 (RPLICA) · S/N 001N22706Cessna 150H · S/N 15068461N2449HErcoupe 415-C · S/N 3074N2485MPiper PA-12 · S/N 12-1559N2681NCessna 120 · S/N 12939N269JLLondo Jim GLASTAR · S/N 5020N276DMMedema Doug VANS RV-6A · S/N 21140N297Halsted Barry BH 1 · S/N 001N2990PConsolidated Aeronautics LAKE LA-4-200 · S/N 955N3072WBeech A36 · S/N E-492N314MLLong Mark D SEAREY LSX · S/N 1LK484CN3173LNorth American AT-6 · S/N 413279N321DGrumman American Avn. AA-1B · S/N AA1B0321N3389ECessna 172N · S/N 17271528N34244Cessna 177B · S/N 17701731N34528Cessna 177B · S/N 17701859N36CEMooney M20J · S/N 24-1321N3773KGlobe GC-1B · S/N 1466N38028Piper J5A · S/N 5-840N3808RPiper PA-28-180 · S/N 28-5834N3926FCessna 172 · S/N 36826N4141LCessna 172G · S/N 17254210N4225CIrwin Steve FS II SC · S/N 345N4308BCessna 170B · S/N 26652N434DRRichardson David C RV-7 · S/N 71456N43MGWiederhold Patrick M VANS RV-7A · S/N 71175N4483CPiper PA-24-250 · S/N 24-1257N456BRCessna P210N · S/N P21000717N46871Boeing A75N1(PT17) · S/N 75-1724N48549Cessna 152 · S/N 15283349N4856LPiper PA-28-180 · S/N 28-4205N48616Interstate S-1B1 · S/N 78N48HRFeltham Glen A RV-8 · S/N 81972N4957HPiper PA-11 · S/N 11-831
Back to Sequim, WA