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.

N666JVWalter Jack N · Meadville, PABuilt 1972 · S/N 17260737N666MGGragg Mervyn C · East Wenatchee, WAS/N 15073977N666MHBenson Shawn E · Rock Hill, SCBuilt 1975 · S/N 17266101N666MMLawson Robert W · Tacoma, WABuilt 1971 · S/N 17701633N666RBOlam Holdings LLC · Honolulu, HIS/N 17700051N666RJNewitt David C · Oakland, CABuilt 1976 · S/N 177RG0902N666RMBrown Conrad · Beaverton, ORBuilt 1975 · S/N 18263853N666SBBredin Robert R · Pacific Palisades, CABuilt 1980 · S/N 18503994N666WPHamilton Stuart E · Covington, GABuilt 1979 · S/N 18266914N66700Red Barn Aircraft LLC · Highland, WIBuilt 1974 · S/N 15076218N66704Sale Reported · Le GosierSale reported, pending cancellationBuilt 1974 · S/N 15076221N66707Tarr Sheryl Lynn · Spokane, WABuilt 1974 · S/N 15076224N66708Liberty University Inc · Lynchburg, VABuilt 1974 · S/N 15076225N66709Smith Micheline Diane · St George, UTBuilt 1974 · S/N 15076226N6670EMacfadden Gary D · Condon, MTS/N 56170N6670FWare Edward A Jr · Nicholson, PABuilt 1966 · S/N 15063270N6670HMcinnis Jody · Hillman, MIBuilt 1975 · S/N 17265530N6670MLbl Flyers LLC · Depoe Bay, ORBuilt 1975 · S/N 18263794N66717Sherman Aviation LLC · Fairfield, NJBuilt 1983 · S/N 17275991N66718Schmitt Rudy · Brookshire, TXBuilt 1974 · S/N 15076232N6671ABurke John E · Spring, TXBuilt 1956 · S/N 28771N6671EAnderas Per R · Green Bay, WIBuilt 1959 · S/N 56171N6671FAntinarelli Peter J · Hickory, NCBuilt 1966 · S/N 15063271N6671PLunn Frank Paul III · Chatham, NHBuilt 1974 · S/N 17264371N66723Armstrong Paul D · Stillwater, OKS/N 15076233N66728Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 15076237N6672AVandenbark Cody M · Troy, IDBuilt 1956 · S/N 28772N6672EKing Aubrey R · Salinas, CABuilt 1959 · S/N 56172N6672FRodriguez Cory Omarr · Abilene, TXBuilt 1966 · S/N 15063272N6672HDavenport Thomas C · Buchanan Dam, TXS/N 17265531N6672SPikul Daniel J · Monson, MABuilt 1967 · S/N 15067472N66730Glau John E · Centennial, COBuilt 1974 · S/N 15076239N66735Ryan Adrian · Anchorage, AKS/N 18052956N66736Klein Todd · Winston Salem, NCBuilt 1974 · S/N 15076241N66738Irvin Bradley A · Lula, GABuilt 1974 · S/N 15076242N66739Airgo Inc · Centralia, ILBuilt 1974 · S/N 15076243N6673ASearson Jason C · Newton, NCBuilt 1956 · S/N 28773N6673EMiller Daniel F · Grain Valley, MOBuilt 1959 · S/N 56173N6673FKysar Ian R · Battle Ground, WABuilt 1966 · S/N 15063273N66745H T Productions Inc · Grayling, MIBuilt 1974 · S/N 15076246N66748Skypark Inc · Wadsworth, OHBuilt 1974 · S/N 15076249N6674AThomas Craig S · Salem, ORBuilt 1956 · S/N 28774N6674FBon Investment Holdings LLC · Zephyrhills, FLBuilt 1966 · S/N 15063274N6674GJoe Dory Aviation LLC · Caldwell, IDBuilt 1970 · S/N 15072174N66751Talmage Timothy A · Azle, TXBuilt 1974 · S/N 15076251N66753Andreasen Trevor C · Springville, UTBuilt 1974 · S/N 15076252N66755Fischer A Edward Jr · Hampstead, NHBuilt 1974 · S/N 15076253N66756Listzwan James · High Springs, FLBuilt 1974 · S/N 15076254N66758Dahlberg James C · Ogilvie, MNBuilt 1974 · S/N 15076255N6675ETornquist Robert John Jr · Turlock, CABuilt 1959 · S/N 56175
Back to AD 79-10-14 R1