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.

N738YHWebster Deryl Thomas · Angola, INBuilt 1978 · S/N 17270338N738YJOzarka College · Melbourne, ARBuilt 1978 · S/N 17270339N738YLCarter Flygare Inc · Sacramento, CABuilt 1978 · S/N 17270341N738YPFuselier Byron · Rayne, LABuilt 1978 · S/N 17270344N738YRYankee Romeo LLC · Wilmington, DEBuilt 1978 · S/N 17270346N738YSHood Jerry R · Double Springs, ALBuilt 1978 · S/N 17270347N738YTB2fh Ltd · Allentown, NJBuilt 1978 · S/N 17270348N738YWLeemon Kenneth V · Scottsdale, AZBuilt 1978 · S/N 17270351N738YXHogan Patrick B · Simpsonville, SCBuilt 1978 · S/N 17270352N738YZHotton Ralph A · Canton, MIBuilt 1978 · S/N 17270354N738ZASale Reported · Ogden, UTSale reportedBuilt 1978 · S/N 17270355N738ZCN738zc LLC · Tallahassee, FLBuilt 1978 · S/N 17270357N738ZDChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N 17270358N738ZELagow Virgil M Ll · Muskogee, OKS/N 17270359N738ZFMann Don R · Mount Vernon, OHBuilt 1978 · S/N 17270360N738ZGPopescu Daniel · Nokesville, VABuilt 1978 · S/N 17270361N738ZHRegistration Pending · La Porte, TXRegistration pendingBuilt 1978 · S/N 17270362N738ZLGoyal Vishal · Walnut Creek, CABuilt 1978 · S/N 17270365N738ZMAero Lease And Trading LLC · Miami, FLBuilt 1978 · S/N 17270366N738ZNRobins David B · Lander, WYBuilt 1978 · S/N 17270367N738ZQRieman Joel · Lompoc, CABuilt 1978 · S/N 17270369N738ZRFicus Point Aviation Corporation Inc · Middletown, DEBuilt 1978 · S/N 17270370N738ZTSp Airparts LLC · Moscow, IDBuilt 1978 · S/N 17270372N738ZUSkydance Aviation LLC · Chesapeake, VABuilt 1978 · S/N 17270373N738ZYRegistration Pending · Syracuse, NYRegistration pendingBuilt 1978 · S/N 17270377N73900Dewey William B · Santa Barbara, CABuilt 1977 · S/N 17267737N73904Vaayu Aviation LLC · Newark, CABuilt 1976 · S/N 17267739N7390MBechtel Jerold L · Snover, MIBuilt 1958 · S/N 55690N7390QChesmore Daniel R · Ten Mile, TNBuilt 1972 · S/N 18261030N7390XTruesdell Ronald W · Edgewater, FLBuilt 1961 · S/N 15059490N73910Arispe Aviation LLC · Mckinney, TXBuilt 1976 · S/N 17267741N73917Wingsleasing LLC · Wichita, KSBuilt 1976 · S/N 17267744N7391AMitchell Vernon · Waxahachie, TXBuilt 1957 · S/N 29491N7391MAnderson Richard A · Sycamore, ILBuilt 1958 · S/N 55691N7391TAngell Toby L · Stillwater, OKBuilt 1959 · S/N 46991N73922Mouton Charles J Jr · Gladewater, TXBuilt 1976 · S/N 17267746N73923Professional Aviation Aircraft Services Ltd · New Philadelphia, OHBuilt 1976 · S/N 17267747N73924Mack Aviation Holdings LLC · Atlanta, GABuilt 1976 · S/N 17267748N73925Wings Over Texas Holdings LLC · Denton, TXS/N 17267749N73926Hatanaka Brandon C · Loveland, COBuilt 1976 · S/N 17267750N73927Abcd Ventures LLC · Ada, OKBuilt 1976 · S/N 17267751N73928Air Peanut Ltd · Wilmington, DEBuilt 1976 · S/N 17267752N73929Jprg Aviation Inc · Orlando, FLBuilt 1976 · S/N 17267753N7392MSantana Marcos · Concord, NCS/N 55692N7392USpernak Airways Inc · Anchorage, AKFirst renewal noticeBuilt 1978 · S/N 20700435N73930Bunke Paul R Trustee · Harrison, OHBuilt 1976 · S/N 17267754N73934Hanson Alexander P · Bremerton, WABuilt 1976 · S/N 17267755N73938Preston Richard R Trustee · Albuquerque, NMBuilt 1976 · S/N 17267757N7393EN7393 LLC · Saint Augustine, FLBuilt 1960 · S/N 57093N7393GBlue Wings LLC · Brecksville, OHBuilt 1970 · S/N 17259093
Back to AD 79-10-14 R1