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.

N8759PHeir Grant · Woodland, CAS/N 24-4209N8764YVenture West LLC · Mesa, AZBuilt 1969 · S/N 30-1920N8765YBrady William H · Moorestown, NJBuilt 1969 · S/N 30-1921N8766PStephens Lloyd G · Saratoga, CABuilt 1965 · S/N 24-4216N8767PGen-One Aviation LLC · Carlsbad, NMBuilt 1965 · S/N 24-4217N8768PGliege Allan C · Middleton, IDBuilt 1965 · S/N 24-4218N8768YVst Aviation LLC · Ball Ground, GAS/N 30-1924N8769YCretney Robert P · Ferris, TXS/N 301925N8770PGores Thomas J · Franklin, WIS/N 24-4220N8771YNation Jimmy D · Decatur, TXBuilt 1969 · S/N 30-1927N8773PMcfly Cornhusker LLC · Sarasota, FLBuilt 1965 · S/N 24-4224N8777PLil Dawg Aviation · Wilmington, DEFirst renewal noticeBuilt 1965 · S/N 24-4228N8777YSilver Ridge Inc · Wilmington, DEBuilt 1969 · S/N 30-1933N8778PTrammell Shaun · Broken Arrow, OKBuilt 1965 · S/N 24-4229N8778YBad Altitude Aviation · Washington, UTBuilt 1969 · S/N 30-1934N877PTaylor Peter L · Red Bluff, CABuilt 1960 · S/N 24-1826N8780PChampion Milton · Reno, NVBuilt 1965 · S/N 24-4232N8780YRegistered aircraftBuilt 1969 · S/N 30-1936N8781PJenkins Aviation Ventures LLC · Woodstock, GABuilt 1965 · S/N 24-4233N8783YOsprey Holding Company LLC · Foley, ALBuilt 1969 · S/N 30-1940N8784PCrane Steven · Phoenix, AZBuilt 1965 · S/N 24-4237N8784YFoster Darryl L · The Woodlands, TXBuilt 1969 · S/N 30-1942N8786PSisk Jerald L · Brighton, COBuilt 1965 · S/N 26-135N87878International Air Services Inc Trustee · Carson City, NVBuilt 1959 · S/N 24-469N8787PA B Helton Enterprises LLC · Warthen, GABuilt 1965 · S/N 24-4239N8788YAerotransit Inc · Milwaukee, WIS/N 30-1946N8789PCannell John D · New Franken, WIBuilt 1965 · S/N 24-4241N8790PBison Reserved LLC · Chicago, ILBuilt 1965 · S/N 24-4243N8791YGeboy Alan R III · Baxley, GABuilt 1969 · S/N 30-1949N8792PPrivette Richard E · Oak Hill, FLBuilt 1965 · S/N 24-4245N8793PFlaagan Kevin D · Beulah, NDBuilt 1965 · S/N 24-4246N8794PDelaware Mark P · Phoenix, AZBuilt 1965 · S/N 24-4247N8795PJejgr LLC · Presho, SDBuilt 1965 · S/N 24-4248N8795YJohnson Paul · Wichita Falls, TXS/N 30-1954N8796PAllie Doug B · Glasgow, MTBuilt 1965 · S/N 24-4249N8797PPlant Curtis W · Runge, TXBuilt 1965 · S/N 24-4250N8797YHight Derrick R · North Aurora, ILBuilt 1969 · S/N 30-1812N8799PMontgomery M Kim · Vega, TXBuilt 1965 · S/N 24-4252N87CWZou Christian · Chandler, AZBuilt 1967 · S/N 30-1639N87RPWhitehead Glenn K · Friendswood, TXS/N 24-1603N8800PAnp Networks Corp · Las Vegas, NVS/N 24-4253N8800YAlexander City Aviation Corp · Alexander City, ALBuilt 1969 · S/N 30-1956N8802PPennington Mitchell T · Medley, WVBuilt 1965 · S/N 24-4257N8803PWade Brian K · Apalachin, NYBuilt 1965 · S/N 24-4258N8804YMartino Aviation LLC · Wilmington, DES/N 30-1960N8806PZiolkowski James E · Amarillo, TXBuilt 1965 · S/N 24-4261N8807PRegistered aircraftBuilt 1965 · S/N 24-4263N8807YRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1969 · S/N 30-1964N8808YAukes Brian E · Huxley, IABuilt 1969 · S/N 30-1965N8809PPa24 LLC · Painesville, OHBuilt 1965 · S/N 24-4265
Back to AD 77-13-21