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.

N2525XTolbert Mark A · Canandaigua, NYBuilt 1977 · S/N 21061803N2525ZMansfield Scott J · Wasilla, AKBuilt 1962 · S/N 185-0525N25265My Toys Inc · Spartanburg, SCS/N 15280561N25269Yankaskas Kurt D · Ijamsville, MDBuilt 1977 · S/N 15280563N2526DThomas Joel Matthew · Bethel, AKBuilt 1956 · S/N 20678N2526RTalkeetna Denali View Lodge LLC · Talkeetna, AKBuilt 1967 · S/N 18258226N2526SPlane Nutz LLC · Sugar City, IDBuilt 1979 · S/N R18201347N2526XBolin David A · Kenmore, WAS/N P206-0026N2526YJahnke Ryan M · Grafton, WIBuilt 1962 · S/N 17249826N25271Byrnes Daniel P · Anchorage, AKS/N 15280564N2527CDuffy Lawrence R Jr · Vinemont, ALBuilt 1954 · S/N 26171N2527DSidders Michael E · Big Lake, AKS/N 20679N2527GRafter H Livestock · Rawlins, WYBuilt 1959 · S/N 51827N2527JHunt Wayne A · Delta Junction, AKBuilt 1964 · S/N 15061027N2527LWooten Craig J · Campobello, SCS/N 17255727N2527QTwenty Inc · Wilmington, DES/N 18257727N2527SCensair LLC · Santa Fe, NMBuilt 1967 · S/N 337-0827N2527VWright James C · Sulphur Springs, TXBuilt 1948 · S/N 18031N2527YSuazo Tito L · Glendale, AZBuilt 1962 · S/N 17249827N25284Riverside Flight Center Inc · Tulsa, OKBuilt 1977 · S/N 15280572N25286Recreational Enterprises LLC · Sanford, FLS/N 15280573N2528JMichael Matthew C · Ames, IAS/N 15061028N2528LWings Of Faith · Stevensville, MTBuilt 1966 · S/N 17255728N2528RHutchens Robert L II · Mocksville, NCBuilt 1967 · S/N 18258228N2528XButcher Collin E · Freeport, TXBuilt 1964 · S/N P206-0028N2528YHock Adam · Ankeny, IABuilt 1962 · S/N 17249828N2529JSale Reported · Geneva, OHSale reportedBuilt 1964 · S/N 15061029N2529UCampbell Alto L III · Pike Road, ALBuilt 1963 · S/N 17250129N252BBJagmin Michael · Chicago, ILBuilt 1950 · S/N 7571N252ERBeaurayne Holdings LLC · Prairieville, LABuilt 1978 · S/N 17271635N252GSWyoming Seaplanes LLC · Alpine, WYBuilt 1976 · S/N 18265179N252HPFino Al Cielo LLC · Jacksonville, FLBuilt 1983 · S/N 18268320N252JMMccallister Billy G · Virginia Beach, VABuilt 1963 · S/N 17250277N252KCPatton Steven W · Fayetteville, ARS/N 30964N252MTAero Quest LLC · Olive Branch, MSBuilt 1977 · S/N 15280407N252RAReynolds Darryl G · Wills Point, TXBuilt 1977 · S/N 17269911N252SBRoberts Christopher E · Anchorage, AKS/N 17270764N252SWSymns Robert A · Aguila, AZBuilt 1978 · S/N 21063029N252WCMosier Paul L · Ventura, CABuilt 1979 · S/N 15284145N25301Southern Arkansas University Technical Branch · Camden, ARBuilt 1977 · S/N 15280581N25302Steiner Jason A · Sabetha, KSBuilt 1977 · S/N 15280582N2530GRegistered aircraftBuilt 1959 · S/N 51830N2530KInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 18052972N2530LSholes Lance M · Oregon City, ORBuilt 1966 · S/N 17255730N2530PKingsley Kiman J · Miller, MOBuilt 1950 · S/N 19775N2530RHines David L · Lancaster, CABuilt 1967 · S/N 18258230N2530VAnderson Jeffrey L · Harrisburg, SDBuilt 1974 · S/N 177RG0604N2530YHarbour William T Jr · Mobile, ALBuilt 1962 · S/N 17249830N2531DAnderson Eric J · Great Falls, MTBuilt 1952 · S/N 20683N2531JCrowder Jr Thomas E · Whitesburg, GABuilt 1964 · S/N 15061031
Back to AD 87-20-03 R2