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.

N9439URautiola Patricia H · Rosemount, MNS/N 15078387N9439XBallard Richard D · Juneau, AKBuilt 1961 · S/N 21057739N9439YR C S Drilling Company Inc · West Lake Hills, TXBuilt 1981 · S/N 21064505N943AHHaley Keith · Tonawanda, NYBuilt 1981 · S/N 21064377N943CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282406N943KSStark James E Trustee · Sun City, AZBuilt 1978 · S/N 17270273N943SPLittle Airplanes LLC · Aurora, ORBuilt 1999 · S/N 172S8138N943THSpirit Aviation Management Services Inc · Thomson, GABuilt 2024 · S/N 172S13143N94405Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 20608345N9440BRamos Daniel J · Pueblo, COS/N 55240N9440USmith Peter I Trustee · Ocala, FLS/N 15078388N9440XMountain Flyers Inc · Asheville, NCBuilt 1985 · S/N 18268527N9441AKing Beth A · Louisville, KYBuilt 1949 · S/N 15262N9441BSmith Mickey D · Tyler, TXBuilt 1958 · S/N 55241N9441MGuemes Aloft LLC · Portland, ORS/N 18264759N9441TDevil Dusters Inc · Artesia, NMBuilt 1960 · S/N 57241N9441ULewis Paul A · Spring, TXBuilt 1976 · S/N 15078389N9441XMurphy Peter D · Santa Fe, NMBuilt 1961 · S/N 21057741N9441ZTjb Capital LLC · Nashville, TNBuilt 1998 · S/N 18280214N9442Winger Aviation LLC · Palatine, ILBuilt 1973 · S/N 177RG0324N9443CRvest Management LLC · Boulder City, NVBuilt 1955 · S/N 31841N9443HAllport Bruce E · North Hollywood, CABuilt 1975 · S/N 17266156N9443LTdz Aircraft Holdings LLC · Dover, DES/N 17276558N9444BWallitner Aviation Inc · Renton, WAS/N 55244N9444HPrestige Worldwide Aerospace LLC · Panama City, FLBuilt 1975 · S/N 17266157N9444MTriple Four Mike LLC · Sand Springs, OKBuilt 1977 · S/N 21062076N9444UB2w Corporation · Winona, MNBuilt 1976 · S/N 15078392N9445AAlsup Alan D · Gainesville, TXBuilt 1949 · S/N 15266N9445CSchaller Lee W · New Athens, ILBuilt 1955 · S/N 31843N9445DTriple Fes LLC · San Antonio, TXBuilt 1984 · S/N 172RG1165N9445HBrown Max K · Cushing, OKBuilt 1975 · S/N 17266158N9445MSky Masters Aviation Inc · Laguna Hills, CAS/N 18264761N9445THale Tom · Browns Valley, CABuilt 1960 · S/N 57245N94461Daytona Aircraft Leasing LLC · Daytona Beach, FLBuilt 2012 · S/N 172S11205N9446CAlaskan Luxury Cruises LLC · Willow, AKS/N 31844N9446GStringfellow Regan M · Boerne, TXS/N U20601646N9446NSkywagon LLC · Goochland, VABuilt 1981 · S/N 18504358N9446UTepper Jesse J · New York, NYBuilt 1976 · S/N 15078394N9447HLang Julia A · Greensburg, PABuilt 1975 · S/N 17266159N9447LAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1986 · S/N 17276559N9447MWings Aircraft LLC · New Richmond, WIS/N 18264763N9447XKaminski Thomas E · Green Bay, WIBuilt 1985 · S/N 18268529N9448AOlson Ben A · Gig Harbor, WABuilt 1949 · S/N 15269N9448CAero Marine Inc · Westland, MIBuilt 1955 · S/N 31846N9448MSoto Eduard D Trustee · Somers, MTBuilt 1976 · S/N 18264764N9448UValley View Farming Inc · Halsey, ORFirst renewal noticeS/N 15078396N9448ZAmeriflyers Of Florida LLC · Addison, TXBuilt 1997 · S/N 17280279N9449ASiglin Sybil Joann · Pleasanton, CABuilt 1949 · S/N 15270N9449BLeaders Bob O · Clear Lake, MNBuilt 1958 · S/N 55249N9449XBelk Pritchard Properties LLC · Broken Arrow, OKBuilt 1961 · S/N 21057749
Back to AD 79-10-14 R1