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.

N1471TFranks James Charles · Conroe, TXBuilt 1972 · S/N 28-7225528N1471UEast Tenn Pilots Club Inc · Knoxville, TNS/N 17267138N1471XSale Reported · Epworth, GASale reportedBuilt 1975 · S/N 28-7525311N14721Mcdonald Trading Post Inc · Plainview, TXBuilt 1973 · S/N 74-30647N14729Heard Terrell · Amarillo, TXBuilt 1974 · S/N 74-30707N1472FCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17273007N1472TGreen Lakes Aviation LLC · Belton, SCBuilt 1972 · S/N 28R-7235298N1472UEbben Robert A · New London, WIS/N 17267139N14732Robson Thomas A · Mcdonough, GABuilt 1974 · S/N 75-30756N14734Thorman Bryan R · Grand Junction, COBuilt 1974 · S/N 75-32-154N14736Stern Gerald W · Ft Worth, TXBuilt 1974 · S/N 74-30703N14738Stern Gerald W · Fort Worth, TXBuilt 1974 · S/N 74-30694N1473DDrake Wm Ronald · Marshall, MOBuilt 1951 · S/N 20056N1473FSilveira Paul J · Valdez, AKS/N 18502851N1473M182p LLC · Oklahoma City, OKBuilt 1975 · S/N 18264340N1473SBattin Robert C · Cartersville, GABuilt 1976 · S/N 18265020N1473YPetty James F · Crandall, GABuilt 1962 · S/N 17249173N14740Coleman Edward H · Tulare, CABuilt 1973 · S/N 74-30642N14744Trimble Anthony W · Weatherford, TXS/N 74-30630N14745Rockwell Donnal E · Ozona, TXBuilt 1973 · S/N 74-30656N14746Kashiwa Charles · Glens Falls, NYS/N 75-32-156N14747Hausken Matthew · Centuria, WIBuilt 1973 · S/N 73-31071N1474ESuffolk County Police Pilots Assoc · Bayport, NYBuilt 1978 · S/N 17271015N1474FJlb Aviation Services LLC · Woodbine, NJBuilt 1979 · S/N 17273008N1474PMccormick Robert E · Selah, WAS/N 23-541N1474TStella Stephen G DBA · Fort Lauderdale, FLBuilt 1972 · S/N 32-7240125N1474UHentges Jerry J · Morris, MNBuilt 1976 · S/N 17267141N1474XKjeldsen Frederik C M · Poughkeepsie, NYBuilt 1975 · S/N 28-7515407N14751Maiorka Kevin D · Lockhart, TXBuilt 1974 · S/N 74-30666N14754Registration Pending · Clarkston, MIRegistration pendingBuilt 1975 · S/N 75-30765N14758Jim Franklin Aviation Service Inc · Ruidoso, NMBuilt 1974 · S/N 74-32-141N1475FAc Group LLC · Helena, MTBuilt 1975 · S/N 18502853N1475SMurdoch-Haig Alexandra · Kailua, HIBuilt 1976 · S/N 18265022N1475VGlobal Flight Training Solutions Inc · Immokalee, FLS/N 17263610N1475YAbe Lincoln Flyers Inc · Lincoln, ILBuilt 1962 · S/N 17249175N1476251 Adventures LLC · East Montpelier, VTS/N 74-30649N14764Bl14764 LLC · Homer, LABuilt 1974 · S/N 74-30701N1476SBk1 Farms LLC · Rock Port, MOBuilt 1976 · S/N 18265023N1476TBough Jayce K · El Dorado Hills, CAS/N 28-7225530N1476UTampa Bay Aviation Inc · Clearwater, FLBuilt 1976 · S/N 17267143N1476XAbel Adam T · Aberdeen, OHS/N 28-7525309N1476YHamilton Gene A · Saegertown, PABuilt 1962 · S/N 17249176N14771Shiner Aviation LLC · Georgetown, TXBuilt 1974 · S/N 75-30732N14772Koehn Loren M · Galva, KSBuilt 1974 · S/N 74-30691N1477FMavity Reagan Chase · Clayton, GABuilt 1966 · S/N 17254972N1477GDobson John F · Union, WABuilt 1962 · S/N D-6980N1477TSrh Club Inc · Wilmington, DEBuilt 1972 · S/N 28-7205306N1477VSatermo Lee John · New Town, NDBuilt 1974 · S/N 17263612N1477XRed Rock Flying School LLC · Mesa, AZBuilt 1975 · S/N 28-7525313N14782Roberts James B · Piedmont, OKS/N 74-30629
Back to AD 98-21-21 R1