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.

N3763UHunter James C · Shelton, WABuilt 1964 · S/N 18255163N3764SKarashchuk Yaroslav P · Georgetown, KYS/N 17250964N3765GGraber Quinten R · Brooksville, MSBuilt 1948 · S/N 7101N3765JSatanta Flying Service Inc · Satanta, KSS/N 15065065N3765RLevin Robert · Roseburg, ORBuilt 1966 · S/N 17255565N3765SKennedy Patrick M · Great Barrington, MABuilt 1971 · S/N 17701629N3765YBott David F · Yukon, OKBuilt 1963 · S/N 21058265N3766DFree Range LLC · Missoula, MTS/N 34466N3766LSygnet Lenard M · Pottstown, PABuilt 1965 · S/N 17253935N3766RHarrigan Patrick · Hickory, NCBuilt 1968 · S/N 337-1034N3766VHaile Kempton Crosby · Warrenton, VABuilt 1975 · S/N 15076612N3766YPyanov Mark · Clinton, MSS/N 21058266N3767JHalbur Wesley D · Heron Lake, MNBuilt 1966 · S/N 15065067N3767SDickehut Donna · Cloverdale, INBuilt 1963 · S/N 17250967N3768D3di LLC · Elizabeth, WVBuilt 1957 · S/N 34468N3768JWheeler Kevin M Trustee · Comstock Park, MIBuilt 1966 · S/N 15065068N3768RStretz Scott P · Lees Summit, MOBuilt 1966 · S/N 17255568N3768VHaynes Robert K · Pilot Point, TXBuilt 1975 · S/N 15076614N3769JRatner Robert D · Swan Lake, NYBuilt 1966 · S/N 15065069N3769UNorthey Scott A · Mazama, WABuilt 1963 · S/N 18255169N3769VSky High Investments LLC · Greenwood, INS/N 15076615N3770FSchoenberger Lance · Shakopee, MNBuilt 1966 · S/N 17255265N3770JAzad Raja M · Hawthorne, CABuilt 1966 · S/N 15065070N3770LJ&C Aviation LLC · South Boston, VABuilt 1965 · S/N 17253939N3770RBowery Michael P · Quinton, VABuilt 1966 · S/N 17255570N3770UPetersen Christopher Erik · Morton, ILBuilt 1964 · S/N 18255170N3770YBig Bend C C Foundation · Moses Lake, WABuilt 1963 · S/N 21058270N37718Cole Rayce S · Palmer, AKS/N 46597N3771JKozel Thomas · Pottstown, PABuilt 1966 · S/N 15065071N3771LFlying Bs LLC · Midlothian, TXBuilt 1966 · S/N 17253940N3771RMccay Brian D · Earlysville, VABuilt 1966 · S/N 17255571N3772RRiver Town Aviation LLC · Williamstown, WVBuilt 1966 · S/N 17255572N3772SThree Strands LLC · Colorado Springs, COBuilt 1963 · S/N 17250972N3772YKossuth Keith E · Sleepy Hollow, CAS/N 21058272N3773JBertrand Aviation LLC · Brookville, KSBuilt 1966 · S/N 15065073N3773RBlair Richard J · Medina, OHS/N 17255573N3773SFielden Donald J · Bartow, FLBuilt 1963 · S/N 17250973N3774DVandal Air LLC · Boise, IDBuilt 1957 · S/N 34474N3774LKarr Stacy A · Hogansville, GABuilt 1965 · S/N 17253943N3774YLanning 2 Aviation LLC · Amarillo, TXBuilt 1963 · S/N 21058274N3775DRegistration Pending · Churchville, MDRegistration pendingS/N 34475N3775LLee Michael Min · Dayton, OHBuilt 1965 · S/N 17253944N3776FRegistration Pending · Denver, NCRegistration pending, pending cancellationS/N 17255271N3776LStramel Bert Jon · Colby, KSBuilt 1965 · S/N 17253945N3776USchmit Joe · Ventura, IAS/N 18255176N3776VCoach Masters Inc · Kearney, NES/N 15076619N37777Quiet Aviation LLC · Longwood, FLS/N 337-0898N3777DOrchid Aero LLC · Lakewood, COS/N 34477N3777VOld School Aviation · Ottsville, PABuilt 1975 · S/N 15076620N3778DBrownd Carl L · Oro Valley, AZBuilt 1957 · S/N 34478
Back to AD 87-20-03 R2