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.
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
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.
N101GJJohnson George O MODIFIED KR-1 · S/N GJ-101N1033CMaule M-7-235C · S/N 25012CN10471Adcox Special STUDENT PRINCE · S/N 2N10686Aircraft Builders STUDENT PRINCE X · S/N 103N107DDDean David E DR-107 · S/N 95-0295N11513Cessna 150L · S/N 15075475N11809Curtiss Wright JR CW1 · S/N 1184N123WRBruce Peter P AVID MARK IV · S/N 1489DN123YYBruce Peter Paul RENEGADE SPIRIT · S/N 709Registration expired, pending cancellationN13167Fairchild 22 C7B · S/N 1506N1366Oficinas Gerais De Matereal AR CHIPMUNK MK20 · S/N C1/1366N1502WAvian Balloon SKYHAWK · S/N 102N150JTFerguson FERGY II B · S/N 00-2B-001N1514DCessna 195A · S/N 7736N16205Waco YQC-6 · S/N 4405N16529Aeronca C-3 · S/N A-673N17074Beech C17B · S/N 132N17641Bowlus BA-100 · S/N 174N17PBPitts Special BMP · S/N 7N180TBCessna 180F · S/N 18051273N18406Stinson SR-9C · S/N 5312N186PDJohnson R H/Albrecht P H RV-6 · S/N 22096N19213Piper J-2 · S/N 1613N19489Cessna C-145 · S/N 459N2063LBeech B19 · S/N MB-809N2162PPiper PA-23 · S/N 23-764N22256Taylorcraft BC · S/N 1204N22671Taylorcraft BL · S/N 1318N251SGoodwin Stephen E FISHER SUPERKOALA · S/N SK101First renewal noticeN252RSMooney M20K · S/N 25-1133N2536ZBellanca 7ECA · S/N 1250-78N27233Rearwin 175 · S/N 1508N28517Fairchild 24W-40 · S/N W40-129N2864ZPiper PA-22-150 · S/N 22-6871N2868ACessna 180 · S/N 30068N288LLGrumman American Avn. AA-1B · S/N AA1B-0365N2896DWaco YKS-7 · S/N 4692N2906VCallair A-3 · S/N 122N2907VCallair A-2 · S/N 123N2944HErcoupe 415-C · S/N 3569N29553Taylorcraft BL-65 · S/N 2396N2963HErcoupe 415-C · S/N 3588N30154Ted Robinson LITTLE MIKE · S/N 1N304CDUltralight Flight PHANTOM · S/N 484N3062PConsolidated Aeronautics LAKE LA-4-200 · S/N 972N311TPiper PA-18-105 SPECIAL · S/N 18-2425N315KTMooney M20M · S/N 27-0316N323TPiper PA-18 105 · S/N 18-2437N326EJCurtis ED CURTIS/SKYBOLT · S/N 001N33395Commonwealth 185 · S/N 1616
Back to Port Townsend, WA