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.

N36GWSky Whiddon Inc · Fort Lauderdale, FLBuilt 2023 · S/N 9551N36HCSimply Everything LLC · Greer, SCBuilt 1989 · S/N E-2492N36HPNyack Inc · Emigrant Gap, CABuilt 1984 · S/N EA-423N36HWHw Inc · Omaha, NEBuilt 1980 · S/N EA-166N36JHFlowerree Farms Inc · Bend, ORBuilt 2017 · S/N 1593N36KBCrumley Michael B · Anchorage, AKBuilt 2000 · S/N E-3339N36KPAir Lease Inc · Bridgeport, WVBuilt 1989 · S/N EA-495N36LLBeech Bums Aviation II LLC · Linden, MIBuilt 1980 · S/N EA-155N36LMN36lm LLC · Spicewood, TXS/N EA-67N36LRQuarter Circle E Enterprises Inc · Yorba Linda, CAS/N E-26N36MNKad Enterprises LLC · Everett, WABuilt 1980 · S/N EA-79N36MRCook Canyon (Gp) LLC · Dallas, TXBuilt 2018 · S/N 4631N36MWM & A Aircraft LLC · Missoula, MTBuilt 2024 · S/N 9877N36NCrossman Kyle D · Monroe, MIBuilt 1980 · S/N 3350004N36NBCl Holdings LLC · Washington, DCS/N E2274N36NMFrost Cavin Bert · Odessa, TXS/N EA-316N36PDHigh Flyers LLC · San Luis Obispo, CABuilt 1995 · S/N E-2921N36PKGoodman Ronald · Dos Palos, CABuilt 2000 · S/N EA-654N36PVLong Wing Aviation LLC · Houston, TXBuilt 2002 · S/N EA-695N36PYMoore Gary E · Crossville, TNBuilt 2000 · S/N E-3350N36PZFillips Robert Victor · Alvin, TXBuilt 1990 · S/N E-2560N36RWBas Part Sales LLC · Greeley, COBuilt 1981 · S/N P21000691N36SValaco Inc · Albertville, ALBuilt 1995 · S/N E-2987N36SATango Whiskey Holdings LLC · Moorpark, CABuilt 2025 · S/N 10447N36TEGary Vaughan Construction Inc · Leland, MSBuilt 1983 · S/N EA-389N36TKKinsey & Co Inc · Las Vegas, NVBuilt 1985 · S/N EA-444N36TMPendragon LLC · Stuart, FLBuilt 1979 · S/N EA-7N36TRClark Tj · Saint George, UTS/N EA-159N36VMTri-Rivers Enterprise · Cameron, MOBuilt 1988 · S/N E-2411N36VTTurley Ty P · Ramona, CABuilt 1993 · S/N E-2806N36VUThomas Gary F · Mount Shasta, CABuilt 2002 · S/N E-3449N36XArchangel Aviation LLC · Cleburne, TXBuilt 1976 · S/N 21061650N36XGWhite Doug · Torrington, WYBuilt 2002 · S/N 3FX027N36YBGrey Fox Corp · La Canada Flt, CAS/N EA-331N36YMRankay Air LLC · Sanger, CABuilt 1983 · S/N EA-369N36YPVillages Equipment Co · Leesburg, FLBuilt 1987 · S/N E-2358N3701NGreat Lakes Aero Marine LLC · Green Bay, WIBuilt 1980 · S/N EA-141N3704GGap Holdings LLC · Dover, DEBuilt 1980 · S/N EA-145N3708KWard Ron · Oklahoma City, OKBuilt 1980 · S/N EA-153N370BMChad Davison Insurance Agency Inc · Bend, ORBuilt 2015 · S/N 1020N370GAir Land Ventures LLC · Highland Park, ILBuilt 2003 · S/N 0783N370JGGuideair LLC · Eden Prairie, MNBuilt 2004 · S/N 1123N370JR110 Aviation LLC · West Des Moines, IABuilt 2024 · S/N 9849N37126Robison Charles T · Pierre, SDBuilt 1980 · S/N EA-156N3714ZQuick Foam Insulation LLC · Lubbock, TXBuilt 1980 · S/N EA-160N37181Jrs Aviation LLC · Falls City, NEBuilt 1980 · S/N 414A0511N371BBLake Peipsi LLC · Williamstown, WVBuilt 2000 · S/N E-3355N371BGCzok Justin · Park Ridge, ILBuilt 2005 · S/N 41104N371CDEicholz Robert Trustee · Palm Springs, CABuilt 2005 · S/N 1434N371ECNext1sr LLC · Dayton, OHBuilt 2025 · S/N 10487
Back to AD 2012-10-13