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.

N9335EParanjpe Vasant · Pittstown, NJBuilt 1984 · S/N 18268397N9335XFlorida Gas Transmission Co · Spring, TXBuilt 1985 · S/N 18268495N93362Bouvier Ellis C · Prineville, ORBuilt 1974 · S/N 21060377N9336CLarson Lynn R · Casselton, NDBuilt 1955 · S/N 31734N9337EMarianas Air Transfer Inc · Saipan, MPBuilt 1979 · S/N 17272230N9337GHaller Lonette J · Mobile, ALBuilt 1971 · S/N 18260877N9337HLorraine'S Blue Sky Aviation LLC · Norman, OKBuilt 1975 · S/N 17266095N9337XValentine Richard E · Holt, FLBuilt 1961 · S/N 18253737N93380Stahla Robert E Trustee · Grand Island, NEBuilt 1974 · S/N 21060384N9338BTopp Jason · Grace City, NDBuilt 1981 · S/N 172RG0799N9338EComanche Hills Aircraft LLC · Lampasas, TXBuilt 1984 · S/N 18268398N9338HSchab Davis Maragaret A · Spangle, WABuilt 1975 · S/N 17266096N9338XHathaway David P · Waterbury, VTBuilt 1985 · S/N 18268496N9338ZBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N U20606404N9339XSedona Aviation LLC · Sedona, AZBuilt 1962 · S/N 18253739N933CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282399N933CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283333N933DB933db LLC · St Louis Park, MNBuilt 1978 · S/N 18503555N933DDHarris John Alfred · Havana, FLBuilt 1972 · S/N 18260933N933LAMindy Limited LLC · Muscatine, IABuilt 1998 · S/N 17280640N933PAerowood Aviation LLC · Monroe, NCBuilt 1964 · S/N 17252361N9340BCook Raymond L · Spring Grove, ILBuilt 1958 · S/N 55140N9340CWolfe Donald E · T Or C, NMBuilt 1955 · S/N 31738N9340UJohnson Cory D · Rugby, NDBuilt 1976 · S/N 15078289N9341BYager Keith E · Eugene, ORBuilt 1958 · S/N 55141N9341HAndreas Neil A · Yakima, WABuilt 1975 · S/N 17266099N9341XKent Steven P · Warwick, NYBuilt 1985 · S/N 18268497N9342FChurchill David J · Bear, DEBuilt 1998 · S/N 18280105N9342GBaumann James J · Trabuco Canyon, CABuilt 1971 · S/N 18260882N9342HGutierrez Ricardo · Downey, CABuilt 1975 · S/N 17266100N9342RCampbell Gene H · Baytown, TXBuilt 1978 · S/N 17702752N9342TChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 172S11153N9343BBas Part Sales LLC · Greeley, COBuilt 1958 · S/N 55143N9343DAva Aviation LLC · Tappan, NYBuilt 1982 · S/N 172RG1128N9343GOlivo Investments Group LLC · Richmond, TXBuilt 1971 · S/N 18260883N9343TJansen Guy A · Lynden, WABuilt 1960 · S/N 50843N9343ULazor Ronald E · Middlefield, CTBuilt 1976 · S/N 15078292N9343XYoung Charles T · Los Banos, CABuilt 1962 · S/N 18253743N9344BSumners David O Jr · Eastville, VABuilt 1958 · S/N 55144N9344CPage James S · Avoca, TXBuilt 1955 · S/N 31742N9344FAtp Aircraft 2 LLC · Wilmington, DEBuilt 1997 · S/N 17280166N9344HBarnstormers Flying Club Inc · Pulaski, TNBuilt 1975 · S/N 17266102N9344LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276543N9344UNewman Thomas E · Saint Ignatius, MTBuilt 1976 · S/N 15078293N9345BPasquariello Thomas · Alton, NHBuilt 1958 · S/N 55145N9345CBunting Gordon E · Bend, ORBuilt 1955 · S/N 31743N9345GFrederick Paul M · Tucson, AZBuilt 1971 · S/N 18260885N9345LHaynie Aviation LLC · Alexander City, ALBuilt 1986 · S/N 17276544N9345XBordner Christopher P · Santa Cruz, CABuilt 1961 · S/N 18253745N9346BHarter Wayne R Jr · Alliance, OHBuilt 1958 · S/N 55146
Back to AD 79-10-14 R1