OpenAirDocs.org
AD 98-21-21 R1

Registered aircraft · 85,612

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.

N2551DLast Frontier Tailwheel LLC · Anchorage, AKBuilt 1952 · S/N 20703N2551GDaum Cole C · Woodstock, GABuilt 1959 · S/N 51851N2551RHendrix Casey W · Ennis, TXBuilt 1967 · S/N 18258251N2551UPizzuto Samuel J · Chamblee, GABuilt 1979 · S/N 28-8016034N2551XMcgrath Paul · Potsdam, NYBuilt 1965 · S/N P206-0051N2552KRicci Harry A · Kokhanok, AKBuilt 1978 · S/N 18052983N2552LFirst Flight Corp · San Diego, CABuilt 1967 · S/N 17255752N2552QFirefly Aero LLC · Courtland, VAS/N 28-7790405N2552RHooper Jerald Ray · Parker, AZBuilt 1967 · S/N 18258252N2552VBurril Matthew C · Asheville, NCBuilt 1948 · S/N 18057N2552WNahas Rafik E · Laguna Niguel, CABuilt 1965 · S/N 920N2552XN2552x LLC · Boulder, COBuilt 1964 · S/N P206-0052N2553CSwanson Lonnie L · Delta Junction, AKBuilt 1954 · S/N 26197N2553DJohnson Nathaniel D · Attalla, ALBuilt 1952 · S/N 20705N2553GRegistered aircraftS/N 51853N2553QSanders William R Jr · Lafayette, COBuilt 1966 · S/N 18257753N2553RDepore Joseph E · Charleston, SCBuilt 1967 · S/N 18258253N2553VJj&M LLC · Red Lodge, MTBuilt 1948 · S/N 18058N2553WBrown Jeffrey B · Punta Gorda, FLBuilt 1965 · S/N 3265N2553YMacair Aviation LLC · Xenia, OHBuilt 1985 · S/N 28-8516079N2554CWard Wilbur B · Swannanoa, NCS/N 26198N2554KBelleair Aviation LLC · Clearwater, FLS/N 18052985N2554LAirheads Inc · Charles Town, WVBuilt 1967 · S/N 17255754N2554RBartlett Richard H · Sussex, NJBuilt 1967 · S/N 18258254N2554UMustang Ops LLC · Orem, UTBuilt 1963 · S/N 17250154N2554WThomas Ryan · Carolina Beach, NCBuilt 1966 · S/N 1014N2554XWallin Justin · Henderson, NVBuilt 1964 · S/N P206-0054N2554ZClement L Ross · Anchorage, AKBuilt 1963 · S/N 185-0554N25552Region Flyers LLC · Valparaiso, INBuilt 1985 · S/N 28-8516081N2555BHadden Fleming Cindy L · San Antonio, TXS/N 28-25678N2555CLatham David C · Weld, MEBuilt 1954 · S/N 26199N2555LGates Kimberly B · Kintnersville, PABuilt 1967 · S/N 17255755N2555UBurull Donald E · Wichita, KSBuilt 1963 · S/N 17250155N2556KCarlson Steven J · Fairbanks, AKS/N 18052986N2556QDuan Yutao · Walnut, CABuilt 1977 · S/N 28R-7703068N2556VLester Paul W · Hurricane, UTBuilt 1948 · S/N 18061N2556XHusnik Brad M · Forest Lake, MNFirst renewal noticeBuilt 1964 · S/N P206-0056N2556YZeafla Randall R · Elizabethtown, KYBuilt 1962 · S/N 17249856N2557CJmte Aviation LLC · Appleton, WIBuilt 1954 · S/N 26201N2557DFullerton John R · Fairbanks, AKS/N 20709N2557LSparks Ryan J · Peculiar, MOBuilt 1967 · S/N 17255757N2557RWhite Willis W · Boise, IDBuilt 1967 · S/N 18258257N2557SAgri-Flight LLC · Waterford, MIS/N R18201349N2557UWings Of Hope · Chesterfield, MOBuilt 1963 · S/N 17250157N2557WAndre Norman C · Downers Grove, ILBuilt 1965 · S/N 923N2557XRegistration Pending · Troy, IDRegistration pendingBuilt 1964 · S/N P206-0057N2557YSaddle Mountain LLC · Cave Creek, AZBuilt 1962 · S/N 17249857N2558DClayton Alfred T Jr · Anchorage, AKBuilt 1952 · S/N 20710N2558GScolari Shawn Fenton · Meeteetse, WYS/N 51858N2558LHoecher Robert · Anchorage, AKS/N 17255758
Back to AD 98-21-21 R1