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.

N439DCLaguna Sky LLC · Wilmington, DES/N 21062636N439ERMorey Airplane Co Inc · Middleton, WIBuilt 2001 · S/N 172S8935N439ESH R Management LLC · Bay Saint Louis, MSBuilt 1998 · S/N 18280130N439LPTps Aviation LLC · Los Angeles, CABuilt 2003 · S/N 172S9439N43AKEarth Center Adventures Inc · Haines, AKBuilt 1980 · S/N U20605545N43APSchubert Edward M · Floyds Knobs, INS/N 17273802N43DEReynolds Carl R · Bryn Mawr, PABuilt 1977 · S/N 18266212N43FWesterlund Karl D · Eagle River, AKBuilt 1954 · S/N 26221N43FAKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 17270808N43GFGaskins Joseph Spencer · Port Orchard, WABuilt 1980 · S/N 17274453N43HLKimbrell Heath G · Quinlan, TXBuilt 1957 · S/N 34652N43JKEvans James · Millbrae, CABuilt 1973 · S/N 18262576N43KYPinto Carlos Eduardo · Tucson, AZBuilt 1972 · S/N 21059563N43LSLima Sierra Inc · Nappanee, INS/N 21062124N43LWRotgers Benjamin Leroy · Malabar, FLS/N 52159N43SLSudtell Chad S · Wasilla, AKBuilt 1954 · S/N 31611N43TBAndreu Kenneth · Valhalla, NYBuilt 1966 · S/N 18257442N43TJCyr Philip · Charlton, MABuilt 1979 · S/N 18267365N43VRMountain Ridge Aviation LLC · Millersburg, PABuilt 1999 · S/N 18280482N4400RBophades LLC · Fort Pierce, FLBuilt 1974 · S/N 17263150N4400UMax Power Aircraft LLC · Kenosha, WIBuilt 1964 · S/N 15060400N4401BJohnson Timothy A · Chisago City, MNBuilt 1955 · S/N 26745N4401LWarbelows Air Ventures · Fairbanks, AKBuilt 1966 · S/N 17254484N4401VEwald Christopher R · Blanding, UTBuilt 1948 · S/N 18534N4402BBuffalo Hill Holdings LLC · Sheridan, WYBuilt 1955 · S/N 26746N4402LClements Alex F Jr · Alamogordo, NMBuilt 1966 · S/N 17254485N4402QSummers Mark A · Alpine, WYBuilt 1973 · S/N 17261697N4402RAvel Aircraft Inc · West Chicago, ILBuilt 1974 · S/N 17263152N4403BWhitesell Timothy D · Bend, ORS/N 26747N4403RGorge Aviation Services LLC · Portland, ORS/N 17263153N4403VEgbert Harry T · Clarks Point, AKBuilt 1948 · S/N 18536N4405BWelton Doug L · Fairbanks, AKBuilt 1955 · S/N 26749N4405LKopcho Thomas L · York, NEBuilt 1966 · S/N 17254490N4405RBon Homme Flyers Inc · Tyndall, SDBuilt 1974 · S/N 17263155N4406BAndersen Gregory A · Kenai, AKBuilt 1955 · S/N 26750N4406RDe Nora Christian G · San Antonio, TXBuilt 1976 · S/N 18052670N4406VPacific Aviation Aircraft Management Inc · Fresno, CABuilt 1948 · S/N 18539N4407QSund Manufacturing Co · Newburg, NDS/N 17261698N4407RRhyneer Loren S · Anchorage, AKBuilt 1976 · S/N 18502946N4408BBrookover Thomas E · Anchorage, AKBuilt 1955 · S/N 26752N4408VScott Tony D · Mangum, OKBuilt 1948 · S/N 18541N4409BDavis John A · Waller, TXS/N 26753N4409RRegistration Pending · Albany, ORRegistration pendingBuilt 1974 · S/N 17263158N440ERChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 172S12027N440FAA-Cent Aviation Inc · Jacksonville, FLBuilt 2003 · S/N 172S9440N440SPHoletz Consulting Inc · Minneapolis, MNBuilt 2000 · S/N 172S8357N4410BRhymes Dustin A · Upland, CABuilt 1955 · S/N 26754N4410LLenhart James A · Manchester, MIBuilt 1966 · S/N 17254495N4410QAyer Benjamin D · Newport, MEBuilt 1973 · S/N 17261699N4410RSpane John T · Mount Airy, NCBuilt 1974 · S/N 17263159
Back to AD 79-10-14 R1