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.

N7477XBindea Bogdan Andrei · Charlottesville, VAS/N 17247977N7478AColorado Air Ventures LLC · Colorado Springs, COBuilt 1956 · S/N 29578N7478GMckinney Brian M · Lakeville, MNS/N 17259178N7478MMayle Brian · West Granby, CTBuilt 1958 · S/N 55778N7479CBentley John R · Bend, ORS/N 30565N7479GLebanon Flying Club Inc · Lebanon, TNBuilt 1970 · S/N 17259179N7479XLanger Joseph H · Blairsville, GAS/N 17247979N747ALLopez Guy S · Big Lake, AKS/N 51748N747APB R S Leasing Inc · Wilmington, DEBuilt 2003 · S/N 172S9535N747AQQuadrani Anthony L · Kingsford, MIBuilt 1974 · S/N 18502333N747FAInman David · Dripping Springs, TXBuilt 1998 · S/N 18280216N747FNInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 33701895N747GBBrogan Kenneth A Jr · Montesano, WABuilt 1972 · S/N 17259440N747GKEastern Stearman Inc Trustee · Leesburg, VABuilt 2007 · S/N 18282029N747JHJlm Machine Co Inc · Bradenton, FLBuilt 1978 · S/N 17270642N747JLWillis Robert K · Lake Havasu City, AZBuilt 1975 · S/N 18264279N747KKHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1976 · S/N 17267651N747KTIasco Flight Training Inc · Redding, CABuilt 1997 · S/N 17280020N747KYMahany John S · Long Beach, CABuilt 1970 · S/N 15071860N747LPSimplifly LLC · Mesa, AZBuilt 1971 · S/N 17260272N747LTRoth James D · Shady Shores, TXBuilt 1999 · S/N 172S8081N747MLMaxwell Robert C · Fountain Hills, AZBuilt 1975 · S/N 177RG0719N747PBBromley James B II · Hesperia, MIBuilt 1956 · S/N 28846N747PCUmo Fight School LLC · Mount Olive, NCBuilt 1977 · S/N 17269156N747PMVko Llp · Custer, SDBuilt 1969 · S/N 18259564N747PTPrince Paul D · Spring Hill, FLBuilt 1974 · S/N 172-63247N747SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12445N747SMTextron Aviation Inc · Wichita, KSS/N 18283371N747SQYr-Aircraft Leasing LLC · Bethel, AKBuilt 1977 · S/N 20700387N747TWRegistered aircraftBuilt 2022 · S/N 18283200N747UCTate Brian J · Perkasie, PABuilt 1977 · S/N 18265367N747VHAmerican Patrols Inc · Midland, TXBuilt 1976 · S/N 17266914N747WGWhiskey Gulf Aero LLC · Deland, FLBuilt 1968 · S/N 18259186N747ZFriesen Joshua D · Wallace, NEBuilt 1951 · S/N 19922N7480APacific Ag Services · Firebaugh, CABuilt 1957 · S/N 29580N7480GPage Ralph W · Jennings, LABuilt 1970 · S/N 17259180N7480QDecatur Aero Club Inc · Decatur, ILBuilt 1972 · S/N 18261120N7480THalley Dan R · Avery, TXBuilt 1959 · S/N 47080N7480XFoster Ricardo E · Lutz, FLBuilt 1960 · S/N 17247980N7481AGrocholl Mark · Rockton, ILBuilt 1956 · S/N 29581N7481GUncapher Elmer D · Mendon, OHS/N 17259181N7481TFairon Daniel · Fox Island, WABuilt 1959 · S/N 47081N7482MSchwab Mark C · Kimball, MIBuilt 1959 · S/N 55782N7482XWilliams John R · Maquoketa, IABuilt 1960 · S/N 17247982N7483EMerriman David A · Rocklin, CABuilt 1960 · S/N 57183N7483QDawson Stewart J · Celina, TXBuilt 1978 · S/N 18503606N7483XDoerr David B · Verdon, NEBuilt 1960 · S/N 17247983N7484MMesiar David C · Anchorage, AKBuilt 1959 · S/N 55784N7484QPlanebroker.Com LLC · Miramar Beach, FLBuilt 1972 · S/N 18261124N7484XHoulton Timbre R · Fairbanks, AKBuilt 1960 · S/N 17247984
Back to AD 79-10-14 R1