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.

N6185UMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10719N61861Pulley Richard A · Chugiak, AKBuilt 1981 · S/N 18504265N61866Wings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17264852N61868Jamm Aircraft LLC · Sterling, OHBuilt 1975 · S/N 17264854N6186BConnelly William L · Lovell, MES/N 34186N6186EHadley Ralph James Jr · Saint Clairsville, OHBuilt 1958 · S/N 46286N6186KSopalsky John J · Goshen, NYBuilt 1975 · S/N 15077577N6186TAtlas Aviation Tampa Inc · Tampa, FLBuilt 2008 · S/N 172S10729N6186VFloriflt LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10730N61870Dfu LLC · Boise, IDBuilt 1975 · S/N 17264856N61872Griffith William C III · Indianapolis, INBuilt 1975 · S/N 17264857N61873Umo Seneca LLC · Raleigh, NCBuilt 1975 · S/N 17264858N61874Erickson Kirk E · Lake Havasu City, AZS/N 18052809N61875Knight Aviation I LLC · Prescott, AZBuilt 1975 · S/N 17264860N61876Ferrara James L Jr · Wellington, NVBuilt 1975 · S/N 17264861N61877Harrison Jason J · Walla Walla, WABuilt 1977 · S/N 18052810N61878Tate John M · Boonton, NJBuilt 1975 · S/N 17264863N61879Lake Elmo Aero LLC · Lake Elmo, MNBuilt 1975 · S/N 17264864N6187EBasham James L · Livingston, TXS/N 46287N6187FNuxoll Builders · Clarkston, WABuilt 1968 · S/N 21059087N6187GMiller George Chris · Lone Oak, TXBuilt 1969 · S/N 15071687N6187JSky King Farmer LLC · Bentleyville, PABuilt 2008 · S/N 18282094N6187TGulfstream Design Associates Inc · Delray Beach, FLBuilt 1964 · S/N 15060887N6187YSilver Creek Aviation Services · Fort Worth, TXBuilt 2008 · S/N 20608309N61884Purfield Sara E · West Richland, WABuilt 1975 · S/N 17264866N61885Libby Stephen R Trustee · Anchorage, AKBuilt 1981 · S/N 18504269N61889Registration Pending · Dallas, PARegistration pendingBuilt 1975 · S/N 17264870N6188BSilver Creek Aviation Services · Fort Worth, TXBuilt 2008 · S/N 20608310N6188ECs Aircraft Services LLC · Jefferson, ORS/N 46288N6188FSky High Adventures LLC · Wilmington, DES/N A1500441N6188KLanning 2 Aviation LLC · Amarillo, TXBuilt 1975 · S/N 15077578N6188QSilver Creek Aviation Services · Fort Worth, TXBuilt 2008 · S/N 20608305N6188RPeterson Bruce L · Brighton, COBuilt 1966 · S/N T210-0088N6188USug-Air LLC · Corpus Christi, TXS/N 21064919N6188YLexington Enterprises Group Inc · San Jose, CABuilt 1981 · S/N 21064287N61890Stallion Leasing LLC · Louisville, KYBuilt 1975 · S/N 17264871N61891Higgins Jerome N · Oak Harbor, WABuilt 1975 · S/N 17264872N61892Loughridge Robert M III · Prattville, ALBuilt 1975 · S/N 17264873N6189ETrato Sharon M · Millington, MIFirst renewal noticeBuilt 1958 · S/N 46289N6189GBrule Alan R · Crookston, MNBuilt 1969 · S/N 15071689N6189QParamus Flying Club Inc · Fairfield, NJBuilt 2008 · S/N 172S10738N6189TBlack Archie C · Colton, CABuilt 1964 · S/N 15060889N618DHCorsair Aviation LLC · Pacoima, CABuilt 2012 · S/N 172S11186N618EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2018 · S/N 172S12164N618JMSkyknight LLC · Greeneville, TNBuilt 2012 · S/N 172S11164N618MKRegistered aircraftBuilt 1978 · S/N 18266388N618MNEack Kenneth B · White Rock, NMBuilt 1977 · S/N 172-69028N618TMTuskegee Airmen National Historical Museum · Detroit, MIBuilt 1979 · S/N 17273346N618VCRaevin Aviation LLC · Bellmore, NYBuilt 2004 · S/N 172S9716N618WWood Jim · Seminole, TXBuilt 1966 · S/N P206-0218
Back to AD 79-10-14 R1