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.

N58964Likens Tony G · Longville, MNBuilt 1973 · S/N 18262432N58967Whatsup LLC · Mccomb, MSBuilt 1973 · S/N 18262435N5896AFox Black Enterprises Inc · Kilmarnock, VABuilt 1956 · S/N 28496N5896EKyle James H · Snohomish, WABuilt 1959 · S/N 17396N5896GYtsera Air Fred LLC · Lyndonville, VTBuilt 1969 · S/N 15071396N5896RRegistration Pending · Florence, MSRegistration pendingBuilt 1965 · S/N 17253565N58976Pennington Tony D · Corpus Christi, TXBuilt 1973 · S/N 18262439N5897CGot Wings LLC · Woodbury, NYBuilt 1973 · S/N 18262437N58981Skloss Anthony W · Edinburg, TXBuilt 1973 · S/N 18262441N58989Texas Wings In The Air II LLC · Santa Teresa, NMBuilt 1973 · S/N 18262442N5898GIsaza Alvaro · Westminster, MDBuilt 1969 · S/N 15071398N58994Aviation Trust Co LLC Trustee · Oklahoma City, OKS/N 18262444N58998Coach Aviation LLC · Dover, DES/N 18262446N58999United Indian Missions DBA · Tucson, AZBuilt 1973 · S/N 18262447N5899BRi Skydiving Aircraft LLC · Middletown, RIBuilt 1956 · S/N 33899N5899RParrish Aviation Flight Academy LLC · Dallas, TXS/N 17253568N5899TBrignac Flying Service LLC · Columbus, MSBuilt 1965 · S/N 1850799N589JSWings West Consulting LLC · Mesa, AZBuilt 1980 · S/N U20606384N589RRock & Roe LLC · Corpus Christi, TXBuilt 1975 · S/N 18264115N589SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2000 · S/N 172S8519N58BWarnick Ronald S · Cascade, MTBuilt 1968 · S/N 15068409N58BDBravan Aviation Inc · Fort Lauderdale, FLS/N 21062742N58CSierra 1 Tech Inc · Blue Jay, CABuilt 1973 · S/N P3370102N58CR7192 Locke Road LLC · Millington, TNBuilt 2005 · S/N 18281544N58DJPtc Financial Inc · Wilmington, DEFirst renewal noticeBuilt 1980 · S/N 21063920N58DSBalliet Edgar J III · Northampton, PABuilt 1979 · S/N 17272305N58DWWilson Daniel J · Mount Vernon, OHBuilt 1979 · S/N 18267139N58FAAlman Michael C · Fruitport, MIBuilt 1958 · S/N 55255N58FFWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 172S12928N58JKWander Aviation LLC · Klamath Falls, ORBuilt 1982 · S/N 18268286N58MARagan Edwin E III · Austin, TXBuilt 1977 · S/N 21062237N58MGMullins Tennis Jr · Chapmanville, WVBuilt 1973 · S/N 18262358N58RRClover Management Systems Inc · Sanford, FLBuilt 1980 · S/N 18267545N58SDBrusasco John Mario Trustee · Portland, ORBuilt 1958 · S/N 50167N58TTBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 21062998N58TYJohnson Jake M · Texarkana, TXBuilt 1977 · S/N 17270111N58WKern Aviation LLC · Shafter, CABuilt 1960 · S/N 15059094N59007Hang On LLC · Montrose, COBuilt 1973 · S/N 21060014N59008Davis Burton D · Jefferson, IABuilt 1973 · S/N 21060015N5900AOlsen Porteous E · Houston, MNBuilt 1956 · S/N 28500N5900BEnvi Adventures LLC · Troutdale, ORS/N 33900N5900EGreene Charles A · Easley, SCBuilt 1959 · S/N 17400N5900JAir America LLC · Sioux Falls, SDS/N A1500200N5900MBucher Burton W · North Chicago, ILBuilt 1956 · S/N 32330N5900RAidan Hammond · Ione, CABuilt 1965 · S/N 17253569N59011Nelson Albert N III · Baytown, TXBuilt 1973 · S/N 21060018N5901ACoulson Michael D · Zanesville, OHBuilt 1956 · S/N 28501N5901TWilliams Terry A · Hazlehurst, GABuilt 1964 · S/N 15060601N5902ASmith Kenneth W · Bedford, INBuilt 1956 · S/N 28502N5902FPeters Kenneth R · Plainfield, ILBuilt 1967 · S/N 21058902
Back to AD 79-10-14 R1