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.

N3664SWasson Tom L · Lakeport, CABuilt 1963 · S/N 17250864N3664UAir Skylane LLC · Boulder, COBuilt 1963 · S/N 18255064N3664VPerfect Aircraft LLC · Ocala, FLBuilt 1975 · S/N 15076579N3665CN3665c LLC · Otsego, MNBuilt 1978 · S/N R18200299N3665UBlue Skies Aviation Of Wi Inc · Pulaski, WIS/N 18255065N3665YJ & B Airlift LLC · Rupert, IDBuilt 1963 · S/N 21058165N3666CStrauss Kenneth W · Vashon, WABuilt 1978 · S/N R18200300N3666JKoseogle Ali Ozan · Longmeadow, MABuilt 1966 · S/N 15064966N3666SBerry Mike J · Palo Cedro, CABuilt 1963 · S/N 17250866N36674Brown Kile Executor · Dallas, TXBuilt 1965 · S/N 18256440N3667JAbbruzze Michael J · Boynton Beach, FLBuilt 1966 · S/N 15064967N3667SOliva Louis F III · Anchorage, AKS/N 17250867N3667YAir Wake Aviation LLC · Hazelwood, MOBuilt 1963 · S/N 21058167N3668CN3668c L L C · Depauw, INBuilt 1954 · S/N 31167N3668JBrown Richard C · Adrian, MIBuilt 1966 · S/N 15064968N3668LMaui Skyhawks Inc · Kula, HIBuilt 1965 · S/N 17253837N3668SWm Aviation LLC · Moncks Corner, SCBuilt 1963 · S/N 17250868N3669LNovacek Jeffrey J · Minneapolis, MNBuilt 1965 · S/N 17253838N3669SKeller Kenneth Ray Jr · Jonesboro, ARS/N 17250869N366KWhite Thomas J · Agua Dulce, CABuilt 1957 · S/N 34529N3670LLatch Leo D · Upland, CABuilt 1965 · S/N 17253839N3670YRoussin David G · Newville, ALBuilt 1963 · S/N 21058170N3671CCharlie Aviation LLC · Philpot, KYBuilt 1978 · S/N R18200302N3671JAndrosky Charles S Jr · Superior, WIS/N 15064971N3671LCalmet Aircraft Leasing LLC · Middletown, DEBuilt 1965 · S/N 17253840N3672CWells William · Cary, NCBuilt 1978 · S/N R18200303N3672GAcosta De La Torre Armando A · El Paso, TXS/N 29549N3672JOndrasik Peter P Jr · Palmerton, PABuilt 1966 · S/N 15064972N3672LJanowski Stephen J Jr · Wadsworth, OHBuilt 1965 · S/N 17253841N3672UD W Clark LLC · Newton, NJBuilt 1963 · S/N 18255072N3672VRobinson Franz · Seagrove, NCBuilt 1975 · S/N 15076582N3672YN3672y LLC · Ferrysburg, MIBuilt 1963 · S/N 21058172N3673SMike Whiskey LLC · Le Claire, IABuilt 1963 · S/N 17250873N3673VClinton Flying Service Inc · Clinton, NCBuilt 1975 · S/N 15076583N3674JAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1966 · S/N 15064974N3674SWiegand Gary E · Carmel Valley, CABuilt 1963 · S/N 17250874N3675CBergstrom Dean A · Watertown, CTBuilt 1954 · S/N 31174N3675JHarder Ronald E · Bell, FLFirst renewal noticeBuilt 1966 · S/N 15064975N3675LSheppard Dale A · Kalispell, MTBuilt 1965 · S/N 17253844N3675YShettle Jay E · Berryville, VABuilt 1963 · S/N 21058175N3676CBoyce Walter Doug · Palmer, AKS/N 31175N3676JKorinko Seana L · Rostraver Township, PABuilt 1966 · S/N 15064976N3676UGregg Michael · Orlando, FLBuilt 1963 · S/N 18255076N3677LBell Ellis E · Forrest City, ARBuilt 1965 · S/N 17253846N3678JMorgan Daniel W · Keene, TXBuilt 1966 · S/N 15064978N3678RCarl Aviation LLC · Lake Havasu City, AZBuilt 1964 · S/N 17251566N3678SMartone Douglas K · Windham, CTBuilt 1963 · S/N 17250878N3678UCaven Dennis L · Santa Rosa, CABuilt 1963 · S/N 18255078N3678YDozier Zach J · New Boston, TXBuilt 1963 · S/N 21058178N3679UPowerhouse Coach Inc · Idaho Falls, IDBuilt 1963 · S/N 18255079
Back to AD 87-20-03 R2