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

N3012LCwp Flight LLC · Lawton, OKBuilt 1979 · S/N 32-7940031N3012NBirkenseer James J · Danville, CAS/N 28-7911099N3012TCain James W · Big Rapids, MIBuilt 1964 · S/N 320C0012N3013ADyer Dennis P · Otis, MES/N 25657N3013DMcclary Doug T · South Lyon, MIBuilt 1978 · S/N 28-7990170N3013FElwell David L · Coolidge, AZFirst renewal noticeBuilt 1966 · S/N 18257113N3013NAnderson John · Hollister, CABuilt 1979 · S/N 28-7911100N3013VCusick Christopher J · La Jolla, CABuilt 1947 · S/N D-415N3013WBrant Lee A · Penngrove, CAS/N 28R-7918085N3013YHolloway Gregory R · Brenham, TXBuilt 1962 · S/N 18254013N3013ZZakos Dean R · Middleton, WIBuilt 1979 · S/N 28-7916395N30144Roberti Aviation Of Delaware Inc · Lighthouse Point, FLS/N 3257330N30147G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7990085N3014FBrown Kimberly L · Tucson, AZBuilt 1966 · S/N 18257114N3014GWings Aircraft LLC · Anacortes, WABuilt 1978 · S/N 28-7911072N3014HBad Dog Aviation Inc · Meridianville, ALBuilt 1978 · S/N 28-7916182N3014QBilly B Services LLC · Cornelia, GABuilt 1967 · S/N 18258014N3014WRunyan Joseph D · Bushnell, ILBuilt 1973 · S/N TE-933N3014XReasoner Michael L · Corvallis, ORBuilt 1979 · S/N 32-7940094N3015CSorna Douglas J · Flower Mound, TXBuilt 1958 · S/N D-5680N3015DFlywell Flying Club Inc · Roseville, MNBuilt 1978 · S/N 28-7990171N3015ECuevas Ernesto · Orlando, FLBuilt 1978 · S/N 17271404N3015UCoastal Fliers Inc · El Cajon, CABuilt 1979 · S/N 28-7990335N3015WDl321 LLC · Lavon, TXBuilt 1973 · S/N TC-1594N3015YBaines Larry R · Antioch, CABuilt 1962 · S/N 18254015N3016APerry Aeronautical Services LLC · Albuquerque, NMBuilt 1953 · S/N 25660N3016CMoore Todd M · Peoria, ILBuilt 1958 · S/N D-5681N3016DHuybrechts Dirk J · Los Angeles, CAFirst renewal noticeBuilt 1978 · S/N 28-7911040N3016FLosleben William L · Duvall, WABuilt 1966 · S/N 18257116N3016MWild Wingdom LLC · Greenville, SCBuilt 1978 · S/N 28-7890284N3016NParker James C · Rescue, CABuilt 1979 · S/N 32-7940038N3016QBarnes David L · Palmer, AKBuilt 1967 · S/N 18258016N3016TWilson Michael L · Santa Maria, CABuilt 1979 · S/N 28-7916298N3016UValley Wings Flight School LLC · Harlingen, TXS/N 17250616N3016WBramble And Schaffer Aviation LLC · Raleigh, NCBuilt 1979 · S/N 28R-7918086N3016YWood James D · Mineral Bluff, GABuilt 1962 · S/N 18254016N30173Tolman William C · Maryville, TNBuilt 1978 · S/N 32R-7887270N30176Arce George S · Roswell, GABuilt 1978 · S/N 32R-7887271N3017AService Oriented Aviation Readiness (Soar) · Bolivar, MOBuilt 1953 · S/N 25661N3017HDavis Ronald C · Bloomington, MNS/N 28-7916184N3017KSwing Paul M · Scottsdale, AZBuilt 1979 · S/N 28-7921048N3017URivera Michael R · Magnolia, TXBuilt 1963 · S/N 17250617N3017WKirk Michael E · Alvin, TXBuilt 1973 · S/N D9520N30184Cp Aviation Inc · Santa Paula, CABuilt 1974 · S/N 17264125N3018FDietzler James J · Weyauwega, WIBuilt 1966 · S/N 18257118N3018QAndre Eric J · Somerset, WIBuilt 1967 · S/N 18258018N3018SPerez Daniel · Pembroke Pines, FLBuilt 1965 · S/N TC-960N3018WAerosport Aviation LLC · Laredo, TXBuilt 1973 · S/N TC-1595N3018YGranger Airplane LLC · Granger, INBuilt 1962 · S/N 18254018N3018ZGorman Robert L · Los Gatos, CABuilt 1979 · S/N 28-7916398
Back to AD 98-21-21 R1