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.

N736UFLee County Flying Club LLC · Marianna, ARBuilt 1977 · S/N R1722793N736UGAerospatiale LLC · Yakima, WAS/N R1722794N736UJN736uj LLC · Tulsa, OKBuilt 1977 · S/N R1722796N736UKMustard Robert M · Duxbury, MAS/N R1722797N736UPDavis John F · Westminster, MDS/N R1722801N736UTIsbell Brian K · Rosenberg, TXBuilt 1977 · S/N R1722804N736UUCoffyn Clifford J · Boynton Beach, FLBuilt 1977 · S/N R1722805N736VAFelmlee Don E · Center, COS/N R1722811N736VBBuell Jack A · St Maries, IDBuilt 1977 · S/N R1722812N736VDJ-Mac Aviation LLC · Hugoton, KSBuilt 1977 · S/N R1722814N736VELesure William A · Wadsworth, OHS/N R1722815N736VFEdgar Warren · Granite Bay, CABuilt 1978 · S/N R18200776N736VGDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1977 · S/N R1722817N736VJFly White Cloud LLC · Lake Havasu City, AZBuilt 1977 · S/N R1722819N736VKGeneral Aviation LLC · Henderson, NVBuilt 1978 · S/N R18200777N736VLKaehlert Lottie DBA · Rifle, COS/N R1722821N736VPKitty Hawk Flight Training And Tours LLC · Kill Devil Hills, NCBuilt 1977 · S/N R1722824N736VRStalling Dustin R · Florence, AZS/N R1722826N736VTRucker William C Trustee · Sanger, TXBuilt 1978 · S/N R18200778N736VWDorsey Jerome J · Greensboro, PAS/N R1722831N736VXRocky Mountain Flight Consultants LLC · Boulder, COBuilt 1978 · S/N R1722832N736VZSuarez Santiago A · Laredo, TXS/N R1722834N736WCNash Jason · Barrington, NHBuilt 1977 · S/N R1722837N736WEContinental Capital Corp · Wilmington, DEBuilt 1977 · S/N R1722839N736WHB&B Island Aviation LLC · Sylvania, OHBuilt 1978 · S/N R18200779N736WJRatjen Aviation LLC · Naples, FLBuilt 1977 · S/N R1722843N736WKRegistration Pending · Jenks, OKRegistration pendingBuilt 1978 · S/N R1722844N736WLInman James F · East Bend, NCBuilt 1977 · S/N R1722845N736WPN736wp LLC · Waterford, NYBuilt 1979 · S/N R18200781N736WSMst Ltd · Charlotte, NCBuilt 1977 · S/N R1722851N736WXStone Aviation LLC · Cusick, WABuilt 1978 · S/N R18200783N736XAReese Brent R · Anchorage, AKBuilt 1978 · S/N R1722859N736XBAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1978 · S/N R1722860N736XCEagle Squadron Inc · The Villages, FLBuilt 1978 · S/N R1722861N736XDRiverview Flyers LLC · Marysville, PABuilt 1978 · S/N R1722862N736XERegistered aircraftBuilt 1978 · S/N R1722863N736XGStonecipher Guy Austin III · Beaumont, TXBuilt 1978 · S/N R18200785N736XHJlm Ranch Inc · Mullen, NEBuilt 1978 · S/N R1722866N736XMNorthwest Passage LLC · Anchorage, AKBuilt 1978 · S/N R1722870N736XNColorado Northwestern Community College · Rangely, COBuilt 1978 · S/N R1722871N736XSRegistration Pending · Urbandale, IARegistration pendingBuilt 1978 · S/N R1722875N736XVFreedom Aviation LLC · Riverton, UTBuilt 1978 · S/N R1722878N736XXMonteiro Aviation LLC · Minneapolis, MNBuilt 1978 · S/N R1722880N736XZPiotrowski Anthony J · Nanticoke, PABuilt 1978 · S/N R1722882N736YBCarlson James D · North Andover, MABuilt 1978 · S/N R1722884N736YDTrans World Aircraft LLC · Quakertown, PABuilt 1978 · S/N R1722886N736YLFive Star Electric Inc · Lakin, KSBuilt 1978 · S/N R18200789N736YQZupanick Joseph A · Montevallo, ALBuilt 1978 · S/N R18200790N736YWInvestments Property Holdings Aviation LLC · Jonesboro, GAS/N R18200793N736YYYankee Yankee LLC · Bend, ORBuilt 1978 · S/N R18200795
Back to AD 87-20-03 R2