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.

N1927TZ And N 1927t LLC · Wapella, ILBuilt 1977 · S/N 182-65857N1928CLafon Daniel L · League City, TXS/N 26073N1928FJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17273019N1928TWalters Jonathan · Malvern, OHBuilt 1990 · S/N CE-1533N1928YMaddex William E · Battle Ground, WAS/N 235N1929CWyborny Wendell R · Cypress, TXBuilt 1953 · S/N 26074N1929UHolmgren David J · Plainfield, NJBuilt 1962 · S/N CD-554N192AAReardon Michael J · East Falmouth, MABuilt 1959 · S/N D-5964N192AMN34cc LLC · Liberty, NCBuilt 2021 · S/N 2881507N192ARDj Whelan Corp · Sag Harbor, NYBuilt 1978 · S/N 17272016N192BSlater Patrick · Glasgow, KYS/N D-4790N192CMFriehe Berend · Moses Lake, WABuilt 1981 · S/N U20606160N192CRIvas Edward P · Great Barrington, MABuilt 1992 · S/N 92-301016N192DKLong Drive Holdings LLC · Alpine, UTS/N 17265020N192FCFleming Michael D · Huntersville, NCBuilt 1968 · S/N 28-24374N192JRCessna 185 LLC · Birmingham, MIS/N 18502286N192MKAdams Andrew T · Westlake, OHBuilt 1992 · S/N 24-3264N192PPiper Aircraft Inc · Vero Beach, FLS/N 28020294N192QFisher Robert · Shoreacres, TXS/N TC-783N192SKDelta Ssm Holding Co · Gladstone, MIS/N 2811022N1930CChidekel Philip M · Chadds Ford, PABuilt 1953 · S/N 26075N1930DFletcher Ellexis L · Corpus Christi, TXBuilt 1952 · S/N D-3203N1930TWing John · Fort Worth, TXS/N 28-7125442N1930VDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1974 · S/N 17263798N1930XDuff James J · Pueblo, COBuilt 1965 · S/N 18256030N1931QKlaes Sheldon T · Fairbanks, AKBuilt 1977 · S/N 18503504N1931VRegistered aircraftBuilt 1974 · S/N 17263799N1931XRuffner Ryon Garrett · Argyle, TXBuilt 1965 · S/N 18256031N1932CSchone Aviation LLC · Albert Lea, MNBuilt 1953 · S/N 26077N1932NChubb Stanley C · Mason, MIBuilt 1973 · S/N CE-417N1932UFryer Charles Trustee · Glendale, AZBuilt 1969 · S/N 18501623N1932YDriver L Spence · Bay City, WIBuilt 1964 · S/N 239N1933FVidal Aviation LLC · Gaithersburg, MDBuilt 1979 · S/N 17273023N1933HBlock Andrea · Chandler, AZS/N 28-7725170N1933MShepherd Matthew R · Bloomington, INBuilt 1976 · S/N 18264487N1933TLogan Flyers LLC · Logan, OHBuilt 1971 · S/N 28-7105151N1933XHall Michael D · Athens, ALBuilt 1965 · S/N 18256033N1934COber John · Candor, NYBuilt 1953 · S/N 26079N1934HMaloney Loran D · Barnhart, MOBuilt 1977 · S/N 28-7716065N1934MKornetzke Jeffrey A · Lake Mills, WIBuilt 1976 · S/N 18264488N1934XMarshall Michael R · Collierville, TNBuilt 1965 · S/N 18256034N1934YMack Anita · Scott Afb, ILBuilt 1964 · S/N 241N1935DCoppage Walter J · Wichita Falls, TXBuilt 1952 · S/N D-3209N1935TWebboe Investments LLC · Falls Church, VABuilt 1971 · S/N 287105153N1935YHodges William L Jr · Spotsylvania, VABuilt 1964 · S/N 289N1936CLalomia Vincent · Montclair, NJBuilt 1953 · S/N 26081N1936FCheek David H · Garland, TXBuilt 1979 · S/N 17273026N1936HBarts Flying Service · Storm Lake, IABuilt 1977 · S/N 28-7716066N1936MScott George M · Reno, NVS/N 18264489N1936SMoore Christopher D · Cheyenne, OKBuilt 1964 · S/N 28-3173
Back to AD 98-21-21 R1