Lopez Island, WA

Registered aircraft · 36

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 = 'LOPEZ ISLAND'
  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.

N11DKDittus/Katsaris GLASAIR FT · S/N 793Built 1986 · Dunlop D BruceN142RSCessna 182E · S/N 18253832Reinmuth Michael WN1573EAeronca 7AC · S/N 7AC-5136Built 1946 · Deach MichaelN182AVCessna 182P · S/N 18264161Built 1975 · Wilson Robert AN20232Cessna 172M · S/N 17261116Built 1972 · Lopez Tail Draggers LLCN2115UBrantly B-2 · S/N 163Dengler Steven GN21268Cessna 182P · S/N 18261528Built 1972 · Aufderhar Kenneth GN2472MPiper PA-12 · S/N 12-1692Built 1947 · Aufderhar Kenneth GN28248Piper J5A · S/N 5-156Built 1940 · Potter PaulN2849HForney 415-C · S/N 3474Built 1946 · Coupe Brothers LLCN2879ZBellanca 7GCBC · S/N 1019-78Built 1978 · Ritchie Rex WN309DDavid B Dunlop MURPHY REBEL · S/N 309Built 2016 · Dunlop David BN3184DCessna 180 · S/N 31982Built 1955 · Ritchie Rex WN32JWJohn N Wach GLASAIR III · S/N 3367Built 2013 · Deach MichaelN3581Cessna 180D · S/N 18051056Built 1961 · Lewis L Dwight JrN3592PPiper PA-18-150 · S/N 18-4550Built 1955 · Dengler Steven GN4015CStinson 108-3 · S/N 108-5015Franklin Jon PN4105YCessna 185A · S/N 1850305Built 1962 · Chock Steven Y HN441DCTL Ultralight Sro STINGSPORT · S/N TLUSA122Built 2005 · Pugerude Kenneth WilliamN4579FCessna A185E · S/N 185-1086Wagner Jan WN4688BCessna 180 · S/N 31487Aufderhar Samuel EN511SFSanford William M RV-8 · S/N 81483Fowler Ronald WN5127UCessna 206 · S/N 206-0127Fowler Ron WN55140Piper PA-28-180 · S/N 28-7305321Built 1973 · Di Giorgio Thomas J JrN56429Piper PA-28-140 · S/N 287325628Built 1973 · Norman Ronald EN576LBRonald E Norman JW-CUB · S/N 002Norman Ronald EN63062Cessna 150M · S/N 15077074Built 1975 · Cade Richard GN6312FCessna 337A · S/N 337-0312Built 1966 · Cade Steve DBAN63458Cessna 180K · S/N 18052847Fowler RonN6696FCessna 150F · S/N 15063296Built 1966 · Young Deborah CN7514DPiper PA-22-150 · S/N 22-5242Built 1957 · Adams Stephen KN8015FCessna 150F · S/N 15064115Built 1966 · Lewis L Dwight JrN9081XCessna 182D · S/N 18253481Kardack Michael RN9542UGrumman American Avn. AA-1C · S/N AA1C0039Norman Ronald EdwardN9805TCessna 172A · S/N 47605Built 1960 · Norman Ronald EN9ZUPiper PA-18-150 · S/N 18-7028Built 1959 · Fowler Ronald W
Back to Lopez Island, WA