OpenAirDocs.org
Seattle, WA

Registered aircraft · 1,552

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.

N1018FDehavilland BEAVER DHC-2 · S/N 710Built 1954 · Lind Leasing LLCN1022FCessna A185F · S/N 18502690Built 1975 · Goodfellow Malcolm DN103PAAmazon.Com Services MK30 · S/N 1786501038Amazon.Com Services LLCN1061YNavion NAVION H · S/N NAV-4-2531Built 1969 · Seward Mark AN10647Cessna 150L · S/N 15074945Kosko Stanley GN108PAAmazon.Com Services MK30 · S/N 1786501039Amazon.Com Services LLCN1093Adams Dean L THORP T-18 · S/N 1093Built 1983 · Museum Of Flight FoundationN109JMesserschmitt ME 109 G · S/N 392Built 1975 · Windward Aviation IncN110MFOMF OMF-100-160 · S/N 0010Built 2001 · Hunter Gregory GN110RARadical S-1 EVENSTAR · S/N 001Radical IncN112KFPiper PA-18-150 · S/N 18-7809134Higgins Timothy TN114BSCirrus Design SR20 · S/N 1192Built 2002 · Bravo Sierra LLCN1155GMooney M20J · S/N 24-1245Built 1981 · Hartwig CodyN11880Cessna 150L · S/N 15075683Built 1974 · Carbaugh Nicholas CN119MCBeech B200 · S/N BB-1225Built 1985 · Agave III LLCN11FCBeech 35R · S/N D-25R1Built 1947 · Cooper Matthew AN11KAAerotek PITTS S-2A · S/N 2084Built 1974 · Cloudbase IncN1213SCessna 208 · S/N 20800243Built 1995 · Wright Caravan LLCN121RACessna 182P · S/N 18261660Built 1972 · Johnson Owen M IIIN1226APiper PA-18 · S/N 18-841Walsh BrendanN122MJCessna 172N · S/N 17270043Built 1977 · Hyper Flight IncN1234QBeech 36 · S/N E-165Built 1969 · Dembowski RodrickN123CBCessna 172M · S/N 17262283Built 1973 · C C Flying ClubN123NXPilatus PC-12/47E · S/N 1123Built 2009 · Heimdal Aviation LLCN123SGWard James R/Ward ANN Marie SPORTSMAN GS-2 · S/N 7418Built 2014 · Ward James RN123XCirrus Design SR22T · S/N 10327Built 2024 · 123x LLCN125PAAmazon.Com Services MK30 · S/N 178650103AAmazon.Com Service LLCN126PAAmazon.Com Services MK30 · S/N 178650103BAmazon.Com Services LLCN12817Paulson Jeffrey E STINSON MODEL O · S/N 10Built 2010 · Museum Of Flight FoundationN129BGAmazon.Com Services MK30 · S/N 178650115QAmazon.Com Services LLCN1325JRockwell International 112A · S/N 325Built 1975 · Mcnamara Bradley WN132LMMullen Lee C SPORTS TRAINER · S/N 35520321Built 1998 · Sommer John JN13347Boeing 247D · S/N 1729Built 1933 · Museum Of Flight FoundationN133RMMarsh Roy W RAND-ROBINSON KR-2S · S/N 8103Built 1994 · Safronoff DrewN133SKDJI MINI 5 PRO · S/N 1581F9DEC257D0292D4JSturges Scott KN13477Stinson JR. SR · S/N 8732Built 1933 · Museum Of Flight FoundationN134PAAmazon.Com Services MK30 · S/N 178650103CAmazon.Com Services LLCN135APAmazon.Com Services MK30 · S/N 178650119WAmazon.Com Services LLCN135PAAmazon.Com Services MK30 · S/N 178650118VAmazon.Com Services LLCN1368HAeronca 15AC · S/N 15AC-417Built 1949 · Westlake Aviation LLCN13711Douglas DC2 · S/N 1368Museum Of Flight FoundationN137APApollo MONSOON · S/N 00009Built 2008 · Mcdougall Robert AN138DDouglas DC3C-S1C3G · S/N 2245Built 1940 · Museum Of Flight FoundationN138PAAmazon.Com Services MK30 · S/N 1786501002Built 2023 · Amazon.Com Services LLCN138SPCessna 750 · S/N 750-0138Built 2000 · Fixed Gear 2 LLCN1393JRockwell International 112B · S/N 523Mcnamara Bradley WN139AMAmazon.Com Services MK30 · S/N 1786501079Amazon.Com Services LLCN139PAAmazon.Com Services MK30 · S/N 178650103PAmazon.Com Services LLCN1410Sutterlin William E PITTS S-1 · S/N 7-0489Built 1982 · Swe3 LLCN142ASPiper PA-28-140 · S/N 28-22530Built 1966 · Gray William Colin
Back to Seattle, WA