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.

N2762MRaymond Mark A · East Jordan, MIBuilt 1946 · S/N 12-1158N2765MExperimental Aircraft Association Chapter 1218 · Willow Springs, MOBuilt 1946 · S/N 12-1167N2770MThissell David W · Plymouth, MABuilt 1946 · S/N 12-1149N2772MDexter Fred H · Live Oak, FLBuilt 1946 · S/N 12-1245N2773MWinby Elize Aj · Palo Alto, CABuilt 1946 · S/N 12-1247N2778MMiller Benny · Canutillo, TXBuilt 1946 · S/N 12-1159N2780MHerrington James W · Locust Grove, GAFirst renewal noticeBuilt 1946 · S/N 12-1168N2784MWarwick Steven D · Middletown, DEBuilt 1946 · S/N 12-1165N2785MWood Gregory M · North Pole, AKS/N 12-1164N2789MDagostino Scott J · Bozeman, MTBuilt 1946 · S/N 12-1184N2794MRifenburg Brian K · Ward Cove, AKS/N 12-1252N27DSWillis Bernie W · Wasilla, AKBuilt 1947 · S/N 12-2654N2800DHamann Russell M · Clear Lake, SDBuilt 1947 · S/N 12-1637N2808MJensen John C · Mccleary, WAS/N 12-1261N2809MCarlos Sean N · Togiak, AKBuilt 1946 · S/N 12-1265N2810MDavis Ronald L Jr · Soldotna, AKBuilt 1946 · S/N 12-1263N2814MBruggeman Michael J · Saint Paul, MNBuilt 1946 · S/N 12-1182N2819MDzr Enterprises LLC · Missoula, MTBuilt 1946 · S/N 12-1174N2820MFlynt Gary J · Baytown, TXBuilt 1946 · S/N 12-1172N2821MPacker Louis M · Wasilla, AKBuilt 1946 · S/N 12-1171N2823MFedorka Paul R Trustee · Soldotna, AKBuilt 1946 · S/N 12-1409N2827MAdams James M · Pontiac, ILBuilt 1946 · S/N 12-1306N2829MAlaska Media LLC · Anchorage, AKBuilt 1946 · S/N 12-1266N2830MMullins Esten R · El Paso, TXS/N 12-1267N2836MSwihart Matthew S · Hood River, ORBuilt 1946 · S/N 12-1273N2845MBrasher Kerry W · Scotts Hill, TNBuilt 1946 · S/N 12-1191N2849M49 Mike Partnership · Erie, COBuilt 1947 · S/N 12-1402N2850MHarvey Timothy A · Colusa, CABuilt 1946 · S/N 12-1190N2853MH&M Aviation · Hazelton, NDBuilt 1946 · S/N 12-1187N2862MFrederick David · Juneau, AKBuilt 1946 · S/N 12-1285N2870MJohnson James F · Florence, MTBuilt 1946 · S/N 12-1199N2875MSzumal Brent · Wasilla, AKBuilt 1946 · S/N 12-1404N2876MJohnson William A · Dillingham, AKS/N 12-1304N2880MAbalama Arthur C · Bethel, AKBuilt 1946 · S/N 12-1309N2883MRegistered aircraftBuilt 1946 · S/N 12-1423N2888MLapoint Daniel L Jr · Bellevue, MIBuilt 1946 · S/N 12-1426N2892MFoster Randy · La Grange, TXBuilt 1947 · S/N 12-1311N2898MPutman John Vick · San Antonio, TXBuilt 1946 · S/N 12-1434N2901MRickard William A · Virginia Beach, VABuilt 1946 · S/N 12-1325N2902MKelsey Michael O · Carey, IDBuilt 1946 · S/N 12-1362N2903MKrog Steven L · Hartford, WIBuilt 1946 · S/N 12-1327N2904MLange Keith J · Wasilla, AKBuilt 1946 · S/N 12-1318N2906MFry Steven G · Eagle River, AKBuilt 1946 · S/N 12-1321N2907MKutschera Thomas C · Youngsville, NYBuilt 1946 · S/N 12-1322N2910MEkdahl John Edward · Freehold, NJBuilt 1946 · S/N 12-1436N2913MMccay Brian D · Earlysville, VABuilt 1946 · S/N 12-1444N2914MPannone Steven R · Palmer, AKBuilt 1947 · S/N 12-1334N2916MBradford Murvin L · Hensley, ARS/N 12-1417N2918MGuess Gerald Bryan · Hernando, FLS/N 12-1419N2919MPiccione Joseph A · Washington, NJBuilt 1946 · S/N 12-1427
Back to AD 76-06-06