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.

N316RCHelicopter Emergency Lift Program · Pomona, NYBuilt 1974 · S/N 1268N3188ZFulton County Police Headquarters · Atlanta, GABuilt 1985 · S/N 3860N3192G3192 Golf Inc · Wauchula, FLBuilt 1972 · S/N 809N3196GUSA Helicopter Inc · West Winfield, NYBuilt 1972 · S/N 775N31ATHelicopter Leasing Inc · Coral Gables, FLBuilt 1972 · S/N 918N31HMDah Aircraft LLC · Georgetown, SCBuilt 1977 · S/N 1160027DN3202DPapa Mike Aviation LLC · Dousman, WIBuilt 1985 · S/N 3849N3211NTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 1984 · S/N 3808N321PERadnor Construction Of Delaware Inc · Allentown, PABuilt 1989 · S/N 0342EN322ECDivesa Aviation Services LLC · Missoula, MTBuilt 1977 · S/N 2218N324CMClarke Environmental Mosquito Management · Roselle, ILBuilt 1977 · S/N 2303N326MHMaritime Helicopters Inc · Homer, AKBuilt 1988 · S/N S-803N327MHMaritime Helicopters Inc · Homer, AKBuilt 1989 · S/N S813N32KYEnglish Air Service LLC · Santa Maria, CABuilt 1979 · S/N 2875N330THHuff Jon L · Corning, NYBuilt 1992 · S/N 0002N331MHKt Auburndale LLC · Panama City Beach, FLBuilt 1982 · S/N 3564N3324FSummit Sales & Leasing Inc · Salem, VABuilt 1964 · S/N 1735N332JPAeronautical Airmotive Modifications Inc · Biscayne Park, FLS/N 7358N333FCGolden Ranch Aviation Inc · Raceland, LABuilt 1975 · S/N 1763N333TABallard Aviation Inc · Newton, KSBuilt 1979 · S/N 590500DN334KCHawk Hollow Farm LLC · Brighton, MIBuilt 1994 · S/N 4303N335DMSmith Steven Lee · Whitehall, MTBuilt 1981 · S/N 3330N345RRChemair Helicopters Inc · Jefferson, WIBuilt 1977 · S/N 2107N346ERCibaoair Aviation Group Inc · Middletown, DEBuilt 1995 · S/N 4337N347MJam Zoom Yayos LLC · Manheim, PABuilt 1981 · S/N EA-253N3521TMbm Aviation Consultants Inc · Wilmington, DEBuilt 1979 · S/N 2703N3523TMoreau Robert D · Granbury, TXBuilt 1979 · S/N 2637N3528TR&B Helicopters Inc · Salinas, CABuilt 1981 · S/N 3516N353AHBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 811079DN355AGHover-Views Unlimited Inc · Syosset, NYBuilt 1982 · S/N 5109N355FFRichards William · Gardiner, NYBuilt 1982 · S/N 5133N355THTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5111N357MCHillsborough County Board Of County Commissioners · Tampa, FLBuilt 1995 · S/N 4355N357MHAa Leasing Lp · Kilauea, HIBuilt 1982 · S/N 1171DN358RLTopside Aviation Inc · Brasstown, NCBuilt 1979 · S/N 2736N360JFCt Grain Systems LLC · Lewisburg, KYS/N 0031AN364KRWright Kris H · Idaho Falls, IDBuilt 1984 · S/N E2184N369DRatcliff Dustin · Saltville, VABuilt 1977 · S/N 1070209DN369EDMonroe Helicopters LLC · Vestavia, ALBuilt 1978 · S/N 870167DN369EHApplebee Aviation Inc · Banks, ORBuilt 1980 · S/N 1200861DN369GSHellyer Aviation · Worland, WYBuilt 1973 · S/N 1230548SN369HAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 660821SN369HEN369he LLC · Wickenburg, AZBuilt 1969 · S/N 1090205EN369HSPurcell Ian · San Diego, CABuilt 1976 · S/N 850763SN369JHJack Harter Helicopters Inc · Lihue, HIBuilt 1985 · S/N 0145EN369KDDairy Air LLC · Scottsdale, AZBuilt 1983 · S/N 0037EN369KVAgricultural Air Services LLC · Jupiter, FLBuilt 1980 · S/N 300659DN369MHAa Leasing Lp · Kilauea, HIBuilt 1978 · S/N 380287DN369PBHelicopter Aviation Services & Leasing Inc · Miami, FLBuilt 1978 · S/N 480305DN369PDCity Of Atlanta · Atlanta, GABuilt 2001 · S/N 0721FF
Back to AD 79-21-01 R1