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.

N6568MDickson Joshua · Frankfort, MEBuilt 1975 · S/N 18263759N6568RJofredo Corp · Zephyrhills, FLBuilt 1979 · S/N 172RG0202N6568SBell Daniel M · Mc Alpin, FLFirst renewal noticeBuilt 1967 · S/N 15067368N6568TElf Aviation LLC · Franklin, TNS/N 17968N6568XBarnes Inc · Lewiston, IDBuilt 1980 · S/N U20605950N65690690 LLC · Carmel, INBuilt 1982 · S/N 17275820N65697Kemp Alan R · Niobrara, NEBuilt 1982 · S/N 17275821N65698Angel Aviation Inc · Peoria, AZBuilt 1982 · S/N 17275822N6569ABallard Scott K · Collierville, TNBuilt 1956 · S/N 32466N6569FWise Joe · Kilgore, TXBuilt 1966 · S/N 15063169N6569MBrown George P III · Houston, TXBuilt 1975 · S/N 18263760N6569SSawicki Victor · Columbus, MIBuilt 1967 · S/N 15067369N656CBUniversity Of Central Missouri · Warrensburg, MOBuilt 2022 · S/N 172S12800N656CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281656N656DMKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 17270327N656EMAxis Electric Inc · Albany, ORBuilt 1975 · S/N 18263945N656EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12454N656FCFlorida Department Of Agriculture & Consumer Svcs · Tallahassee, FLBuilt 2017 · S/N 18283008N656MAWings Over Texas Holdings LLC · Denton, TXS/N 17280924N656MCMcintosh Justin W · Joshua, TXBuilt 1978 · S/N 21063111N656MFMelbourne Flight Training LLC · Melbourne, FLBuilt 1982 · S/N 17275818N656SFSkyfusion II LLC · Atlanta, GAFirst renewal noticeS/N 17271302N656SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8061N656TSN656ts LLC · Stuart, FLS/N 17275808N65704Skywarrior Flight Training Inc · Pensacola, FLBuilt 1982 · S/N 17275824N65709Maverick Jet Leasing Corp · Wilmington, DEBuilt 1982 · S/N 17275827N6570AKunz Ethan · Ashland, ORBuilt 1956 · S/N 32467N6570FMykland Bennett · Graham, WABuilt 1966 · S/N 15063170N6570HBritten Air LLC · Natchitoches, LABuilt 1975 · S/N 17265492N6570MJones Brandon · Steele, MOBuilt 1975 · S/N 18263761N6570SAnderson Christopher D · Newark, OHBuilt 1967 · S/N 15067370N65710Beach Cities Aviation Academy LLC · Hawthorne, CABuilt 1982 · S/N 17275828N65716Rtd Aviation LLC · Hillsborough, NJBuilt 1982 · S/N 17275831N6571DBlazing Sun Aviation LLC · Encinitas, CABuilt 1979 · S/N 17272871N6571ELersner Bradley D · Katy, TXBuilt 1959 · S/N 56071N6571HHentges Dave · Canby, MNBuilt 1975 · S/N 17265493N6571TJohnson Bryan K · Lafayette, LABuilt 1960 · S/N 17971N65722Red River Aviation Services LLC · Altus, OKBuilt 1982 · S/N 17275835N65724Registration Pending · Kalispell, MTRegistration pendingS/N 17275836N65729Nevrdul LLC · Cambridge, MDBuilt 2005 · S/N 172S9791N6572DWalkowicz Eddie · Garland, TXBuilt 1979 · S/N 17272872N6572EKadlecik John Keith · Boise, IDBuilt 1959 · S/N 56072N6572GAero Equities LLC · Ventura, CABuilt 1970 · S/N 15072072N6572SGlatt Nicolas · Mazama, WABuilt 1967 · S/N 15067372N6572YMoss G B · Bakersfield, CABuilt 1981 · S/N 21064444N65730Chuchuca Espinoza Jorge A · Clifton, NJS/N 17275840N65735Bredvold Daniel M · Mendota Heights, MNS/N 17275842N65738Mc Collom Perry C · Saint Louis, MOBuilt 2004 · S/N 172S9746N6573DPeabody Jeffery L · Vinemont, ALBuilt 1979 · S/N 17272873N65741Flycarolina LLC · Charlotte, NCBuilt 1982 · S/N 17275846
Back to AD 79-10-14 R1