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.

N2579SMenagh Bret J · Fresno, CABuilt 1968 · S/N 337-0879N2579UHann Aviation LLC · Yuma, AZBuilt 1963 · S/N 17250179N257FK257fk LLC · Marathon, FLBuilt 1977 · S/N 17269126N257JSDelaurentis Robert · San Diego, CABuilt 1978 · S/N 18266090N257LMSsb Aviation LLC · Wasilla, AKBuilt 1975 · S/N 18052548N257RRegistered aircraftBuilt 1957 · S/N 34411N257RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266240N257SPAviatzone LLC · Fort Lauderdale, FLBuilt 1977 · S/N 20700781N25807Peabody Jeffery L · Vinemont, ALBuilt 1977 · S/N 15280793N2580DPlace Ashley K · Bradenton, FLBuilt 1952 · S/N 20732N2580GLei Puahi Inc · Klamath Falls, ORBuilt 1959 · S/N 51880N2580JKingdom Air Corps · Sutton, AKBuilt 1964 · S/N 15061080N2580SArizona Production Machinery & Supply · Casa Grande, AZBuilt 1976 · S/N 21061333N2581CClepper Catherine M · Saegertown, PABuilt 1954 · S/N 26225N2581DMccullugh Jordon T · Idaho Falls, IDBuilt 1952 · S/N 20733N2581JStikeleather Fred A · Hiddenite, NCS/N 15061081N2581KYsc Inc · Harvard, MABuilt 1978 · S/N 18053002N2581VMink Stephen Earl · Walnut Creek, CABuilt 1974 · S/N 177RG0625N2581YOverman Aviation LLC · Saint Louis, MOS/N 17249881N25820Sale Reported · Xxx, OKSale reportedBuilt 1977 · S/N 15280799N2582DFriesen Gary J · Mariposa, CABuilt 1952 · S/N 20734N2582KSherman David B · Readfield, MEBuilt 1978 · S/N 18053003N2582LRichardson Michael Todd · Wilkesboro, NCS/N 17255782N2582Q82q LLC · Glenwood, MDS/N 18257782N2582RBergmann Robert A · Lake Placid, FLBuilt 1967 · S/N 18258282N2582VThul Nathan Michael Trustee · Centralia, IABuilt 1948 · S/N 18087N25836Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280808N2583CWarner Mitchel K · Kodiak, AKS/N 26227N2583GN2583g LLC · Madison, KSBuilt 1959 · S/N 51883N2583JLauff Samuel Jr · Ocala, FLBuilt 1964 · S/N 15061083N2583LMontgomery Robert A · Hampstead, NCBuilt 1967 · S/N 17255783N2583RHigh Range Aviation Inc · Gooding, IDBuilt 1967 · S/N 18258283N2583SMackowiak Michael · Haines, AKBuilt 1973 · S/N 18502250N2583UUfly Vi LLC · St Thomas, VIBuilt 1963 · S/N 17250183N2583XN2583x LLC · Oklahoma City, OKBuilt 1965 · S/N P206-0083N2584CMoreman Wiley E · Willcox, AZBuilt 1954 · S/N 26228N2584JVolar LLC · Forest, MSBuilt 1965 · S/N 15061084N2584KEichorn Russell A · Grand Rapids, MNBuilt 1978 · S/N 18053005N2584URedd David C · Blanding, UTBuilt 1963 · S/N 17250184N25852Griffith Aviation Inc · Griffith, INBuilt 1977 · S/N 15280817N25855Williams Stephen W · Granbury, TXBuilt 1977 · S/N 15280820N2585CGillum Colton M · Ontario, ORBuilt 1954 · S/N 26229N2585GWilkinson Benjamin M · Anchorage, AKS/N 51885N2585LAerospace Quality LLC · Piggott, ARS/N 17255785N2585RChristie Bruce W · Wasilla, AKBuilt 1967 · S/N 18258285N2585ULionudakis Michael A · Scotts Valley, CABuilt 1963 · S/N 17250185N25860Sorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 15280825N2586JHenegar Nathanie L · Owasso, OKFirst renewal noticeBuilt 1964 · S/N 15061086N2586LRuiz Edinson · Bakersfield, CABuilt 1967 · S/N 17255786N2586QErrington Aero LLC · Bellefontaine, OHBuilt 1966 · S/N 18257786
Back to AD 87-20-03 R2