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.

N8299ELondon Corbin Airport Board · London, KYBuilt 1979 · S/N 17272185N8299SMcauliffe John P · Livonia, MIBuilt 1965 · S/N 15061899N8299XBeail Herschel D · Quincy, CAS/N 17248799N829AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13533N829BGGipson Robert E · Port Byron, ILBuilt 1968 · S/N 17700667N829BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280951N829CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281263N829EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2022 · S/N 172S12837N829FACareer Flight Training And Aircraft Rental Holding · Naples, FLBuilt 2002 · S/N 18281129N829FSPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1999 · S/N 17280795N829PJMidwestern Twang Communications LLC · Evanston, ILBuilt 1970 · S/N 17701534N82ADAdams Aircraft LLC · Wilmington, DEBuilt 1961 · S/N 18253753N82BAMcilnay Brian S · Athens, TNBuilt 1981 · S/N 18268084N82BGGrimshaw Brian Trustee · Long Beach, CABuilt 1964 · S/N 18255427N82CCDenrow Limited Lc · Shawnee, OKBuilt 1975 · S/N 18264066N82CTCoelho Gabriel P · Chowchilla, CABuilt 1969 · S/N 18259804N82DZJosephine Air LLC · Castle Rock, WABuilt 1978 · S/N 18266752N82ESkymaster Mods & Parts LLC · Castalian Springs, TNBuilt 1973 · S/N P3370126N82EDRodriguez Rolando · Harlingen, TXBuilt 1973 · S/N 15075663N82EPPosav Holdings LLC · Zephyrhills, FLBuilt 1978 · S/N 17271353N82FBBolea Air Inc · Morgan Hill, CABuilt 1974 · S/N 18263094N82FLVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N 18281007N82HABeller Ronald D · Morehead, KYBuilt 1976 · S/N 17702401N82HSAdventist World Aviation · Wilson, NCBuilt 1971 · S/N 18260814N82JDJ D Aviation LLC · Rochester, NYBuilt 2018 · S/N 18283040N82JWGaines Joseph M · Niceville, FLBuilt 1980 · S/N 18053162N82KCDrake Raymond H · Asheville, NCBuilt 1998 · S/N 18280193N82KYKentucky Department Of Aviation · Frankfort, KYS/N 18267092N82LAAvery Lyle · Beach Lake, PABuilt 2000 · S/N 18280846N82LECollier County Sheriffs Office · Naples, FLBuilt 2004 · S/N 18281377N82LTRegistered aircraftBuilt 2005 · S/N 172S9913N82LWMuskox Ministries · Fairbanks, AKBuilt 1973 · S/N U20602054N82MEHutt George H III · Stratham, NHBuilt 1975 · S/N 18264089N82MGSkymasters LLC · Olathe, KSBuilt 1967 · S/N 337-0659N82MHRainier Flight Service LLC · Renton, WABuilt 2023 · S/N 172S13002N82MNDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N R1722014N82NGallant James II · Scottsville, KYS/N 33538N82NACoduto Billy Mark · Shelbyville, TNS/N 18264607N82PAHart Michael Anthony · Rockford, ILFirst renewal noticeBuilt 1986 · S/N 18268586N82SLHanus Logan D · Kenyon, MNS/N 18257976N82TLRegistration Pending · Roscoe, ILRegistration pending, pending cancellationS/N 18263775N82WAVomela Paul Trustee · Wasilla, AKBuilt 1978 · S/N 18266327N82WGHash Brian Morrison · Mattawa, WABuilt 1998 · S/N 18280388N82XTPerreault Mark L · Van Buren, MEBuilt 1979 · S/N 18266945N82YMiller Charles G · Anchorage, AKBuilt 1958 · S/N 51039N82YCBerry Kevin J · Renfrew, PABuilt 2008 · S/N 18282081N8300AChapa Jana K · Corpus Christi, TXBuilt 1952 · S/N 25152N8300BMonger Kenneth R · Bella Vista, ARBuilt 1957 · S/N 36100N8300MWiener Ronald K Trustee · Tucson, AZBuilt 1976 · S/N 18264583N8300QSafeco Leasing LLC · Port Alsworth, AKBuilt 1976 · S/N U20603161
Back to AD 79-10-14 R1