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.

N8837XRichards Kevin J · Magnolia, TXBuilt 1961 · S/N 18253237N8838BMason City Enterprises LLC · Mason City, NES/N 36538N8838XAdventist World Aviation Inc · Wilson, NCBuilt 1961 · S/N 18253238N8838ZG2g Aviation LLC · Wray, COBuilt 1966 · S/N 17255488N8839BRiberio Trucking LLC · Stratford, CTBuilt 1957 · S/N 36539N8839GRegistered aircraftBuilt 1966 · S/N 15062939N8839TKansas Farm And Ranch Inc · Seneca, KSBuilt 1960 · S/N 52739N8839USchuh Thomas M · Queen Creek, AZBuilt 1965 · S/N 17252750N8839XAlexander Ray J · Battle Ground, WABuilt 1961 · S/N 18253239N8839ZCole Samuel L M III · Kenai, AKBuilt 1966 · S/N 17255489N883CMDelone Charles · Sarasota, FLS/N P17257155N883DDKelly David C II · Roseville, CABuilt 1978 · S/N 18266549N8840SBlue Thunder Aviation LLC · Heath Springs, SCBuilt 1965 · S/N 15062140N8840TNelson William J · Hamilton, MTBuilt 1960 · S/N 52740N8840UHathor Aviation LLC · Johnstown, COBuilt 1965 · S/N 17252751N8840XSb Enterprise LLC · Marshall, TXBuilt 1961 · S/N 18253240N8841BErwin Brandon · Jacksboro, TXS/N 36541N8841GLinn Parker J · Brainerd, MNBuilt 1966 · S/N 15062941N8841UNorcal Flight Center LLC · Lincoln, CABuilt 1966 · S/N 17252752N8841XAngelone Inc · Elkhart, INS/N 18253241N8842GTiller Stanford C · Loup City, NEBuilt 1966 · S/N 15062942N8842TMcnamee Michael P · Anthony, NMS/N 52742N8842UHwa LLC · Charleston, SCBuilt 1965 · S/N 17252753N8843BBaker Ralph · Lake Geneva, FLS/N 36543N8843GSanders Don · Mustang, OKBuilt 1966 · S/N 15062943N8843TDiscovery Medical Research LLC · Kearney, NEBuilt 1960 · S/N 52743N8843UGullatt Jamey D · Mount Airy, NCBuilt 1965 · S/N 17252754N8843XDavis James S · Reno, NVBuilt 1960 · S/N 18253243N8844GNorthside Logistics And Automotive Inc · Dardanelle, ARS/N 21059144N8844XMangum Larry M · Morristown, TNBuilt 1961 · S/N 18253244N8844ZTerry L Fowler LLC · Greenbrier, ARBuilt 1966 · S/N 17255494N8845BB1rd Flying LLC · Hotchkiss, COBuilt 1957 · S/N 36545N8845QJohnson James W · Wilmot, ARBuilt 1979 · S/N 18503776N8845THeaton James D · Cuba, MOBuilt 1960 · S/N 52745N8845XByerly Charles W · Joliet, MTS/N 18253245N8845ZCartwright Adam C · Homestead, FLFirst renewal noticeS/N 17255495N8846TN8846t LLC · Canyon, TXS/N 52746N8846USmith Chad · Boulder City, NVBuilt 1965 · S/N 17252758N8847BSeymour John R · Findlay, OHS/N 36547N8847GSabillon Luis H · Concord, CABuilt 1966 · S/N 15062947N8847URuo Hiko · Petaluma, CABuilt 1976 · S/N 15078003N8847ZChristian Matthew T · Sebring, FLS/N 17255497N8848GFlynn John P · Colebrook, NHBuilt 1967 · S/N 15066988N8848THawkins Donald M · Borrego Springs, CABuilt 1960 · S/N 52748N8848XLevesque Michael C · Hampden, MEBuilt 1961 · S/N 18253248N8848ZMix Gary · Hoagland, INBuilt 1966 · S/N 17255498N8849GSustarich Stephen M · Ketchikan, AKBuilt 1966 · S/N 15062949N8849XCopper River Airmotive LLC · Copper Center, AKBuilt 1961 · S/N 18253249N8849ZBagwell Aaron Edward · Mount Vernon, WABuilt 1966 · S/N 17255499N884CAColeman Aero Club · Apo AeBuilt 1978 · S/N 17271876
Back to AD 87-20-03 R2