OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N2773DHattaway Gene · Double Oak, TXBuilt 1952 · S/N 25315N2773FAdriatic Holdings LLC · Cheyenne, WYBuilt 1966 · S/N 18256873N2773JN2773j LLC · Titusville, FLBuilt 1975 · S/N A1500596N2773VBeale Air Force Base Aero Club · Beale Afb, CABuilt 1975 · S/N 177RG0694N2773XLee Ty K · Anchorage, AKBuilt 1965 · S/N 18051573N2774DOutbound Aero LLC · Kiowa, COBuilt 1952 · S/N 25316N2774JPerez Guillermo · Castaic, CABuilt 1979 · S/N 17273649N2774QRdj Brothers Trucking Inc · Bigfork, MTBuilt 1967 · S/N 18257974N2774SPeterson Dennis · Cambridge, MNBuilt 1967 · S/N 15066674N2774XElk Creek Investments LLC · Helena, MTBuilt 1965 · S/N 18051574N2775EFaulkner Harry E Jr · Bethel, AKBuilt 1978 · S/N 17271316N2775FJock Carl A Trustee · Roscommon, MIBuilt 1966 · S/N 18256875N2775LKing Mons A · Paoli, PABuilt 1967 · S/N 17255975N2775QRay Chris J · Ironside, ORBuilt 1967 · S/N 18257975N2775RMiller David · Tyler, TXBuilt 1980 · S/N 172RG0624N2775SRichardson Arthur · Herald, CAS/N 15066675N2775ULuff John W · Odessa, MOBuilt 1963 · S/N 17250375N2776DAtiyeh Aziz Matthew · Aumsville, ORS/N 25318N2776EAugusta Flying Club Inc · Martinez, GABuilt 1978 · S/N 17271317N2776FBabovic Slobodan · Elm Grove, WIS/N 18256876N2776GOliver Charles D · Saint Albans, WVBuilt 1959 · S/N 52076N2776JMission Aviation Fellowship · Nampa, IDS/N 185-1526N2776LRd Aire LLC · Opelika, ALBuilt 1967 · S/N 17255976N2776UGarrison Randy · Queen City, TXBuilt 1963 · S/N 17250376N2776XSmith James A III · Millerton, NYBuilt 1965 · S/N 18051576N2777ETop Flight Aviation Inc · Corona, CABuilt 1974 · S/N 17262885N2777GPacheco Randy L · Pacific Grove, CABuilt 1959 · S/N 52077N2777JFirst Flight LLC · Craig, AKBuilt 1969 · S/N 185-1527N2777LHataway Gregory L · Kinston, ALBuilt 1967 · S/N 17255977N2777TAviator Air Flight School LLC · Grand Prairie, TXBuilt 1972 · S/N 17261147N2777XKruskie Douglas · Petoskey, MIS/N 18051577N2778DBaker Julius W · Anchorage, AKBuilt 1952 · S/N 25320N2778FHuber George M · Bentonville, ARBuilt 1966 · S/N 18256878N2778JWilfer Dennis M · Fairbanks, AKBuilt 1969 · S/N 185-1528N2778SStamper Brian L · Tucson, AZBuilt 1967 · S/N 15066678N2778URoberts Kenneth B · Wall Township, NJBuilt 1963 · S/N 17250378N2779DLumley Carol J · Eagle River, WIBuilt 1952 · S/N 25321N2779FSweatt D Wayne · Memphis, TXBuilt 1966 · S/N 18256879N2779LResetar Douglas J · Pittsford, NYBuilt 1967 · S/N 17255979N277CBN277cb LLC · Jacksonville, FLBuilt 1976 · S/N 17267516N277JKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1968 · S/N 18259292N277KLCoombs Johnnie · Blue Mountain, MSBuilt 1966 · S/N 15064869N277NWindh Randall · Reedley, CAS/N 28440N277RTGonzalez Edwin A · Scott Afb, ILBuilt 1968 · S/N 15070021N277SLCharlies Wings LLC · Salisbury, NCBuilt 1973 · S/N 17261652N277TMPollock Donald Edward · Union Hall, VABuilt 1976 · S/N 18264391N27808St George Flight Academy LLC · St George, UTBuilt 1971 · S/N 17260023N2780CWheeler Russell E · Roxbury, CTBuilt 1954 · S/N 26324N2780DChythlook Joseph L · Dillingham, AKS/N 25322N2780GHolden Christa · Rougemont, NCBuilt 1958 · S/N 52080
Back to AD 87-20-03 R2