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.

N5995JYachal Benedick · Wilsey, KSBuilt 1975 · S/N 18263604N5996ACascade Mountain Vacation Rentals LLC · Cle Elum, WABuilt 1956 · S/N 28596N5996BStrong Brian S · Southport, NCBuilt 1956 · S/N 33996N5996FL M W Leasing · Midlothian, TXBuilt 1968 · S/N 21058996N5996GRandle Jessica R · North Bend, ORBuilt 1969 · S/N 15071496N5996JEvergreen Flying Club Inc · Medina, WABuilt 1975 · S/N 18263605N5996ROwens Wilbur · Rch Palos Vrd, CAS/N 17253665N5996TLopez Manuel G · Fort Washington, MDFirst renewal noticeS/N 15060696N5997BSpence Joseph H · Enterprise, ORBuilt 1956 · S/N 33997N5997RVande Sandt Curtis B · Tioga, NDBuilt 1965 · S/N 17253666N5997TFour Aces Montana LLC · Missoula, MTBuilt 1964 · S/N 15060697N5998ACrow Todd R · Hinckley, MNBuilt 1956 · S/N 28598N5998BConroy Bruce M · Martinez, CABuilt 1956 · S/N 33998N5998EAir Heritage Inc · Beaver Falls, PABuilt 1959 · S/N 17498N5998FMedic Choppers LLC · Springdale, ARS/N 21058998N5999BBig Bird LLC · Prescott, AZBuilt 1957 · S/N 33999N5999EBender Evan Dh · Linville, VABuilt 1959 · S/N 17499N599CMMscm Partners LLC · Fairfield, TXS/N 17257970N599CPCoons Aircraft Services Inc · West Palm Beach, FLBuilt 1968 · S/N 18258960N59ABates Roger · Palm Beach Gardens, FLBuilt 1978 · S/N 21062509N59ADJohnson Rand C · Galveston, TXBuilt 1959 · S/N 46673N59AJBird Dog Aircraft LLC · Billings, MTBuilt 1981 · S/N 18504158N59AKJaworski Roger W · Mesa, AZS/N 18503604N59BMLissow William M · New Port Richey, FLBuilt 1959 · S/N 52120N59CKSig Properties LLC · Helena, ARFirst renewal noticeBuilt 1972 · S/N 18261416N59EFTancredi Andrew D · Germantown, TNBuilt 2004 · S/N 18281359N59FFPeregrine Howard Partners II Lp · New Orleans, LABuilt 2023 · S/N 172S12933N59JFJpf Holdings LLC · Wilmington, DEBuilt 1977 · S/N R1722325N59KHKrause Wesley A · Big Bear City, CABuilt 1972 · S/N 18261378N59KMMatthews Casey D · Fort Worth, TXBuilt 1959 · S/N 50503N59LJL & J Aviation Inc · Atwater, CABuilt 2001 · S/N 17281043N59MJSweatt Greg · Cochise, AZBuilt 1970 · S/N 18260369N59MPPilch Michael Joseph · Sheridan, WYBuilt 1959 · S/N 50624N59PGStone Aviation Holdings LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260347N59TWAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13249N59VLKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259905N59WAAdventist World Aviation Inc · Wilson, NCBuilt 1975 · S/N U20602958N59XPCobb John M · Fayetteville, TNBuilt 1977 · S/N R1722015N59YYBay Richard P · West Jordan, UTBuilt 1960 · S/N 56429N5AKHackler Tara Cole · Bend, ORBuilt 1977 · S/N 17268768N5BNMountain Air Inc · Quincy, CABuilt 1973 · S/N 15075144N5BWThompson Aubrey C · Wilmington, NCBuilt 1968 · S/N 15069426N5CMBramall Buster I · Waxahachie, TXBuilt 1973 · S/N 17262655N5CYKawasaki Clyde H · Carson City, NVS/N P337-0083N5DJMyers Bradley J · Madisonville, KYBuilt 1974 · S/N 21060399N5DTFive Delta Tango LLC · Tucson, AZBuilt 1970 · S/N 15071977N5EA310 LLC · Conover, NCBuilt 1975 · S/N U20602711N5EJJones Eric M · Southbridge, MAS/N 177RG0167N5FBRichers David M · Thornton, COBuilt 1966 · S/N 17255431N5GSOllman Matthew P · Poplar Grove, ILS/N 33721
Back to AD 79-10-14 R1