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.

N5857ABrandt Jeff D · Ankeny, IABuilt 1956 · S/N 28457N5857BObrien Terence · Bonney Lake, WABuilt 1956 · S/N 33857N5857GWhitver Jeremy W · Ankeny, IABuilt 1969 · S/N 15071357N5857RWaypoint Equipment LLC · Mckinney, TXBuilt 1966 · S/N 17253526N58580Trgn LLC · Charleston, WVBuilt 1973 · S/N 18262153N58582Hunsaker Joshua James · Turner, ORBuilt 1973 · S/N 18262154N58583Triesch Charles · Houston, TXBuilt 1973 · S/N 18262155N58586Bullock Gary L · Saint Regis, MTBuilt 1973 · S/N 18262158N5858AMadey Benjamin · Ghent, NYBuilt 1956 · S/N 28458N5858RNitz Terry L · Fredericksburg, VABuilt 1965 · S/N 17253527N5858TAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 18266683N58591Blue Skies Aero Club · Redmond, WABuilt 1973 · S/N 18262162N58593North Kern Aviation Inc · Wasco, CABuilt 1973 · S/N 18262164N58597Smith John N · Martinsville, INBuilt 1973 · S/N 18262167N5859BGrant Marsall M · Truckee, CABuilt 1956 · S/N 33859N5859JWillis Tyler L · Wasilla, AKS/N 18501819N585BBStrickland Tracy · Driggs, IDBuilt 1973 · S/N 18262136N585CMMandes George J · Homer, AKS/N 18504099N585DBCoppeta Alfred J · Altoona, PABuilt 1973 · S/N 18262120N585PMN585pm LLC · Worthington, OHBuilt 1977 · S/N 18503451N585ZDairy Air LLC · Van Nuys, CABuilt 1977 · S/N 18503266N58601Baker Ranches Inc · Baker, NVBuilt 1973 · S/N 18262169N58602Leatherwood Aviation LLC - Rs N58602 · College Station, TXBuilt 1973 · S/N 18262170N58607Pendlebury David A · Pittsboro, NCS/N 18262172N5860AMrd Aero LLC · Manheim, PAS/N 28460N5860FThomas Kirk F · Corpus Christi, TXBuilt 1967 · S/N 21058860N5860GRegistered aircraftBuilt 1969 · S/N 15071360N5860JMcclain Kevin D · Westminster, CABuilt 1975 · S/N 18263567N5860RSkyhawk Ventures LLC · Boise, IDBuilt 1965 · S/N 17253529N58620Ries Farms LLC · Hastings, MNBuilt 1973 · S/N 18262179N58624Hoefer Bradley W · Steamboat Springs, COFirst renewal noticeBuilt 1973 · S/N 18262182N58626Rainbow Flight Inc · Felda, FLBuilt 1973 · S/N 18262184N58628Alste LLC · Seattle, WABuilt 1973 · S/N 18262186N5862ASanders Mark R · Towner, COBuilt 1956 · S/N 28462N5862BJac & Phill Corp · San Ysidro, CAS/N 33862N5862JChase Benjamin A · West Chesterfield, NHBuilt 1975 · S/N 18263569N5862RMcgowan Keegan M · San Antonio, TXBuilt 1965 · S/N 17253531N58631Strickler Hayden B · Euclid, MNS/N 18262188N58633Trisha Parker Real Estate Inc · Port Angeles, WAS/N 18262190N58634Poutre Robert P · Osceola, WIBuilt 1973 · S/N 18262191N58635Decourley Claudette · San Diego, CABuilt 1973 · S/N 18262192N58636Adventist World Aviation Inc · Wilson, NCBuilt 1973 · S/N 18262193N5863ADabney Richard W · Tanner, ALBuilt 1956 · S/N 28463N5863BBales Charles F · Altadena, CABuilt 1956 · S/N 33863N58641Goodell Scott W · Humboldt, IAS/N 18262198N58645Bishop Chuck W · Gilbert, AZBuilt 1973 · S/N 18262201N58646Capper Flying Club Inc · Lancaster, CABuilt 1973 · S/N 18262202N58647Omara Timothy · Tampa, FLBuilt 1972 · S/N 18052277N5864AS Aviation LLC · Wisconsin Dells, WIBuilt 1956 · S/N 28464N5864BKavanaugh James M · Gilbert, AZBuilt 1956 · S/N 33864
Back to AD 87-20-03 R2