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.

N4432UHull Ronald W · Temecula, CABuilt 1964 · S/N 15060432N4433BAircraft Partner N4433b Dst · BerlinBuilt 1955 · S/N 26777N4433QTwo Dog Enterprises Inc · Madison, WIBuilt 1973 · S/N 17261712N4433RWtf Partnership · Anchorage, AKBuilt 1976 · S/N 18502953N4434CNewberg Edgar T · Hector, MNBuilt 1953 · S/N 16019N4434KAzar Abdo Georges · Houston, TXS/N 18268241N4434QFaires Kelly C · Cedartown, GABuilt 1973 · S/N 17261713N4434RAll American Aviation LLC · Fort Worth, TXBuilt 1974 · S/N 17263179N4435BHarstad Calvin B · Viking, MNS/N 26779N4436BHarris Derek A · Marion, TXBuilt 1955 · S/N 26780N4436LLehman Bradley R · Onsted, MIBuilt 1966 · S/N 17254527N4436QVan Hoomissen Thomas J · Anchorage, AKS/N 17261715N4436RDoran Kenneth J · Twisp, WABuilt 1974 · S/N 17263181N4437BCaudill Charles D · Fairbanks, AKBuilt 1955 · S/N 26781N4437LThomas John · Lees Summit, MOBuilt 1966 · S/N 17254528N4438CCiabattoni Joseph L · Upland, CABuilt 1953 · S/N 16023N4438LHarvey Jason Kyle · Glendale, AZS/N 17254529N4439CRegistration Pending · Wilmington, DERegistration pendingBuilt 1953 · S/N 16024N4439QLipan Creek Flying Serice LLC · Eola, TXBuilt 1971 · S/N 18800839N443KAKirsch John P · Fort Defiance, AZS/N U20602496N4441KWeaver Aircraft Co · Carson City, NVBuilt 1966 · S/N 15065397N4441LKwon Andrew W · Tujunga, CABuilt 1966 · S/N 17254534N4441QHaring Clay DBA · Lincoln, KSBuilt 1971 · S/N 18800841N4441RAtwood Flying Club · Atwood, KSBuilt 1974 · S/N 17263184N4441WHodge Henry D Jr · Anchorage, AKBuilt 1978 · S/N U20604389N4442FRegistration Pending · Sulphur, LARegistration pendingBuilt 1958 · S/N 46144N4442LSchoepflin Robert D · Palouse, WABuilt 1966 · S/N 17254535N4442UBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 15060442N4443LHenderson Michael Trustee · Whitman, NES/N 17254536N4443RCold Region Air LLC · Fairbanks, AKBuilt 1976 · S/N 18502957N4443UFratangelo Robert A · Sodus, NYBuilt 1964 · S/N 15060443N44441Breeden William N · Gaithersburg, MDBuilt 1966 · S/N 18258015N4444CLester Chad M · New Castle, DEBuilt 1953 · S/N 16029N4444TKinzie Industries LLC · Alva, OKBuilt 1966 · S/N P206-0290N4444VWolfe Randy K · Middle Grove, NYBuilt 1971 · S/N 15072907N4444WKoehler Robert E · West Lafayette, INBuilt 1961 · S/N 18253371N4445BFassett Barry J · Blaine, MNBuilt 1955 · S/N 26789N4446BOz Aviation Inc · Wilmington, DEBuilt 1955 · S/N 26790N4446LC And T Aviation Inc · Madera, CAS/N 17254539N4446RSiler Jerry L · Eau Claire, WIBuilt 1974 · S/N 17263188N44475Jerryair Ltd · Kent, OHS/N P21000408N4447QWolter Dennis R · Cincinnati, OHBuilt 1973 · S/N 17261719N4447RManos Con Alas Ministries · Sierra Madre, CABuilt 1978 · S/N R18200601N4447UTrenter Ray J · Waynesboro, GAS/N 15060447N4448BLadegard Ryan P · Wasilla, AKBuilt 1955 · S/N 26792N4448CSnider Gary · West Des Moines, IABuilt 1953 · S/N 16033N4448LPuertolas Pascual G · Cobb, CABuilt 1966 · S/N 17254541N4448RBell F Robert · Anchorage, AKBuilt 1976 · S/N 18502960N4449BPatkotak Hugh Gareth Sr · Anchorage, AKBuilt 1955 · S/N 26793N4449GHuntley John · Bellingham, WABuilt 1962 · S/N 21058087
Back to AD 87-20-03 R2