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.

N1738JPiper 38j LLC · Buckeye, AZBuilt 1968 · S/N 28-24153N1738TClinton 83 Aviation LLC · La Place, LAS/N 28-7125055N1739COpp Daniel · Anchorage, AKBuilt 1953 · S/N 30439N1739FSessions Jan · Kirbyville, TXBuilt 1966 · S/N 17255134N1739JSahli Theodore E · Costa Mesa, CABuilt 1968 · S/N 28-24154N1739TWatkins Felton III · Meridian, MSBuilt 1970 · S/N 28-7125056N173BADunlap Jolene · Peoria, ILBuilt 1979 · S/N 17272370N173DSanford Mark J · Ithaca, NYBuilt 1964 · S/N TC-825N173KADaigle Lawrence J · Cohasset, MNBuilt 1972 · S/N 17260939N173KMLd Enterprises Llp · Roswell, GABuilt 1968 · S/N 17257781N173MMitchell Jonathan L · Poteau, OKBuilt 1981 · S/N 32R-8113087N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960N173PKTrc-4k Investments LLC · Southlake, TXBuilt 1968 · S/N 17257364N173QLively Scott Jacob Charles · Greenbrier, ARBuilt 1964 · S/N D-7350N173RJJohnston Ronald E · Seattle, WAS/N 26269N173SKS Kamat Inc · Lexington, KYS/N 17272108N173SNWilliams Hoffman Alexander M · Downers Grove, ILBuilt 1967 · S/N 32-912N173TAughenbaugh Timothy A · Iroquois, SDS/N D-8259N173VALegner Leasing LLC · Las Vegas, NVBuilt 1971 · S/N 172-60090N173VFCorlee Douglas K · Palm Coast, FLBuilt 1964 · S/N 17252157N173VRDauria William · Anna, TXBuilt 1971 · S/N 18260781N1740FBecton Richard A · San Antonio, TXBuilt 1966 · S/N 17255135N1740GOelrich Matthew Alan · Concord, CABuilt 1962 · S/N CD-490N1740WCarlsbad Raceway Corp · Hemet, CABuilt 1972 · S/N CD-1302N1741CWitt William A · Ennis, MTBuilt 1953 · S/N 30441N1741GPlane Fun Inc Tr Trustee · Snellville, GABuilt 1956 · S/N D-4773N1741JReynolds David Hays J · Ariton, ALS/N 28-24157N1742ECole-Tac LLC · Rapid City, SDBuilt 1978 · S/N 310R1558N1742FMarsteller Bruce Paul Jr · Greensburg, PABuilt 1966 · S/N 17255137N1742GLoftus Kevin · Pasadena, CABuilt 1962 · S/N CD-467N1742VGalion Air Inc · Galion, OHBuilt 1974 · S/N 17263735N1742XR&C Aviation Partners LLC · Tucson, AZBuilt 1975 · S/N 21060763N1743DCranton Larry J · Mesa, AZBuilt 1952 · S/N 20343N1743FLittle Bird Airways LLC · Hamburg, NYBuilt 1966 · S/N 17255138N1743GYoung Harrison · Phoenix, AZBuilt 1962 · S/N TC-278N1743HN1743h LLC · Yorktown, VAS/N 28-7790337N1743JRomualdi Giovanni · Torrance, CABuilt 1968 · S/N 28-24159N1743RChronicle Aerospace Inc · Wilmington, DEBuilt 1974 · S/N 18502463N1743VRegistered aircraftBuilt 1974 · S/N 17263736N1743WThomas John J · Marana, AZBuilt 1972 · S/N D-9404N1744DJones William H Trustee · Wenden, AZBuilt 1951 · S/N 20187N1744GWelsh Ayden · Dayton, OHBuilt 1962 · S/N D-6953N1744XDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21060765N1745DStuczynski Jason S · Justin, TXBuilt 1951 · S/N 20188N1745FClary David D · Elk Grove Village, ILBuilt 1966 · S/N 17255140N1745RFiske James K · North Andover, MAFirst renewal noticeBuilt 1974 · S/N 18502465N1745TStoffer Aviation LLC · Marion, INBuilt 1970 · S/N 28-7125063N1745WThoroughscape Inc · Wellington, FLBuilt 1972 · S/N CE-409N1746Mclain Mitchell J · Southaven, MSBuilt 1986 · S/N 24-1598N1746CGreen Gary Dale · Mccarthy, AKBuilt 1953 · S/N 30446
Back to AD 98-21-21 R1