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.

N13BLCross Country Aviation LLC · Park City, UTBuilt 1975 · S/N E-724N13BPN13bp LLC · Walla Walla, WAS/N 320D0123N13BRC-140 Co LLC · Pensacola, FLBuilt 1963 · S/N 27-532N13CAAeroclub Management LLC · Cincinnati, OHBuilt 1974 · S/N 31-7405411N13CEWilley R Scott · Layton, UTBuilt 1970 · S/N 31007N13EGo Leasing Co · Phillipsburg, KSBuilt 1952 · S/N D-3259N13EJAvidash LLC · Cape Coral, FLS/N CE1130N13ESCsl Holdings LLC · Drayton, NDBuilt 1977 · S/N 31-7812046N13FGBaum Group LLC · Shavertown, PABuilt 1957 · S/N 34271N13GPWeidner Kevin G · Bunker Hill, ILBuilt 1967 · S/N 30-1535N13HMN13hm LLC · Punta Gorda, FLBuilt 1970 · S/N TE-813N13HWSikes Alan · Collins, GABuilt 1962 · S/N 1850290N13JTHoltzclaw Timothy M · O Brien, FLBuilt 1972 · S/N 17261008N13KFRockwood Blake T · Fort Worth, TXBuilt 1965 · S/N 28-2396N13KKSanders Flight Training Center Inc · Jasper, ALBuilt 1977 · S/N 17268760N13KRKaplan Ronald · Palm Beach Gardens, FLBuilt 1967 · S/N 28-4363N13KSNolt Ivan · Mount Solon, VABuilt 1974 · S/N 21060202N13LMTupelo Limited Lc · Lake Charles, LAFirst renewal noticeS/N 34-7870075N13MCMathison Neil James · Solon Springs, WIBuilt 1974 · S/N 18052444N13MDMoorstein Mark A · Manassas, VABuilt 1967 · S/N 680025N13MKLjh Consulting Services LLC · Greenleaf, IDBuilt 1968 · S/N TE-515N13MPPowell & Powell LLC · Northport, ALS/N 28-7515384N13NPEvans Randall B Trustee · Fallon, NVBuilt 1954 · S/N 31225N13NSThirteen November Sierra LLC · Herriman, UTS/N 24-3122N13PECamm Air · Spencer, IAS/N TJ-50N13PKOaks Aviation LLC · Clear Lake, MNBuilt 1981 · S/N 310R2127N13PNWillis Ted A · Fayetteville, ARBuilt 1957 · S/N D-5231N13RGIsland Piper Llp · St Helena Is, SCBuilt 1972 · S/N 28-7310055N13RKSwartz Charles Harris Jr · Spicewood, TXBuilt 1978 · S/N E-1238N13RTWoodhouse Dave · Battle Creek, MIBuilt 1962 · S/N D-6954N13SKFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17271183N13SPNew York State Police · Latham, NYBuilt 1967 · S/N 17256431N13TEMaddox Eric L · Grover Beach, CABuilt 1978 · S/N 24-0700N13TMSuntech LLC · St George, UTBuilt 1963 · S/N 115N13TNMcdaniel Robert M · Tonasket, WABuilt 1977 · S/N 21062428N13TPLehman Aviation LLC · Remington, INBuilt 1976 · S/N 17267454N13TTKlcc Holdings LLC · Boca Raton, FLS/N 27-7554069N13TWSouthern Aerial Service LLC · Douglas, GABuilt 1985 · S/N TH-1468N13VMAhs Aero LLC · Phoenix, AZBuilt 1975 · S/N CE-552N13WStl LLC · Savoy, ILBuilt 2001 · S/N 3246185N13WRBillys Blessing LLC · Louisburg, NCBuilt 2000 · S/N 3246154N13WSJohnson Chad H · Houston, TXBuilt 1979 · S/N 18503938N13WTBentz George T · Missoula, MTBuilt 1973 · S/N 18262089N13WWHurd Steven C · Bangor, MEBuilt 1982 · S/N 18504378N13XXNantz William G Jr · Raleigh, NCS/N D-6467N13YPBlock Scott M · Chandler, AZBuilt 1968 · S/N 17257055N13YZCreative Destination Development LLC · Mount Pleasant, TXBuilt 1976 · S/N E-859N13ZZTigerair Of Alabama Inc · Newark, DEBuilt 1973 · S/N E-464N1400Salour Michael M · Carlsbad, CABuilt 1979 · S/N P210-00277N14005Delaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-4623
Back to AD 98-21-21 R1