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.

N5060RBristow Brent L · Anchorage, AKFirst renewal noticeBuilt 1976 · S/N 18502992N50610Henry Mark Alan · Dickinson, TXS/N 15069431N50614Walker William G Jr · Scottsdale, AZBuilt 1968 · S/N 15069434N50617Adventist World Aviation · Wilson, NCS/N 15069436N50618Clark Christopher W · Fallon, NVBuilt 1968 · S/N 15069437N5061ASmith Aviation LLC · Springer, OKS/N 28061N50621Slade Michael · Lakeville, MABuilt 1968 · S/N 15069439N50624Davis Clint A · Fairland, INBuilt 1968 · S/N 15069442N50628Padgett Justin S · Fruithurst, ALBuilt 1968 · S/N 15069445N50629Boshart Stanley J · Albany, ORBuilt 1968 · S/N 15069446N5062RRichland County Finance Department · Columbia, SCBuilt 1974 · S/N 17263300N5062UEnglish Ryan E · Henderson, NVBuilt 1964 · S/N 206-0062N50633Sherwood Ronald R · Kathleen, GABuilt 1968 · S/N 15069449N5063EAdams James R · Prescott, AZS/N 50363N5063HParsons William L · Harrogate, TNBuilt 1975 · S/N 17265324N50641Jstram Lc · Sheridan, WYBuilt 1968 · S/N 15069454N5064DPershing Flying Club Inc · Lovelock, NVBuilt 1958 · S/N 51164N5064HFranklin Air Services LLC · New Orleans, LABuilt 1975 · S/N 17265325N50652Omlid Robert L · Watford City, NDBuilt 1968 · S/N 15069461N5065DWharton Edwin Scott · Anchorage, AKBuilt 1958 · S/N 51165N5065ERickman Wanda M · Absarokee, MTBuilt 1958 · S/N 50365N50663Zimna Grazyna · KrasocinS/N 15069467N50665Meneely Robert W · Los Altos Hills, CAS/N 15069469N5066AThordarson Norman K · Friday Harbor, WABuilt 1955 · S/N 28066N5066DCurry Timothy S · Salisbury, MDBuilt 1958 · S/N 51166N5066RBurke William M · Norwalk, CTBuilt 1974 · S/N 17263304N50672Registered aircraftBuilt 1968 · S/N 15069476N50679Go Fly Ez LLC · Athens, OHBuilt 1968 · S/N 15069480N5067ADaniels Tim · Unalakleet, AKBuilt 1955 · S/N 28067N5067ERickenbach Rodd L Trustee · Denver, COBuilt 1958 · S/N 50367N5067HSanders Flight Training Center Inc · Jasper, ALS/N 17265326N50688Hershey Andrew C · Manchester, NHBuilt 1968 · S/N 15069485N50691Layka'S Choice LLC · Lawrenceville, GABuilt 1968 · S/N 15069487N50695Mannfolk Steven M · Wingdale, NYS/N 15069489N50696Winsor Andrew · Medford, MAS/N 15069490N50697Cole Timothy Les · Las Vegas, NVBuilt 1968 · S/N 15069491N5069ANusz Russell I · Hitchcock, OKBuilt 1953 · S/N 28069N5069HNehring Curtis A · Goleta, CABuilt 1975 · S/N 17265327N506EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12857N506SPHenrie Aviation LLC · Fairfield, NJBuilt 2000 · S/N 172S8363N506YZR&R Gray Equipment & Cattle LLC · Enid, OKS/N 21059139N50704Fox Valley Technical College · Oshkosh, WIBuilt 1968 · S/N 15069496N50706Rhoades Charles E · Blessing, TXFirst renewal noticeS/N 15069498N50717Road Robert L · Fargo, NDBuilt 1968 · S/N 15069504N5071AMccanles Mike E · Adrian, MOBuilt 1955 · S/N 28071N5071DAcmx LLC · Cedar Rapids, IAS/N 51171N5071HFosse David K · Carbondale, ILS/N 17265329N50720Smith Bruce Allan · Phelps, KYBuilt 1968 · S/N 15069506N50728Erickson Aeronautics LLC · Perry, IABuilt 1968 · S/N 15069512N50729Blue Sky 6 LLC · Torrance, CAS/N 15069513
Back to AD 79-10-14 R1