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.

N1679FCrawford Anthony B · Hampton Cove, ALBuilt 1966 · S/N 17255074N1679HLake Elmo Aero LLC · Lake Elmo, MNS/N 28-7790331N1679MVaughns Flying Service Inc · Reese, MIBuilt 1971 · S/N 18501870N1679XBouchereau Raymond Jr · San Dimas, CABuilt 1975 · S/N 21060714N1679ZRiemer Emil F · Brush Prairie, WABuilt 1962 · S/N 185-0479N167BHHolliday Robert R · Andover, KSBuilt 1966 · S/N 17255345N167JWStrittmatter Joseph M · Aubrey, TXBuilt 1968 · S/N D-8792N167LDRegistered aircraftS/N 670105N167MStoltzfus Jesse A · Greenfield, OHBuilt 1964 · S/N CD-795N167NGohman Charles Scott · Salinas, CAS/N TE-137N167QQGrondahl Chad R · Peyton, COBuilt 1966 · S/N 670149N167TFWhitney David W · Ooltewah, TNBuilt 1967 · S/N D-8472N167TRBarton Aviation LLC · San Antonio, TXBuilt 1998 · S/N TH-1849N1680CRogers Terrence W · Almond, WIBuilt 1953 · S/N 30380N1680DTrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1952 · S/N 20322N1680FBoyette Robert Wayne · Ashford, ALBuilt 1966 · S/N 17255075N1680HShimkus Aviation LLC · Tupelo, MSS/N 28R-7703031N1680RSchulze Roger F · Hanford, CABuilt 1978 · S/N R18200512N1681CClark Eddie · Naknek, AKBuilt 1953 · S/N 30381N1681DKaiserauer Brian · Longmont, COBuilt 1952 · S/N 20323N1681FRegistered aircraftBuilt 1966 · S/N 17255076N1681UMeise Bill · Spring Green, WIBuilt 1982 · S/N 21064725N1682CFly & Fish LLC · Kalispell, MTBuilt 1953 · S/N 30382N1682FBravo Zak Air LLC · Lake Wales, FLBuilt 1966 · S/N 17255077N1682JBeatty Gary A · Mosinee, WIFirst renewal noticeBuilt 1967 · S/N 28-24083N1682RDelcamp Don D · Troy, OHBuilt 1978 · S/N R18200513N1682YStorby Steven R · Osceola, WIBuilt 1962 · S/N 17249382N1683JMiranda Emigdio · El Dorado Hills, CAS/N 28-24084N1683WAirsouth Aviation Services Inc · Little Rock, ARS/N TC-1526N1683YKnutson Daniel T · Lodi, WIBuilt 1962 · S/N 17249383N1683ZSchmitz David K · Spooner, WIBuilt 1962 · S/N 185-0483N1684CBredin William B · Anchorage, AKS/N 30384N1684FRedmon Robert J · Gallatin, TNBuilt 1966 · S/N 17255079N1684HPlane Folks LLC · Tucson, AZBuilt 1977 · S/N 28-7725154N1684JJarriel Investments Inc · Register, GABuilt 1967 · S/N 28-24086N1684WHaller Philip L · Peoria, AZS/N D-9386N1684YKoenig William J · Benedict, MDS/N 17249384N1685CBallard Heather A · Pleasant Prairie, WIS/N 30385N1685DAngrisani Robert J · Sacramento, CABuilt 1952 · S/N 20327N1686CButts Michael D · Carson City, NVBuilt 1953 · S/N 30386N1686ELiddick Terry S · Spearfish, SDBuilt 1978 · S/N 17271093N1686FAdams Claude T Jr · Palmer, AKBuilt 1966 · S/N 17255081N1686JPatterson John E · Jacksonville, ILBuilt 1967 · S/N 28-24088N1686MTerrastar LLC · Kalispell, MTBuilt 1971 · S/N 18501873N1686YBrissel John M · El Paso, TXBuilt 1962 · S/N 17249386N1686ZBruegger Shannon B · Lance Creek, WYBuilt 1963 · S/N 1850486N1687FTigerair 2020 LLC · Newark, DES/N 17255082N1687JMarsh Flyers LLC · Britton, SDBuilt 1968 · S/N 28-24089N1687WAirway Management Inc · Wilmington, DEBuilt 1972 · S/N E-355N1687XMorton Douglas E · Cody, WYBuilt 1975 · S/N 21060722
Back to AD 98-21-21 R1