OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N767JCCole Jeffrey E · Rockwall, TXS/N E-797N767JPPicard Philip A · Clover, SCBuilt 1990 · S/N TH-1583N767RRRed Leasing LLC · Juneau, AKBuilt 1972 · S/N 310Q0455N767SBRegistered aircraftBuilt 2005 · S/N 29-0383N767TMJavelina Aero LLC · Sheridan, WYBuilt 1967 · S/N D-8556N767URegistered aircraftBuilt 1968 · S/N D-8873N7680YMeekin Michael J · Palmer, AKBuilt 1961 · S/N 1850190N7684NMccarthy Mitchell S · Stamford, CTBuilt 1968 · S/N D-8867N7687NFreedom Flying Inc · Wilmington, DEBuilt 1968 · S/N E-94N768CDSears William R · Lexington, MABuilt 2004 · S/N 1041N7690NSpencer Alan R · Peyton, COBuilt 1968 · S/N E-92N7691DScout Aviation LLC · Homer, AKBuilt 1968 · S/N U206-1015N7691NHawk Robert S · Argyle, TXBuilt 1968 · S/N E-93N76940Gsh Of Alabama LLC · Huntsville, ALS/N D-8861N7694NBradley Dennis M · Newburgh, MEBuilt 1968 · S/N D-8869N7695NChalk 2 Inc · Apple Valley, CABuilt 1968 · S/N D-8870N769ACAircraft Propulsion Leasing LLC · Holland, OHBuilt 1978 · S/N TK-89N769BSWells Donald T · Seattle, WABuilt 1968 · S/N U206-1251N769DLInternational Air Services Inc Trustee · Carson City, NVBuilt 2025 · S/N E-4159N769EAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0303N769TPatterson David Roy · Lockney, TXBuilt 1972 · S/N D-9395N769WTJd Odle Second Family Limited Partnership · Manhattan Beach, CABuilt 2014 · S/N E-4046N76ACTennessee Aviation Company LLC · Knoxville, TNBuilt 1980 · S/N E-1791N76AGSkyview Applicators LLC · Hartington, NEBuilt 1976 · S/N 18802699TN76BAWestphal Jon A · Menomonie, WIBuilt 1975 · S/N E-783N76BLBravo Lima Corp · Lakewood, COBuilt 1973 · S/N 21059808N76BYViper Aeronautics LLC · Lincoln, NEBuilt 2002 · S/N 0145N76CWYatahey LLC · Middletown, DEBuilt 1976 · S/N 310R0695N76DACessna 76da LLC · Warsaw, VABuilt 1977 · S/N U20604208N76DBAek Property 6 LLC · Glendale, AZBuilt 1975 · S/N CE-608N76EDFlying Hawks Ranch LLC · Bruning, NEBuilt 1968 · S/N P206-0487N76KTWarriors With Wings LLC · Zebulon, NCBuilt 1974 · S/N 414-0508N76KULaurent Michael · Queen Creek, AZS/N D-7319N76MJJzw Aviation LLC · North Salt Lake, UTBuilt 1981 · S/N 421C1204N76NB12 Parsecs LLC · Manhattan, KSBuilt 1975 · S/N E-791N76PLMilam Malcolm Bruce · Bowie, MDBuilt 1976 · S/N 310R0660N76SCBeaver Creek Adventures LLC · Bangor, MEBuilt 1981 · S/N 18504206N76TWapiti Holdings LLC · Pratt, KSBuilt 2009 · S/N E-3901N76TMForeign Auto Specialties · Minneapolis, MNBuilt 1976 · S/N 76-30815N76VCBel Air Holdings Inc · Wilmington, DEBuilt 1982 · S/N TH-1361N76VVVandersteen Richard J · Hanford, CABuilt 2005 · S/N 3RX118N7701FRegistered aircraftBuilt 1977 · S/N 18503245N7702QRobinson Meyer · Daphne, ALBuilt 1970 · S/N 310Q0202N7703TRegistered aircraftBuilt 1972 · S/N 18502056N7707RCondor 1 LLC · Jackson, TNBuilt 1968 · S/N E-100N7709RBonanza Angels LLC · Springfield, VABuilt 1968 · S/N E-102N770CFKopp Adrian D · Brookville, INBuilt 1978 · S/N U20604569N770CSFlying Cpa LLC · Colorado Springs, COBuilt 1975 · S/N 421B0877N770LAGulf Airbatics Ltd · Jennings, LABuilt 1974 · S/N TH-517N770MPPerrin Michael G · Howell, MIBuilt 1977 · S/N CE-713
Back to AD 86-13-04 R3