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.

N191CTBessemer Plywood Corp · Bessemer, MIBuilt 1974 · S/N 310R0057N191DJScallion Leon Ivy · Pine Bluff, ARBuilt 1965 · S/N 3206N191FPravin Aturalita · Duluth, MNBuilt 1964 · S/N TC-716N191GA5056 Bonanza LLC · Tulsa, OKBuilt 1957 · S/N D-5056N191HCTrinair Aviation LLC · Hampshire, ILBuilt 1965 · S/N 2992N191JHJack Henry And Associates Inc · Monett, MOBuilt 1982 · S/N E-2042N191JKN191jk LLC · Brunswick, GABuilt 1982 · S/N E-1943N191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLBuilt 1994 · S/N TH-1720N191NDMoore Aviation Inc · Beaver Falls, PABuilt 1989 · S/N 4495003N191PALa Mooneytte LLC · Seabrook, SCBuilt 1964 · S/N 248N191RAnderson Harold E · Phoenix, AZBuilt 1955 · S/N 35229N191RVSpurgeon Michael · Nashville, TNBuilt 1978 · S/N 32R-7887051N191SHHutton Stephen · Madison, MSBuilt 1968 · S/N 17257232N191WFletcher Flying Service 419 LLC · Labelle, FLBuilt 1964 · S/N TC-577N191WEFs Mickey LLC · East Lansing, MIBuilt 1975 · S/N TE-1059N191WWLichtscheidl Ted J · Forest Lake, MNBuilt 1972 · S/N 17260840N191YPlatte Valley Air LLC · Columbus, NEBuilt 1966 · S/N D-8172N1920CVanjara Gufran U · San Ramon, CABuilt 1964 · S/N 2686N1920DHunt James W · Maryville, TNBuilt 1952 · S/N D-3192N1920FChristensen Dean G · Elk Grove, CABuilt 1979 · S/N 17273012N1920MThompson William F · Fisherville, KYBuilt 1975 · S/N 18264482N1920QAcadian Aircraft Leasing LLC · Rangeley, MEBuilt 1977 · S/N 18503502N1920XJensen Richard Vaughn · Emmett, IDBuilt 1965 · S/N 18256020N1921CRay William H · Lawrenceburg, TNS/N 26066N1921DBrickhouse Aviation LLC · Franklin, TNS/N D-3193N1921FState Of Iowa · Iowa City, IABuilt 1979 · S/N 17273013N1921MRed Shirt Resources LLC · Weatherford, TXBuilt 1975 · S/N 18264483N1922SRodland Roy A · Monroe, WAS/N 17251523N1922TBiscoe Donald M · Cottage Grove, MNBuilt 1969 · S/N 21059220N1922UFriedrich Richard R · Newtown, CTS/N 185-1593N1922VRogers Randall J · Newalla, OKBuilt 1974 · S/N 17263796N1922XHerman Joseph T · Lovell, WYBuilt 1965 · S/N 18256022N1922YDurso Joseph M Jr · Mesa, AZBuilt 1964 · S/N 217N1923FAtlanta Air Academy LLC · Kennesaw, GABuilt 1980 · S/N 17273015N1923HGardner Christopher M · Mankato, MNBuilt 1977 · S/N 28-7725168N1923YHyde Joe G · San Angelo, TXBuilt 1964 · S/N 218N1924HSkyjiro Forge Corp · Arcadia, CABuilt 1977 · S/N 28-7725169N1924XTahiac Aviation LLC · Berryton, KSS/N 18256024N1924YHull Thomas · Midland, TXS/N 219N1925XBtak LLC · New Baden, ILBuilt 1965 · S/N 18256025N1925YMapes Peter B · Oscoda, MIBuilt 1964 · S/N 220N1926DKoosmann Mark R · Corcoran, MNBuilt 1956 · S/N D-3198N1926FUnited Flying Club Inc · Belmont, CABuilt 1979 · S/N 17273017N1926QVonimhof Rudolph F · Anchorage, AKBuilt 1977 · S/N 18503503N1926UBarrett Michael D · Anchorage, AKBuilt 1973 · S/N U20602287N1926XWilkerson Kelvin E Jr · Kannapolis, NCBuilt 1965 · S/N 18256026N1926YRoss Dustin · Georgetown, TXBuilt 1964 · S/N 221N1927DHawksworth Jeff · Laveen, AZS/N D-3199N1927FSanders Herman G · Baldwyn, MSBuilt 1979 · S/N 17273018N1927HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 28R-7737017
Back to AD 98-21-21 R1