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.

N6313EGottshall Curt E · Monroe, WABuilt 1959 · S/N 46413N6313FTeens In Flight Inc · Palm Coast, FLBuilt 1979 · S/N 17273188N63145Morin James R · West Ossipee, NHS/N 18052833N63149Aviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1975 · S/N 15077138N6314AGarletts Frank · Jackson, MSBuilt 1956 · S/N 33114N6314BGregg Delvin K · Durango, COBuilt 1957 · S/N 34214N6314CC4p LLC · Jackson, TNFirst renewal noticeBuilt 1980 · S/N 21063861N6314DSaghafi Jamsheed Trustee · Parma, OHBuilt 1978 · S/N 21062938N6314EWeber Tom L · Douglas, WYBuilt 1959 · S/N 46414N6314GKing William E · Simpsonville, SCBuilt 1970 · S/N 15071814N63150Parrish Jonathan · Boulder City, NVBuilt 1962 · S/N 15059756N63154Burleson James G · Grand Prairie, TXBuilt 1975 · S/N 15077142N63155Morten David J · Larimore, NDS/N 15077143N63157Tadres Abanob Y · Antioch, TNBuilt 1975 · S/N 15077145N6315APerkins Larry L · Wildomar, CABuilt 1956 · S/N 33115N6315BEbright Sean E · Hasty, COS/N 34215N6315FSavidge Lenice M · Rogers, ARS/N 337-0315N6315SDelta Delta Aviation Group Inc · New Castle, DEBuilt 1967 · S/N 15067115N63165Eagle Eye Aviation LLC · Mccomb, MSBuilt 1975 · S/N 15077150N63166Chucks Aircraft LLC · Hartland, MES/N 18052834N63169Spinola Hernandes M · Homestead, FLBuilt 1975 · S/N 15077153N6316DRuiz Edinson · Bakersfield, CABuilt 1979 · S/N 17272714N6316GChurch Aviation LLC · Christmas Valley, ORFirst renewal noticeS/N 15071816N6316SGlobal Navigator LLC · Anacortes, WABuilt 1967 · S/N 15067116N63174Evans James II · Seattle, WAS/N 17275399N63177Christiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10778N63179Fetch Carl Jr · Monongahela, PABuilt 1975 · S/N 15077157N6317DJkg LLC · Murfreesboro, TNBuilt 1979 · S/N 17272715N6317GChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10777N63180Hall Thomas E · Sylvia, KSBuilt 1975 · S/N 15077158N63181Wild Blue Flight LLC · Ellensburg, WABuilt 1975 · S/N 15077159N63186Branche Mitchell J · Winter Haven, FLBuilt 1975 · S/N 15077164N6318AElliott Dave P · Boulder, COBuilt 1956 · S/N 33118N6318BCenturion Associates 2 LLC · Elgin, SCBuilt 1978 · S/N 21062745N6318EEvans Robert W · Upland, CABuilt 1959 · S/N 46418N63197Deangelis Kristopher M · Las Vegas, NVBuilt 1975 · S/N 15077166N63198White Hayden · Lees Summit, MOBuilt 1975 · S/N 15077167N63199Winfred & Waters LLC · Georgetown, TXBuilt 1975 · S/N 15077168N6319BAtarah LLC · Tucson, AZBuilt 1957 · S/N 34219N6319FAbidance Inc · Winthrop, WAS/N 18264154N6319KStemmer Kenneth Edward · Palm Desert, CABuilt 1975 · S/N 15077641N631AAAerospring Leasing LLC · Wasilla, AKBuilt 2025 · S/N 172S13373N631AFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 20608070N631CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281520N631CTCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10779N631EHHuddleston Edward L · Oaktown, INBuilt 1966 · S/N 15063361N631SLee Grant L · Dallas, TXBuilt 1977 · S/N 18265554N63205Bagwell Robert B · Sequim, WABuilt 1975 · S/N 15077173N63207Two Star Maritime LLC · Fremont, CABuilt 1975 · S/N 15077175N6320FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1979 · S/N 17273190
Back to AD 79-10-14 R1