Dehavilland BEAVER DHC-2 MK.1
Registered aircraft · 76
Aircraft of this model in the FAA registry, by N-number.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2800102')
ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2800102')
ORDER BY n_numberRun 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.
N102SYElijah Air LLC · Bethel, AKN109KSRs Specialties LLC · Anchorage, AKN1117FIsland Wings Air Service LLC · Ketchikan, AKN1400ZAlaskan Fish Pirate Outfitting LLC · Ketchikan, AKN144QRpl Aircraft Leasing LLC · Anchorage, AKN156TBDalks Leasing Inc · Wilmington, DEN17598Kenmore Air Harbor LLC · Kenmore, WAN192ZUsda Forest Service · Boise, IDN193ZUsda Forest Service · Boise, IDN19AKRedemption Inc · Kodiak, AKN1CMFlight Management LLC · Kirkland, WAN2106QBerning Ron · Lino Lakes, MNN221RTLyons Aircraft Leasing LLC · Hillsboro, ORN2297RRapids Camp Lodge Inc · King Salmon, AKN22KKKilo-Kilo LLC · Wausau, WIN2415ZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN28378D & B Aircraft Leasing LLC · Anchorage, AKN2SFAirlease Inc · Kenmore, WAFirst renewal noticeN30PLFins Fur & Feathers Flying LLC · King Salmon, AKN338TPRainbow River Lodge Aviation LLC · Sandy, UTN4040WSourdough Air Service Inc · Fairbanks, AKN41FEnich Steve G · Side Lake, MNN444EFKatmai Air LLC · Anchorage, AKN450DBPathe Peter · Kirkland, WAN454FUAudie Spencer Davis · Wasilla, AKN460DBBristol Bay Mission Lodge LLC · Anchorage, AKN46DGKingfisher Air Inc · Kodiak, AKN4756TRuoss Rolan B · Kodiak, AKN4794CKalinin Partners LLC · Juneau, AKN5147GJb Leasing Co LLC · Nikiski, AKN5162GHanni Walter G · Anchorage, AKN5217GRiver Front Akn LLC · Anchorage, AKN5220GSan Francisco Seaplane Tours Inc · Mill Valley, CAN5221GPrindiville Thomas · Carmichael, CAN5343GCoyote Air LLC · Coldfoot, AKN5347GBeacon West LLC · Billings, MTN5349G49 Golf LLC · Tigard, ORN5354GBlack Pearl Beavers LLC · Springville, NYN5371GKing Air Inc · Naknek, AKN5381UJb Leasing Company LLC · Kenai, AKN53BVBlue Prop Warbirds LLC · Long Lake, MNN542RPDap Aviation Ventures LLC · Missoula, MTN555RGDrpg Aviation LLC · Metamora, MIN5595MForty-Nine Skies LLC · Ketchikan, AKN55WED & B Aircraft Leasing LLC · Anchorage, AKN590RSRandys Olde Towne Service Inc · Traverse City, MIN602AKN602ak LLC · Wasilla, AKN62469Northern Waters LLC · Livingston, MTN62BNNann Bernhard · Minneapolis, MNN64384Hayton James B · Sedro Woolley, WA
Back to Dehavilland BEAVER DHC-2 MK.1