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.

N8282BAmyx Hiram R · Liberty, TXBuilt 1957 · S/N 36082N8282TLoveless Phillip A · Independence, KSBuilt 1961 · S/N 17556982N8283LChapin Devon S · Oxford, CTS/N 17256483N8283UThede Dondi I · Marshall, WIBuilt 1964 · S/N 17252183N8283XWinfrey Walter A · Auburn, CABuilt 1961 · S/N 17248783N8283ZClear Prop LLC · Bogalusa, LAS/N 205-0283N8284LMaxwell Barton W Jr · Crawfordsville, INBuilt 1967 · S/N 17256484N8285Mason Samuel A · Santa Paula, CABuilt 1982 · S/N 18504393N8285AReim Sanford E · Fort Myers, FLBuilt 1952 · S/N 25137N8285EJames G Loy General Contractor Inc · Punta Gorda, FLBuilt 1979 · S/N 17272171N8285FBearss Gordon M · Lawrence, KSBuilt 1966 · S/N 15064385N8285UDel Martin Lp · Spring, TXBuilt 1964 · S/N 17252185N8285XBerntsen Bradley T Trustee · Apple Valley, MNBuilt 1961 · S/N 17248785N8285ZVaughn Hollis L · Virden, NMBuilt 1963 · S/N 205-0285N8286EPreston Richard R Trustee · Albuquerque, NMBuilt 1979 · S/N 17272172N8286LKyle John M · Wheeling, WVBuilt 1967 · S/N 17256486N8286M3 Jc LLC · Phoenix, AZBuilt 1970 · S/N 21059286N8286TWelch Scott P · Lovell, WYFirst renewal noticeBuilt 1961 · S/N 17556986N8287ALindholm Stanley D Trustee · Lucas, TXBuilt 1952 · S/N 25139N8287LShirk Matthew · Auburn, INBuilt 1967 · S/N 17256487N8287MProfessional Metal Services Inc · Albion, NEBuilt 1970 · S/N 21059287N8287QAdventist World Aviation · Wilson, NCBuilt 1976 · S/N U20603148N8287XMckeever Jesse M · Indio, CABuilt 1961 · S/N 17248787N8287ZMillion John B · Westminster, MDBuilt 1963 · S/N 205-0287N8288EGomez Cierra D · Jasper, ALS/N 17272174N8288GFord Flying Service Inc · Doerun, GABuilt 1973 · S/N 18801287N8288MAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1970 · S/N 21059288N8288SWatters Reid W · Tilleda, WIBuilt 1965 · S/N 15061888N8288TDooley Kenneth J · Charleston, TNBuilt 1961 · S/N 17556988N8288XLantana Beach Flying Club · West Palm Beach, FLBuilt 1961 · S/N 17248788N8289BGodfrey Brian T · Waupaca, WIBuilt 1957 · S/N 36089N8289FDe Cristo Andre G · Flushing, NYBuilt 1966 · S/N 15064389N8289GDutcher Kenneth J · Kingsland, TXS/N 177RG0189N8289LFaust Stanley J · Nashua, NHBuilt 1967 · S/N 17256489N8289UPrice William B · Lamar, SCBuilt 1964 · S/N 17252189N828BMChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280134N828CFChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280326N828CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281272N828EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2022 · S/N 172S12833N828FGRidgeline Assets LLC · Wilmington, DEBuilt 2023 · S/N 172S13076N828FSPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1999 · S/N 17280794N828JTAtems Elisabeth · Northfield, VTBuilt 1976 · S/N 177RG0945N828LFFinseth Loren V Trustee · Fountain, MNBuilt 1977 · S/N 18265438N828LPFlying Twenties Inc · San Jose, CABuilt 2001 · S/N 172S8828N828PBAero Missions LLC · Zeeland, MIBuilt 1977 · S/N 18265926N828PKElizabeth City State University · Elizabeth City, NCBuilt 2020 · S/N 172S12596N828RHMad Kav Properties LLC · Corona, CABuilt 1979 · S/N 18267467N828RJNielsen Ron E · Lindon, UTS/N 21063836N828SGSky High Aviation Of Ga LLC · Doraville, GABuilt 2012 · S/N 18282325N828SPVista Aviation Inc · Pacoima, CABuilt 2001 · S/N 172S8741
Back to AD 79-10-14 R1