OpenAirDocs.org
AD 89-24-01 R1

Registered aircraft · 4,242

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:89-24-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:89-24-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.

N995EGEagle Group USA Inc · Howell, MIBuilt 1980 · S/N EA-90N9963YN9963y LLC · Provo, UTBuilt 1982 · S/N 21064649N9964YGreenspun Mark H · Washington, DCBuilt 1982 · S/N 21064650N9968JBoening Bros Dusting & Spraying Scv · Floresville, TXBuilt 1981 · S/N T18803897TN9976MBrush Wesley A · Sparks, NVBuilt 1978 · S/N U20604626N9977JBoening Bros Dusting & Spraying Inc · Floresville, TXBuilt 1982 · S/N T18803906TN997CHHolly Ridge Planting · Indianola, MSBuilt 1986 · S/N T21064997N997JDAviation.One Business Holdings LLC · Mesa, AZBuilt 1984 · S/N 414A1004N997RRegistered aircraftBuilt 1974 · S/N 21060386N997TAAir Flight Inc · Fort Lauderdale, FLFirst renewal noticeBuilt 1980 · S/N 402C-0231N9982YChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1982 · S/N 21064659N9983MTate Clint · Boise, IDBuilt 1978 · S/N U20604632N9986MLogan Timothy R · Valley City, NDS/N U20604635N998JA2 Doods LLC · Lakewood Ranch, FLBuilt 1979 · S/N 310R0938N998JGDragonfly Aviation LLC · Davie, FLBuilt 1999 · S/N EA-641N9991YArwlb Aviation LLC · Spokane, WABuilt 1982 · S/N 210-64661N9996JDiamond X LLC · Elko, NVBuilt 1982 · S/N T18803925TN999AJNedley Aviation LLC · Wilmington, DEFirst renewal noticeBuilt 1984 · S/N EA-417N999AVSouza Engineering Contracting Inc · San Luis Obispo, CABuilt 1979 · S/N P21000257N999BFRigel Aviation Inc · Jefferson Hills, PABuilt 1979 · S/N EA-24N999CECb Wings LLC · Eugene, ORBuilt 1980 · S/N EA-86N999DCTbm Avenger Inc · Peru, ILBuilt 1976 · S/N 340A0035N999EBEngines Inc · Jonesboro, ARBuilt 1979 · S/N 340A0951N999JLFlying Swan LLC · Ashland, NHBuilt 1973 · S/N 414-0479N999KMMaule Aviation LLC · Las Vegas, NVBuilt 1979 · S/N P21000387N999PCFlying T LLC · Albuquerque, NMBuilt 1972 · S/N 21059694N999RKTcg Aviation LLC · Pelham, ALBuilt 1974 · S/N 414-0610N99HJMf Property Management LLC · Hattiesburg, MSBuilt 1978 · S/N 414A0041N99JZUnadventurous LLC · Amarillo, TXBuilt 1984 · S/N TJ-474N99PAMckelvey Jeffrey R · Dadeville, ALBuilt 1978 · S/N TJ-179N99VBC&S Aviation Partners LLC · Thibodaux, LABuilt 1980 · S/N EA-154N99VMDaniel M Skotte Do Pc · Sunriver, ORBuilt 1980 · S/N EA-140N99YZEdwal Aviation LLC · Reno, NVBuilt 1981 · S/N 21064608N9DVNorwood Ronald Steven · Raleigh, NCBuilt 1981 · S/N EA-193N9EPMcavian LLC · Perryton, TXBuilt 1981 · S/N TJ-378N9GFApruda Andri Trustee · Nashville, TNBuilt 1988 · S/N 4608127N9NCEmpresas Marex Inc · Mayaguez, PRBuilt 1978 · S/N 414A0202N9RYDpr Capital LLC · Farmington, UTS/N 340A0211N9SHSenza Limiti LLC · Park City, UTBuilt 1980 · S/N EA-52N9TFBender Glenn Steven · Lovell, MEBuilt 1948 · S/N NAV-4-1396N9TRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1973 · S/N 21059846N9WJWsw Rental Of Sarasota LLC · Longboat Key, FLBuilt 1973 · S/N 340-0185
Back to AD 89-24-01 R1