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.

N7271AEinck Matthew J · Fort Worth, TXS/N 29371N7271SWalker Kevin · Stillwater, OKBuilt 1967 · S/N 15067971N72727Hice Michael D · Cookeville, TNBuilt 1971 · S/N 177-01678N7272AOpen Air Ltd Co DBA · Pella, IABuilt 1956 · S/N 29372N7272EMonro Andrew C · Columbia X Rd, PAS/N 52272N7272KPearson Zachary B · Hayden, IDBuilt 1952 · S/N 20412N7272SRegistered aircraftBuilt 1967 · S/N 15067972N7273AMartin Randal O · Oak Point, TXBuilt 1956 · S/N 29373N7273SFerguson Jeffrey Woods · San Antonio, TXBuilt 1967 · S/N 15067973N7274GFlyit LLC · Washougal, WABuilt 1973 · S/N 15074632N7274MPearson Russell · Fairfield, MTS/N 55574N7274TN8653u LLC · Fairbanks, AKBuilt 1959 · S/N 46874N7274XFuellner Sean L · Shelocta, PABuilt 1962 · S/N 15059374N7275AZelinski Jeffrey C · Watersmeet, MIS/N 29375N7275TBeets Larry Joe · Columbia, MSBuilt 1959 · S/N 46875N7276AAved Consulting LLC · Edgewater, FLBuilt 1956 · S/N 29376N7276MMcneil Larry D · Portal, AZBuilt 1958 · S/N 55576N7276NDancer Aviation LLC · Delphos, OHBuilt 1976 · S/N U20603597N7276SMorgan Michael · Wichita, KSBuilt 1967 · S/N 15067976N7276TBraner Richard C Trustee · Oakdale, CABuilt 1959 · S/N 46876N7276XEvv 150 LLC · Evansville, INBuilt 1961 · S/N 15059376N7277ADrzewiecki Chad M · Cuyahoga Falls, OHBuilt 1952 · S/N 29377N7277SMarkland Benjamin Harrison · Lehigh Acres, FLBuilt 1967 · S/N 15067977N7277TStrehler Stanford L · League City, TXBuilt 1959 · S/N 46877N7278EAlvarez Scott · Battle Ground, WABuilt 1959 · S/N 52278N7278NPerry Christopher W · West Sacramento, CAFirst renewal noticeBuilt 1974 · S/N 18263065N7278TChudy Daniel B · Yucaipa, CAS/N 46878N7279AGoerger Allan E · Barney, NDBuilt 1956 · S/N 29379N7279EXtreme Divers West Inc · San Juan, PRS/N 52279N7279GMartin Rick · Rindge, NHBuilt 1973 · S/N 15074633N7279SLee Peter Joohak · Irvine, CABuilt 1967 · S/N 15067979N727BSHorvath Andrew J · Winnsboro, SCBuilt 1966 · S/N 15064667N727CMoore Kelly M · Moscow, IDBuilt 1958 · S/N 51319N727DCCalianno David · Spring Hill, FLBuilt 1974 · S/N 17702086N727DGMarsh David G · Bluffdale, UTBuilt 1955 · S/N 31710N727DRRoss Trucking LLC · Goldendale, WAS/N U206-0556N727FValiair Ltd Co Trustee · Casper, WYBuilt 1981 · S/N P21000727N727FACorporate Services LLC · Baton Rouge, LAS/N 21059414N727FKVan Schoonhoven Peter · Battle Ground, WABuilt 1967 · S/N 21058912N727GLRheney John W III · Cameron, SCBuilt 1976 · S/N 18264939N727HMPatterson Casey Paul · Kinston, ALS/N 15066715N727JTStory Billy G · Kempner, TXBuilt 1965 · S/N 337-0200N727KDReich Brad Roy · Rohnert Park, CAS/N 17254281N727LBMcnamee John B · Sugar Land, TXBuilt 1974 · S/N 177RG0626N727LCBurmaster Christopher R · Murfreesboro, TNBuilt 1966 · S/N 17254788N727LGYouth & Aviation Inc · Thiensville, WIBuilt 1968 · S/N 17256938N727LHHale John A · Ennis, MTBuilt 1965 · S/N P206-0085N727LSScarsella Luciano S · Lafayette, LAS/N 18265755N727METruesdell Shannon · Stephenville, TXBuilt 1976 · S/N 17268426N727NEDeeair Ltd · Dayton, OHBuilt 1979 · S/N U20605152
Back to AD 87-20-03 R2