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.

N684DWSun Aircraft Management LLC · Ormond Beach, FLBuilt 2000 · S/N 17280945N684MCT&B Aero LLC · Jacksonville, FLS/N 21061604N684SSecond Wind Aviation Corp · Friday Harbor, WABuilt 1969 · S/N 20700147N684SPCondor Aero Club Inc · Zelienople, PABuilt 1999 · S/N 172S8095N6850BJennings Donald J · Gypsum, COS/N 21062845N6850ESchott Nicholas F · Burns, ORBuilt 1959 · S/N 56350N6850GVoorheis Patrica D · Casa Grande, AZBuilt 1970 · S/N 15072350N6851ECharlie Lima 1 LLC · Jacksonville, FLBuilt 1978 · S/N 17272074N6851FCarr Thomas W · Grand Blanc, MIBuilt 1966 · S/N 15063451N6851R6851r LLC · Greeley, COS/N T210-0251N6852AFabian Ryan S · Vancouver, WABuilt 1956 · S/N 28952N6852HSetter Jory · Midvale, UTBuilt 1975 · S/N 17265608N6852RJensen Sid R · Idaho Falls, IDBuilt 1967 · S/N T210-0252N6853HJohnson Seth W · North Pole, AKBuilt 1975 · S/N 17265609N6854ADulin Thad L · Midland, TXBuilt 1956 · S/N 28954N6854ERowe Cecil D · Knoxville, TNBuilt 1959 · S/N 56354N6854GUniverse LLC · Prospect, KYBuilt 1970 · S/N 15072354N6854HN6854h LLC · Opa Locka, FLBuilt 1975 · S/N 17265610N6855ACowley Dale Thomas Trustee · Sandusky, MIS/N 28955N6855RD & N Holdings Inc · Boca Raton, FLBuilt 1967 · S/N T210-0255N6856EHigh Plains Agronomics Inc · Milliken, COBuilt 1959 · S/N 56356N6856MWoodall Larry Douglas · Auburn, WABuilt 1975 · S/N 18263861N6857GDuran Alexander · Holbrook, NYBuilt 1970 · S/N 15072357N6857HNew Mexico Flying Eagle Inc · Tucson, AZBuilt 1975 · S/N 17265611N6857MRegistration Pending · Lenoir City, TNRegistration pendingBuilt 1975 · S/N 18263862N6857RRegistered aircraftBuilt 1967 · S/N T210-0257N6858ACorrigan Flying Club · Manitowoc, WIBuilt 1956 · S/N 28958N6858EMalara Steven · Frankfort, NYBuilt 1984 · S/N 18268378N6858HPrairie Skies Aviation LLC · Hutchinson, KSBuilt 1975 · S/N 17265612N6858XHoang Andrew Q · Seal Beach, CABuilt 1960 · S/N 17247758N6859AClark Brenton J · Fairfield, IAFirst renewal noticeS/N 28959N6859EAndersen Henrik T · Golden, COBuilt 1959 · S/N 56359N6859HRoeper Gary Lee · Linden, MIS/N 17265613N6859MRegistration Pending · Woodruff, SCRegistration pendingBuilt 1975 · S/N 18263863N6859RRomeo Airmotive LLC · Stockton, CABuilt 1967 · S/N T210-0259N6859XWilkerson Bradley W · Caldwell, IDBuilt 1960 · S/N 17247759N685ACMullerhill Inc · Hillsboro Beach, FLBuilt 2004 · S/N 18281463N685BBHeavenly Flight LLC · Cumming, GABuilt 2023 · S/N 172S12980N685DWUpper Valley Flying Club Inc · White Riv Jct, VTBuilt 2000 · S/N 17280946N685GTEatmb Air Inc Trustee · Wilmington, DEBuilt 1979 · S/N 21063361N685JMBallard Aviation · Waynesville, MOBuilt 1974 · S/N 18801992N685LACorr Joshua · Santa Paula, CABuilt 1965 · S/N 185-0876N685RADenkat Plane Shadow LLC · Buckeye, AZBuilt 1968 · S/N 15068701N685SSecond Wind Aviation Corp · Friday Harbor, WABuilt 1970 · S/N 20700184N685SPDirty Side Down Aviation LLC · Georgetown, TXBuilt 1999 · S/N 172S8096N685VAlpha Golf Flyers Inc · Wilmington, DEBuilt 1976 · S/N P3370265N6860HUniversity Of Michigan Flyers · Ann Arbor, MIBuilt 1975 · S/N 17265614N6861EBeckerman George F · Mount Carmel, ILBuilt 1959 · S/N 56361N6861HViking Systems Inc · Naples, FLS/N 17265615N6861MEwing Aviation LLC · Ellisville, MSBuilt 1975 · S/N 18263865
Back to AD 79-10-14 R1