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.

N7494YRay James O III · Mc Rae, GABuilt 1964 · S/N 30-555N7495PSale Reported · Fort Lauderdale, FLSale reported, pending cancellationBuilt 1961 · S/N 24-2690N7496PS & S Air Inc · Wilmington, DEBuilt 1961 · S/N 24-2691N7497PLift Aircraft LLC · Carmel, INBuilt 1961 · S/N 24-2692N7498PKarnegis Frank J · Senoia, GABuilt 1961 · S/N 24-2693N7499PTri-C Farms · Tompkinsville, KYBuilt 1961 · S/N 24-2696N74BNBig Bend Community College Foundation · Moses La, WABuilt 1969 · S/N 30-1806N74YCButzer Brian K · Boca Raton, FLBuilt 1969 · S/N 30-1847N7500PBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 24-2699N7503PHouseth Timothy C · Hastings, MNBuilt 1961 · S/N 24-2704N7503YCunneen Sean M · Vista, CABuilt 1964 · S/N 30-565N7509PSuperbird Aviation LLC · Atlantic, IABuilt 1961 · S/N 24-2710N750HKRegistration Pending · Lutz, FLRegistration pendingS/N 30-947N7510PMavco Corp · Lewes, DEBuilt 1961 · S/N 24-2711N7515PRyan John David · Fort Rucker, ALBuilt 1961 · S/N 24-2716N7515YJohnson Max L Jr · Greenville, SCBuilt 1964 · S/N 30-579N7516PHawkinson Dustin R · Glendale, AZBuilt 1961 · S/N 24-2717N7517PRitzheimer Eric R · Glendale, AZS/N 24-2718N7518PLasswell Joel E · Arcola, ILS/N 24-2719N7519YDunshee Kevin G · La Luz, NMBuilt 1964 · S/N 30-584N751WWVicentin De Oliveira Ricardo · Winter Garden, FLBuilt 1967 · S/N 30-1449N7520PRomo Victor Gerardo · Menifee, CAS/N 24-2722N7520YWendelburg Kevin R · Moreland, GABuilt 1964 · S/N 30-585N7522PXair LLC · El Cajon, CABuilt 1961 · S/N 24-2724N7523YBarry Patric · Laguna Hills, CABuilt 1964 · S/N 30-588N7525PStack Robert J · Aurora, COS/N 24-2727N7527PWhite Andrew D · Covelo, CABuilt 1961 · S/N 24-2730N7528YSkyward Solutions Inc · Lewes, DEBuilt 1964 · S/N 30-593N752CFAnytime Flights LLC · Scottsdale, AZBuilt 1964 · S/N 30-592N7532PKing Larry Joe · Quanah, TXBuilt 1961 · S/N 24-2736N7533PFoster Andrew · Laguna Beach, CABuilt 1961 · S/N 24-2737N7533YFlying Pirates Unlimited LLC · New Bern, NCBuilt 1964 · S/N 30-596N7534PCrow Brenton · Findlay, OHBuilt 1961 · S/N 24-2738N7535YN7535y LLC · Sylvania, OHBuilt 1964 · S/N 30-598N7537YCecerr Paul E · Olive Branch, MSS/N 30-601N7538YEdwards John G · Stoneville, NCBuilt 1964 · S/N 30-602N7539YChristianini Cassio Pereira · Plantation, FLBuilt 1964 · S/N 30-603N753SPKor Wesley D · White, SDBuilt 1961 · S/N 24-2740N7542YLyle Eugene W · Honesdale, PABuilt 1965 · S/N 30-606N7545PFriebert Stephen E · Elk Grove, CABuilt 1961 · S/N 24-2752N7546YBrilliant Holdings LLC · Winfield, MOBuilt 1965 · S/N 30-609N7548PSecolad N7548p LLC · Madison, INS/N 24-2756N7549PAlbano Alan T · Elbert, COBuilt 1961 · S/N 24-2757N7551PKassik Ryan W · Commerce City, COS/N 24-2759N7551YWills Terry W · Cedar Park, TXBuilt 1964 · S/N 30-614N7552PSaunders Frank H · Salinas, CABuilt 1961 · S/N 24-2760N7555YHirvonen Jukka Matti · Oak Ridge, NCBuilt 1964 · S/N 30-618N7558PAngst Matthew J · Wilmington, OHBuilt 1961 · S/N 24-2767N7560PFlying Warriors LLC · Kearney, NEBuilt 1961 · S/N 24-2769N7560YRa Procurement LLC · Maypearl, TXBuilt 1964 · S/N 30-623
Back to AD 77-13-21