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.

N4674CN&C Enterprises LLC · Vine Grove, KYBuilt 1953 · S/N 25618N4674EMilliken Bradley B · San Mateo, CABuilt 1982 · S/N 18268258N4674UKlein David · Sebastopol, CABuilt 1983 · S/N 21064802N4674XSaunders Christopher · Lehighton, PABuilt 1966 · S/N 15064724N4675CLane Robert W · Palmer, AKBuilt 1974 · S/N 18502592N4675ERojo Aircraft LLC · Mesquite, NVBuilt 1982 · S/N 18268259N4675XBlalock Merrel K III · Mayflower, ARS/N 15064725N4676BRobbins J Putnam · Valparaiso, INBuilt 1955 · S/N 31574N4677CRegistered aircraftBuilt 1953 · S/N 25621N4677LJet Airways Express Inc · Aventura, FLBuilt 1966 · S/N 17254672N4677QDahl Larry A · Cogswell, NDBuilt 1972 · S/N 21059577N4677XBaird Harvey L · Sharon, OKFirst renewal noticeS/N 15064727N4678BKing Paul E · Albany, ORBuilt 1955 · S/N 31576N4678FMullett Sean · Cleveland, TNBuilt 1966 · S/N P206-0278N4678KGarcia Roberto P · Spring Hill, FLFirst renewal noticeBuilt 1975 · S/N 18263679N4678QPrairie Dog Aviation LLC · Sioux Falls, SDBuilt 1972 · S/N 21059578N4679AFlying Bulldogs LLC · Joplin, MOBuilt 1956 · S/N 32276N4679CDahl Dan P · Wasilla, AKBuilt 1953 · S/N 25623N4679GFlightime Inc · Elkhart, INS/N 17273305N4679LFitting Solutions Lc · Chester, NJBuilt 1966 · S/N 17254674N4679UNelson Ross R · Menomonie, WIBuilt 1964 · S/N 18051379N4679XVentura Joel · Andover, MABuilt 1966 · S/N 15064729N4679YExtreme Air LLC · Cottage Grove, WIBuilt 1980 · S/N 21063983N467AT467at LLC · Frankfort, ILBuilt 1968 · S/N 17700879N467CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280859N467DHLopez Floyd W · Arroyo Seco, NMBuilt 1960 · S/N 57142N467ERWingsleasing LLC · Wichita, KSS/N 172S10287N467QStegner John J · Boonville, MOBuilt 1976 · S/N 17266649N467TSPsl Surveys · Manassas, VABuilt 2010 · S/N 18282239N4680KIntrepid Red Baron Inc · New Franken, WIBuilt 1975 · S/N 18263681N4680LWasilowski Steven P · Elgin, ILBuilt 1966 · S/N 17254675N4680UFoster Randy · La Grange, TXBuilt 1964 · S/N 18051380N4681FFisher Adam · Corona, CABuilt 1966 · S/N P206-0281N4681KBluestone Ryan Joseph · Lake Havasu City, AZBuilt 1975 · S/N 18263682N4681LOmer Syeda · Gilroy, CAS/N 17254676N4681ZWhite Blaine Scott · Castlewood, VABuilt 1980 · S/N 32278N4682DBusch Craig D · Green Brook, NJBuilt 1979 · S/N 17272330N4682LJones Carl R · Little Rock, ARBuilt 1966 · S/N 17254677N4682QHangar 27 LLC · Bountiful, UTS/N 21059582N4682UWaddoups Max E III · Palmer, AKBuilt 1964 · S/N 18051382N4683GDeichert Ryan L · Bismarck, NDS/N 17273309N4683KKrohn Ronald C · Pauma Valley, CABuilt 1975 · S/N 18263684N4683LLawson Seth A · Morgantown, WVBuilt 1966 · S/N 17254678N4684AShilanski Micah V · Wasilla, AKBuilt 1956 · S/N 32281N4684LHowell Tyler L · Romoland, CABuilt 1966 · S/N 17254679N4685ARegistered aircraftBuilt 1956 · S/N 32282N4685FRulewicz Dennis G · Jackson, MIBuilt 1966 · S/N P206-0285N4685LEsquilin Steven C · Poway, CABuilt 1966 · S/N 17254680N4685XFite Robert G · Brookings, SDBuilt 1966 · S/N 15064735N4686BThompson Harrison C · Brookings, SDBuilt 1955 · S/N 31584
Back to AD 79-10-14 R1