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.

N3LESubick Leonard W · Spring City, PAS/N 20700368N3LUKirby & Associates Texas Lp · West Hills, CAS/N 18264437N3MKRedwing Aviation LLC · San Antonio, TXBuilt 1977 · S/N 177RG1217N3NFRooster Partners LLC · Santa Monica, CABuilt 1979 · S/N R18200932N3NQKropp Matthew M · North Creek, NYBuilt 1963 · S/N 18051224N3PRShadow Air LLC · Mountain Home, ARS/N 18257226N3PVAtkinson Russell M · Concord, CAS/N 17251739N3PZBrothers Aviation LLC · Black Rock, ARS/N 210-63326N3QZTexins Flying Club · Mckinney, TXBuilt 1972 · S/N 18261649N3RWGordon George M Jr · Weston, MABuilt 1978 · S/N 17271069N3RXMorelli Michael V · Kenilworth, ILBuilt 1974 · S/N 17264044N3SFPowers Gilford L · Glenville, NYBuilt 1970 · S/N 17259442N3SLMaedel John Henry Jr · Nesbit, MSBuilt 1968 · S/N 18259051N3SMQuaintance Christian N · Culpeper, VABuilt 1964 · S/N 18051488N3TNChamplain Flyers LLC · Westford, VTBuilt 1974 · S/N 17263547N3UFAltorfer David W · Peoria, ILBuilt 1976 · S/N 21061410N3UXDiller Christina · Anchorage, AKBuilt 1979 · S/N 18267442N3VCGreen John T Trustee · Kettering, OHBuilt 1980 · S/N R18201452N3VQOff The Ground LLC · Austin, TXS/N 34892N3VZHavard Mark · Groves, TXBuilt 1976 · S/N 18265132N3WWCrouthamel Russel M · Harleysville, PAS/N 18265542N3XZStrom Laurelin · Lexington Park, MDBuilt 1972 · S/N 15074013N3YNWeaver Carl · Halstead, KSS/N 18051477N40007Kelleher Timothy J · Lake Placid, NYS/N 182-61875N4000DHortman Jennifer L · Murrieta, CABuilt 1958 · S/N 51361N4000FDe Lisio Frederick C · Andover, MABuilt 1958 · S/N 36900N4001DJohnson Randall S · Craig, AKBuilt 1957 · S/N 34701N4001VKittelman Tom L · Buckley, WAS/N 18320N4001YHill James J · Saint Helen, MIBuilt 1961 · S/N 1850201N4002DVanburen Willard L Sr · Ashland, NEBuilt 1957 · S/N 34702N4002VLofstrom David S · Chugiak, AKS/N 18321N4003FMartin Rogers K · Rome, GABuilt 1958 · S/N 36903N4003UGambassi Saverio · Bealeton, VAS/N 15061403N4003VPa Services Gulfsouth LLC · Minden, LAS/N 18322N4004FCreelman Richard A · San Marcos, TXBuilt 1958 · S/N 36904N4004VDitges Nathanael · Creston, IABuilt 1948 · S/N 18323N4005DHarris Mark P · Arcata, CABuilt 1957 · S/N 34705N4005FRound Engine Aero · Nashville, MIS/N 36905N4005USteinberg Alan R · Iron Mountain, MIBuilt 1965 · S/N 15061405N4005VScarberry Dennis L · Goddard, KSBuilt 1948 · S/N 18324N4005YWareham Charles L · Chugiak, AKBuilt 1962 · S/N 185-0328N4006DTveitnes Svein T · Whitewright, TXBuilt 1957 · S/N 34706N4006FBig Sky Fkyers LLC · Billings, MTS/N 36906N4006JGreenstreet Robert A · Lake Geneva, WIBuilt 1966 · S/N 15065306N4007Empire Ranch Inc · Lebanon, MOFirst renewal noticeBuilt 1973 · S/N 18262208N40098Fall River County Emergency Management · Hot Springs, SDBuilt 1966 · S/N R172-0134N400BTN Ranch LLC · Missoula, MTS/N R18200452N400GEFreeway Airport Inc · Mitchellville, MDBuilt 1981 · S/N 17275445N400GTDelaney Holdings LLC · De Witt, IABuilt 1971 · S/N 21059544N400HA15 Corp · Lansing, MIBuilt 1970 · S/N 17701484
Back to AD 87-20-03 R2