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.

N2047GSatina David J · Norton, OHBuilt 1958 · S/N 51347N2047NAwa Aviation LLC · Sacramento, CABuilt 1978 · S/N E-1400N2047PFromknecht Robert L · Quakertown, PABuilt 1978 · S/N E-1401N2047WKapusta Marian · Clearwater, FLBuilt 1965 · S/N D-7986N2047YMohr Jacob Karl · Van Wert, OHBuilt 1962 · S/N 17249547N20481Lesage Robert E · Puyallup, WABuilt 1973 · S/N 17261324N20484North Central Aircraft Sales · Tioga, NDBuilt 1973 · S/N 17261327N20486Humbert Delmar Alan · Briones, CABuilt 1973 · S/N 17261329N20487Point To Point Air LLC · Arlington, WAS/N 17261330N20488Aurora 17 Holdings LLC · Aurora, ORBuilt 1973 · S/N 17261331N2048BCicciari David A · Cincinnati, OHBuilt 1978 · S/N E-1402N2048GIozia Luz E · Ruidoso, NMS/N 51348N2048MMiller Gerald L · Selinsgrove, PABuilt 1977 · S/N 28-7816244N2048V5l Aviation LLC · Decatur, TXBuilt 1978 · S/N E-1404N2048WTripi Mark DBA · Parkersburg, WVBuilt 1965 · S/N D-7987N2048YIron Horse Aviation LLC · Omak, WAS/N 17249548N2048ZJulis Wings LLC · Jacksonville, FLBuilt 1978 · S/N CE-828N20490Aarow Aircraft Leasing LLC · Mcminnville, ORS/N 17261333N20494Aviation Group Jmj Inc · Callahan, FLS/N 17261337N20496Hess Garrett J · Fullerton, CABuilt 1973 · S/N 17261339N2049ASouth Delta Aviation Inc · West Helena, ARBuilt 1978 · S/N E-1405N2049CPray Matthew W · Augusta, KSBuilt 1959 · S/N TD-234N2049NAdvanced Aviation LLC · New Century, KSBuilt 1978 · S/N D-10190N2049RHook Sean · Garden Ridge, TXBuilt 1969 · S/N 28-5445N2049WHufford P Thomas Trustee · San Diego, CABuilt 1965 · S/N D-7985N2049XTaylor Stephen A · Benton, KSBuilt 1965 · S/N 18256149N2049ZObie Edgar L · Chinook, MTBuilt 1978 · S/N E-1398N204BTulin Bradley G · Sedona, AZBuilt 1956 · S/N D-4548N204CMMorgan Kenneth J · Norridgewock, MEFirst renewal noticeBuilt 1975 · S/N 17265224N204DPDavid Perry LLC · Oklahoma City, OKBuilt 1979 · S/N 24-0891N204EAEtheredge Mark · Pell City, ALBuilt 2023 · S/N 28020119N204GAirmart Inc · Lexington, KYS/N TH-2042N204JWN204jw LLC · Fort Worth, TXBuilt 1976 · S/N 18265167N204LPSteffenhagen Julian L Jr Trustee · Tustin, CABuilt 1988 · S/N CE-1262N204MMAvest Ltd · Hilltop Lakes, TXS/N 24-0718N204NDAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2002 · S/N 2844070N204PT A Infinities LLC · Dover, DEBuilt 1991 · S/N E-2601N204PCHestertown Aviation LLC · Monroe, GABuilt 1973 · S/N 32-7440036N204RBRoper Benjamin F · College Station, TXS/N 28R-7703149N204RKHermann Ron A · Sarasota, FLBuilt 1985 · S/N 28-8611003N204SCGyure Ronald J · Fort Worth, TXBuilt 1965 · S/N 27-2796N204SJStuart M Davis Inc · Rice, WABuilt 1972 · S/N 32-7240097N204SRSunrise Aero Inc · Ocala, FLS/N 17262822N204TAAnderson Thomas W · Mustang, OKBuilt 1967 · S/N 680059N204TSAs The Crow Flies Aerial Services LLC · Irving, TXBuilt 1977 · S/N U20604052N204WTRegistered aircraftBuilt 1964 · S/N 30-699N20500Duflo Jeffrey T · Lowville, NYBuilt 1973 · S/N 17261343N20503Vyatkin Denis · Sacramento, CABuilt 1973 · S/N 17261346N20504Yoanna Flight School Inc · Fort Myers, FLNon-citizen corporation, flight hours not reportedS/N 17261347N2050CDow Jeffrey W · Port Hadlock, WAFirst renewal noticeBuilt 1959 · S/N TD-229
Back to AD 98-21-21 R1