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.

N4410TLavin Gregory S · Chugiak, AKBuilt 1982 · S/N 18504335N4410VMorris Roy S · Shorter, ALBuilt 1948 · S/N 18543N4411Mh Aviation LLC · Dublin, CABuilt 1965 · S/N 15062560N4411BFerguson James L · Junction City, KSBuilt 1955 · S/N 26755N4412BGiraffe & Platypus Aviation Ltd · Fort Collins, COBuilt 1955 · S/N 26756N4412QWoods Flying Service LLC · Memphis, MOBuilt 1971 · S/N 18800812N4413BBynum Sonia · Portland, ORBuilt 1955 · S/N 26757N4413SBirmingham Flight Center LLC · Birmingham, ALS/N 17257905N4413USpears David A · Naperville, ILBuilt 1964 · S/N 15060413N4414RKirk Ledoux · Stanwood, WABuilt 1979 · S/N U20605111N4414VVan Noy Greg A · Bozeman, MTBuilt 1948 · S/N 18547N4415RNextgen Flight Academy Inc · Riverside, CABuilt 1974 · S/N 17263163N4416LBustamante Marcos H · Nogales, AZBuilt 1966 · S/N 17254503N4416VWiebe Aron Fehr · Seminole, TXBuilt 1948 · S/N 18549N4417UBlacqjacq Aviation Co · Wilmington, DEBuilt 1964 · S/N 15060417N4418BFulwiler Daniel R · Green Bay, WIBuilt 1955 · S/N 26762N4418LIroquois Soaring Assn · Rome, NYBuilt 1966 · S/N 17254505N4418RTeton Leasing LLC · Pocatello, IDBuilt 1974 · S/N 17263166N4419BStaubach Adam R · North Pole, AKBuilt 1955 · S/N 26763N4419LMil2atp Inc · Pikeville, NCBuilt 1966 · S/N 17254506N441AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1983 · S/N 17276091N441CAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280441N441DLPinion Aviation Inc · Glenbrook, NVBuilt 1976 · S/N 17267391N441DPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1975 · S/N 17265691N441ERVeve Jesus Vila · Mayaguez, PRBuilt 2005 · S/N 172S10060N441NAHendry Rickey W · Apple Springs, TXBuilt 1955 · S/N 32198N441QFChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280278N441SPPendragon Aviation LLC · Sylvania, GABuilt 1982 · S/N 18268215N441SSSchwarz Mickey D · Thorndale, TXBuilt 1964 · S/N 15060512N441TJRylee LLC · Lawrence, KSBuilt 1979 · S/N 18267141N441TSRawareo LLC · Warsaw, MOBuilt 1966 · S/N 17254288N44200Cessna172 LLC · Holliday, TXBuilt 1956 · S/N 28127N4420ENoguerra Eric · Astoria, ORBuilt 1973 · S/N 15073879N4420LMic Jack LLC · Stuart, FLFirst renewal noticeBuilt 1966 · S/N 17254507N4420RPeterson Reid E · Minnetonka, MNBuilt 1974 · S/N 17263167N4421LSouthern Seaplane Inc · Belle Chasse, LAS/N 17254508N4421UClaypool James W · Hunts Point, WABuilt 1980 · S/N 18267449N4422RN4422r LLC · Miami, FLBuilt 1974 · S/N 17263168N4423BMouser Cassandra J · Beaverton, ORBuilt 1955 · S/N 26767N4423LQuigley James J · Labelle, FLBuilt 1966 · S/N 17254512N4423QObap · Westchester, ILBuilt 1973 · S/N 17261704N4423UReed Andrew · Peck, MIS/N 15060423N4423VThomas Jessica A · Bethel Island, CABuilt 1948 · S/N 18554N4424FPt Logistics LLC · Rye, NHBuilt 1955 · S/N 26768N4424LTikiun Thaddeus J Jr · Bethel, AKBuilt 1966 · S/N 17254513N4425UAlbers Brian C · Portland, INBuilt 1964 · S/N 15060425N4427BRoderick Paul Edward · Talkeetna, AKBuilt 1955 · S/N 26771N4427LHatter Ronnie A · Newcastle, OKBuilt 1966 · S/N 17254516N4427RRedwood Aviation Group LLC · Santa Rosa, CABuilt 1974 · S/N 17263173N4427UEichmann Sheri L · Paulden, AZBuilt 1964 · S/N 15060427
Back to AD 79-10-14 R1