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.

N7758PSkalsky Todd A · Hartley, TXBuilt 1961 · S/N 24-2974N7758YMead Aviation LLC · Missoula, MTBuilt 1965 · S/N 30-790N7761YBytes Aviation LLC · Poolesville, MDBuilt 1965 · S/N 30-848N7764PBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 24-2981N7765PRegistered aircraftBuilt 1961 · S/N 24-2982N7765YAce Vne LLC · Stevensville, MIBuilt 1965 · S/N 30-852N7767PStock Keith A · Warrensburg, MOS/N 24-2983N7768PGreensburg Jeannette Airport Administration Inc · Jeannette, PAS/N 24-2984N776CHHassler William J · Houston, TXBuilt 1965 · S/N 30-753N7770PGlau Jon E · Englewood, COBuilt 1961 · S/N 24-2986N7771YDakota Executive Flight Inc · Miller, SDBuilt 1965 · S/N 30-857N7773PJenkins John R · Fairmont, WVBuilt 1962 · S/N 24-2989N7773YBismuth Robert · Seattle, WABuilt 1965 · S/N 30-859N7774YReed John · Seattle, WABuilt 1965 · S/N 30-860N7776PHardin Gerald A · Port Clinton, OHFirst renewal noticeBuilt 1962 · S/N 24-2993N7777PWeihe Philip D · Cleveland Heights, OHBuilt 1961 · S/N 24-2994N7777YDigati Anthony J · Mentone, CAS/N 30-863N7778YSpiegel Eitan · San Francisco, CABuilt 1965 · S/N 30-864N7779YMccool Kenneth W · Olive Branch, MSBuilt 1965 · S/N 30-865N777BBMrnak Andy M · Bowman, NDBuilt 1961 · S/N 24-2227N777DFOl Hughes LLC · Staplehurst, NEBuilt 1972 · S/N 24-5019N777EEDga Aviation LLC · Sacramento, CABuilt 1961 · S/N 24-2773N777FSCasey William F · Ponderay, IDBuilt 1972 · S/N 39-121N777KGLonnevik Dennis F · Bigfork, MTBuilt 1966 · S/N 30-1159N777KPKelly'S Flying Service LLC · Warrensburg, MOBuilt 1963 · S/N 30-110N777MURobinson James G · Baltimore, MDBuilt 1964 · S/N 26-83N777RHLarson Peter T Trustee · Coraopolis, PABuilt 1965 · S/N 30-908N777ZZMiller Jordan Raul · Columbus, OHFirst renewal noticeS/N 24-1495N7780PMolinari Eugene A Jr · Milton, FLBuilt 1961 · S/N 24-2997N7781PBallard William S · Sanford, NCBuilt 1962 · S/N 24-2998N7786POlson Arthur W · Fairbanks, AKBuilt 1962 · S/N 24-3003N7786YBell Frank · Tuxedo, NCBuilt 1965 · S/N 30-869N7787YBucks Flight Academy LLC · Cashion, OKBuilt 1965 · S/N 30-870N7788PEight Eight Papa Inc · Williamsport, PABuilt 1962 · S/N 24-3005N7790YMaki Stephen B · New Port Richey, FLBuilt 1965 · S/N 30-146N7791YMaki Stephen B · New Port Richey, FLBuilt 1965 · S/N 30-874N7792PAdkins Brian Keith · Twp Washinton, NJBuilt 1962 · S/N 24-3009N7793YRedinger Aaron · Hanlontown, IABuilt 1965 · S/N 30-876N7794PWard Ronald Kevin · Santa Rosa, CAS/N 24-3011N7795PBressman John W · Belton, MOBuilt 1962 · S/N 24-3012N7796PDsr Cherokee 180 LLC · Dallas, TXBuilt 1962 · S/N 24-3014N7797PGrassi Michael A · Waterford, MIBuilt 1963 · S/N 24-3015N77CHTcb Management Inc · Chiefland, FLBuilt 1971 · S/N 39-136N77SLSanders Wiley C Jr · Troy, ALBuilt 1967 · S/N 30-1654N7803PNoguess James E · Deming, NMS/N 24-3064N7804PFisher B Barton · Bowman, NDBuilt 1962 · S/N 24-3023N7805PN6760s LLC · Brooklyn, NYBuilt 1962 · S/N 24-3073N7805YN7805y LLC · Winchester, VAS/N 30-884N7806PSpires Kenneth G · Seville, OHBuilt 1962 · S/N 24-3025N7806YHhozapnv-LLC · Las Vegas, NVBuilt 1965 · S/N 30-885
Back to AD 77-13-21