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.

N4384UMarkey William C · Wenatchee, WAFirst renewal noticeS/N 15060384N4385BDorris Michael R · Mccall, IDBuilt 1956 · S/N 26729N4385QKulis Richard W · Gill, MABuilt 1971 · S/N 17260285N4385RAnderson Kenneth J · Norman, OKBuilt 1974 · S/N 17263135N43860Friends Of Army Aviation · Ozark, ALS/N R172-0124N4386RFlying H LLC · Lake Placid, FLBuilt 1974 · S/N 17263136N4387BN4387b LLC · Sheridan, ARBuilt 1955 · S/N 26731N4387QCrose Merrill L · Sibley, MOBuilt 1971 · S/N 17260287N4387UR&M Steel Co Inc · Caldwell, IDBuilt 1964 · S/N 15060387N4388BHanke Lowell E · Deerbrook, WIBuilt 1955 · S/N 26732N4388RSunrise Aviation Inc · Ormond Beach, FLBuilt 1974 · S/N 17263138N4389BVogel Max R · Havre, MTBuilt 1955 · S/N 26733N4389LOdell John J · Salinas, CABuilt 1966 · S/N 17254470N4389QMellinger Jason C · North Pole, AKS/N 17260289N438CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 18283345N438ERMorey Airplane Company Inc · Middleton, WIBuilt 2001 · S/N 172S8934N438SATwopro Energy Services LLC · Odessa, TXBuilt 2016 · S/N 18282421N438SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2018 · S/N 172S12225N4390LAero Science International LLC · Martinez, GABuilt 1966 · S/N 17254471N4390QFlying Mermaid LLC · Aiea, HIBuilt 1971 · S/N 17260290N4390RBrown David R · Kent, WABuilt 1974 · S/N 17263140N4390VNamtvedt Erik · Wasilla, AKBuilt 1956 · S/N 28741N4391LVeness Matthew B Trustee · Fairborn, OHBuilt 1966 · S/N 17254472N4391QSpringville Flying Club · Spanish Fork, UTBuilt 1971 · S/N 17260291N4391RCheek Kenneth W · Yadkinville, NCBuilt 1974 · S/N 17263141N4392BBrooks Todd A · Vacaville, CAFirst renewal noticeBuilt 1955 · S/N 26736N4392QRose Denver W · Eubank, KYBuilt 1971 · S/N 17260292N4393BMiller Zachary · Anchorage, AKS/N 26737N4393QJkj Aviation LLC · Wilmington, NCBuilt 1971 · S/N 17260293N4393RHorizon Dreams LLC · Homer, GABuilt 1974 · S/N 17263143N4393URoberts Alan W · Emmetsburg, IABuilt 1964 · S/N 15060393N4394LR A Marsh Flying Club LLC · Williamson, GABuilt 1966 · S/N 17254475N4394QAircraft Resource Center Inc · Lakeville, MNBuilt 1971 · S/N 17260294N4394URawdon Robert C Jr · Hohenwald, TNBuilt 1964 · S/N 15060394N4395UMhaskar Advait S · Burlington, IABuilt 1964 · S/N 15060395N4396BRhett Martin C · Palmer, AKBuilt 1955 · S/N 26740N4396LDyer John F · Spring, TXBuilt 1966 · S/N 17254479N4396QBennett Barry J · Owasso, OKBuilt 1971 · S/N 17260296N4396UMetz Daniel J · Brighton, COS/N 15060396N4397QWingsleasing LLC · Wichita, KSS/N 17260297N4397RBuiqui Aerospace Corp · Kissimmee, FLBuilt 1974 · S/N 17263147N4398BEckert Paul E · Palmer, AKS/N 26742N4398LSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 17254481N4398RAlferman Thomas H · Hampton Bays, NYBuilt 1974 · S/N 17263148N4399BJohnston Dennis W · Temple, TXBuilt 1955 · S/N 26743N4399LEge Sidney J · Carlisle, PABuilt 1966 · S/N 17254482N4399QHoefly Christopher · Belleview, FLS/N 17260299N439CEMuller Jenny DBA · Cody, NEBuilt 1965 · S/N 17253171N439CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282355N439CSMarionneaux Law Firm LLC · Baton Rouge, LABuilt 2016 · S/N 18282429
Back to AD 79-10-14 R1