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.

N7763CHudzinski Thomas E · Wasilla, AKS/N 32341N7763FRoss Joshua S · Homer, AKBuilt 1966 · S/N 15063863N7763TWood Pro Ventures LLC · Justiceburg, TXBuilt 1960 · S/N 47363N7763UMarshall Michael S · Lincoln, CABuilt 1976 · S/N 15077835N7764FAbouhatab Majed · Houston, TXBuilt 1966 · S/N 15063864N7764GTriad Aviation Academy LLC · Greensboro, NCBuilt 1970 · S/N 17259464N7764XMalcolm Ward A · Moorefield, WVBuilt 1960 · S/N 17248264N7765FFilippone Chrristopher A · Ormond Beach, FLS/N 15063865N7765GJefferies Stanley J · Coos Bay, ORBuilt 1970 · S/N 17259465N7765TWhisman Marc K · Long Beach, CABuilt 1960 · S/N 47365N7765UCentral Ohio Soaring Association Inc · Marion, OHBuilt 1976 · S/N 15077837N7766FBuckman Bill · Lorenzo, TXBuilt 1966 · S/N 15063866N7766GAir Ally Asset Management LLC · Chisago City, MNS/N 17259466N7766TGourley Steven E · Unionville, MOBuilt 1960 · S/N 47366N7767AWinged Bear LLC · Grafton, WIBuilt 1956 · S/N 32664N7767BKline Paul · El Mirage, AZBuilt 1971 · S/N 18501945N7767FMorris Donald R · Murphysboro, ILS/N 15063867N7767GPerformance Aviation LLC · Fort Myers, FLBuilt 1970 · S/N 17259467N7767TVisscher Paul J · Madison, GABuilt 1960 · S/N 47367N7767USkynet Aviation LLC · Cocoa Beach, FLS/N 15077838N7768AAmundson Scott E · Wrightwood, CAS/N 32665N7768UFoothill Sport Aviation LLC · Cameron Park, CABuilt 1976 · S/N 15077839N7769APliska Alan T · Torrance, CABuilt 1956 · S/N 32666N7769TWhiskey Tango Foxtrot Aviation LLC · Bemidji, MNBuilt 1960 · S/N 47369N776DLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N R18200556N776NGoeken William K Trustee · Sanger, TXS/N 18503239N776SASopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1976 · S/N 15077884N776TMAero Performance LLC · Scooba, MSBuilt 1976 · S/N 21061480N7770ASampson Zachary J · New Braunfels, TXS/N 17252309N7770GMyers Keith R Trustee · Fond Du Lac, WIBuilt 1970 · S/N 17259470N7770KAir Craft LLC · Sheridan, WYBuilt 1976 · S/N 18052726N7770TShinn William D · Milton, WABuilt 1960 · S/N 47370N7770UBrown Michael E · Miramar, FLBuilt 1964 · S/N 17251770N7771AWells Jason R · Chugiak, AKBuilt 1956 · S/N 32668N7771BBeam Thomas W · Paw Paw, MIBuilt 1964 · S/N 17251607N7771GEmpire Aero Club Inc · Sebastopol, CABuilt 1970 · S/N 17259471N7771TBailey Bradley E · Phoenix, AZBuilt 1960 · S/N 47371N7771UPryor Isaac L · Charlotte, NCBuilt 1964 · S/N 17251771N7772BLunken Martha F · Cincinnati, OHBuilt 1956 · S/N 32420N7772FCushing Aviation LLC · Red Wing, MNBuilt 1966 · S/N 15063872N7772GWings Over Texas Holdings LLC · Denton, TXBuilt 1970 · S/N 17259472N7772UKiger Aviation LLC · Corvallis, ORBuilt 1964 · S/N 17251772N7772XPremier Air Inc · Raceland, LABuilt 1961 · S/N 17248272N7773FDux Aaron T · Missoula, MTS/N 15063873N7773TBennett Kevin S · Bay City, ORBuilt 1960 · S/N 47373N7773UWitsberger Kelly R · Newburg, MOBuilt 1964 · S/N 17251773N7774ASaydun LLC · Richardson, TXBuilt 1964 · S/N 17252168N7774BAdair Aviation LLC · Broken Arrow, OKBuilt 1981 · S/N U20606224N7774CTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1973 · S/N 0093N7774FMurphy Jeffrey R · Newport, MNS/N 15063874
Back to AD 87-20-03 R2