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.

N5182DJensen Rodney H · South Jordan, UTS/N 51282N5182ERegistered aircraftBuilt 1978 · S/N 17271756N5182FAmerican Flight Museum Inc · Topeka, KSBuilt 1965 · S/N 17253116N5182HVanderpool Robert W · Red Devil, AKS/N 18503326N51832Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 17274357N5183ENashville Flight School LLC · Nashville, TNS/N 17271757N5183PAig Aeronautics LLC · Guaynabo, PRBuilt 1981 · S/N 15284890N5183RThompson Aerial Service Inc · Wyndmere, NDBuilt 1974 · S/N 17263400N5183WG S I Training Services Inc · Branson, MOBuilt 1981 · S/N P21000650N51840Sky Bubble LLC · Santa Ana, CABuilt 1980 · S/N 17274359N5184EStringfellow Timothy C · Maryville, TNBuilt 1978 · S/N 17271758N5184FScott Alan M · Othello, WABuilt 1965 · S/N 17253124N5184JRiverside Flight Academy LLC · Riverside, CAS/N 17273721N5185ACardan Aircraft Services Inc · Red Bluff, CAS/N 28185N5185DMartinez Richard Christian · Stockbridge, MIS/N 17272441N51864Zita Air LLC · Lewisburg, PABuilt 1980 · S/N 17274361N51865Savage Michael B · Lincoln, CABuilt 1981 · S/N 17274362N5186ATengwall Kevin A · Watford City, NDS/N 28186N5186HPope Brian B · Coalgate, OKBuilt 1975 · S/N 17265365N5186LKlippel Charlie L · Huntington Beach, CABuilt 1980 · S/N 15284276N5186UHumphrey Jeffrey · Corvallis, MTBuilt 1964 · S/N 206-0186N51871Az2026 LLC · Miami, FLBuilt 1980 · S/N 17274366N51875Wings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 17274369N5187DHonnold Thomas M Jr · Cascade, IDS/N 51287N5187ENowak Michael J · Waxahachie, TXBuilt 1978 · S/N 17271760N5187GThompson Edward A · Sunset Beach, NCBuilt 1979 · S/N 17273555N5187RTke Ltd · Thief River Falls, MNBuilt 1974 · S/N 17263404N51883Angel Aviation Inc · Peoria, AZBuilt 1980 · S/N 17274371N51885Angel Aviation Inc · Peoria, AZBuilt 1980 · S/N 17274372N5188USky Stallion LLC · Winter Park, FLBuilt 1964 · S/N 206-0188N51890Hyldburg Aviation Inc · Plymouth, MABuilt 1980 · S/N 17274375N5189ABarrymore Cole · Government Camp, ORBuilt 1979 · S/N 21063302N5189BFreedom Aviation Of America LLC · Newcastle, TXBuilt 1979 · S/N 15283797N5189EOpportunity Flying Club Inc · Anchorage, AKBuilt 1959 · S/N 50489N5189YKmc Aviators LLC · Burlington, CTBuilt 1980 · S/N 21064114N518CACompass Aviation Inc · Shelby, NCBuilt 1979 · S/N 17273049N518HJArmstrong Consolidated LLC · Anchorage, AKBuilt 1971 · S/N 18501930N518MJPursuit 53 · College Station, TXBuilt 1981 · S/N U20606535N518PUSalim Omar J · Olympia, WABuilt 1983 · S/N 172RG1135N518RAPeterson Maeve M · Sonoma, CABuilt 1960 · S/N 15059082N518VKingsley Kiman J · Miller, MOBuilt 1956 · S/N 32429N519Malaska Jacob L · Orefield, PABuilt 1966 · S/N 15064303N5190DWalden James F · Willcox, AZBuilt 1958 · S/N 51290N5191ABurdeaux Barry S · Orting, WAS/N 28191N5191JN5191j LLC · Myrtle Beach, SCBuilt 1979 · S/N 17273724N5191RKlein Alan D · Hudson, WIBuilt 1974 · S/N 17263408N5191SBomar Christopher P · Munford, TNBuilt 1980 · S/N R18201515N5191URobles Marcos F · Oracle, AZBuilt 1964 · S/N 206-0191N5191VTrue Drilling LLC · Casper, WYBuilt 1975 · S/N 21060857N51920Wilkinson Edward H · Aspers, PABuilt 1980 · S/N 17274377
Back to AD 87-20-03 R2