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.

N403BSRogness Joshua D · Wasilla, AKS/N 18503527N403CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13237N403CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282448N403EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12639N403ESPlumdaffy LLC · West Chatham, MAS/N 18280050N403FRBas Part Sales LLC · Greeley, COS/N 17280245N403GFSky Mates Inc · Wilmington, DEBuilt 2005 · S/N 172S9918N403GMBalisky Micah · Fort Shaw, MTBuilt 1972 · S/N 18260967N403PKN403pk LLC · Ada, MIBuilt 1977 · S/N 18265475N403SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1999 · S/N 172S8295N403SWBsf Skylane LLC · Buford, GAS/N 18280830N4041UCumberland Soaring Group Inc · Wiley Ford, WVBuilt 1965 · S/N 15061441N4042FTweedle Dee LLC · John Day, ORBuilt 1958 · S/N 36942N4042VFreedom Aviation · Salina, KSBuilt 1948 · S/N 18361N4043FFinley Trevor S · Caddo Mills, TXS/N 36943N4043JDevine Steven A · Roseville, CAS/N 15065343N4043UHawthorne Christopher J · Lafayette, LABuilt 1965 · S/N 15061443N4043VThompson Frank · Weiser, IDBuilt 1948 · S/N 18362N4044JLiberty University Inc · Lynchburg, VABuilt 1966 · S/N 15065344N4044VStrnad William J · Taylors Falls, MNBuilt 1948 · S/N 18369N4045DTlm Properties LLC · Gladewater, TXBuilt 1957 · S/N 34745N4045FRobinson Jeffrey A · Gaines, MIBuilt 1956 · S/N 36945N4045UKnutson Tristian A · Spokane, WABuilt 1965 · S/N 15061445N4046FVyatkin Denis · Sacramento, CAS/N 36946N4046UFox James E · Queen Creek, AZS/N 15061446N4046VHowell Alvin M · Needville, TXS/N 18373N4047DEiff John E · Deland, FLFirst renewal noticeBuilt 1957 · S/N 34747N4047FRegistration Pending · Sherwood, WIRegistration pendingBuilt 1958 · S/N 36947N4047UDurfey Kyle A · Tucson, AZBuilt 1965 · S/N 15061447N4048MJoel Massey Real Estate LLC · Flowery Branch, GABuilt 1981 · S/N 182-67993N4048UOshtemo Flyers LLC · Kalamazoo, MIBuilt 1965 · S/N 15061448N4048VThomas Kevin C · Spokane, WABuilt 1948 · S/N 18377N4049DUnwrapped LLC · Dover, DEBuilt 1957 · S/N 34749N4049FSouthwell Arthur M · Arcadia, FLBuilt 1958 · S/N 36949N4049JWashington Aero Club Inc · South Park, PAS/N 15065349N4049UCatero Inc · Chickasha, OKBuilt 1965 · S/N 15061449N4049VJustin William R · Sauk Rapids, MNBuilt 1975 · S/N 15076685N404BNCienski Todd A · Duncanville, TXBuilt 1965 · S/N 21058705N404DCN404dc LLC · Kennesaw, GABuilt 2023 · S/N 172S13065N404EPSkywest Leasing Inc · St George, UTBuilt 2014 · S/N 172S11436N404FREdb Air Inc · Wilsonville, ORBuilt 1997 · S/N 17280282N404KRCenterline Aviation Inc · Middletown, DEBuilt 2009 · S/N 18282203N404RGJoyner James M · Eagle River, AKS/N 18502702N404SMForm 50 Aviation LLC · Newark, DEBuilt 1966 · S/N 18257374N404SWWood Roger W · Sale Creek, TNBuilt 1968 · S/N 17256702N4050DKesling Aviation LLC · Orange Beach, ALBuilt 1957 · S/N 34750N4050FTitensor Shanelle Bn · Tetonia, IDS/N 36950N4050VDussetschleger Lynn Albert · Luling, TXBuilt 1948 · S/N 18381N4051DOlson Scott L · Girdwood, AKS/N 34751N4051FTamargo Victor · Fort Worth, TXBuilt 1958 · S/N 36951
Back to AD 79-10-14 R1