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.

N60956Mcclellen Mark C · Mccall, IDBuilt 1980 · S/N 18504083N60959Cruz Abdiel Ayala · Ocala, FLBuilt 1969 · S/N 15070697N6095ESmith Douglas Derek · Mebane, NCBuilt 1980 · S/N 18503996N6095FPlane Partners LLC · Navarre, FLBuilt 1975 · S/N 18264110N6095JWaterman David K · Temple City, CABuilt 1973 · S/N A1500395N6095RWilbanks James R · Clayton, GABuilt 1965 · S/N 17253764N6095VCessna 170b LLC · Eagle River, AKS/N 20724N60962Barnstormers Inc · Bemidji, MNBuilt 1969 · S/N 15070699N60967Salyer Robert D · Nashville, TNS/N 15070701N60968Nelson Gary A · Grand Marais, MNBuilt 1969 · S/N 15070702N60969Northwest Aviation LLC · Whitefish, MTBuilt 1980 · S/N 18504085N6096GPilot Pros Inc · Miami, FLBuilt 1969 · S/N 15071596N6096JCurrivan Robert B · Fort Mohave, AZS/N A1500396N60970Airfrank Inc · Hackensack, NJBuilt 1969 · S/N 15070704N60976Fly Low Aviation LLC · Smithville, MSS/N 15070709N6097BBenavidez Robert · Deming, NMBuilt 1957 · S/N 34097N6097MPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 15284621N6097RBravo Charlie One LLC · Redkey, INBuilt 1965 · S/N 17253766N6097TDuffy Thomas J · Hollis, NHS/N R18201902N60982Taylor Gregory William II · Angels Camp, CABuilt 1969 · S/N 15070714N60983Jpm Aircraft Leasing LLC · Wilmington, DES/N 15070715N60988Cluck Charles W · Spring, TXBuilt 1969 · S/N 15070718N6098AMcknight Christopher M · Nampa, IDBuilt 1957 · S/N 180-32943N6098BMarranca James · Buffalo, NYBuilt 1957 · S/N 34098N6098DShurtleff Russell D · Tunkhannock, PABuilt 1979 · S/N 17272602N6098JHall David K · State College, PABuilt 1973 · S/N A150-0397N60995Replogle Thomas J · Redondo Beach, CAFirst renewal noticeBuilt 1969 · S/N 15070721N6099AAnderson Timothy D · Mountain Iron, MNBuilt 1956 · S/N 28699N6099BWilson Stuart · North Franklin, CTBuilt 1957 · S/N 34099N6099FTreat Gary DBA · Yakima, WABuilt 1975 · S/N 18264114N6099JVincent David R · Hartley, TXBuilt 1973 · S/N A1500399N6099WGriffith Aviation Co · Tulsa, OKBuilt 1981 · S/N P21000713N609DCBarber Aircraft LLC · Topping, VABuilt 1975 · S/N 17265563N609DSTj Air Holdings Inc · Wilmington, DEBuilt 1981 · S/N T30300025N609KYMorrison Neil E · Port Townsend, WABuilt 1967 · S/N R172-0225N609PCKoufi Airline Inc Trustee · Wilmington, DEBuilt 1975 · S/N 18263417N609RLT And B Mgmt LLC · Las Vegas, NVBuilt 1979 · S/N 21063802N60AKSchmidt Jason A · Wasilla, AKBuilt 1980 · S/N 18504157N60CHCutler Scott D · Tumwater, WABuilt 1950 · S/N 19535N60DWJohnson Boyd · Apple Valley, MNBuilt 1981 · S/N P21000696N60ECWright Zach · Spicewood, TXBuilt 1979 · S/N 18503913N60GAGlidewell Aviation Inc · Parkland, FLBuilt 1978 · S/N 17271354N60HEagle Flight Squadron Inc · East Orange, NJBuilt 1973 · S/N 17261653N60HFTexas Flying Club Inc · Bryan, TXBuilt 1977 · S/N 17270210N60MKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N P21000670N60MWArt & Carolyn Inc · Winter Park, FLS/N 52447N60PEMagliacano Matthew J · Cleveland, MOFirst renewal noticeBuilt 1952 · S/N 20799N60PKWexcap Leasing LLC · Centerville, UTS/N 21064916N60QMcleod Cecil H · Mt Pleasant, SCBuilt 1954 · S/N 16131N60RSVolare Alto LLC · Sanford, NCBuilt 1980 · S/N P21000521
Back to AD 87-20-03 R2