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.

N758FWLarsen Don A · Kenosha, WIBuilt 1978 · S/N R1723070N758FZWright Base Flight Training LLC · Tullahoma, TNBuilt 1978 · S/N R1723073N758GBDaystar Aviation LLC · Eugene, ORBuilt 1978 · S/N R1723075N758GCAndrews Ralph M · Jacksonville, FLBuilt 1978 · S/N R1723076N758GFInflyt LLC · Carlsbad, CABuilt 1979 · S/N R1723079N758HARegistration Pending · Jacksonville, ARRegistration pendingS/N R1723098N758HCCentral Air Parts Inc · Staunton, ILBuilt 1979 · S/N R1723100N758HKAir Pierre LLC · Orlando, FLBuilt 1979 · S/N R1723107N758HLCunningham Robert F · Gibraltar, MIBuilt 1979 · S/N R1723108N758HMBwg Hanger LLC · Los Angeles, CABuilt 1979 · S/N R1723109N758HSEdge Of The World Inc · Banner Elk, NCBuilt 1979 · S/N R1723114N758HTStinnett Raymond C · Bozeman, MTBuilt 1979 · S/N R1723115N758HVLozoya Luis G · Yuma, AZBuilt 1979 · S/N R1723117N758JBYuen Kin Chun · Elk Grove, CABuilt 1979 · S/N R1723123N758JDHancock Gregory C · Eastsound, WABuilt 1979 · S/N R1723125N758JGMorton Frank W · Harwinton, CTBuilt 1979 · S/N R1723128N758JRTownsend Robert J · Leavenworth, WABuilt 1979 · S/N R1723137N758JSHenderson Scott · Tucson, AZBuilt 1979 · S/N R1723138N758JTEdwards Thomas G Trustee · Jacksonville, ORBuilt 1979 · S/N R1723139N758JZReaka Dean James Trustee · Troy, MOBuilt 1979 · S/N R1723145N758KCMccormick Robert C · Vlg Of Lakewd, ILBuilt 1979 · S/N R1723148N758KFMorgan Kenneth J · Norridgewock, MEBuilt 1979 · S/N R1723151N758KMStrong Janet L · Vancouver, WABuilt 1979 · S/N R1723157N758KRKairys Steven A · Encino, CABuilt 1979 · S/N R1723161N758KVAk Denali Group LLC · Anchorage, AKBuilt 1979 · S/N R1723165N758LCDepino Damian P · Dummerston, VTBuilt 1979 · S/N R1723172N758LEBernheim Karen M · Sisters, ORBuilt 1979 · S/N R1723174N758LJPeery William R · Beckley, WVBuilt 1979 · S/N R1723178N758LMSwenson Karine · Anchorage, AKBuilt 1979 · S/N R1723181N758LNLittle 8 Mile Ranch LLC · Missoula, MTBuilt 1979 · S/N R1723182N758LPTony Joe Aviation LLC · Sheridan, WYBuilt 1979 · S/N R1723183N758LRWood Tyler J · Creston, CABuilt 1979 · S/N R1723185N758LSKomizo Enterprises LLC · Fort Worth, TXS/N R1723186N758LWTeton Leasing LLC · Pocatello, IDBuilt 1979 · S/N R1723190N758LYDixon Craig S · Rimrock, AZBuilt 1979 · S/N R1723192N758MHFantasy Flyer LLC · Ojai, CABuilt 1979 · S/N R1723201N758MLStrong Ronald E · Phoenix, AZS/N R1723204N758MNTritt Scott W · Bolivar, OHBuilt 1979 · S/N R1723206N758MPPickle Brad R · Pottsboro, TXBuilt 1979 · S/N R1723207N758MQSarkissian Hovannes · Pasadena, CABuilt 1979 · S/N R1723208N758MSRegistered aircraftBuilt 1979 · S/N R1723210N758MTTurbine Financial Group LLC · Ogden, UTBuilt 1979 · S/N R1723211N758MVCarson Flying Feeders LLC · Carson, IABuilt 1979 · S/N R1723213N758MWHaddock Debra E · Shelby, NCBuilt 1979 · S/N R1723214N758MYMcclellan Steven D · Blackfoot, IDBuilt 1979 · S/N R1723216N758MZMowry Valetta J · Greensburg, PABuilt 1979 · S/N R1723217N758NAManabe Osamu · Kapolei, HIBuilt 1979 · S/N R1723218N758NBMcdonald Sporting Goods · Murfreesboro, TNBuilt 1979 · S/N R1723219N758NCWatkins Herbert L Jr · Durango, COS/N R1723220N758NDPlatinum Hawk Xp LLC · Flower Mound, TXS/N R1723221
Back to AD 79-10-14 R1