OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N2184FCarr Cassandra C · San Antonio, TXBuilt 1965 · S/N U206-0384N2184QMallette Carl L · Knoxville, TNBuilt 1974 · S/N 177RG0584N2184RHatbox LLC · Snohomish, WAS/N 18255384N21852Peralta Jose Ramon · Sinking Spring, PAFirst renewal noticeBuilt 1972 · S/N 18801075N2185CRichards William R · Columbus, INBuilt 1955 · S/N 16170N2185EMckenzie Owen R Jr · Burlington, NCBuilt 1978 · S/N 17271182N2185QCarlson Bruce D · Umatilla, ORS/N 177RG0585N2185ULethin Savanna C · Anchorage, AKBuilt 1974 · S/N U20602354N21861Round Engine Aero · Nashville, MIS/N 18801082N2186CBucher Burton W · North Chicago, ILBuilt 1955 · S/N 16171N2186FBranchaud Crystal J · Anchorage, AKBuilt 1965 · S/N U2060386N2186QBlue Streak LLC · Athens, GAS/N 177RG0586N2186XAshiku Phillip · Ukiah, CABuilt 1965 · S/N 337-0086N21878Lie Chris E · Kotzebue, AKBuilt 1974 · S/N 17264038N2187CEnvisage LLC · Virginia Beach, VAS/N 16172N2187GRegistered aircraftBuilt 1958 · S/N 51487N21883Stevenson Flying Service LLC · Selden, KSBuilt 1972 · S/N 18801098N21887Gilheany Robert V · Hicksville, NYBuilt 1974 · S/N 17264039N2188GDisastermarks LLC · Miami, FLBuilt 1958 · S/N 51488N2188ZAlbright Duane C · Wasilla, AKBuilt 1963 · S/N 18051288N21893Western Territory Flyers LLC · Fairfax, CABuilt 1974 · S/N 17264040N218CCSotally Tober LLC · Wilmington, DEBuilt 1979 · S/N 21063297N218EABauer Todd A · Kenmare, NDBuilt 1970 · S/N 17259583N218HIverson Timothy A · Maple Grove, MNS/N R1722840N218JAWildwood Helicopter Co Inc · Wildwood, NJBuilt 1981 · S/N 15285307N218PPSumrell James E III · Bumpass, VABuilt 1976 · S/N 172-67520N218RARozo Jhon B · Orlando, FLBuilt 1975 · S/N 17265450N218WSeaplane Adventures LLC · Cheyenne, WYS/N 18255649N218ZMSkylink Xpress Inc · San Bernardino, CABuilt 1977 · S/N 15280011N21900Odonnell Edward T · Waconia, MNBuilt 1973 · S/N 15074521N21902Sleeping Giant Flying Club Inc · Helena, MTBuilt 1973 · S/N 15074523N21904Ragsdale Justin S · Bartlett, TNBuilt 1973 · S/N 15074525N21908Harrison Robert W · Oak Harbor, WAS/N 15074528N2190CSchmiedt Daniel M · Westminster, SCBuilt 1955 · S/N 16175N2190FSachs Peter T · Naperville, ILBuilt 1965 · S/N U206-0390N2190GScapegoat Aviation LLC · Choteau, MTBuilt 1958 · S/N 51490N21917Kinser Jay · Monrovia, MDS/N 15074534N21919Gustafson Dean F · Mercer, WIBuilt 1973 · S/N 15074536N2191FOhlinger Michael B · Mission, TXBuilt 1965 · S/N U206-0391N2191R2gl P&I LLC · El Paso, TXS/N 18255391N2191YDecker Ronnie L · Meno, OKBuilt 1962 · S/N 17249691N21923Averett Jeremy J · Liberty, UTS/N 15074540N21924Berwick Mark A · Emmett, IDBuilt 1973 · S/N 15074541N21929Holland Roy Morgan · Santa Maria, CABuilt 1973 · S/N 15074544N2192CHamann David L · Los Lunas, NMBuilt 1955 · S/N 16177N2192GWood Kyle A · Soldotna, AKBuilt 1958 · S/N 51492N2192QAdams Kenny G · Phelan, CABuilt 1974 · S/N 177RG0592N2192XGoldsmith Alejandro J · Houston, TXBuilt 1965 · S/N 337-0092N2192ZTalbott Erin W · Palouse, WAS/N 18051292N21930Bonnett Paul R · Pine Valley, CABuilt 1973 · S/N 15074545
Back to AD 87-20-03 R2