OpenAirDocs.org
Friday Harbor, WA

Registered aircraft · 100

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 = 'FRIDAY HARBOR'
  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.

N1032MCessna 150K · S/N 15071732Built 1970 · Hoyer Bryan HN12212Cessna 172M · S/N 17261884Built 1973 · Wilson Donovan FN12440Cessna 172M · S/N 17261983Built 1973 · Bill Myer Services IncN1294XMooney M20E · S/N 167Built 1963 · Mcglynn BrianN145JGGeldermann Bert E LANCAIR LEGACY · S/N L2K-230Built 2005 · Geldermann Bert EN146BUPiper PA-46-310P · S/N 46-8408057Built 1984 · Saltwater Aviation LLCN1506VCessna 172M · S/N 17263634Built 1974 · Deshon LorenN16351Piper PA-28-180 · S/N 28-7305231Built 1973 · Degraaff Norman LN180FGGuenther Fredric A DR 107 · S/N DR1074FGRoberts Todd LN1995WReinhardt Quelle SPORTSMAN GS-2 · S/N 7460Built 2017 · Quelle ReinhardtN2003NMooney M20K · S/N 25-2005Built 1997 · Widdoes L Curtis JrN2014BLuscombe 8A · S/N 6441Built 1948 · Root Daniel JN21295Cessna 172M · S/N 17263925Built 1974 · Tauscher Robert CN219MCCessna 182T · S/N 18281323Built 2004 · Hansen ToddN225MCPiper PA 46-350P · S/N 4636239Built 1999 · P46 Tango LLCN231PTCessna P210N · S/N P21000551Built 1980 · Lobbytools Aviation LLCN25QRaytheon A36 · S/N E-3398Built 2001 · Grant JaniceN28062Bellanca 17-30A · S/N 79-30906Built 1978 · Alger Mark DN29127Cessna U206C · S/N U206-1097Built 1968 · Shivers William L JrN2913TAero Commander 200D · S/N 319Built 1966 · Blaine ChristopherN311FHJamieson Robert HATZ CB1 · S/N 242First renewal noticeBuilt 2010 · Jamieson Robert FN3228NPiper J3C-65 · S/N 22420Built 1946 · Spoor Rhys DN332BWVans RV-12IS · S/N 121631Built 2006 · Willows A O DennisN34156Cessna 177B · S/N 17701674Built 1971 · King Gregory JN35618Cessna 172I · S/N 17256866San Juan Flyers LLCN3580JCessna 150E · S/N 15061280Built 1965 · Jamieson Robert FN3615RPiper PA-28-180 · S/N 28-5711Morrissey William T TrusteeN378TACirrus Design SR22T · S/N 2160Built 2020 · Full Time Betty LLCN3848QCessna 172L · S/N 17259948Built 1971 · Westwind Flyers LLCN3882GCessna U206B · S/N U206-0882Built 1967 · Ranier Flight Service LLCN3954FCessna 172 · S/N 36854Built 1958 · Gossom J BurkN3980SCessna 172E · S/N 17251180Thompson Richard LN3YHCirrus Design SR22 · S/N 0239Built 2002 · Marsaudon DavidN4189EAeronca 11CC · S/N 11CC-89Built 1947 · Jamieson Robert FN422RVMachin Doran G VAN'S AIRCRAFT RV6 · S/N 21422Built 1998 · Machin Geoffrey CN4282NIlleges R/Goin K KITFOX IV · S/N 1596Seabright CorpN43085Taylorcraft BC12-D · S/N 6744Built 1946 · Edgington Quinn AN4404JPiper PA-28-140 · S/N 28-22798Built 1967 · Fly Like A Girl LLCN44AKSmith AEROSTAR 601P · S/N 61P-0481-194Built 1978 · Avcom CoN4688HPiper PA-17 · S/N 17-86Chouinard Christopher PN471FBeech 35-B33 · S/N CD-810Built 1964 · Mccullough Kevin CN488SCessna 414 · S/N 4140529Sale reported, pending cancellationN4895PPiper PA-23-250 · S/N 27-482Built 1961 · Klein Barry AN4991FCessna TU206B · S/N U206-0691Built 1966 · Chouinard Christopher PN5066ACessna 172 · S/N 28066Built 1955 · Thordarson Norman KN511EXCessna 208B · S/N 208B5011Built 2013 · Cannery Leasing LtdN5244UCessna 206 · S/N 206-0244Built 1964 · Roberts ToddN5340CCessna 140A · S/N 15460Built 1950 · Custis James GN555AMPiper PA-32RT-300 · S/N 32R-7885187Built 1978 · Edgewater Ventures LLCN5845ZRobert Percival MURPHY REBEL · S/N 230RBuilt 1996 · Geldermann Bert E
Back to Friday Harbor, WA