AD 2012-10-13

Registered aircraft · 13,306

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:2012-10-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:2012-10-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.

N997AVOlioni Aviation LLC · Palo Alto, CABuilt 2021 · S/N 2279N997CDN997cd Corp Trustee · Wilmington, DEBuilt 2004 · S/N 0893N997CHHolly Ridge Planting · Indianola, MSBuilt 1986 · S/N T21064997N997JDAviation.One Business Holdings LLC · Mesa, AZBuilt 1984 · S/N 414A1004N997JKEastern Stearman Inc Trustee · Leesburg, VABuilt 2005 · S/N 41108N997PSFuel X LLC · Pearl, MSBuilt 2024 · S/N 10178N997RRegistered aircraftBuilt 1974 · S/N 21060386N997TAAir Flight Inc · Fort Lauderdale, FLFirst renewal noticeBuilt 1980 · S/N 402C-0231N997TCJasmine Aviation LLC · Los Altos, CABuilt 2022 · S/N 8548N9982YChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1982 · S/N 21064659N9983MTate Clint · Boise, IDBuilt 1978 · S/N U20604632N9984GIndura Air Holdings LLC · Bloomfield Hills, MIBuilt 2016 · S/N 4345N9986MLogan Timothy R · Valley City, NDS/N U20604635N9989Bank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 11060N998CDLindsay Allan · Papillion, NEBuilt 2003 · S/N 0482N998CZMesa Aviation LLC · Mesa, AZBuilt 2023 · S/N 9098N998DFThompson William III · Lawrenceville, ILBuilt 2013 · S/N 0650N998EKAopa Foundation Inc · Frederick, MDBuilt 2016 · S/N 4353N998JA2 Doods LLC · Lakewood Ranch, FLBuilt 1979 · S/N 310R0938N998JGDragonfly Aviation LLC · Davie, FLBuilt 1999 · S/N EA-641N998JWBowtie Investments LLC · Schriever, LAS/N 2989N998KBPure Air LLC · Wichita, KSBuilt 2022 · S/N 8713N998LSTalton Rentals LLC · Tupelo, MSBuilt 1998 · S/N E-3204N998PMWirth Aviation LLC · Scottsdale, AZBuilt 1999 · S/N E-3251N998PRRanchlands Management Company LLC · Las Vegas, NVBuilt 2024 · S/N 10356N998RCCf Holdings LLC · Hernando, MSBuilt 2018 · S/N 4727N998WTMkeair LLC · Waukesha, WIBuilt 2002 · S/N 0210N9991Sale Reported · Kalispell, MTSale reported, canceledBuilt 2001 · S/N 0079N9991YArwlb Aviation LLC · Spokane, WABuilt 1982 · S/N 210-64661N9994Holstein Group Inc · Lomita, CABuilt 2024 · S/N 9809N9996JDiamond X LLC · Elko, NVBuilt 1982 · S/N T18803925TN999AJNedley Aviation LLC · Wilmington, DEFirst renewal noticeBuilt 1984 · S/N EA-417N999ANOsi Air LLC · Wilmington, DEBuilt 2005 · S/N 1668N999AVSouza Engineering Contracting Inc · San Luis Obispo, CABuilt 1979 · S/N P21000257N999BFRigel Aviation Inc · Jefferson Hills, PABuilt 1979 · S/N EA-24N999BYBrace Yourself Orthodontics Inc · Portsmouth, OHBuilt 2007 · S/N 2858N999CECb Wings LLC · Eugene, ORBuilt 1980 · S/N EA-86N999DCTbm Avenger Inc · Peru, ILBuilt 1976 · S/N 340A0035N999DXJourneyman Aviation LLC · Louisville, KYBuilt 2003 · S/N 0582N999EBEngines Inc · Jonesboro, ARBuilt 1979 · S/N 340A0951N999ETJet Aero LLC · Montoursville, PABuilt 2003 · S/N 0476N999FAFlying Affair LLC · Jupiter, FLBuilt 2011 · S/N 0252N999JLFlying Swan LLC · Ashland, NHBuilt 1973 · S/N 414-0479N999JWWazney Aviation LLC · Willoughby, OHBuilt 2003 · S/N 29-0293N999KMMaule Aviation LLC · Las Vegas, NVBuilt 1979 · S/N P21000387N999KSColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2009 · S/N 3507N999LCJust Plane Aviation LLC · Baldwin, MIS/N 40032N999PCFlying T LLC · Albuquerque, NMBuilt 1972 · S/N 21059694N999PGRegistered aircraftBuilt 1995 · S/N E-2955N999RKTcg Aviation LLC · Pelham, ALBuilt 1974 · S/N 414-0610
Back to AD 2012-10-13