OpenAirDocs.org
Brewster, WA

Registered aircraft · 34

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 = 'BREWSTER'
  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.

N131HAEurocopter SA315B · S/N 1318/43Built 1993 · High Altitude Helicopters IncN2207APiper PA-18-135 · S/N 18-1882Built 1951 · Smith David CN226JKCub Crafters PA18-150 · S/N 9965CCBuilt 2004 · Smith David CN238HAAerospatiale SA315B · S/N 2438Built 1976 · High Altitude Helicopters IncN265HAAerospatiale SA315B ALOUETTE III · S/N 2656High Altitude Helicopters IncN280FUEnstrom 280 · S/N 1007Adf Helicopters IncN3353King SKYHOPPER 20 · S/N 001Built 1970 · Mcnamara John PN417NABell UH-1H · S/N 64-13628Built 1965 · Vi 1 LLCN4561WDJI AGRAS T50 · S/N 1581F6BUB248U001N245Out West Ag LLCN492LJDJI AGRAS T50 · S/N 1581F6BUB246F001479UOut West Ag LLCN504Sikorsky S58E · S/N 57-1717Built 1957 · Vi 1 LLCN506Sikorsky S-58H · S/N 14-8079Vi 1 LLCN50DREnstrom Helicopter 280C · S/N 1203Adf Helicopters IncN540FUGarlick Helicopters HH-1K · S/N 157190Built 1999 · Adf Helicopters IncN58HFSikorsky S-58J · S/N 571692Built 1957 · Vi 1 LLCN58HUSikorsky S-58J · S/N 58-1575Built 1963 · Vi1 LLCN58KKSikorsky S-58C · S/N 58462Built 1957 · Vi 1 LLCN58NSSikorsky S-58H · S/N 58-1453Built 1960 · Vi 1 LLCN6261CGarlick Helicopters UH-1H · S/N 68-15521Built 1968 · Vi1 LLCN633UGrumman G-164 · S/N 369Built 1965 · Smith David CN644WWDJI AGRAS T100 · S/N 1581F8ZLC25B700244FZOut West Ag LLCN644XGDJI AGRAS T100 · S/N 1581F8ZLC25AU0025N8XOut West Ag LLCN65203Cessna T-50 · S/N 3124Built 1942 · Smith David CN70277Piper J3C-65 · S/N 17258Built 1946 · Smith David CN703SCSikorsky S58E · S/N 581607Built 1963 · Vi 1 LLCN7228Grumman Acft ENG Cor-Schweizer G-164A · S/N 903Built 1972 · Smith David CN7936CSikorsky S-58 · S/N 58996Built 1958 · Vi 1 LLCN7982Grumman Acft ENG Cor-Schweizer G-164A · S/N 846First renewal noticeBuilt 1971 · Smith David CN79ARSikorsky CH34C · S/N 57-1709Vi 1 LLCN80978Globe GC-1B · S/N 1171Smith David CarrollN8296KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 650BSmith David CN85HJSikorsky S-58D · S/N 581716Vi 1 LLCN867Sikorsky S-58C · S/N 58534Built 1957 · Vi1 LLCN90307Bell 206B II · S/N 1747Built 1975 · Smith David C
Back to Brewster, WA