OpenAirDocs.org
Usda Forest Service

Registered aircraft · 24

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

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_name = 'USDA FOREST SERVICE' OR list_contains(g.other_registrant_names, 'USDA FOREST SERVICE')
  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.

N106FSDehavilland DHC-2 MK. I(L20A) · S/N 477Built 1952 · Boise, IDN107NJBell UH-1H · S/N 13682Trenton, NJN110ZShort Bros SD3-60 SHERPA · S/N SH3409Built 1984 · Boise, IDN111ZCessna TU206F · S/N U20602919Boise, IDN115ZTextron B200GT · S/N BY-396Built 2021 · Boise, IDN125ZQuest KODIAK 100 · S/N 100-0226Built 2017 · Boise, IDN141ZDehavilland DHC-6-300 · S/N 803Built 1984 · Boise, IDN142ZShort Bros SD3-60 SHERPA · S/N SH3421Built 1985 · Boise, IDN147ZTextron B200GT · S/N BY-323Built 2018 · Boise, IDN148ZShort Bros SD3-60 SHERPA · S/N SH3428Built 1998 · Boise, IDN151ZShort Bros SD3-60 · S/N SH3407Boise, IDN160ZQuest KODIAK 100 · S/N 100-0227Built 2017 · Boise, IDN161ZShort Bros SD3-60 SHERPA · S/N SH3412Built 1997 · Boise, IDN170ZTextron B200GT · S/N BY-491Boise, IDN174ZShort Bros SD3-60 SHERPA · S/N SH3410Built 1984 · Boise, IDN176ZShort Bros SD3-60 SHERPA · S/N SH3411Built 1997 · Boise, IDN181ZTextron B200GT · S/N BY-394Built 2021 · Boise, IDN191ZDehavilland BEAVER DHC-2 · S/N 1006Built 1956 · Boise, IDN192ZDehavilland BEAVER DHC-2 MK.1 · S/N 1347Built 1959 · Boise, IDN193ZDehavilland BEAVER DHC-2 MK.1 · S/N 1162Built 1957 · Boise, IDN242KCBell UH-1H · S/N 6717842Bakersfield, CAN407KCBell UH-1H · S/N 66-16401Bakersfield, CAN416DFBeech 200C · S/N BL-124Built 1985 · Mcclellan, CAN444DFMarsh S-2F3AT · S/N 151654Mcclellan, CA
Back to Usda Forest Service