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.

N9569XStepair LLC · Spring Valley, OHBuilt 1962 · S/N 21057869N956ASA2g International LLC · San Juan Capo, CABuilt 1978 · S/N 33701848N956BFMpd2 Inc · Valdosta, GABuilt 1971 · S/N 18260597N956CFHighwind Aero LLC · Inyokern, CABuilt 2002 · S/N 18281075N956CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282409N956ESHr Cabinets LLC · Nederland, TXBuilt 2017 · S/N 18283013N956SMMississippi Forestry Commission · Pearl, MSBuilt 2000 · S/N 18280783N956SPN3812q LLC · San Diego, CABuilt 1999 · S/N 172S8156N956WBEd Payne Motors Inc · Weslaco, TXBuilt 1981 · S/N 21064532N9570AUpper Fifteen Inc · Latham, NYBuilt 1998 · S/N 18280286N9570BStriplin Bradley H · Pittsboro, NCS/N 32867N9570VAwp Holdings LLC · Murphysboro, ILS/N 18280285N9570XGroves Chandler H DBA · Farmington, CAS/N 21057870N9571BFarrell Mark A · Omaha, NEBuilt 1957 · S/N 32868N9571HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266236N9571VTempleton John E · Loami, ILBuilt 1974 · S/N 17264373N9571XBarnett David Kirk · Brock, TXS/N 21057871N95720Stilley John · Flagstaff, AZBuilt 1978 · S/N 18266608N95721Copeland Danny K · Roseville, CABuilt 1978 · S/N 18266609N9572AEagle Eye Marketing LLC · Reno, NVBuilt 1998 · S/N 18280279N9572GJones Robert D Jr · Chugiak, AKBuilt 1972 · S/N U20601772N9572HGeneral Aviation LLC · Henderson, NVBuilt 1975 · S/N 17266237N9572LJav Air Services LLC · Anchorage, AKBuilt 1986 · S/N 17276582N9572VHill Timothy E · Hooks, TXBuilt 1974 · S/N 17264374N9572WDr Equipment LLC · Ackerly, TXBuilt 1998 · S/N 17280544N9572XSparks James D · Glennallen, AKBuilt 1962 · S/N 21057872N9573BDocarmo Aviation LLC · Dallas, TXBuilt 1981 · S/N 172RG0890N9573TLearn To Fly LLC · Portal, GABuilt 1959 · S/N 57373N9573VReynolds Darryl G · Wills Point, TXBuilt 1974 · S/N 17264375N9573XLenyk Michael · Venice, FLBuilt 1986 · S/N 18268558N9573ZBangert Richard E III · Seattle, WABuilt 1981 · S/N U20606549N95740Nicholes Steven A Trustee · Portland, ORBuilt 1978 · S/N 18266615N95747Eichelberger John Andrew · Winchester, MABuilt 1978 · S/N 18266617N9574AHomeward Bound Enterprises LLC · Parker, COS/N 18280824N9574BHinds Community College · Bolton, MSBuilt 1981 · S/N 172RG0891N9574GKreiner Kurt · Rch Palos Vrd, CABuilt 1972 · S/N U20601774N9574HJb III LLC · Stuart, FLBuilt 1975 · S/N 17266238N9574TMcclellan Fred L · Flint, MIBuilt 1960 · S/N 57374N9574XFlying Nova LLC · Anchorage, AKS/N 21057874N9575AConway Sheila R · Seattle, WABuilt 1949 · S/N 19136N9575GGolden Eagle Outfitters · Delta Junction, AKFirst renewal noticeBuilt 1972 · S/N U20601775N9575HBoca Aircraft Partners Inc · Coral Springs, FLBuilt 1981 · S/N 18267965N9575VFurnari Alfio · Hutchinson Island, FLBuilt 1974 · S/N 17264377N95764Marc Inc · Bolton, MSBuilt 1978 · S/N 18266622N95766Ongstad William · Harvey, NDBuilt 1978 · S/N 18266623N9576GWerth Lance C · Johnson Lake, NEBuilt 1974 · S/N 18801542N9576TDe Vincenzo Chiara · Chicago, ILBuilt 1960 · S/N 57376N9577BRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1981 · S/N 172RG0894N9577VMdr Flying Inc Trustee · Wilmington, DEBuilt 1974 · S/N 17264379N9577WIasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280527
Back to AD 79-10-14 R1