Skip to content

Dehavilland DHC-2

Registered aircraft · 69

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 ('2808001', '2808010')
  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 ('2808001', '2808010')
ORDER BY n_number

Run 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.

N107BKomro International LLC · Durand, WIBuilt 1958 · S/N 1220 N1108QLake Clark Holdings LLC · Port Alsworth, AKBuilt 1952 · S/N 416 N113CBC And P Aviation Inc · Blaine, MNBuilt 1961 · S/N 1491 N117BBKustatan Leasing LLC · Nikiski, AKBuilt 1962 · S/N 1511 N126RSFox Whiskey Inc · Wilmington, DEBuilt 1961 · S/N 1464 N1454ZOut There Outfitters LLC · Boise, IDBuilt 1955 · S/N 972 N1455ZD & B Aircraft Leasing LLC · Anchorage, AKBuilt 1953 · S/N 769 N1959BReinbold Frederick K · Anchorage, AKBuilt 1958 · S/N 1371 N1966BQualitair LLC Trustee · MichelstadtBuilt 1966 · S/N 1615 N2109ALafferty Peter S · Harrisburg, ORBuilt 1955 · S/N 927 N21190Wipaire Inc · South Saint Paul, MNS/N 1421 N2123XKias LLC · Waukesha, WIBuilt 1961 · S/N 1473 N226WDRs Specialties LLC · Anchorage, AKBuilt 1952 · S/N 226 N233NJw Ltd · Seattle, WAS/N 976 N243ARitland Stephen L · Flagstaff, AZBuilt 1958 · S/N 1244 N24BRRiver Front Akn LLC · Anchorage, AKBuilt 1953 · S/N 644 N2513NWattum Investments LLC · Kodiak, AKBuilt 1963 · S/N 1521 N269AWPrijatel Thomas J · Cordova, AKBuilt 1954 · S/N 768 N30PDPowell Aviation LLC · Bellevue, WABuilt 1957 · S/N 1057 N328JV212 Investments LLC · Owasso, OKBuilt 1976 · S/N 260 N34EBHultquist David Dean · Anchorage, AKBuilt 1954 · S/N 749 N38AKRedemption Inc · Kodiak, AKBuilt 1957 · S/N 720 N4444ZRustair Inc · Anchorage, AKBuilt 1958 · S/N 1307 N450DMBarnstorm Aviation Inc · Jacksonville, FLBuilt 1953 · S/N 577 N450RARyan Aviation Management LLC · Palm Coast, FLBuilt 1953 · S/N 526 N456NJw Limited · Seattle, WAS/N 1534 N470DBN470db LLC · Soldotna, AKS/N 917 N471PMAlaska Ultimate Safaris LLC · Homer, AKBuilt 1959 · S/N 1366 N489AKOlsen Martin G · Anchorage, AKBuilt 1951 · S/N 364 N490KKatmai Air LLC · Anchorage, AKBuilt 1958 · S/N 1268 N4989NLambeth Air LLC · Sitka, AKBuilt 1948 · S/N 31 N4TSUpland Aviation LLC · Medford, ORBuilt 1955 · S/N 930 N501JPoma Luis Eduardo · Pinecrest, FLS/N 1451 N510PW5b 7b Aero LLC · Sandpoint, IDBuilt 1954 · S/N 641 N5142GL-Bird LLC · Hood River, ORBuilt 1952 · S/N 481 N57XLArcus Aero LLC · Bridgeport, TXBuilt 1957 · S/N 1680 N591DBWet Dreams LLC · Erwinna, PABuilt 1959 · S/N 1310 N60JGJgg Management LLC · Mccall, IDBuilt 1960 · S/N 1453 N620NRak Tbvr LLC · Middletown, DEBuilt 1957 · S/N 1026 N62230Rainbow River Lodge Aviation LLC · Sandy, UTBuilt 1952 · S/N 707 N6266MPrijatel Thomas J · Cordova, AKBuilt 1963 · S/N 1531 N62LCNorthstar Holdings LLC · Anchorage, AKBuilt 1957 · S/N 1086 N639CMBeaver 639 LLC · Milwaukee, WIBuilt 1954 · S/N 639 N67030Bristol Bay Sportfishing LLC · Iliamna, AKBuilt 1958 · S/N 1372 N67066Zulu Forty One LLC · Anchorage, AKBuilt 1957 · S/N 1279 N67673Blue Aircraft LLC · Ketchikan, AKBuilt 1957 · S/N 1284 N67688Wildman Lodge Alaska LLC · Anchorage, AKBuilt 1957 · S/N 1146 N67692Rhk Of Kansas · Wardsville, MOS/N 1018 N67DNVectored Solutions Inc · Everett, WABuilt 1955 · S/N 799 N68073Safeco Leasing LLC · Port Alsworth, AKS/N 1005

Back to Dehavilland DHC-2