AD 98-21-21 R1

Registered aircraft · 85,616

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.

N119JLMayo Clive S · Palmetto Bay, FLBuilt 1973 · S/N 18262575N119JSFennen David A · Katy, TXBuilt 1961 · S/N D-6861N119LMRegistered aircraftBuilt 1971 · S/N 22-0001N119MBWagner Mike · Godley, TXBuilt 1981 · S/N 24-1135N119MSAeronorth LLC · Ann Arbor, MIBuilt 1969 · S/N 21059121N119P4dw Interests LLC · Longview, TXS/N 17263873N119PCAc Sales & Investments LLC · Hickory, NCBuilt 1979 · S/N 24-0874N119RBDetroit Lakes Aviation Inc · Detroit Lakes, MNBuilt 1966 · S/N D-8231N119RKHtv Music Co · Franklin, TNBuilt 1972 · S/N 18261574N119TTBurrell Anthony · Stillwater, OKBuilt 1981 · S/N D-10369N119TWCarter Flygare Inc · Sacramento, CABuilt 1974 · S/N TH-533N119WRatliff Hayden N · Clarkesville, GABuilt 1953 · S/N D-3518N119WCSmith Steven W · Kodiak, AKBuilt 1972 · S/N 18052235N11ACN11ac LLC · Lighthouse Point, FLS/N TC-215N11APAp Aero LLC · Oklahoma City, OKBuilt 1974 · S/N 21060168N11ATChan Roger J · Anchorage, AKBuilt 1974 · S/N 18502547N11AXLoukopoulos George Matthew · Tucson, AZBuilt 1949 · S/N D-1992N11BCBledsoe Lucile M · Wray, COBuilt 1991 · S/N EA-515N11BTBravo Tango LLC · Minden, LABuilt 1965 · S/N 18256146N11BXMatthew K Cole · Gillespie, ILBuilt 1972 · S/N CE-388N11CSilicz Nicholas J · Shafter, CABuilt 1975 · S/N 18502713N11CASky Dragon LLC · Atlanta, GAS/N 28-8190077N11CEMelcher Pierre S · New Braunfels, TXBuilt 1974 · S/N 18502512N11CFKrens Janet E · Purcellville, VABuilt 1954 · S/N CH-107N11CGComanche 260b-N11cg · Pomeroy, WABuilt 1966 · S/N 24-4434N11CVStoots Christa M · Tucson, AZS/N 24-4130N11CWJabez Aviation LLC · Petaluma, CABuilt 1977 · S/N 28R7737079N11DEPeile Kelly · Lakeview, ORS/N 38087N11DHRegistered aircraftBuilt 1978 · S/N 18052974N11DZLowe Jacob · Knoxville, TNBuilt 1965 · S/N 18256245N11ESale Reported · Wayne, NESale reported, canceledBuilt 1947 · S/N D-699N11ECBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1970 · S/N TH-128N11EMEstus Chad · North Las Vegas, NVBuilt 1957 · S/N D-5159N11EVBonita Beech LLC · Bonita Springs, FLBuilt 1976 · S/N TH-748N11FCCooper Matthew A · Seattle, WABuilt 1947 · S/N D-25R1N11FFJet Speed Aviation Inc · Las Vegas, NVS/N TE-736N11FJPetit Chris J · Marrero, LABuilt 1961 · S/N 18253252N11FLBell Christopher K · Ashley, OHBuilt 1968 · S/N 28R-30444N11FPShannon Rcs LLC · Kalispell, MTBuilt 1952 · S/N D-3104N11FRMosley John E · Jackson, MSBuilt 1971 · S/N 18260761N11GERusso James F · Liberty, SCBuilt 1972 · S/N 28-7325081N11GGGallagher Aviation LLC · Cincinnati, OHBuilt 1959 · S/N D-6184N11GKBaden Michael · Waxhaw, NCS/N 28-23403N11GMPlatt Tony E · Riverside, CABuilt 1979 · S/N D-10298N11GNHaley James M Trustee · Edmond, OKBuilt 1973 · S/N 28-7305330N11GXWestrum Enterprises LLC · Norwalk, IABuilt 1976 · S/N 310R0645N11HAVintage Aero Inc · Brandon, FLBuilt 1973 · S/N 28-7305338N11HHRegistration Pending · Durango, CORegistration pendingBuilt 1965 · S/N 18051484N11HKJohnson Wendell F · Harlingen, TXBuilt 1981 · S/N 32R-8129071N11HRHf Aero LLC · Lusby, MDBuilt 1979 · S/N 34-7970233
Back to AD 98-21-21 R1