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.

N6402FMaier Andrew J · Barnesville, MNBuilt 1965 · S/N 15063002N6402NManos Con Alas Aviation · Stateline, NVBuilt 1978 · S/N 21062978N6402VG&M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 172RG0664N64034State Of Louisiana · Baton Rouge, LABuilt 1981 · S/N 17275507N64035Loomis Darwin · Mooreland, OKBuilt 1975 · S/N 17264980N6403EGultch Dale R · Brookfield, WIBuilt 1959 · S/N 46503N6403FFertile Flying Club Inc · Fertile, MNBuilt 1966 · S/N 15063003N6403GKassel Willard C · Sicily Island, LAS/N 15071903N6403TSawicki Michael T · Midland, MIS/N 17803N6403VVista Aviation Inc · Pacoima, CABuilt 1980 · S/N 172RG0665N64040Golding Donald J · Tucson, AZBuilt 1981 · S/N 17275509N64043Aira Aviation LLC · Grand Ledge, MIFirst renewal noticeBuilt 1975 · S/N 17264981N64044Johnson Lance D · Duluth, MNS/N 18052865N64045Walker Robert · Chula Vista, CABuilt 1975 · S/N 17264983N64046Biesecker Michael Gary · High Point, NCBuilt 1975 · S/N 17264984N64048Gray Peter A · Salinas, CABuilt 1975 · S/N 17264986N6404FHigh Demand Earthworks & Vineyard Development LLC · Napa, CABuilt 1975 · S/N 18264190N6404GWarrior Aviation LLC · Prior Lake, MNBuilt 1970 · S/N 15071904N6404TWestrum Enterprises LLC · Norwalk, IABuilt 1959 · S/N 17804N64053Collins Thomas A · Orleans, MABuilt 1975 · S/N 17264990N64056Angel Aviation Inc · Peoria, AZBuilt 1981 · S/N 17275512N6405ERiggs Bradley A · Emporia, KSBuilt 1959 · S/N 46505N6405GArmond Richard J · Thousand Oaks, CABuilt 1970 · S/N 15071905N6405TBrunks Paul D · Peachtree City, GAS/N 17805N6405XArctic Aviation Leasing LLC · Anchorage, AKBuilt 1980 · S/N U20605870N64061Stark Glenn M · Nampa, IDBuilt 1975 · S/N 17264994N64062M G Enterprises Of Albert Lea Inc · Alden, MNBuilt 1975 · S/N 17264995N64063Bowers Alan B · Bellevue, WABuilt 1975 · S/N 17264996N64065Lg Holdings LLC · Gretna, NES/N 17275514N64067Duvall Chris D · Tahlequah, OKBuilt 1975 · S/N 17264998N64069Whiskey Tango Aviation LLC · Keene, NDBuilt 1981 · S/N 17275515N6406BWojtacha Jacob M · Wasilla, AKBuilt 1956 · S/N 29606N6406EOwczarek Przemyslaw J · Hampton Bays, NYBuilt 1959 · S/N 46506N6406KWandell Daniel J · Murfreesboro, TNBuilt 1975 · S/N 15077687N6406XIronsides Custom Grinding Inc · Waitsburg, WAS/N 50906N64074Green Norman D · Lake City, FLBuilt 1975 · S/N 17265000N64079Portneuf Holdings LLC · Chubbuck, IDBuilt 1981 · S/N 17275516N6407BMclean Diane A · Weirsdale, FLBuilt 1956 · S/N 29607N6407DWalo Enterprises LLC · Aurora, COBuilt 1979 · S/N 17272790N6407EN6407e LLC · Hanover, MDBuilt 1959 · S/N 46507N6407TKane Erik W · Mojave, CABuilt 1959 · S/N 17807N6407VWard Matthew A · Fort Worth, TXBuilt 1980 · S/N 172RG0669N64081Burrows Donna M Trustee · Grain Valley, MOBuilt 1975 · S/N 17265004N64082Mcdonald Douglas W Sr · Cornelia, GABuilt 1975 · S/N 17265005N64087California Airways LLC · Hayward, CABuilt 1981 · S/N 17275519N6408EMorgan Lloyd J · Memphis, MOBuilt 1959 · S/N 46508N6408GWebb Joe R · Union, WABuilt 1979 · S/N 17273594N6408KShowah Michael F · Scottsdale, AZS/N 15077688N6408NBorders Nowell W · Edinburg, TXBuilt 1978 · S/N 21062984N6408THowland Timothy A · Mankato, MNBuilt 1960 · S/N 17808
Back to AD 79-10-14 R1