OpenAirDocs.org
AD 76-08-02 R2

Registered aircraft · 2,553

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:76-08-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-08-02-R2')
  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.

N6637BNewbold Vernon D · Wheatland, WYS/N 35737N6644BN6644b LLC · Cresson, TXBuilt 1958 · S/N 35744N6644QLomakin Anatol · Lincoln Park, NJBuilt 1974 · S/N 414-0543N664RRobertello Gerald J · Centreville, VABuilt 1960 · S/N 39082N664RJGeneva Lakes Aviation LLC · Lake Geneva, WIBuilt 1975 · S/N 402B0854N6650BBrewer Eric Vincent · Alva, OKS/N 35750N66552Janak Jeffrey · Corpus Christi, TXBuilt 1963 · S/N 320B0003N6659BNelson Scott J · Bridgewater, MIS/N 35759N665RNelson Todd J · Bluffdale, UTBuilt 1958 · S/N 35755N6663BRegistration Pending · La Puente, CARegistration pendingS/N 35763N6665BRex Timothy Davis · Cape Coral, FLBuilt 1958 · S/N 35765N666LVPetecraft Aviation Services Inc · Plains, GABuilt 1958 · S/N 35748N6670BMorris Thomas B · Imlay City, MIBuilt 1958 · S/N 35770N6673BBushido Hospitality Services LLC · North Las Vegas, NVBuilt 1958 · S/N 35773N6675QLoyal Aviation LLC · Loyal, WIBuilt 1973 · S/N 421B0442N6683BOrf Mike · Austin, TXBuilt 1958 · S/N 35783N6685BSale Reported · Orange City, FLSale reportedBuilt 1958 · S/N 35785N6686BRjb Ventures Corp · Wilmington, DEBuilt 1958 · S/N 35786N6690BWalker Hyral B Jr · Wills Point, TXBuilt 1958 · S/N 35790N6698BElliott Frank F · Mojave, CAFirst renewal noticeBuilt 1959 · S/N 35798N66CWSpannhake John H · Washington, CTBuilt 1973 · S/N 310Q0844N66DHKingsbury Raymond S · Farmington, MNS/N 320E0041N66EPSpillett James Kreg · Sandy, UTBuilt 1973 · S/N 421B0520N66XXSale Reported · Denton, TXSale reportedBuilt 1964 · S/N 320C0033N6701XPlewa Gary M · Hays, NCBuilt 1960 · S/N 310-0001N6702TReeve Howard E · Minot, NDBuilt 1959 · S/N 39002N6706TMetz Robert W · Logan, UTFirst renewal noticeBuilt 1959 · S/N 39006N6708TCkg Aviation Services LLC · Argyle, TXBuilt 1959 · S/N 39008N6709XNeches Air Inc · Silsbee, TXBuilt 1960 · S/N 310-0009N6713XSkowbo Rock G · Winchester, VABuilt 1960 · S/N 3100013N6714TDewald Michael A · Garden Grove, CABuilt 1959 · S/N 39014N6716XEberly Steven · Euless, TXS/N 310-0016N6720XCoburn Randy J · Saint George, UTBuilt 1960 · S/N 310-0020N6724XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1960 · S/N 310-0024N6727XVan Haitsma Kelley · Fort Worth, TXS/N 310-0027N6728TPatkotak Hugh G Sr · Anchorage, AKBuilt 1959 · S/N 39028N6731XThree One X-Ray LLC · Lebanon, OHBuilt 1960 · S/N 310-0031N6734TTravel Guys Ltd · Sparks, NVS/N 39034N6735XLocal Flight Adventures LLC · Morgantown, WVBuilt 1960 · S/N 310-0035N6739XIntravaia Anthony J · Saint Louis, MOS/N 310-0039N6742TMorris Thomas B · Imlay City, MIBuilt 1960 · S/N 39042N6747Ps Afu3a LLC · Monument, COBuilt 1958 · S/N 38106N6748TWhalen John J · West Ossipee, NHBuilt 1960 · S/N 39048N6749XSchindele Micheal D · Tolna, NDBuilt 1961 · S/N 310-0049N674CCTrn Aviation LLC · Mcallen, TXS/N 414-0453N6750TArsic Ranko · Hallendale, FLBuilt 1960 · S/N 39050N6756TStanley M C DBA · Caldwell, IDBuilt 1960 · S/N 39056N6758TGill James L Jr · Hernando, MSBuilt 1960 · S/N 39058N6760TTregre Gary M · Fort Worth, TXFirst renewal noticeBuilt 1959 · S/N 39060N6766TAero Research & Development Corp · Bronx, NYS/N 39066
Back to AD 76-08-02 R2