OpenAirDocs.org
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.

N170JRRing John A · La Conner, WABuilt 1952 · S/N 20750N170JTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1953 · S/N 25827N170JWStark David M · Merkel, TXS/N 25973N170KBBecker Kurt G · Dexter, NMBuilt 1956 · S/N 27103N170KHFossa Joseph S · Essex, MABuilt 1952 · S/N 25030N170KMMarlow Properties LLC - Marlow Aviation LLC Series · Knoxville, TNBuilt 1949 · S/N 19166N170KTHughes Michael D · Erie, COBuilt 1955 · S/N 26758N170KWCrews Cobert · Shady Shores, TXBuilt 1955 · S/N 26712N170LSchaible Peter J · Springfield, VABuilt 1954 · S/N 26252N170LCMacy Richard M · Lebanon, NEBuilt 1955 · S/N 26928N170LEArends Brian H · Mahomet, ILS/N 18271N170LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881376N170LMGlastonbury Michael C · Sioux Falls, SDS/N 18457N170MWilliams John R Jr · Marfa, TXFirst renewal noticeBuilt 1966 · S/N D-8317N170MBCoffman Richard A II · Hernando, MSBuilt 1950 · S/N 19203N170MSMidstate Aviation Inc · Ellensburg, WAFirst renewal noticeBuilt 1953 · S/N 26085N170MWN88tg LLC · Fairbanks, AKBuilt 1952 · S/N 25411N170NDau Jason E · Fairbanks, AKBuilt 1955 · S/N 26899N170PBFancher Scott · Granite Falls, WABuilt 1950 · S/N 19800N170PPBarry Stephen J · Beaverton, ORBuilt 1955 · S/N 26695N170PRHicks Arch A · Oxford, NCBuilt 1953 · S/N 25686N170PSMcgavock Edward A · Columbus, WIBuilt 1951 · S/N 20152N170PTSabos Anthony J · Bolingbrook, ILBuilt 1950 · S/N 19300N170PYYates James H · Edmond, OKBuilt 1951 · S/N 19949N170REBerbig Daniel J · Anchorage, AKBuilt 1953 · S/N 25922N170RHBas Part Sales LLC · Greeley, COBuilt 1947 · S/N 18030N170RKBelphegor LLC · Madison, WIBuilt 1953 · S/N 26053N170RPDejesus Kennet J · Troy, OHBuilt 1953 · S/N 25865N170RSWilson Benjamin A · Shawnee, KSBuilt 1950 · S/N 19611N170RWSchroth Ian C · Gustavus, AKS/N 18406N170SBMacbean Stanley F Trustee · Orem, UTBuilt 1952 · S/N 25140N170SKNottingham John F · Covington, LABuilt 1979 · S/N 17273173N170SLSimmons Kenton L · Van Alstyne, TXBuilt 1948 · S/N 18138N170STDow Jeff W · Port Hadlock, WABuilt 1948 · S/N 18666N170TAKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1975 · S/N 27-7654005N170TBIal Corp · Lewes, DEBuilt 1973 · S/N 34-7350190N170TCGammelin Robert · Alta, WYBuilt 1949 · S/N 19183N170TDHoyt Nicholas J · Port Orchard, WABuilt 1954 · S/N 26488N170TPNorthrop John · Fairfield, CAFirst renewal noticeBuilt 1950 · S/N 19609N170UJohnson Thomas C · Roseau, MNBuilt 1953 · S/N 25858N170UWBlocher Kristyn A · Tumwater, WABuilt 1948 · S/N 18403N170VPocock Milne David · Cal Nev Ari, NVBuilt 1952 · S/N 20656N170VWPratz Chris · Ellensburg, WABuilt 1952 · S/N 20592N170WRFinkel Charles M · Taylorsville, NCBuilt 1954 · S/N 26450N170WSSikorski Bradley · Colorado Springs, COBuilt 1950 · S/N 19490N170WYLarsen Michael S · Cody, WYBuilt 1954 · S/N 26592N170YPocock Milne D · Cal Nev Ari, NVBuilt 1953 · S/N 25882N1710CSmith Peter R · Lewistown, MTBuilt 1953 · S/N 30410N1710FValley Aviators Inc · Williston, NDBuilt 1966 · S/N 17255105N1710HQuon Nicholas · Fayetteville, GABuilt 1959 · S/N 35810
Back to AD 98-21-21 R1