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.

N7844GRedington James F · Hot Springs, VABuilt 1970 · S/N 17259544N7844TRegistration Pending · Saint Matthews, SCRegistration pendingBuilt 1960 · S/N 47444N7844URegistration Pending · Hereford, AZRegistration pendingBuilt 1964 · S/N 17251844N7844XFeather Farms Inc · Griffithville, ARBuilt 1961 · S/N 17248344N78458Heffley And Ruiz LLC · Waco, TXBuilt 1968 · S/N 17257624N7845EWallace Terry E · Bedford, TXBuilt 1959 · S/N 17645N7845GSolorio Inc · Mission, TXBuilt 1970 · S/N 17259545N7845TOrr Dorthy L · Santa Paula, CABuilt 1960 · S/N 47445N78461Lynam Leonard B · Walled Lake, MIBuilt 1968 · S/N 17257625N78464Hernandez Jesse · Auburndale, FLS/N 17257627N7846FGrossman Steven · Seven Valleys, PAS/N 15063946N7846UCrisco Millwright Services LLC · Lewes, DEBuilt 1964 · S/N 17251846N7847CAyres Patrick C · Bend, ORBuilt 1954 · S/N 31046N7847UFinnegan James M · West Valley City, UTBuilt 1964 · S/N 17251847N7847XNix Charles W · San Jose, CABuilt 1961 · S/N 17248347N78482N78482 LLC · Granbury, TXS/N 17257632N78487Richardson David · Leitchfield, KYS/N 17257635N78489Tanner Richard L · Copperhill, TNBuilt 1968 · S/N 17257636N7848TChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12412N78490Owens Neil L Jr · Tallapoosa, GAS/N 17257637N78491El Dorado Rentals Inc · El Dorado Springs, MOBuilt 1968 · S/N 17257638N78494Peterson Darwin D · Antler, NDBuilt 1968 · S/N 17257640N7849EDelaney Jerard Emmet II · Monroe, MIBuilt 1959 · S/N 17649N7849TMyers Stanley · Portland, ORBuilt 1960 · S/N 47449N7849ZMorgan Gregory A · Rice, VABuilt 1963 · S/N 15059949N784ACRochefort Michael A · Panama City, FLBuilt 1997 · S/N 18280096N784AWSea Rogue Enterprises Inc · Greenville, MEFirst renewal noticeBuilt 1973 · S/N 18502251N784BGSuperior Flying Services LLC · Superior, WIBuilt 2004 · S/N 17281222N784CRTurnipseed Kenny A · Sumner, TXS/N 17257629N784DJAlta Volare LLC · Wilmington, DEBuilt 1968 · S/N 21059104N784DRMyren Jason A · Marion, IABuilt 2003 · S/N 18281213N784ERTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13578N784GHenry Frank P · Winnabow, NCBuilt 1977 · S/N 18265960N784GTMarianas Air Transfer Inc · Tinian, MPBuilt 1977 · S/N 17268855N784JATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13598N784LMNorth Lake Air LLC · Lindstrom, MNBuilt 1979 · S/N 18267452N784REsmaili Farid · Woodstock, VAS/N 17271233N784SAEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2001 · S/N 172S8780N784SPSaz Dynamics LLC · Daly City, CABuilt 2001 · S/N 172S8711N7850GWhitfield Robert O Jr · Hurdle Mills, NCS/N 17259550N7850UJohnson Lawrence F · Sacramento, CABuilt 1964 · S/N 17251850N7850ZBenscoter Richard S · Nordman, IDBuilt 1963 · S/N 15059950N78512United States Air Force Academy Aero Club · Usaf Academy, COBuilt 1969 · S/N 17257646N78513Reeder Gary T · Galena, OHBuilt 1968 · S/N 17257647N78515Becker Jarrod L · Selfridge, NDBuilt 1968 · S/N 17257648N78517Johnson Kevin R · Gladstone, ORBuilt 1968 · S/N 17257650N7851FDevries James E · Bejou, MNBuilt 1966 · S/N 15063951N7851UR & S Aviation LLC · Corning, ARBuilt 1964 · S/N 17251851N78520Jdb Aviation Inc · Merritt Island, FLBuilt 1968 · S/N 17257651N78522Jb522 LLC · Pflugerville, TXBuilt 1973 · S/N 18261768
Back to AD 79-10-14 R1