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.

N5736TSparks Fly LLC · Mount Gilead, OHS/N 17251636N5737JSkolnik Adam R · Clermont, FLBuilt 1974 · S/N 18263506N5737RRegistration Pending · Chatham, NYRegistration pendingBuilt 1965 · S/N 17253406N5738CRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1950 · S/N 19692N5738RKury Ernest A · Centerville, IABuilt 1965 · S/N 17253407N5739ADaystar Ltd · Ellsworth, KSS/N 28339N5739CHellie Andrew B · College Place, WABuilt 1950 · S/N 19693N573JCCoffey John L · Iron River, WIS/N 18502396N573JFHuddleston Edward L · Oaktown, INBuilt 1973 · S/N 18052398N5740BPash Olin M · Harlan, IABuilt 1956 · S/N 33740N5740GAdventist World Aviation · Wilson, NCBuilt 1969 · S/N 15071240N5740JStonestreet Arlie D Trustee · Pratt, KSBuilt 1974 · S/N 18263509N5741BCansino Ross G · George West, TXBuilt 1956 · S/N 33741N5741RJungman Jensen David A · Adel, IAS/N 17253410N5742ADirt Devil Aviation LLC · Bowdon Junction, GAS/N 28342N5742TSkyhawkfive LLC · Claremont, NHS/N 17251642N5743JMidwest Aerial Photography · Galloway, OHBuilt 1970 · S/N P20600643N5743TRay Aviation LLC · Burkett, TXBuilt 1964 · S/N 17251643N5744BMcgrew Robert P III · Red Bluff, CABuilt 1956 · S/N 33744N5744RBrown Dallin N · Scipio, UTS/N 17253413N5744TMorris Charles E · Ft Worth, TXBuilt 1964 · S/N 17251644N5745CShriver Michael C · Caledonia, ILBuilt 1950 · S/N 19699N5745GPettis Gary D · Lula, GABuilt 1969 · S/N 15071245N5745JJohnson Charles R · Aurora, OHBuilt 1974 · S/N 18263512N5746AManier Byron K · Houston, MOBuilt 1956 · S/N 28346N5746CHince Ambrose · East Troy, WIBuilt 1950 · S/N 19700N5746JPassage Way Farms · Lyon, MSBuilt 1974 · S/N 18263513N5746RKrawietz William L · Bulverde, TXBuilt 1965 · S/N 17253415N5746TWolfe John E · Bay Point, CABuilt 1964 · S/N 17251646N5747BFarris Steve R · Fresno, CABuilt 1956 · S/N 33747N5747RLehmer Jereme D · Oxford, NYBuilt 1965 · S/N 17253416N5747TMontgomery Robert L · Kingman, AZBuilt 1964 · S/N 17251647N5748AGaines Matthew M · Plattsburg, MOBuilt 1956 · S/N 28348N5748CRigos George N · Whistler BcNon-citizen corporation, flight hours not reportedBuilt 1950 · S/N 19702N5748EInternational Air Services Inc Trustee · Carson City, NVS/N 17271930N5748GKozar Theodore · Connellsville, PABuilt 1969 · S/N 15071248N5748JWallner Patrick J · Redding, CABuilt 1974 · S/N 18263515N5748RStanley David W · Burleson, TXBuilt 1965 · S/N 17253417N5748TKelly Walter T · Winona, MNBuilt 1964 · S/N 17251648N5749AScobey Robert P · Weiser, IDBuilt 1956 · S/N 28349N5749GPorter John W · Center, TXBuilt 1969 · S/N 15071249N5749RMerrill Robert · Plymouth, MABuilt 1965 · S/N 17253418N5749TEast Fork Aviation LLC · Brandon, MSBuilt 1964 · S/N 17251649N574AJRippel Aviation LLC · La Salle, ILBuilt 1975 · S/N 15077148N574DEMuggsys Aviation Services LLC · Crittenden, KYBuilt 1974 · S/N 172-62959N574MTGrow Michael J · Palmer, AKBuilt 1967 · S/N 185-1247N574STState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606116N574WBDeal Timothy E · Anchorage, AKBuilt 1957 · S/N 34507N5750GHolt Wayne A · Waterford, MEBuilt 1969 · S/N 15071250N5750RPeters Tricia S · Columbia City, INBuilt 1965 · S/N 17253419
Back to AD 87-20-03 R2