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.

N616JHHarcatco LLC · Corsicana, TXS/N 18504290N616MCFletcher Flying LLC · Russellville, ARS/N 18281616N616PJLarson Paul S · San Carlos, CABuilt 1979 · S/N 18267121N616SFAmelia Reid Aviation LLC · San Jose, CABuilt 1980 · S/N 172RG0740N616SKSuperior Flying Services LLC · Superior, WIBuilt 1979 · S/N 17273381N616WERodriguez Norberto R · Inwood, NYBuilt 1963 · S/N 18254925N61700Torres Ramon L · Mulberry, FLS/N 17264741N61701Jls Aviation LLC DBA · Fredericksburg, VABuilt 1975 · S/N 17264742N61703Beising Steven · Las Vegas, NVBuilt 1975 · S/N 17264744N61704Glick Mervin L · Stanardsville, VABuilt 1975 · S/N 17264745N61705White Robert Tyler · Pleasanton, CABuilt 1977 · S/N 18265728N61707Spartan National Holdings LLC · Missoula, MTBuilt 1975 · S/N 17264747N61709Caldwell Clifton · Sterling City, TXBuilt 1975 · S/N 17264748N6170BEnglish Stanley P · Anchorage, AKBuilt 1957 · S/N 34170N6170FWilkins Raymond E · Osceola, IABuilt 1968 · S/N 21059070N6170NGarmin210 LLC · Willard, MOBuilt 1978 · S/N 21062941N6170RBrown Michael R · Huntsville, ALBuilt 1965 · S/N T210-0070N6170THerman David B · Seattle, WABuilt 1964 · S/N 15060870N61710Bob Hoover Academy Inc · Salinas, CABuilt 1975 · S/N 17264749N61713Miller Melanie L · Spanaway, WABuilt 1975 · S/N 17264750N61718Ortman Bernard R · Bozeman, MTBuilt 1975 · S/N 17264753N6171EAvequities Inc · Dallas, TXBuilt 1958 · S/N 46271N6171FDohrenwend Mark G · Owensboro, KYBuilt 1968 · S/N 21059071N6171GMission Flight Academy · Yucaipa, CAS/N 15071671N61727Mays Gloria J · College Station, TXBuilt 1975 · S/N 17264755N61728Henderson James Ross · Garden Prairie, ILBuilt 1976 · S/N 18052792N6172DBlue Spruce Aviation LLC · Fairview Park, OHBuilt 1979 · S/N 17272617N6172EKatz Braunschweig Daniel A · Staten Island, NYBuilt 1958 · S/N 46272N6172GTappan Scott M · Port Saint Lucie, FLBuilt 1969 · S/N 15071672N6172TMckinney Peggy A · Hamersville, OHBuilt 1964 · S/N 15060872N61733Pan Air Flying Club Inc · Miami, FLBuilt 1975 · S/N 17264760N61737Executive Flight Institute LLC · Murrieta, CABuilt 1975 · S/N 17264763N61738Finn Development LLC · Kaysville, UTBuilt 1975 · S/N 17264764N61739Southern Aero LLC · Homestead, FLS/N 17264765N6173FLesondank Stephen M · Bellvue, COBuilt 1968 · S/N 21059073N6173QKinder Mark Edward · Bozeman, MTBuilt 2004 · S/N 18281388N6173RBeyer Livestock Auction LLC · Clovis, NMBuilt 1965 · S/N T210-0073N6173TGreat Pilots LLC · Rocklin, CABuilt 1965 · S/N 15060873N61742Fox James R · Saint Paul, MNBuilt 1981 · S/N 18504246N61743Carruth John T · Danvers, MNBuilt 1975 · S/N 17264768N61747Lakes Aircraft LLC · Little Canada, MNBuilt 1981 · S/N 18504248N61748Zapata Raymond E · Cabo Rojo, PRBuilt 1975 · S/N 17264772N61749Kellogg Wade A · Chelsea, MIBuilt 1981 · S/N 18504249N6174BN6174b LLC · Nokomis, FLBuilt 1978 · S/N 21062698N6174ECano Michael J · Vallecito, CABuilt 1958 · S/N 46274N6174GMosley Gabriel T · Oak Hills, CABuilt 1969 · S/N 15071674N6174RLaurel Highlands Aeronautical Academy · Latrobe, PAS/N 172RG0103N61752Lee Robert Eric · Charleston, WVBuilt 1975 · S/N 17264774N61755K E F Enterprises · Plymouth, MABuilt 1975 · S/N 17264777N61757Smith Bradford W · Duluth, MNS/N 18504251
Back to AD 79-10-14 R1