OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N2260YReich Bruce D · Red Oak, IABuilt 1967 · S/N 17700060N22612Wild Hair Aviation LLC · Centerville, WABuilt 1968 · S/N 15068402N22615Word Charles A · Pensacola, FLBuilt 1968 · S/N 15068405N2261CGandy John W III · Mt Vernon, TXBuilt 1953 · S/N 30561N2261RPetik Jason P · Sidney, NEBuilt 1968 · S/N T210-0411N2261YKemper Dennis R · Carmichael, CABuilt 1967 · S/N 17700061N22628Lemko Dennis A · Fresno, CABuilt 1968 · S/N 15068412N2262SKoch Phillip E · Eldon, MOBuilt 1976 · S/N 21061206N2262TMarsh John E · Washington, DCBuilt 1968 · S/N 185-1420N2262XStampfler Richard D · Groveland, MABuilt 1965 · S/N 337-0162N2262YRegistered aircraftBuilt 1967 · S/N 17700062N22638Lindorfer John H · Long Beach, MSBuilt 1976 · S/N 15078567N2263CWalker William S · Shallotte, NCBuilt 1953 · S/N 30563N2263JJr Imaging Logistics Inc · Pasco, WABuilt 1966 · S/N 15065463N2263TUnited States Air Force · Dover Afb, DEBuilt 1977 · S/N R18200014N2263YMejia Mauricio · South Gate, CABuilt 1967 · S/N 17700063N22645Martinez Emilio · Fairburn, GABuilt 1968 · S/N 15068424N22648Eagles Wings Flight Training · Clintonville, WVBuilt 1968 · S/N 15068425N2264DKlein James M · Pinconning, MIBuilt 1952 · S/N 20416N2264GMessner Mark R · Chesapeake, OHBuilt 1958 · S/N 51564N2264JRegistered aircraftAssigned, pending cancellationS/N 15065464N22650Sackett Gary G · Millcreek, UTFirst renewal noticeBuilt 1972 · S/N 21059767N22656Berry Frank C · Watkinsville, GAS/N 15068431N2265DPiispanen Norman C · Fairbanks, AKBuilt 1952 · S/N 20417N2265GWilder James S · Eagle, IDBuilt 1958 · S/N 51565N2265RHodhson Shell S · Wyocena, WIBuilt 1969 · S/N T210-0415N2265YHemann Dale F · Osage, IABuilt 1967 · S/N 17700065N22662Rogers Gary A · Novi, MIBuilt 1968 · S/N 15068433N22663Auger Allan Dean · Conifer, COBuilt 1968 · S/N 15068434N22667Firkus Lloyd Jason · Plover, WIBuilt 1968 · S/N 15068437N2266DBeland Steven J Jr · Saint Ansgar, IABuilt 1952 · S/N 20418N2266JRound Engine Aero · Nashville, MIBuilt 1966 · S/N 15065466N2266SWeekend Air LLC · Incline Village, NVBuilt 1976 · S/N 21061210N2266XBarney Julius C · Lutz, FLBuilt 1965 · S/N 337-0166N22673Merry Robert J · Lynnwood, WAFirst renewal noticeBuilt 1968 · S/N 15068440N22676Burgess Barton C · Leesburg, OHBuilt 1968 · S/N 15068442N22677Barlow Rod · Kaysville, UTBuilt 1968 · S/N 15068443N2267TAeropod Inc · Aurora, COS/N 185-1427N2267XRound Engine Aero · Nashville, MIBuilt 1965 · S/N 337-0167N2267YCole Gary L · Richmond, TXBuilt 1967 · S/N 17700067N22680Turpen Andrew B · San Andreas, CAS/N 15068444N22682Bianchi Brandon J · Castroville, CABuilt 1968 · S/N 15068446N22689Ridge View Aviation LLC · Napanoch, NYBuilt 1974 · S/N 17264073N2268CCozach LLC · Wilmington, DEBuilt 1982 · S/N T30300081N2268JKing Larry W · Port St John, FLBuilt 1966 · S/N 15065468N2268SPlatinum Air Services LLC · Morgantown, WVS/N R18201317N22692Registration Pending · Metairie, LARegistration pendingS/N 15068452N226ACTitle 46 LLC · Hamilton, MTBuilt 1979 · S/N 18267019N226BBurton Robert B · New York, NYBuilt 1977 · S/N 21061701N226CAChoice Aviation LLC · Hamilton, MTBuilt 1976 · S/N 17266762
Back to AD 87-20-03 R2