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.

N2434USkyhawk N2434u LLC · Wilmington, DEBuilt 1963 · S/N 17250034N2434XJensen Shaun V · Anchorage, AKBuilt 1965 · S/N 18256334N2435ACooper Timothy J · Spearman, TXBuilt 1969 · S/N D-9036N2435DThibodeau Dean U · North Pole, AKBuilt 1952 · S/N 20587N2435FBas Part Sales LLC · Greeley, COS/N 180-51635N2435GVoninski John R · Manlius, NYS/N 51735N2435LAero Science International LLC · Augusta, GABuilt 1966 · S/N 17255635N2435MBrolan Aviation LLC · Kansas City, MOBuilt 1977 · S/N 28-7890253N2435QVolare Aviation LLC · Wylie, TXBuilt 1966 · S/N 18257635N2435UGalati Stephen E · Florissant, MOBuilt 1963 · S/N 17250035N2436CHawk Unlimited LLC · Kalispell, MTS/N 30736N2436DSutton Aircraft Salvage LLC · Palmer, AKS/N 20588N2436GDk Futures LLC · Reno, NVBuilt 1959 · S/N 51736N2436MVenture Aviation Inc · Arlington, MABuilt 1977 · S/N 28R-7837089N2436RSilva Gary · Yerington, NVBuilt 1964 · S/N 18255536N2436YAlpha Flight Academy · Concord, CANon-citizen corporation, flight hours not reportedBuilt 1985 · S/N 28-8516056N24372Curns James R · New London, WIBuilt 1970 · S/N 28-5665N2437CFogleman Brian L · Stonewall, LAS/N 30737N2437FKuersten Robert S · Middleton, WIBuilt 1965 · S/N 18051637N2437MRock Full Gospel Church · Parkersburg, WVBuilt 1979 · S/N 27-7954058N2437RBlackwelder John W · Columbia, KYBuilt 1964 · S/N 18255537N2437UPlanetosea LLC · Doylestown, PABuilt 1983 · S/N 21064782N2437XLudke Arnold · Oakland, NJBuilt 1965 · S/N 18256337N2437YRussell John D · Dana Point, CABuilt 1962 · S/N 17249737N2438GWk Aviation LLC · Buffalo, SDBuilt 1959 · S/N 51738N2438RSpeed Hunter Aviation LLC · Franklin, OHBuilt 1969 · S/N 28-5622N2438UThweatt Greg K · Lodi, CABuilt 1963 · S/N 17250038N2438XRousser Cattle LLC · Amarillo, TXBuilt 1965 · S/N 18256338N2438YHoskins Aaron C · Cayuga, NYBuilt 1962 · S/N 17249738N2439GJ+J Electric LLC · Seminole, TXBuilt 1959 · S/N 51739N2439LBetts William B · Big Lake, AKS/N 17255639N2439USmith Steven T · Charlottesville, VABuilt 1963 · S/N 17250039N2439XAlpha Aero LLC · Biddle, MTBuilt 1965 · S/N 18256339N2439YBluegate Engineering LLC · Richburg, SCBuilt 1962 · S/N 17249739N243AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881733N243ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496042N243BDBennett Reed J · Reno, NVBuilt 1956 · S/N 20591N243DWSijtsma Wouter · Ladson, SCS/N 2844088N243GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881113N243HEason Michael P · Murfreesboro, TNBuilt 1952 · S/N D-3272N243JAYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 28020019N243MSmall Hills Farms · Durham, CABuilt 1982 · S/N 24-1293N243MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881708N243PSN9089 LLC · Lewes, DES/N 3257073N243SDRegistration Pending · Brookings, SDRegistration pendingBuilt 2024 · S/N 4496576N243WMoore William · Dalhart, TXBuilt 1971 · S/N 17260205N243XJLoiacono Vincent · Sunfield, MIBuilt 1965 · S/N 28-2095N2440DXing Kong Aviation Service LLC · Atwater, CAS/N 4496305N2440LEads Kevin C · Arley, ALBuilt 1966 · S/N 17255640N2440UMiller Patrick · Madison, MNBuilt 1963 · S/N 17250040
Back to AD 98-21-21 R1