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.

N8159PRegistration Pending · Tucson, AZRegistration pendingBuilt 1963 · S/N 24-3414N8160PSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1963 · S/N 24-3415N8164PHobbs Phillip E · Matthews, NCBuilt 1963 · S/N 24-3419N8164YBrewer Steven G · Laconia, NHBuilt 1966 · S/N 30-1277N8165PJohnson Warford B II · Ozark, MOBuilt 1963 · S/N 24-3420N8167PDiehl Matthew · Elk River, MNBuilt 1963 · S/N 24-3423N8168PSchrump Donald R · Putnam, CTBuilt 1963 · S/N 24-3424N8169PLudlow Brent G · Murray, UTBuilt 1963 · S/N 24-3425N8170PLock Haven Aircraft Sales · Lock Haven, PABuilt 1963 · S/N 24-3426N8172YKline John C · Wolcottville, INBuilt 1966 · S/N 30-1286N8173YAltitude Aviation Group LLC · Kissimmee, FLS/N 30-1287N8174PIglewski Rudolph Daniel II · Apache Junction, AZBuilt 1963 · S/N 24-3430N8174YStansbury Todd V · Centennial, COS/N 30-1289N8175PCunningham James L · Tucson, AZBuilt 1963 · S/N 24-3431N8176PHundley Jeffrey S · Parker, COBuilt 1963 · S/N 24-3432N817KBaquero Eric P · New Castle, COBuilt 1963 · S/N 24-3445N8180PGriffin Robert · Middletown, DES/N 24-3436N8180YG2g Aviation LLC · Wray, COBuilt 1966 · S/N 30-1296N8181PTascosa Trail Inc · Gruver, TXBuilt 1963 · S/N 24-3437N8182PFaulkner Ronnie L · Mount Ida, ARBuilt 1963 · S/N 24-3439N8186YHeiter Aviation Services LLC · Leesburg, INS/N 30-1303N8187PKlein Dale A · Mandan, NDBuilt 1963 · S/N 24-3443N8187YWhite Jack S · Boone, NCFirst renewal noticeBuilt 1966 · S/N 30-1304N8188PPurdy Bryan T · Bryant, ARBuilt 1963 · S/N 24-3444N8188YFly Anytime LLC · Kankakee, ILBuilt 1966 · S/N 30-1305N818YInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 30-1458N8191PN8191p LLC · Snowflake, AZS/N 24-3447N8192YPlane Fun Inc Tr Trustee · Snellville, GABuilt 1966 · S/N 30-1309N8193PFlying Crooner LLC · Orlando, FLBuilt 1963 · S/N 24-3449N8194PMarrs Walter Scott · Chino, CAS/N 24-3450N8195PBoddington Aviation LLC · Portland, TXBuilt 1963 · S/N 24-3451N8196PWorkman Randy · Tipp City, OHBuilt 1963 · S/N 24-3270N8197YTyer Larry E Jr · Newnan, GABuilt 1966 · S/N 30-1316N8198YRoss Brian L · Eagle River, WIBuilt 1966 · S/N 30-1317N81LLJma Aviation LLC · Lakin, KSBuilt 1959 · S/N 24-1338N81MDTt Twins LLC · Fayetteville, GABuilt 1964 · S/N 30-512N8200PSix Five Papa Inc · Temple, NHBuilt 1963 · S/N 24-3452N8201YTorqmation Inc · Houston, TXS/N 30-1320N8203PDell John J · Saint Clair Shores, MIBuilt 1963 · S/N 24-3455N8203YMn98 LLC · Belview, MNBuilt 1966 · S/N 30-1322N8204YBlue Steele LLC · Barnegat, NJBuilt 1966 · S/N 30-1324N8206PMente Charles E · Ocala, FLS/N 24-3458N8206YBauer Electric Inc · Winona, MNBuilt 1966 · S/N 30-1331N8207YTwinkie Air LLC · Colville, WAS/N 30-1333N8208PGallacher Edwin T · Salt Lake City, UTBuilt 1963 · S/N 24-3460N8208YAirswiss Inc · Wilmington, DEBuilt 1966 · S/N 30-1334N8209PFox Black Enterprises Inc · Kilmarnock, VABuilt 1963 · S/N 24-3461N820TOneil John M · Leicester, NCFirst renewal noticeBuilt 1959 · S/N 24-1102N8210PJohnson James E · Calhoun, LABuilt 1963 · S/N 24-3463N8211YMccoy Darren T · Caledonia, MIBuilt 1966 · S/N 30-1338
Back to AD 77-13-21