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.

N4552CMckinney Lodging Management LLC · Trout Lake, WABuilt 1952 · S/N 25496N45530Young Thomas E Jr · Alton, MOBuilt 1975 · S/N 15076962N4553SMinion Air Inc · John Day, ORBuilt 1968 · S/N 18259182N4553UCoyle Jonathan D · Franktown, COBuilt 1964 · S/N 15060553N45541Zxtair LLC · Mankato, MNFirst renewal noticeBuilt 1975 · S/N 15076966N45542Baldridge Steven J · Edmonds, WAS/N 15076967N4554FFejes Jacob J · Watertown, NYS/N 185-1057N4555CVan Roo Jon D · Hartland, WIBuilt 1953 · S/N 25499N45560Johnson Adam · Denton, TXBuilt 1975 · S/N 15076971N45563Tremer Jesse · Kathleen, GABuilt 1975 · S/N 15076972N45566Watts Charles B IV · Pace, FLBuilt 1975 · S/N 15076973N45570San Mateo Flying Club Inc · Palo Alto, CAS/N 15076974N4557FKincaid Jonathan A · Frankfort, MEBuilt 1966 · S/N 185-1061N4557UCrum Thomas A · Loyal, OKBuilt 1964 · S/N 15060557N45582Burch Jacqueline L · Aguanga, CABuilt 1975 · S/N 15076980N45586Rak Aviation LLC · Everett, WABuilt 1975 · S/N 15076982N45588Dahlonega Mountain Flyers Inc · Dahlonega, GABuilt 1975 · S/N 15076983N4558BDe Ley Taylor · Yorba Linda, CABuilt 1955 · S/N 31457N4558CFarrell Raymond E · Monument, COBuilt 1953 · S/N 25502N4558FN4558f LLC · Columbus, OHBuilt 1966 · S/N 185-1062N4559UBoyd Jeffrey S · Hutsonville, ILBuilt 1964 · S/N 15060559N455AFGlacier Bay Aviation LLC · Fayetteville, GABuilt 1968 · S/N 17701336N455AKBarr Scott A · Barrow, AKS/N 18260061N455CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282196N455EDTurner James Glenn · Naples, FLBuilt 1962 · S/N 21058118N455EPDove Aviation 455ep LLC · Stuart, FLBuilt 1998 · S/N 17280664N455HSSagnieres Hubert · Newport, VTBuilt 2001 · S/N 18281054N455WCHayes William F · Perrysburg, OHBuilt 1969 · S/N 337-1191N45601Three Four Juliet LLC · Orange, CABuilt 1975 · S/N 15076986N45613Devanani Vishnu D · Orlando, FLS/N 15076988N45614Gard Lionel V III · Camp Wood, TXBuilt 1975 · S/N 15076989N45617Schumaker Grant E · Wichita, KSBuilt 1975 · S/N 15076991N4561VOrca Wealth Management LLC · New Port Richey, FLBuilt 1976 · S/N U20603052N45623Prosperous Holdings LLC · Gainesville, GABuilt 1975 · S/N 15076994N45626Creamer James P · Lakeland, FLBuilt 1975 · S/N 15076997N4562FMcdaniel Dean K · Queen Creek, AZS/N 185-1069N45632Marble Jere D · Dayton, NVBuilt 1975 · S/N 15076998N45636Carolina Tripacers LLC · Summerville, SCBuilt 1975 · S/N 15076999N4563BLarose Gary R · Anchorage, AKS/N 31462N4563CBrown Peter D · Anchorage, AKBuilt 1953 · S/N 25507N4563UBailey Wesley S · Bulverde, TXBuilt 1964 · S/N 15060563N4563WE&V Air LLC · Chatsworth, GABuilt 1973 · S/N 18262363N45649Cygan Fred P · Hudson, MABuilt 1975 · S/N 15077006N4564CMountain Todd Lee · Byron, MIBuilt 1953 · S/N 25508N45659Mcallister Christopher E · Phoenix, AZBuilt 1975 · S/N 15077011N45662Turnberry Air LLC · Oviedo, FLBuilt 1975 · S/N 15077012N45663Williams Kaylee A · Grapevine, TXBuilt 1975 · S/N 15077013N4566BWagnon Bertram L · Anchorage, AKS/N 31465N4566UGruver Norval T · Bartlesville, OKBuilt 1964 · S/N 15060566N45673Theimer Ryan D · West Bend, WIS/N 15077015
Back to AD 79-10-14 R1