AD 98-21-21 R1

Registered aircraft · 85,616

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.

N11421Beach Prairie LLC · Cedar Rapids, IABuilt 2001 · S/N E-3378N11423Boland Aviation LLC · Newton, NJBuilt 1981 · S/N 24-1178N1142FHart James A · Arlington, VAFirst renewal noticeBuilt 1966 · S/N 17254737N1142GMorgan Robert Brian · Ozark, MOBuilt 1981 · S/N 24-1172N1142LMcdonald Brennan P · Orlando, FLBuilt 1981 · S/N 24-1162N1142MStewart Eric · Lott, TXBuilt 1981 · S/N 24-1174N1142QSteely Paul · Williamsburg, KYBuilt 1977 · S/N 28-7790378N1142THaskell Bryan William · Belmont, NCBuilt 1981 · S/N 24-1175N1142XAerofeather Aviation Inc · Suffolk, VAS/N 34-7570221N1143AStraeter Eckhard · Lempster, NHBuilt 1981 · S/N 24-1179N1143FWilson Dan · Saginaw, TXS/N 17254738N1143KBishop Nathan Wesley · League City, TXBuilt 1981 · S/N 24-1181N1143MCastelletti Mark Anthony Trustee · Casa Grande, AZBuilt 1970 · S/N 17259443N1143NMichael K Bristow · Smyrna, GABuilt 1981 · S/N 24-1183N1143WRiner Mark G · Bartlesville, OKBuilt 1981 · S/N 25-0587N1144FBandit Air LLC · Stowe, PABuilt 1956 · S/N 33279N1144KYoung Bradley M · Vancouver, WABuilt 1981 · S/N 24-1185N1144MCcr Aviation LLC · Kalispell, MTS/N 17259444N1144NHanovich Robert L Jr · Flagstaff, AZBuilt 1981 · S/N 24-1186N1144WNimmo Lawrence · Cordova, MDBuilt 1981 · S/N 24-1189N1144XFly Texas Sky LLC · Arlington, TXFirst renewal noticeBuilt 1975 · S/N 28-7505215N1144ZBay Lux Ventures LLC · Tampa, FLBuilt 1977 · S/N 287890231N1145FGurke George J · Anchorage, AKBuilt 1975 · S/N 18502757N1145TWilliams Thomas J · Burr Ridge, ILBuilt 1981 · S/N 24-1191N1145UWws Air LLC · Savannah, GABuilt 1981 · S/N 24-1192N1146FLarson Larry D · Sargeant, MNBuilt 1966 · S/N 17254741N1146HLtk Air Inc · North Wilkesboro, NCBuilt 1976 · S/N 32-7740031N1146JAdam Spencer · New York, NYBuilt 1981 · S/N 24-1197N1146LSak Aviation LLC · Cheney, KSBuilt 1981 · S/N 24-1198N1146PElkin Christopher E · Talpa, TXBuilt 1981 · S/N 24-1199N1146TGandhi Mehul · Hayward, CAS/N 24-1200N1147N7371y LLC · Waterford, MIBuilt 1964 · S/N 30-423N1147AShipley & Son Ltd · Capitan, NMBuilt 1981 · S/N 24-1202N1147DWesterhold Wayne E · Cary, NCBuilt 1981 · S/N 25-0594N1147FParker Robert M · Hurst, TXBuilt 1966 · S/N 17254742N1147GIcarus Transport LLC · Charlotte, NCBuilt 1981 · S/N 25-0595N1147HSpacious Skies LLC · Overland Park, KSBuilt 1977 · S/N 32R-7780139N1147XPax Flyers LLC · Hollywood, MDBuilt 1975 · S/N 28R-7535259N1148BBallard Neil B · Mankato, MNBuilt 1981 · S/N 24-1204N1148FReed Roger · Lebanon, KYBuilt 1966 · S/N 17254743N1148GJackson Brian · Oklahoma City, OKBuilt 1981 · S/N 24-1205N1148NForbes Ryan C · Newnan, GABuilt 1981 · S/N 24-1208N1148TCorlett Samuel E · Fort Worth, TXBuilt 1958 · S/N D-5453N1148UCaromac LLC · Florence, SCBuilt 1981 · S/N 24-1210N11495Risoldi John L Sr · Kitty Hawk, NCBuilt 1981 · S/N 24-1220N1149BStefenelli Aviation N Tr Inc Trustee · AtterseeBuilt 1981 · S/N 25-0603N1149FLemery Aaron D · Chattaroy, WAS/N 17254744N1149GShine Flyer LLC · Kalispell, MTBuilt 1981 · S/N 25-0606N1149HN1149h Inc · Pembroke Pines, FLBuilt 1981 · S/N 25-0607N1149LAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 25-0608
Back to AD 98-21-21 R1