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.

N6868FVan Bielert Wouter · Haxtun, COS/N 15063468N6868LJohnson Gregory L · Orange, CABuilt 1969 · S/N 18260147N6868RChrisman Charles Griggs · Denver, COS/N T210-0268N6868XRegistered aircraftBuilt 1960 · S/N 17247768N6869AMccraney John K · Canon, GAS/N 28969N6869XSquires Aaron Lane · Aynor, SCS/N 17247769N686DBAnderson Bruce Robert · Mena, ARS/N 172-68334N686MGMike Golf Holdings LLC · Pinellas Park, FLBuilt 1981 · S/N 18504314N6870ELentfer Sheryl A · Anchorage, AKBuilt 1959 · S/N 56370N6870MApplied Science Services Corp · Woodland Hills, CABuilt 1977 · S/N 21061998N68713Hillsboro Aero Academy LLC · Hillsboro, ORS/N 15285331N68714Registration Pending · Iuka, ILRegistration pendingBuilt 1981 · S/N 15285332N6871AGibson James G · Harpers Ferry, WVBuilt 1956 · S/N 28971N6872ACoats Alexander · Murrieta, CAS/N 28972N6872FSkybound Aircraft LLC · Blue Point, NYBuilt 1966 · S/N 15063472N6872GVortex Aircrafts Inc · Port Saint Lucie, FLBuilt 1973 · S/N 18801215N6872MShowalter Mark W · Richland, WABuilt 1975 · S/N 18263871N68735Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1978 · S/N 15282345N68736Lake Elmo Aero LLC · Lake Elmo, MNS/N 15282346N6873EWallace Joseph R · Winchester, KYBuilt 1959 · S/N 56373N68742Byars Cecil E · Tupelo, MSBuilt 1978 · S/N 15282351N6874AGillum Thomas W III · Davenport, IABuilt 1956 · S/N 28974N68750Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 15282356N68754Ace Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282358N6875EElston Josh · Sterling, AKS/N 56375N6875GStevenson Mark Frank · Anthem, AZBuilt 1970 · S/N 15072375N68767Snohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N 15282367N68768Harris Thomas W · Roseville, MNBuilt 1978 · S/N 15282368N6876EDunn Gary K · Paw Paw, ILBuilt 1959 · S/N 56376N6876FPalmer Dana G · Gatesville, TXBuilt 1966 · S/N 15063476N6876GMyers Russell E · Happy Jack, AZBuilt 1970 · S/N 15072376N6876HSt Charles County Flying Club LLC · Portage Des Sioux, MOBuilt 1975 · S/N 17265622N68775Gruca Paul G · Riverdale, MIBuilt 1981 · S/N 15285337N6877ASchenck Alan E · Clarinda, IABuilt 1956 · S/N 28977N6877EBell Connor C · Maple Valley, WABuilt 1959 · S/N 56377N6877HKoenig Ned · New Bremen, OHBuilt 1975 · S/N 17265623N6877XSwick Gerald K · Murfreesboro, TNBuilt 1960 · S/N 17247777N68789Sinden Donald L · Puyallup, WABuilt 1978 · S/N 15282374N6878XLinkinhoker Craig W · Carpentersville, ILBuilt 1960 · S/N 17247778N68799Smtm Holdings Inc · Wilmington, DEBuilt 1978 · S/N 15282382N6879EWilliams James W · Friendsville, TNS/N 56379N6879MCohen Robert · Buda, TXBuilt 1975 · S/N 18263884N6879XRegistration Pending · Farr West, UTRegistration pendingBuilt 1960 · S/N 17247779N687AZZublin John A III · Murrieta, CABuilt 1968 · S/N 17256592N68806G&M Aircraft Inc · Wheat Ridge, COS/N 15282383N68808Mrb Aviation Inc · Lexington, SCBuilt 1978 · S/N 15282384N6880EBartel Anthony E Jr · Ridgecrest, CABuilt 1959 · S/N 56380N6880MKing Dale C · Simi Valley, CABuilt 1975 · S/N 18263876N68810Air-Planes LLC · Soddy Daisy, TNBuilt 1978 · S/N 15282385N68812Avcorp Holdings Inc · Jackson, MIBuilt 1981 · S/N 15285339
Back to AD 87-20-03 R2