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.

N8266YWerner Thomas E · Newark, DEBuilt 1966 · S/N 30-1394N8267YMh Aviation Inc · Lancaster, CABuilt 1966 · S/N 30-1395N8268YBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 30-1397N8269PEarley Douglas J · Covina, CABuilt 1963 · S/N 24-3522N8270PKraemer And Co Mfg Inc · Orland, CABuilt 1963 · S/N 24-3523N8271YWhitley Miles G · Olathe, KSBuilt 1966 · S/N 30-1400N8273YSkyway Air Service Inc · Wichita, KSBuilt 1966 · S/N 30-1402N8274PVenticinque Raymond A · Cranston, RIBuilt 1963 · S/N 24-3527N8274YTwinkie Transport LLC · Palm City, FLBuilt 1966 · S/N 30-1403N8278PDewalt Rodney P · Fort Worth, TXBuilt 1963 · S/N 24-3530N8281PDubois Jean-Claude · Midlothian, TXS/N 24-3533N8283PPolzin Thomas H · Chippewa Falls, WIBuilt 1963 · S/N 24-3535N8284PTonry Richard Martin · Georgetown, TXBuilt 1963 · S/N 24-3536N8285PPhillips Dale J · Michigan City, INBuilt 1963 · S/N 24-3537N8286PStage Crew LLC · Clermont, FLBuilt 1963 · S/N 24-3538N8286YCoub Industries Inc · Fairfield, CABuilt 1967 · S/N 30-1422N8287PDeviny William M Jr · Arroyo Grande, CABuilt 1963 · S/N 24-3539N8288PStelter John · Clancy, MTBuilt 1963 · S/N 24-3540N8290PEmge Douglas W · Albertville, ALBuilt 1963 · S/N 24-3543N8291PWilcher Trevor C · Macungie, PABuilt 1963 · S/N 24-3544N8292PCharles City Aeronautics Inc · Charles City, IABuilt 1963 · S/N 24-3545N8294YNenno Richard W II · Bothell, WABuilt 1967 · S/N 30-1432N8296YBl Aviation Services LLC · Camden, DEBuilt 1967 · S/N 30-1435N8298PBaumann Christopher · Plant City, FLBuilt 1963 · S/N 24-3234N8298YEstes Bernard R · Bumpass, VABuilt 1967 · S/N 30-1437N8299PFischer Dale R · Laporte, INBuilt 1963 · S/N 24-3277N82RJLynch James D Jr · Ocala, FLBuilt 1966 · S/N 30-1049N8302YArnold Roger R · Jonesville, LAS/N 30-1441N8304YLusk Thomas L · Centennial, COS/N 30-1443N8309YHolman Michael J · Anchorage, AKBuilt 1967 · S/N 30-1448N8310PPremiere Aviation Inc · Concord, CABuilt 1963 · S/N 24-3560N8311PDuckett Kristofer · Fairfield, CAS/N 24-3561N8311YAj Air LLC · Cape Girardeau, MOBuilt 1967 · S/N 30-1450N8313PSpencer Cory · Mobile, ALBuilt 1963 · S/N 24-3563N8313YUnusual Attitudes LLC · Bates City, MOBuilt 1967 · S/N 30-1452N8315PSquawk Wv LLC · Morgantown, WVBuilt 1963 · S/N 24-3565N8315YGolden Compass Aviation LLC · Wilmington, DEBuilt 1967 · S/N 30-1455N8316PHolbrook James K · West Liberty, KYBuilt 1963 · S/N 24-3567N8316YSchubnell Ryan A · Avondale Estates, GAS/N 30-1456N8318PPlane Old Memes LLC · Seminole, FLBuilt 1964 · S/N 24-3569N831JRRegistration Pending · High Springs, FLRegistration pendingBuilt 1959 · S/N 24-585N8320PCallicrate Michael P · Saint Francis, KSBuilt 1963 · S/N 24-3571N8320YKling Aviation Inc · Friendswood, TXBuilt 1967 · S/N 30-1460N8322YDayhoff Miller Alice J · Springfield, OHBuilt 1967 · S/N 30-1463N8324PCirrus Air LLC · Eden, NCBuilt 1963 · S/N 24-3575N8324YStein Anthony J · Locust Grove, GABuilt 1967 · S/N 30-1465N8326YEastern Stearman Inc Trustee · Leesburg, VABuilt 1967 · S/N 30-1468N8327YKaeser Robert E · Lafayette, INBuilt 1967 · S/N 30-1469N8328PSale Reported · Lewes, DESale reportedS/N 24-3581N8328YSims Chris · Colleyville, TXBuilt 1967 · S/N 30-1470
Back to AD 77-13-21