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.

N7299NGonin Henri Louis · Elko, NVBuilt 1974 · S/N 18263086N7299QStout Oscar M · Brookshire, TXS/N 17260599N7299TOstrowski Sven E · Mullica Hill, NJBuilt 1959 · S/N 46899N7299XPecoy Edward D · Lyons, NYBuilt 1961 · S/N 15059399N729CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281757N729EBoard Of Trustees Of Southern Illinois Universtiy · Carbondale, ILBuilt 2023 · S/N 172S12965N729ELRegistered aircraftBuilt 2023 · S/N 18283209N729HPorter Wade R · Durham, CABuilt 1949 · S/N 19044N729JHDickman Robert J · Richmond, INBuilt 1978 · S/N 17271839N729LUTextron Aviation Inc · Wichita, KSS/N 172S13596N729MTHochreiter Heinrich · Bellingham, WABuilt 1999 · S/N 172S8272N729SPMars Aerospace Inc · Bay Shore, NYBuilt 2000 · S/N 172S8666N729WDMonroe Greg · Linden, TNBuilt 1960 · S/N 47583N72BLSkrow Works Inc · West Monroe, LAS/N 17257795N72CABrooks Duane T · Mt Shasta, CABuilt 1972 · S/N P3370027N72CCCaterfull Inc · Miami Beach, FLBuilt 1975 · S/N 17266347N72CPGrant Henry R H · Ocracoke, NCBuilt 1973 · S/N 15075051N72CXCorsair Engine Technologies · Colorado Springs, COBuilt 1969 · S/N 17258725N72EFN72ef LLC · Canton, GABuilt 2000 · S/N 172S8636N72ERMaierhoffer Henry F Jr · Sylvania, GABuilt 1977 · S/N 17269501N72FDEngesath David H · Duluth, MNBuilt 1974 · S/N 17263913N72FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12936N72GJSkydive Greene County Inc · Xenia, OHS/N 51723N72HSRowser Brad C · Duchesne, UTBuilt 1959 · S/N 52223N72JGN72jg LLC · Belgrade, MTBuilt 1976 · S/N 18264870N72JNTroy I Mounts Md Inc · San Juis Obispo, CABuilt 1974 · S/N 17263882N72KFKirkpatrick John Drew · Post, TXBuilt 2004 · S/N 18281361N72MCAa-Aero Inc · Fairfield, NJBuilt 2005 · S/N 18281653N72MRSnide Thomas C · Dublin, OHBuilt 1998 · S/N 18280123N72NXNexair Avionics LLC · Plymouth, MABuilt 1976 · S/N 17267923N72PFKuck Russell W · Aguila, AZBuilt 1965 · S/N 17253530N72RRoam Airlines LLC · Eugene, ORBuilt 1952 · S/N 20904N72RXTayloreel Plastics South Corp · Gainesville, GAS/N 18261397N72SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17272017N72STSierra Tango Air LLC · Senoia, GAS/N 17269433N72TNTornado Alley Turbo Inc · Ada, OKBuilt 1976 · S/N R1722028N72TRRcrhb LLC · Wells, TXBuilt 1972 · S/N 18261325N72USUnited States Aviation Underwriters Inc · Toledo, OHBuilt 2001 · S/N 18280936N72VCProfessional Motorcoach Leasing & Sales LLC · Tamassee, SCBuilt 1981 · S/N 18267977N72VHThomason Terry C · Hot Springs, ARBuilt 1972 · S/N 18261033N72WEWest Elk Air LLC · Gunnison, COBuilt 1979 · S/N 18503854N72XPFlink Frank B Jr · Shawnee Mission, KSFirst renewal noticeBuilt 1977 · S/N R1722396N73001Spooter Air LLC · Obion, TNBuilt 1976 · S/N 17267232N7300QClark Perry W · Pine River, MNBuilt 1971 · S/N 18260940N73010Rico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17267235N73015Alameda Flying Club Inc · Richmond, CABuilt 1976 · S/N 17267238N7301GFreeport Flyers Inc · Freeport, ILBuilt 1970 · S/N 17259001N7301MLeaders Bob O · Clear Lake, MNBuilt 1958 · S/N 55601N7301QMorgan John C · Seattle, WABuilt 1971 · S/N 18260941N7301SJohn Air LLC · Aurora, UTBuilt 1976 · S/N 18265094
Back to AD 79-10-14 R1