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.

N8498XThompson Jason Edward · River Heights, UTBuilt 1961 · S/N 17248998N8499GRyan Richard E · Atlantic, IABuilt 1965 · S/N 15062599N8499LKennedy Christopher S · Canton, ILBuilt 1968 · S/N 17256699N8499MCornale Michael J · Dwight, ILBuilt 1976 · S/N 18264632N8499SGraznak Timothy C · Greeley, COBuilt 1965 · S/N 18256599N8499TLewis Lawrence R · Newport, WABuilt 1960 · S/N 52399N8499XSkaggs Nathan H · Peebles, OHS/N 17248999N84ATJ Squared Enterprises Corp · Hendersonville, TNBuilt 1980 · S/N 172RG0791N84CWestern Summit Enterprises Inc · Pacoima, CAFirst renewal noticeBuilt 1973 · S/N P3370115N84CCBowman Gregory H · Wichita, KSBuilt 1962 · S/N 17248756N84DLAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1979 · S/N 17272771N84DMGafni Tal · Scottsdale, AZBuilt 1973 · S/N 18262010N84EBas Part Sales LLC · Greeley, COBuilt 1973 · S/N P3370142N84FFKoorenny Brian G · Clarkston, WABuilt 1958 · S/N 51221N84JK Diamond K Guest Ranch LLC · Republic, WABuilt 1958 · S/N 46010N84LCRegistered aircraftBuilt 1976 · S/N P3370246N84LMSchaefer Bernard C · Fairfield, TXBuilt 1979 · S/N 18267405N84LSBrenberger Mark L · Raleigh, NCBuilt 1976 · S/N 18264741N84MCOn-Site Mech LLC · Helena, MTS/N 21064955N84MKNew Horizons Aviation Inc · Goshen, INBuilt 1977 · S/N 15281230N84SJLabelle Gregory D Trustee · Newbury Park, CABuilt 1984 · S/N 21064867N84TMRealm Group Transport Inc · Las Vegas, NVBuilt 1978 · S/N 18503702N84USMcginty Flying Service LLC · Jones, LAS/N 18052942N8500GAugust Mark C · Atchison, KSBuilt 1965 · S/N 15062600N8500JRiley Alfred E III · Norristown, PABuilt 1967 · S/N 15066400N8500TWhite Taylor D · Gainesville, GAS/N 52400N8501KStephenson Joe D Jr · Sand Springs, OKS/N 17250723N8501SWitschger Scott L · Albuquerque, NMBuilt 1965 · S/N 18256601N8501UOverbaugh Gary R · Highland, UTBuilt 1964 · S/N 17252401N8502BSims Hollow M · Lithonia, GABuilt 1957 · S/N 36202N8502USmitty 172 LLC · Rockford, MIBuilt 1964 · S/N 17252402N8503GPynn David W · Gasport, NYBuilt 1965 · S/N 15062603N8503SCub Club Inc · Toddville, IABuilt 1965 · S/N 18256603N8503TKolb Bryan C · Hutto, TXBuilt 1959 · S/N 52403N8503UCropley Alton I · Sitka, AKS/N 15077941N8504UDoug & Holly Harmon Inc · Fremont, MIBuilt 1964 · S/N 17252404N8505BGreen James S · Slaton, TXS/N 36205N8505JKunz Isaac A · Texarkana, TXBuilt 1967 · S/N 15066405N8505SAir Repair Inc · Cleveland, MSBuilt 1965 · S/N 18256605N8505USilverman Phillip E Trustee · Fullerton, CABuilt 1964 · S/N 17252405N8505XBerri Edward W Jr · N Fort Myers, FLBuilt 1962 · S/N 17557105N8506BTierney Garrett J · Manorville, NYBuilt 1957 · S/N 36206N8506GNighthawk Air Systems Inc · Miami, FLS/N 15062606N8506JHorning Richard H · Galion, OHS/N 15066406N8506QBell Robert C · Colby, KSS/N U20603363N8506TM & C Aviation LLC · Corinth, TXBuilt 1959 · S/N 52406N8506XBugli Zachary J · Stevensville, MTS/N 17557106N85074Patriot Pole Aviation LLC · Missouri Valley, IABuilt 1975 · S/N 18263614N8507GCaldera Michael E · Williamsport, PABuilt 1965 · S/N 15062607N8508BCc Motors LLC · Redding, CABuilt 1957 · S/N 36208
Back to AD 87-20-03 R2