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.

N3350FStrait Daniel · Sierra Vista, AZBuilt 1966 · S/N 18257350N3350SBarry Jason J · Orange, CABuilt 1969 · S/N 21059150N3350UKragseth Kyle A · Shoshone, IDBuilt 1963 · S/N 18254750N33512Kennedy John D · Clinton Twp, MIBuilt 1966 · S/N R172-0099N3351LGagnon Philip F · Anchorage, AKBuilt 1967 · S/N 185-1303N3351STarantino Nicholas T Jr · Union City, CAS/N 21059151N3351TTaylor Gail L · Red Bluff, CAS/N 17700651N3352FDaradici Jodi A · Gilbert, AZBuilt 1966 · S/N 18257352N3353TDwinell Jeffrey C · Granby, MABuilt 1967 · S/N 17700653N3353UWieser Ranch Inc · Vernon, COBuilt 1963 · S/N 18254753N3354YFelkins Roger C · Hillsboro, ALBuilt 1962 · S/N 18254354N3355EMiddletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1978 · S/N 17271515N3355RSkyhawks Flying Club Inc · Canton, SDBuilt 1967 · S/N 18258655N3356FShroyer Scott E · Peyton, COBuilt 1966 · S/N 18257356N3356SBbt Inc · Wilmington, DEBuilt 1969 · S/N 21059156N3356TCarlin Joseph A Jr · Rapid City, SDS/N 17700656N3356VCavu Pilot LLC · Powell, TNBuilt 1974 · S/N 15076471N3357DHodel Lawrence E · Hayden, IDBuilt 1955 · S/N 32155N3357JHagghult Christer · Bonney Lake, WABuilt 1967 · S/N 15066057N3357LMark II Aviation LLC · Corvallis, MTBuilt 1967 · S/N 185-1309N3357THigh West Aero LLC · Broadus, MTBuilt 1967 · S/N 17700657N3357URunway Ventures LLC · Salida, COBuilt 1963 · S/N 18254757N3358JBlue Chip Enterprises Inc · Clayton, NCBuilt 1967 · S/N 15066058N3358RHaydukovich Steven J · Phoenix, AZBuilt 1967 · S/N 18258658N3358UBratcher Michael · Elizabethtown, KYS/N 18254758N3359FHughes John · Almira, WABuilt 1966 · S/N 18257359N3359JGaler Charles J · Irvington, ALBuilt 1967 · S/N 15066059N3359TDuquette Robert R · Elfrida, AZS/N 17700659N3359VArcher Lee R · Redondo Beach, CABuilt 1974 · S/N 15076473N335JCAlexander Melodie A · Lees Summit, MOBuilt 1956 · S/N 28785N335RSYould Eric P Trustee · Palmer, AKBuilt 1977 · S/N 17268562N335SFRamont Ronald G Jr Trustee · Modesto, CABuilt 1977 · S/N 21062413N3360FLane Glen Allen Jr · Cocoa, FLBuilt 1966 · S/N 18257360N3360JStewart Roger · Lenexa, KSBuilt 1967 · S/N 15066060N3360RRoschi Nancy L · Stevensville, MTBuilt 1975 · S/N 18502874N3360SMohler Earl C · Bonita, CAS/N 21059160N3360UBailes Ernest J IV · Shepherd, TXBuilt 1963 · S/N 18254760N3360YFoote Jerry O · Unadilla, NYFirst renewal noticeBuilt 1962 · S/N 18254360N3361DDe Lint Marcus W · Cove, ORBuilt 1955 · S/N 32159N3361ROlson Bartlet · Merrimac, WIBuilt 1967 · S/N 18258661N3361TPew Aaron · Mesa, AZS/N 17700661N3361UKelleher Chuck W · Shelby, MTBuilt 1963 · S/N 18254761N3362FMunoz Mario · Scottsboro, ALBuilt 1966 · S/N 18257362N3362JLivingston Rod W · Tuttle, NDBuilt 1967 · S/N 15066062N3362RLight Jeffrey D · Woodville, VABuilt 1967 · S/N 18258662N3362TMain Cynthia M · Richmond, TXFirst renewal noticeBuilt 1967 · S/N 17700662N3362UGilliland Mcclaflin Wayne D · Powell, WYBuilt 1963 · S/N 18254762N3363DTodd Michael E · Yelm, WABuilt 1955 · S/N 32161N3363EMcfly LLC · Casper, WYBuilt 1978 · S/N 17271518N3363REagles Flight LLC · Grove, OKBuilt 1967 · S/N 18258663
Back to AD 87-20-03 R2