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.

N84LMSchaefer Bernard C · Fairfield, TXBuilt 1979 · S/N 18267405N84LSBrenberger Mark L · Raleigh, NCBuilt 1976 · S/N 18264741N84MCOn-Site Mech LLC · Helena, MTS/N 21064955N84RJM & G Aircraft Management LLC · Aurora, ORBuilt 2023 · S/N 172S13061N84SHAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13266N84SJLabelle Gregory D Trustee · Newbury Park, CABuilt 1984 · S/N 21064867N84TMRealm Group Transport Inc · Las Vegas, NVBuilt 1978 · S/N 18503702N84USMcginty Flying Service LLC · Jones, LAS/N 18052942N8500GAugust Mark C · Atchison, KSBuilt 1965 · S/N 15062600N8500JRiley Alfred E III · Norristown, PABuilt 1967 · S/N 15066400N8500TWhite Taylor D · Gainesville, GAS/N 52400N8501KStephenson Joe D Jr · Sand Springs, OKS/N 17250723N8501SWitschger Scott L · Albuquerque, NMBuilt 1965 · S/N 18256601N8501UOverbaugh Gary R · Highland, UTBuilt 1964 · S/N 17252401N8502BSims Hollow M · Lithonia, GABuilt 1957 · S/N 36202N8502USmitty 172 LLC · Rockford, MIBuilt 1964 · S/N 17252402N8503GPynn David W · Gasport, NYBuilt 1965 · S/N 15062603N8503SCub Club Inc · Toddville, IABuilt 1965 · S/N 18256603N8503TKolb Bryan C · Hutto, TXBuilt 1959 · S/N 52403N8503UCropley Alton I · Sitka, AKS/N 15077941N8504UDoug & Holly Harmon Inc · Fremont, MIBuilt 1964 · S/N 17252404N8505BGreen James S · Slaton, TXS/N 36205N8505JKunz Isaac A · Texarkana, TXBuilt 1967 · S/N 15066405N8505SAir Repair Inc · Cleveland, MSBuilt 1965 · S/N 18256605N8505USilverman Phillip E Trustee · Fullerton, CABuilt 1964 · S/N 17252405N8505XBerri Edward W Jr · N Fort Myers, FLBuilt 1962 · S/N 17557105N8506BTierney Garrett J · Manorville, NYBuilt 1957 · S/N 36206N8506GNighthawk Air Systems Inc · Miami, FLS/N 15062606N8506JHorning Richard H · Galion, OHS/N 15066406N8506QBell Robert C · Colby, KSS/N U20603363N8506TM & C Aviation LLC · Corinth, TXBuilt 1959 · S/N 52406N8506XBugli Zachary J · Stevensville, MTS/N 17557106N85074Patriot Pole Aviation LLC · Missouri Valley, IABuilt 1975 · S/N 18263614N8507GCaldera Michael E · Williamsport, PABuilt 1965 · S/N 15062607N8508BCc Motors LLC · Redding, CABuilt 1957 · S/N 36208N8508JJanssen Willis W · Ault, COBuilt 1967 · S/N 15066408N8508S8508s LLC · Yerington, NVBuilt 1965 · S/N 18256608N8508TLily Gold LLC · Wilmington, DEBuilt 1959 · S/N 52408N8508UEspinosa Isaac · Kissimmee, FLBuilt 1964 · S/N 17252408N8509BLafleur Joel A · Garden Valley, IDBuilt 1957 · S/N 36209N8509GVictory Family Church Of Decatur Tx Inc · Decatur, TXBuilt 1965 · S/N 15062609N850DRMooers Michael T · Haggerstown, MDBuilt 1977 · S/N 15079358N850FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10376N850MGHuston Joe L · Wasilla, AKBuilt 1966 · S/N 1851085N850SPAviolease LLC · Vancouver, WABuilt 2001 · S/N 172S8758N850WBMorris John A · Phoenix, AZBuilt 1968 · S/N 185-1350N850YDudley Benjamin H · Wasilla, AKBuilt 1964 · S/N 17251784N8510SBarton Andrew · Morehead City, NCBuilt 1965 · S/N 18256610N8510UTds Property Holdings LLC · Gilmer, TXBuilt 1964 · S/N 17252410N8511TAcute Holdings LLC · Jenks, OKBuilt 1960 · S/N 52411
Back to AD 79-10-14 R1