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.

N52704Owen John D Trustee · Liberty, MOBuilt 1974 · S/N 18262782N52707Mook Douglas G · El Paso, TXBuilt 1974 · S/N 18262785N5270DGibson Brenton D · Siletz, ORBuilt 1957 · S/N 50168N5270HR & D Aircraft Inc · Jamestown, NCBuilt 1975 · S/N 17265390N5270QPitman Mark T · Princeton, MNBuilt 1972 · S/N 15073170N5270SMe & Cl Holdings Inc · Harlingen, TXS/N R18201532N52713Austin-Walker Aviation LLC · Waukee, IAS/N 177RG1255N52714Greager William E · Lakewood, COBuilt 1974 · S/N 18262791N52716Brewer Wesley G · Irvine, CAS/N 177RG1256N52719Pynn David W · Gasport, NYBuilt 1977 · S/N 177RG1257N5271QBridges Paul J · Denton, TXBuilt 1972 · S/N 15073171N5271RAyala-Moore Kristopher · Tucson, AZBuilt 1974 · S/N 17263485N5271SRegistered aircraftBuilt 1980 · S/N R18201533N5271U71 Uniform Corp · The Villages, FLBuilt 1980 · S/N 172RG0316N52720Rick Aviation Inc · Newport News, VABuilt 1981 · S/N 17274592N52723Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 177RG1258N52726Cottonwood Flyers LLC · Gypsum, COBuilt 1974 · S/N 18262800N52727Nathaniel Mothershead · Sardis, MSBuilt 1974 · S/N 18262801N5272EEcolift Corp · San Juan, PRS/N R1720178N5272RRichmond Pilots Corp · Linden, NJBuilt 1974 · S/N 17263486N5272UAerial Surveys Inc · Conway, ARBuilt 1964 · S/N 206-0272N52732Registered aircraftBuilt 1974 · S/N 18262804N52735Patzoldt Quenton A · Pine City, MNBuilt 1974 · S/N 18262806N52736Busick Clifford E · Stevenson Ranch, CABuilt 1974 · S/N 18262807N52739Above All Aviation Inc · Santa Barbara, CABuilt 1974 · S/N 18262810N5273DDrath Mark O · Reedsville, WIBuilt 1957 · S/N 50171N5273EDaniels Ronald H · Delton, MIBuilt 1959 · S/N 50573N5273RClear Prop Aviation LLC · Sterling, VABuilt 1974 · S/N 17263487N5273TFunk Michael W · Windham, NHBuilt 1982 · S/N R18201846N52746Kravchenko Aleksandr · Everett, WAS/N 18262815N52747Unicorn Papa Air LLC · Longwood, FLBuilt 1981 · S/N 17274598N52748Hall Howard S · Covington, GABuilt 1974 · S/N 18262816N52749Middle Tennessee State University · Murfreesboro, TNS/N 17274599N5274DSimonsen Deanne M · White Salmon, WABuilt 1958 · S/N 50172N5274EFedermann Joe R · Anchorage, AKBuilt 1959 · S/N 50574N5274HLincoln Skyways Inc · Lincoln, CABuilt 1975 · S/N 17265392N5274SHap'S Air Inc · Ames, IABuilt 1980 · S/N R18201534N5274YMba Sales LLC · Ridgefield, WABuilt 1980 · S/N 21064147N52750Wieneke Robert A · Rockwall, TXBuilt 1981 · S/N 17274600N52751Weinstein Mark H · Carrollton, GABuilt 1974 · S/N 18262819N52754Torgerson'S LLC · Ethridge, MTBuilt 1974 · S/N 18262822N52758Luse David C · Newalla, OKBuilt 1974 · S/N 18262825N5275DWorrell Sharyl L · Anchorage, AKBuilt 1958 · S/N 50173N5275EPasiewicz Shannon M · Anchorage, AKBuilt 1959 · S/N 50575N5275QSkyfarmer LLC · Culleoka, TNBuilt 1972 · S/N 15073175N5275RNorth Matthew E · Oro Valley, AZBuilt 1978 · S/N R18200641N5275VViatrans LLC · Pryor, OKBuilt 1975 · S/N 21060890N52761Reb Baron Aviation LLC · Riverdale, CAS/N 18262828N52764Skylane LLC · Williamsburg, VABuilt 1974 · S/N 18262831N52765Benson Daniel P · Lake Placid, FLBuilt 1977 · S/N 177RG1267
Back to AD 87-20-03 R2