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.

N2639DHanson Scott · Anchorage, AKBuilt 1952 · S/N 20791N2639FHendershott Kevin J · Vacaville, CABuilt 1965 · S/N 18256739N2639GHusted Dean T · Hicksville, OHBuilt 1959 · S/N 51934N2639WBrown Jeffrey R · Leesburg, FLBuilt 1966 · S/N 976N263AAWilkey Michael B · Kingston, GABuilt 1958 · S/N D-5581N263ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496087N263DBZulu Murphy LLC · Oklahoma City, OKS/N 25-2022N263DHHybird Inc · Corpus Christi, TXBuilt 1982 · S/N 32R-8229067N263DWWarren David T · Mobile, ALBuilt 1959 · S/N 51970N263EAJdcwac LLC · Blair, NEBuilt 2002 · S/N E-3437N263LPMarkman William J · The Dalles, ORS/N 18265959N263MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881361N263NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842064N263SAColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1999 · S/N E-3283N2640FLaguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeBuilt 1979 · S/N 310R1676N2640USealey Gary W · Saint Pauls, NCBuilt 1963 · S/N 17250240N2640YMarc Aircraft Holding LLC · Soldotna, AKBuilt 1962 · S/N 18051140N2641LTm Aviation Services LLC · Riverside, CABuilt 1967 · S/N 17255841N2641PChandler David G · Phoenix, AZBuilt 1979 · S/N 310R1679N2641RHowatt Scott · Hannah, NDBuilt 1967 · S/N 18258341N2641WRampini Daniel G · Cleveland, OHBuilt 1966 · S/N 3303N2641ZTfs Air LLC · Loveland, COBuilt 1979 · S/N 310R1804N2642ACronin LLC · Jacksonville, FLBuilt 1979 · S/N 310R1682N2642CMuniz Elmer · Port Saint Lucie, FLS/N 35042N2642GWillis Andrew B · Wasilla, AKBuilt 1959 · S/N 51942N2642LRiggin Flight Service Inc · Madison, SDS/N 17255842N2642QLongerbone Danny L · Fishers, INBuilt 1970 · S/N 17258931N2642SReich Stephen Barry · Kentfield, CABuilt 1976 · S/N 21061345N2642YStallings Ted W · Seldovia, AKS/N 310R1684N2643FWortham Bethany S · Soldotna, AKBuilt 1965 · S/N 18256743N2643GBorland Gregg A · Elkhart Lake, WIBuilt 1959 · S/N 51943N2643KWashington Walt W · Collierville, TNBuilt 1978 · S/N 18053023N2643QOst Jesse E · Hunter, KSBuilt 1966 · S/N 18257843N2643RNorthern Wings LLC · Spokane, WABuilt 1967 · S/N 18258343N2643UGaring Gerald R · Schenectady, NYBuilt 1963 · S/N 17250243N2643YCompany Plane LLC · Wisconsin Rapids, WIS/N 310R1687N2643ZPolizzi Christopher I · Peachtree City, GABuilt 1979 · S/N 310R1688N2644RColler Randy L · Jackson, MIBuilt 1967 · S/N 18258344N2644VCrosby David · Potomac, MDBuilt 1979 · S/N 310R1812N2644WMoran Robert D Jr · Plano, TXBuilt 1966 · S/N 979N2645FMichel John Vernon III · Westminster, MDBuilt 1965 · S/N 18256745N2645GMurdoch Kyle · Burns, WYBuilt 1959 · S/N 51945N2645KFowlkes John M Trustee · Marfa, TXBuilt 1978 · S/N 18053024N2645LMchugh Eric P · Cleveland, TXS/N 17255845N2645QSigman Kenneth M · Birmingham, ALBuilt 1977 · S/N 28-7790411N2645VPapp Adam · Raleigh, NCBuilt 1948 · S/N 18155N2646Sliger David W · Floral City, FLBuilt 1950 · S/N 19379N2646FAmerican Driveaway LLC · Cowden, ILS/N 18256746N2646PAlas De La Aguila LLC · Kalispell, MTS/N E-2313N2646UEarly Patricia A · Palmyra, PABuilt 1963 · S/N 17250246
Back to AD 98-21-21 R1