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.

N142PAAmazon.Com Services MK30 · S/N 178650103DAmazon.Com Services LLCN143PAAmazon.Com Services MK30 · S/N 178650103EAmazon.Com Services LLCN143SFSno Fly CH 650 · S/N 65-10372Built 2017 · Sno FlyN144AHRobinson Helicopter R44 · S/N 0865Built 2001 · Atomic Helicopters LLCN145AMAmazon.Com Services MK30 · S/N 178650107AAmazon.Com Services LLCN145DGGilmore Daniel A GS-2 SPORTSMAN · S/N 7142Built 2007 · Schiemer Charles WN146PAAmazon.Com Services MK30 · S/N 1786501005Amazon.Com Services LLCN147APAmazon.Com Services MK30 · S/N 178650119XAmazon.Com Services LLCN147BGAmazon.Com Services MK30 · S/N 1786501144Amazon.Com Services LLCN14DHCirrus Design SR22 · S/N 3000Built 2008 · Denisenkov DmitryN15000Cessna 172K · S/N 17258075Built 1969 · Central District Aviation LLCN150APAmazon.Com Services MK30 · S/N 1786501190Amazon.Com Services LLCN150SCCessna TU206F · S/N U20601958Built 1973 · Anderson Thomas RN151PZCessna 150C · S/N 15059719Built 1962 · Marvin NeilN151SGStemme STEMME S 12 · S/N 12-041Built 2021 · Gurevich AlanN1520APiper PA-20 · S/N 20-710Built 1951 · Bush James RN152PAAmazon.Com Services MK30 · S/N 1786501007Built 2023 · Amazon.Com Services LLCN1597HCessna 177RG · S/N 177RG0771Built 1975 · Aerobox LLCN159PAAmazon.Com Services MK30 · S/N 1786501008Built 2023 · Amazon.Com Services LLCN1601HAirbus Helicopters Deutschland EC135T3 · S/N 1134Built 2013 · Valkyrie Europe LLCN1627Junior G Morrow BGL SPECIAL · S/N 0021Built 2015 · Johns Trevor MN162BGAmazon.Com Services MK30 · S/N 1786501177Amazon.Com Services LLCN162PAAmazon.Com Services MK30 · S/N 1786501009Built 2023 · Amazon.Com Services LLCN163DLMooney M20TN · S/N 31-0055Built 2007 · Mooplane LLCN164PDBodie Peter J JR VANS RV-6A · S/N 24705Built 2003 · Karimi AshkanN1656CCessna 180 · S/N 30356Built 1953 · Anderson Thomas RN165AMAmazon.Com Services MK30 · S/N 178650107BAmazon.Com Services LLCN168PAAmazon.Com Services MK30 · S/N 178650100ABuilt 2023 · Amazon.Com Services LLCN16ESDiamond Aircraft Ind DA 42 · S/N 42.AC100Built 2007 · Meow Meow LLCN170APAmazon.Com Services MK30 · S/N 1786501191Amazon.Com Services LLCN1718DCessna 170A · S/N 20161Built 1951 · Swe3 LLCN171UCessna 182R · S/N 18268147Built 1982 · Nancy Unicorn LLCN17384Boeing E75 · S/N 75-5741Built 1960 · Bright J TobiasN173ARPhoenix Air Sro U-15 PHOENIX · S/N 24/U15Built 2013 · N173ar LLCN173RJCessna 170B · S/N 26269Johnston Ronald EN17476Bell H13G · S/N 52-7993Built 1952 · Aviation Maintenance TechnologyN174PAAmazon.Com Services MK30 · S/N 178650100BAmazon.Com Services LLCN175APAmazon.Com Services MK30 · S/N 1786501192Amazon.Com Services LLCN1763WBeech A36 · S/N E-406Built 1973 · 63 Whiskey LLCN1780FDJI PHANTOM 4 PRO V2.0 · S/N 11UFC7MOA50304Fennell Christopher SN179PAAmazon.Com Services MK30 · S/N 178650100CAmazon.Com Services LLCN17VPGary Schmitt JA30 SUPERSTOL · S/N JA433-01-15Built 2016 · Avstar IncN17WBoeing B-17F · S/N 42-29782Built 1942 · Museum Of Flight FoundationN180SCessna 180J · S/N 18052317Built 1973 · Bensinger William IN1810ZCessna 210-5(205) · S/N 2050010Built 1962 · Ranzway CorpN181MECessna T206H · S/N T20608182Built 2000 · Coastal Marine Engine IncN181MXRonda Donald E MONI · S/N 00181Ronda Michael EN181PAAmazon.Com Services MK30 · S/N 178650100DAmazon.Com Services LLCN182KQQuest KODIAK 100 · S/N 100-0182Built 2016 · Snl Aviation LLCN182MGCessna T182T · S/N T18208046Built 2001 · Turnidge Austin Michael
Back to Seattle, WA