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.

N7218ERice Ross H · Moab, UTBuilt 1959 · S/N 52218N7218MFord Ethan G · Anchorage, AKS/N 55518N7218TTwilley Reginald M · Mobile, ALFirst renewal noticeBuilt 1959 · S/N 46818N72194Skydive Ky LLC · Cecilia, KYBuilt 1969 · S/N U206-1315N7219MBrincefield Leland L · Waconia, MNBuilt 1958 · S/N 55519N7219STulsa Flight Training LLC · Bixby, OKBuilt 1967 · S/N 15067919N7219TScott Gregory R · Kennesaw, GABuilt 1959 · S/N 46819N721AEmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 1978 · S/N 18266259N721AAGammage Linda L · Delanco, NJBuilt 1968 · S/N 17257605N721CTChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10140N721CWFischer Alfred M DBA · Genoa City, WIS/N 15067112N721EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13055N721JMWalton Frederick W · Upper Sandusky, OHBuilt 1959 · S/N 56038N721LULiberty University · Lynchburg, VABuilt 2010 · S/N 172S11056N721MWelch James D · Holdenville, OKBuilt 1957 · S/N 29879N721NRUS Department Of The Interior · Boise, IDBuilt 1985 · S/N U20606902N721SACommonwealth Of Massachusetts · Bridgewater, MABuilt 1997 · S/N 17280239N721SGAlaska Air Service LLC · Brookings, ORBuilt 1964 · S/N 206-0265N721THAtp Aircraft 7 LLC · Wilmington, DEBuilt 2017 · S/N 172S12011N721ZASky-Vu Flyers Inc · Fishers, INBuilt 2004 · S/N 18281439N7220GStagg Travis M · Fairbanks, AKBuilt 1969 · S/N 17258920N7220NNatural Selection Farms Inc · Sunnyside, WABuilt 1974 · S/N 18263011N7221EMuller Farm And Ranch · Grenora, NDBuilt 1959 · S/N 52221N7221MStartin Evan A · Colfax, WABuilt 1958 · S/N 55521N7221QSleeping Giant Flying Club · Helena, MTBuilt 1972 · S/N 17260521N7221SGardner Riley F · Hamilton, TXBuilt 1976 · S/N 18265083N7221TDahle Neil E · Mason City, IABuilt 1959 · S/N 46821N72222Jouppi Kenneth J · Ward Cove, AKBuilt 1969 · S/N U206-1329N7222AChamberlain C Douglas · Bellefontaine, OHBuilt 1956 · S/N 29322N7222NN B Tweet & Sons · Nome, AKBuilt 1976 · S/N U20603568N7222QMohawk Flying Club Inc · Ada, MIBuilt 1972 · S/N 17260522N7222TRegistration Pending · Lawndale, CARegistration pendingBuilt 1959 · S/N 46822N7223ASather Evan · Hayward, CAS/N 29323N7223GLaze Daniel · Carson City, MIBuilt 1973 · S/N 15074624N7223MMoosehead Enterprises LLC · Estero, FLBuilt 1958 · S/N 55523N7223NLee Stephen J · Cadiz, KYS/N 18263014N7223QBuiqui Aerospace Corp · Kissimmee, FLBuilt 1972 · S/N 17260523N7223SSong David D · Ashland, CABuilt 1967 · S/N 15067923N7223TRoberts Michael R · Plano, TXBuilt 1959 · S/N 46823N7224EHowenstein John G · Roseville, CABuilt 1959 · S/N 52224N7224NCook Jon I · Cloudcroft, NMBuilt 1974 · S/N 18263015N72250Anderson Gilbert Lc · Palm Bay, FLS/N 33701548N7225AFouts Philip W · Caldwell, IDBuilt 1956 · S/N 29325N7225GVance Wilbur H III · Hershey, PABuilt 1970 · S/N 17258925N7225SAero States Aviation LLC · Owasso, OKBuilt 1967 · S/N 15067925N7225VConnecticut Aircraft Sales LLC · Manchester, CTBuilt 1977 · S/N 17270030N7226EKinnebrew John · Adkins, TXBuilt 1959 · S/N 52226N7226GHerlihy Douglas K II · Denville, NJBuilt 1970 · S/N 17258926N7226SN46132 Leasing LLC · Kalispell, MTBuilt 1967 · S/N 15067926N7226TCreasman Zane V · Arden, NCBuilt 1959 · S/N 46826
Back to AD 79-10-14 R1