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.

N759XDRegistered aircraftBuilt 1978 · S/N 18266333N759XFRichards Chad · Brookshire, TXBuilt 1978 · S/N 18266335N759XKWright Andrew N · Dadeville, ALBuilt 1978 · S/N 18266339N759XQWells Mark K · Kennett Square, PABuilt 1978 · S/N 18266344N759XWClear Skies And Tailwinds LLC · Verona, WIBuilt 1978 · S/N 18266350N759YBVaughan Larry S · Amarillo, TXS/N 18266355N759YDHalifax Aviation Partners Inc · Battleboro, NCBuilt 1978 · S/N 18266357N759YEBridger Optronics LLC · Mooresville, NCBuilt 1978 · S/N 18266358N759YGSpringville Flying Club · Spanish Fork, UTS/N 18266360N759YHColeman Tommy · Prosper, TXBuilt 1978 · S/N 18266361N759YMJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266365N759YQPreston Dan R · Medway, MABuilt 1978 · S/N 18266368N759YRDoss Michael G · Austin, TXBuilt 1978 · S/N 18266369N759YSBowers LLC · Englewood, COBuilt 1978 · S/N 18266370N759YURegistered aircraftBuilt 1978 · S/N 18266372N759YWChamberlain Diane L · Houston, TXS/N 18266374N759YXMagee Thomas J · Pasadena, CABuilt 1978 · S/N 18266375N759YYWainwright LLC · Mesa, AZFirst renewal noticeS/N 18266376N759ZDN759zd LLC · Stratford, CTBuilt 1978 · S/N 18266381N759ZETransair Leasing Inc · Miami, FLBuilt 1978 · S/N 18266382N759ZHHatch George R · Avon, MABuilt 1978 · S/N 18266385N759ZKShelley James R · Bowling Green, KYBuilt 1978 · S/N 18266387N759ZMN759zm LLC · Fort Collins, COBuilt 1978 · S/N 18266389N759ZQSlone Bryan E · Omaha, NEBuilt 1978 · S/N 18266392N759ZTSherck Nicholas · Woodbridge, NJBuilt 1978 · S/N 18266395N759ZUFlying Bobcat LLC · Boise, IDS/N 18266396N75ALTeebagy Steven C · Wellington, FLBuilt 1973 · S/N 17701927N75BNBernic Inc Trustee · Wilmington, DEBuilt 2000 · S/N 18280909N75CWilliam Roy S · Kendallville, INBuilt 1978 · S/N 18503664N75CGRichter Aviation Inc · Maxwell, CABuilt 1973 · S/N 18502214N75DAHenderson John L · Ozona, TXBuilt 1979 · S/N 21063172N75DKPaul Mark A · Warren, OHS/N U20603217N75DMPro-Rentals Inc · Athens, OHBuilt 1976 · S/N 21061430N75DWBliss Gregory A · Saint Johns, FLBuilt 1975 · S/N 18263906N75EAero Techniques Inc · Portage, MIBuilt 1966 · S/N 17255365N75EELgc Consulting Inc · Salisbury, NCBuilt 1975 · S/N 21060837N75ERFaulkner John · Urbana, OHBuilt 1977 · S/N 17269776N75FBPhillips Brandon S · Susanville, CABuilt 1966 · S/N 18051707N75FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12938N75GLSkyshare LLC · Boulder, COBuilt 1973 · S/N 21059814N75KBJoseph Carter Realty Inc · Jasper, ALBuilt 2022 · S/N 18283185N75LERegistered aircraftBuilt 1965 · S/N 185-0870N75MLLowe John Howard II · Tifton, GABuilt 1964 · S/N 18255505N75NSJohnson Dale B · Steele, NDBuilt 1968 · S/N 17257539N75NXAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 33701660N75PDHaher Thomas R · Tully, NYBuilt 2000 · S/N 18280683N75PJJohnson Peter G · Tower, MNBuilt 1975 · S/N U20602705N75RBBarr Air Patrol LLC · Mesquite, TXS/N 18280011N75RCJoffe Zalman · Bahama, NCBuilt 1981 · S/N 21064325N75SDVimco N75sd LLC · El Paso, TXBuilt 1973 · S/N 17260829
Back to AD 79-10-14 R1