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.

N2287RTail Winds To The Island Inc · Ashland, KYBuilt 1969 · S/N T210-0437N22882Vasiliou Adamos C · Burtonsville, MDBuilt 1968 · S/N 15068586N22886Sky High Adventures LLC · Wilmington, DEBuilt 1968 · S/N 15068589N2288GSkydive Buckeye LLC · Buckeye, AZBuilt 1958 · S/N 51588N22892Miller Frank L · Ninilchik, AKBuilt 1968 · S/N 15068593N22893Hoffer Patrick N · Orr, MNBuilt 1968 · S/N 15068594N22897Donn Rex · Washington, UTS/N 15068598N228ANCalifornia In Nice Inc · San Jose, CABuilt 1981 · S/N 17274354N228ARHurricane Creek Flying Club LLC · Walla Walla, WABuilt 1979 · S/N 17273580N228CABowles Thomas J · Prairie Village, KSBuilt 1981 · S/N R18201686N228CJSplashin LLC · White Lake, MIBuilt 1977 · S/N 17269610N228CPColumbia Pacific Aviation Inc · Moses Lake, WABuilt 1978 · S/N 18266514N228HPLance Reid Enterprises LLC · Turlock, CABuilt 1980 · S/N R18201643N228JASky Port Inc · Kalispell, MTBuilt 1976 · S/N 18265111N228KYPapalote Ranches LLC · Missoula, MTBuilt 1978 · S/N R1722883N228NYFerguson Colt W · Wolf Point, MTBuilt 1959 · S/N 46482N228TFTop Flight Aviation Inc · Corona, CABuilt 1979 · S/N 17273426N228TMMacs Seaplane Service LLC · Milan, INS/N 17270902N228WBSnell Jeffrey D · Inver Grove, MNBuilt 1974 · S/N 17263032N228ZFFandrich Edward I · Payson, AZS/N 18502461N22900Swanton Jed M · Shawnee, KSBuilt 1968 · S/N 15068601N22902Easterling William R · Pikeville, NCBuilt 1968 · S/N 15068603N22903Walther Newell A · Wasilla, AKBuilt 1968 · S/N 15068604N22905Yokota Flight Training Center · Apo, APBuilt 1974 · S/N 17264078N2290DVan Roy Gary J · Seven Bays, WABuilt 1952 · S/N 20442N2290GHooker John L · Iowa Park, TXBuilt 1958 · S/N 51590N2290SElco Avion LLC · Eagle Lake, TXBuilt 1976 · S/N 21061233N2290XMatthews Roy E · Sparta, MIBuilt 1965 · S/N 337-0190N2290YHerren Roger L · Clayton, ILBuilt 1967 · S/N 17700090N22915Sprankle Gerard · Fairbanks, AKS/N 15068613N22919Brozzo Ralph · St Johns, FLBuilt 1968 · S/N 15068614N2291DKauffman Phillip L · Castleberry, ALBuilt 1952 · S/N 20443N2291EDv Aviation Inc · Brainerd, MNBuilt 1978 · S/N 17271224N2291YWyatt Gary D · Sun City West, AZBuilt 1967 · S/N 17700091N22920Jackson Kenneth R · Stephenville, TXS/N 15068615N22921Sakry Robert J · Saint Joseph, MNBuilt 1968 · S/N 15068616N22924Hirkala Ronald R · Weirton, WVBuilt 1968 · S/N 15068618N22926Gossett Rita M · Granbury, TXBuilt 1968 · S/N 15068619N22927Hamilton Gregory J · Avon Lake, OHBuilt 1968 · S/N 15068620N2292CKlein John T · Austin, ARBuilt 1953 · S/N 30592N2292GNelson Erik · Exeter, NHBuilt 1958 · S/N 51592N2292YJess Lawrence A · Menomonie, WIBuilt 1967 · S/N 17700092N22935Tift Aviation LLC · Tifton, GABuilt 1968 · S/N 15068627N2293GEischen Kent A · Smoot, WYBuilt 1958 · S/N 51593N2293JFrey Jerry P · Fallon, NVBuilt 1979 · S/N T18803449TN2294CHitch Dixon S · Malta, MTBuilt 1953 · S/N 30594N2294DPlunkett Carton C · Terry, MSBuilt 1952 · S/N 20446N2294GHenderson Ramsey H · Pittsboro, NCBuilt 1958 · S/N 51594N2294RSeeliger Jeremy E · Pasco, WABuilt 1978 · S/N R18200584N2294XCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1965 · S/N 337-0194
Back to AD 87-20-03 R2