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.

N64153Davies Thomas V · Chula Vista, CABuilt 1977 · S/N 18052874N64154Jw Skyhawk LLC · Austin, TXBuilt 1975 · S/N 17265049N64155Lowcountry Flight LLC · Johns Island, SCBuilt 1975 · S/N 17265050N64157Christensen Jeffrey S · Wisconsin Rapids, WIBuilt 1975 · S/N 17265052N64159Flying 14 LLC · Spokane, WABuilt 1975 · S/N 17265053N6415APekkala John W · Palmer, AKS/N 33215N6415FDewitte Jon James · Bishop, GABuilt 1975 · S/N 18264192N6415RAlpine Aviation Of Fayetteville Inc · Prairie Grove, ARBuilt 1979 · S/N 172RG0179N6415SJohnson Edward A · Columbia, SCS/N 15067215N6415TEnglish Gary M · Clermont, FLBuilt 1959 · S/N 17815N6415VPeter Prince Aviation Center LLC · Milton, FLS/N 172RG0677N6415XPogany Steve C · Chugiak, AKBuilt 1960 · S/N 18050915N64160Glide Slope LLC · East Hampton, NYBuilt 1975 · S/N 17265054N64161Aom Aircraft LLC · Orlando, FLBuilt 1975 · S/N 17265055N64162Mccormick Philip D · Mount Pleasant, IABuilt 1975 · S/N 17265056N64163Good Airplanes LLC · Oshkosh, WIBuilt 1975 · S/N 17265057N64165Weaver Lynwood J Jr · Raleigh, NCBuilt 1975 · S/N 17265059N64167Registered aircraftS/N 18052875N6416AJanak Jeffrey · Corpus Christi, TXBuilt 1956 · S/N 33216N6416GRolin Brian · Mc David, FLBuilt 1970 · S/N 15071916N6416KShreveport Aviation Services LLC · Shreveport, LAS/N 15077692N6416SCerny Mark V · Canyon City, ORBuilt 1967 · S/N 15067216N6416TMitchell Paula E · Norman, OKBuilt 1959 · S/N 17816N64173Training Planes LLC · Tampa, FLBuilt 1975 · S/N 17265065N64174Sen Air Inc · Mckeesport, PABuilt 1975 · S/N 17265066N6417ALevasseur Peter W · Plymouth, MEBuilt 1956 · S/N 33217N6417ESharpley David Jr · Pittsboro, INBuilt 1959 · S/N 46517N6417FAdkins Ian B · Dahlonega, GABuilt 1966 · S/N 15063017N6417JChapman Michael K · North Salt Lake, UTS/N 17273871N6417KVaro-Real Investments Inc · Visalia, CAS/N R1722044N6417NTaylor Michael Norman · Chino Hills, CABuilt 1978 · S/N 21062993N6417TBazeley Paul J · Aurora, ORS/N 17817N64180Spanaflight LLC · Puyallup, WABuilt 1975 · S/N 17265069N64181Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275529N64183Chiappe Glenn R · Lago Vista, TXBuilt 1977 · S/N 18052877N64184Arlington Flight Services Inc · Arlington, WABuilt 1975 · S/N 17265071N64186Paraloft LLC · Mims, FLBuilt 1975 · S/N 17265072N6418DAirways Aviation Inc · Grand Rapids, MNBuilt 1979 · S/N 17272793N6418ELima-001 LLC · Muscatine, IAS/N 17272019N6418XCoffman David W · Wilbur, WABuilt 1960 · S/N 18050918N64191Flycarolina LLC · Concord, NCBuilt 1975 · S/N 17265076N64192Skyhawk Transport LLC · Hazel Green, ALBuilt 1975 · S/N 17265077N64198Randy Goering Inc · Bend, ORBuilt 1975 · S/N 17265080N64199Mutschler George Robert Jr · Bayfield, COBuilt 1975 · S/N 17265081N6419BMarshall Timothy M Trustee · Tucson, AZBuilt 1978 · S/N 21062762N6419TBaich Michael V · Coleraine, MNBuilt 1959 · S/N 17819N6419VUrbana Aircraft LLC · Urbana, MDBuilt 1980 · S/N 172RG0680N6419XPernat Frank J Trustee · Chaska, MNBuilt 1980 · S/N U20605877N641ABDaccarett Marcos · Boise, IDS/N 182-67178N641DACavu Aviation LLC · Lake Geneva, WIBuilt 1970 · S/N 18501619
Back to AD 79-10-14 R1