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.

N736PPLuksch Daniel C · Murfreesboro, TNS/N R1722683N736PQRegistration Pending · John Day, ORRegistration pendingS/N R1722684N736PRM3 Aviation LLC · Wausau, WIS/N R1722685N736PWTheno Steven M · Coupeville, WABuilt 1977 · S/N R1722690N736PYTurbine Financial Group LLC · Ogden, UTS/N R1722692N736QAQuintana Cesar A · Sunny Isles Beach, FLS/N R1722694N736QBHambrick Joseph G · Carthage, TXS/N R1722695N736QCKirtland Aero Club · Kirtland Afb, NMS/N R1722696N736QFWilliams Mitchell L · Chickasha, OKBuilt 1977 · S/N R1722699N736QGG&M Aircraft Inc · Wheat Ridge, COBuilt 1977 · S/N R1722700N736QNSkjonsberg Robert A · New Effington, SDS/N R1722706N736QSWerme Eric Brian · King George, VABuilt 1977 · S/N R1722710N736QUCloudstreet Partnership · Albuquerque, NMBuilt 1978 · S/N R18200755N736QXTeets Trent D · West Fargo, NDS/N R18200756N736QYWanken Troy F · Shelby, MTFirst renewal noticeBuilt 1977 · S/N R1722716N736RAWernsman William Adam Trustee · Garnett, KSBuilt 1978 · S/N R18200758N736RCAtwood William E · Millersville, MDBuilt 1977 · S/N R1722720N736RFBiz Flyers LLC · Great Falls, MTBuilt 1977 · S/N R1722723N736RGRegistered aircraftBuilt 1978 · S/N R18200762N736RHJabavu Aviation LLC · Cedar Hill, TXBuilt 1977 · S/N R1722725N736RKRegistered aircraftBuilt 1977 · S/N R1722727N736RPExtter Aviation LLC · Parker, COS/N R1722731N736RQKisic Michael L · Rector, PABuilt 1978 · S/N R18200764N736RRWatts Glenn L · Anchorage, AKBuilt 1977 · S/N R1722733N736RUGlaeser Robert L · Portland, ORBuilt 1977 · S/N R1722736N736RVPerrin J R · Omaha, NEBuilt 1977 · S/N R1722737N736RWHoward County Flying Club Inc · Grand Island, NEBuilt 1977 · S/N R1722738N736RXTop Notch Services LLC · Glen Cove, NYBuilt 1977 · S/N R1722739N736RZShipol Flying LLC · Sacramento, CABuilt 1977 · S/N R1722741N736SDJcp Thrift Inc · Ocean Springs, MSS/N R1722745N736SEJones Harry N · Kathleen, GABuilt 1977 · S/N R1722746N736SKHawe Christopher · Homer, AKBuilt 1977 · S/N R1722751N736SLLang Inc · Wilmington, DEBuilt 1977 · S/N R1722752N736SPColberg Stefan · North Bend, ORBuilt 1977 · S/N R1722755N736SXWalls Chris K · Lawrenceville, GABuilt 1977 · S/N R1722762N736SYGosch Peter J · Littleton, COBuilt 1977 · S/N R1722763N736TASlc LLC · Las Vegas, NVBuilt 1977 · S/N R1722765N736TCJia Li · Chandler, AZS/N R1722767N736TELissie Flying Service Inc · Lissie, TXBuilt 1977 · S/N R1722769N736TGMagleby Herbert K · Surprise, AZS/N R18200768N736TP4110 Aviation LLC · Rome, GABuilt 1977 · S/N R1722778N736TSRose Clarence E III · Grove, OKBuilt 1978 · S/N R18200770N736TTWillard Michael E · Colorado Springs, COBuilt 1977 · S/N R1722782N736TUMathwig Althea G · Glencoe, MNBuilt 1977 · S/N R1722783N736TVRegistration Pending · Mocksville, NCRegistration pendingBuilt 1977 · S/N R1722784N736TXN736 Tango Xray LLC · Paw Paw, ILBuilt 1977 · S/N R1722785N736UASandstrom Jeff A · Anchorage, AKBuilt 1977 · S/N R1722788N736UBMccall Freddie · Brewton, ALBuilt 1977 · S/N R1722789N736UDSeven Ranges Mfg Corp · Carrollton, OHBuilt 1978 · S/N R18200771N736UETraining Planes Of Texas Inc · Flint, TXBuilt 1977 · S/N R1722792
Back to AD 87-20-03 R2