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.

N16088Wyrosdick Benjamin S · Hoover, ALBuilt 1972 · S/N 15073467N1608CMiller Gerald Roy · Denver, NCBuilt 1953 · S/N 30308N1608FSmith Tim J · Leasburg, MOBuilt 1966 · S/N 17255003N1608YKohr Daniel E · Bartlett, TNBuilt 1962 · S/N 17249308N16091Timm Mark W · Ithaca, NEBuilt 1972 · S/N 15073469N16093Hanus Aviation LLC · Kenyon, MNBuilt 1972 · S/N 15073471N16097Crosswind Capital LLC · Castle Rock, COBuilt 1972 · S/N 15073474N1609CBerry John C · Thunderbolt, GABuilt 1953 · S/N 30309N1609EEilenfeld Teresa · Mansfield, OHBuilt 1978 · S/N 17271065N1609FHeneghan Tim S · Auburn, WABuilt 1973 · S/N 18052316N1609XHarvey P J · Midland, TXBuilt 1975 · S/N 21060645N1609YMapes Steven J · Schenectady, NYBuilt 1962 · S/N 17249309N160CBBishop Christopher S · Houston, TXBuilt 1966 · S/N 15063780N160FSModi Yogini · Homestead, FLBuilt 1979 · S/N 17272752N160KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1976 · S/N 15078474N160PYeager Robert F · Cuyahoga Falls, OHBuilt 1962 · S/N 18254278N160WBBeach Banners Inc · Jacksonville, FLBuilt 1958 · S/N 55238N16101Hatch David G · Clovis, CAS/N 15073477N16105Stevenson Rodrick Albert · Smyrna, GABuilt 1972 · S/N 15073480N16107Scheck Robert C · Chicago, ILBuilt 1972 · S/N 15073481N16108Longsroad LLC · Carefree, AZBuilt 1972 · S/N 15073482N16109Registration Pending · Mundelein, ILRegistration pendingBuilt 1972 · S/N 15073483N1610FFrahm Lon R · Colby, KSBuilt 1966 · S/N 17255005N1610MBreuer Lisa · Horseshoe Bend, IDBuilt 1975 · S/N 18264395N16114Mcquaid Joseph D · Cosby, TNS/N 15073486N1611FTripp Michael J · Macon, GABuilt 1966 · S/N 17255006N1611HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 177RG0784N16120Av8 Flight Assets LLC · Eden Prairie, MNBuilt 1972 · S/N 15073491N16125Palmer Earl S Jr · Boise, IDBuilt 1972 · S/N 15073494N16127Skypark Inc · Wadsworth, OHBuilt 1972 · S/N 15073496N16128Marquette County Flying Club · Marquette, MIBuilt 1972 · S/N 15073497N16129Rankin Kevin · Maryville, MOBuilt 1972 · S/N 15073498N1612CBeck Robert A · Cove, ORBuilt 1953 · S/N 30312N1612EPavlovitch Marion T · Northridge, CAFirst renewal noticeBuilt 1978 · S/N 17271066N16134Adibi Saeed · Huntsville, ALBuilt 1976 · S/N 17702485N16137Hines Roger E · Greenville, OHBuilt 1976 · S/N 17702487N1613FAde William Henry III Trustee · Tucson, AZBuilt 1966 · S/N 17255008N1613HHampton William R · Marietta, GAFirst renewal noticeBuilt 1975 · S/N 177RG0786N1613MMclaughlin Drew V · Anchorage, AKBuilt 1970 · S/N 18501833N1613VMcewen Michael A M D · Gadsden, ALBuilt 1974 · S/N 17263692N1613YNelson Bobby E · Lago Vista, TXS/N 17249313N1614CMaggie L Air Service LLC · Kalispell, MTS/N 30314N1614FMathena Chad R · Narrows, VABuilt 1966 · S/N 17255009N1615EFisher Ralph B · Lutz, FLBuilt 1978 · S/N 17271067N1615FWells Edmund B · Austin, MNBuilt 1966 · S/N 17255010N1615VFrance Jeffrey A · Reedville, VABuilt 1974 · S/N 17263693N1615XBvi Aviation LLC · Wilmington, DEBuilt 1975 · S/N 21060651N16165Registered aircraftBuilt 1972 · S/N 15073514N16166Hayden Scott M · Walworth, WIBuilt 1972 · S/N 15073515N16169Trotter Patrick J · North Las Vegas, NVBuilt 1972 · S/N 15073518
Back to AD 87-20-03 R2