Seattle, WA
Registered aircraft · 1,640
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 = 'SEATTLE' 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 = 'SEATTLE' 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.
N216HAAirbus A321-271N · S/N 8471N217HAAirbus A321-271N · S/N 8578N2186ZCessna T206H · S/N T20608559N218HAAirbus A321-271N · S/N 8764N219PAAmazon.Com Services MK30 · S/N 178650100KN21SGCessna 421C · S/N 421C0039N220PAAmazon.Com Services MK30 · S/N 178650100LN22199Piper PA-28-181 · S/N 28-7990070N2219JCessna 150G · S/N 15065419N223BGAmazon.Com Services MK30 · S/N 178650115VN223HAAirbus A321-271N · S/N 9060N223PAAmazon.Com Services MK30 · S/N 178650100MN223TMMadsen C Thomas SR Z-HI MAX/MAK-1 · S/N ZHM-728N2243NPiper PA-28RT-201T · S/N 28R-7931052N224AKBoeing 737-990ER · S/N 62680N225APAmazon.Com Services MK30 · S/N 1786501194N225NBombardier CL-600-2B16 · S/N 5652N226CRMooney M20K · S/N 25-0570N226HAAirbus A321-271N · S/N 9127N226LRCrist-Steckmeyer GLASAIR SH-2 · S/N 226N227NDehavilland DHC 2 MK III · S/N 1686-TB54N228CCCirrus Design SR22T · S/N 0713N228HAAirbus A321-271N · S/N 9274N228NTextron 208B · S/N 208B5601N228PAAmazon.Com Services MK30 · S/N 178650100NN229BGAmazon.Com Services MK30 · S/N 1786501149N229NCessna 560 · S/N 560-0759N230BGAmazon.Com Services MK30 · S/N 178650118CN231DVMooney M20K · S/N 25-0173N231ERMooney M20K · S/N 25-0213N231PPMooney M20K · S/N 25-0342N2320BTemco GC-1B · S/N 3620N233BGAmazon.Com Services MK30 · S/N 1786501132N233NDehavilland DHC-2 · S/N 976N234AWPilatus PC-12/47E · S/N 1369N2358QBeech 23 · S/N M-427N235APAmazon.Com Services MK30 · S/N 1786501195N236AKBoeing 737-990ER · S/N 36351N236BGAmazon.Com Services MK30 · S/N 178650116HN2379MPiper PA-12 · S/N 12-1624N237AKBoeing 737-990ER · S/N 36357N237APAmazon.Com Services MK30 · S/N 1786501196N23802Cessna 206H · S/N 20608137N238AKBoeing 737-990ER · S/N 62681N238APAmazon.Com Services MK30 · S/N 1786501197N238DCDiamond Aircraft Ind DA 40 · S/N 40.967N238PAAmazon.Com Services MK30 · S/N 178650100QN238USDiamond Aircraft Ind DA 42 · S/N 42.AC128N2397TPiper PA-28-140 · S/N 28-7225070N239PAAmazon.Com Services MK30 · S/N 178650103F
Back to Seattle, WA