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.

N8212PTweeddale Thomas Allan · Denton, TXBuilt 1963 · S/N 24-3465N8213YBoomer Joshua G · Floyds Knobs, INBuilt 1966 · S/N 30-1340N8215PAme LLC · Kalispell, MTBuilt 1963 · S/N 24-3468N8215YGlassburn Teresa L · Winthrop, WAS/N 30-1343N8216YMedia Stew LLC · Carson City, NVS/N 30-1344N8217PDanilchuk Phillip A · Auburn, GAS/N 24-3470N8217YMaledy John Trustee · Salem, MOBuilt 1966 · S/N 30-1345N8219YDurden Julian F Jr · Twin City, GABuilt 1966 · S/N 30-1347N8220PParsell Scott · Katy, TXBuilt 1963 · S/N 24-3473N8221PMoreau Donald G · Dayton, TXBuilt 1963 · S/N 24-3474N8221YBill Kennedy Aviation LLC · Stuart, FLBuilt 1966 · S/N 30-1349N8222PWeirich Joseph J · South Milwaukee, WIBuilt 1963 · S/N 24-3475N8224YWoodard Earl G Jr · Danville, GABuilt 1966 · S/N 30-1353N8226YC P L Air LLC · Middletown, DEBuilt 1966 · S/N 30-1356N8234YBurkey Jeffrey C · Stuart, FLBuilt 1966 · S/N 30-1360N8235PZiesman Ernest D · Henderson, NVBuilt 1963 · S/N 24-3488N8235YLyons Kenneth L · Port Neches, TXS/N 30-1361N8236PLeary Patrick W · Lewistown, MTBuilt 1963 · S/N 24-3490N8237PNarveson Kristian · Pueblo West, COBuilt 1963 · S/N 24-3491N8239P3so II LLC · Louisville, KYBuilt 1963 · S/N 24-3493N8239YMurray Coy L · Guntersville, ALBuilt 1966 · S/N 30-1365N8241PRegistered aircraftBuilt 1963 · S/N 24-3495N8242PLake Donald T · Green Valley, AZFirst renewal noticeBuilt 1963 · S/N 24-3496N8243PMountain Mooney Inc · Idaho Falls, IDS/N 24-3497N8243YHampton Brent · Edgewood, TXBuilt 1966 · S/N 30-1369N8244YDow Jeff · Port Hadlock, WABuilt 1965 · S/N 30-917N8246YVon Gruben Steven E · Bonita Springs, FLBuilt 1967 · S/N 30-1372N8247PEldredge Michael J · Modesto, CABuilt 1963 · S/N 24-3501N8248PArmstrong Kristian Trustee · Airville, PABuilt 1963 · S/N 24-3502N8249POgan Steve G · Pierre, SDBuilt 1963 · S/N 24-3503N8250PSedberry Jason A · Kokomo, INS/N 24-2563N8250YStoltz Kevin · Locust Grove, GABuilt 1966 · S/N 30-1376N8251PDefranco Ross A · Los Angeles, CABuilt 1963 · S/N 24-3505N8254PRegistered aircraftAssigned, pending cancellationS/N 24-3508N8254YCrimson Aviation LLC · Helena, MTBuilt 1966 · S/N 30-1380N8255PKanooth Michael L · Washougal, WABuilt 1963 · S/N 24-3509N8256PHouse Terry J · Mountain View, ARBuilt 1963 · S/N 24-3233N8256YPhill-Air Inc · Dover, DEBuilt 1967 · S/N 30-1382N8257PWipf Ryan C · Mound, MNS/N 24-3510N8258PThings That Fly LLC · Phoenix, AZBuilt 1963 · S/N 24-3511N8258YJohnson David C · Chisago City, MNBuilt 1966 · S/N 30-1384N8259YRyan Ferguson LLC · Sanford, FLBuilt 1966 · S/N 30-1386N825CRWolken Ralph E · Shady Shores, TXBuilt 1959 · S/N 24-1227N8261PWarzek Mary Ann · Halfmoon, NYS/N 24-3514N8261YWilliams Brannon R · Fort Worth, TXBuilt 1966 · S/N 30-1388N8262YAchamp LLC · Memphis, TNBuilt 1966 · S/N 30-1390N8264PChavez Raul M · Comanche, TXBuilt 1963 · S/N 24-3517N8264YPatterson Casey Paul · Kinston, ALBuilt 1966 · S/N 30-1392N8265PNiemiec Andrew Josephtrustee · Anchorage, AKBuilt 1963 · S/N 24-3518N8266POtto David M · Gig Harbor, WABuilt 1963 · S/N 24-3519
Back to AD 77-13-21