OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N34096Mirafuentes Akoni Jr · Surprise, AZBuilt 1976 · S/N 177RG0970N34097Brennan Benjamin M · Pensacola, FLBuilt 1971 · S/N 17701638N34099Nehrbass Daniel · Santa Ana, CABuilt 1971 · S/N 17701639N3409JMountain Home Oasis LLC · Albuquerque, NMBuilt 1967 · S/N 15066109N3409RAnderson Curtiss B · Heber Springs, ARBuilt 1968 · S/N 18258709N3409YThies Trevor H · Seattle, WABuilt 1967 · S/N 18051909N340HPBeartooth Aviation LLC · Kalispell, MTBuilt 2000 · S/N 18280889N340MTAcron Aviation Academy Inc · Sanford, FLBuilt 2006 · S/N 172S10374N34101Aldrich Andrew J · Soulsbyville, CABuilt 1971 · S/N 17701641N34102Jaquez Marlene D · Baton Rouge, LABuilt 1971 · S/N 17701642N34104Mcgowan Glenn R · Poplar Grove, ILBuilt 1971 · S/N 17701644N34106Bellmann Carl W · Bryan, OHBuilt 1971 · S/N 17701646N34108Pierce Andrew · Littleton, NCBuilt 1971 · S/N 17701647N3410CGreer Jack D · Gillette, WYS/N 26453N3410DGuillory Dan Jr · Eunice, LABuilt 1955 · S/N 26953N3410FMacy Richard H · Culver, ORBuilt 1966 · S/N 18257410N3410JNewsom Rickey D · Springfield, ARS/N 15066110N3410REpperly Scott C · Montague, CABuilt 1967 · S/N 18258710N3410SDurtschi Jay W · Franklin, IDBuilt 1964 · S/N 18255810N3410TPeterson Barry · Sausalito, CABuilt 1967 · S/N 17700710N3410UWegman Aviation LLC · Kenmore, NYBuilt 1963 · S/N 18254810N3411DBox 4-S Ranch Inc · Pullman, WABuilt 1955 · S/N 26954N3411ROgp LLC · Wilmington, DEBuilt 1967 · S/N 18258711N3411SHorseshoe 182 LLC · Dickinson, NDBuilt 1964 · S/N 18255811N3411TSouthern Aero LLC · Theodore, ALBuilt 1967 · S/N 17700711N3411USutton Aircraft Salvage LLC · Palmer, AKBuilt 1963 · S/N 18254811N3411YFinnelly Barry J · Snohomish, WAS/N 18051911N34121Downey Colin T · Jupiter, FLBuilt 1971 · S/N 17701650N34122Cardinal Flying Club LLC · Saint Helens, ORBuilt 1971 · S/N 17701651N34125Quinones Horacio Adan Gil · Palmdale, CABuilt 1971 · S/N 17701652N34129Shook Mitchell M · Vidalia, GABuilt 1971 · S/N 17701653N3412DBerens Brian T · Homer, AKBuilt 1955 · S/N 26955N3412FClaretta Inc · Wilmington, DEBuilt 1966 · S/N 18257412N3412SBanks Ramona C · Huntsville, ALS/N 18255812N3412TC177knotclub LLC · Springfield, ILBuilt 1967 · S/N 17700712N3412YSkinner Jason Richard · Templeton, CABuilt 1968 · S/N 18051912N34133Geneva Lakes Flying LLC · Bristol, WIBuilt 1971 · S/N 17701654N34138Wheat Michael D · Wichita Falls, TXBuilt 1971 · S/N 17701656N34139Registered aircraftBuilt 1971 · S/N 17701657N3413DMitchell Robert D · Fort Meade, FLBuilt 1955 · S/N 26956N3413SFly Buddies LLC · Tucson, AZBuilt 1964 · S/N 18255813N3413VNiles Air LLC · Concord, NCBuilt 1974 · S/N 15076493N34140Beacham Clinton S · Pleasanton, CABuilt 1976 · S/N 177RG0972N34146Aegis Aero LLC · Vancleave, MSBuilt 1971 · S/N 17701664N34147Ferguson Claudia K Trustee · Orange, CABuilt 1971 · S/N 17701665N34148Rupp Gregory J · Deltona, FLS/N 17701666N34149Juniper Ventures LLC · Missoula, MTBuilt 1971 · S/N 17701667N3414RDanninger James · Kirkland, WABuilt 1967 · S/N 18258714N3414TKkk Services Inc · Saint Charles, MOBuilt 1967 · S/N 17700714N34150Mcalindon Timothy E · Arlington, MABuilt 1971 · S/N 17701668
Back to AD 79-10-14 R1