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.

N7317YComanche Air Services LLC · Westminster, COBuilt 1964 · S/N 30-360N7318YBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 30-361N731WN64gs LLC · Van Nuys, CABuilt 1971 · S/N 24-4989N7320YSpruce John P · Liberty Hill, TXBuilt 1964 · S/N 30-364N7321PTappan East LLC · New Philadelphia, OHBuilt 1961 · S/N 24-2498N7322PRuple Michael D · Palm Bay, FLBuilt 1961 · S/N 24-2499N7323PCrawford Patricia C · Denton, NCBuilt 1961 · S/N 24-2500N7323YFoster Jay W · Marshfield, MOBuilt 1964 · S/N 30-367N7324PWright Havis L · Pleasant Hill, MOBuilt 1961 · S/N 24-2502N7324YMccaslin Dale Alan Trustee · Holt, MOBuilt 1964 · S/N 30-369N7326PHarris David M · Costa Mesa, CABuilt 1961 · S/N 24-2504N7326YHighsky Aero Inc · Arlington, TXBuilt 1964 · S/N 30-371N7327PTown Terry N · Lake Havasu City, AZBuilt 1961 · S/N 24-2505N7327YGeyman Edward J · Wilmington, OHBuilt 1964 · S/N 30-372N7328PCoffee Bean Connoisseur LLC · Highland, NYBuilt 1961 · S/N 24-2506N7328YBarnett David K · Brock, TXS/N 30-374N7329PSlm Holdings LLC · Kalispell, MTBuilt 1961 · S/N 24-2507N732CATrey Stroup Aviation LLC · Fort Pierre, SDBuilt 1966 · S/N 30-1086N7330PGenpack LLC · Hillsdale, NJBuilt 1961 · S/N 24-2509N7330YJordan Terry L · Hugoton, KSBuilt 1964 · S/N 30-378N7331YNeubert Erich S · Dana Point, CABuilt 1964 · S/N 30-292N7332PArnold Christian M · Waltham, MABuilt 1961 · S/N 24-2511N7334YJg Air LLC · Cape Coral, FLBuilt 1964 · S/N 30-383N7338PPope Kent M · Hayden, IDBuilt 1961 · S/N 24-2517N733GPHorton Luther · Lakeland, FLBuilt 1962 · S/N 24-3213N7340PWard James A · Brentwood, TNBuilt 1961 · S/N 24-2519N7341PBlaes Richard S · Columbus, OHBuilt 1960 · S/N 24-2520N7342YHinkle Anthony · Mineola, TXBuilt 1964 · S/N 30-392N7344PWorley Jimmy · Dallas, TXBuilt 1961 · S/N 24-2522N7347PVan Eyck Christopher · Cottonwood, CABuilt 1961 · S/N 24-2525N7348PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1961 · S/N 24-2526N7349PMathison John M · Vancouver, WABuilt 1961 · S/N 24-2527N7351PSutliff Larrie G · Briarcliff Manor, NYBuilt 1961 · S/N 24-2529N7354YBreum Todd R · Billings, MTBuilt 1964 · S/N 30-408N7355PGo Fly Az LLC · Gilbert, AZBuilt 1961 · S/N 24-2533N7357PMelvin Ryan C · Hamilton, GABuilt 1961 · S/N 24-2535N7358YPmx Aviation Services LLC · Kailua Kona, HIBuilt 1964 · S/N 30-413N7359YAwmr LLC · Conroe, TXBuilt 1964 · S/N 30-414N7362PMead Gary M · Lubbock, TXBuilt 1961 · S/N 24-2540N7363PJansen David C · Newnan, GABuilt 1961 · S/N 24-2541N7364PMarotta Thomas E · Twin Lake, MIS/N 24-2542N7365YLoguidice Anthony · Bethlehem, PABuilt 1964 · S/N 30-416N7366PAnthony Craig D · Keller, TXBuilt 1961 · S/N 24-2544N7366YShockley Kenlon D · Aurora, COBuilt 1964 · S/N 30-417N7368YHoenmans John P · Roseville, CABuilt 1964 · S/N 30-419N7369PGrier Randall · Owasso, OKBuilt 1961 · S/N 24-2549N7370PLeesman Raleigh R · Blunt, SDBuilt 1961 · S/N 24-2550N7371PJsntg Inc · Wilmington, DEBuilt 1961 · S/N 24-2552N7372PArnold Matthew C · Alpine, CABuilt 1961 · S/N 24-2553N7374PFerland Jeffrey B · San Francisco, CABuilt 1961 · S/N 24-2555
Back to AD 77-13-21