OpenAirDocs.org
AD 77-13-21

Registered aircraft · 3,193

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:77-13-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
  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.

N8511PWiebe Aron F · Seminole, TXBuilt 1965 · S/N 26-91N8512YSager Garrett · Fort Worth, TXBuilt 1967 · S/N 30-1672N8513YCrane Douglas Gordon · Coquille, ORBuilt 1967 · S/N 30-1673N8514YMcnally Rodney · Sonora, CABuilt 1967 · S/N 30-1675N8515PJohnson Gary Paul · West Jordan, UTBuilt 1964 · S/N 26-52N8515YPiper Aviation Museum Foundation · Lock Haven, PABuilt 1967 · S/N 30-1676N8519PHubbard William A · Blair, OKS/N 26-99N8520PJones Terry W · Houston, TXBuilt 1965 · S/N 26-100N8523YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1684N8525PThorstenson Joseph · Norwalk, CTBuilt 1965 · S/N 26-105N8526PFisher Robin D · Corona, CABuilt 1964 · S/N 26-106N8526YCarlile John D · The Villages, FLBuilt 1968 · S/N 30-1687N8527YHatbright Farm LLC · Wilmington, DEBuilt 1968 · S/N 30-1688N8528YYoung David A · Lakeland, FLBuilt 1968 · S/N 30-1689N8530YMouat Michael W · Hemet, CABuilt 1968 · S/N 30-1691N8533PJacobs Aviation LLC · Mount Juliet, TNS/N 26-114N8535PSecond Life Flight Inc · Delray Beach, FLBuilt 1964 · S/N 26-116N8535YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1696N8536PBaker Gary J Trustee · Stateline, NVBuilt 1965 · S/N 26-117N8538PNovo Rafael E · Edgewood, NMBuilt 1965 · S/N 26-119N8538YRothstein Steven R · Punta Gorda, FLBuilt 1967 · S/N 30-1606N8539YTwinco Leasing LLC · Yacolt, WABuilt 1967 · S/N 30-1626N8540YCli Aerospace LLC · Appleton, WIS/N 30-1568N8542PPro Aviation LLC · Allen, TXS/N 26-123N8542YAviation Training Solutions LLC · Hilo, HIBuilt 1967 · S/N 30-1598N8544PSetzler Frank · Gilbert, AZBuilt 1964 · S/N 24-4001N8547PStewart James David · Mesa, AZBuilt 1964 · S/N 24-4004N8549PWest Texas Weather Modification Association · San Angelo, TXBuilt 1964 · S/N 24-4006N8550PNick Smith And Associates Inc · Mcallen, TXBuilt 1964 · S/N 24-4007N8551PBratcher Troy L · Williston, NDS/N 24-4008N8555YScharf Mark T · Rosamond, CAFirst renewal noticeBuilt 1968 · S/N 30-1702N8556PLandis Ehrin · Redding, CABuilt 1964 · S/N 24-4013N8557PQuaal Ranch Inc · Sundance, WYS/N 24-4014N8558PBaughman Kevin R · Avinger, TXBuilt 1964 · S/N 24-4015N8558YFritsch Nathaniel · Ettrick, WIBuilt 1968 · S/N 30-1705N8559PMcclean Adam D · Lakeport, CABuilt 1964 · S/N 24-4016N8560YSullian John J · Alexandria, VAS/N 30-1707N8562PRegistration Pending · Waukee, IARegistration pendingBuilt 1965 · S/N 24-4019N8564YGingers Holdings Inc · Jacksonville, FLBuilt 1968 · S/N 30-1711N8565PLynn Owen P · Vinemont, ALS/N 24-4021N8566PRicciardi Brian · Dennis, MABuilt 1964 · S/N 24-4022N8566YClarke George W III · Sierra Vista, AZBuilt 1968 · S/N 30-1714N8567PJeewek Rita M Trustee · Parma, OHBuilt 1964 · S/N 24-4023N8567YJohnson Randy D · Becket, MAS/N 30-1715N8569PPurpose Flight Inc · Wilmington, DES/N 24-4026N8571PBrackett William E · Capitan, NMBuilt 1964 · S/N 24-4028N8572PService Drug DBA · Chadron, NEBuilt 1964 · S/N 24-4029N8573PMounicou Sonny M · Olive Branch, MSBuilt 1964 · S/N 24-4030N8577PPrice Isaac H · Flat Rock, ALBuilt 1964 · S/N 24-4034N8578PGibbs Gregory Curtis · Engelhard, NCBuilt 1964 · S/N 24-4035
Back to AD 77-13-21