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.

N565RAN565ra LLC · Elbert, COBuilt 1977 · S/N 21062347N565SMMuller Scott B · Verbank, NYS/N 18267914N565UEsposito John A · Rye, NHBuilt 1963 · S/N 206-0065N565WWard Ann Marie · Seattle, WABuilt 1978 · S/N 15281812N5660BHarlow Brett · Pryor, OKBuilt 1956 · S/N 33660N5660GLawrence Corey R · Bourbon, MOBuilt 1969 · S/N 15071160N5660RSpirit Hills Ranch LLC · Belgrade, MTBuilt 1965 · S/N 17253292N5660TChoose You LLC · Twin Falls, IDS/N 17251560N5661BPiekarski John G · Kuna, IDBuilt 1956 · S/N 33661N5661TSingletary Kenneth W · Newman Lake, WAS/N 17251561N5662AMccafferty John · East Jordan, MIBuilt 1956 · S/N 28262N5662BHollibird Aviation LLC · Knightdale, NCBuilt 1956 · S/N 33662N5664ASale Reported · Spirit Lake, IDSale reportedBuilt 1956 · S/N 28264N5665JFarwest Aviation LLC · Billings, MTBuilt 1970 · S/N 18800615N5665RLimmer Rita G · Redding, CABuilt 1965 · S/N 17253299N5666ARonshausen Steven A · Circleville, OHBuilt 1956 · S/N 28266N5666B98x LLC · Caddo Mills, TXBuilt 1956 · S/N 33666N5666RSport Flying USA Inc · Ronkonkoma, NYBuilt 1965 · S/N 17253300N5667BMarmitt Management Inc · Moses Lake, WABuilt 1956 · S/N 33667N5667RBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1965 · S/N 17253302N5668TShattuck Shaun R Jr · Coarsegold, CABuilt 1964 · S/N 17251568N5669ABlanchette Charles · Payson, AZBuilt 1956 · S/N 28269N5669JWeber David A · Bryan, TXBuilt 1974 · S/N 18263486N5669RBeasley Marty J · Statesboro, GABuilt 1965 · S/N 17253304N5669TClemmons Gavin T · Hopkins, MNBuilt 1964 · S/N 17251569N566BGN566bg LLC · Leesburg, VABuilt 1979 · S/N 17272979N566GSPomeroy Cattle Ranch LLC · Kalispell, MTS/N 15071446N566HCThomas Charles Stephen Trustee · Lakeway, TXBuilt 1981 · S/N 18267810N566JCMurphy Janel L · Lake Lure, NCBuilt 1977 · S/N 18265541N566JWRoss Stephen D · Greenfield, OHBuilt 1962 · S/N 18254448N566QButte Aviation Inc · Butte, MTBuilt 1979 · S/N 17273553N566RMBueter Eric · Wauseon, OHBuilt 1977 · S/N 18265722N5670R&R Aircraft LLC · Chugiak, AKBuilt 1966 · S/N 18256905N5670BHart Deric C · Anchorage, AKBuilt 1956 · S/N 33670N5670JBank Of Utah Trustee · Salt Lake City, UTBuilt 1969 · S/N 18800620N5671AJarvis Peter S · Lebanon, CTBuilt 1956 · S/N 28271N5671BVaughn William · Charlotte, NCBuilt 1956 · S/N 33671N5672BToumala Scott R · Bemidji, MNBuilt 1956 · S/N 33672N5672GHarrold Adam T · New Waterford, OHBuilt 1969 · S/N 15071172N5674AStearns Edwin Ben Jr · Chandler, AZBuilt 1956 · S/N 28274N5674RSpellman Mark · Novi, MIBuilt 1965 · S/N 17253312N5674TPerma-Culture Inc · Dade City, FLBuilt 1964 · S/N 17251574N5675AMarch David H Trustee · Lincoln, CABuilt 1956 · S/N 28275N5675BMontgomery Richard G · Garden City, IDBuilt 1956 · S/N 33675N5675GGray Mark J · Muncie, INBuilt 1969 · S/N 15071175N5675RN5675r Corp · Rochester, NYBuilt 1965 · S/N 17253313N5675TPhillips Michael · Thompson Falls, MTBuilt 1964 · S/N 17251575N5676ALakes Area Aviation LLC · Little Falls, MNBuilt 1956 · S/N 28276N5676GSchmidt Gary L · Afton, MNS/N 15071176N5676JLunsford Group Inc · Asheville, NCBuilt 1974 · S/N 18263490
Back to AD 87-20-03 R2