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.

N7189PTofan Ray · National City, CABuilt 1960 · S/N 24-2359N7189YHesano Joseph M · Rockford, ILBuilt 1963 · S/N 30-213N718JRFlytwincos LLC · Las Vegas, NVBuilt 1964 · S/N 30-276N7190YMiller Kevin · Collegedale, TNBuilt 1963 · S/N 30-214N7191PRamineni Raja · Fort Mill, SCBuilt 1961 · S/N 24-2361N7192PBest Equipment Leasing LLC · Bakersfield, CABuilt 1960 · S/N 24-2362N7193PSzczawinski Anthony J · Elko, NVFirst renewal noticeBuilt 1960 · S/N 24-2363N7196YAircraft & Aviation Professionals LLC · Coldwater, MIS/N 30-220N7199PLee Jeffrey L · Cameron, MTBuilt 1961 · S/N 24-2370N7199YFour Way Aircraft Ltd · Pensacola, FLBuilt 1963 · S/N 30-223N71ADSons Aviation LLC · Moody, ALS/N 30-1524N71BBMitchell Trans · Timnath, COFirst renewal noticeBuilt 1967 · S/N 30-1539N71GMEtheredge Mark · Pell City, ALBuilt 1969 · S/N 30-1959N71GTHazduff LLC · Plainfield, INBuilt 1969 · S/N 30-1801N71PVCeleste LLC · Playa Del Rey, CABuilt 1966 · S/N 30-1261N7200PThompson Grover A · Locust, NCBuilt 1960 · S/N 24-2386N7200YBroussard Don W Jr · Wynne, ARBuilt 1963 · S/N 30-224N7203PGorge Fast Aviation LLC · Hood River, ORBuilt 1960 · S/N 24-2373N7204PPittner Hans C · Goshen, NYBuilt 1960 · S/N 24-2374N7206YSkyflite LLC · Hillsboro, ORS/N 30-232N7207PSteinbach Philipp · Bentonville, ARBuilt 1960 · S/N 24-2377N7209YThy Will Be Done Here LLC · Reno, NVBuilt 1963 · S/N 30-235N7210PBirdwell David W · Richmond, TXBuilt 1960 · S/N 24-2380N7211PWhite Jordan H · Gold Beach, ORBuilt 1960 · S/N 24-2381N7211YBeers Jason · Girard, OHS/N 30-237N7216YMerriwether David E · Whitesburg, GABuilt 1963 · S/N 30-242N7217PNewman Samuel M · Taylorsville, UTBuilt 1960 · S/N 24-2389N7220PHench Martin Stewart · La Verne, CABuilt 1960 · S/N 24-2392N7221PBuhrmeister Timothy J · Centereach, NYBuilt 1960 · S/N 24-2393N7224YDistel Harold M · Williamson, GABuilt 1964 · S/N 30-246N7225PSuperior Aviation LLC · Metairie, LABuilt 1960 · S/N 24-2399N7225YTwin Cam Holdings LLC · Union City, TNBuilt 1964 · S/N 30-248N7226YGilbert Douglas A · Weston, FLBuilt 1964 · S/N 30-249N7227YClearview Aerial Solutions LLC · Rogersville, TNS/N 30-250N7230PFranks Orlan H III · Belton, TXBuilt 1960 · S/N 24-2404N7230YVyas Shiven P · Chino Hills, CABuilt 1964 · S/N 30-254N7232POntiveros Vicente III · New Braunfels, TXS/N 24-2406N7233YPacific North Air LLC · Portland, ORBuilt 1964 · S/N 30-257N7234PEagle Ag Services LLC · Lees Summit, MOBuilt 1960 · S/N 24-2408N7239PMccabe Gregory · Melbourne Beach, FLBuilt 1960 · S/N 24-2413N723JSAlbertson James M · Westville, FLBuilt 1967 · S/N 30-1512N7240YHodges David S · Reidsville, GABuilt 1964 · S/N 30-264N72424Magill William J · Moncks Corner, SCS/N 241523N7244PPaden Stanley R · Diamond Bar, CABuilt 1961 · S/N 24-2418N7244YJ Mac Aviation Services LLC · Andalusia, ALBuilt 1964 · S/N 30-269N7245PMontcalm Kevin L · Mansfield, LABuilt 1960 · S/N 24-2419N7246PAlex John R · Turner, MTBuilt 1960 · S/N 24-2420N7246YMoyer Thomas L · Fayetteville, GABuilt 1964 · S/N 30-271N7247PRegistration Pending · Caribou, MERegistration pendingBuilt 1960 · S/N 24-2421N7248PN7248p Ltd · Wallkill, NYBuilt 1960 · S/N 24-2424
Back to AD 77-13-21