Port Townsend, WA

Registered aircraft · 120

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 = 'PORT TOWNSEND'
  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.

N101GJJohnson George O MODIFIED KR-1 · S/N GJ-101Built 1987 · Morrison Neil EN1033CMaule M-7-235C · S/N 25012CBuilt 1997 · Huson Lee EN10471Adcox Special STUDENT PRINCE · S/N 2Built 1929 · Dyson Keith AN10686Aircraft Builders STUDENT PRINCE X · S/N 103Built 1931 · Martell SummerN107DDDean David E DR-107 · S/N 95-0295Built 2016 · Dean David EN11513Cessna 150L · S/N 15075475Built 1973 · Erickson Tristan ScottN11809Curtiss Wright JR CW1 · S/N 1184Port Townsend Aero MuseumN123WRBruce Peter P AVID MARK IV · S/N 1489DBuilt 1995 · Bruce Peter PN123YYBruce Peter Paul RENEGADE SPIRIT · S/N 709Registration expired, pending cancellationBruce Peter PN13167Fairchild 22 C7B · S/N 1506Built 1933 · Port Townsend Aero MuseumN1366Oficinas Gerais De Matereal AR CHIPMUNK MK20 · S/N C1/1366Built 1959 · Port Townsend Aero MuseumN1502WAvian Balloon SKYHAWK · S/N 102Built 1982 · Port Townsend Aero MuseumN150JTFerguson FERGY II B · S/N 00-2B-001Built 2006 · Scherer James SN1514DCessna 195A · S/N 7736Built 1951 · Port Townsend Aero MuseumN16205Waco YQC-6 · S/N 4405Built 1936 · Port Townsend Aero MuseumN16529Aeronca C-3 · S/N A-673Built 1959 · Port Townsend Aero MuseumN17074Beech C17B · S/N 132Built 1937 · Port Townsend Aero MuseumN17641Bowlus BA-100 · S/N 174Port Townsend Aero MuseumN17PBPitts Special BMP · S/N 7Built 1970 · Port Townsend Aero MuseumN180TBCessna 180F · S/N 18051273Built 1963 · Port Townsend Aero MuseumN18406Stinson SR-9C · S/N 5312Built 1937 · Port Townsend Aero MuseumN186PDJohnson R H/Albrecht P H RV-6 · S/N 22096Built 1999 · Starfighter Holdings LLCN19213Piper J-2 · S/N 1613Built 1947 · Port Townsend Aero MuseumN19489Cessna C-145 · S/N 459Built 1938 · Port Townsend Aero MuseumN2063LBeech B19 · S/N MB-809Built 1976 · Peterson Eric TN2162PPiper PA-23 · S/N 23-764Built 1956 · Lark Aircraft LeasingN22256Taylorcraft BC · S/N 1204Built 1939 · Port Townsend Aero MuseumN22671Taylorcraft BL · S/N 1318Built 1939 · Snider TimN251SGoodwin Stephen E FISHER SUPERKOALA · S/N SK101First renewal noticeBuilt 1995 · Goodwin Stephen EN252RSMooney M20K · S/N 25-1133Hoover Bradley EugeneN2536ZBellanca 7ECA · S/N 1250-78Lemanski Thomas AN27233Rearwin 175 · S/N 1508Built 1940 · Port Townsend Aero MuseumN28517Fairchild 24W-40 · S/N W40-129Port Townsend Aero MuseumN2864ZPiper PA-22-150 · S/N 22-6871Built 1959 · Uecker Todd MN2868ACessna 180 · S/N 30068Built 1953 · Taylor Eric CN288LLGrumman American Avn. AA-1B · S/N AA1B-0365Witold SiekajN2896DWaco YKS-7 · S/N 4692Built 1938 · Port Townsend Aero MuseumN2906VCallair A-3 · S/N 122Lark Aircraft LeasingN2907VCallair A-2 · S/N 123Built 1949 · Port Townsend Aero MuseumN2944HErcoupe 415-C · S/N 3569Port Townsend Aero MuseumN29553Taylorcraft BL-65 · S/N 2396Built 1940 · Eggert Robert SN2963HErcoupe 415-C · S/N 3588Built 1946 · Suryan Sheri AN30154Ted Robinson LITTLE MIKE · S/N 1Port Townsend Aero MuseumN304CDUltralight Flight PHANTOM · S/N 484Built 1995 · Berson William JN3062PConsolidated Aeronautics LAKE LA-4-200 · S/N 972Built 1979 · Stay LaurenceN311TPiper PA-18-105 SPECIAL · S/N 18-2425Built 1953 · Lark Aircraft LeasingN315KTMooney M20M · S/N 27-0316Built 2001 · Moonrise Flyers IncN323TPiper PA-18 105 · S/N 18-2437Built 1953 · Lark Aircraft LeasingN326EJCurtis ED CURTIS/SKYBOLT · S/N 001Built 1999 · Port Townsend Aero MuseumN33395Commonwealth 185 · S/N 1616Built 1946 · Cohn David A
Back to Port Townsend, WA