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.

N367CRRay Samuel · Spring Hill, TNS/N R18201875N367TJFlorida Aerial Services Inc · Lutz, FLBuilt 1975 · S/N 18263721N3680CBindon Phil E · Wasilla, AKFirst renewal noticeBuilt 1954 · S/N 31179N3680SLubonovic Thomas M · New Carlisle, OHBuilt 1963 · S/N 17250880N3680VAdams James W · Sioux Falls, SDBuilt 1975 · S/N 15076586N3681JPence Northwest Aviation LLC · Salem, ORBuilt 1966 · S/N 15064981N3681LBurton Walter E · Statesboro, GABuilt 1965 · S/N 17253850N3681YJeff Blue Corp · Seminole, FLS/N 21058181N3682CKiger Lance B · Prairieville, LAS/N 31181N3682LRiseaero LLC · Florence, SCBuilt 1965 · S/N 17253851N3682SPederstuen Ricky L · Hudson, WIBuilt 1963 · S/N 17250882N3683JGuess Clayton L · Bushnell, FLBuilt 1966 · S/N 15064983N3683VMcflight Aviation LLC · Highland, UTBuilt 1975 · S/N 15076588N3684CFly Away Aviation LLC · Folsom, LABuilt 1978 · S/N R18200307N3684UToews Berton J · Casper, WYBuilt 1963 · S/N 18255084N3685JBranson David F · Tucson, AZBuilt 1966 · S/N 15064985N3685LBarber Richard S · Baker, NVBuilt 1965 · S/N 17253854N3685SGarrison Randy L · Queen City, TXBuilt 1963 · S/N 17250885N3685YWhite Lawrence L III · La Habra, CABuilt 1963 · S/N 21058185N3686CSedwick William R · Anchorage, AKBuilt 1954 · S/N 31185N3686JSeasun Aviation LLC · Miami, FLS/N 15064986N3686SBurg David J · Oroville, CABuilt 1963 · S/N 17250886N3686UEnvi Adventures LLC · Troutdale, ORBuilt 1963 · S/N 18255086N3686YEllis Air LLC · Acworth, GAS/N 21058186N3687JPacific Northwest Aeronautics Inc · Lewes, DENon-citizen corporation, flight hours not reportedS/N 15064987N3688CDiedrich Steve A · Sandpoint, IDBuilt 1954 · S/N 31187N3688LNamassivaya Nagaraju · Rexford, NYBuilt 1965 · S/N 17253857N3688UTaylor Aviation Inc · Fort Benton, MTBuilt 1963 · S/N 18255088N3688YHarris Beth · Albuquerque, NMS/N 21058188N3689CR D Management LLC · Central City, NEBuilt 1978 · S/N R18200309N3689JInnovative Restoration Aviation LLC · Slidell, LAS/N 15064989N3689VChvatal Daniel A · Jordan, MNBuilt 1975 · S/N 15076592N368ABStryker Kevin · Ben Wheeler, TXBuilt 1968 · S/N 15069023N368BCAugustina Holdings LLC · Argyle, TXS/N 182-68517N368CPWilliams Truman V · Robbinsville, NCBuilt 1980 · S/N R18201580N3690JMcvay Joshua J · Longmont, COS/N 15064990N3690LSmith Steve J · Magnolia, TXBuilt 1965 · S/N 17253859N3691JS & S Aircraft LLC · Rathdrum, IDBuilt 1966 · S/N 15064991N3691SBogan Jeremy · Rusk, TXS/N 17250891N3691YHunt Lynn C Trustee · Windsor, CAS/N 21058191N3692CDevil Dusters Inc · Artesia, NMS/N 31191N3692SBrown Wesley B · Sparks, NVBuilt 1963 · S/N 17250892N3692UPineview Ac Sales LLC · Bedford, WYBuilt 1963 · S/N 18255092N3693SChianese Anthony · Wylie, TXBuilt 1963 · S/N 17250893N3694SJstream Lc · Sheridan, WYBuilt 1963 · S/N 17250894N3694UPara Tactics LLC · Shelton, WAFirst renewal noticeBuilt 1963 · S/N 18255094N3694YScott Dale D · Alliance, OHBuilt 1963 · S/N 21058194N3695COrton Dennis · Mead, COBuilt 1978 · S/N R18200312N3695SZavada Michael S · Morris, MNBuilt 1963 · S/N 17250895N3695YAffordable Aviation Corp · Moriches, NYBuilt 1963 · S/N 21058195
Back to AD 87-20-03 R2