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.

N704AZFrantz Dean A · Adrian, MIBuilt 1976 · S/N 15078471N704BEGore Cleveland · Manning, SCS/N 15078475N704BGJones Kermit L III · Jasper, ALBuilt 1976 · S/N 15078477N704BHCloud Buddies LLC · Charlotte, NCBuilt 1976 · S/N 15078478N704BMEdwards Richard V · Acampo, CABuilt 1976 · S/N 15078482N704BNWipaire Inc · South Saint Paul, MNBuilt 1982 · S/N 18504380N704BRRourke William P · Lavonia, GAS/N 15078486N704BZFranks John W · Barberton, OHBuilt 1976 · S/N 15078494N704CACircle S Aviation LLC · Starkville, MSBuilt 1976 · S/N 15078495N704CBLewis Stephen · Hayden, IDBuilt 1976 · S/N 15078496N704CEB2w Corporation · Winona, MNBuilt 1976 · S/N 15078498N704CFWilbur Blake G · Kent, WABuilt 1976 · S/N 15078499N704CMCarpenter Devon W · Mountain Top, PABuilt 1976 · S/N 15078505N704CNTm Aero Marine Inc · North Miami, FLBuilt 1976 · S/N 15078507N704CSHolloway James H · Merritt Island, FLBuilt 1976 · S/N 15078511N704CURogers Gale Allen · Jonesborough, TNBuilt 1976 · S/N 15078513N704CXAlbatross Air Inc · Beaver, WVBuilt 1976 · S/N 15078516N704CYKimbrel Michael R · Shreveport, LABuilt 1976 · S/N 15078517N704CZCook David · Tucson, AZBuilt 1977 · S/N 15078518N704DBAndrews University · Berrien Springs, MIBuilt 1976 · S/N 15078519N704DFMaples Andrew L · Wilmington, DES/N 15078523N704DGEastern Florida State College · Cocoa, FLBuilt 1976 · S/N 15078524N704DHDelaware River Flyers LLC · Dover, DEBuilt 1976 · S/N 15078525N704DJStevens Robert L · Wauseon, OHBuilt 1976 · S/N 15078526N704DMTodd R Ray · Lewisville, NCBuilt 1976 · S/N 15078529N704DSMeza Mike A · Aledo, TXBuilt 1976 · S/N 15078534N704DTWasson Tom L · Lakeport, CAS/N 15078535N704DUWinstead Walley K · Leavenworth, KSBuilt 1976 · S/N 15078536N704DXBaskov Andrei · Irvine, CABuilt 1976 · S/N 15078539N704DYSommers Delwyn L · Ochlocknee, GABuilt 1976 · S/N 15078540N704DZWest Michigan Flying Club Inc · Norton Shores, MIBuilt 1976 · S/N 15078541N704EGMartinez Stephen D · Belton, MOBuilt 1976 · S/N 15078548N704ELLancaster Aero LLC · Smoketown, PABuilt 1976 · S/N 15078552N704EMFee Eaman · Pembroke, MABuilt 1976 · S/N 15078553N704ERBeckwith James N · Goldsboro, NCS/N 15078557N704EVJones Janet J · Burlington, VTBuilt 1976 · S/N 15078561N704EXMouw Jacob W H · Palmer, AKBuilt 1976 · S/N 15078563N704EZLanning 1 Aviation LLC · Amarillo, TXBuilt 1976 · S/N 15078565N704FEOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeBuilt 1976 · S/N 15078570N704FKTb Maintenance And Cleaning LLC · Deltona, FLBuilt 1976 · S/N 15078575N704FNNorman Charles E DBA · Zanesville, OHBuilt 1976 · S/N 15078577N704FPKopache Gregory · Boulder, COBuilt 1976 · S/N 15078578N704FQLapinel Marc P · Long Beach, NYS/N 15078579N704FWHorton Jimmie D · Orlando, FLS/N 15078585N704FXKlingenberg Alice Ruth · Derby, KSBuilt 1976 · S/N 15078586N704FYWassair Aviation LLC · Elkhorn, WIS/N 15078587N704FZDanto Peter J · Concord, CABuilt 1976 · S/N 15078588N704GGillis Ryan T · Kenai, AKS/N 15078638N704GCSteffen Craig · Harrogate, TNBuilt 1976 · S/N 15078591N704GDMacmorris Clifford Jr · Naples, FLBuilt 1976 · S/N 15078592
Back to AD 87-20-03 R2