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.

N7067GAngelle Kelli R · New Roads, LABuilt 1969 · S/N 17258767N7067TSmith Roy Harold · Whiteville, NCBuilt 1959 · S/N 46667N7067XAlpha Golf LLC · Glenpool, OKBuilt 1961 · S/N 15059167N70686Haase Douglas R · Manassas, VABuilt 1968 · S/N 18259356N70688Roesner David A · Salina, KSBuilt 1968 · S/N 18259358N7068AMcdonald Ronald B · Arcadia, FLBuilt 1956 · S/N 29168N7068EMarino Farms LLC · Macon, MOS/N 56568N7068FAndrew David N · Manhattan, ILBuilt 1966 · S/N 15063668N7068MStaples Norman J · Sussex, WIBuilt 1958 · S/N 55368N7068QWestwind Aviation Inc · Bremerton, WABuilt 1972 · S/N 17260368N70695Tucker Whitney L · Gove, KSBuilt 1968 · S/N 18259360N70697Whalen Charles R · Gladewater, TXS/N 18259362N70698Martin Kenneth R · Mill Creek, WABuilt 1968 · S/N 18259363N7069EPinnell John T · Bakersfield, CAS/N 56569N7069GAjf Enterprises LLC · Des Moines, IABuilt 1969 · S/N 17258769N7069MJohnson Roger N · Winnemucca, NVBuilt 1958 · S/N 55369N7069QFlakker Michael E · Gold Hill, NCS/N 17260369N7069THovey Terry W · Rogue River, ORBuilt 1959 · S/N 46669N7069USmith Alwyn · Boca Raton, FLS/N 18051846N706DAFlycarolina LLC · Charlotte, NCBuilt 1980 · S/N 17274339N706DEBradley Aircraft Company LLC · Columbus, INBuilt 1979 · S/N 17272596N706HPFlorida Highway Patrol · Tampa, FLBuilt 1985 · S/N R18202013N706PREvoaviation LLC · Watkinsville, GABuilt 1971 · S/N 18260752N7070EKuchn Todd S · Wabasso, MNBuilt 1960 · S/N 56570N7070FDaub David M · Sealy, TXBuilt 1966 · S/N 15063670N7070GGade Christopher P · Williston, VTFirst renewal noticeBuilt 1969 · S/N 17258770N70710Embyr November LLC · Gunnison, COBuilt 1968 · S/N 18259364N70712Ivany Hugh Scott · Anchorage, AKBuilt 1976 · S/N 18503059N70713Satre Olaf · Kiowa, COBuilt 1971 · S/N 18501878N7071AFieldman Gregory S · Olympia, WABuilt 1956 · S/N 29171N7071EPlumstead Lawrence P · Seminole, FLS/N 56571N7071FPadgett Troy A · Midway, TXS/N 20240N7071GWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258771N7071QSun Country Aero Club · The Villages, FLS/N 17260371N7072ABig R Of Greeley · Greeley, COS/N 29172N7072FMiller Richard M · New Galilee, PABuilt 1966 · S/N 15063672N7072GMears Benjamin W III · Eastville, VABuilt 1969 · S/N 17258772N7072MWhisler Jon N · Shady Shores, TXBuilt 1958 · S/N 55372N7072QB&R Aircraft LLC · Wadsworth, OHS/N 17260372N7072SEstby Hans P · Hayfield, MNBuilt 1967 · S/N 15067772N7072TFlaugher P Diane · Beloit, WIBuilt 1959 · S/N 46672N70739Morey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 15282595N7073EWestrum Durl T · Norwalk, IAS/N 56573N7073FBushby David R · Barnesville, GABuilt 1966 · S/N 15063673N7073GSky Warriors LLC · Hayward, CAS/N 17258773N7073KCopper River Airmotive LLC · Copper Center, AKS/N 17271690N7073SWaterman Ronald L · Albuquerque, NMBuilt 1976 · S/N 18265059N70740Sierra Bravo Air LLC · Winston Salem, NCBuilt 1968 · S/N 18259365N7074AFogg Morgan T · Pierce, COBuilt 1956 · S/N 29174N7074QMorris Sidney H · Kenai, AKFirst renewal noticeBuilt 1963 · S/N 18051250
Back to AD 87-20-03 R2