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.

N48BGWhitfill Mark J · Crockett, TXBuilt 1978 · S/N 17271064N48CFRaven Girl LLC · Eagle River, AKS/N 20700366N48EFVista Air Inc · Pacoima, CABuilt 2004 · S/N 172S9629N48FACavu Pilot LLC · Powell, TNBuilt 1965 · S/N 15061895N48FCSoarmates Inc · Missoula, MTFirst renewal noticeBuilt 1968 · S/N U206-1099N48FFWingsleasing LLC · Wichita, KSBuilt 2022 · S/N 172S12875N48JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1975 · S/N 17265312N48JGWulvik Frederik M · Wasilla, AKBuilt 1974 · S/N 18502391N48JKKeahey Britt · Saint Joseph, LABuilt 1972 · S/N 17260693N48KCGraham Norman J · West Ossipee, NHBuilt 1959 · S/N 52056N48PMFreeman Robert G DBA · Baker, FLBuilt 1960 · S/N 57567N48RGBlueskies LLC · Smyrna, TNBuilt 2023 · S/N 172S12953N48VAGeiser Corbin · Little Elm, TXBuilt 1977 · S/N 21061798N48WEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1973 · S/N 18262161N4900ABaum James L Trustee · Anchorage, AKBuilt 1956 · S/N 32297N4900DCastaneda Jose · Yakima, WAS/N 17272389N4901ASchneberger C J · Clinton, IARevoked, canceledBuilt 1956 · S/N 32298N4902ACavanagh Michael B · Dubois, WYBuilt 1956 · S/N 32299N4902FFlying Vikings Inc · Hayward, CABuilt 1979 · S/N 17273099N4902RBecker Flying Service Inc · Hartington, NEBuilt 1975 · S/N 18802420TN4902UWallace Randall · Stamps, ARFirst renewal noticeBuilt 1965 · S/N 21058602N4902VZweifel John M · Beresford, SDBuilt 1952 · S/N 25334N4903AKendall Ted O · Lakeside, CAS/N 32300N4903DSam Air LLC · Madison, SDBuilt 1958 · S/N 51003N4903NDroke Paul Dan Jr · Coalgate, OKBuilt 1979 · S/N 18267447N4904GC & W Aviation LLC · Trumbull, CTBuilt 1979 · S/N 17273451N4904QFoxtrot Air LLC · Highmore, SDBuilt 1976 · S/N 18802639TN4904UMcdonald Patrick B · Brownwood, TXBuilt 1965 · S/N 21058604N4905CAnacapa Capital LLC · Fresno, CABuilt 1979 · S/N 21063664N4905RFlight Level Zero LLC · Othello, WABuilt 1975 · S/N 18802423TN4905UPerformance Ag Indiana · Frankfort, INS/N 21058605N4906DHutchison Robert T · Big Lake, AKBuilt 1958 · S/N 51006N4906NKmq Data Acquisitions LLC · Chugiak, AKBuilt 1979 · S/N 18267450N4907RMills Spraying Service Inc · Pahokee, FLBuilt 1975 · S/N 18802425TN4908GShaffer Aviation LLC · Tupelo, MSS/N 17273455N4908Q1lowflyer Inc · Harrisonville, MOBuilt 1976 · S/N 18802643TN4909ANastro Kristopher Jason · Fallon, NVS/N 32306N4909GRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1979 · S/N 17273456N4909UGarner Howard E · Bonifay, FLBuilt 1965 · S/N 21058609N4909YFremont Airways LLC · Riverton, WYBuilt 1980 · S/N 21064039N490AFEiffert Matthew T · Ukiah, CABuilt 1970 · S/N 17701493N490CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282205N490DBPatkotak Crawford · Barrow, AKS/N U20604472N490EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12258N490LLAntel Av Corp · Lewes, DEBuilt 2004 · S/N 18281432N490NWGalvin Flight Services Hawaii LLC · Honolulu, HIBuilt 2021 · S/N 172S12757N490SPSky Training LLC · West Milford, NJBuilt 1998 · S/N 172S8031N491Acadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1978 · S/N 18503597N4910AEverett Laurence B · Berkley, CABuilt 1956 · S/N 32307N4910DN4910d LLC · Delavan, WIBuilt 1979 · S/N 17272394
Back to AD 79-10-14 R1