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.

N726AMRegistered aircraftBuilt 1953 · S/N 26009N726ASA2g International LLC · San Juan Capo, CABuilt 1975 · S/N 33701661N726CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11566N726EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13029N726HSSpmhrt 206 LLC · East Bernard, TXS/N U20606947N726JHClearview Flying Club Inc · Westminster, MDBuilt 1977 · S/N 17269494N726LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13587N726MBBurgos Orlando · Venice, FLBuilt 1982 · S/N 17275766N726MMRiverside Flight Academy LLC · Riverside, CABuilt 1979 · S/N 17272970N726SAInternational Air Services Inc Trustee · Carson City, NVBuilt 2010 · S/N 18282221N727United States Department Of Interior · Boise, IDBuilt 1982 · S/N 18504371N7270GBruneau Paul G Jr · Madison, MEBuilt 1970 · S/N 17258970N7270HSundowners Inc · Fort Myers, FLBuilt 1999 · S/N 18280481N7270NRivera Daniel A · San Marcos, TXBuilt 1974 · S/N 18263059N7270QGrey-Gc LLC · Picayune, MSBuilt 1999 · S/N 18280484N7270TBudenbender Philip W · Weatherford, TXBuilt 1959 · S/N 46870N7270YBlanton Kenneth A Jr · Cortland, NYBuilt 1999 · S/N 18280498N7271AEinck Matthew J · Fort Worth, TXS/N 29371N7271SWalker Kevin · Stillwater, OKBuilt 1967 · S/N 15067971N7271XAeolian LLC · Mcalester, OKBuilt 1999 · S/N 18280518N72727Hice Michael D · Cookeville, TNBuilt 1971 · S/N 177-01678N7272AOpen Air Ltd Co DBA · Pella, IABuilt 1956 · S/N 29372N7272EMonro Andrew C · Columbia X Rd, PAS/N 52272N7272KPearson Zachary B · Hayden, IDBuilt 1952 · S/N 20412N7272RBst Equipment LLC · Spearfish, SDBuilt 1999 · S/N 18280492N7272SRegistered aircraftBuilt 1967 · S/N 15067972N7273AMartin Randal O · Oak Point, TXBuilt 1956 · S/N 29373N7273EBlack Kennith M · Barboursville, WVBuilt 1999 · S/N 18280489N7273MPalm Beach Flight Training Corp · Lantana, FLBuilt 1999 · S/N 17280761N7273SFerguson Jeffrey Woods · San Antonio, TXBuilt 1967 · S/N 15067973N72749Sarkcap Global Inc · Carlsbad, CABuilt 2001 · S/N 18280933N7274GFlyit LLC · Washougal, WABuilt 1973 · S/N 15074632N7274MPearson Russell · Fairfield, MTS/N 55574N7274QPugliese Vincent · Woodbridge, VABuilt 1999 · S/N 18280533N7274SWltf LLC · Frisco, TXBuilt 1999 · S/N 18280537N7274TN8653u LLC · Fairbanks, AKBuilt 1959 · S/N 46874N7274XFuellner Sean L · Shelocta, PABuilt 1962 · S/N 15059374N7275AZelinski Jeffrey C · Watersmeet, MIS/N 29375N7275CAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280503N7275DMoody Bible Institute Of Chicago · Spokane, WABuilt 1999 · S/N 17280790N7275HBurch Preston M · Sykesville, MDBuilt 1998 · S/N 18280396N7275REdb Air Inc · Wilsonville, ORBuilt 1999 · S/N 172S8026N7275TBeets Larry Joe · Columbia, MSBuilt 1959 · S/N 46875N72762N72762 LLC · Sarasota, FLBuilt 2001 · S/N 18280940N7276AAved Consulting LLC · Edgewater, FLBuilt 1956 · S/N 29376N7276HFlying Schnauzer LLC · Vestavia, ALS/N 18280565N7276MMcneil Larry D · Portal, AZBuilt 1958 · S/N 55576N7276NDancer Aviation LLC · Delphos, OHBuilt 1976 · S/N U20603597N7276PSanders Daniel K · Cuba, NMBuilt 1999 · S/N 18280566N7276QBrynelsen Charles R · North Oaks, MNBuilt 1999 · S/N 18280567
Back to AD 79-10-14 R1