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.

N8976YAfricano Aircraft Management LLC DBA · Chicago, ILS/N 39-142N8977PWarrior Up LLC · Clayton, NCBuilt 1966 · S/N 24-4435N8979PShortridge Mary E · Bennet, NEBuilt 1966 · S/N 24-4438N8980PLittle Wood LLC · Bellevue, MIBuilt 1966 · S/N 24-4439N8980YTomu Fly LLC · Vero Beach, FLS/N 39-146N8981YGrey Enterprises Holdings LLC · Kalispell, MTBuilt 1972 · S/N 39-138N8982PAviation & Aerospace Consulting & Mgmt Svcs LLC · Bullhead City, AZBuilt 1966 · S/N 24-4441N8982YCovington James P · Poplar Grove, ILBuilt 1972 · S/N 39-147N8983PBlum Kenneth J · Truckee, CABuilt 1966 · S/N 24-4442N8984PMarchant Scott · Clackamas, ORBuilt 1966 · S/N 24-4443N8985PSharp Charles Barry · Fulton, KYBuilt 1966 · S/N 24-4445N8986PNielsen James R · Carson City, NVS/N 24-4446N8986YN8986y LLC · Orlando, FLBuilt 1972 · S/N 39-151N8990PBaitanator Inc · Lamesa, TXBuilt 1966 · S/N 24-4451N8991PCendejas Agustin · Chino, CABuilt 1966 · S/N 24-4452N8992PL And L Aviation Inc · Mount Airy, MDBuilt 1966 · S/N 24-4453N8993PPitcher Benjamin Alan · Fishers, INBuilt 1966 · S/N 24-4454N8997PF2 Management LLC · Canoga Park, CAS/N 24-4458N8998PMoore Jeffrey · Oceanside, CABuilt 1966 · S/N 24-4459N8999PBednorski Craig A Trustee · Grass Valley, CABuilt 1966 · S/N 24-4376N89GBHerrington Kevin · Honey Grove, TXS/N 24-4779N8FTop Flight Aviation Inc · Corona, CAS/N 30-1312N8LBHill Mark Daniel · Magnolia, TXBuilt 1969 · S/N 30-1788N8MZSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 301648N8PXFly Casual LLC · Sacramento, CABuilt 1972 · S/N 39-144N9004PFlying R Aviation LLC · Cherokee, IAS/N 24-4465N9005PKasakoff Lloyd · Diamond Bar, CAS/N 24-4466N9006PSage Building Construction Inc · Roosevelt, UTBuilt 1966 · S/N 24-4467N9007PKoval Andor A · Yerington, NVBuilt 1966 · S/N 24-4468N9008PStarnes William H · Eureka Springs, ARBuilt 1966 · S/N 24-4469N900DCRognerud Edward J · Rosemount, MNBuilt 1970 · S/N 39-20N900GPPerkins E G Jr · Greenwood, MSBuilt 1966 · S/N 24-4464N9013PRegistered aircraftBuilt 1966 · S/N 24-4474N9014PSherback Michael A · Mountain View, CABuilt 1965 · S/N 24-4475N9016PRegistered aircraftBuilt 1966 · S/N 24-4477N9019PReeves Robert Lincoln · Charlotte, NCBuilt 1966 · S/N 24-4480N9020PLindsay Terry M · West Hills, CABuilt 1966 · S/N 24-4482N9021PFontenot Monty Jason · Aiken, SCBuilt 1966 · S/N 24-4483N9022PAcc Air Charter Company · Wilmington, DEBuilt 1966 · S/N 24-4484N9023PHand Joseph Michael · Sheboygan Falls, WIBuilt 1966 · S/N 24-4485N9024PBlue Skies Above LLC · Bogart, GABuilt 1966 · S/N 24-4486N9025PIdeation Machine LLC · Las Vegas, NVS/N 24-4487N9028PBray Nick R Trustee · China Spring, TXBuilt 1966 · S/N 24-4490N9029PEzzell Stephen Mark · Statesville, NCS/N 24-4491N9030PPaso Rio LLC · Bouse, AZS/N 24-4492N9033PMiddletown LLC · Chandler, AZBuilt 1966 · S/N 24-4495N9034PNational Test Pilot School · Mojave, CABuilt 1966 · S/N 24-4496N9037PJack Ryan Aviation · Woodcliff Lake, NJS/N 24-4500N9042PWt Del Pl LLC · Newark, DEBuilt 1966 · S/N 24-4505N9050PFrisbee Robert P · Mcminnville, ORBuilt 1966 · S/N 24-4515
Back to AD 77-13-21