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.

N9276PHansen Stephen J · Redmond, WAS/N 24-4776N9279PArdis Mitchell Farm LLC · Winnsboro, TXBuilt 1968 · S/N 24-4780N9282PCampbell Paul · Glade Spring, VABuilt 1968 · S/N 24-4782N9284PDickinson Malcolm · Stamford, CTBuilt 1968 · S/N 24-4784N9285PStumpf Bernard L · Westerly, RIBuilt 1968 · S/N 24-4785N9288PLivingston Jerry D · Wichita, KSBuilt 1968 · S/N 24-4788N9289PSvetlik Ludvik Julius · Victoria, TXS/N 24-4789N9292PRegistered aircraftBuilt 1968 · S/N 24-4791N9293PCenterline Holdings Inc · Camden, DEBuilt 1968 · S/N 24-4792N9294PJensen Thomas · Durango, COBuilt 1968 · S/N 24-4793N9296PStevens John W · Westlake Village, CABuilt 1968 · S/N 24-4795N9297P9797p LLC · San Angelo, TXBuilt 1968 · S/N 24-4796N92BHHeydorff Stephen F Trustee · Sierra Madre, CABuilt 1969 · S/N 30-1852N92EEGw Aero LLC · Arnold, MDBuilt 1959 · S/N 24-1668N92NEAnderson Aviation LLC · Bulverde, TXBuilt 1964 · S/N 30-459N9303PDyster Justin C · Coeur D Alene, IDBuilt 1968 · S/N 24-4799N9308PExecutive Enterprise Solutions LLC · Mount Pleasant, SCBuilt 1969 · S/N 24-4804N9312PGregory John P · Riverside, CABuilt 1969 · S/N 24-4808N9313PPencosky Edward A Jr · Manorville, NYBuilt 1969 · S/N 24-4809N9315PGrady Michael J · Farmington, NMBuilt 1969 · S/N 24-4811N9316PProvost Stephen Nicholas · Saint Louis, MOBuilt 1969 · S/N 24-4812N9317PFutter John H · Whately, MABuilt 1969 · S/N 24-4813N9318PPorter Wayne · Phoenix, AZBuilt 1969 · S/N 24-4814N9321PRegistered aircraftBuilt 1969 · S/N 24-4818N9325PCody William James · South Lyon, MIBuilt 1969 · S/N 24-4822N9327PKrb LLC · Rupert, IDBuilt 1969 · S/N 24-4825N9329PLenders Insurance Solutions Group LLC · Ozark, MOBuilt 1969 · S/N 24-4827N9331PAmra Nabil · Chaska, MNS/N 24-4829N9333PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 24-4831N9337PWesterfield John III · Birmingham, ALBuilt 1969 · S/N 24-4835N9338PDream Home Aviation Inc · New Smyrna Beach, FLS/N 24-4836N9339PBreznik John D · Bradford, PABuilt 1969 · S/N 24-4837N9342PTaulbee Gregory · Sarasota, FLBuilt 1969 · S/N 24-4840N9344PWheeler R Tyson · Frederick, MDBuilt 1969 · S/N 24-4843N9345PRegistration Pending · Gilbert, AZRegistration pendingBuilt 1969 · S/N 24-4844N9347PRegistered aircraftBuilt 1969 · S/N 24-4846N9353PSmith Evan B · Mechanicsville, VABuilt 1969 · S/N 24-4854N9356PMente Charles · Homestead, FLBuilt 1969 · S/N 24-4856N9357PNewman Joseph G · Grand Ledge, MIBuilt 1960 · S/N 24-2033N9358PJeneson Tim · Ketchum, IDBuilt 1969 · S/N 24-4858N9359PCarter James D · Carlton, TXBuilt 1969 · S/N 24-4859N9364PTougas William E · Timberlake, NCBuilt 1969 · S/N 24-4864N9369PLoadstone Aviation LLC · Billings, MTBuilt 1969 · S/N 24-4869N936RGrandinetti Robert L · Fayetteville, NYBuilt 1967 · S/N 30-1580N9371PBuschmann Robert O Jr Trustee · Prescott, AZBuilt 1969 · S/N 24-4871N9372PBeery Milo A · Clarinda, IABuilt 1969 · S/N 24-4872N9373PLeff Benjamin Franklin · Cedar Park, TXBuilt 1969 · S/N 24-4873N9379PAerodata Inc · Edgewater, MDBuilt 1969 · S/N 24-4880N9380PEchelmeier Stanton M · Fort Payne, ALBuilt 1969 · S/N 24-4881N9381PSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-4882
Back to AD 77-13-21