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.

N8122APerkins Christopher R · Brackettville, TXBuilt 1952 · S/N 20974N8122FGreat Lakes Charity Air LLC · Brown City, MIBuilt 1966 · S/N 15064222N8122LWoodward Thomas M · Granbury, TXBuilt 1974 · S/N 177RG0610N8122SAnderson Donald A · Kiel, WIBuilt 1965 · S/N 15061722N8122XRusty Flyer Aviation LLC · Grove City, OHBuilt 1961 · S/N 17248622N8123AEgmond Aircraft LLC · Lewes, DEBuilt 1952 · S/N 20975N8123BVan Maren John C · Owasso, OKBuilt 1957 · S/N 29923N8123FTilley Christian M · Shelby, MTBuilt 1966 · S/N 15064223N8123GBlattmachr Matthew · Anchorage, AKS/N U20603770N8123LShippee Norman J · Foster, RIBuilt 1974 · S/N A1500499N8123Q8123q LLC · Olympia, WABuilt 1975 · S/N U20603093N8123TBurns Lawrence S · New Smyrna Beach, FLBuilt 1960 · S/N 17556823N8123USterner Thomas M · Wilmington, DEBuilt 1976 · S/N 15077892N8123ZGray Bryan D · Colorado City, TXBuilt 1962 · S/N 205-0123N8124BVan Skyhawk Charles R · Eagle River, WIS/N 29924N8124FMurray Mark J · Georgetown, GABuilt 1966 · S/N 15064224N8124TWanke Michael L · Merrill, WIBuilt 1960 · S/N 17556824N8124UGardoski Mark · Twin Falls, IDBuilt 1964 · S/N 17252024N8124VFarhat Jamal M · Rochester, MIBuilt 1977 · S/N R1722316N8124XNehrbass Douglas · Clarksville, TNBuilt 1961 · S/N 17248624N8125BTrue Heading LLC · Granite City, ILBuilt 1957 · S/N 29925N8125MDobson Air Enterprise LLC · College Station, TXBuilt 1976 · S/N 18264543N8125STucker William F · Booneville, ARS/N 15061725N8125TLinebaugh Ricky L · Dover, PABuilt 1960 · S/N 17556825N8125UAgati Stephen B · Tucker, GABuilt 1964 · S/N 17252025N8125XBlue Skies Flying Services LLC · Blandon, PAS/N 17248625N8125ZM E M Enterprises · Friday Harbor, WABuilt 1962 · S/N 205-0125N8126BRobinson Michael E · Anthony, NMBuilt 1957 · S/N 29926N8126EAnderson Wilbur W Trustee · Lead Hill, ARBuilt 1978 · S/N 17272143N8126FWhite Guy B · Waxahachie, TXS/N 15064226N8126SSun Valley Aviation Inc · Harlingen, TXBuilt 1965 · S/N 15061726N8126TBergland John Edward · Santa Monica, CABuilt 1952 · S/N 20952N8126ZBarber Jonathan D · Payson, AZBuilt 1962 · S/N 205-0126N8127L2f Trade LLC · Gainesville, TXS/N 21060614N8127TCahalan Robert J · Stroudsburg, PABuilt 1960 · S/N 17556827N8127XBlick Clayton T · Dunedin, FLBuilt 1961 · S/N 17248627N8128FShowers Gregory S · Williamstown, PABuilt 1966 · S/N 15064228N8128LSayco Aviation LLC · Fayetteville, GABuilt 1974 · S/N 21060615N8128MSchwartz Donald G · Elroy, WIBuilt 1976 · S/N 18264544N8128SLawrence Jason C · Tecumseh, MIBuilt 1965 · S/N 15061728N8128TSvoboda Patrick J · Bucyrus, KSBuilt 1960 · S/N 17556828N8128UWalters Stephen B · Madison, ALBuilt 1964 · S/N 17252028N8129BSeneca Enhancements Company LLC · Portland, ORBuilt 1957 · S/N 29929N8129FHigh Exposure Inc · Wilmington, DEBuilt 1966 · S/N 15064229N8129GJohnson Richard A Trustee · Chandler, AZBuilt 1971 · S/N 21059429N8129ZRhodes Steve A · Auburn, CAS/N 205-0129N812AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281197N812CPHigh Wing Air Services LLC · Merritt Island, FLBuilt 1977 · S/N 17268790N812DAHanson Aviation LLC · Winter Park, FLBuilt 1979 · S/N 17273577N812EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12797
Back to AD 79-10-14 R1