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.

N5829AVine Clayton A · Wolf Point, MTS/N 28429N5829BFair Skies Inc · Dade City, FLBuilt 1956 · S/N 33829N5829FMoa Klinton J · Bellingham, WABuilt 1966 · S/N 21058829N582LPCape Island Aviation LLC · Millville, NJBuilt 2004 · S/N 172S9582N582SPSvanberg Craig Emile · Dayt Bch Sh, FLBuilt 2000 · S/N 172S8509N582TCBreak For It Aviation LLC · Draper, UTBuilt 2005 · S/N 18281550N58302Gillett John W · Hillsboro, ORBuilt 1972 · S/N 18501966N5830AChapman Erin A · Edmond, OKBuilt 1956 · S/N 28430N5830BHaberich Alexander J · Avon, COBuilt 1956 · S/N 33830N5830FSuchy Karel · Kenosha, WIBuilt 1966 · S/N 21058830N5830GDunn Michael J · Ozark, ARBuilt 1969 · S/N 15071330N5830JMontague Brett A · Van Buren, OHBuilt 1970 · S/N 18501799N58316Labelle-Hamer Brendan T · Fairbanks, AKBuilt 1977 · S/N 18503284N5831ECampbell Jennings R · Bell, FLBuilt 1959 · S/N 17331N5832ABurgess Kelly M · Dannebrog, NEBuilt 1956 · S/N 28432N5832BAircraft Structural Repair Inc · Hamilton, MTS/N 33832N5832GFitzgibbon Patrick D · Waterloo, WIS/N 15071332N5832JAerial Advertising Services · Livermore, CAS/N 17273842N5833AJones Curtis DBA · Jacksonville, NCBuilt 1956 · S/N 28433N5833FVermillion Fc-1 LLC · Crystal City, TXBuilt 1966 · S/N 21058833N5833JAlbatross Air Inc · Beaver, WVBuilt 1980 · S/N 17273843N5834EKendall Samuel · Fairbanks, AKBuilt 1959 · S/N 17334N5835ABoyd Edward L · Riverton, ILBuilt 1956 · S/N 28435N5835BJepson Duwayne D · Frazee, MNBuilt 1956 · S/N 33835N5835ELaw Brian W · Brodhead, WIBuilt 1959 · S/N 17335N5836AMallach Kenneth L · Gatesville, TXFirst renewal noticeBuilt 1956 · S/N 28436N5836ESchulz Michael A · Upland, CABuilt 1959 · S/N 17336N5836JMeyerkorth Aviation LLC · Rock Port, MOBuilt 1970 · S/N 18501805N5837ACrawford Mike R · Flowery Branch, GABuilt 1956 · S/N 28437N5839BReffett John S · Eagle River, AKBuilt 1956 · S/N 33839N5840ETnw Aviation LLC · Clinton, ARS/N 17340N5841ASeipel Damian Y · Huntington Beach, CABuilt 1956 · S/N 28441N5841BFultz Wilbur R · Fort Benton, MTBuilt 1956 · S/N 33841N5841GCrawford Trevor Nicolas · Potter Valley, CABuilt 1956 · S/N 28499N5842BPietrs Michael · Shoreview, MNBuilt 1956 · S/N 33842N5842FHci Properties LLC · Frankston, TXBuilt 1967 · S/N 21058842N5842TArapaho Air LLC · Walnut Grove, CABuilt 1964 · S/N 185-0742N5843EMedlin Wayne D · Marshville, NCFirst renewal noticeBuilt 1959 · S/N 17343N5843FU3 Aviation LLC · Little Rock, ARS/N 21058843N58441Tall Timber Flying Service LLC · Kalispell, MTBuilt 1974 · S/N U20602604N58442Van Vleet Dennis · Kingman, AZBuilt 1973 · S/N 18262066N58443Szeliga Mark H · Bethel, MEBuilt 1973 · S/N 18262067N5844GLummus David R · West Point, MSBuilt 1969 · S/N 15071344N58454Thiele John E · Harrison, IDBuilt 1973 · S/N 18262074N58457Registered aircraftBuilt 1973 · S/N 18262075N58458Prairie Wings Aviation LLC · Victoria, TXBuilt 1973 · S/N 18262076N5845GBerg William J · Aberdeen, SDS/N 15071345N58465Ram Air LLC · Portland, MEBuilt 1973 · S/N 18262079N58466Aerial Transport LLC · Dover, DEBuilt 1974 · S/N U20602609N58467Schaefer Leonard · Oak Dale, PABuilt 1973 · S/N 18262081
Back to AD 79-10-14 R1