OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N4057YWalther Newell A · Wasilla, AKBuilt 1961 · S/N 185-0257N40583Grald Jonathan A · New Hampton, NYS/N 15065358N4058DKenley Douglas T · Palmer, AKBuilt 1957 · S/N 34758N4059FDoss Lonny Richard · Lake Charles, LABuilt 1958 · S/N 36959N405DTSkiles Carl A · Leander, TXS/N 17702389N405JHTss Flying Club Inc · Bethesda, MDBuilt 1981 · S/N R18201790N405JMGibson William · Aberdeen, MSS/N 17251766N405MWWarin Michael R · Pella, IABuilt 1963 · S/N 17250433N405NRGasper Daniel C · Tacoma, WABuilt 1963 · S/N 185-0252N4060GCm3 LLC · North Las Vegas, NVS/N 17264771N4060JDooley Bob A · Alexander, ARFirst renewal noticeBuilt 1966 · S/N 15065360N4061DDavis Russell C · Bakersfield, CABuilt 1958 · S/N 34761N4061FHuston Aviation LLC · Fort Worth, TXBuilt 1958 · S/N 36961N4061JConley Rocky · Swanton, OHS/N 15065361N4061UShreve Gary L · Midlothian, TXBuilt 1965 · S/N 15061461N4061YRegistered aircraftBuilt 1961 · S/N 1850261N4062DJohnson Gunnar W · Unalakleet, AKBuilt 1958 · S/N 34762N4062FCharlotte Air Services · Charlotte, MIBuilt 1958 · S/N 36962N4063DRicheson Rodney Scott · Moses Lake, WABuilt 1957 · S/N 34763N4063FHand Tod E · Copper Center, AKBuilt 1958 · S/N 36963N4063JPoules Alexander · Hope Valley, RIBuilt 1966 · S/N 15065363N4063UHangar 22 Flying Club · Siren, WIBuilt 1965 · S/N 15061463N4063VInternational Air Services Inc Trustee · Carson City, NVBuilt 1948 · S/N 18395N4064VCapouch Rosemary E · Medaryville, INBuilt 1948 · S/N 18396N4065VStiletto Beaver Touchdown LLC · Evanston, ILBuilt 1975 · S/N 15076689N4066FGray Chet K · Midland, TXBuilt 1958 · S/N 36966N4066VWeis Patrick A · Cornelius, ORBuilt 1948 · S/N 18398N4067DBlackwood William C · Irvington, ALBuilt 1958 · S/N 34767N4067JSkyway Inc · Wilmington, DEBuilt 1966 · S/N 15065367N4067VBas Part Sales LLC · Greeley, COBuilt 1948 · S/N 18399N4068JSutton Thomas A · Gaylord, MIBuilt 1966 · S/N 15065368N4068YPatkotak Hugh G · Anchorage, AKBuilt 1962 · S/N 1850268N4069FDmac Aircraft LLC · Savannah, GABuilt 1958 · S/N 36969N4069JFdp Productions LLC · Atlanta, GABuilt 1966 · S/N 15065369N4069UPch Transportation LLC · Monterey, CABuilt 1965 · S/N 15061469N406AHInternational Air Services Inc Trustee · Carson City, NVBuilt 1962 · S/N 185-0442N406BNClover Crest II Inc · Key Largo, FLBuilt 1959 · S/N 56122N406DPWings & Blades LLC · Columbia Falls, MTS/N 18051805N406GGCedar Creek Corp · Red Bluff, CABuilt 1967 · S/N 185-1154N406NWJohnson Aeronautics LLC · Billings, MTBuilt 1981 · S/N 18504244N406PTMurray John J · Kalispell, MTBuilt 1981 · S/N 172RG0801N406WMMcelvain Michael R · Billings, MTBuilt 1958 · S/N 51589N407Lyford Charles A IV · Bellevue, WABuilt 1976 · S/N P3370251N4070JClark Philip M · Caldwell, OHBuilt 1966 · S/N 15065370N4070VWomack Jimmy R · Webb, ALBuilt 1948 · S/N 18402N4071DNew Richard A · Deming, WABuilt 1958 · S/N 34771N4071FQuebedeaux Steven R · Sunset, LABuilt 1958 · S/N 36971N4071JMilhous Walter L · Carmichael, CABuilt 1966 · S/N 15065371N4072VHauenstein Edgar D · Holden, MOBuilt 1948 · S/N 18404N4072YCompton Douglas C · Heron, MTBuilt 1961 · S/N 185-0272
Back to AD 87-20-03 R2