AD 79-10-14 R1

Registered aircraft · 56,582

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:79-10-14-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
  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.

N6703RSteinle Lee M · Jourdanton, TXBuilt 1966 · S/N T210-0103N6704AKaspar Matthew L · Neenah, WIBuilt 1956 · S/N 28804N6704EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17272052N6704FAvistar Media Corporation · Wilmington, DES/N 15063304N6704GRyan Conner J · Fruita, COS/N 15072204N6704MBillups Jeff · Eagle, IDBuilt 1975 · S/N 18263806N6705HKobuk Valley Outfitters Co · Kiana, AKBuilt 1977 · S/N 18503337N6705MRegistration Pending · Stuart, FLRegistration pendingBuilt 1975 · S/N 18263807N6705SMiszczak Ethan · Newnan, GABuilt 1967 · S/N 15067505N6706ALouden Bruce H · Kalispell, MTBuilt 1956 · S/N 28806N6706EDalley Robert C · Waldron, INBuilt 1959 · S/N 56206N6706HDairy Air Inc · Wyoming, PABuilt 1975 · S/N 17265547N6706MBaker Thaddeus J · Elk, WABuilt 1975 · S/N 18263808N6706RSzopa Ireneusz W · East Troy, WIBuilt 1965 · S/N T210-0106N6706SDavis Bradley · Oconomowoc, WIBuilt 1967 · S/N 15067506N6707HWjt Investments LLC · Gurley, ALBuilt 1975 · S/N 17265548N6707RParker David Scott Trustee · Albuquerque, NMBuilt 1965 · S/N T210-0107N6708GRussell Gary W · Martinsburg, WVBuilt 1970 · S/N 15072208N6708MPrecision Aviation Inc · Kimberly, IDBuilt 1975 · S/N 18263809N6709AEvanoff Aaron · Fowlerville, MIFirst renewal noticeS/N 28809N6709EDixon Kevin S · Shady Shores, TXS/N 56209N670CSSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2002 · S/N 172S9098N670EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12690N670JHNatural Resources Engineering Co Pa · Superior, WIFirst renewal noticeBuilt 1978 · S/N U20604489N670MAVan Anda Aviation LLC · Apopka, FLBuilt 1999 · S/N 17280728N6710GShelton Dale E · West Frankfort, ILBuilt 1970 · S/N 15072210N6710MFlying Skylanes Inc · Hillsborough, CABuilt 1975 · S/N 18263810N6711AAero Club Valkaria LLC · Malabar, FLBuilt 1956 · S/N 28811N6711EGardner Terrence L · Pittsboro, NCS/N 56211N6712EEdwards Joseph C · Austin, ARBuilt 1959 · S/N 56212N6712RAero Applications Inc · Burley, IDBuilt 1966 · S/N T210-0112N6712SDunaire LLC · Mechanicsburg, PABuilt 1967 · S/N 15067512N6713CClemens Jerry W · Benton, KSBuilt 1965 · S/N 18256662N6713ECendejas Agustin · Chino, CAS/N 56213N6714APelcher Devin · Ormond Beach, FLBuilt 1956 · S/N 28814N6714MIda Aviation LLC · Virginia Beach, VABuilt 1975 · S/N 18263812N6715GCardwell Aubrey Lynn · Spring Branch, TXBuilt 1970 · S/N 15072215N6715RRose Mary R · Portland, ORBuilt 1966 · S/N T210-0115N6717AHeffron Jacob L · Little Falls, MNBuilt 1956 · S/N 28817N6717EDenrow Limited Lc · Shawnee, OKBuilt 1978 · S/N 17272055N6717GJet Airways Express Inc · Aventura, FLS/N 15072217N6718AWolfe Quest M · Phoenix, AZBuilt 1956 · S/N 28818N6718SRoberts Brandon R · Bogata, TXBuilt 1967 · S/N 15067518N6719ASantana Maria De La Luz · Hemet, CAS/N 28819N6719EOleary Aviation Inc · Sibley, IABuilt 1959 · S/N 56219N671EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12694N671HABartek Ronald · Lake Charles, LAS/N 15076505N671MAVan Anda Aviation LLC · Apopka, FLBuilt 1999 · S/N 17280732N671PMBarron Bradley C · Harper, TXBuilt 1979 · S/N 18267475N671VHRobert And Andrea Van Hofwegen LLC · Buckeye, AZBuilt 1956 · S/N 29459
Back to AD 79-10-14 R1