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.

N737XTHeins Alfred Jr · Monticello, NYBuilt 1977 · S/N 17269760N737XURaynor Andrew C · Kingman, AZS/N 17269761N737XWWeiss Gregory K · Colorado Springs, COBuilt 1977 · S/N 17269763N737XZBrown John P Jr · Winter Garden, FLBuilt 1977 · S/N 17269766N737YADuffys Aircraft Sales And Lsg Inc · Neillsville, WIBuilt 1977 · S/N 17269767N737YBBurke Donald T · Scranton, NDBuilt 1977 · S/N 17269768N737YEAeroventures Flying Club Inc · Lilburn, GABuilt 1977 · S/N 17269771N737YFVero Technical Support Inc · Pensacola, FLBuilt 1977 · S/N 17269772N737YGAgassiz Flyers Inc · Herman, MNBuilt 1977 · S/N 17269773N737YPYankee Papa LLC · Wilmington, DEBuilt 1977 · S/N 17269780N737YQTec Aviation Inc · Pasco, WABuilt 1977 · S/N 17269781N737YSCk Max LLC · Stanford, KYBuilt 1977 · S/N 17269783N737YT80075 Aircraft Corporation LLC · Wilmington, DEBuilt 1973 · S/N 17261481N737YULake Elmo Aero LLC · Lake Elmo, MNBuilt 1977 · S/N 17269785N737YVLees Sea Air · Kiana, AKBuilt 1977 · S/N 17269786N737YZWininger Spencer C · Wichita, KSBuilt 1977 · S/N 17269790N737ZACounty Of Santa Cruz · Santa Cruz, CABuilt 1977 · S/N 17269791N737ZCMoody Air Ventures LLC · Nolanville, TXBuilt 1977 · S/N 17269793N737ZDHp Air Inc · Cape Coral, FLBuilt 1977 · S/N 17269794N737ZGDuck Air LLC · Mooresville, NCBuilt 1977 · S/N 17269797N737ZJLazy Eights Holdings LLC · Greenwood, INBuilt 1977 · S/N 17269799N737ZKAk Fly Inc · Kasilof, AKBuilt 1977 · S/N 17269800N737ZNEquinoxx Flight Systems LLC · Lawrenceville, GABuilt 1977 · S/N 17269803N737ZPJahawk Leasing LLC · Sugar Grove, ILBuilt 1977 · S/N 17269804N737ZRTennessee Seaplane Company LLC · Knoxville, TNBuilt 1977 · S/N 17269806N737ZTEdwards Ronald R · Clinton, ARBuilt 1977 · S/N 17269808N737ZVJax Aero LLC · Jacksonville, FLBuilt 1977 · S/N 17269810N737ZWS & S Aviation Co · Ball Ground, GAS/N 17269811N73800Soul Aviation LLC · Newport Beach, CABuilt 1976 · S/N 17267690N73808Delta Aviation Inc · Monticello, MNBuilt 1976 · S/N 17267691N7380GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259080N7380HCoggins Craig C · Nome, AKS/N 18503384N7380KKxp Ventures LLC · Piedmont, SCFirst renewal noticeBuilt 1976 · S/N R1722067N7380NWolverton Engineering Inc · Collins, MSBuilt 1974 · S/N 18263163N7380TAndersen William A · Flagstaff, AZBuilt 1959 · S/N 46980N73813Smoot Russell L · Louisville, KYBuilt 1976 · S/N 17267693N73816Nedved Aviation LLC · Mitchell, SDBuilt 1976 · S/N 17267696N73819Botter Marlene S Trustee · Kent, WABuilt 1976 · S/N 17267699N7381EDill Terry L · Delphi, INBuilt 1960 · S/N 57081N7381NHorizon Enterprises LLC · Kalispell, MTS/N 18263164N7381QBooth Sean A · Auburn, CABuilt 1972 · S/N 18261021N7381VEvarts Roy K · Northborough, MABuilt 1977 · S/N R1722306N7382AWretschko Brian W · Phoenix, AZBuilt 1956 · S/N 29482N7382MPansza Michaelangelo · Poteet, TXBuilt 1958 · S/N 55682N7382NTerracon Pipelines Inc · Healdsburg, CABuilt 1974 · S/N 18263165N7382QOsterman Michael A · Maplewood, MNBuilt 1972 · S/N 18261022N73830Asbury Paul G · Charleston, TNBuilt 1976 · S/N 17267706N73837Bloomex Aviation LLC · Montvale, NJS/N 17267711N7383LChicken Hawk Aviation LLC · Strasburg, COS/N 17273259N7383MRegistered aircraftS/N 55683
Back to AD 79-10-14 R1