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.

N5781BRobinson Stephen L · Celina, TXBuilt 1956 · S/N 33781N5781CSipple Ronald W Jr · Gardner, KSBuilt 1950 · S/N 19735N5781GWilliams Lynwood A · Clayton, NCBuilt 1969 · S/N 15071281N5781RFeauto Aviation Inc · Saint Cloud, FLS/N 17253450N5781TCortis Samuel L · Uniontown, PABuilt 1964 · S/N 17251681N5782BRankin Paul D · Hudson, WIBuilt 1956 · S/N 33782N5782COsborne Don R · Fairbury, NEBuilt 1950 · S/N 19736N5782JN5782j LLC · Myrtle Beach, SCBuilt 1979 · S/N 17273835N5782RSchuck Daniel W · Newark, CABuilt 1965 · S/N 17253451N5782TLas Capital Corp · St Johns, FLBuilt 1964 · S/N 17251682N5783ABright Corner Charter LLC · Bozeman, MTBuilt 1956 · S/N 28383N5783BGlaser Edwin P · Calhan, COBuilt 1956 · S/N 33783N5783CAnderson Donnie · Loudon, TNBuilt 1950 · S/N 19737N5783JSelting Mark D · Kadoka, SDBuilt 1971 · S/N 21059483N5783RPritting John R · Reno, NVS/N 17253452N5784AAnderson Steve R · Dillon, COS/N 28384N5784BC&B Aerial Transport Inc · Wilmington, DEBuilt 1956 · S/N 33784N5785BWoodley Aerial Leasing LLC · Walnut, ILBuilt 1956 · S/N 33785N5785GBrown Colin M · Williamstown, NJBuilt 1969 · S/N 15071285N5785RKablau Frank · Elroy, WIBuilt 1965 · S/N 17253454N5786ABongiorni Robert W Jr · Burgettstown, PABuilt 1956 · S/N 28386N5786CCarr Rebecca N · Willow, AKFirst renewal noticeBuilt 1950 · S/N 19740N5786RBrown Jeremiah S · Ada, OHS/N 17253455N5786TBam Aviation LLC · Santa Ana, CABuilt 1964 · S/N 17251686N5788AWeston Stetson J · Tremonton, UTBuilt 1956 · S/N 28388N5788JEagle Aviation Inc · Elizabeth, COBuilt 1975 · S/N 18263536N5788THart Justin Owen · Olalla, WAS/N 17251688N5789CHeineken Chad H · Fairbanks, AKBuilt 1950 · S/N 19743N5789JDonaldson Robert D · Kingston, NYBuilt 1975 · S/N 18263537N5789RShipley Lucas S · Jefferson, IABuilt 1965 · S/N 17253458N578LWWags And Wings LLC · Sunset, LABuilt 1958 · S/N 34862N578MAByte Networking LLC · Juneau, AKFirst renewal noticeBuilt 1967 · S/N 15068091N5790ASheen Mark Andrew · Snowflake, AZBuilt 1956 · S/N 28390N5790CThompson Dan L · Fargo, NDBuilt 1950 · S/N 19744N5790RMiller Cindy C · San Ramon, CAS/N 17253459N5790TViramontez Walter P · Santee, CABuilt 1964 · S/N 17251690N5791BQuist Michael A · Antioch, ILS/N 33791N5791TShinn Jeffrey D · Weatherford, TXBuilt 1964 · S/N 17251691N5792BJacquin Aviation Inc · Markham, ILBuilt 1956 · S/N 33792N5792CCampbell Peter R · Edgewater, FLBuilt 1950 · S/N 19746N5792RCollins Mark W · Seymour, TNBuilt 1965 · S/N 17253461N5792TMorgan Dennis A · Middle River, MDBuilt 1964 · S/N 17251692N5793BRitland Stephen · Flagstaff, AZBuilt 1956 · S/N 33793N5793CDobyns Jesse · Ethel, WABuilt 1951 · S/N 19837N5793RRogers Jesse E · La Belle, MOBuilt 1965 · S/N 17253462N5793TJefferson County Public Schools · Louisville, KYBuilt 1964 · S/N 17251693N5794APerkins Larry L · Wildomar, CAFirst renewal noticeBuilt 1956 · S/N 28394N5794RMacfarland Donald C · North Tonawanda, NYBuilt 1965 · S/N 17253463N5794TGodfrey Kenneth E · Oroville, CABuilt 1964 · S/N 17251694N5795BJst Management LLC · Zephyrhills, FLFirst renewal noticeBuilt 1956 · S/N 33795
Back to AD 87-20-03 R2