OpenAirDocs.org
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.

N1190HBergman William George · Muskegon, MIBuilt 1977 · S/N 28-7716002N1190MDorr Daniel B · Locust Grove, GABuilt 1969 · S/N 17258690N1190QBritell Andrew Paul · Sandwich, NHBuilt 1972 · S/N 21059690N1191DFas Holdings LLC · Osage Beach, MOBuilt 1986 · S/N TH-1506N1191FStopa Gary · Florida, NYBuilt 1966 · S/N 17254786N1191HBurford John W Trustee · Madison, MSS/N 28-7790294N1191MMoore John S · Tracy, CABuilt 1969 · S/N 17258691N1191QCameron Schoessler Aviation LLC · Bliss, IDBuilt 1975 · S/N U20602862N1191UFlitepro Inc · Murrieta, CAS/N 17266892N1191VWilmarth Rebecca C · Red Devil, AKBuilt 1974 · S/N U20602506N1192MGaruda Aviation Inc · Miami, FLBuilt 1969 · S/N 17258692N1193FVoss Douglas D · Grand Island, NEBuilt 1979 · S/N 17272964N1193MEagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17258693N1194AGta Air Inc · Addison, TXBuilt 1969 · S/N E-159N1194HCrnic Paul C · Chesterfield, MOS/N 28R-7703016N1194MGadamic LLC · Fresno, CABuilt 1969 · S/N 17258694N1194QKirkpatrick Jason · Mosca, COBuilt 1975 · S/N U20602864N1194XCantrell William Terry · Spring Hill, TNS/N 34-7570236N1195MBrown Alan J · Cheyenne, WYBuilt 1975 · S/N 18264240N1195TRoberts Robin W · Birmingham, ALBuilt 1974 · S/N E-629N1195UMatonti James R · Oklahoma City, OKBuilt 1976 · S/N 17266896N1196USwaff Properties LLC · Humble, TXBuilt 1976 · S/N 17266897N1196XMedic Choppers LLC · Springdale, ARS/N 28-7525279N1197FSchumacher Bradley M · Lewiston, IDBuilt 1975 · S/N 18502763N1197MSholer Jon R · Battle Ground, WABuilt 1975 · S/N 18264241N1197PPenley Steven A · Corinth, TXBuilt 1955 · S/N 23-212N1197UP D H S Aerial Photography Inc · St Petersburg, FLBuilt 1976 · S/N 17266898N1198FStockle Barry W · Oakland, CABuilt 1966 · S/N 17254793N1198HAlge Aviation · Middletown, DES/N 32R-7780143N1198MGoeke Christine A Trustee · Hartland, WIBuilt 1969 · S/N 17258698N1198XDiscover Aviation Center LLC · Elyria, OHBuilt 1975 · S/N 28-7505223N11995Russell Ricky · Montrose, ARS/N 18263974N11999Euroaviation Inc Trustee · KematenBuilt 1989 · S/N 25-1213N1199ULansford Inc · Clovis, NMBuilt 1982 · S/N 21064673N119A2is Partners LLC · Vero Beach, FLBuilt 1969 · S/N 28-25947N119ABSafford Aviation Service Inc · Coolidge, AZBuilt 1966 · S/N TE-145N119ACKidd Kevin A · Key West, FLBuilt 1972 · S/N TH-188N119AVFour Mac Air LLC · San Diego, CAFirst renewal noticeBuilt 1984 · S/N 28-8490079N119BTDelaware US Investments LLC · Corpus Christi, TXBuilt 2022 · S/N 2881522N119DCDuque Helen · Orlando, FLS/N 17267722N119DDColeman Russell L · St Charles, ILBuilt 1952 · S/N D-3380N119DSDeltasierra LLC · Staunton, VABuilt 1979 · S/N 18503735N119EAce Aeromotive Inc · Miami, FLBuilt 1958 · S/N 24-532N119EDCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1948 · S/N D-1497N119EWBte Aviation LLC · Wilmington, DEBuilt 1981 · S/N E-1863N119GGYepes Hurtado Andres F · Lubbock, TXBuilt 1978 · S/N 28R-7931008N119GSDall James R Jr · Hayes, VABuilt 1985 · S/N 32R-8529009N119HPValiair Limited Company Trustee · Casper, WYBuilt 1966 · S/N 28-21570N119JBWagner Mathew J · Gary, SDBuilt 1958 · S/N D-5683N119JDUSA Wiltshire LLC · Pembroke Pines, FLBuilt 1969 · S/N 28-25406
Back to AD 98-21-21 R1