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.

N91RGM&M Aviation LLC · Pelzer, SCBuilt 1958 · S/N 24-115N91XCFitzgerald David R · Canton, OHBuilt 1971 · S/N 39-90N9200PWings & Wheels Lease Of Central Nebraska LLC · Broken Bow, NEBuilt 1967 · S/N 24-4693N9205PDt Pralle Enterprise Inc · Hampton, IAS/N 24-4700N9207PWissler John H · Tenino, WABuilt 1967 · S/N 24-4702N9211PBordeleau Michael V · Bridport, VTS/N 24-4706N9212PHapka Leon J · Halma, MNFirst renewal noticeBuilt 1967 · S/N 24-4707N9216PWilliams Dayre · Red Cloud, NEBuilt 1967 · S/N 24-4712N9217PGruber Joachim R · Elizabethtown, KYFirst renewal noticeBuilt 1967 · S/N 24-4713N9219PChrastka Keith · San Angelo, TXBuilt 1967 · S/N 24-4715N921BLLewis Bertrand V · Glendale, AZBuilt 1964 · S/N 30558N9220PDavid Rever Aviation LLC · Dewey Beach, DEBuilt 1967 · S/N 24-4716N9221PStevenson Tom · Portland, ORBuilt 1967 · S/N 24-4718N9222PAztec Remains LLC · Potosi, WIBuilt 1967 · S/N 24-4719N9224PAnde Leasing Co LLC · Edgewood, NMS/N 24-4721N9225PRegistered aircraftBuilt 1967 · S/N 24-4722N9227PSiebold Peter · Tehachapi, CABuilt 1967 · S/N 24-4717N9228PShillig Vance R · Colorado Springs, COS/N 24-4726N9229PKoeman Scott B · Fort Moore, GAS/N 24-4727N922JMApplied Aerospace Concepts Pllc · Bloomington, MNBuilt 1972 · S/N 24-5017N9231PSeaton Flying Services Inc · Salado, TXBuilt 1967 · S/N 24-4729N9233PBlandina Leon V · New Hudson, MIBuilt 1967 · S/N 24-4731N9235PJen Lyn Inc · Wilmington, DEFirst renewal noticeBuilt 1967 · S/N 24-4734N9236PTasso Aviation LLC · Orrville, ALS/N 24-4735N9237PCloud Climibers LLC · Lexington, KYBuilt 1967 · S/N 24-4736N9238PPylant Eric Jon · Arnold, CABuilt 1967 · S/N 24-4737N9241PGaskill Jeffrey V · Weston, MOS/N 24-4740N9242PDekervor Marc Phillippe II · La Mesa, CAS/N 24-4741N9243PKanne Michael J · Des Moines, IABuilt 1967 · S/N 24-4742N9246PSharp Paul C · Modesto, CABuilt 1967 · S/N 24-4745N9247PEhrenberg David G · Corning, NYBuilt 1968 · S/N 24-4746N9248PPajaro Jaison · Burtonsville, MDBuilt 1966 · S/N 24-4627N9250PBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 24-4747N9251PSalori Aviation LLC · Centralia, MOBuilt 1967 · S/N 24-4749N9252POsipov Yuri A · Lomita, CABuilt 1967 · S/N 24-4750N9253PConway Brandon · Springtown, TXBuilt 1967 · S/N 24-4751N9254PMeyer Aviation LLC · South St Paul, MNBuilt 1968 · S/N 24-4752N9255PSalvia Michael · Farmington Hills, MIBuilt 1968 · S/N 24-4754N9258PCessna 79432 LLC · Missoula, MTBuilt 1968 · S/N 24-4757N9259PChiarini Joshua · Cranston, RIBuilt 1968 · S/N 24-4758N925DGNwi Drones LLC · Chesterton, INBuilt 1960 · S/N 24-1870N9262PReliant Aeroworks LLC · Sanger, TXBuilt 1968 · S/N 24-4761N9263PWhitacre John B III · Waynesburg, OHBuilt 1968 · S/N 24-4762N9264PBeil Richard P Trustee · Caroline, WIBuilt 1968 · S/N 24-4763N9267PNickravesh Niknam J · San Jose, CABuilt 1968 · S/N 24-4767N9268PAts Inc · Chicago, ILBuilt 1968 · S/N 24-4768N9269PRegistered aircraftBuilt 1968 · S/N 24-4769N9270PPenn Landmark Corp · Pinehurst, NCS/N 24-4770N9272PH&R Aircraft LLC · Kansas City, MOBuilt 1968 · S/N 24-4772N9274PMurray John F · Crystal Lake, ILBuilt 1968 · S/N 24-4774
Back to AD 77-13-21