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.

N9507ALott William F Jr Trustee · Oklahoma City, OKBuilt 1949 · S/N 19068N9507BHanderson Ronald Jr Sr · Sitka, AKBuilt 1957 · S/N 32804N9507LBatra Sanjeev · Roseville, CABuilt 1986 · S/N 17276566N9508BRegistered aircraftBuilt 1981 · S/N 172RG0842N9508WUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1998 · S/N 17280377N9509GMid Continent Aircraft Corp · Hayti, MOBuilt 1974 · S/N 18801508TN9509TKline John C · Wolcottville, INS/N 57309N9509XHilliard Keith B · Van, TXFirst renewal noticeBuilt 1961 · S/N 21057809N950ACRed Carpet Aviation LLC · Carlsbad, CABuilt 1983 · S/N 17276058N950CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282185N950DRRjc Skyhawk LLC · Middletown, DES/N 17268169N950HPKansas Highway Patrol · Topeka, KSBuilt 1998 · S/N 20608002N950LPAmeriflyers Of Texas Inc · Addison, TXBuilt 2001 · S/N 172S8950N950MEN950me LLC · Manassas, VABuilt 1976 · S/N 17266539N950MGDurante Salvatore · Oro Valley, AZBuilt 1977 · S/N R1722623N950SRAcme Aero LLC · Kingman, KSBuilt 1979 · S/N 21063698N9510HRegistered aircraftBuilt 1975 · S/N 17266188N9510JOrange County Mosquito Control District · Orange, TXBuilt 1981 · S/N 18803814N9510LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276568N9510XWillett Michael J · North Little Rock, ARBuilt 1961 · S/N 21057810N9511BRadford Kenneth J Jr · Chugiak, AKBuilt 1957 · S/N 32808N9511DEglin Aero Club · Eglin Afb, FLS/N 17280359N9511GBurdette Ernest L · Pass Christian, MSBuilt 1998 · S/N 18280121N9511RBrewer William B · Fairbanks, AKBuilt 1985 · S/N U20606881N95129Texas State Technical College · Waco, TXBuilt 1997 · S/N 17280264N9512ACook Timothy L · Oklahoma City, OKBuilt 1950 · S/N 19381N9512FGeorge'S Aviation Services Inc · Honolulu, HIBuilt 1998 · S/N 17280429N9512HTracy Patrick J · Maddock, NDBuilt 1975 · S/N 17266190N9512LKreykes K Douglas · Greeley, COBuilt 1998 · S/N 18280237N9512XSwagerty Michael P · La Mesa, NMBuilt 1961 · S/N 21057812N9512YPalmer George J III · Orlando, FLBuilt 1981 · S/N 21064533N9513BLong Michael A · Grand Lake, COBuilt 1981 · S/N 172RG0844N9513GThomas David · Boise, IDBuilt 1971 · S/N U20601713N9513HHigh Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17266191N9514GP51d Mustang LLC · Bigfork, MTBuilt 1971 · S/N U20601714N9514HFrerichs John E · Gurley, ALBuilt 1975 · S/N 17266192N9515BGrason Aviation LLC · Appleton, WIBuilt 1981 · S/N 172RG0846N9515GRegistration Pending · Kenai, AKRegistration pendingS/N U20601715N9515QVictory Aviation Club Inc · Hamilton, OHBuilt 1998 · S/N 17280383N9515RCunningham Michael K · Pinebluff, NCBuilt 1976 · S/N 18503186N9515SKingsky Flight Academy LLC · Lakeland, FLBuilt 1998 · S/N 17280398N9515XJones Jeffrey A · Rehobeth Beach, DEBuilt 1961 · S/N 21057815N9516AHogan Robert P · North Pole, AKBuilt 1950 · S/N 19384N9516JEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280396N9516WRingco Aviation LLC · Oklahoma City, OKS/N 18280226N9516XZeroone Easy Group Inc · Winchester, KYBuilt 1986 · S/N 18268543N9517HPlane Solutions LLC · Kalispell, MTS/N 18267958N9517TSteele Cody T · Polson, MTBuilt 1960 · S/N 57317N9517XKelley James E · Kennewick, WABuilt 1961 · S/N 21057817N9518AFinney Kevin Anthony · Hawthorne, FLBuilt 1949 · S/N 19079
Back to AD 79-10-14 R1