OpenAirDocs.org
AD 84-24-54 R2

Registered aircraft · 563

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:84-24-54-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-24-54-R2')
  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.

N6603XAerial Applicators Of Missouri LLC · Jonesboro, ARBuilt 1990 · S/N 51412N660HAHelicopter Applicators Inc · Gettysburg, PABuilt 1979 · S/N 45219N67231United States Army · Ft Rucker, ALBuilt 1993 · S/N 5124N681HBCity Of Huntington Beach · Huntington Beach, CABuilt 2022 · S/N 0335FFN682HBCity Of Huntington Beach · Huntington Beach, CABuilt 2022 · S/N 0336FFN683HBCity Of Huntington Beach · Huntington Beach, CABuilt 2022 · S/N 0337FFN684AEAir Evac Ems Inc · O Fallon, MOBuilt 2016 · S/N 52484N69FHelicopters Inc · Cahokia, ILBuilt 1996 · S/N 53025N6NJNew Jersey State Police · West Trenton, NJBuilt 1995 · S/N 52107N6QPHelicopters Inc · Cahokia, ILS/N 52191N6TYMooney Seven Inc · San Antonio, TXBuilt 1992 · S/N 52007N705FSHvl Construction Inc · Fresno, CABuilt 1994 · S/N E-2836N70606Registration Pending · Rome, NYRegistration pendingBuilt 1989 · S/N 51282N711TTFaithful Flyers LLC · Lakeside, CABuilt 1991 · S/N 51433N712MScotts Helicopter Service Inc · Le Sueur, MNBuilt 1983 · S/N 51072N713WRTrans Texas Helicopter Transport LLC · Realitos, TXS/N 52464N7159HPremier Rotors LLC · Saint Martinville, LABuilt 1990 · S/N 51397N71HMSummit Helicopters Inc · Salem, VABuilt 1994 · S/N 52114N71JJInterstate Helicopters Inc · Bethany, OKBuilt 1989 · S/N 51329N721KHBruce Mike · Evadale, TXBuilt 1984 · S/N E-2214N7266KGulf Helicopters LLC · Santa Fe, TXBuilt 1985 · S/N 760283N726HGm Leasing Company LLC · Broussard, LABuilt 1992 · S/N 51548N727JSTrickett Michael W · Washington, DCBuilt 2002 · S/N 5048N729AEAir Evac Ems Inc · O Fallon, MOBuilt 1995 · S/N 52156N73AWTre Aviation Corp · Wilmington, DES/N 52115N73WLLaroche Aviation Services LLC · Bellaire, OHBuilt 1990 · S/N 0081FFN7575SDkpa Heli LLC · Webster, MNBuilt 1996 · S/N 52162N75TVMooney Seven Inc · San Antonio, TXBuilt 1994 · S/N 52095N761MHMansfield Heliflight Inc · Milton, VTBuilt 1981 · S/N 760232N762MHGm Leasing Co LLC · Broussard, LAS/N 760233N763MHGm Leasing Co LLC · Broussard, LAS/N 760230N765MHGm Leasing Co LLC · Broussard, LABuilt 1983 · S/N 760236N767HWeyerhaeuser Nr Co · Seattle, WABuilt 1992 · S/N 52003N769MHGm Leasing Co LLC · Broussard, LAS/N 760278N76LPPanther Helicopters Inc · Belle Chasse, LABuilt 1993 · S/N 52056N771KESchilling Michael K · Kenai, AKBuilt 2004 · S/N 51002CN772DWCcf Ventures Inc · Bangor, MEBuilt 1976 · S/N 007N775DWCosta James J · Prineville, ORBuilt 1976 · S/N 028N77DCOmega 377 Pennsylvania LLC · Shavertown, PABuilt 1985 · S/N E-2289N782AEAir Evac Ems Inc · O Fallon, MOBuilt 2016 · S/N 52482N783AEAir Evac Ems Inc · O Fallon, MOBuilt 2016 · S/N 52483N785AEAir Evac Ems Inc · O Fallon, MOBuilt 2016 · S/N 52485N7860SMagnum Aviation LLC · Goff, KSS/N 6627N790RBRight Brother Aviation LLC · Rome, NYBuilt 1988 · S/N 51248N7978KMowata Farms LLC · Mamou, LABuilt 1982 · S/N 45492N79TMAbove & Beyond Aviation Inc · Anchorage, AKBuilt 1991 · S/N 51472N79TVBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N 45718N7QNHelicopters Inc · Wilmington, DEBuilt 1997 · S/N 52199N7YJHelicopters Inc · Linden, NJS/N 52026N801CLAv8-Orr Helicopter Services Inc · Hamilton, MTBuilt 1979 · S/N 45354
Back to AD 84-24-54 R2