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.

N2571GGolf Air LLC · Anchorage, AKBuilt 1959 · S/N 51871N2571JWullner Leeroy J · Cedar Rapids, IABuilt 1964 · S/N 15061071N2571LClements Jim L · Cushing, OKBuilt 1967 · S/N 17255771N25722Mitchell Brian J · Boise, IDBuilt 1963 · S/N 18051274N2572GMorgan Nathan · Boise, IDBuilt 1959 · S/N 51872N2572LBuick Robin B · Redding, CABuilt 1973 · S/N A1500485N2572RMladejovsky Michael G Trustee · Paulden, AZBuilt 1967 · S/N 18258272N2572SGwin Bryan · La Porte, TXBuilt 1976 · S/N 21061332N2572VJarvis Michael Lynn · Orem, UTBuilt 1974 · S/N 177RG0620N2572XC S Enterprises Llp · Morristown, TNBuilt 1965 · S/N P206-0072N2573KDonham Sonjia F · Portland, ORBuilt 1978 · S/N 18052995N2573QJayviation Inc · Lake City, FLBuilt 1969 · S/N 21059173N2573VOldfield Raymond M Jr · Waupaca, WIBuilt 1974 · S/N 177RG0621N2573XSkd LLC · Spokane, WABuilt 1965 · S/N P206-0073N2573YFritz David C · Lincoln, NEBuilt 1960 · S/N 17247906N2574DDumm Wesley J · Kodiak, AKBuilt 1952 · S/N 20726N2574RChauvin Junius · Franklin, LAS/N 18258274N2574Y9th Moon Enterprises LLC · Alpine, TXS/N 17249874N25754Jet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15280767N2575DBurgess William S · Anchorage, AKBuilt 1952 · S/N 20727N2575GAltes Matt · Mount Shasta, CABuilt 1959 · S/N 51875N2575JStein Gerald A · Tolar, TXBuilt 1965 · S/N 15061075N2575KSchlick David L · Poulsbo, WABuilt 1978 · S/N 18052997N2575SDulin Morgan L · Midland, TXBuilt 1968 · S/N 337-0875N2575VStone Tommy R · Jacksonville Beach, FLBuilt 1974 · S/N 177RG0622N2575X360 Solo LLC · San Martin, CABuilt 1965 · S/N P206-0075N2575YSky Unlimited · Portland, ORBuilt 1962 · S/N 17249875N2576CFlying R LLC · Fruitdale, SDBuilt 1954 · S/N 26220N2576DMarshall Jerry J · Parker, AZBuilt 1952 · S/N 20728N2576LRiggin Flight Service Inc · Madison, SDS/N 17255776N2576QHamilton Steve · Carson City, NVBuilt 1966 · S/N 18257776N2576YRowe John W · Glen Haven, COBuilt 1962 · S/N 17249876N25772Arnold Jonathan L · Warrensburg, MOBuilt 1977 · S/N 15280774N25773Solberg Avn Co Inc · Whitehouse Station, NJBuilt 1977 · S/N 15280775N25775Van Es Mark E · Laredo, TXBuilt 1977 · S/N 15280777N25779Eads James · Saginaw, TXBuilt 1977 · S/N 15280780N2577JDelaney John T · Bangor, PABuilt 1964 · S/N 15061077N2577LKim L Jensen · Enoch, UTBuilt 1967 · S/N 17255777N2577QSlingsby J Geoffrey · Rapid City, SDBuilt 1977 · S/N 18503520N2577RSchomaker Michael J · Pleasanton, CABuilt 1967 · S/N 18258277N2577SHurt Randall L · Smithville, TNBuilt 1968 · S/N 337-0877N2577ZMaynard Christopher J · Anchorage, AKBuilt 1964 · S/N 185-0577N25785Iggy Enterprises LLC · Gig Harbor, WABuilt 1977 · S/N 15280783N2578CPayne Megan T · Anchorage, AKFirst renewal noticeBuilt 1954 · S/N 26222N2578DKnuths Kristian Jacob · North Pole, AKBuilt 1952 · S/N 20730N2578JRenewed Inc · Tekamah, NEBuilt 1964 · S/N 15061078N2578YBush James W · Skaneateles, NYBuilt 1962 · S/N 17249878N2579GMcglachlin Brandon E · Moundridge, KSBuilt 1959 · S/N 51879N2579JMaatje Charles J · Egg Harbor City, NJBuilt 1964 · S/N 15061079N2579KSkywagon LLC · Sterling, AKBuilt 1978 · S/N 18053000
Back to AD 87-20-03 R2