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.

N6473DTurner Glenn · West Melbourne, FLS/N 17272822N6473SUlman Gary T Trustee · Mountain Iron, MNBuilt 1967 · S/N 15067273N6474FDodd Michelle J · Riverton, KSBuilt 1966 · S/N 15063074N6474KDavis Thomas Aviation Group LLC · Saint Martinville, LABuilt 1975 · S/N 15077718N6474XMay Jeremy A · Norco, CABuilt 1961 · S/N 18050974N64754Aerofeather Aviation Inc · Suffolk, VABuilt 1982 · S/N 17275617N6475DDarcy Aviation LLC · Danbury, CTBuilt 1979 · S/N 17272823N6475XTwin Oaks Aircraft Maintenance LLC · Hillsboro, ORBuilt 1961 · S/N 18050975N6476FKnowles Brian Thomas · Windsor, NCBuilt 1966 · S/N 15063076N6476GChupito Sabrocito LLC · Paso Robles, CABuilt 1979 · S/N 17273601N64776Christiansen Aviation LLC · Wilmington, DEBuilt 1982 · S/N 17275621N6477CRains David O · El Paso, TXS/N 19304N6477ELoutzenhiser Mark · Wasilla, AKBuilt 1959 · S/N 46577N6477HTurbines Ltd · West Point, NES/N 20700537N6477SJuhl Aviation LLC · Luverne, MNS/N 15067277N64786Magee Wayland G · Bennington, NEBuilt 1961 · S/N 17557075N6478BKuhfahl Matthew J · San Antonio, TXBuilt 1957 · S/N 29678N6478DBrezovich Ivan A · Birmingham, ALBuilt 1979 · S/N 17272826N6478TBasic Daniel J · Mulberry, FLBuilt 1960 · S/N 17878N64791Tfa Aircraft Holding Corp · Daytona Beach, FLBuilt 1982 · S/N 17275624N64792Air Sal Leasing Inc · Fort Myers, FLS/N 17275625N6479EThomas Alan R · Wickenberg, AZBuilt 1959 · S/N 46579N6479FFurick Robert P · Woodinville, WABuilt 1975 · S/N 18264200N6479GGibbons Asher · Mobile, ALBuilt 1970 · S/N 15071979N6479KHall Charles R · Greenbrier, ARBuilt 1975 · S/N 15077722N6479NSouth Aero LLC · Albuquerque, NMBuilt 1978 · S/N 21063053N6479TDrury Isaac W · Milton, FLBuilt 1960 · S/N 17879N6479XSutton Aircraft Salvage LLC · Palmer, AKBuilt 1961 · S/N 18050979N6479YGv Air Inc · Medford, ORBuilt 1981 · S/N 21064399N647CRChristiansen Aviation LLC · Wilmington, DEBuilt 2015 · S/N 172S11613N647CSTextron Aviation Inc · Wichita, KSS/N 172S13647N647MTArbo Elijah B · Mount Chase, MEBuilt 1970 · S/N 17259158N647SBHyde Matthew L · Santa Cruz, CABuilt 1982 · S/N 21064743N647SPElizabeth City State University · Elizabeth City, NCBuilt 1998 · S/N 172S8054N647THChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12647N6480BCrowe Manoah R · Del Valle, TXFirst renewal noticeBuilt 1957 · S/N 29680N6480DFlyright Aviation LLC · North Las Vegas, NVBuilt 1979 · S/N 17272828N6480FHaithcock Stephen · Oxnard, CABuilt 1966 · S/N 15063080N6480GLloyd Trent E · Central Valley, UTBuilt 1970 · S/N 15071980N6480SKline James R · Kokomo, INBuilt 1967 · S/N 15067280N64814Propel Air LLC · Pottstown, PABuilt 1982 · S/N 17275630N64815Channel Islands Aviation Inc · Camarillo, CABuilt 1982 · S/N 17275631N6481BMorse Cory L · Montville, MEBuilt 1957 · S/N 29681N6481FWood James N · Samson, ALBuilt 1966 · S/N 15063081N6481JCape Flight Instruction Inc · Cotuit, MABuilt 1980 · S/N 17273876N6482AMoreman Wiley E · Willcox, AZBuilt 1956 · S/N 33282N6482BMendoza Victor · Liberal, KSS/N 29682N6482EIreland Kel · Fredericksburg, TXBuilt 1959 · S/N 46582N6482KKimmel Timothy I · San Angelo, TXS/N 15077723N6482NBoerboon Jeffrey T · Cave Creek, AZBuilt 1981 · S/N 18504311
Back to AD 79-10-14 R1