AD 98-21-21 R1

Registered aircraft · 85,612

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.

N2989MInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 32-7840062N2989UGodinez Mauricio U · San Diego, CABuilt 1963 · S/N 17250589N2989VContessa Holdings Ltd · Cheyenne, WYS/N D-386N298ATAltura Holdings LLC · New Albany, MSBuilt 1998 · S/N 3257069N298GBSandhu Harpreet · Livermore, CABuilt 1977 · S/N 17268841N298HPPendergrass Inc · Demopolis, ALBuilt 1998 · S/N 3246110N298JCNiemeijer Meindert · Coralville, IABuilt 1978 · S/N R18200740N298MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2843864N298NDNational Training 1 LLC · Wilmington, DEBuilt 2001 · S/N 4496085N298PWMedina Ruben F · Foothill Ranch, CABuilt 1965 · S/N 28-20851N298SHHeising Sean Allen · Billings, MTBuilt 1993 · S/N 3213064N298SMSmb Flyer LLC · Queen Creek, AZBuilt 1973 · S/N 18262327N298VBEdholm Joseph · Lino Lakes, MNBuilt 1959 · S/N 50364N2990ATottle K M DBA · Limington, MEBuilt 1953 · S/N 30190N2990CLyng Stephen G · Kenosha, WIBuilt 1954 · S/N 30890N2990KGundersen Timothy A · Henderson, NVBuilt 1980 · S/N 18053153N2990UShiny Pigeon LLC · Fort Worth, TXBuilt 1963 · S/N 17250590N2991FBerryessa Alan E · Cedarville, CABuilt 1966 · S/N 18257091N2991KHayton James B · Sedro Woolley, WAS/N 18053154N2991LRussell Daniel · Louisville, KYS/N 670350N2991UNeary Joseph P · Lindenhurst, ILBuilt 1963 · S/N 17250591N2991VParsons Franklin R Jr Trustee · Kiowa, COS/N D-389N2991YRabska William G · Suisun City, CABuilt 1962 · S/N 18253991N2992DArnold Scott M · Peachtree City, GAS/N 26935N2992RSolrei Inc · West Palm Beach, FLS/N 28R-35382N2992VSheridan Jeffrey S · Lakeville, MNBuilt 1947 · S/N D-390N2993BHillegeist Tracy · Beverly, KSBuilt 1953 · S/N D-3631N2993CFrei Jayci N · Grangeville, IDS/N 30893N2993DBcw Aviation LLC · Sigourney, IABuilt 1955 · S/N 26936N2993FDaniels Aviation Inc · Inverness, MSS/N 18257093N2993LGoutell Carl R · Marco Island, FLBuilt 1967 · S/N 670352N2993RSell Carl N · Spanaway, WABuilt 1969 · S/N 28R-35384N2993U63 Aviation LLC · Petoskey, MIBuilt 1963 · S/N 17250593N2993YBranch Robert W · Fort Mohave, AZS/N 18253993N2994ADicicco Matthew Trustee · Los Gatos, CABuilt 1953 · S/N 30194N2994DAncam Lc · West Burlington, IABuilt 1955 · S/N 26937N2994ESkyventure Aviation LLC · Battle Creek, MIBuilt 1979 · S/N 17271398N2994R2994r Aircraft Leasing LLC · Spanish Fork, UTBuilt 1969 · S/N 28R-35386N2994VJetmx Inc · Goodyear, AZS/N D-392N29950Nichols William K · Bainbridge, GABuilt 1974 · S/N TC-1760N29959Nail Ronald Wesley · Edmond, OKBuilt 1986 · S/N E-2340N2995BLeggat Douglas J · Manhattan, KSBuilt 1953 · S/N D-3633N2995DPapoulias Michael A · Jackson, MIBuilt 1955 · S/N 26938N2995FCj3 Aviation LLC · Idaho Falls, IDBuilt 1966 · S/N 18257095N2995LS&S Wings And Wheels LLC · Wilmington, DEBuilt 1967 · S/N 670354N2995QTraveling Aviators LLC · West Valley City, UTS/N 32R-7780275N2995RAbj Aviation LLC · Montgomery, OHBuilt 1969 · S/N 28R-35387N2996BSale Reported · Alton, ILSale reportedBuilt 1953 · S/N D-3634N2996CSutton Aircraft Salvage LLC · Palmer, AKBuilt 1954 · S/N 30896N2996DParker Stephen H · Montgomery, TXBuilt 1955 · S/N 26939
Back to AD 98-21-21 R1