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.

N9142TLjungkvist Kristian · Ashland, ORBuilt 1959 · S/N 50642N91430N91430 LLC · San Antonio, TXBuilt 1969 · S/N 18052080N91439Mod Flying LLC · Elkhorn, NEBuilt 1969 · S/N 18052085N9143ACacka David A · Klamath Falls, ORBuilt 1949 · S/N 18904N9143USherer Preston A · Watertown, WIBuilt 1976 · S/N 15078094N9144BMason Matthew L · Lincoln, ILBuilt 1958 · S/N 36744N9144GZimmerman Paul B · Haswell, COBuilt 1971 · S/N 18260684N9144MRobertson James D · Liberty, MOBuilt 1977 · S/N 21062065N9144XWinsome Ag Services LLC · Johnson, KSBuilt 1961 · S/N 18253544N91451Pettus Const Inc · Dallas, GABuilt 1973 · S/N 18262004N9145AWomack Wilbur A Jr · Jackson, LABuilt 1949 · S/N 18906N9145GYost James J · Placentia, CABuilt 1971 · S/N 18260685N9145USharp Wayne H · Mena, ARBuilt 1976 · S/N 15078096N91464Breard Armand C · Monroe, LABuilt 1969 · S/N 18052091N9146AHusser Marilyn G · Independence, ORS/N 18907N9146GShea Bernie J · Polson, MTBuilt 1971 · S/N 18260686N9146MJc Aircraft Leasing LLC · Wasilla, AKBuilt 1970 · S/N U20601546N9146XMangun Charles L · Middleton, IDBuilt 1961 · S/N 18253546N91470Sky Sailing Inc · Warner Springs, CABuilt 1969 · S/N 18052094N91475Johnson Robert L · Douglas, AKBuilt 1969 · S/N 18052097N91476Petersen Greg · Chelan, WABuilt 1969 · S/N 18052098N9147BReed Zane · Mountain Home, IDBuilt 1958 · S/N 36747N9147CCope Eric E · Angels Camp, CABuilt 1954 · S/N 31246N9147GSnyder Barry L · Morrison, COBuilt 1971 · S/N 18260687N91484Scovel Simeon Edwin · Ontario, CABuilt 1973 · S/N 18262006N91489Dan River Aero Club Inc · Jonesville, NCBuilt 1973 · S/N 18262008N9148MBlackhole Inc · Round Rock, TXBuilt 1976 · S/N 18264702N9149BFoust Kal E · Lenox, MIBuilt 1958 · S/N 36749N9149MBoynton Scott E · Campbell Hall, NYBuilt 1970 · S/N U20601549N914AVNorcal Skydiving LLC · Cloverdale, CABuilt 1964 · S/N 18255445N914AZN969az LLC · Miami, FLBuilt 1985 · S/N 17276379N914CBChan Blair H · Arlington, TXBuilt 1977 · S/N R1722705N914EYDreimiller Raymond J Jr · Bloomfield, NYBuilt 1976 · S/N 15079131N914FCSinibaldi Glenn · Highland Park, NJBuilt 1969 · S/N 18052086N914HSHis Wings Air Service Inc · Hyder, AKS/N 185-0429N914JBSwartz Eric C Trustee · Aptos, CABuilt 2000 · S/N 18280786N914JDAis Wings LLC · Grand Rapids, MIBuilt 1972 · S/N 17261296N914MDCrum Brian B · Warrensburg, MOS/N 51014N914RLNichols Charles C · Hanford, CABuilt 2004 · S/N 18281399N914RRMartinez Jeff L · Lewistown, MTS/N 17264508N914SCHotel Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13438N914STAir Ex LLC · Chelan, WABuilt 1980 · S/N 18504010N914SWSilver Express Co DBA · Miami, FLBuilt 1999 · S/N 172S8160N914ZSkylens LLC · Hammond, LABuilt 1974 · S/N 17264444N91507Eagle Aviation LLC · Spearfish, SDBuilt 1973 · S/N 17261499N91508Stewart Bryan P · Carson City, NVBuilt 1969 · S/N 18259798N91509Watts Timothy R · Hermiston, ORS/N 18259799N9150BHarral Blake · Prescott Valley, AZFirst renewal noticeBuilt 1958 · S/N 36750N9150CAkers Joel W · Anchorage, AKBuilt 1954 · S/N 31249N9150HN9150h LLC · Charleston, SCBuilt 1975 · S/N 17265975
Back to AD 79-10-14 R1