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.

N5980PKalil Joseph M · Tucson, AZBuilt 1959 · S/N 24-1073N5985PDavis Marc E · Hillsboro, ORBuilt 1959 · S/N 24-1078N5994PPendry Jan-Simon · San Martin, CABuilt 1959 · S/N 24-1088N5995PN5995p LLC · Palmetto, FLBuilt 1959 · S/N 24-1089N5997PN5997p LLC · Madison, ALBuilt 1959 · S/N 24-1092N5999PNewnum Richard · Kernersville, NCBuilt 1959 · S/N 24-821N59LVGreek John W · Tustin, CABuilt 1959 · S/N 24-1229N59RHSmith Mikeal A · Acton, CABuilt 1959 · S/N 24-1006N5BKRegistered aircraftBuilt 1961 · S/N 24-2677N5BYWolff Emanuel C Md · Tucson, AZBuilt 1963 · S/N 30-105N5EBN5eb LLC · Medina, OHBuilt 1967 · S/N 30-1474N5MAScola Daniel B · Port Orange, FLBuilt 1967 · S/N 30-1622N5WKEz Air Inc · Wilmington, DES/N 30-1853N5WWClark Nikita C · Ontario, ORBuilt 1965 · S/N 30-708N6001PZarate Roger L · La Mirada, CABuilt 1959 · S/N 24-1095N6008XMangum Gary W · Centreville, VABuilt 1969 · S/N 301836N600AHCoastal Road Aviation LLC · Mukilteo, WABuilt 1969 · S/N 24-4863N6014PTwo Men And A Plane Inc · Dearborn, MIBuilt 1959 · S/N 24-1109N6015PWeeks Vaughan B · Racine, WIBuilt 1959 · S/N 24-1110N6016PCorson Dana · Helena, MTBuilt 1959 · S/N 24-1111N6019PN6019p LLC · Washington, DCBuilt 1959 · S/N 24-1114N6022PRegistered aircraftBuilt 1959 · S/N 24-1117N6027PJourney Over Destination Aviation LLC · Golden, COBuilt 1959 · S/N 24-1122N6030PAngel Aviation LLC · Paradise, KSBuilt 1959 · S/N 24-1126N6032PStarrynight Bonanza Group LLC · Brighton, COBuilt 1959 · S/N 24-1128N6035PWhited Craig L · Redington Beach, FLBuilt 1959 · S/N 24-1131N6036PKoop Christopher N · Lake Orion, MIS/N 24-1132N6039PProcredential LLC · Raleigh, NCBuilt 1959 · S/N 24-1135N6040PWerner Christopher R · Anderson, CABuilt 1959 · S/N 24-1136N6043PRoberts Ronald L · Pismo Beach, CABuilt 1959 · S/N 24-1139N6045PEverroad Richard L · Bloomington, INBuilt 1959 · S/N 24-1141N6048PJohnson Keith A · Atlantic Beach, FLBuilt 1959 · S/N 24-1144N6049PMurolo Michael · Clancy, MTS/N 24-1145N6050PNeuman Michael R · Valencia, PABuilt 1959 · S/N 24-1146N6052POn Site Aviation Inc · Hillsboro, NDBuilt 1959 · S/N 24-1148N6054PMartinez Juan R · San Bruno, CABuilt 1959 · S/N 24-1150N6056PN6056p LLC · Sonoma, CABuilt 1959 · S/N 24-1152N6057PAerdonlen · Pensacola, FLBuilt 1959 · S/N 24-1153N6059PShearer Jay E · Coshocton, OHBuilt 1959 · S/N 24-1155N6062PYoung Tracy K · Newcomerstown, OHS/N 24-1158N6067PRoark William B · Silverdale, WABuilt 1959 · S/N 24-1163N6070PParcell Charles W · La Canada Flt, CABuilt 1959 · S/N 24-1166N6071PKohler Thomas M · Brant Beach, NJS/N 24-1167N6073PBradshaw James L · Lenoir, NCBuilt 1959 · S/N 24-1169N6074PBerlingen Michael W · Oregon City, ORBuilt 1959 · S/N 24-1170N6075PMoore Leslie D · Raymore, MOBuilt 1959 · S/N 24-1171N6079PColson Carl L · Blunt, SDBuilt 1959 · S/N 24-1177N6087PBrandner Paul D · Lake Tapps, WABuilt 1959 · S/N 24-1186N6089PMichaelsen Richard P · Sanborn, NYBuilt 1959 · S/N 24-1188N6090PBasin Franchising LLC · Vernal, UTBuilt 1959 · S/N 24-1189
Back to AD 77-13-21