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.

N3750VNeal Latimer B IV · Fayetteville, GABuilt 1975 · S/N 15076610N3750YMurphy Mark · Belleair, FLBuilt 1963 · S/N 21058250N3752FCopper River Airmotive LLC · Copper Center, AKS/N 17255247N3752JLudwig Daniel C · New Rockford, NDBuilt 1966 · S/N 15065052N3752RMccoy Gregory K · Wichita, KSBuilt 1966 · S/N 17255552N3752SHutchins Mary Ellen · Front Royal, VABuilt 1963 · S/N 17250952N3752URegistered aircraftBuilt 1963 · S/N 18255152N3753JWallin Joshua M · Moreno Valley, CAS/N 15065053N3753LKroutil David W · Hilmar, CABuilt 1965 · S/N 17253922N3753RCounts Sean M · Largo, FLBuilt 1966 · S/N 17255553N3753YWolfe Christopher D · Gilbert, AZBuilt 1963 · S/N 21058253N3754DEckard Eric M Trustee · Wasilla, AKBuilt 1957 · S/N 34454N3754FTrees Joshua S · Italy, TXBuilt 1966 · S/N 17255249N3754LBuist Gordon G · Southbury, CTBuilt 1965 · S/N 17253923N3754RVandiver James A · Rome City, INBuilt 1966 · S/N 17255554N3754YSullivan Eugene M · Cotter, ARBuilt 1963 · S/N 21058254N3755LNorcal Flight Center LLC · Lincoln, CAS/N 17253924N3755UHendrickson Justin R · Twin Falls, IDBuilt 1963 · S/N 18255155N3755YCecil Enterprises LLC · Gig Harbor, WABuilt 1963 · S/N 21058255N3756DAnderson Daren J · Almond, WIS/N 34456N3756JLong Donald R · Seneca, SCBuilt 1966 · S/N 15065056N3756UKlinger Cattle Co Inc · Friona, TXBuilt 1958 · S/N 51263N3756XStephens Tanner B · Palmer, AKBuilt 1968 · S/N 21059075N3757SWiller Sebastian · Calhoun, GABuilt 1963 · S/N 17250957N3758DStrother John G · Kenai, AKBuilt 1957 · S/N 34458N3758FTvpx Aircraft Solutions Inctrustee · North Salt Lake, UTS/N 17255253N3758LN3758l LLC · Titusville, FLBuilt 1965 · S/N 17253927N3758RDrager Timothy L · Pottstown, PABuilt 1966 · S/N 17255558N3758SMorris Philip N · Edgewood, NMBuilt 1963 · S/N 17250958N3759SBudd Stephen C · Lake City, FLBuilt 1963 · S/N 17250959N3759YManagement Support Services LLC · Naturita, COBuilt 1963 · S/N 21058259N375FDepartment Of The Interior · Boise, IDBuilt 1980 · S/N U20605750N375HPCraig E Rappe · Wasilla, AKBuilt 1976 · S/N 18503235N375HWWallace Charles · Fayetteville, ARBuilt 1963 · S/N 21058251N375JTD2 Aviation LLC · Chesterfield, MOBuilt 1979 · S/N R18201291N375LARegistered aircraftBuilt 1965 · S/N 17252722N375MKIntegrity S&J Properties LLC · Amarillo, TXBuilt 1963 · S/N 21058252N375PWRyan Adrian B · Anchorage, AKBuilt 1979 · S/N 18503965N375WVictory Holdings LLC · Anacortes, WABuilt 1978 · S/N 18503598N375YVBisono Pablo R · San Juan, PRBuilt 1974 · S/N 17262930N3760JWeeks Ryan A · Sneads Ferry, NCBuilt 1966 · S/N 15065060N3760SPorter Charles T III · Seymour, TXBuilt 1963 · S/N 17250960N3760YHarris Stephen T · Williamstown, KYBuilt 1963 · S/N 21058260N3761LBas Part Sales LLC · Greeley, COS/N 17253930N3761PSky Rollers LLC · Merritt Island, FLBuilt 1978 · S/N P21000053N3761SBucks Flight Academy LLC · Cashion, OKBuilt 1963 · S/N 17250961N37624Lowe David M · Sacramento, KYS/N 20668N3762DSteves Aircraft · Lakeport, CABuilt 1956 · S/N 34462N3763RPrimo Aviation LLC · Collierville, TNBuilt 1966 · S/N 17255563N3763SGriffn Jared · Sheridan, ARBuilt 1963 · S/N 17250963
Back to AD 87-20-03 R2