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.

N457EPRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11593N457GGBohl Howard M · Temecula, CAS/N 15060269N457SKWorld Marketing Syndicate I · Wilmington, DEBuilt 1975 · S/N 17264736N457SPSouth Dakota State University · Brookings, SDBuilt 1999 · S/N 172S8321N4580EDe Baca Land & Cattle LLC · Jacksboro, TXBuilt 1982 · S/N 18268244N4580JBlakeslee Mark C · Kodiak, AKBuilt 1975 · S/N 180-52509N4580UDean Nolan W · Harrisonburg, VABuilt 1964 · S/N 15060580N4581CGerardy Harlan D · Gruver, TXBuilt 1953 · S/N 25525N4582CBontrager Brian S · Wasilla, AKBuilt 1953 · S/N 25526N4582ERelis Enterprises LLC · Ravenel, SCBuilt 1982 · S/N 18268245N45835Yoakam John A · North Ridgeville, OHS/N 177RG0756N4583CWood L Paul · Bridgeport, TXS/N 25527N4584BNadon Peter M · Aztec, NMBuilt 1955 · S/N 31483N4584CEco Resources Inc · Millersport, OHBuilt 1953 · S/N 25528N4584UDavis Jubal L · Waverly, OHBuilt 1964 · S/N 15060584N4585BWalchshauser Scott A · Double Oak, TXBuilt 1955 · S/N 31484N4585CTempero Clair R · Worden, MTBuilt 1953 · S/N 25529N4586BGochenaur Dwight W · York Springs, PABuilt 1955 · S/N 31485N4586UCate Randall L · Knoxville, TNFirst renewal noticeBuilt 1964 · S/N 15060586N4587CJackson Marshall L II · Rock Hill, SCBuilt 1953 · S/N 25531N4589CNelson David W · Marengo, ILBuilt 1953 · S/N 25533N458CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 172S13267N458CDDiacont Charles R · Nazareth, PABuilt 2003 · S/N 18281231N458CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280850N458CSHarriss Robert Mallory · Mcallen, TXS/N 18282452N458DJSurvey America Inc · Rancho Cordova, CABuilt 1980 · S/N U20605833N458ESB R S Leasing Inc · Wilmington, DEBuilt 1998 · S/N 18280091N458SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8323N458SRDr2 Aviation LLC · Valdosta, GABuilt 1972 · S/N 18261409N458WCSee Forever Holdings LLC · Wilmington, DEBuilt 2010 · S/N 18282235N4591UJacobsen Ian M · Lincoln City, ORBuilt 1964 · S/N 15060591N4592CKelley Stephen Mark · Kamiah, IDBuilt 1953 · S/N 25536N4593BSale Reported · Anchorage, AKSale reportedBuilt 1955 · S/N 31492N4593VFranklin Eric J · Anchorage, AKBuilt 1980 · S/N 172RG0330N4594CSt Johns Aviation LLC · Saint Johns, MIBuilt 1979 · S/N 21063569N4594ELingo Joshua B · Lake Village, ARBuilt 1979 · S/N 18503805N4594UMclendon Michael L · Whitesboro, TXBuilt 1964 · S/N 15060594N4595BBartusek Donald L Trustee · Columbia, MDBuilt 1955 · S/N 31494N4595CYoussefzadeh Salim · Pls Vrds Est, CABuilt 1953 · S/N 25539N4596BLow & Slow LLC · Columbus, OHBuilt 1955 · S/N 31495N4596FJaysix LLC · Greeley, COBuilt 1966 · S/N 185-1150N4596URustair Inc · Anchorage, AKBuilt 1979 · S/N U20604990N4597BPost William S · Custer, WABuilt 1955 · S/N 31496N4597CSutton Aircraft Salvage LLC · Palmer, AKS/N 25541N4597FWarden Richard L · Canby, ORBuilt 1966 · S/N 185-1151N4597RSanta Cruz Airplane LLC · Santa Cruz, CABuilt 1969 · S/N 15070525N4599BAgua Viva Ministries · Mebane, NCBuilt 1954 · S/N 614N4599CNovne Aviation Inc · Harrisburg, SDBuilt 1953 · S/N 25543N459CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 172S13270N459CCLemon James M · Billings, MTBuilt 1971 · S/N 18501916
Back to AD 79-10-14 R1