OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,016

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.

N1129USchroeder Herbert D · Plano, TXBuilt 1976 · S/N 17266858N112APAerospace Trust Management LLC Trustee · Wilmington, DES/N 17262038N112DSCarter Erick D · Eugene, ORBuilt 1977 · S/N 18265826N112EWKerwin Patrick C · Redwood City, CABuilt 1974 · S/N 21060504N112GCSkywagon Ventures LLC · Chapel Hill, NCBuilt 1973 · S/N 18052387N112NBillingsley Carl · Henderson, TXBuilt 1956 · S/N 28584N112NBCarew Enterprises Inc · Appleton, WIBuilt 1973 · S/N 15074671N112NCFrance Jay D · Colbert, GABuilt 1970 · S/N 17701598N112NL1st American Aviation Inc · North Miami, FLS/N 18258322N112QBFloyd Austin · Searcy, ARBuilt 1955 · S/N 26952N112RPTaylor Chad A · Enid, OKBuilt 1950 · S/N 19422N112SSOlsen John · Wasilla, AKS/N 18052510N112THHanson David J · Elgin, TXS/N 15280204N112VBHatley Ralph A · Eagle Creek, ORBuilt 1963 · S/N 18254937N11305Logsdon Elizabeth M · Morganfield, KYBuilt 1973 · S/N 15075314N11308Kaher Kevin G · Menlo Park, CABuilt 1973 · S/N 15075317N1130FMonahan William T · Vestal, NYBuilt 1966 · S/N 17254725N1130UTc Aviation LLC · Denham Springs, LAS/N 17266859N1131MWhite Tom · South Charleston, WVBuilt 1975 · S/N 18264228N1131WPrice Steven D · Healdsburg, CABuilt 1976 · S/N 18264584N11322Creekside Speech Therapy LLC · Ocala, FLBuilt 1973 · S/N 15075328N11323Huckabay Timothy J · Red Bluff, CABuilt 1973 · S/N 15075329N11329Burkhart Verlus L · Fairmont, MNBuilt 1973 · S/N 15075332N1132UMjolhus Knut G · Amarillo, TXBuilt 1982 · S/N 21064669N11330Leikala Douglas A · Fairport Harbor, OHBuilt 1975 · S/N 17702332N11331Gervais Andre B · Griffin, GABuilt 1973 · S/N 15075334N11332Byrd Craig Stephen · Laurel, MSS/N 15075335N1133FFinnelly Barry J · Snohomish, WABuilt 1966 · S/N 17254728N1133MRobinson Lanis A · Clanton, ALBuilt 1970 · S/N 15071733N1133UMustachio Donald · East Stroudsburg, PABuilt 1976 · S/N 17266862N1134FScialabba John E · Columbus, OHBuilt 1966 · S/N 17254729N1134UWells William L · Santa Cruz, CABuilt 1976 · S/N 17266863N11351Lanier Equipment Leasing LLC · Gainsville, GABuilt 1973 · S/N 15075343N11352Kimmel Nathan · Lancaster, PABuilt 1973 · S/N 15075344N11353Denmark Brooks Mclaughlin · Clayton, NCS/N 15075345N11356Melton Joseph W · Conway, ARS/N 15075348N11358Lavalle David · Centerburg, OHBuilt 1973 · S/N 15075350N1135FLong Duane C · Baskin, LAS/N 17272961N1135MLopez Ferco Capdevila · Port Saint Lucie, FLS/N 15071735N1135YSwanson Isaac · Wasilla, AKS/N 15059535N11363Fireland Christopher G · Brownwood, TXS/N 15075354N11365Kimberk Frederick S · Cambridge, MABuilt 1973 · S/N 15075355N11366Registration Pending · Jacksonville, FLRegistration pendingBuilt 1973 · S/N 15075356N11367Canniff Dustin P · Sutton, AKBuilt 1973 · S/N 15075357N11368Adkins Ian B · Dahlonega, GABuilt 1975 · S/N 17702333N11369Abrams Adrian L · Palmer, AKS/N 15075359N1136GBurnside Thomas L · Kansas, ILBuilt 1978 · S/N 18266300N1136MHiggins Derrick · Arbyrd, MOBuilt 1970 · S/N 15071736N11371Sale Reported · Thomaston, GASale reportedBuilt 1973 · S/N 15075361N11373Huffman Aviation LLC · Burleson, TXBuilt 1973 · S/N 15075363
Back to AD 87-20-03 R2