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.

N6670EMacfadden Gary D · Condon, MTS/N 56170N6670FWare Edward A Jr · Nicholson, PABuilt 1966 · S/N 15063270N6670HMcinnis Jody · Hillman, MIBuilt 1975 · S/N 17265530N6670MLbl Flyers LLC · Depoe Bay, ORBuilt 1975 · S/N 18263794N66717Sherman Aviation LLC · Fairfield, NJBuilt 1983 · S/N 17275991N66718Schmitt Rudy · Brookshire, TXBuilt 1974 · S/N 15076232N6671ABurke John E · Spring, TXBuilt 1956 · S/N 28771N6671EAnderas Per R · Green Bay, WIBuilt 1959 · S/N 56171N6671FAntinarelli Peter J · Hickory, NCBuilt 1966 · S/N 15063271N6671PLunn Frank Paul III · Chatham, NHBuilt 1974 · S/N 17264371N66723Armstrong Paul D · Stillwater, OKS/N 15076233N66728Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 15076237N6672AVandenbark Cody M · Troy, IDBuilt 1956 · S/N 28772N6672EKing Aubrey R · Salinas, CABuilt 1959 · S/N 56172N6672FRodriguez Cory Omarr · Abilene, TXBuilt 1966 · S/N 15063272N6672HDavenport Thomas C · Buchanan Dam, TXS/N 17265531N6672SPikul Daniel J · Monson, MABuilt 1967 · S/N 15067472N66730Glau John E · Centennial, COBuilt 1974 · S/N 15076239N66735Ryan Adrian · Anchorage, AKS/N 18052956N66736Klein Todd · Winston Salem, NCBuilt 1974 · S/N 15076241N66738Irvin Bradley A · Lula, GABuilt 1974 · S/N 15076242N66739Airgo Inc · Centralia, ILBuilt 1974 · S/N 15076243N6673ASearson Jason C · Newton, NCBuilt 1956 · S/N 28773N6673EMiller Daniel F · Grain Valley, MOBuilt 1959 · S/N 56173N6673FKysar Ian R · Battle Ground, WABuilt 1966 · S/N 15063273N66745H T Productions Inc · Grayling, MIBuilt 1974 · S/N 15076246N66748Skypark Inc · Wadsworth, OHBuilt 1974 · S/N 15076249N6674AThomas Craig S · Salem, ORBuilt 1956 · S/N 28774N6674FBon Investment Holdings LLC · Zephyrhills, FLBuilt 1966 · S/N 15063274N6674GJoe Dory Aviation LLC · Caldwell, IDBuilt 1970 · S/N 15072174N66751Talmage Timothy A · Azle, TXBuilt 1974 · S/N 15076251N66753Andreasen Trevor C · Springville, UTBuilt 1974 · S/N 15076252N66755Fischer A Edward Jr · Hampstead, NHBuilt 1974 · S/N 15076253N66756Listzwan James · High Springs, FLBuilt 1974 · S/N 15076254N66758Dahlberg James C · Ogilvie, MNBuilt 1974 · S/N 15076255N6675ETornquist Robert John Jr · Turlock, CABuilt 1959 · S/N 56175N6675FCommercial Center Inc · Wilmington, DEBuilt 1966 · S/N 15063275N6675MMorrissette Todd · Buxton, MEBuilt 1975 · S/N 18263795N6675TYoung Dan J · Norwalk, IABuilt 1960 · S/N 15059075N66764Cuttler Lloyd · Carabaset Vly, MEBuilt 1978 · S/N 18052958N66765Kalba Shaun B · Pleasant Valley, NYBuilt 1978 · S/N 18052959N66768Ludemann John K · Enfield, CTBuilt 1974 · S/N 15076262N6676FCampbell J R Jr · Bell, FLBuilt 1966 · S/N 15063276N6676GChen Hong · Independence, ORBuilt 1970 · S/N 15072176N6676TCash W Duane · Fairfield Bay, ARS/N 15059076N66774Kilo Lima LLC · Hicksville, NYBuilt 1974 · S/N 15076268N66776Broherd James · Natalia, TXBuilt 1974 · S/N 15076269N66777Lennon Bobby M · Whiteville, NCS/N 15076270N66779Blinn Philipp Randy · Priest River, IDS/N 15076272N6677BHess Chad · Boise, IDBuilt 1978 · S/N 21062816
Back to AD 87-20-03 R2