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.

N9346DHolloway James H · Merritt Island, FLBuilt 1982 · S/N 172RG1129N9347GNazir Donna Lacruz · Boca Raton, FLS/N 18260887N9347HWings Like Eagles LLC · Wilmington, DEBuilt 1975 · S/N 17266105N9347TLewis University · Romeoville, ILBuilt 2012 · S/N 172S11166N9347UAirgo Inc · Centralia, ILBuilt 1976 · S/N 15078296N9348FDirty Side Down Aviation LLC · Georgetown, TXBuilt 1997 · S/N 17280189N9348HDeshazer Bill G · Gladewater, TXBuilt 1975 · S/N 17266106N9348XWhittemore Kenneth P Jr · Fredericksburg, VABuilt 1962 · S/N 18253748N9349MDouble R Air LLC · Miami, FLBuilt 1980 · S/N 20700682N9349XDicarlo Jason M · Covington, LABuilt 1962 · S/N 18253749N934AZN934az LLC · Miami, FLBuilt 1999 · S/N 172S8294N934CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282400N934EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S12982N934GRGrossman Robert W · Andover, MABuilt 1977 · S/N 17269688N934MT8th Dimension Enterprises LLC · Englewood, COBuilt 1997 · S/N 17280058N934TCVandentoorn Randy J · Caledonia, MIFirst renewal noticeBuilt 1976 · S/N 18503026N934TRAris Leasing Inc · Sunnyvale, CABuilt 1977 · S/N 17269190N9350BHoman Ralph C · Weiser, IDBuilt 1958 · S/N 55150N9350CCloud Dancer Inc · Berlin, MDBuilt 1955 · S/N 31748N9351DJennings David M · Huffman, TXBuilt 1982 · S/N 172RG1130N9351FCarr Sam H · Spring, TXBuilt 1998 · S/N 18280104N9351HBrown Daniel Thomas · Layton, UTS/N 17266109N9351UHolt James D · Greensboro, NCBuilt 1976 · S/N 15078300N9351XSasser Konnie B · Granbury, TXBuilt 1985 · S/N 18268499N9352CSage Blue LLC · Yakima, WABuilt 1955 · S/N 31750N9352XLinhart Charles W · Dayton, WYBuilt 1962 · S/N 18253752N9353DRegistration Pending · Simi Valley, CARegistration pending, canceledBuilt 1982 · S/N 172RG1131N9353ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 18268402N9353GMisyukevich Konstantyn · Clarkston, MIBuilt 1971 · S/N 18260893N9353YKovax Aviation LLC · Youngstown, OHBuilt 1981 · S/N 21064482N9354BC2 Aero LLC · Dallas, TXBuilt 1958 · S/N 55154N9354CSmith Richard M · Stanwood, WABuilt 1955 · S/N 31752N9355CGrobbelaar Warren · Naples, FLBuilt 1955 · S/N 31753N9355NGardner Tyler J · Lowell, MEBuilt 1981 · S/N 18504337N9355RSkyline Aviation LLC · Lewistown, MTBuilt 1975 · S/N 18802254TN9355XTaylor John A · Lexington, MABuilt 1985 · S/N 18268501N9356BWard Clayton D · Mcville, NDBuilt 1958 · S/N 55156N9356HQuad Cities Aero LLC · Bettendorf, IABuilt 1975 · S/N 17266113N9356XGibson Kenneth W · Washougal, WAS/N 18253756N9356YParsons Bruce W Trustee · Costa Mesa, CABuilt 1981 · S/N 21064483N9357GPpp Investments LLC · Lexington, MSBuilt 1971 · S/N 18260897N9357TBonafide Investments LLC · Dover, DEBuilt 1960 · S/N 50857N9357UBaldwin James S · Sylvania, OHBuilt 1976 · S/N 15078306N9358ELechmanski Philip J · Shelter Island, NYBuilt 1979 · S/N 17272236N9358GBig Sky Plane Holdings LLC · Kalispell, MTBuilt 1971 · S/N 18260898N9358LUnited States Air Force · Eglin Afb, FLBuilt 1986 · S/N 17276546N9358NHarvey Kandace A · Snohomish, WABuilt 1981 · S/N 18504339N9358USaddedine Nouredine · Frisco, TXBuilt 1976 · S/N 15078307N9359BPalinsky Gary C · Au Gres, MIS/N 55159N9359CAero Sport Craft LLC · Havre De Grace, MDS/N 31757
Back to AD 79-10-14 R1