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.

N5899TBrignac Flying Service LLC · Columbus, MSBuilt 1965 · S/N 1850799N589JSWings West Consulting LLC · Mesa, AZBuilt 1980 · S/N U20606384N589RRock & Roe LLC · Corpus Christi, TXBuilt 1975 · S/N 18264115N58BWarnick Ronald S · Cascade, MTBuilt 1968 · S/N 15068409N58BDBravan Aviation Inc · Fort Lauderdale, FLS/N 21062742N58CSierra 1 Tech Inc · Blue Jay, CABuilt 1973 · S/N P3370102N58CCPittsburgh Marine Technologies · Eighty Four, PABuilt 1981 · S/N R18201729N58DJPtc Financial Inc · Wilmington, DEFirst renewal noticeBuilt 1980 · S/N 21063920N58DSBalliet Edgar J III · Northampton, PABuilt 1979 · S/N 17272305N58DWWilson Daniel J · Mount Vernon, OHBuilt 1979 · S/N 18267139N58FAAlman Michael C · Fruitport, MIBuilt 1958 · S/N 55255N58GSCranford John · Douglassville, TXBuilt 1979 · S/N R18201412N58JKWander Aviation LLC · Klamath Falls, ORBuilt 1982 · S/N 18268286N58LJL&J Aviation Inc · Atwater, CABuilt 1985 · S/N 15285959N58MARagan Edwin E III · Austin, TXBuilt 1977 · S/N 21062237N58MGMullins Tennis Jr · Chapmanville, WVBuilt 1973 · S/N 18262358N58RRClover Management Systems Inc · Sanford, FLBuilt 1980 · S/N 18267545N58SDBrusasco John Mario Trustee · Portland, ORBuilt 1958 · S/N 50167N58TTBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 21062998N58TYJohnson Jake M · Texarkana, TXBuilt 1977 · S/N 17270111N58WKern Aviation LLC · Shafter, CABuilt 1960 · S/N 15059094N59007Hang On LLC · Montrose, COBuilt 1973 · S/N 21060014N59008Davis Burton D · Jefferson, IABuilt 1973 · S/N 21060015N5900AOlsen Porteous E · Houston, MNBuilt 1956 · S/N 28500N5900BEnvi Adventures LLC · Troutdale, ORS/N 33900N5900JAir America LLC · Sioux Falls, SDS/N A1500200N5900MBucher Burton W · North Chicago, ILBuilt 1956 · S/N 32330N5900RAidan Hammond · Ione, CABuilt 1965 · S/N 17253569N59011Nelson Albert N III · Baytown, TXBuilt 1973 · S/N 21060018N5901ACoulson Michael D · Zanesville, OHBuilt 1956 · S/N 28501N5901TWilliams Terry A · Hazlehurst, GABuilt 1964 · S/N 15060601N5902ASmith Kenneth W · Bedford, INBuilt 1956 · S/N 28502N5902FPeters Kenneth R · Plainfield, ILBuilt 1967 · S/N 21058902N5902RWojcik Dorene L · Cortland, OHS/N 17253571N5903AHunt Kenneth · Humble, TXBuilt 1956 · S/N 28503N5903BAbidance Inc · Winthrop, WAS/N 33903N5903GRybarczyk Mathias M · Rice Lake, WIS/N 15071403N59041Edwards Aviation & Consulting LLC · Broken Arrow, OKBuilt 1973 · S/N 21060044N59045Air-Zancada Inc · Wilmington, DEBuilt 1973 · S/N 21060046N59049Scarry David Charles · San Luis Obispo, CABuilt 1973 · S/N 21060049N5904B98x LLC · Caddo Mills, TXBuilt 1956 · S/N 33904N5904FRegistered aircraftBuilt 1967 · S/N 21058904N5904JHodge Marcus · Mansfield, LABuilt 1975 · S/N 18263572N5905JF92 Aviation Llp · Dover, OKBuilt 1975 · S/N 18263573N5905RSmart Harold J · Locust Grove, GABuilt 1965 · S/N 17253574N5905TThomas Paul C · Roberts, WIBuilt 1964 · S/N 15060605N59060Agriflite Services Inc · Wakarusa, INBuilt 1973 · S/N 21060059N5906AGnb Aviation LLC · Lake City, TNBuilt 1956 · S/N 28506N5906GBennett Cass · Oxnard, CABuilt 1969 · S/N 15071406N5906JErkie Norman R · Denison, TXS/N A1500206
Back to AD 87-20-03 R2