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.

N2CYPallante John · Manahawkin, NJS/N 24-3003N2DARask Mark C · Becker, MNBuilt 1967 · S/N 28-23401N2DCGottsleben John J · Tucson, AZBuilt 1964 · S/N D-7318N2DGAgostini Glenn · Tampa, FLBuilt 1964 · S/N 28-1526N2DMWiley Post LLC · Lewes, DEBuilt 1970 · S/N 21059305N2DNHaines Matthew E · Lake Dallas, TXBuilt 1973 · S/N D-9426N2DPGreat Circle Flying Club Inc · Sandusky, OHBuilt 1973 · S/N 32-7340112N2DQLemont Corp · Southwest, PABuilt 1967 · S/N TG-3N2DRGustafson Dale H · Kingwood, TXBuilt 1962 · S/N D-6924N2DURegistered aircraftBuilt 1977 · S/N D-10030N2DVLewis Paul A · Spring, TXBuilt 1960 · S/N 24-1679N2DWSquare One Enterprises Corp · Hot Springs, ARBuilt 1973 · S/N 28R-7335368N2EBCampbell Bernard D · Morehouse, MOBuilt 1971 · S/N 18260609N2EYBender Jeffrey T · Scottsdale, AZBuilt 1967 · S/N D-8401N2FKAshwath Nagaraj · Los Altos Hills, CABuilt 1978 · S/N CE-834N2FNFlying Neutrons LLC · Lebanon, OHBuilt 1977 · S/N 17269910N2FRMarcum Alan M · Palo Alto, CABuilt 1989 · S/N 25-1211N2FXPlane Crazy Aviation LLC · Hollywood, SCBuilt 1966 · S/N 27-3147N2GAWilson Frank C · Irondale, OHBuilt 1974 · S/N 18502376N2GHAbel Robert G · Williamstown, MABuilt 1963 · S/N 2050369N2GRRichardson Gordon B II · Caldwell, TXBuilt 1961 · S/N D-6659N2HABrunner Robert L · Jefferson, ORBuilt 1975 · S/N 17265382N2HJLittle Eagle Valley LLC · Dover, DES/N CE-542N2HRWertheim Michael S · Fort Pierce, FLBuilt 1974 · S/N 27-7405342N2HSIsland Pearl Airways · Doral, FLFirst renewal noticeBuilt 1979 · S/N 34-8070022N2HUN2hu LLC · Parker, COS/N R18200447N2JCJcmc Inc · Junction City, KSBuilt 1984 · S/N E-2172N2JHReign Air Charter Corp · New Port Richey, FLBuilt 1964 · S/N 17252443N2JKGoldberg Leonard J · Westbrook, CTBuilt 1977 · S/N 18265546N2JXBrookeash Inc · Waxahachie, TXBuilt 1965 · S/N D-7811N2KBKb Aviation LLC · Mission Viejo, CABuilt 1974 · S/N E-599N2KDElliott Frank F · Mojave, CAFirst renewal noticeBuilt 1969 · S/N T210-0436N2KMBas Part Sales LLC · Greeley, COBuilt 1973 · S/N TC-1608N2KNSareavco LLC · Kissimmee, FLBuilt 1987 · S/N 24-3031N2LCStults Curt M · Choctaw, OKBuilt 1961 · S/N CD-403N2LHStotlar Richard L · Tucson, AZBuilt 1987 · S/N CE-1133N2MBAlfa Foxtrot LLC · Statesville, NCBuilt 1978 · S/N 310R1357N2MHN2mh LLC · Albuquerque, NMS/N 32R-7887009N2MLMclaury Kim · Mission Hill, SDBuilt 1997 · S/N E-3114N2MTO'Leary John M · Fresno, CABuilt 1963 · S/N CD-612N2NMMayberry Harold M · Bryant, ILBuilt 1949 · S/N 18831N2NZFriedland Dana K Jr · Mountain Home, ARS/N 32R-7780111N2PNFugro USA Land Inc · Rapid City, SDBuilt 1977 · S/N 31-7752141N2PWXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 44-7995087N2PXBliss James · Corpus Christi, TXBuilt 1977 · S/N 28-7816211N2QWPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754126N2RBRegistered aircraftBuilt 1981 · S/N 24-1148N2RHRene M Haas Inc · North Chatham, MABuilt 1996 · S/N 24-3376N2RPFasken Frank Andrew · Paris, TXS/N 27-7754160N2RSSlippy Timothy W · Bothell, WABuilt 1972 · S/N 28-7205179
Back to AD 98-21-21 R1