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.

N3363YCamlik Air LLC · Wausau, WIBuilt 1978 · S/N 21063145N3364DKtr Aviation LLC · Evans, COS/N 32162N3364EPlsr LLC · Denton, TXBuilt 1978 · S/N 17271519N3364FCrouch Jeffrey Lane Jr · Grimesland, NCBuilt 1966 · S/N 18257364N3364JSlawski Michael E · Tucson, AZBuilt 1967 · S/N 15066064N3364SAir Deeken Ltd · Doylestown, OHBuilt 1969 · S/N 21059164N3364THigh Mesa Aviation LLC · Naturita, COBuilt 1967 · S/N 17700664N3364UPalladino Frank · Castleton, NYBuilt 1963 · S/N 18254764N3364YSpeth Peter P · Peru, INBuilt 1962 · S/N 18254364N3365FTimlor Inc · Warrenton, ORBuilt 1966 · S/N 18257365N3365SWinger Cattle Co Inc · Johnson, KSBuilt 1969 · S/N 21059165N3366PLccc Enterprises Inc · Jupiter, FLBuilt 1966 · S/N 18257084N3366ST R Webster And Son Inc · Rexburg, IDBuilt 1969 · S/N 21059166N3366UAbraham Alan · Pilot Point, TXS/N 18254766N3366VMason Dave Q · San Marcos, CABuilt 1977 · S/N R1722251N3366YCrawford Stephen E · Corinth, TXS/N 18254366N3367RRegistered aircraftS/N 18502875N3367SSierra Co Llp · Wendell, IDBuilt 1973 · S/N 18502280N3367UKellogg David J · Marshall, MIS/N 18254767N3368FA&W Air LLC · Aiken, SCBuilt 1966 · S/N 18257368N3368RRegistered aircraftAssigned, pending cancellationS/N 18258668N3368SForbes Amanda M · Huachuca City, AZBuilt 1969 · S/N 21059168N3368TTuley Richard L · Marietta, GARegistration revokedBuilt 1967 · S/N 17700668N3368UZeigler Ryan C · The Dalles, ORBuilt 1963 · S/N 18254768N3369ERustmann Richard E · Willimantic, CTBuilt 1978 · S/N 17271520N3369FJ P Aero Holdings Inc · Carson City, NVS/N 18257369N3369RFenton Flyers Inc · Hillsboro, MOBuilt 1967 · S/N 18258669N3369SC-210 Lc · Atlantic, IABuilt 1969 · S/N 21059169N3369TBauer Charles · Graceville, MNS/N 17700669N336ADKropp Christian Trustee · Azle, TXBuilt 1963 · S/N 336-0054N336AFLaine Carey E · Nevada City, CABuilt 1972 · S/N 17260404N336BHAce Aviation LLC · Mankato, MNBuilt 1964 · S/N 3360125N336CFRobbins Warren N · Chandler, AZS/N 336-0174N336DDNewman Christopher J · Lorena, TXBuilt 1960 · S/N 47254N336FLLambright Jerry A · South Daytona, FLBuilt 1964 · S/N 336-0177N336GMGlasser Dean · Boswell, PAS/N R1722336N336JBBarney Julius C · Lutz, FLBuilt 1963 · S/N 336-0071N336JLErickson Paul · Okahumpka, FLS/N 336-0181N336JWMusgrove Jimmy Wayne · Delta Junction, AKBuilt 1964 · S/N 336-0189N336LBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 336-0117N336LVMarti Jorge · Miami, FLBuilt 1964 · S/N 336-0176N336RSAirspeed Marketing LLC · Phoenix, AZS/N 17252228N336TWPair Of Minutes LLC · Marshville, NCBuilt 1963 · S/N 336-0147N336VRVr Jet LLC · Goshen, INBuilt 1963 · S/N 336-0024N336W336 LLC · Eagle, IDBuilt 1963 · S/N 336-0156N3370SWittenborn Grant A · Olathe, KSBuilt 1973 · S/N 18502281N3370UBriannas Wings Of Passion Foundation Inc · Magalia, CABuilt 1963 · S/N 18254770N3370VHolladay Aviation LLC · Jacksonville, FLBuilt 1974 · S/N 15076477N3370YBrink Brittnie L · Baldwin, WIBuilt 1962 · S/N 18254370N3371EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271521
Back to AD 87-20-03 R2