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.

N8940GCapps Christopher N · Austin, TXBuilt 1970 · S/N 18260480N8940XKish John · Fort Mohave, AZBuilt 1961 · S/N 18253340N8941BBig R Of Greeley Inc · Greeley, COBuilt 1958 · S/N 36641N8941TGeco Inc · Wilmington, DEBuilt 1960 · S/N 52841N8941VSky Castle Aviation LLC · New Castle, INBuilt 1974 · S/N 17264298N8941XParrish Perry W · Columbia, KYS/N 18253341N8942BBishops Sky Cam LLC · Jonesburg, MOBuilt 1958 · S/N 36642N8942GSale Reported · Stevensville, MTSale reported, canceledBuilt 1970 · S/N 18260482N8942TMonger Curtis V · Bend, ORS/N 52842N8942VPilots Flying School LLC · Englishtown, NJS/N 17264299N8942XBlb Group LLC · Lake Havasu City, AZBuilt 1961 · S/N 18253342N8943BHarris David B III · Parlier, CAS/N 36643N8943GTruyaert Ivan R Jr · New Carlisle, INBuilt 1970 · S/N 18260483N8943VZiegler Aviation LLC · Minneapolis, MNBuilt 1974 · S/N 17264300N8944GSagra Nw LLC · Ronan, MTBuilt 1970 · S/N 18260484N8945TLumpkin Ed · Rosie, ARS/N 52845N8945XHarty Arthur · Acampo, CABuilt 1961 · S/N 18253345N89464Freeway Airport Inc · Mitchellville, MDBuilt 1983 · S/N 17276006N8946BLumberjack LLC · Flagstaff, AZBuilt 1958 · S/N 36646N8946VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264302N8946XKennedy Dennis R Trustee · Westlake Village, CABuilt 1961 · S/N 18253346N8947BKaczmarek Richard G · Sandersville, GAS/N 36647N8947SMatyas Aviation Inc · Sugarloaf, PABuilt 1965 · S/N 15062247N8947VMills Alan F · Chatom, ALBuilt 1974 · S/N 17264303N8947XN8947x LLC · Middletown, DEBuilt 1961 · S/N 18253347N8948GWilbur-Ellis Co · Salinas, CABuilt 1970 · S/N 18260488N8948VPlain Company Ltd · Bloomfield Hills, MIBuilt 1974 · S/N 17264304N8948XRhodes Steven D · Anchorage, AKBuilt 1961 · S/N 18253348N8949GChuckanut Flying Club Inc · Bellingham, WABuilt 1970 · S/N 18260489N894AHAerospace Asset Holdings LLC · Wilmington, DEBuilt 1977 · S/N U20604061N894CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281864N894EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13236N894KCFlight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10742N89503Menne Aviation LLC · Brooklyn Park, MNBuilt 1983 · S/N 17276007N8950BPeppers Denise S · Centre, ALBuilt 1958 · S/N 36650N8950TGribi Daniel M · Miranda, CAS/N 52850N8950XAnderson Craig M · Barron, WIBuilt 1961 · S/N 18253350N8951GThrash Helen · Pelahatchie, MSS/N 18260491N8952TNorthwest Exteriors Inc · Rancho Cordova, CABuilt 1960 · S/N 52852N8953GAirfleet Solutions LLC · Newark, DEBuilt 1970 · S/N 18260493N8953TDouglass Jason E · Friday Harbor, WABuilt 1959 · S/N 47158N8953XHenning Jeffrey Carl · Prescott, AZBuilt 1961 · S/N 18253353N8954URausch John H · Fairport, NYBuilt 1976 · S/N 15078026N8954XGansz Kenneth L · Clare, IABuilt 1961 · S/N 18253354N8955SHewett Donnie · Little River, SCS/N 15062255N8955XPampa Office Supply · Elk City, OKBuilt 1961 · S/N 18253355N8956TBrown Donald L · Peoria, AZS/N 52856N8956XLove Brandon · Big Sandy, TXS/N 18253356N8957BScott Larry R · Hobbs, NMS/N 36657N8957SMiller Andy · Marana, AZBuilt 1965 · S/N 15062257
Back to AD 79-10-14 R1