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.

N9924NMulcaire Jess · Camp Verde, AZBuilt 1975 · S/N 18052579N9924QMy Way Aviation LLC · Weston, FLBuilt 1975 · S/N 17265868N9924RInzer James Clarence IV · Baton Rouge, LABuilt 1986 · S/N U20606983N9924TBlue Skies Aviation LLC · Wall, SDBuilt 1960 · S/N 18253024N9924VEdwards Kevin M · Grass Valley, CAS/N 17264558N99253Mitiguy Aviation LLC · Stow, MABuilt 1985 · S/N 17276421N9925BMartell Summer · Port Townsend, WABuilt 1957 · S/N 34325N9925EMeredith Dean J · Boynton Beach, FLBuilt 1975 · S/N 18263985N9925GPetecraft Aviation Services Inc · Plains, GABuilt 1971 · S/N 18800725N9925NHarrod James · Birchwood, MNBuilt 1975 · S/N 18052580N9925QRoeder Cara R · Lake Charles, LABuilt 1975 · S/N 17265869N9925VGoodin Joshua W · Jacksonville, FLBuilt 1974 · S/N 17264559N99263Wings Over Texas Holdings LLC · Denton, TXBuilt 1985 · S/N 17276424N99265St Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1985 · S/N 17276425N9926AOlmsted Ronald A · Barnstead, NHFirst renewal noticeBuilt 1950 · S/N 19286N9926EPaul Michael Trustee · San Antonio, TXBuilt 1985 · S/N 18268472N9926NBelchak Timothy A · Albuquerque, NMS/N 21063252N9926VRanheim Richard J · Blaine, MNBuilt 1966 · S/N 18051778N9926XMuth Franklin R · Missoula, MTBuilt 1961 · S/N 1850126N99273United States Air Force · Dover Afb, DEBuilt 1985 · S/N 17276427N9927ABrian Jake K · Sumner, ILBuilt 1950 · S/N 19287N9927HAnderson Mfg Inc · Camilla, GABuilt 1981 · S/N 18268118N9927QAndrus Shane · Pullman, WABuilt 1975 · S/N 17265871N9927THauser Thomas R · Johnson, KSBuilt 1960 · S/N 18253027N9927VBunin David K · Rockwall, TXBuilt 1977 · S/N R1722354N9928BHayton James B · Sedro Woolley, WAS/N 34328N9928EAir-Lark Inc · Fort Walton Beach, FLBuilt 1975 · S/N 18263988N9928NScott J Steve Jr · Itta Bena, MSBuilt 1977 · S/N U20603730N9928QDavis John · Jackson, WYBuilt 1975 · S/N 17265872N9928VRyan Wilfred P · Anchorage, AKFirst renewal noticeBuilt 1966 · S/N 18051780N9928YEckelkamp L B Jr · Washington, MOBuilt 1982 · S/N 21064643N99295Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276429N9929ACavner Hudson · Palmer, AKBuilt 1950 · S/N 19289N9929EJesse Briggs Inc · Stuttgart, ARS/N 18263989N9929NBarnes Stewart A Trustee · Wasilla, AKBuilt 1975 · S/N 18052584N992CDPineland Properties LLC · Volga, SDS/N 56299N992CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280284N992EZLarge Jon D · Wasilla, AKBuilt 1953 · S/N 25905N992LBBravo Initiative LLC · Highlands Ranch, COBuilt 1975 · S/N 18263982N992PSProctor Gary · Wichita, KSBuilt 1978 · S/N 21063074N992VTVermont Flight Academy · South Burlington, VTBuilt 1998 · S/N 172S8043N992WTAngle Of Attack Inc · Santa Fe, NMBuilt 1972 · S/N 18261200N992WWTss Flying Club Inc · Bethesda, MDBuilt 1999 · S/N 17280717N9930ASmith David J · Duluth, MNBuilt 1950 · S/N 19290N9930EBell A A Flying Club · Mechanicsburg, PABuilt 1985 · S/N 18268473N9930HTorres Daniel Yorro · Carolina, PRBuilt 1981 · S/N 18268121N9930QBrawdy James · Clarence Center, NYBuilt 1979 · S/N 18503798N9930TWateractive43 LLC · Auburn, CAS/N 18253030N9930VHovland Keith C · Wadsworth, OHBuilt 1966 · S/N 18051782N9930XPeterson Tony · Humboldt, IABuilt 1961 · S/N 1850130
Back to AD 79-10-14 R1