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.

N7197GFly Wissota LLC · Chippewa Falls, WIBuilt 1969 · S/N 17258897N7197MKansas Soaring Association · Wichita, KSBuilt 1958 · S/N 55497N7197TNelson Jim · Midlothian, TXS/N 46797N7198EAcute Holdings LLC · Jenks, OKBuilt 1959 · S/N 52198N7198FCessna Flyers LLC · Bountiful, UTBuilt 1966 · S/N 15063798N7198GJones Lawrence A · St Simons Island, GABuilt 1969 · S/N 17258898N7198QBay Lux Ventures LLC · Tampa, FLBuilt 1972 · S/N 17260498N7198XScott Allexus D · Melbourne, ARBuilt 1961 · S/N 15059298N71991Bush-Tell Inc · Aniak, AKBuilt 1968 · S/N U206-1247N71994Skydive Buckeye LLC · Goodyear, AZBuilt 1968 · S/N U206-1249N7199EHornor Kent A · Oak Creek, COBuilt 1959 · S/N 52199N7199FSale Reported · Pikeville, TNSale reportedBuilt 1966 · S/N 15063799N7199XGrand Aviation LLC · Celina, OHBuilt 1961 · S/N 15059299N719AWUnrau Wilbur D Trustee · Wolf Point, MTBuilt 1973 · S/N 18262249N719CGAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13474N719CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281714N719LCYoung Larry W · Bowdoin, MES/N 18259514N719LULiberty University Inc · Lynchburg, VABuilt 2023 · S/N 172S13072N719SRob Hance Management P C · Argyle, TXS/N 18283026N719THAuburn University · Auburn, ALBuilt 2017 · S/N 172S12010N71BTriplett Gregory S · Groveland, CABuilt 2003 · S/N 18281289N71CNAnderson Thomas R · Seattle, WAS/N 18053113N71CPKitty Hawk Flight Training And Tours LLC · Nags Head, NCBuilt 1972 · S/N 15073229N71CWSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 18051093N71DCDish Technologies LLC · Rocky Mount, NCBuilt 1960 · S/N 52803N71DJBlitman Jeffrey W · Wellington, FLBuilt 1973 · S/N 18261969N71ERClapp William H · Mountain View, MOBuilt 1968 · S/N 180-51965N71ESBig Tex LLC · Reedsburg, WIS/N U206-1402N71FCNaples Flying Club Inc · Naples, FLBuilt 1997 · S/N 17280237N71FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12935N71HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9758N71HHEastern Slope Aviation Academy · North Conway, NHBuilt 1971 · S/N 17260295N71HTAerodynamic LLC · Aurora, ORBuilt 2002 · S/N 172S9047N71JHJacks Air Serv Inc · Greenville, MEBuilt 1966 · S/N 18051678N71JTJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266696N71KFFoster Kenneth B · Queen Creek, AZBuilt 1977 · S/N 18265723N71MHSchultz Engineered Products Inc · Neptune, NJBuilt 1978 · S/N 18052965N71MJ1mj LLC · Willis, TXBuilt 1979 · S/N 18267250N71MVVolatile Aero Ventures LLC · Boulder City, NVFirst renewal noticeBuilt 1974 · S/N U20602365N71MWWalker Michael E · Lewistown, MTS/N 51266N71PHPlh Air LLC · Post Falls, IDBuilt 1975 · S/N U20602651N71PKBob Hoover Academy · Salinas, CABuilt 1974 · S/N 17263272N71PLRegistered aircraftS/N 18280840N71RTaliaferro Aviation LLC · Ardmore, OKS/N 18503942N71SNorth Pine Properties LLC · Queen Creek, AZBuilt 1974 · S/N P3370171N71STGreen Martin H · Framingham, MABuilt 1978 · S/N 18266651N71TDDunn William F · Del Norte, COBuilt 1957 · S/N 29706N71TFFreund Timothy P · Goddard, KSBuilt 1956 · S/N 32587N71WTBear Cat Air LLC · Gun Barrel City, TXS/N 21061505N7200AMcdaniel Neil R · Wray, COBuilt 1956 · S/N 29300
Back to AD 79-10-14 R1