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.

N7301THolte Martin W · Burnsville, MNBuilt 1959 · S/N 46901N73020Ajf Enterprises LLC · Des Moines, IABuilt 1976 · S/N 17267239N73028Halley Craig H · Lanai City, HIBuilt 1976 · S/N 17267241N7302ASkywagon Aero LLC · Wilmington, DEBuilt 1956 · S/N 29402N7302GSmith Neil W · Rincon, GABuilt 1970 · S/N 17259002N7302MKoenig Donald J · Las Animas, COBuilt 1958 · S/N 55602N7302NClark Frank C · Pinckney, MIBuilt 1974 · S/N 18263088N7302QDuckworth Bill J · Epps, LAS/N 18260942N7302TSchaff James F · Prescott, AZBuilt 1959 · S/N 46902N7302XGlover Thomas · Marana, AZBuilt 1961 · S/N 15059402N73036Johnson Deborah K · Fairbanks, AKBuilt 1979 · S/N 20700555N7303ALogajan James M · Rapid City, SDBuilt 1956 · S/N 29403N7303GGolden Greg J · Thurman, IABuilt 1973 · S/N 15074640N7303MHerbert Robert Leo · Ammon, IDBuilt 1958 · S/N 55603N7303NJordan James D · Paradise, TXBuilt 1979 · S/N 21063218N7303XBosch Kent D · Montevideo, MNBuilt 1961 · S/N 15059403N73040Goulding Brian K · Roswell, GABuilt 1976 · S/N 17267247N73041Max Air Aviation LLC · Carrollton, GABuilt 1976 · S/N 17267248N73043Six Ten Ventures LLC · Cedar Hill, TXBuilt 1976 · S/N 17267250N73047Spernak Airways Inc · Anchorage, AKFirst renewal noticeBuilt 1979 · S/N 20700556N7304GChapman David C · Summersville, WVBuilt 1970 · S/N 17259004N7304NCoastal Aviation Export LLC · Wilmington, DEBuilt 1976 · S/N U20603607N73054Blue Wings LLC · Spokane, WABuilt 1976 · S/N 17267253N7305AK&M Aviation LLC · West Liberty, KYS/N 29405N7305QWolding Mylo D · New Town, NDBuilt 1971 · S/N 18260945N7305SJones Keith J · Tucson, AZBuilt 1976 · S/N 18265098N7305URyan Air Inc · Anchorage, AKBuilt 1977 · S/N 20700392N73063Oregon State Flying Club · Corvallis, ORBuilt 1976 · S/N 17267256N73064Whitelam Bruce R · Sacramento, CABuilt 1976 · S/N 17267257N73067Grant Aviation Inc · Anchorage, AKBuilt 1979 · S/N 20700558N73068Christensen Gary D · Alliance, NEFirst renewal noticeBuilt 1976 · S/N 17267259N73069Eagle Sky Patrol Inc · Deadwood, SDBuilt 1976 · S/N 17267260N7306AFloyd Ckyler Don · Bowman, NDS/N 29406N7306EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17272081N7306QOllee Air LLC · Smithfield, UTBuilt 1971 · S/N 18260946N7306SBennett Aviation LLC · New York, NYBuilt 1976 · S/N 18265099N7306TFaull Ron W · Sandpoint, IDS/N 46906N7307ACook Raymond L · Clarksville, TNBuilt 1956 · S/N 29407N7307NLow Michael E · Hurricane, UTBuilt 1974 · S/N 18263093N7307QN7307q LLC · Wickenburg, AZBuilt 1978 · S/N 18503600N7307SDunlap Michael L · Haymarket, VABuilt 1976 · S/N 18265100N73088Kalivas William Nick · Dallas, TXBuilt 1961 · S/N 18051027N7308GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259008N7308TBerg Weston L · Stanton, NDBuilt 1959 · S/N 46908N7308XEsmond Emmett W · Seattle, WABuilt 1961 · S/N 15059408N73091Rudder33 LLC · Grantham, NHBuilt 1976 · S/N 17267261N73093Yngsdal Dale A · Lino Lakes, MNBuilt 1976 · S/N 17267262N7309MDunn Louis Jr · Mooresville, NCS/N 55609N7309NMartyn Michael L · Inyokern, CAFirst renewal noticeBuilt 1974 · S/N 18263095N7309QWayne Kenneth B · Sonoma, CABuilt 1972 · S/N 18260949
Back to AD 79-10-14 R1