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.

N61599Freebird Aviation LLC · Eagle, IDBuilt 1974 · S/N U20602350N6159RBagamaspad Alan M · Reseda, CABuilt 1979 · S/N 172RG0098N6159ULaw Office Of Vincent G Rieger · Kalispell, MTBuilt 1985 · S/N 21064927N615AHRusty Crate LLC · Wynne, ARS/N 17252337N615EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12716N615ESCampanell Garrett · Leesburg, VABuilt 1969 · S/N 18260093N615FUN615fu LLC · Nashville, TNBuilt 1962 · S/N 18254491N615SPChesapeake Skyhawks Inc · Wilmington, DEBuilt 2000 · S/N 172S8603N615TWClark Jim W · Claremore, OKBuilt 2020 · S/N 18283110N615WTOwensby Paul T · Fayetteville, NCBuilt 1968 · S/N 17257421N616U S D A Forest Service Fepp · Columbia, SCBuilt 1967 · S/N U206-0849N61605Blake Ernest Ronald · San Jose, CABuilt 1975 · S/N 17264670N61606Swafford Charles T · Humble, TXBuilt 1975 · S/N 17264671N61607Maier Dennis J · Morristown, SDBuilt 1975 · S/N 17264672N61609Eriksen Bjorn A · Polson, MTBuilt 1981 · S/N 18504235N6160BJesperson Kenneth R · Ekalaka, MTS/N 34160N6160EBurnette Richard A · Hampton, GABuilt 1958 · S/N 46260N6160NRj Capital LLC · Mustang, OKBuilt 1978 · S/N 21062931N61610Sugarpine Skies LLC · San Jose, CABuilt 1973 · S/N 17261367N61615High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17264677N61616Wolstenholme Ralph E · Westfield, PABuilt 1981 · S/N 18504237N6161BPeterson Tony D · Humboldt, IABuilt 1957 · S/N 34161N6161FBeach Bums Air LLC · Martin, GABuilt 1968 · S/N 21059061N6161GGough James L · Hesston, KSBuilt 1969 · S/N 15071661N6161KSmith William F · Hindsville, ARBuilt 1975 · S/N 15077562N6161NOn Eagles Wings LLC · Los Gatos, CABuilt 1978 · S/N 21062932N61622Lexington Flying Club · Richmond, KYBuilt 1975 · S/N 17264681N61625Chapline Curtis · Cypress, TXBuilt 1975 · S/N 17264683N61628Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1974 · S/N 17264684N6162RSmjd LLC · Penrose, COBuilt 1965 · S/N T210-0062N6162VAir Ventures Hawaii LLC · Lihue, HIBuilt 2004 · S/N 18281373N6162ZHolloman Afb Aero Club · Holloman Afb, NMBuilt 2004 · S/N 18281375N61630Jerome Pester Farms Inc · Hingham, MTBuilt 1975 · S/N 17264685N61631Jones Donald T Jr · Barrigada, GUBuilt 1975 · S/N 17264686N61632Cost Garret Alan · Tulalip, WABuilt 1976 · S/N 18052785N61633Rotor Spec Aviation LLC · Fort Lauderdale, FLBuilt 1975 · S/N 17264688N61635Meridian Aero Club Inc · Midland, MIBuilt 1975 · S/N 17264690N61637Amelia Reid Aviation LLC · San Jose, CABuilt 1975 · S/N 17264691N6163FVagabond Flying Association · Winfield, ILBuilt 1979 · S/N 17273157N6163KJennings Steven W · Austin, TXS/N 15077563N6163MN6163m LLC · Eugene, ORBuilt 1962 · S/N 17249550N6163UMcevoy Steven T · Aniak, AKBuilt 1980 · S/N U20605357N61640Cooper Michael A · Rohnert Park, CABuilt 1975 · S/N 17264694N61641Handzo Anthony J · Roseville, ILBuilt 1975 · S/N 17264695N61642N61642 LLC · Lowell, MIBuilt 1975 · S/N 17264696N61643Spence Stephen E · Mancelona, MIBuilt 1975 · S/N 17264697N61645Lima-001 LLC · Muscatine, IABuilt 1975 · S/N 17264698N61648Tnt Airworks LLC · Hibbing, MNS/N 17264699N6164B64 Bravo LLC · Oberlin, OHBuilt 1957 · S/N 34164N6164FBlue River Aviation LLC · Palmer, AKBuilt 1979 · S/N 17273158
Back to AD 79-10-14 R1