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.

N417BHHugel Bohdan · Selma, NCBuilt 1962 · S/N 24-3108N41AEBowen Haldor S · Sandpoint, IDS/N 24-637N41BPSturdevant Harold L Jr · Kalispell, MTS/N 30-644N41LPulliam Oscar E Jr · Moscow, TNBuilt 1958 · S/N 24-351N41PLTj Air Holdings Inc Trustee · Wilmington, DES/N 30-1293N4236PRegistration Pending · Chandler, AZRegistration pendingS/N 24-1260N4250Leafgreen Jeff A Trustee · Lander, WYBuilt 1959 · S/N 24-894N4269WZeek Michael · Munfordville, KYFirst renewal noticeS/N 30-1258N4284Clements Eric C · Sheridan, WYBuilt 1965 · S/N 24-4284N4297ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N 39-114N42PMJofredo Corp · Zephyrhills, FLBuilt 1969 · S/N 30-1932N42TPBalkin John S · Bigfork, MTBuilt 1964 · S/N 30-255N430MMMersereau Iden H · Goodyear, AZBuilt 1966 · S/N 24-4525N431ABAirtrust LLC - 18 - Series 18 Trustee · Sheridan, WYS/N 24-4156N434BBElgin Engineering LLC · Arlington, TXBuilt 1966 · S/N 24-4536N43BLockard Seth J · Lebanon, TNBuilt 1963 · S/N 30-226N43TLT M L Aircraft Inc · Narrowsburg, NYBuilt 1971 · S/N 24-5001N444CPMercure Ryan K · Eads, TNBuilt 1963 · S/N 30-230N4483CRich Aden Gene · Sequim, WABuilt 1959 · S/N 24-1257N44PCGenocchio Anthony F · New Port Richey, FLBuilt 1965 · S/N 24-4124N44WDDemray William S · Northville, MIBuilt 1969 · S/N 30-1860N4563VMercer Alexander David · San Diego, CABuilt 1958 · S/N 24-129N456PBooth Donald V · Denison, TXS/N 24-3276N45888D-Five Holdings Group LLC · Vidor, TXBuilt 1963 · S/N 24-3453N45JLBows Investments LLC · Bend, ORS/N 39-148N45MBWright Kelly A · Spokane, WABuilt 1959 · S/N 24-1445N46EAEssential Aviation LLC · Meridianville, ALBuilt 1970 · S/N 39-79N46MJones Gregory D · Pueblo, COBuilt 1958 · S/N 24-411N46PHarrison Donna J · Eau Claire, MIBuilt 1966 · S/N 24-4470N4743MMcbride Paul · Dallas, TXBuilt 1969 · S/N 301848N475TVPaine Twin Comanche LLC · Redmond, WABuilt 1966 · S/N 30-1366N478WTBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 24-4634N47BBRogers Joseph O III · Fernandina Beach, FLBuilt 1960 · S/N 24-1889N48086Spohrer Wilner And Maxwell P A · Jacksonville, FLS/N 30-1421N487SCRegistered aircraftBuilt 1959 · S/N 24-1346N48ARGacey Inc Trustee · Wilmington, DEBuilt 1966 · S/N 30-1328N4949YPearce Richard Henry · Moses Lake, WAS/N 30-648N494NJT And B Flying Adventures LLC · Middletown, DES/N 30-494N4960250 Inc · Washington, DCS/N 24-4025N4995BStobbe Marlin L · Granada Hills, CAS/N 24-4501N49WSJohnson Matthew N · Redgranite, WIBuilt 1966 · S/N 30-1393N4CBDream Catcher Company LLC · Center, COBuilt 1964 · S/N 24-3607N4CKLorenzo Walker Institute Of Technology · Naples, FLBuilt 1967 · S/N 30-1645N4PLJuliet Kilo Aviation LLC · Palos Heights, ILBuilt 1961 · S/N 24-2400N4XNMiller Donald W · Harrisonburg, VABuilt 1971 · S/N 244990N4YASoaring Eagle Southwest LLC · Fort Mohave, AZS/N 30-365N5002POrtman Bernard · Deer Park, TXBuilt 1957 · S/N 24-5N5003PLouwagie Bradley J · Marshall, MNFirst renewal noticeBuilt 1957 · S/N 24-6N5005PRackley William R Jr · Grand Island, FLBuilt 1957 · S/N 24-8N5006PWright William · Cleveland, OKBuilt 1957 · S/N 24-9
Back to AD 77-13-21