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.

N8077LAndrews Carson D · Hartsville, SCBuilt 1967 · S/N 17256277N8077SRebecca Grace LLC · Riesel, TXBuilt 1965 · S/N 15061677N80781P D H S Aerial Photography Inc · Spicewood, TXBuilt 1976 · S/N 17266745N80784Stamm David A · Lake Almanor, CAS/N 17266747N80788Bell Aa Flying Club Inc · Mechanicsburg, PABuilt 1976 · S/N 17266748N8078ALeonard Willis Thomas · Vacaville, CABuilt 1952 · S/N 20930N8078BShareair LLC · Columbiaville, MIS/N 29878N8078G615dm LLC · Hazel Green, ALBuilt 1971 · S/N 177RG0078N8078LSale Reported · HawkestoneSale reportedBuilt 1967 · S/N 17256278N8078SBazemore Kelley R · Ingleside, TXS/N 15061678N8078TWise James K · Billings, MTBuilt 1960 · S/N 17556778N80790Wingsleasing LLC · Wichita, KSBuilt 1976 · S/N 17266749N80797Neitz Frank · Bethel, AKS/N 17266750N80798Thomas Dean Properties LLC · O Fallon, MOBuilt 1976 · S/N 17266751N8079ARegistered aircraftBuilt 1952 · S/N 20931N8079FRegent Aero LLC · Kingsland, GAS/N 15064179N8079GBoney Grady · Rhine, GABuilt 1973 · S/N 18801227TN8079LHurricane Joaquin LLC · Umatilla, FLS/N 17256279N8079TSwannack Peter Jay · Lamont, WABuilt 1960 · S/N 17556779N807CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12629N807EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13181N807HDTubbs Jerry M · Manns Harbor, NCBuilt 1976 · S/N 17266730N807KSKansas State University Salina · Salina, KSBuilt 1969 · S/N 15071287N807PAAnson Air LLC · Sugar Land, TXBuilt 2005 · S/N 172S9953N807SPCawthon James B · Chelsea, ALBuilt 1999 · S/N 172S8111N807VROrton Thomas L · Clifford, MIBuilt 2007 · S/N 18281926N807WCEt Fly Home LLC · Auburn, ALBuilt 1977 · S/N 21061775N807XMrair LLC · Lewes, DEBuilt 1961 · S/N 18253207N80800West Bend Air Inc · West Bend, WIBuilt 1976 · S/N 17266752N80803Bradley Charles S · East Bethel, MNS/N 17266754N80807Wings Over Texas Holdings LLC · Denton, TXS/N 17266755N8080BNeton Inc · Bradenton, FLBuilt 1957 · S/N 29880N8080THigh Mesa Aviation LLC · Naturita, COBuilt 1960 · S/N 17556780N8080VTri Rotor Spray & Chemical · Ulysses, KSBuilt 1968 · S/N 188-0330N8080XWard B J · Hewitt, NJBuilt 1961 · S/N 17248580N80810White Hawk Aviation Inc · Brandy Station, VABuilt 1976 · S/N 17266757N80816Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1976 · S/N 17266760N8081ACorn Michael Lee · Wilmington, NCBuilt 1952 · S/N 20933N8081EFlying Horseman Ranch LLC · Stuart, VABuilt 1974 · S/N 18502329N8081LAerowood Aviation LLC · Monroe, NCBuilt 1967 · S/N 17256281N8081TSproul Andrew W · Isabella, OKBuilt 1960 · S/N 17556781N8081VStorm Flying Service LLC · David City, NEBuilt 1968 · S/N 188-0331N8081XHibdon Robert R · Jefferson City, MOBuilt 1967 · S/N 18258166N8082EAviation Access LLC · Van Nuys, CABuilt 1978 · S/N 17272135N8082LBurns Jeremiah W · Westerville, OHS/N 17256282N8082MKeenan Thomas E Jr · Smyrna, DES/N 15072542N8082TStrahm Jennifer · Edgerton, KSBuilt 1960 · S/N 17556782N8082XNewman Joseph N · Springfield, MIBuilt 1961 · S/N 17248582N80830Mahnattan Flying Tigers Inc · Bozeman, MTBuilt 1976 · S/N 17266764N80837Lucky Richard E · Skipperville, ALBuilt 1976 · S/N 17266767
Back to AD 79-10-14 R1