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.

N61LCochran Robert Michael · Marathon, NYBuilt 1956 · S/N 32578N61LVHolt Daniel E Jr · Fayetteville, TNBuilt 1965 · S/N 17253899N61PTWings Of Faith Ministries Inc · Tustin, CABuilt 1978 · S/N U20604538N61RBKiazen Black Mountain Holdings LLC · Black Mountain, NCBuilt 1974 · S/N 21060268N61USLakes Aviation LLC · Lakewood, ILBuilt 2001 · S/N 18280935N61WTMonmouth Area Flying Club Inc · Lakewood, NJBuilt 2005 · S/N 172S9818N61YHamilton Daniel L · Coleman, OKBuilt 1964 · S/N 18255657N6200EKirkpatrick Heather A · Clarkston, MIBuilt 1958 · S/N 46300N6200RFlycarolina LLC · Charlotte, NCBuilt 1979 · S/N 172RG0112N6200SKnick Michael J · Camarillo, CABuilt 1967 · S/N 15067000N6201GOlson Christopher L · Delavan, WIBuilt 1969 · S/N 15071701N6201THowett Robert L · Pikeville, NCS/N 15060901N6202BGamache Daniel S · Pleasanton, CABuilt 1978 · S/N 21062706N62030Aht Aviation LLC · Doral, FLBuilt 2008 · S/N 18282096N6203EBandy Suzanne M · Newport, ORBuilt 1958 · S/N 46303N6203RCannon Elliot M · Paso Robles, CABuilt 1965 · S/N 15061503N62049Carlesimo Bernard Vincent · Sea Girt, NJS/N 17275203N6204SRed Baron Flying Club Inc · Pleasant Ridge, MIBuilt 1967 · S/N 15067004N6204TFlory Michael S · Baxley, GABuilt 1964 · S/N 15060904N62058Sky Warrior Flight Training Inc · Pensacola, FLS/N 17275204N6205EMcwilliams Michael W · Derby, KSBuilt 1958 · S/N 46305N6205HCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 18267876N6205SFriesen Valry C · Ryder, NDBuilt 1967 · S/N 15067005N6205VRed Baron LLC · Middletown, DEBuilt 1980 · S/N 172RG0590N6206ANipper James R · Defuniak Springs, FLBuilt 1956 · S/N 33006N6206DP & W Investments Inc · Wilmington, DEFirst renewal noticeBuilt 1979 · S/N 17272634N6206RHagan Steve P · Mexico, MOBuilt 1965 · S/N 15061506N6206SSluyter Zachary W · Greeley, COBuilt 1967 · S/N 15067006N6207ABtp Inc · Missoula, MTBuilt 1956 · S/N 33007N6207EDick Charles H · Milton, KSBuilt 1958 · S/N 46307N6207HYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700551N6207KMoberg Charles W · Edina, MNBuilt 1975 · S/N 15077587N6207MFranklin Dirk W · Beaumont, TXBuilt 1954 · S/N 30640N6208CMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10820N6208EWharton Melissa P · Wise, VABuilt 1958 · S/N 46308N6208GWilson Tom P · Ontario, CABuilt 1969 · S/N 15071708N62093American Aircraft Sales Co · Livermore, CAS/N 17275210N62098Delta State University · Cleveland, MSS/N 17275211N6209C8 Waters LLC · Goodyear, AZBuilt 1979 · S/N 21063830N6209EReynolds Richard E · Trumansburg, NYBuilt 1959 · S/N 46309N6209NZimmerman Dean F · Royalton, MNBuilt 1980 · S/N 18267797N620EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13051N620GWBoyer Skip P · Oak Harbor, WABuilt 1972 · S/N 17260486N620JASilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2000 · S/N 172S8638N620MMRahill John G · Burlington, VTBuilt 1957 · S/N 32780N620SPGulf Coast Aviation LLC · New Orleans, LABuilt 2000 · S/N 172S8610N620WTStilley David · Flagstaff, AZBuilt 1999 · S/N 18280460N62104Condor Aero Club Inc · Zelienople, PAS/N 17275213N6210ADepot Avionics Inc · Alamosa, COBuilt 1956 · S/N 33010N6210EHodges Darin C · West Jefferson, NCBuilt 1958 · S/N 46310
Back to AD 79-10-14 R1