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.

N1607DMiko Aviation LLC · Santee, CAS/N 20249N1607FNurieva Asmar · New Smyrna Beach, FLBuilt 1966 · S/N 17255002N1608CMiller Gerald Roy · Denver, NCBuilt 1953 · S/N 30308N1608FSmith Tim J · Leasburg, MOBuilt 1966 · S/N 17255003N1608YKohr Daniel E · Bartlett, TNBuilt 1962 · S/N 17249308N1609CBerry John C · Thunderbolt, GABuilt 1953 · S/N 30309N1609EEilenfeld Teresa · Mansfield, OHBuilt 1978 · S/N 17271065N1609FHeneghan Tim S · Auburn, WABuilt 1973 · S/N 18052316N1609XHarvey P J · Midland, TXBuilt 1975 · S/N 21060645N1609YMapes Steven J · Schenectady, NYBuilt 1962 · S/N 17249309N160DPrice Paul L · Lancaster, VABuilt 1966 · S/N 3448N160DBAguilar Theodore · Bozeman, MTBuilt 1959 · S/N 23-1670N160FSModi Yogini · Homestead, FLBuilt 1979 · S/N 17272752N160LTodd Victor E · London Mills, ILBuilt 1958 · S/N DH-201N160LMMino Leonard G · Pueblo West, COBuilt 1958 · S/N 24-79N160MJFoley Robert A · Columbia, NJS/N 30-1410N160PYeager Robert F · Cuyahoga Falls, OHBuilt 1962 · S/N 18254278N160PTPilot Training Center LLC · Miami, FLBuilt 1978 · S/N 44-7995161N160RFYank-N-Bank LLC · Greeley, COBuilt 1966 · S/N 28-21867N160SPAerospace Trust Management LLC Trustee · Wilmington, DES/N D-9615N160THolmberg Michael G · Hinckley, OHBuilt 1978 · S/N 28-7816373N160TPContrail Aviation Inc · Cheboygan, MIBuilt 1963 · S/N 28-796N160UCrane Rental Service Inc · Tempe, AZBuilt 1960 · S/N CJ-9N160WBBeach Banners Inc · Jacksonville, FLBuilt 1958 · S/N 55238N1610FFrahm Lon R · Colby, KSBuilt 1966 · S/N 17255005N1610MBreuer Lisa · Horseshoe Bend, IDBuilt 1975 · S/N 18264395N1611FTripp Michael J · Macon, GABuilt 1966 · S/N 17255006N1612CBeck Robert A · Cove, ORBuilt 1953 · S/N 30312N1612EPavlovitch Marion T · Northridge, CAFirst renewal noticeBuilt 1978 · S/N 17271066N1613FAde William Henry III Trustee · Tucson, AZBuilt 1966 · S/N 17255008N1613MMclaughlin Drew V · Anchorage, AKBuilt 1970 · S/N 18501833N1613VMcewen Michael A M D · Gadsden, ALBuilt 1974 · S/N 17263692N1613YNelson Bobby E · Lago Vista, TXS/N 17249313N1614CMaggie L Air Service LLC · Kalispell, MTS/N 30314N1614FMathena Chad R · Narrows, VABuilt 1966 · S/N 17255009N1615EFisher Ralph B · Lutz, FLBuilt 1978 · S/N 17271067N1615FWells Edmund B · Austin, MNBuilt 1966 · S/N 17255010N1615VFrance Jeffrey A · Reedville, VABuilt 1974 · S/N 17263693N1615XBvi Aviation LLC · Wilmington, DEBuilt 1975 · S/N 21060651N1616CCleared Direct LLC · Seville, OHBuilt 1953 · S/N 30316N1616DCorbin Sarah R · Anchorage, AKFirst renewal noticeBuilt 1951 · S/N 20258N1616FMarciel John L · John Day, ORBuilt 1966 · S/N 17255011N1617CRetroair Restoration LLC · Big Lake, AKBuilt 1953 · S/N 30317N1617VCook Timothy D · Ashville, NYBuilt 1974 · S/N 17263694N1618DJutting Anthony C · Fruitland, IDS/N 20260N1618FCastillo Giovanny G · Brodheadsville, PAS/N 17255013N1618MFluckey Gary T · Homer, AKBuilt 1970 · S/N 18501834N1619DVintage Pacific Aviator LLC · Redondo Beach, CABuilt 1951 · S/N 20261N1619FReeve Howard E · Minot, NDS/N 17255014N1619WExecutive Aircraft Management LLC · Northport, ALBuilt 1972 · S/N TE-869
Back to AD 98-21-21 R1