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.

N7081SGustafson Clayton H · Woodbury, CTS/N 15067781N7081TYanez Manuel R · Calexico, CAS/N 46681N70822Southern Seaplane Inc · Belle Chasse, LABuilt 1973 · S/N U20602099N70826Chabay Shawna P · Greenleaf, IDBuilt 1968 · S/N 18259380N7082FBuchanan Walter C · Yuma, AZBuilt 1966 · S/N 15063682N7082GBbt Inc · Wilmington, DEBuilt 1969 · S/N 17258782N7082QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260382N7082SBills Jack M · Naples, FLS/N 32499N7082TGarrett Kasey L · Wilder, IDS/N 46682N7083GMassie Robert G · Whitewater, WIBuilt 1969 · S/N 17258783N7083QSevensixzerozero LLC · Boerne, TXBuilt 1972 · S/N 17260383N70845Registered aircraftBuilt 1968 · S/N 18259390N70849Hedrick Chad A · Goshen, OHS/N 18259393N7084ABaldwin Glen R · Culdesac, IDS/N 29184N7084EKnight Darrell K · Temple, TXBuilt 1960 · S/N 56584N7084FState Of Wisconsin · Madison, WIBuilt 1976 · S/N 18052721N7084MRush David · Homer, AKBuilt 1958 · S/N 55384N7084QMarcks Jason M · Shiocton, WIFirst renewal noticeS/N 17260384N7084SGreer John M Jr · Mercer Island, WABuilt 1967 · S/N 15067784N7084THeitkamp Douglas C · Barney, NDS/N 46684N7084XPatry Aeronautical Institute · Kalispell, MTBuilt 1961 · S/N 15059184N7085EArmstrong Bruce · Port Orchard, WABuilt 1960 · S/N 56585N7085GRegistered aircraftBuilt 1969 · S/N 17258785N7085QJust Plane Fun Et LLC · East Troy, WIBuilt 1973 · S/N 18262025N7085SMatthews Suzanne M · Horseheads, NYS/N 15067785N7085TKelley Geoffrey A · Wichita, KSBuilt 1959 · S/N 46685N7085XGorman Michael G · Zephyr Cove, NVS/N 15059185N70861Importico William J · Bridgewater, NJBuilt 1968 · S/N 18259397N70867Phantom Flyer LLC · Yelm, WABuilt 1968 · S/N 18259400N7086ATugmon Danny Lee · Locust Grove, OKBuilt 1956 · S/N 29186N7086FCooley Dennis Andrew · Wasilla, AKBuilt 1966 · S/N 15063686N7086GSniffen Wesley H · Sycamore, OHBuilt 1969 · S/N 17258786N7086XYocum Stuart · Kingman, AZBuilt 1961 · S/N 15059186N70872Johorn LLC · Downingtown, PABuilt 1968 · S/N 18259402N7087FParnell Don E · Alexandria, LAS/N 15063687N7087GRavindran Manoj · Clarksville, TNBuilt 1970 · S/N 17258787N7087TLakelands Flyers LLC · Greenwood, SCS/N 46687N70884Walbert Frank J · Pagosa Springs, COBuilt 1969 · S/N 18259405N70885Bates Ranches · Condon, ORBuilt 1968 · S/N 18259406N70888Nbw Wings LLC · Cave Creek, AZBuilt 1968 · S/N 18259408N7088DShoup Greg L · Pierre, SDBuilt 1961 · S/N 17248392N7088FVander Mey Thomas H · Aitkin, MNBuilt 1966 · S/N 15063688N7088GSardeis LLC · River Hills, WIS/N 17258788N7088MCrouse Dewayne O · Eagle River, AKBuilt 1958 · S/N 55388N7088QTraviss Siegfried H · Athol, IDS/N 18262027N70892Williams Tyler D · Tracy, CABuilt 1968 · S/N 18259410N7089ARuotsi Tony M · Beaver Island, MIBuilt 1956 · S/N 29189N7089MWolgemuth Mark P · Lowell, INS/N 55389N708CCOlivier Seth N · Baskin, LABuilt 1966 · S/N 15063262N708HKKliner Henry J · Wilmot, SDBuilt 1950 · S/N 19742
Back to AD 87-20-03 R2