OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N4303LArtic'S Air Academy LLC · Palmer, AKBuilt 1966 · S/N 17254372N4303QHobart Aviation Inc · Akron, OHBuilt 1971 · S/N 17260203N4303SCartersfly LLC · Lewes, DES/N 18257541N4303USherbak Michael J II · St Helena Is, SCBuilt 1963 · S/N 15060303N43043Environmental Safety & Health Consulting Svcs Inc · Houma, LABuilt 2024 · S/N 18283261N4304QProfessional Aviation Inc · Dalton, GAS/N 17260204N4304UStoller Aircraft Rentals LLC · Sharpsburg, GAS/N 15060304N4305LLavin Renaye K · Wasilla, AKS/N 17254374N4306LGrandinetti Robert L · Fayetteville, NYS/N 17254375N4307RMcmath Don · Collinsville, OKBuilt 1974 · S/N 17263060N4308BLyons Milo J · Sequim, WABuilt 1955 · S/N 26652N4308LKim Jingu · Mount Prospect, ILBuilt 1966 · S/N 17254377N4308QN4038q LLC · Merritt Island, FLBuilt 1971 · S/N 17260208N4308UWildcat Aviation LLC · Schoolcraft, MIBuilt 1964 · S/N 15060308N4309LWallace Leroy C · Wshngtn Ct Hs, OHBuilt 1966 · S/N 17254378N4309QCamp Harold S Jr · Bossier City, LABuilt 1971 · S/N 17260209N4309RWest Atlantic Transportation Corp · Mount Pleasant, NCBuilt 1976 · S/N 18502928N430CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13242N430CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8692N430EPFly La Wings LLC · Glendale, CAS/N 17280648N430EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2014 · S/N 172S11453N430FSCustom Air International LLC · Homestead, FLBuilt 1978 · S/N 17271355N430KUlve Scott David · Camdenton, MOBuilt 1979 · S/N 18267209N430MState Of Louisiana · Baton Rouge, LAS/N 18268250N430RPSale Reported · Billings, MTSale reportedBuilt 1976 · S/N 18503244N430SDMedary Aviation LLC · Brookings, SDBuilt 2025 · S/N 172S13323N430UCheyenne LLC · West Mifflin, PABuilt 1997 · S/N 17280121N4310BMaly Burr J · Anchorage, AKBuilt 1955 · S/N 26654N4310LMckenzie Donovan G · East Northport, NYBuilt 1966 · S/N 17254379N4310QRonceverte Fliers Incorporated · Asbury, WVBuilt 1971 · S/N 17260210N4310USport Wings Enterprises LLC · Pasadena, TXBuilt 1964 · S/N 15060310N4311BPohl Jeffrey A · Milaca, MNBuilt 1955 · S/N 26655N4311LRockin Robin Aviation LLC · Natchez, MSS/N 17254380N4311QLink John · West Milford, NJBuilt 1971 · S/N 17260211N4311UMoreland Wesley M · Mckinney, TXBuilt 1965 · S/N 337-0093N4312RHorizon Group Inc Trustee · Boca Raton, FLBuilt 1974 · S/N 17263065N4312UDudley Benjamin H · Wasilla, AKS/N 15060312N4313RStauffer Kurt A · Belleville, PABuilt 1974 · S/N 17263066N4314QRafinski Marcus · San Juan, PRBuilt 1971 · S/N 17260214N4315BMckamey Dave S · Sonora, CABuilt 1955 · S/N 26659N4315LBeedle Jeremiah J H · Juneau, AKS/N 17254384N4315QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1971 · S/N 17260215N4315RDuffys Aircraft Sales And Leasng Inc · Neillsville, WIBuilt 1974 · S/N 17263068N4315UYoung Margaret J · Peck, IDBuilt 1964 · S/N 15060315N4316BAnderson Gregory P · Meadow Vista, CABuilt 1955 · S/N 26660N4316RMarston Charles T · New Bern, NCBuilt 1974 · S/N 17263069N4317QPerera Nandana L · Logan, OHBuilt 1971 · S/N 17260217N4317RSam Aviation LLC · Long Beach, CAS/N 17263070N4318LPhillips Matthew L · Las Cruces, NMBuilt 1966 · S/N 17254387N4318RBeaulieu Steven · Georgetown, DEBuilt 1974 · S/N 17263071
Back to AD 79-10-14 R1