AD 98-21-21 R1

Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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.

N2239D41 Investments Gp LLC · Sinton, TXBuilt 1978 · S/N 34-7970011N2239GPotter Cleve J · Fresno, CABuilt 1958 · S/N 51539N2239PCumbee Danny A · Geneva, ALS/N 23-848N2239TErwin Chris L · Carson City, NVS/N 28-7125629N2239ZAsc Air LLC · Neligh, NEBuilt 1979 · S/N 28-7921025N223BBN223bb LLC · Great Falls, VABuilt 2000 · S/N E-3340N223BDN223bd LLC · Fresno, CABuilt 1980 · S/N R18201454N223BECampbell Edward A · Anchorage, AKBuilt 1977 · S/N 17268915N223BTMull David L · Kathleen, GABuilt 1978 · S/N R18200360N223DBurch Construction Co Inc · Ramona, CABuilt 1993 · S/N CE1755N223DAAerodrome LLC · Louisville, KYBuilt 1970 · S/N 27-4563N223DWSeibel Keith L · Paris, TNBuilt 1963 · S/N D-7113N223FCKimzey Edwin D Jr · La Jolla, CABuilt 1993 · S/N 24-3309N223GHMeridian Aircraft LLC · Wilmington, DES/N 2881542N223HWatson James E Jr · Victor, COBuilt 1956 · S/N 35385N223JDFlynt Kevin D · Decorah, IAS/N 28R-7803042N223KMWithrotor Aviation Inc · Lakeview, ORBuilt 1974 · S/N TH447N223KWMedic Choppers LLC · Springdale, ARS/N EA-382N223LDGaston'S White River Resort Inc · Lakeview, ARBuilt 1965 · S/N U206-0493N223MVallington Alexander M · Enterprise, ALBuilt 1960 · S/N D-6524N223MDPremier Engineering Inc · San Antonio, FLBuilt 1974 · S/N 32-7440154N223NKWandering Vet LLC · Mccook, NEBuilt 1955 · S/N 26814N223RJCline Larry J · Beeville, TXBuilt 1979 · S/N 18266850N223SBAdams Derek · Lexington, MABuilt 1981 · S/N TJ-339N223SCSurdex Corp · Chesterfield, MOBuilt 1973 · S/N U20601999N223TLZanghi Michael · Katy, TXBuilt 1971 · S/N 18260719N223TRTurner Lee W · Valdosta, GABuilt 1968 · S/N 17257757N223WDGilliam Preston T · Philadelphia, PABuilt 1964 · S/N 28-20366N223WHPerrin James F · Bancroft, WIBuilt 1964 · S/N 18051355N223WWSan Diego Flight Training Inc · San Diego, CABuilt 1978 · S/N 28R-7837251N223XSaleem Sandhu M · Santa Clara, CAS/N 34-7970288N223YZMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881536N223ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881608N2240Twin Bonanza LLC · Meridian, IDBuilt 1956 · S/N DH-35N2240BK & D Dakota LLC · Avon, OHBuilt 1978 · S/N 28-7911015N2240DOhnback Ulf · Spokane, WABuilt 1978 · S/N 34-7970032N2240EKellogg Jeffrey D · Adams Center, NYBuilt 1978 · S/N 17271200N2240FFenco Holdings Inc · Cheyenne, WYS/N 310L0040N2240GThunderbird Aircraft Company · Bloomington, MNBuilt 1978 · S/N 28-7916217N2240KBurnet David A · Quinton, ALBuilt 1978 · S/N 28-7916233N2240PAnderson Timothy H · Janesville, WIBuilt 1956 · S/N 23-849N2240TJudie Bear Air LLC · Bend, ORFirst renewal noticeBuilt 1971 · S/N 28-7125625N2241Davis Clint H · Paola, KSFirst renewal noticeS/N TD-221N22419Gehres Shawn E · Enterprise, ALBuilt 1978 · S/N 32R-7885270N2241BHanneman Michael W · Abilene, TXBuilt 1978 · S/N 32R-7985018N2241FHaag Douglas A · Collierville, TNBuilt 1967 · S/N 310L-0041N2241GOwens Wilbur · Rch Palos Vrd, CABuilt 1978 · S/N 28-7990229N2241KFlickinger Charles · Hermitage, PABuilt 1978 · S/N 28-7916236N2241NBell Michael C · Sammamish, WABuilt 1979 · S/N 28R-7918043N2241RHappy Landings Aero LLC · Wilmington, DEBuilt 1968 · S/N T210-0391
Back to AD 98-21-21 R1