OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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.

N6677EEmery Edward L · Marysville, WABuilt 1959 · S/N 56177N6677HPeterson Robert E · Richland, WABuilt 1975 · S/N 17265533N6677RTre Aviation Corp · Wilmington, DES/N 21059654N6677TStewart Greg Lee · Bottineau, NDS/N 15059077N6677XMuhlenbrock Guillermo Rene Jr · Las Vegas, NVS/N 21057677N66780Keenan Jim F · Neenah, WIBuilt 1974 · S/N 15076273N66781Strong Mack A · Coral Springs, FLS/N 15076274N66785Destefano Patrick S · Bryan, TXBuilt 1974 · S/N 15076278N66786Gibb Bryce M · Portland, TXBuilt 1974 · S/N 15076279N6678XKinman Kary Wade · Panama City Beach, FLBuilt 1961 · S/N 21057678N66790Logan Dan P · Gilliam, LABuilt 1974 · S/N 15076283N6679SCampos Katherine · Tallahassee, FLBuilt 1967 · S/N 15067479N667ARRegistered aircraftBuilt 1977 · S/N 18265379N667BCWithrotor Aviation Inc · Lakeview, ORBuilt 1979 · S/N 18503849N667PBButzin Paxton E · Wild Rose, WIBuilt 1951 · S/N 20116N667WBMcleod Patrick J · Overgaard, AZBuilt 1967 · S/N 18258563N6680BBush Douglas B · Santa Rosa Beach, FLBuilt 1978 · S/N 21062818N6680EPrax Philip · Fairbanks, AKBuilt 1959 · S/N 56180N6680MMcshane Shannon K · Alamo Heights, TXBuilt 1975 · S/N 18263796N6680TParsons Joshua A · Hollis Center, MEBuilt 1960 · S/N 15059080N6681ACarignan Armand R · Hooksett, NHBuilt 1956 · S/N 28781N6681EFoisy Douglas · Burleson, TXBuilt 1959 · S/N 56181N6681GMoore Joseph L · Hesperus, COS/N 15072181N6682XDuff John W · Alligator, MSBuilt 1960 · S/N 21057682N6683EBergeson John S · Rhome, TXS/N 56183N6683GPardee Gary D · Buckley, WABuilt 1970 · S/N 15072183N6683SWingsofdawn LLC · East Greenwich, RIBuilt 1967 · S/N 15067483N6683THecker Darin S · Grants Pass, ORBuilt 1960 · S/N 15059083N6684ASchumacher Leroy H · Beach City, OHBuilt 1956 · S/N 28784N6684ERound Engine Aero · Nashville, MIS/N 56184N6684GReeder Brenton Lamar · Beacon, NYBuilt 1970 · S/N 15072184N6684MMlynarczyk Stanley · Darien, ILBuilt 1975 · S/N 18263798N6684TButzen Steve B · Sheboygan, WIBuilt 1960 · S/N 15059084N6685XTaliaferro John P · Birmingham, ALBuilt 1961 · S/N 21057685N6686NClarity Aviation LLC · Anchorage, AKBuilt 1978 · S/N 21063146N6687EDriggers David J · Anchor Point, AKBuilt 1959 · S/N 56187N6687FBlakesley Eric R · Canandaigua, NYS/N 15063287N6687SSale Reported · Houston, AKSale reportedBuilt 1967 · S/N 15067487N6687XReed Ted R · San Angelo, TXBuilt 1961 · S/N 21057687N6688APouncey Robert · Proctor, ARS/N 28788N6688HSamaritans Purse · Boone, NCS/N 18503335N6688NLedson Steven Noble · Sonoma, CAS/N 21063148N6688TSelfridge Dennis A · Dighton, KSBuilt 1960 · S/N 15059088N6689AMaley Christopher L · Otsego, MIBuilt 1956 · S/N 28789N6689EHeizler Mark W · Oswego, ILBuilt 1959 · S/N 56189N6689FMills Nicolas A · Greenwood, NYBuilt 1966 · S/N 15063289N6689SSimpson Dwight D · Phillips, WIBuilt 1967 · S/N 15067489N6689TFlying Restorations LLC · Holts Summit, MOBuilt 1960 · S/N 15059089N6689XBravo Echo Echo LLC · Millersview, TXS/N 21057689N668DB686 Aviation LLC · Lakewood, COBuilt 1975 · S/N 21061003
Back to AD 87-20-03 R2