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.

N23757Walinchus Robert E · Pooler, GAS/N CE-731N2375CEverwind Aviation LLC · Kalispell, MTBuilt 1978 · S/N R18200167N2375DGauntt Chep · Goodyear, AZBuilt 1952 · S/N 20527N2375MValentine Ronald F Jr · Santa Maria, CABuilt 1977 · S/N 28-7816280N2375SLundin Lawrence D · Midvale, IDBuilt 1976 · S/N 21061257N2375XBaldwin Todd K · Prescott Valley, AZBuilt 1965 · S/N 18256275N2376GN2376g LLC · Helena, MTBuilt 1958 · S/N 51676N2376TStranberg Ray L · Bakersfield, CAS/N 28-7225057N2376UHowell Rebecca Elizabeth · Elgin, TXBuilt 1962 · S/N 17249976N2377EBeck Roger M Trustee · Goode, VABuilt 1978 · S/N 17271256N2377FBuoni Frank · Bakersfield, CABuilt 1965 · S/N 21058577N2377GLutz Matthew S · Lewistown, MTBuilt 1958 · S/N 51677N2377UCardinal Flight Systems LLC · Cary, NCBuilt 1979 · S/N 28-8016021N2377XBieker Tor M · Hood River, ORBuilt 1965 · S/N 18256277N2377ZMatthews Grover C · Hardinsburg, KYBuilt 1979 · S/N 27-7954116N2378CHovda H O · Progreso, TXBuilt 1953 · S/N 30678N2378GStramel Matthew J · Elko, NVBuilt 1958 · S/N 51678N2378TKeiffer Taylor H · Atlanta, GABuilt 1971 · S/N 28-7225059N2378UInternational Flight Academy LLC · Ft Worth, TXBuilt 1979 · S/N 28-8016022N2379CWest Country Aviation Inc Trustee · Wilmington, DEBuilt 1978 · S/N R18200170N2379DMoore Orville G · Hays, KSBuilt 1952 · S/N 20531N2379RLanzetta Kenneth · Oakland Park, FLBuilt 1979 · S/N 18266988N2379UAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1962 · S/N 17249979N2379XK Fortner LLC · San Marcos, TXS/N 18256279N237CSHorizon Flyers LLC · Kingsford, MIBuilt 1968 · S/N 28-24230N237CTSkymax LLC · Stanford, KYBuilt 1968 · S/N 18258819N237DCHinkle Airspray Inc · Cavalier, NDBuilt 1978 · S/N TJ-133N237DTBurque Sean Michael · New Braunfels, TXBuilt 1962 · S/N 17249862N237DWTheis Industrial Leasing Inc · Spivey, KSS/N 35506N237FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 1989 · S/N 2842015N237KBHenke Aircraft Holdings LLC · Dayton, TXBuilt 1978 · S/N 78-31144N237MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881815N237MTPiper Aircraft Inc · Vero Beach, FLS/N 4496660N237SColey Douglas E · Mchenry, ILBuilt 1965 · S/N D-7841N237TDBodily Lorin D · Brigham City, UTS/N TD237N2380DKovalchik Janet N Trustee · Kernersville, NCBuilt 1952 · S/N 20532N2380MPiggott William H · Madison, CTBuilt 1977 · S/N 28-7890249N2380RReep Nicolas K · Yakima, WABuilt 1964 · S/N 18255480N2380TRegistered aircraftS/N 28-7225060N2380XGaller Mary D Trustee · Elysian, MNBuilt 1965 · S/N 18256280N2380ZCopeland Medical LLC · Jonesboro, ARBuilt 1979 · S/N 27-8054031N2381CLee Kevin M · Rexburg, IDBuilt 1954 · S/N 30681N2381DShryock Jennifer M · King Salmon, AKS/N 20533N2381FOops LLC · Cheyenne, WYBuilt 1965 · S/N 21058581N2381GKittelman Thomas L · Gilbert, AZS/N 51681N2381XCooper Scott J · Fellows, CABuilt 1965 · S/N 18256281N23822Platt James Wesley · Bushnell, FLBuilt 1977 · S/N E-1089N2382GGish Joseph B · Lewiston, IDFirst renewal noticeBuilt 1958 · S/N 51682N2382TGethers Adolph B · Dothan, ALBuilt 1971 · S/N 28-7205031N2382UMrnm LLC · Albia, IABuilt 1963 · S/N 17249982
Back to AD 98-21-21 R1