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.

N6861RJohnson Bradley Michael · Belgrade, MTBuilt 1967 · S/N T210-0261N6862EBostik Industries LLC · Green Cove Springs, FLS/N 56362N6862FGradel Thomas A Jr · Irmo, SCBuilt 1966 · S/N 15063462N6862HStrickland J A · Fairbanks, AKBuilt 1975 · S/N 17265616N6862MCreacy Jason Thomas · Gatesville, TXBuilt 1975 · S/N 18263866N68639Bathalter Michelle N · Las Vegas, NVBuilt 1960 · S/N 18253073N6863AZinter Dean K · Tigard, ORBuilt 1956 · S/N 28963N6863MRvandco LLC · Missoula, MTBuilt 1975 · S/N 18263867N6863TBering Capital LLC · Anchorage, AKBuilt 1973 · S/N 17262470N6864ABrusik John A Jr DBA · New Port Richey, FLS/N 28964N6864HMay Jeffrey N · Ocala, FLBuilt 1975 · S/N 17265618N6864MKnott Dustin Shane · Brentwood, CABuilt 1975 · S/N 18263868N6864RRankin Bryan · Cloverdale, CABuilt 1967 · S/N T210-0264N6865ESustek Jerry · Seattle, WABuilt 1959 · S/N 56365N6865FGeissler Robert William Jr · Baltimore, MDBuilt 1966 · S/N 15063465N6865XGessley Lester Jack Jr · Port Saint Lucie, FLBuilt 1960 · S/N 17247765N68662Edwards Joseph C Trustee · Austin, ARBuilt 1958 · S/N 55543N6866AJlk Inc · Malvern, ARBuilt 1956 · S/N 28966N6866EStuart Bradley J · Hillsboro, NDBuilt 1959 · S/N 56366N6866FLand Ross A · Cedar Rapids, IAS/N 15063466N6866HParrish Michael C Trustee · Lakeland, FLBuilt 1975 · S/N 17265619N6866ROrnes W Harold · Aiken, SCBuilt 1967 · S/N T210-0266N6867AHeffron Jacob L · Little Falls, MNS/N 28967N6868FVan Bielert Wouter · Haxtun, COS/N 15063468N6868LJohnson Gregory L · Orange, CABuilt 1969 · S/N 18260147N6868RChrisman Charles Griggs · Denver, COS/N T210-0268N6868XRegistered aircraftBuilt 1960 · S/N 17247768N6869AMccraney John K · Canon, GAS/N 28969N6869TCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2005 · S/N 172S10001N6869XSquires Aaron Lane · Aynor, SCS/N 17247769N686DBAnderson Bruce Robert · Mena, ARS/N 172-68334N686DWSunrise Aviation Inc · Ormond Beach, FLBuilt 2000 · S/N 17280947N686MGMike Golf Holdings LLC · Pinellas Park, FLBuilt 1981 · S/N 18504314N686PXTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2023 · S/N 172S13020N686SPRainier Flight Service LLC · Renton, WABuilt 1999 · S/N 172S8097N6870ELentfer Sheryl A · Anchorage, AKBuilt 1959 · S/N 56370N6870LBarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280097N6870MApplied Science Services Corp · Woodland Hills, CABuilt 1977 · S/N 21061998N6871AGibson James G · Harpers Ferry, WVBuilt 1956 · S/N 28971N6872ACoats Alexander · Murrieta, CAS/N 28972N6872FSkybound Aircraft LLC · Blue Point, NYBuilt 1966 · S/N 15063472N6872GVortex Aircrafts Inc · Port Saint Lucie, FLBuilt 1973 · S/N 18801215N6872MShowalter Mark W · Richland, WABuilt 1975 · S/N 18263871N6873EWallace Joseph R · Winchester, KYBuilt 1959 · S/N 56373N6874AGillum Thomas W III · Davenport, IABuilt 1956 · S/N 28974N6875EElston Josh · Sterling, AKS/N 56375N6875GStevenson Mark Frank · Anthem, AZBuilt 1970 · S/N 15072375N6876EDunn Gary K · Paw Paw, ILBuilt 1959 · S/N 56376N6876FPalmer Dana G · Gatesville, TXBuilt 1966 · S/N 15063476N6876GMyers Russell E · Happy Jack, AZBuilt 1970 · S/N 15072376
Back to AD 79-10-14 R1