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.

N88666Vincze Andras · Anchorage, AKBuilt 1957 · S/N 32778N8866SZimmer Linda S · Hillsboro, ILBuilt 1965 · S/N 15062166N8866TTrachta Stanley J · Tucson, AZBuilt 1960 · S/N 52766N8867BCowan Rena E · Pleasant Hill, ORBuilt 1958 · S/N 36567N8867GDavis Robert M · Liberal, KSBuilt 1966 · S/N 15062967N8867SCooper-White Michael L · Orrtanna, PABuilt 1965 · S/N 15062167N8867TCusimano Louis C · Montauk, NYBuilt 1960 · S/N 52767N8867UHoffman Robert E · Blossvale, NYBuilt 1965 · S/N 17252782N8868SMeriwether John N · Prairie Village, KSBuilt 1965 · S/N 15062168N8868TKlein Ryan L · Tijeras, NMBuilt 1960 · S/N 52768N8868UMuller Robert J · River Falls, WIBuilt 1965 · S/N 17252784N8869TDonaldson Lucas Paul · Owyhee, NVS/N 52769N8869XAshley Heating And Air Conditioning · Wasilla, AKBuilt 1961 · S/N 18253269N886KHLexi Air LLC · Boise, IDBuilt 1977 · S/N 21061727N88717Copp Mathew J · Cumberland, MEBuilt 1969 · S/N 18260100N8871BSing Clifford J Trustee · Idaho Falls, IDBuilt 1958 · S/N 36571N8871GHukill Warren J · Oakland, CABuilt 1966 · S/N 15062971N8871UWichmann William C · Owasso, OKBuilt 1965 · S/N 17252787N8871XRegistered aircraftBuilt 1961 · S/N 18253271N8872GN8872g Holdings LLC · Nashville, TNBuilt 1966 · S/N 15062972N8872SAeronautical Technical Service Inc · Collierville, TNS/N 15062172N8873BPathfinder Aerospace LLC · Raeford, NCBuilt 1958 · S/N 36573N8873GHarris David J · Aguila, AZBuilt 1966 · S/N 15062973N8873UOlafsen George F · Greeneville, TNBuilt 1965 · S/N 17252789N8874GEluwawalage Damayanthie · Reading, PABuilt 1966 · S/N 15062974N8874TFletcher Edwin R Jr · Flowery Branch, GAFirst renewal noticeBuilt 1960 · S/N 52774N8875TDelahunty Brian E · Ocala, FLBuilt 1960 · S/N 52775N8875UDunaire LLC · Mechanicsburg, PAS/N 15078009N8876BBeryl Aviation LLC · Omaha, NEBuilt 1958 · S/N 36576N8876XBowen Gabriel J · Salt Lake City, UTBuilt 1960 · S/N 18253276N88778Hubbard Austin L · Somerton, AZS/N R172-0128N88779Drexler Daniel L · Harrison, TNS/N R1720132N8877TAnderson Robert M · Merritt Island, FLBuilt 1960 · S/N 52777N8877USmith Stephen A · Aloha, ORBuilt 1965 · S/N 17252794N8878UBallard Ralph T · Hurricane, UTBuilt 1976 · S/N 15078011N8879BKatsahnias George T · Denton, TXBuilt 1958 · S/N 36579N8879XKlingelhoffer Jeffrey A · Olympia, WABuilt 1961 · S/N 18253279N887CMHigh Top LLC · Leclaire, IABuilt 1979 · S/N 18267314N887JBBertrand Carolyn L · Ridgecrest, CABuilt 1966 · S/N 337-0559N887PBZankiz Jose Carlos · Naples, FLBuilt 1968 · S/N U206-1062N887WQuad City Area Flying Eagles Inc · Milan, ILBuilt 1975 · S/N 21060976N887WBJones Brandon · West Bountiful, UTBuilt 1975 · S/N 18502708N8880Causey Dale L · Albuquerque, NMBuilt 1956 · S/N 28459N88808Thompson Patrick M · Madera, CABuilt 1974 · S/N 15076150N8880TAltitude Air LLC · Sheboygan Falls, WIBuilt 1960 · S/N 52780N8880UJackson Todd · Spirit Lake, IDBuilt 1976 · S/N 15078012N8881Steadfast Ministries · Alton, TXS/N 55308N8881NHero Enterprises LLC · Panama City Beach, FLS/N 18267508N8881VLien Ronald N · Gilford, NHS/N 17264240N8881XFluegel Justin D · Gresham, ORS/N 18253281
Back to AD 87-20-03 R2