AD 74-18-13

Registered aircraft · 1,642

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

N3797WCarter Thomas Shane · Pinetop, AZBuilt 1966 · S/N 32-725N37MVMonreal Michael · North Barrington, ILBuilt 1969 · S/N 32-40657N3800WJdj Transport LLC · Wilmington, DEBuilt 1966 · S/N 32-40128N3801WSale Reported · Silver City, IASale reportedS/N 32-729N3803WDelp Ryan K · Southbury, CTS/N 32-731N3807WFeller Gerald A · Long Beach, CAS/N 32-736N3808WDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 32-737N3809WFair Skies Aviation LLC · Cincinnati, OHBuilt 1966 · S/N 32-739N3811WMartin Gerard A · Boston, KYBuilt 1966 · S/N 32-741N3812WTuned Up Services Inc · Waldo, FLBuilt 1966 · S/N 32-742N3813WTaylor Bruce W · Stroudsburg, PABuilt 1966 · S/N 32-744N3814WN3814w LLC · Maumee, OHBuilt 1966 · S/N 32-745N3815WCk Aviation LLC · Milledgeville, GABuilt 1966 · S/N 32-746N3818WHeadwinds Maintenance Inc · Fort Pierce, FLBuilt 1966 · S/N 32-750N38226Martinex Aviation LLC · Wentzville, MOS/N 32-40281N3823WCherokee N3823w LLC · Huntsville, ALFirst renewal noticeBuilt 1966 · S/N 32-755N3824WTeel Brian P · Hooper, UTBuilt 1966 · S/N 32-756N3825WKaizen Companies Inc · Boise, IDBuilt 1966 · S/N 32-757N3826WMiller Heather J · Dupo, ILBuilt 1966 · S/N 32-759N38276N38276 LLC · Las Vegas, NVBuilt 1977 · S/N 32-7740081N382FSSmith Michael L · Smyrna, SCS/N 32-7700019N3830WKris Noone Air LLC · Wilmington, DES/N 32-764N38331Johnston Craig J · Ocean City, NJBuilt 1977 · S/N 32-7740082N3833WKurz Sean H · Blairsville, PABuilt 1966 · S/N 32-767N3836WOconnell Richard M · Dothan, ALBuilt 1966 · S/N 32-771N3841WHirschler Steven · Big Bear Lake, CABuilt 1966 · S/N 32-779N3842WAnderson David A · Omaha, NEBuilt 1966 · S/N 32-780N3843WStrong Jason · Agency, MOBuilt 1966 · S/N 32-781N3852WHaymond David G · Sandy, UTBuilt 1966 · S/N 32-792N3854WValiair Lc Trustee · Casper, WYBuilt 1966 · S/N 32-795N3855WRcr Aviation LLC · Punta Gorda, FLBuilt 1968 · S/N 32-1057N3856WBarr Barry · Memphis, TNBuilt 1966 · S/N 32-797N3859WFast Lane Aviation Lllp · Hawkinsville, GAFirst renewal noticeBuilt 1966 · S/N 32-801N3860WBrasfield Jason · Bonnerdale, ARBuilt 1966 · S/N 32-802N3861WMendez Fidel Serrano · San Sebastian, PRBuilt 1966 · S/N 32-804N3865WWestenberger David L · Indianapolis, INBuilt 1966 · S/N 32-809N3866WN3866w LLC · Broken Arrow, OKBuilt 1966 · S/N 32-810N38677Bass Michael L · Mount Olive, NCBuilt 1977 · S/N 32-7840024N3867WN3867w LLC · Clemson, SCBuilt 1966 · S/N 32-811N3873WBrault David M · Lake Stevens, WABuilt 1966 · S/N 32-819N3874WSplit Oak Contracting Inc · Williamson, GABuilt 1966 · S/N 32-820N3876WSteele Kyle Z · Acworth, GAS/N 32-822N3879WSale Reported · Texarkana, TXSale reportedBuilt 1966 · S/N 32-825N3880WSpecialized Communications · Smithsburg, MDBuilt 1966 · S/N 32-826N3881WKincaid Bruce W · Garland, TXBuilt 1967 · S/N 32-827N38854Schmidt Ryan A · Medinah, ILFirst renewal noticeBuilt 1977 · S/N 32-7740098N3886MBravo Foxtrot Partners LLC · Knoxville, TNBuilt 1978 · S/N 32-7840074N388TWeimer David J · Knightstown, INBuilt 1973 · S/N 32-7440044N3890WRobinson Mark A · Carson City, NVBuilt 1967 · S/N 32-914N3894WElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1966 · S/N 32-840
Back to AD 74-18-13