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.

N7873PKirtley Kevin R · Boise, IDBuilt 1962 · S/N 24-3099N7875P3 Commanches Aviation LLC · Williamston, SCBuilt 1962 · S/N 24-3101N7875YDodson Carl F · Jasper, INBuilt 1965 · S/N 30-959N7876PCrouse Gregory T · Napa, CABuilt 1962 · S/N 24-3102N7877PMiller Kenneth · Jennings, LAS/N 24-3103N7879PKeenan Matthew J · Clearwater, FLBuilt 1962 · S/N 24-3105N787ANDixon Richard W · Laytonsville, MDBuilt 1962 · S/N 24-3308N787KSWalden Franklin S · Southern Pines, NCBuilt 1964 · S/N 24-3644N7882PWaters Robert D · Albuquerque, NMBuilt 1962 · S/N 24-3110N7883PFinke Michael C · Pleasant Prairie, WIBuilt 1962 · S/N 24-3111N7883YHoward Jerry W · Snellville, GABuilt 1965 · S/N 30-968N7885YKregel Steven · Garnavillo, IABuilt 1965 · S/N 30-970N7887P7887papa LLC · Glenwood Springs, COBuilt 1962 · S/N 24-3116N7887YAskins Jack C · Wichita Falls, TXBuilt 1966 · S/N 30-973N7888YBurkel Robert G · Hemet, CABuilt 1966 · S/N 30-975N7890YMhr Leasing LLC · Hickory Corners, MIBuilt 1966 · S/N 30-977N7891PN7891p Partners LLC · Suffolk, VABuilt 1962 · S/N 24-3120N7892YHarrison Richard J · South Hamilton, MABuilt 1966 · S/N 30-979N7893PBas Part Sales LLC · Greeley, COS/N 24-3122N7893YRegistered aircraftBuilt 1966 · S/N 30-980N7898PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 301873N7898YPatry Aeronautical Institute · Kalispell, MTBuilt 1966 · S/N 30-986N78PWPower Joe D · Seguin, TXBuilt 1963 · S/N 24-3434N78RJUsaeroflight LLC · Greenville, SCBuilt 1970 · S/N 39-21N7900PGoco Wireless Inc · Goliad, TXBuilt 1962 · S/N 24-3130N7900YLone Star Aircraft Holding Group LLC · Plano, TXS/N 30-987N7901YHinshaw Eric C · Lake Wales, FLBuilt 1966 · S/N 30-988N7902YCohn David · Port Townsend, WABuilt 1966 · S/N 30-990N7903PCaple Colby L · Windsor, COS/N 24-3133N7905PComanche250 LLC · Sequim, WAS/N 24-3136N7905YPatterson Thomas A · Minerva, OHBuilt 1966 · S/N 30-994N7907PSchwartz Tyson E · Midland, TXBuilt 1961 · S/N 24-3138N7910PStanford Richard E · Oklahoma City, OKBuilt 1962 · S/N 24-3141N7914PBethers James D · Montpelier, IDBuilt 1962 · S/N 24-3145N7915YTurbine Financial Group LLC · Ogden, UTBuilt 1966 · S/N 30-1005N7916YHurlston Glen David · Leesville, LABuilt 1966 · S/N 30-1006N7919PBailey Stephen J · Wichita Falls, TXS/N 24-3151N7919YKeller Paul W · Austin, TXBuilt 1966 · S/N 30-1009N7920PM & K Zeiler Aircraft LLC · Lawrence, KSBuilt 1962 · S/N 24-3152N7922PKeener & Assoc Inc · North Myrtle Beach, SCBuilt 1963 · S/N 24-3155N7922YSuhrie Mark A · Oneida, KYS/N 30-1012N7923PRichards Michael Dean · Burneyville, OKBuilt 1962 · S/N 24-3156N7924PWest Texas Weather Modification Association · San Angelo, TXBuilt 1962 · S/N 24-3157N7925PJapundza Bob · Kokomo, INBuilt 1962 · S/N 24-3159N7928PPeterson Jay O · Las Vegas, NVBuilt 1962 · S/N 24-3162N7928YW Carney LLC · Ocala, FLBuilt 1966 · S/N 30-1019N7929PSmh Aviation LLC · Johnstown, COBuilt 1962 · S/N 24-3163N7929YMasek Lawrence J · Cuyahoga Falls, OHBuilt 1966 · S/N 30-1020N7930PBotimer Douglas L · Fullerton, CABuilt 1962 · S/N 24-3164N7930YShort Final LLC · Mooresville, NCS/N 30-1021
Back to AD 77-13-21