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.

N55LGWard Randy · Port Saint Lucie, FLS/N 17256728N55LHL H Aviation LLC · Clanton, ALBuilt 1955 · S/N 26927N55LWLeeward Aero Sales Corp · Ocala, FLS/N 1851185N55MStevens Donald K · Canton, GABuilt 1949 · S/N 7408N55MBSimon Caesar · Carmel, CABuilt 1978 · S/N 18266750N55MPCommanche LLC · Slatington, PAS/N 177RG0668N55MRQc Executive Aviation LLC · Sheridan, WYBuilt 1974 · S/N 18262983N55NABloomhardt Theodore E · Hinesburg, VTBuilt 1974 · S/N 18262915N55NSBrown Nelson S · Auburn, WABuilt 1955 · S/N 31469N55PFBurris Adam Eugene · Graham, WABuilt 1966 · S/N 18257888N55PGGonzalez Pota H · Seguin, TXBuilt 1968 · S/N 17257793N55QBSainthill Raymond C · Long Beach, NYS/N 17269080N55RHMccarthy Michael E · Martinez, CABuilt 1969 · S/N P206-0584N55RXJs Enterprises LLC · Clarinda, IABuilt 1981 · S/N 21064586N55SFRegistered aircraftBuilt 1979 · S/N R18201016N55SNHussey Arthur M III · Fairbanks, AKBuilt 1964 · S/N 18255199N55WBMetro Flyers Ltd · Wilmington, DEBuilt 1975 · S/N 18263900N55WMBankston Jeffery · Rice, TXBuilt 1978 · S/N R18200757N55YPBmf Jax LLC · Jacksonville, FLS/N F1721930N560Carter Brooks LLC · Kalispell, MTBuilt 1979 · S/N P3370330N5600AJessup Modeana M · Wilbur, WABuilt 1956 · S/N 28200N5600BParks Darryl D Trustee · Eagle River, AKBuilt 1956 · S/N 33600N5600GChimera Air Inc · Maumee, OHBuilt 1969 · S/N 15071100N5600RBreland Gerald Monroe Sr · Bogalusa, LABuilt 1965 · S/N 17253207N5601AOsceola Aerosport LLC · Osceola, WIBuilt 1956 · S/N 28201N5601EMarshall Joseph · Uniontown, OHBuilt 1983 · S/N 18268333N5601JGoos Lynn A · Silver City, IABuilt 1974 · S/N 18263458N5602ALooney Hubert · Florissant, MOBuilt 1956 · S/N 28202N5602TBerg William J · Aberdeen, SDS/N 17251502N5603JMiller Duane A · Redlands, CABuilt 1974 · S/N 18263460N5603RRegistered aircraftBuilt 1965 · S/N 17253211N5604JJohnson David A · Sunrise Beach, TXBuilt 1974 · S/N 18263461N5604RSkunda Robert J · Hebron, OHBuilt 1965 · S/N 17253213N5604TAndrews Jeremy R · Walker, MNBuilt 1964 · S/N 17251504N5605AKlase Robert · Greenville, TXS/N 28205N5605GMartinez Ivan A · Oro Valley, AZS/N 15071105N5605JMajor Air LLC · Charleston, SCS/N 17273819N5605RCostello John M · Wichita, KSBuilt 1965 · S/N 17253214N5606GPinho Michel A · Santa Barbara, CABuilt 1969 · S/N 15071106N5607AGilbirds William M · Kansas City, MOBuilt 1956 · S/N 28207N5609BWinkelman Ronald A · Chugiak, AKBuilt 1956 · S/N 33609N5609TWestfall Gage T · Marietta, OKBuilt 1964 · S/N 17251509N560MAKrauss Solutions LLC · Debary, FLBuilt 1966 · S/N 15065142N560PCHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281915N560SFAllen Adam W · Sutter Creek, CABuilt 1974 · S/N 15075865N560SPProtea Group Management Services LLC · Carrollton, TXS/N R1722359N560ZHeslin Jon P · Sutton, MABuilt 1974 · S/N 17262889N5610ANielson Douglas W · East Troy, WIBuilt 1956 · S/N 28210N5610GInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 15071110N5610JRael Pedro G · Los Lunas, NMBuilt 1974 · S/N 18263465
Back to AD 87-20-03 R2