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.

N7671XBernsen Timothy Stephen · Devine, TXS/N 17248171N7672ATram Enterprises LLC · White, GAS/N 32569N7672XFlying Couch LLC · Orleans, MABuilt 1961 · S/N 17248172N7673GSchaack Lawrence A · Woods Cross, UTBuilt 1970 · S/N 17259373N7673TDunning Steve G · Assaria, KSBuilt 1960 · S/N 47273N7673XDunham Randy C DBA · Lawton, OKBuilt 1960 · S/N 17248173N7674KToms Robert G · Holly, MIS/N 18052698N7674MMezzell James H · Cullman, ALBuilt 1959 · S/N 55974N7674TDugger Robert F · Ashville, ALBuilt 1960 · S/N 47274N7674UBischoff Daniel C · Camano Island, WAS/N 15077800N7675GHalopoff Guy · Oroville, CABuilt 1973 · S/N 15074713N7675TClegg Peter M · Grace, IDS/N 47275N7675UWaite Trevor K · South Ogden, UTBuilt 1976 · S/N 15077801N7675XEstes Jerry L · Lewisville, ARBuilt 1960 · S/N 17248175N7676GPalmer Michael C · Emmett, IDBuilt 1970 · S/N 17259376N7676MWhite Hawk Leasing LLC · Chapel Hill, NCS/N 55976N7676TNickerson David W · East New Market, MDBuilt 1960 · S/N 47276N7676URhine Steven L · Vancouver, WABuilt 1976 · S/N 15077802N7677UOrser Shana J · Kissimmee, FLBuilt 1976 · S/N 15077803N7678AHenderson William H Trustee · Eagle River, AKBuilt 1956 · S/N 32575N7678GTanner Michael J · Hooksett, NHS/N 17259378N7678XSandstone Point Cattle Co LLC · Seguin, TXBuilt 1960 · S/N 17248178N7679GShipp-Hove Kylan · Mesa, AZBuilt 1970 · S/N 17259379N7679MRothgeb Michael A · Burns, ORBuilt 1959 · S/N 55979N7679UDebenedetto John · Northwood, NHBuilt 1976 · S/N 15077805N767CDTyler Flyers Inc · Tyler, TXBuilt 1979 · S/N 17273607N767CGMindy Limited LLC · Muscatine, IAS/N 17269309N767GGabbard Michael · Jupiter, FLBuilt 1979 · S/N R18200900N767RAClear Prop Aero Inc · Webster, MNBuilt 1959 · S/N 47078N767RFAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N P21000161N767RSRegistered aircraftBuilt 1958 · S/N 51140N767RWWhitt Robert L · Carolina Beach, NCBuilt 1977 · S/N 15079378N767WDLibby William J · Hooksett, NHBuilt 1978 · S/N R18200862N7680GGulyash Michael J · Ukiah, CAS/N 17259380N7680KStripe Joseph R · Olympia, WAS/N 18052700N7680YMeekin Michael J · Palmer, AKBuilt 1961 · S/N 1850190N7681GCompass Aviation Inc · Shelby, NCBuilt 1970 · S/N 17259381N7681KNewberry Robert L · Lakeland, FLBuilt 1976 · S/N 18052701N7681UTunnel Electric Inc · Shingle Springs, CAS/N 21064975N7682MVan De Hei Mike · Pioneer, CABuilt 1959 · S/N 55982N7682TPittsburgh Institute Of Aeronautics · West Mifflin, PAS/N 17249073N7682UTech Flight Corp · South Hamilton, MAS/N 15077808N7682XRosenlof Dean F · Tempe, AZBuilt 1961 · S/N 17248182N7683GBalgoyen James T · Charlotte, MIBuilt 1970 · S/N 17259383N7683MHarmon Katlyn E · Gypsum, COS/N 55983N7683TCleary Michael A · Folsom, CABuilt 1960 · S/N 47283N7684KWard Keven R · Juneau, AKBuilt 1976 · S/N 18052702N7685AAnderson Clarence D Trustee · Anchorage, AKBuilt 1956 · S/N 32582N7685MLazy Double Air LLC · Bloomer, WIBuilt 1980 · S/N R18201583N7685NFranklin Construction Inc · Chico, CAS/N 21063247
Back to AD 87-20-03 R2