OpenAirDocs.org
AD 79-21-01 R1

Registered aircraft · 1,074

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-21-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-21-01-R1')
  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.

N911ALAir Methods LLC · Greenwood Village, COBuilt 1997 · S/N 53144N911ANAlaska Tactical Aviation LLC · Palmer, AKBuilt 1974 · S/N S-156N911BYAmerican Honor Foundation Inc · Melourne, FLBuilt 2013 · S/N 0617EN911CPSt Louis County Police Department · Clayton, MOBuilt 1984 · S/N 0105EN911HHEwing Flying Service LLC · Morganza, LABuilt 1982 · S/N 3571N911JRGlobal Rescue Jets LLC · Boca Raton, FLS/N S-798N911PGPrince Georges County · College Park, MDBuilt 2000 · S/N LN091N911UDIndian River County Sheriff'S Office · Vero Beach, FLBuilt 1995 · S/N 5231N912PCTri-Rotor Spray & Chemical · Ulysses, KSBuilt 2005 · S/N 71-20340N913RLAero Leasing Inc · Medford, ORS/N 2913N9151THiller Aircraft Corp · Firebaugh, CAS/N 5089N9159FApex Heli-Support LLC · Phoenix, AZS/N 1090605DN91637Usda Aphis Ws · Cedar City, UTBuilt 2001 · S/N 5268N916GSFlight International Inc Trustee · Dover, DEBuilt 1980 · S/N 2916N91763Sterling Acres LLC · Santa Fe, NMS/N 5272N9177FRotor View Inc · Wilmington, DEBuilt 1973 · S/N 430465SN917SUSouthern Utah University · Cedar City, UTS/N 52127N9196FAsbill Jimmy T · Winnsboro, TXBuilt 1974 · S/N 740616SN919ACKw Air LLC · Darlington, INBuilt 1988 · S/N 4020N91WSSunny Sky LLC · Stacyville, IABuilt 1974 · S/N 1565N920HAMshr Helicopter Service LLC · Chehalis, WABuilt 1962 · S/N 1361N920JPKar Aviation LLC · Saltville, VAS/N 290449DN921SDCounty Of Fresno · Fresno, CABuilt 1990 · S/N 0428EN922MCGeco Inc · Wilmington, DEBuilt 1970 · S/N 68-16829N922SDCounty Of Fresno · Fresno, CABuilt 1991 · S/N 0478EN9233FC & D Helicopters LLC · Spanish Fork, UTBuilt 1975 · S/N 350715SN9276FHeli-Flite Inc · Corona, CABuilt 1978 · S/N 180254DN9290ZMaco Aviation Inc · Dayton, WABuilt 1978 · S/N 2452N935MAlan Aviation LLC · Los Angeles, CAS/N 1111125DN93BHBlue Hill Helicopters LLC · Norwood, MABuilt 1995 · S/N 5216N93CPKlump Aviation LLC · Bowie, AZBuilt 1997 · S/N 4470N93MDNew Horizons Helicopters Inc Trustee · Wilmington, DEBuilt 1993 · S/N 0512EN93MKDel Rio Aviation Inc · Paso Robles, CABuilt 1972 · S/N 867N9460TEvermore Aviation LLC · Wasilla, AKBuilt 1988 · S/N 0238EN94VMMachugh David · Pasco, WABuilt 1994 · S/N 4316N952SDHeli Fly Inc Trustee · Wilmington, DEBuilt 1995 · S/N LN073N952SFRegistration Pending · Elko, NVRegistration pendingBuilt 1989 · S/N 0366EN956KBIrie Leasing LLC · Trenton, NJBuilt 1979 · S/N 2717N95SKCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 1921N965RWWilmarth Russell · Alton Bay, NHBuilt 2002 · S/N 5047N9677NDat Aircraft LLC · Lewes, DEBuilt 1974 · S/N 1020422SN969RLRanger Aviation Leasing LLC · Wilmington, DES/N 3969N969VSVertol Systems Co Inc · Destin, FLBuilt 1980 · S/N 1100833DN96NWNorthwest Helicopters Inc · Olympia, WABuilt 1995 · S/N 4389N970YGCbk LLC · Eagle, COBuilt 1979 · S/N P21000219N971RHTurbines Ltd · West Point, NEBuilt 1972 · S/N 797N973RHTurbines Ltd · West Point, NEBuilt 1994 · S/N 4318N975RHTurbines Ltd · West Point, NEBuilt 1996 · S/N 4415N9762CFort Wolters Helicopters · Mineral Wells, TXBuilt 1962 · S/N 2159N979RHTurbines Ltd · West Point, NEBuilt 1989 · S/N 4080
Back to AD 79-21-01 R1