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.

N2489MBarker Gerald E · Weymouth, MAS/N 12-1695N2491MPope Geoffrey M · Bishop, CABuilt 1947 · S/N 12-1698N2492MSchaaf Terry L · Bowman, NDBuilt 1947 · S/N 12-1699N2493MDriver Kegan Thomas · Billings, MTS/N 12-1561N2499MC & C Sierra LLC · Jackson, WYBuilt 1947 · S/N 12-1566N2504MAerial Messages Leasing Co · Longwood, FLBuilt 1946 · S/N 12-1002N2505MSever Jeffrey D · Anchorage, AKBuilt 1946 · S/N 12-1003N2507MEller Ralph E · Wasilla, AKBuilt 1946 · S/N 12-1005N2511MAustin Air Cruisers LLC · Dripping Springs, TXS/N 12-1009N2513MFinley Joel H · Sandwich, MAS/N 12-911N251TGelvin Stanley M · Central, AKBuilt 1946 · S/N 12-254N2524MDd Leasing LLC · Aberdeen, IDBuilt 1946 · S/N 12-910N2526MTulin Donald J · Anchorage, AKS/N 12-1017N2528MJohnson Robert M · Mapleton, MES/N 12-1019N2531MCurtis Kevin R · Flushing, MIBuilt 1946 · S/N 12-1022N2533MJohnson Cory R · Owatonna, MNBuilt 1946 · S/N 12-925N2534MBooher John R · Eagle River, AKBuilt 1946 · S/N 12-926N2542MHudson Joseph M · Holly Springs, NCBuilt 1946 · S/N 12-1031N2544MDeaton Mark · Gig Harbor, WAS/N 12-1033N2545MCopenhaver Patrick J · Enumclaw, WABuilt 1946 · S/N 12-931N2547MCapozzi Tony · Seaford, DEBuilt 1946 · S/N 12-930N2549MOld Goat LLC · Wilmington, DEBuilt 1946 · S/N 12-928N2552MSchmidt Anthony D Jr · Jordan, MNBuilt 1946 · S/N 12-933N2553MRubbert Jan D · Upham, NDBuilt 1946 · S/N 12-1012N2554MLensegrav Leslie C · Meadow, SDBuilt 1946 · S/N 12-1013N2555MSchiller Jeffrey A · San Diego, CABuilt 1946 · S/N 12-1011N2556MTennyson Chad E · Ridgefield, WABuilt 1946 · S/N 12-1040N2557MSale Reported · Oklahoma City, OKSale reportedBuilt 1946 · S/N 12-934N2560MAicraft Leasing LLC · Orlando, FLBuilt 1946 · S/N 12-936N2563MDavidson Dan F · Ozona, TXBuilt 1946 · S/N 12-938N2564MMonger Douglas J · Helena, MTBuilt 1946 · S/N 12-937N2566MQuality Aviation Inc · Marana, AZBuilt 1946 · S/N 12-1045N2569MSp Airparts LLC · Moscow, IDBuilt 1946 · S/N 12-940N256DNau Howard A · Melba, IDBuilt 1947 · S/N 12-2903N2570MBills Nathan · Overland Park, KSS/N 12-921N2572MChieftain LLC · Hot Springs, ARS/N 12-941N2577MBales Colton E · Wasilla, AKBuilt 1946 · S/N 12-1051N2579MBarela Peter A · Wasilla, AKBuilt 1946 · S/N 12-946N257AWWright Laura J · Hagerstown, MDS/N 12-3304N2581MSpencer David W · Anchorage, AKBuilt 1947 · S/N 12-1049N2586MSmith Randall A C · North Pole, AKBuilt 1946 · S/N 12-1047N2591MFlyer One LLC · Palm Harbor, FLBuilt 1946 · S/N 12-950N2594MBertke Matthew B · Anchorage, AKS/N 12-1037N2608MEhrenfelt Linda Mae · Pierre, SDBuilt 1946 · S/N 12-1074N2612MGreenhalgh Janna L · Caldwell, IDBuilt 1946 · S/N 12-964N2615MKelsey Mike · Carey, IDBuilt 1946 · S/N 12-1079N2620MBooth Chance · Wasilla, AKBuilt 1946 · S/N 12-1091N2623MRegistration Pending · Anchorage, AKRegistration pendingBuilt 1956 · S/N 12-1092N2638MBooth Wade W · Palmer, AKBuilt 1946 · S/N 12-981N2639MPense Douglas H · Fairbanks, AKBuilt 1946 · S/N 12-977
Back to AD 76-06-06