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.

N7341QHahn John C · Sherwood, ARS/N 18260981N7341TG & D Holdings LLC · Provo, UTS/N 46941N73420Globemaster Services LLC · Saint Jacob, ILBuilt 1976 · S/N 17267444N73423Weck Geoffrey E · Woodstock, ILBuilt 1976 · S/N 17267447N73424Quincy Flying Club Inc · Quincy, ILBuilt 1976 · S/N 17267448N73425Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267449N73428Johnson Brent C · Appleton, MNBuilt 1976 · S/N 17267452N73429Anson Flyers Club Inc · Wadesboro, NCBuilt 1976 · S/N 17267453N7342ANewberry Ernest B Jr · Crawfordville, FLBuilt 1957 · S/N 29442N7342KPurvis Danny J · Anchorage, AKBuilt 1976 · S/N R1722060N7342QThistlesoar LLC · Plaquemine, LABuilt 1972 · S/N 18260982N7342TKeyes George E Jr · Moab, UTBuilt 1959 · S/N 46942N73433Salvation Neighborhood Development Corp · Riverside, CAS/N 17267457N73434Monette Verne G · Anchorage, AKBuilt 1976 · S/N 17267458N73435Air America Spares LLC · Daytona Beach, FLBuilt 1976 · S/N 17267459N73439Umo Flight School LLC · Mount Olive, NCBuilt 1976 · S/N 17267462N7343ACheek Kenneth W · Yadkinville, NCBuilt 1977 · S/N A1500722N7343ELemanski Joseph S · Grosse Ile, MIBuilt 1959 · S/N 57043N7343MSheets Laura J · Follett, TXBuilt 1958 · S/N 55643N7343XEnyart Patrick · Lindlakes, MNBuilt 1961 · S/N 15059443N73441Stein Aporn U · Pepeekeo, HIBuilt 1976 · S/N 17267464N7344MKiever Robert P Jr · Summerfield, FLBuilt 1958 · S/N 55644N7344XOff LLC · Lonoke, ARS/N 15059444N73450Penn Yan Flying Club Inc · Penn Yan, NYBuilt 1976 · S/N 17267468N73451Airward Inc · Columbia, CABuilt 1976 · S/N 17267469N73452Hodges Jonathan D · Port Orchard, WABuilt 1976 · S/N 17267470N73453Mfa LLC · Mount Pleasant, SCBuilt 1976 · S/N 17267471N73454Yr-Aircraft Leasing LLC · Soldotna, AKBuilt 1976 · S/N 17267472N73455101 Flight LLC · Waterford, MIBuilt 1976 · S/N 17267473N73456K E F Enterprises · Plymouth, MABuilt 1976 · S/N 17267474N73457Bmg Aviation Inc · Bloomington, INBuilt 1976 · S/N 17267475N73459Stowers Joshua S · Niceville, FLBuilt 1976 · S/N 17267477N7345GJacks Air Service Inc · Greenville, MEBuilt 1970 · S/N 17259045N7345QLester Darrell S · Riverton, UTBuilt 1972 · S/N 18260985N7345XStraytail150 LLC · Minneapolis, MNBuilt 1961 · S/N 15059445N73461Monk Crafton L · Saraland, ALBuilt 1976 · S/N 17267478N73462Farkas Dan · Wyoming, MIBuilt 1976 · S/N 17267479N73464Knight Kevin J · Fort Wayne, INBuilt 1976 · S/N 17267481N73467Ryan Air Inc · Anchorage, AKBuilt 1980 · S/N 20700594N73468Tnt Airworks LLC · Hibbing, MNBuilt 1976 · S/N 17267484N7346GBentley Darrell Howard · Powell, TNBuilt 1970 · S/N 17259046N7346SWood Donald · Spring Branch, TXBuilt 1976 · S/N 18265137N7346THalford Richard W · Eagle River, AKBuilt 1959 · S/N 46946N73472Lajova LLC · Amarillo, TXBuilt 1976 · S/N 17267488N73473Lauro Michael J · Kailua Kona, HIBuilt 1976 · S/N 17267489N73477Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1976 · S/N 17267493N7347ATalkeetna Build A Plane Inc · Talkeetna, AKS/N 29447N7347GN7347g LLC · Miami, FLBuilt 1970 · S/N 17259047N7347NAv8 LLC · Boise, IDS/N U20603624N7347QMitchell David L · Imperial, TXBuilt 1972 · S/N 18260987
Back to AD 79-10-14 R1