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.

N5171VLisenbey Edward · Caldwell, IDS/N 21060846N5172ABarnes Timothy Edward · Stephenville, TXBuilt 1955 · S/N 28172N5172HMsi Fuel Management Inc · Vacaville, CABuilt 1975 · S/N 17265359N5172RWaterhouse Roy Todd · Mccall, IDBuilt 1976 · S/N 18503012N5172WOcala Aviation Services Inc · Ocala, FLBuilt 2002 · S/N 172S9043N51732Imsar LLC · Springville, UTBuilt 2002 · S/N 18281088N5173ERyznar Daniel J · Anchorage, AKBuilt 1959 · S/N 50473N5173UKnutson Wayne R · Tioga, NDBuilt 1964 · S/N 206-0173N5173VEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 172S9046N51748Planenutz LLC · Deland, FLBuilt 1980 · S/N 17274342N5174AWells Lavar W · Hanksville, UTBuilt 1956 · S/N 28174N5174EBlue Sky Pilots Inc · Salem, ORBuilt 1978 · S/N 17271752N5174HFlying Finn Enterprises LLC · Wilmington, DEBuilt 1975 · S/N 17265360N5175ADenkema Richard S · Grand Rapids, MIBuilt 1955 · S/N 28175N5175EWinston Jacob · Granbury, TXBuilt 1978 · S/N 17271753N5175NArkansas Bolt Co · Little Rock, ARBuilt 1980 · S/N 18267560N5175PSbkr LLC · Greenville, PABuilt 2002 · S/N 18281155N5175YLutz Aviation LLC · Perkinsville, VTBuilt 2002 · S/N 172S9050N5176EAirplane Money Pit LLC · Rexburg, IDBuilt 1982 · S/N 18268296N5176RRight Rudder Flight Training LLC · La Verne, CABuilt 1979 · S/N 172RG0044N5176VVangorder Donna · Greenwood, ARS/N 172RG0459N5177AHolden Daniel N · Anacortes, WAS/N 28177N5177DCross Richard G · Brewster, MNBuilt 1958 · S/N 51277N5177EAbraham Edward C · Canadian, TXBuilt 1959 · S/N 50477N5177HPomeroy Cattle Ranch LLC · Kalispell, MTBuilt 1975 · S/N 17265361N5177NMacelvaine William Stephen · Morro Bay, CABuilt 1980 · S/N 18267561N51782Ranger Lumber Corp · Springfield, MABuilt 2002 · S/N 18281096N51784Winingar Thomas M · Brock, TXBuilt 2002 · S/N 18281097N51785Photos Unlimited · Rancho Cordova, CABuilt 2002 · S/N 18281098N5178EHughes Kenneth L Jr · Wasilla, AKBuilt 1959 · S/N 50478N5178FTurrentine Danny H · Wolfe City, TXBuilt 1965 · S/N 17253100N5178RHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17263395N5178SG & M Aircraft Inc · Wheat Ridge, COBuilt 2002 · S/N 17281097N5178USoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281098N5178YSoutheastern Oklahoma State University · Durant, OKS/N 17281099N51793Lindsey Richard A · Richmond, TXBuilt 1980 · S/N 17274347N51794Christiansen Aviation LLC · Wilmington, DES/N 17274348N5179DBlack Daniel L · Spicewood, TXBuilt 1958 · S/N 51279N5179HFlight Time Builders Inc · Memphis, TNBuilt 1975 · S/N 17265362N5179UPower Flight LLC · Las Vegas, NVBuilt 1964 · S/N 206-0179N5179VFairmont State University · Fairmont, WVBuilt 1980 · S/N 172RG0460N517CAFisher Richard L Jr · Saint Helens, ORS/N 17268100N517DBBerry Bruce E · Louisville, TNBuilt 1977 · S/N 18266021N517DLDelta Leema Aviation LLC · Moncks Corner, SCBuilt 1977 · S/N 17268965N517MAKilo Charlie Aeronautics LLC · Baton Rouge, LABuilt 2017 · S/N 18283007N517NDSunrise Aviation Inc · Ormond Beach, FLS/N 172S10787N517PCAfrican Bible Colleges Inc · Karval, COBuilt 1973 · S/N 18261628N517RANason David F · Kent, WABuilt 1961 · S/N 15059375N517SAHalo For Freedom Warrior Foundation · Willow Park, TXBuilt 1966 · S/N U206-0644N517SMMcelvain Pete R · Iowa Park, TXBuilt 1968 · S/N 17257318
Back to AD 79-10-14 R1