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.

N8811YHutchinson Douglas E · Cle Elum, WABuilt 1969 · S/N 30-1968N8812PRegistered aircraftBuilt 1965 · S/N 24-4267N8812YSpain Air LLC · Dadeville, ALBuilt 1969 · S/N 30-1969N8813PWolcott Kent E · Colorado Springs, COBuilt 1965 · S/N 24-4268N8814YTwin C 14y LLC · Cape Coral, FLBuilt 1969 · S/N 30-1972N8815YBauer Andrew J · Concord, NCBuilt 1969 · S/N 30-1973N8817PTei Corp · Kalispell, MTBuilt 1965 · S/N 24-4273N8817YWiehl Thomas K III · Earlysville, VABuilt 1969 · S/N 30-1975N8818YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 30-1976N8819PN8819p LLC · Boca Raton, FLBuilt 1965 · S/N 24-4275N8822PCornwell Charles E · Tucson, AZBuilt 1965 · S/N 24-4278N8823YFerrara John M · Newtown, PABuilt 1969 · S/N 30-1981N8824PAzimi Matthew H · Navarre, FLBuilt 1965 · S/N 24-4280N8826PIngalls Equipment LLC · Redlands, CABuilt 1965 · S/N 24-4282N8829PInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 24-4285N8830PCanon Daniel H · Fruit Cove, FLBuilt 1965 · S/N 24-4286N8832PRoundtree Benjamin · Cass City, MIBuilt 1965 · S/N 24-4288N8833PRegistered aircraftBuilt 1965 · S/N 24-4289N8833YGagan Samrat LLC · Charlotte, NCBuilt 1969 · S/N 30-1991N8835PFeller James P · Granite Bay, CABuilt 1965 · S/N 24-4291N8836YLodge Aviation LLC · Lewes, DEBuilt 1969 · S/N 30-1994N8837YWilfly Inc · Dahlgren, ILBuilt 1969 · S/N 30-1995N8838PLogan Flyers LLC · Logan, OHBuilt 1965 · S/N 24-4293N8838YWaterwings Seaplanes LLC · Hoover, ALBuilt 1969 · S/N 30-1993N8839YMcguinness William V IV · Houston, TXBuilt 1969 · S/N 39-2N8840PStutzman John M · Grand Rapids, MIBuilt 1965 · S/N 24-4295N8841PBotsacos Chris S DBA · Long Beach, CABuilt 1965 · S/N 24-4296N8842PGauss Roger W · Forest Hill, MDBuilt 1965 · S/N 24-4297N8842YQuest Aviation Inc · Houlton, MEBuilt 1969 · S/N 30-2000N8843PRodarte Lionel A · Downey, CABuilt 1965 · S/N 24-4298N8844PReetz Roger D · Duluth, MNBuilt 1965 · S/N 24-4299N8844YStreater Aviation LLC · Weirsdale, FLBuilt 1969 · S/N 39-3N8846PLecrone Gregory S · Granbury, TXBuilt 1965 · S/N 24-4301N8847PSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1965 · S/N 24-4302N8848PLazar Stephen D · Toledo, OHBuilt 1965 · S/N 24-4303N8848YBrunot Frank A · Spring Hill, FLBuilt 1969 · S/N 30-1907N8849PCare Management Oregon Inc · New Plymouth, IDBuilt 1965 · S/N 24-4304N884DCTanner Greg L · Bend, ORBuilt 1961 · S/N 24-2434N8850PSharp Alan D · Dallas, TXBuilt 1965 · S/N 24-4305N8851PRegistered aircraftBuilt 1965 · S/N 24-4307N8852YWikle Luther M · Laceys Spring, ALBuilt 1969 · S/N 39-7N8853PGebhart Kevin E · Burley, IDBuilt 1965 · S/N 24-4309N8854YSeeds John S Jr Trustee · Tequesta, FLBuilt 1970 · S/N 39-9N8855PTja Pop Ltd · Dix Hills, NYBuilt 1965 · S/N 24-4311N8857YLewis Leslie S · Glendale, AZBuilt 1970 · S/N 39-12N8858PMachmiller A A · San Jose, CABuilt 1965 · S/N 24-4315N8859PGowins John C · New Philadelphia, OHBuilt 1965 · S/N 24-4317N8861PForney Garry L · El Centro, CABuilt 1965 · S/N 24-4318N8864YMiller Donald W · Harrisonburg, VABuilt 1970 · S/N 39-19N8865PBrown Travis E · Leicester, NCBuilt 1965 · S/N 24-4322
Back to AD 77-13-21