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.

N5793ELowe David M · Sacramento, KYBuilt 1959 · S/N 17293N5793RRogers Jesse E · La Belle, MOBuilt 1965 · S/N 17253462N5793TJefferson County Public Schools · Louisville, KYBuilt 1964 · S/N 17251693N5794APerkins Larry L · Wildomar, CAFirst renewal noticeBuilt 1956 · S/N 28394N5794RMacfarland Donald C · North Tonawanda, NYBuilt 1965 · S/N 17253463N5794TGodfrey Kenneth E · Oroville, CABuilt 1964 · S/N 17251694N5795BJst Management LLC · Zephyrhills, FLFirst renewal noticeBuilt 1956 · S/N 33795N5795CHancock James T · South Saint Paul, MNBuilt 1950 · S/N 19839N5795ERose Walter W · Arena, WIBuilt 1959 · S/N 17295N5795GRhodes Tom B · Dallas, TXBuilt 1969 · S/N 15071295N5796CJohnson Terry A · Idaho Falls, IDBuilt 1950 · S/N 19750N5796JRegistered aircraftBuilt 1971 · S/N 21059496N57977Denney Dennis · New Port Richey, FLBuilt 1976 · S/N 21061475N5797AEver Fast LLC · Kalispell, MTS/N 28397N5797CNorris Terry F · Rockford, ILBuilt 1950 · S/N 19751N5797FWright James J · Owens Cross Roads, ALBuilt 1973 · S/N 18261914N5797JLindsay Properties LLC · Kosciusko, MSBuilt 1975 · S/N 18263543N5797RRiggs Laura A · Middleburg, FLBuilt 1965 · S/N 17253466N5798ABowman Ronald J · Bellefonte, PABuilt 1956 · S/N 28398N5798EPineapple Flyers Inc · Rockville, MDBuilt 1959 · S/N 17298N5798RRatcliff Bruce A · Plain City, OHBuilt 1965 · S/N 17253467N5799AMiller Lavon S · Eureka, NVS/N 28399N5799CLewellen Donnie J · Friona, TXBuilt 1950 · S/N 19753N5799GBafa LLC · Lewes, DEBuilt 1969 · S/N 15071299N5799JBritt Demolition And Recycling Inc · Hanceville, ALBuilt 1971 · S/N 21059499N5799TGs Air LLC · Sioux Falls, SDS/N 17251699N579BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280944N579CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283101N579ER22 H20 LLC · Montgomery, TXBuilt 2005 · S/N 18281599N579JDForst Kenneth D DBA · Grand Rapids, MNBuilt 1980 · S/N 18503964N579JKKopacz Thomas H · Glen Flora, WIBuilt 1973 · S/N 17261765N579KRed Plane Aviation LLC · Key West, FLBuilt 1960 · S/N 17247827N579MAJones Andrew W · Turner, MTBuilt 1967 · S/N 15068081N579WGTrede 2021 C172 LLC · Aurora, ORBuilt 2021 · S/N 172S12752N57BMHuerta Holdings Inc · Santa Ana, CABuilt 1973 · S/N 17261980N57BRRamsey Brent C · Tulsa, OKBuilt 1979 · S/N 18267277N57CCavu Aviation LLC · Tulsa, OKBuilt 1973 · S/N P3370091N57CABlue Sky Management LLC · Stevens Point, WIBuilt 1975 · S/N 18502698N57CSSparkjoy Backcountry LLC · Boulder, COBuilt 2025 · S/N 18283295N57DLGarrett Gary M · Reno, NVBuilt 1978 · S/N 18266366N57EAEwing Andrew M · Santa Rosa Beach, FLBuilt 1977 · S/N 177RG1169N57FASilver Express Co DBA · Miami, FLBuilt 1997 · S/N 17280225N57FFWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 172S12927N57HKell Thomas G · Anchorage, AKBuilt 1958 · S/N 50286N57MJFrederick Bradley W · Corvallis, ORFirst renewal noticeBuilt 1969 · S/N 18259651N57MTYee Michael P · Missouri City, TXS/N 21058133N57MWFogal Brian K · Chambersburg, PABuilt 1957 · S/N 29688N57PHEldredge Bradley P · Highland, UTS/N 18265514N57UDAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12089N57VBKlingebiel Kurt · Leonardtown, MDBuilt 1985 · S/N 17276476
Back to AD 79-10-14 R1