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.

N4265QParrish Aviation Flight Academy LLC · Southlake, TXS/N 17260165N4265VByler Jonathan P · Inman, SCBuilt 1948 · S/N 18623N4266298x LLC · Caddo Mills, TXBuilt 1968 · S/N 18259128N4266FCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1958 · S/N 46166N4266QMaxwell James B · Lewiston, IDBuilt 1971 · S/N 17260166N4266UDoyle Paddy B · Homedale, IDBuilt 1963 · S/N 15060266N42672Dowden Lairon W Jr · Nederland, TXBuilt 1968 · S/N 18259131N42673Chase Donald C · Erie, PABuilt 1968 · S/N 18259132N42678Merow Michael C · Algoma, WIBuilt 1968 · S/N 18259135N4267FValenzuela Kevin · Totowa, NJBuilt 1958 · S/N 46167N4267QDhf LLC · Valentine, NEBuilt 1971 · S/N 17260167N4267UZeiset Luke R · Manchester, TNBuilt 1964 · S/N 15060267N42687Cal Coast Reps Inc · Costa Mesa, CABuilt 1968 · S/N 18259138N42689Alc Aviation LLC · Waseca, MNBuilt 1968 · S/N 18259140N4268UWhitby Devin A · Dumfries, VABuilt 1964 · S/N 15060268N42693Paul D Barkhurst Pc · San Antonio, TXBuilt 1968 · S/N 18259141N42694Jaffa Bruce E · Moose Pass, AKBuilt 1968 · S/N 18259142N42698Bruch Stein · Randolph, MNBuilt 1968 · S/N 18259145N4269FPerkey Gilbert J Jr · Eagle Rock, VAS/N 46169N4269LBussey Stuart · Lafayette, CABuilt 1966 · S/N 17254338N4269VDouglas Phillip A · Fredericktown, OHBuilt 1948 · S/N 18627N426ASSaylor Alvin N Jr · Friendswood, TXBuilt 1970 · S/N P206-0590N426DLHawk30 Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172RG0827N426HLGiurtino Joel F · Spring Hill, FLBuilt 1977 · S/N 17269050N426MBTimothy Harty · New Richmond, WIBuilt 1984 · S/N 18504420N426MCMagic Carpet LLC · Wilmington, DEBuilt 1971 · S/N 17260022N426SKBergstrom Aircraft Inc · Pasco, WABuilt 1979 · S/N 17273720N426XARound Engine Aero · Nashville, MIS/N 15063198N42700Van Matre Thomas A Jr · Mineola, TXBuilt 1973 · S/N 18052371N42704White Dog I LLC · Bend, ORBuilt 1968 · S/N 18259149N42705Henry James A · Fresno, CABuilt 1968 · S/N 18259150N42707Management Assistance Group LLC · Hamilton, NJBuilt 1968 · S/N 18259152N4270LDavenport Sam · Gail, TXBuilt 1966 · S/N 17254339N4270QReeves James C · Locust Grove, GABuilt 1971 · S/N 17260170N4270USilvia Scott A · Valley Springs, CAS/N 15060270N42712Adams William Kelly · Tulia, TXBuilt 1968 · S/N 18259155N42713Prater Bobby D · Grand Ledge, MIBuilt 1968 · S/N 18259156N42714Crouch Jeffrey Lane Sr · Rockingham, NCBuilt 1968 · S/N 18259157N42715Coleman Robert B · San Francisco, CABuilt 1968 · S/N 18259158N42718Circle K Bar LLC · Ardmore, OKBuilt 1968 · S/N 18259161N4271FStevens George C · Lake Leelanau, MIBuilt 1958 · S/N 46171N4271LRoberts David W · Arden, NCS/N 17254340N42725Tepper Jeremy A · Vail, AZBuilt 1968 · S/N 18259165N4272FCayton John C · Cameron, MOS/N 46172N4272LStechbart Kurt E · Glendora, CABuilt 1966 · S/N 17254341N4272QKeech Mark A · Fairbanks, AKBuilt 1976 · S/N U20603042N4272VShaw Christopher · Porterville, CAFirst renewal noticeBuilt 1948 · S/N 18630N42732Wampole David R · Miami, FLBuilt 1968 · S/N 18259169N4273FVan Wychen James G · Warrens, WIBuilt 1958 · S/N 46173N4273QSimmons Robert J · Justin, TXBuilt 1971 · S/N 17260173
Back to AD 87-20-03 R2