AD 76-06-06

Registered aircraft · 1,247

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:76-06-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-06-06')
  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.

N2640MStraight Gary D · Wasilla, AKBuilt 1946 · S/N 12-982N2641MGeorge Gary D · Humble, TXBuilt 1946 · S/N 12-983N2642MLons Travis W · King Salmon, AKBuilt 1946 · S/N 12-984N2645MSchwenke-Cram Kim · Madison, SDBuilt 1946 · S/N 12-979N2646MBelanger Bette · Wasilla, AKBuilt 1946 · S/N 12-1143N2655MRenneke Wiest Lynnette E · Le Sueur, MNBuilt 1946 · S/N 12-978N2656MHaggstrom Daryl V · Fairbanks, AKBuilt 1946 · S/N 12-968N2657MCurtis Christopher J · Wasilla, AKBuilt 1946 · S/N 12-970N2665MProsser William C · Wasilla, AKBuilt 1947 · S/N 12-993N2666MBurt David R Jr · Justin, TXBuilt 1946 · S/N 12-1109N2671MZoch Lori R · Port Orange, FLBuilt 1946 · S/N 12-972N2674MStarr LLC · Superior, WIBuilt 1946 · S/N 12-1107N2677ML & L Farms · Richvale, CABuilt 1946 · S/N 12-1095N2681MHebrink Jason R · Grand Rapids, MNBuilt 1946 · S/N 12-1112N2682MDavis Philip L · Spring Hill, TNBuilt 1946 · S/N 12-1113N2683MBeach Banners Inc · Jacksonville, FLBuilt 1946 · S/N 12-1114N2684MGrangruth Rory A · Wadena, MNBuilt 1954 · S/N 12-997N2686MCummings Scott Alan · Monitor, WABuilt 1946 · S/N 12-999N2687MWilkes Gary W · Lakeland, FLBuilt 1946 · S/N 12-1117N2689MKuehni Steven A · Stanley, WIBuilt 1946 · S/N 12-1200N2691MHartmaier Robert S Jr · Monroe Township, NJBuilt 1946 · S/N 12-1121N2692MOnstott Norman V · Mount Pleasant, MIBuilt 1946 · S/N 12-1122N2694MSwartz William L · Cumb Foreside, MEBuilt 1946 · S/N 12-1206N2699MJohnson George W · Seattle, WAS/N 12-1203N26QQHauser Family Flying LLC · Mount Pleasant, PABuilt 1946 · S/N 12-605N2701MBaltrum Daniel R · Ester, AKBuilt 1946 · S/N 12-1205N2706MEs LLC · Tulsa, OKBuilt 1946 · S/N 12-1209N2707MKarpik Joseph Paul · Floodwood, MNBuilt 1946 · S/N 12-1210N2708MKiceniuk Taras · Santa Paula, CAS/N 12-1211N2712MCardinal Adventures LLC · Green Bay, WIBuilt 1946 · S/N 12-1127N2713MBeacon West LLC · Billings, MTBuilt 1946 · S/N 12-1126N2718MLibby Justin C · Anchorage, AKBuilt 1946 · S/N 12-1215N2719MCenter Charles C · Wasilla, AKBuilt 1946 · S/N 12-1216N2720MCalderwood Kenneth E · Kenai, AKBuilt 1946 · S/N 12-1220N2722MInfinity Aviation LLC · Piedmont, SDBuilt 1946 · S/N 12-1133N2732MEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1946 · S/N 12-1225N2734MGraves Dorel E · Danville, INBuilt 1946 · S/N 12-1226N2735MScott Chase · Anchorage, AKBuilt 1946 · S/N 12-1138N2736MBrummer Christopher P · Wasilla, AKBuilt 1946 · S/N 12-1137N2737MGautreau Peter F · Chickaloon, AKBuilt 1946 · S/N 12-1141N2738MKerner Frank W · Saint Charles, MOBuilt 1946 · S/N 12-1227N2740MWroe Daniel C · Denton, MDS/N 12-1230N2743MKemp Dale W · Lampasas, TXBuilt 1946 · S/N 12-1229N2746MStonecipher Wayne H · Yamhill, ORBuilt 1947 · S/N 12-1233N2747MGuy Vaughn Zindel III · Eden, UTBuilt 1946 · S/N 12-1234N2748MLathrop Patrick W · Kent, WABuilt 1946 · S/N 12-1235N2754MWheaton Lee H · Patten, MEBuilt 1946 · S/N 12-1241N2755MKerwin Peter M · Naperville, ILBuilt 1946 · S/N 12-1240N2757MHaring Clay · Lincoln, KSBuilt 1946 · S/N 121238N2758MHaring Clay · Lincoln, KSBuilt 1946 · S/N 12-1154
Back to AD 76-06-06