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.

N6207PSquawk 2310 LLC · Ridgefield, WABuilt 1959 · S/N 24-1309N6210PHolbrook Glen A · Marion, WIFirst renewal noticeBuilt 1959 · S/N 24-1312N6211PPounds Kenneth M · Pueblo West, COBuilt 1959 · S/N 24-1313N6212PJobin Lyle S · Madeira Beach, FLBuilt 1959 · S/N 24-1314N6216PDuvall James Grafton III · Silver Springs, NVBuilt 1959 · S/N 24-1318N6218PSmith Ron E · Goodlettsville, TNBuilt 1959 · S/N 24-1320N6221PLicata Paul Z · Mexico, MOS/N 24-1323N6222PPacheco Carlos Antonio · Yuma, AZBuilt 1959 · S/N 24-1324N6224PDattilio Joseph · Wasilla, AKS/N 24-1326N6225PMcvey Charles D · Merritt Island, FLBuilt 1959 · S/N 24-1327N6226PHofstetter Fred M · Boerne, TXBuilt 1959 · S/N 24-1328N6229PA2a Aviation Inc · Simsbury, CTBuilt 1959 · S/N 24-1332N622BRidley Aircraft & Aviation Services LLC · Gilbert, AZBuilt 1966 · S/N 1341N6236PHill Scott G · Mcdonough, GABuilt 1959 · S/N 24-1341N6240POrtiz Raul D · Fredericksburg, VABuilt 1959 · S/N 24-1345N6244PSimon Projects LLC · Sebastian, FLBuilt 1959 · S/N 24-1349N6245PBishop Warren · Iowa City, IABuilt 1959 · S/N 24-1351N6249PKeller Richard A · Stacy, MNBuilt 1959 · S/N 24-1356N6251PPearce Donnie D · Mena, ARBuilt 1959 · S/N 24-1358N6254PMcphee Michael Andrew · Cherokee, TXBuilt 1959 · S/N 24-1361N6256PReilly Thomas J · Happy Valley, ORBuilt 1959 · S/N 24-1363N6259PWyant Dustin Jay · Great Bend, KSBuilt 1959 · S/N 24-1366N6260PLarson Jeffery A Trustee · Marysville, CABuilt 1959 · S/N 24-1368N6261PRice Brent M · Onalaska, WABuilt 1959 · S/N 24-1369N6263PBerg Robert Martin · Madras, ORS/N 24-1371N6267PFlyhigh LLC · Midlothian, VABuilt 1959 · S/N 24-1375N626DWWings Of Freedom LLC · Big Bear Lake, CABuilt 1969 · S/N 30-1799N626NRJones Robert D · Chestertown, MDBuilt 1970 · S/N 39-82N6271PMckee Kelvin K · Amelia Island, FLBuilt 1959 · S/N 24-1379N6272PLearis Aviation LLC · Missoula, MTBuilt 1959 · S/N 24-1380N6274PStowers Marc S · Lakewood, CABuilt 1959 · S/N 24-1383N6278PPearson Phillip T · Sutherland, NEBuilt 1959 · S/N 24-1387N6281PTomorrow Horizons LLC · Urbana, OHBuilt 1959 · S/N 24-1390N6284PThomson William O · Simsbury, CTBuilt 1959 · S/N 24-1394N6286PFuechsel Robert Marcus · Pocatello, IDBuilt 1959 · S/N 24-1396N6288PKeenan Douglas P · Boulder Creek, CABuilt 1959 · S/N 24-1398N6289PRegistered aircraftAssigned, pending cancellationS/N 24-1399N6293PAndersen Ted · Alamosa, COS/N 24-1403N6298PN6298p Inc · Okeechobee, FLBuilt 1959 · S/N 24-1278N62FRRossi A F · Belmont, CABuilt 1965 · S/N 30-646N6301PDavid A Gowan · Templeton, CABuilt 1959 · S/N 24-1410N6302PBarber Stephen R · Gainesville, GABuilt 1959 · S/N 24-1411N6303PMarlette Ellen J · Cohasset, MAS/N 24-1413N6310PPopel John G Sr Trustee · Piqua, OHBuilt 1959 · S/N 24-1420N6316PHitt Edward L · Statesboro, GAS/N 24-1426N6317PYounhorsh Sales LLC · Wilmington, DEBuilt 1959 · S/N 24-1427N6318PBlaha Karl F · Ocala, FLBuilt 1959 · S/N 24-1428N6319PBedenbaugh Michael B · Lake City, FLBuilt 1959 · S/N 24-1429N6327PSunspot Investment Corp · Marathon, FLBuilt 1959 · S/N 24-1436N6329PKhan Adam Iqbal Ahmed · Sanger, TXBuilt 1959 · S/N 24-1438
Back to AD 77-13-21