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.

N250LJCarew Aviation Inc · Appleton, WIBuilt 1964 · S/N 24-3393N250PCHerndon Timothy M · Kingston, OKBuilt 1959 · S/N 24-1133N250RBWestern Slope Aviators LLC · Delta, COBuilt 1958 · S/N 24-334N250TJTalley John T · Clifton, TXBuilt 1959 · S/N 24-1048N25MHumble Ventures Inc · Tempe, AZBuilt 1965 · S/N 24-4221N25PRInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 30-1511N260BCFlying J LLC · Bulverde, TXBuilt 1967 · S/N 24-4606N260CDMarlow Bruce D - Trustee · Nevada City, CABuilt 1966 · S/N 24-4389N260DTInternational Air Services Inc Trustee · Carson City, NVS/N 24-4995N260GCFeline Health Inc · Hampstead, NCBuilt 1969 · S/N 24-4834N260JFKropp Christian Trustee · Azle, TXBuilt 1965 · S/N 24-4196N260NCYounhorsh Sales LLC · Wilmington, DEBuilt 1969 · S/N 24-4855N260PCRegistered aircraftBuilt 1965 · S/N 24-4125N260SCN260sc Partnership Group LLC · Ogden, UTBuilt 1964 · S/N 24-3678N264GCon-Air Aviation LLC · Queen Creek, AZBuilt 1967 · S/N 30-1633N2654ESch Aviation Inc Trustee · Sporle Kings LynnBuilt 1971 · S/N 39-93N266LCCambridge Aviation LLC · Hillsborough, NJBuilt 1966 · S/N 30-1157N266WLowell James · Tucson, AZS/N 24-1923N269YEyles Richard L · Galloway, OHBuilt 1965 · S/N 30-798N26BWBestul Greg · Lester Prairie, MNBuilt 1967 · S/N 30-1559N26CXCiholas Philippe A · Sedgwick, KSBuilt 1970 · S/N 244949N26RJRoedel Road Co · Kewadin, MIBuilt 1969 · S/N 30-1886N276JSEagle Flight Academy LLC · Owensboro, KYBuilt 1964 · S/N 30-422N277DDWicked Flyby LLC · Lewes, DEBuilt 1960 · S/N 24-1818N2782YDegroff Steven A · Berne, INBuilt 1964 · S/N 26-59N27BRLarson Allen L · Capron, ILBuilt 1969 · S/N 24-4909N27PCRegistration Pending · Houston, TXRegistration pending, pending cancellationBuilt 1962 · S/N 24-3022N282PGitlow Stuart · Woonsocket, RIBuilt 1964 · S/N 30-508N287GE7ge Aviation LLC · Southfield, MIFirst renewal noticeBuilt 1964 · S/N 30-522N288ABSyrasoft Aviation LLC · Baldwinsville, NYBuilt 1962 · S/N 24-3033N289WWVision Aircraft II LLC · Scottsdale, AZBuilt 1971 · S/N 39-84N289ZZAero Mobil Inc · Wilmington, DEBuilt 1969 · S/N 39-88N2904PRandall Airlines LLC · Wendell, NCBuilt 1965 · S/N 24-4191N292REStructure Inc · Neenah, WIBuilt 1965 · S/N 30-768N2947Moran M Michael · Chico, CAS/N 24-4681N29BJMax Total Time LLC · Lufkin, TXBuilt 1958 · S/N 24-398N29SCBrown Sherrie C · Cushing, OKBuilt 1962 · S/N 24-3125N2ABBailey Richard T · Oregon City, ORBuilt 1960 · S/N 24-1941N2DVLewis Paul A · Spring, TXBuilt 1960 · S/N 24-1679N2RTBarnett Keri Trustee · Brownfield, TXBuilt 1969 · S/N 24-4830N2SVPiper J D · Lawrenceville, ILBuilt 1963 · S/N 24-3428N2VGWong Jonathan · Phoenix, AZBuilt 1969 · S/N 30-1875N2VQN2vq LLC · Manassas, VABuilt 1964 · S/N 30-563N2XHAmericas Best Amt Inc · Goodyear, AZBuilt 1964 · S/N 30-473N2YPCollum Aviation LLC · Milton, FLS/N 30-452N300MMHamblin Kenneth · Stanton, TNBuilt 1965 · S/N 30-851N300REMoreau Leo B · Wasilla, AKBuilt 1965 · S/N 30-841N301EMMcconwell Edward A · Mission, KSBuilt 1965 · S/N 30-916N3030WZadnik Gary R · Vacaville, CAS/N 24-3534N306AKRobinson Thomas F II · Port Charlotte, FLBuilt 1966 · S/N 30-1253
Back to AD 77-13-21