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.

N9133PJ&J N2288 LLC · Houston, TXBuilt 1966 · S/N 24-4613N9134PGjdefigo LLC · Gambrills, MDBuilt 1966 · S/N 24-4614N9135PMatthias Michael V · Readlyn, IABuilt 1966 · S/N 24-4615N9137PJackson Thomas A Trustee · Maple Grove, MNBuilt 1966 · S/N 24-4618N9138PSiemering Thomas · Sarasota, FLBuilt 1966 · S/N 24-4619N9140PKing Stephen M · Medford, MABuilt 1966 · S/N 24-4621N9141PSilvabar Air LLC · Springfield, VTS/N 24-4622N9142PErickson Ralph E · Foristell, MOBuilt 1966 · S/N 24-4623N9143PSons Aviation LLC · Moody, ALS/N 24-4624N9144PKober Kelly W · West Chester, PABuilt 1966 · S/N 24-4625N9146PBlack Diamond Aviation LLC · Levelland, TXBuilt 1967 · S/N 24-4629N9147PDesouza Ian · Binghamton, NYBuilt 1966 · S/N 24-4631N9148PJohnson T J H · Franklin, MIBuilt 1966 · S/N 24-4632N914DPGonzalez Ramiro · Lancaster, OHBuilt 1966 · S/N 24-4633N9152PLock Haven 24 LLC · Chandler, AZS/N 24-4637N9153PA&E Aviation LLC · Ruston, LABuilt 1966 · S/N 24-4639N9154PSloan James M Trustee · Grandbury, TXBuilt 1966 · S/N 24-4640N9155PRegistered aircraftBuilt 1966 · S/N 24-4641N9157PN9157p LLC · Mason, MIBuilt 1966 · S/N 24-4643N915BCGentry Jeremiah S · Fort Smith, ARBuilt 1967 · S/N 244673N915HPAnderson Austin C · Washington, DCBuilt 1966 · S/N 24-4371N9160PHeath Allen W · Westlake, TXBuilt 1966 · S/N 24-4648N9161PAven Michael D · Georgetown, INBuilt 1966 · S/N 24-4649N9162PBrown Nathan B · Wallace, KSBuilt 1966 · S/N 24-4650N9163PMiller Richard Marc Trustee · Dana Point, CABuilt 1966 · S/N 24-4651N9166PNewman Jeffrey M · Pauline, SCBuilt 1966 · S/N 24-4654N9167PPegasus Unlimited LLC · Arroyo Grande, CABuilt 1966 · S/N 24-4655N9169PPorter Christina · Cape Coral, FLS/N 24-4658N9170PP&S Aviation LLC · White Rock, NMBuilt 1967 · S/N 24-4659N9171PMckim Thomas F · Winston Salem, NCBuilt 1967 · S/N 24-4660N9172PSale Reported · Henderson, NVSale reportedBuilt 1967 · S/N 24-4661N9175SMarshall Adam A · Fremont, NEBuilt 1967 · S/N 24-4664N9176PWalter Richard · Hampshire, ILBuilt 1967 · S/N 24-4665N9177PCochran Charles M III · Terre Haute, INBuilt 1967 · S/N 24-4666N9178PCarnes Harley · Ocean, NJBuilt 1967 · S/N 24-4668N9180PHughes Travis · Willow Park, TXBuilt 1967 · S/N 24-4670N9182PMonske Nicholas · Austin, TXS/N 24-4672N9184XContinental Title Trust LLC Trustee · Wichita, KSBuilt 1966 · S/N 30-1041N9187PJapundza Bob · Kokomo, INFirst renewal noticeS/N 24-4677N9188PRogermoser Hanspeter · Summerville, SCBuilt 1967 · S/N 24-4678N9189PThom Transport LLC · Marlette, MIBuilt 1967 · S/N 24-4680N918YInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 30736N9190PGreen Mark S · Ocala, FLBuilt 1967 · S/N 24-4683N9191ECatlin Aviation Co · Okla City, OKRegistration revokedBuilt 1959 · S/N 241538N9193PDean Aaron · Norwich, NYBuilt 1967 · S/N 24-4686N9195PHarstine Lucene May · Claypool, INBuilt 1967 · S/N 24-4688N9196PHarris Michael · Pointblank, TXBuilt 1967 · S/N 24-4689N9197PHardin County Aviation LLC · Kountze, TXBuilt 1967 · S/N 24-4690N9198PBarna George · Castleton, NYBuilt 1967 · S/N 24-4692N91BRRegistration Pending · South Boston, VARegistration pendingBuilt 1965 · S/N 24-4326
Back to AD 77-13-21