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.

N8850GSchool Board Of Seminole County Florida · Sanford, FLS/N 15062950N8850SFlyers Park Farm LLC · Newark, OHBuilt 1965 · S/N 15062150N8850TAmalong Timothy M · Tucson, AZBuilt 1960 · S/N 52750N8850UA & H Renovation LLC · Woodstock, GABuilt 1976 · S/N 15078004N8850XBossola Raymond L · Suffolk, VABuilt 1961 · S/N 18253250N8851SChamseddine Ahmed A · Middletown, RIBuilt 1965 · S/N 15062151N8851UBaird Mark · Emeryville, CABuilt 1976 · S/N 15078005N8852BShuck Herbert K · Meadow Bridge, WVBuilt 1957 · S/N 36552N8852GAmis Jan E · Weeki Wachee, FLS/N 15062952N8853UDrakes Landing Inc · Archibald, LABuilt 1976 · S/N 15078006N8853XSnflk Leasing LLC · Andrews, TXBuilt 1961 · S/N 18253253N8854TMcgillivray Sean P · Grants Pass, ORBuilt 1960 · S/N 52754N8854XSuper Skylane LLC · Dewey, AZBuilt 1961 · S/N 18253254N8855GAldrich Curtiss R · Big Oak Flat, CABuilt 1966 · S/N 15062955N8855THolm Brian N · Buckley, WABuilt 1960 · S/N 52755N8855UBaginski D D · Salesville, OHBuilt 1976 · S/N 15078007N8856GMorris Charles K · Miami, FLBuilt 1966 · S/N 15062956N8856UKnutson Wayne R · Thompson, NDBuilt 1965 · S/N 17252770N8857BSafe Skies Aviation LLC · Middletown, OHBuilt 1957 · S/N 36557N8857GUp And Away LLC · Seymour, TNBuilt 1967 · S/N 18258100N8857XBlanton Robert D · Wichita, KSBuilt 1961 · S/N 18253257N8858BPiper Joseph C II · Walsenburg, COBuilt 1958 · S/N 36558N8858SDenney Andrew I IV · Las Cruces, NMFirst renewal noticeBuilt 1965 · S/N 15062158N8858TGranger Bryce W · Ravenna, OHBuilt 1960 · S/N 52758N8858UHolbrook Joel P · Delta Junction, AKBuilt 1965 · S/N 17252772N8858XGordon Jeffrey · Indianapolis, INS/N 18253258N8859BRandolph James C · Ridgecrest, CABuilt 1958 · S/N 36559N8859GBaker Jacob J · Nags Head, NCBuilt 1966 · S/N 15062959N8859TBooth Jesse R · Alamosa, COBuilt 1960 · S/N 52759N885CEOwens John · Camden Point, MOBuilt 1957 · S/N 32671N885CVOregon Air Partnership · Encino, CAS/N P337-0050N885DERoberts James A · Hamburg, ARBuilt 1966 · S/N 17253885N885QMMoore Timothy L · Wendell, IDS/N 34709N885WAMorcom Aviation Services Inc DBA · Everett, WAS/N 15280190N8860BStraight Tail Flyers LLC · Peoria, ILBuilt 1958 · S/N 36560N8860GBlack Spruce Aviation LLC · Hermon, MEBuilt 1966 · S/N 15062960N8860NBroussard Lewis A Jr · Morse, LABuilt 1948 · S/N 7232N8861GMiller Andy D · Marana, AZS/N 15062961N8861SJump Brian · Watsonville, CAS/N 15062161N8861UBlanchard Donald P Jr · Napoleonville, LABuilt 1965 · S/N 17252775N8862SBarber Theodore C Trustee · Spanish Fork, UTS/N 15062162N8862UChase Tim W · Kearney, MOBuilt 1965 · S/N 17252777N8863BMollere Michael E · Marion, TXS/N 36563N8863UBoatman Robert G · Great Falls, MTBuilt 1965 · S/N 17252778N8863XDupuis Logging Inc · Polson, MTBuilt 1961 · S/N 18253263N8864TRegistration Pending · Murdo, SDRegistration pendingBuilt 1960 · S/N 52764N8865BRegistration Pending · Wentzville, MORegistration pendingBuilt 1958 · S/N 36565N8865GChiquiza Gomez Juan Camilo · Fort Pierce, FLS/N 15062965N8865URegistration Pending · Parsons, KSRegistration pendingBuilt 1965 · S/N 17252780N8865XBeerman Paul L · Fort Wayne, INBuilt 1961 · S/N 18253265
Back to AD 87-20-03 R2