Skip to content

Enstrom Helicopter 280C

Registered aircraft · 48

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 ('3300505')
  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 ('3300505')
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.

N106DABeartooth Fencing LLC · Reed Point, MTBuilt 1976 · S/N 1050 N111EEPereira Alfred R Jr · Valley Springs, CABuilt 1977 · S/N 1075 N122TVButler Aaron · Rupert, IDBuilt 1976 · S/N 1049 N142LKummoung Jeffery S · Middleburg, FLBuilt 1976 · S/N 1036 N1577ESeibert Lynn K · Fresno, CAS/N 1131 N170QCherry Calvin L · Paso Robles, CABuilt 1978 · S/N 1137 N17YBAhearn Nicholas · Harper, TXBuilt 1978 · S/N 1158 N221MPBenson Aviation LLC · Mehoopany, PAS/N 1147 N277RDWestline Corp · Medina, OHBuilt 1978 · S/N 1156 N280AL2e2 Corporation · Menlo Park, CABuilt 1980 · S/N 1210 N280MGM&M Charter LLC · Mountville, PABuilt 1978 · S/N 1135 N280WRBeacon Aviation Flight Services LLC · Rogers, ARBuilt 1977 · S/N 1108 N3143CAuron Chris · Naples, FLBuilt 1977 · S/N 1103 N3398MMott William R · Beach Lake, PABuilt 1976 · S/N 1037 N403TAJ & J Shop Heliair LLC · Laurel, DES/N 1204 N43MHKorb Thomas M · Owasso, OKBuilt 1978 · S/N 1148 N50DRAdf Helicopters Inc · Brewster, WAS/N 1203 N51659Hawk Robert S · Argyle, TXBuilt 1977 · S/N 1098 N51723Rhoads Timothy C · Logan, NMBuilt 1978 · S/N 1136 N51735Styer David B · Milton Freewater, ORBuilt 1978 · S/N 1139 N51739Quality Aero LLC · East Aurora, NYS/N 1141 N51787Holder Michael T · Whitesburg, GABuilt 1980 · S/N 1172 N529HJsh Farms Inc · Hermiston, ORBuilt 1976 · S/N 1042 N554HSouthworth Elizabeth A · Igo, CABuilt 1976 · S/N 1039 N565XMackechnie Martin J · Palm Harbor, FLBuilt 1978 · S/N 1138 N5687PBrown Clifford J · Hoschton, GAS/N 1167 N5690BK & L Aerial LLC · Echo, ORBuilt 1979 · S/N 1171 N5690DRolfe Cameron R · San Mateo, CABuilt 1978 · S/N 1154 N56926Bitwell Construction LLC · Hartville, OHS/N 1188 N5693RWaters Willie Frank Jr · Willits, CAS/N 1194 N5694NBegley Edward · Glasgow, KYS/N 1197 N5695AJacob Ricker · Ranchester, WYS/N 1201 N5697MStanton Mark I · Spokane, WAS/N 1209 N5699NStyer David B · Pendleton, ORBuilt 1981 · S/N 1220 N594HKeading Helicopter LLC · Shoshone, IDBuilt 1977 · S/N 1074 N595ARMiddle Fork Aviation LLC · Meadowview, VAS/N 1182 N59AXCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1982 · S/N 1227 N602HKing John H · Trumansburg, NYBuilt 1977 · S/N 1077 N61GGCoggin Randall · Longview, TXS/N 1178 N624HNeed For Speed Inc · Dover, DEBuilt 1977 · S/N 1078 N646HStyer David B · Milton Freewater, ORBuilt 1977 · S/N 1099 N665HHouchin Thomas J · Pittsburgh, PABuilt 1977 · S/N 1093 N666CFTrofimchuck Matthew P · Coal City, ILBuilt 1977 · S/N 1069 N700ATMoore Stirling · Douglas, WYS/N 1193 N70719Emerson Frayne · Stanfield, ORS/N 1072 N800SCMalcom Scott O · Toledo, WABuilt 1976 · S/N 1067 N84DHStanton Mark I · Spokane, WABuilt 1976 · S/N 1055 N9285November 9285 LLC · Higden, ARBuilt 1978 · S/N 1003

Back to Enstrom Helicopter 280C