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.

N216HAAirbus A321-271N · S/N 8471Built 2018 · Hawaiian Airlines IncN217HAAirbus A321-271N · S/N 8578Built 2018 · Hawaiian Airlines IncN2186ZCessna T206H · S/N T20608559Built 2005 · National Products IncN218HAAirbus A321-271N · S/N 8764Built 2019 · Hawaiian Airlines IncN219PAAmazon.Com Services MK30 · S/N 178650100KBuilt 2024 · Amazon.Com Services LLCN21SGCessna 421C · S/N 421C0039Built 1976 · Two One Sierra Golf LLCN220PAAmazon.Com Services MK30 · S/N 178650100LBuilt 2024 · Amazon.Com Services LLCN22199Piper PA-28-181 · S/N 28-7990070Built 1978 · Charlie Whiskey Flying LLCN2219JCessna 150G · S/N 15065419Built 1966 · Mcnamara Bradley WN223BGAmazon.Com Services MK30 · S/N 178650115VAmazon.Com Services LLCN223HAAirbus A321-271N · S/N 9060Built 2019 · Hawaiian Airlines IncN223PAAmazon.Com Services MK30 · S/N 178650100MBuilt 2024 · Amazon.Com Services LLCN223TMMadsen C Thomas SR Z-HI MAX/MAK-1 · S/N ZHM-728Schmitt Laura MmN2243NPiper PA-28RT-201T · S/N 28R-7931052Built 1979 · Barclay Alexander CN224AKBoeing 737-990ER · S/N 62680Built 2016 · Alaska Airlines IncN225APAmazon.Com Services MK30 · S/N 1786501194Amazon.Com Services LLCN225NBombardier CL-600-2B16 · S/N 5652Built 2006 · Jbw Aircraft Leasing Co IncN226CRMooney M20K · S/N 25-0570Bentley Mooney LLCN226HAAirbus A321-271N · S/N 9127Built 2019 · Hawaiian Airlines IncN226LRCrist-Steckmeyer GLASAIR SH-2 · S/N 226Anderson ThomasN227NDehavilland DHC 2 MK III · S/N 1686-TB54T B Plane LLCN228CCCirrus Design SR22T · S/N 0713Airheading LLCN228HAAirbus A321-271N · S/N 9274Built 2019 · Hawaiian Airlines IncN228NTextron 208B · S/N 208B5601Built 2020 · Mpe Beaver LLCN228PAAmazon.Com Services MK30 · S/N 178650100NBuilt 2024 · Amazon.Com Services LLCN229BGAmazon.Com Services MK30 · S/N 1786501149Amazon.Com Services LLCN229NCessna 560 · S/N 560-0759Built 2007 · Jbw Aircraft Leasing Co IncN230BGAmazon.Com Services MK30 · S/N 178650118CAmazon.Com Services LLCN231DVMooney M20K · S/N 25-0173Built 1979 · Lansinger Edward JN231ERMooney M20K · S/N 25-0213Mooney Hunters LLCN231PPMooney M20K · S/N 25-0342Built 1980 · Blackdog Air LLCN2320BTemco GC-1B · S/N 3620Built 1948 · Kuffel Florian LN233BGAmazon.Com Services MK30 · S/N 1786501132Amazon.Com Services LLCN233NDehavilland DHC-2 · S/N 976Jw LtdN234AWPilatus PC-12/47E · S/N 1369Built 2012 · N234aw LLCN2358QBeech 23 · S/N M-427Bertrand Jason AN235APAmazon.Com Services MK30 · S/N 1786501195Amazon.Com Services LLCN236AKBoeing 737-990ER · S/N 36351Built 2016 · Alaska Airlines IncN236BGAmazon.Com Services MK30 · S/N 178650116HAmazon.Com Services LLCN2379MPiper PA-12 · S/N 12-1624Built 1946 · Thies Trevor HN237AKBoeing 737-990ER · S/N 36357Built 2016 · Alaska Airlines IncN237APAmazon.Com Services MK30 · S/N 1786501196Amazon.Com Services LLCN23802Cessna 206H · S/N 20608137Built 2000 · Gherst Richard HN238AKBoeing 737-990ER · S/N 62681Built 2016 · Alaska Airlines IncN238APAmazon.Com Services MK30 · S/N 1786501197Amazon.Com Services LLCN238DCDiamond Aircraft Ind DA 40 · S/N 40.967Built 2008 · Kick Tires Light Fires LLCN238PAAmazon.Com Services MK30 · S/N 178650100QBuilt 2024 · Amazon.Com Services LLCN238USDiamond Aircraft Ind DA 42 · S/N 42.AC128Built 2008 · Meow Meow LLCN2397TPiper PA-28-140 · S/N 28-7225070Built 1971 · Sound Approach Aviation LLCN239PAAmazon.Com Services MK30 · S/N 178650103FAmazon.Com Services LLC
Back to Seattle, WA