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.

N156AEHolt Cory J · Santa Ynez, CABuilt 1962 · S/N 18254549N156DARound Trip Lc · Elkhart, KSS/N 15079190N156JMTrechak Ashley L · Shafter, CABuilt 1956 · S/N 32360N156KAXclusive Level Auto Glass LLC · Kissimmee, FLBuilt 1973 · S/N 15074980N156KCWhitney Aviation LLC · Derry, NHBuilt 1978 · S/N 18503621N156MRegistered aircraftBuilt 1979 · S/N 18053114N156SKBrenny Christopher D · Burlington, WIBuilt 1981 · S/N 15285035N156VBooher Daniel Ross · Humble, TXBuilt 1957 · S/N 50019N156XDBurgess Mark W · Greene, MES/N 17268718N1570DBoswell Kurt R · Renton, WABuilt 1952 · S/N 7792N1570QColvin William E · Newberry, FLBuilt 1971 · S/N 15072870N1570UReno70 LLC · Anchorage, AKBuilt 1970 · S/N 20700170N1570VMcdermott John P Trustee · Redding, CABuilt 1974 · S/N 17263671N1570YBoggs Texe T · Sarcoxie, MOBuilt 1962 · S/N 17249270N1571DMilton William H · West Glenville, NYBuilt 1952 · S/N 7793N1571EMorgan Steven P · Roswell, GABuilt 1978 · S/N 17271049N1571HYork Ronald A · West Lafayette, INBuilt 1975 · S/N 177RG0745N1571UFavero Michael R · Sacramento, CABuilt 1973 · S/N U20602263N1571VPeabody Jeffery L · Vinemont, ALBuilt 1974 · S/N 17263672N15724Mcrae Roy Sean · Thorne Bay, AKBuilt 1972 · S/N 18052292N1572QStenberg Andrea Renee · Edmonds, WAS/N 15072872N1572VWaldroup Anthony Wayne · Konawa, OKBuilt 1974 · S/N 17263673N1573FSmith David J · Duluth, MNBuilt 1965 · S/N 185-0949N1573QFergeson Matthew C · Dwg, TXBuilt 1971 · S/N 15072873N1574DWilliams Marc A · Ridgecrest, CABuilt 1952 · S/N 7796N1574LNghiem Daniel · Westminster, CABuilt 1973 · S/N A1500460N1574PSouthern Seaplane Inc · Belle Chasse, LABuilt 1976 · S/N 21061258N1574YBlue Hawk LLC · Rogers, MNS/N 17249274N1575CMeierotto Martin A · Two Rivers, AKBuilt 1953 · S/N 30275N1575HCardinal Shares Inc · Rochester, MNS/N 177RG0749N1575QKelley Jack T Jr · Linden, NCS/N 15072875N1575SSkyward Flying LLC · Goshen, INBuilt 1975 · S/N 18264374N1575VMissouri Reliability Services LLC · Maryville, MOBuilt 1974 · S/N 17263675N1576DMock Lurita M · Anderson, INBuilt 1952 · S/N 7798N1576HBloom Timothy S · Chugiak, AKBuilt 1977 · S/N 18503309N1576MSkyline Aviation Services LLC · Miramar, FLBuilt 1977 · S/N 21061948N1577CDunn William A · Dedham, MES/N 30277N1577DWilson Travis · Oswego, KSS/N 7799N1577HKing Wayne T · Anchorage, AKBuilt 1977 · S/N 18503310N1577YConner James D · Elgin, TXBuilt 1962 · S/N 17249277N1578CImhof Air LLC · Ferndale, WABuilt 1953 · S/N 30278N1578HKramer Jason K · Longview, TXBuilt 1975 · S/N 177RG0752N1578QBrown Carolyn J · West Ossipee, NHBuilt 1971 · S/N 15072878N1579MGospel To The Nations Ministries Inc · Dayton, OHBuilt 1975 · S/N 18264377N1579QChastain Elizabeth A · Saint Louis, MOBuilt 1971 · S/N 15072879N157DF157df LLC · Madison, WIS/N 17260646N157KAPhillips David Jj · Orlando, FLS/N 15075210N157LMBaughman David · Jeffersonville, INBuilt 1961 · S/N 21057764N157NHRegistered aircraftBuilt 1981 · S/N 15285106N157STogo Aviation Services LLC · Palmer, AKBuilt 1955 · S/N 31840
Back to AD 87-20-03 R2