OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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.

N7638MHerbert-Johnson Veronica L · Picayune, MSS/N 55938N7638TEaglet Flight Operations Lp · Fort Worth, TXBuilt 1960 · S/N 47238N7638XBreaux Matthew J · Grosse Tete, LAS/N 17248138N7639TCaldwell Perrin L · Batesville, MSBuilt 1960 · S/N 47239N763PAComputer Services Inc · Yukon, OKBuilt 1974 · S/N 15075618N763RDDrennan Ronald W · Edmond, OKBuilt 1969 · S/N 18259979N763SASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15283073N763TCN42 Hy LLC · Kalispell, MTBuilt 1966 · S/N T210-0113N764Usda Forest Servic Fepp · Columbia, SCBuilt 1975 · S/N U20602672N7640GCreative Strategies Inc · Proctorville, OHBuilt 1970 · S/N 17259340N7640TAloway Shaquetta S · Cleveland, OHS/N 47240N7640XNotre Amour LLC · Cypress, TXBuilt 1960 · S/N 17248140N7641MCrawford Trevor Nicolas · Potter Valley, CABuilt 1959 · S/N 55941N7641XEngelhardt David J · Williamsburg, OHBuilt 1960 · S/N 17248141N7642GAir Petunia · Claremont, CABuilt 1970 · S/N 17259342N7642KJobe Alexander Joseph · Asotin, WABuilt 1976 · S/N 18052694N7642TLuthi Mark P · Rome, GABuilt 1960 · S/N 47242N7642XGrey Eagle Aviation LLC · Walker, MNBuilt 1960 · S/N 17248142N7643GTriad Aviation Academy LLC · Greensboro, NCBuilt 1970 · S/N 17259343N7643TGarcia Yonhara Fortun Faedo · Norco, CABuilt 1960 · S/N 47243N7643XBrackman Aviation LLC · Twin Falls, IDBuilt 1960 · S/N 17248143N7644GSkypark Inc · Wadsworth, OHBuilt 1970 · S/N 17259344N7645MKennedy Eric S · Utica, OHBuilt 1959 · S/N 55945N7645VBig Sky Aviation Leasing LLC · Helena, MTBuilt 1976 · S/N 177RG0899N7646ASommer Charles D · Twin Falls, IDBuilt 1956 · S/N 32543N7646GSky Aviation LLC · Encinitas, CABuilt 1970 · S/N 17259346N7646XGeorge James D · Aurora, INS/N 17248146N7647GIowa Lakes Community College · Estherville, IAS/N 17259347N7647MHeithold Burdett D · South Sioux City, NES/N 55947N7647THolmen Roger A · Carlsbad, NMS/N 47247N7648AFrance Jane M · Cheyenne, WYBuilt 1956 · S/N 32545N7648TAppel Jacob · Redfield, SDS/N 47248N7649GSipes Aircraft LLC · Livingston, TXS/N 15074710N7649TScott Steve W · Antioch, CAS/N 47249N7649URey Henry R · Fresh Meadows, NYBuilt 1975 · S/N 15077775N764AAWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265624N764BKFairmont State University · Fairmont, WVBuilt 1976 · S/N 17266891N764CPApmg Aircraft Management LLC · Las Vegas, NVBuilt 1965 · S/N 15061758N764MSNielsen Daniel P · Grand Rapids, MNS/N 52132N764RBReo & Bpo LLC · Lewes, DEBuilt 1982 · S/N 21064674N764SAerotrans Management LLC · Mercer Island, WABuilt 1979 · S/N U20604957N7651AMonson Conrad J · Wasilla, AKBuilt 1956 · S/N 32548N7651XHappy Landings Aviation LLC · Maple, NCS/N 17248151N7652AWilliams Jerry B · Vashon, WABuilt 1956 · S/N 32549N7652MHenderson Aviation LLC · Norman, OKBuilt 1959 · S/N 55952N7654KLuginbuel Stacy W · Prairie Grove, ARBuilt 1976 · S/N 18052695N7654LLarsen Daniel R · Kenai, AKBuilt 1963 · S/N 18051240N7654VRene Ronald M · Linden, NCBuilt 1977 · S/N R1722312N7655TMorrell Nathaniel A · Pelham, GABuilt 1960 · S/N 47255N7655USitta Donald C · Farmington, NMBuilt 1976 · S/N 15077781
Back to AD 87-20-03 R2