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.

N246BCKeystone Solutions LLC · Higley, AZS/N 18259539N246BMBlue Oasis Flight Support · Tamarac, FLBuilt 1978 · S/N 34-7870083N246BWRc Sun Enterprises Inc · Loveland, COS/N 79-30930N246CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881002N246CCAlaska Department Of Public Safety · Anchorage, AKBuilt 1979 · S/N U20605314N246DYWilson Ralph W Trustee · Mentor, OHBuilt 1996 · S/N E-3065N246ECKnight Air LLC · Wausau, WIS/N 21062435N246EEBaldwin Alexander L · Saint Charles, MOS/N D-6797N246JJlr Resources LLC · Naples, FLBuilt 1979 · S/N P21000355N246JBN246jb LLC · Boynton Beach, FLBuilt 1973 · S/N 28R-7435003N246JCSchultes James F Jr · Woodbury, NJBuilt 1985 · S/N 24-1557N246JDHilliard Bruce · Grantsville, UTS/N 74-31105N246JMForbes Thomas L · Poland, OHBuilt 1964 · S/N 535N246KWGenellie Gerald F Jr Trustee · Batavia, OHBuilt 1980 · S/N 18267659N246LSJohnson Mark · Macon, MSS/N 32185N246MWLandrum Stuart · Farmington, MOBuilt 1964 · S/N 30-678N246NDGlobal Aviation Corp · Farmingdale, NYBuilt 1999 · S/N 2842056N246PAHugie Lucas R · Logan, UTS/N 18257487N246SPWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269023N246TAHartman Allen L · Queen Creek, AZBuilt 1979 · S/N 80-30977N246TFMorgan Daniel D · Topeka, KSS/N R18201677N246VTAkwe River Flying And Guide Service LLC · Yakutat, AKBuilt 1975 · S/N U20602822N246WBToavs Brent J · Wolf Point, MTBuilt 1969 · S/N D-8951N2470CMcclymond Tyler L · Grand Junction, COS/N 30770N2470GBaillargeon Richard W · Springville, IABuilt 1959 · S/N 51770N2470LSmith Joseph · Sycamore, ILBuilt 1966 · S/N 17255670N2470QCities Aviation Services LLC · Dubberly, LABuilt 1966 · S/N 18257670N2470UT C I Aviators LLC · Lewes, DEBuilt 1963 · S/N 17250070N2471CCavjet LLC · Bonham, TXBuilt 1954 · S/N 30771N2471QThomas Salvatore J · Lenoir City, TNBuilt 1966 · S/N 18257671N2471RFykerud Eric J Sr · Bend, ORBuilt 1964 · S/N 18255571N2471USchroeder Nyla R · Minneapolis, MNBuilt 1979 · S/N 28-8090049N2471YRegistered aircraftBuilt 1962 · S/N 17249771N2472Vivid Aviation LLC · Las Vegas, NVBuilt 1976 · S/N E-906N2472FParr Crawford B · Anchorage, AKBuilt 1966 · S/N 18051674N2472QSalzman Denise M · Cameron Park, CABuilt 1966 · S/N 18257672N2472RVac New Inc · China Village, MENon-citizen corporation, flight hours not reportedBuilt 1964 · S/N 18255572N2472XPhillips Robert Frank · Tabernacle, NJBuilt 1965 · S/N 18256372N2472YAndrews Kevin M · Riverside, CABuilt 1970 · S/N E-254N2473CLewis Eddy L · Cortez, COBuilt 1954 · S/N 30773N2473RRonald O Holcomb LLC · Lapeer, MIBuilt 1964 · S/N 18255573N2473WCahill Chad · Edmond, OKBuilt 1985 · S/N 28-8590073N2473YFunderburg Erskine R · Pell City, ALBuilt 1985 · S/N 28-8590074N2474DDavidson Chad E · Roxton, TXBuilt 1952 · S/N 20626N2474EBas Part Sales LLC · Greeley, COS/N 17271297N2474QBurnet Aviation Group LLC · Bertram, TXBuilt 1966 · S/N 18257674N2474UPistor Elise D · Colleyville, TXBuilt 1963 · S/N 17250074N2474XKramer William L · Wellington, FLBuilt 1965 · S/N 18256374N2475CHansen Curtis · Merrimack, NHBuilt 1954 · S/N 30775N2475DGresley Ross A · Catawba, NCS/N 20627
Back to AD 98-21-21 R1