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.

N311PGKumar Shekar · Greenwood, SCBuilt 1999 · S/N E-3257N311TCN311tc LLC · Tacoma, WAS/N 1582N311TDWw House Inc · Lumberton, TXBuilt 2010 · S/N 3623N311XXWeekend Pass LLC · Golden, COBuilt 2021 · S/N 2369N3122MMiller-Jackson Co Inc · Oklahoma City, OKBuilt 1984 · S/N EA-416N3122RMarrow Henry G · Southern Pines, NCBuilt 1994 · S/N TH-1722N3122UTravel Aviation Inc · Vineyard Haven, MABuilt 1988 · S/N E-2431N31291N31291 Aviation LLC · Omro, WIBuilt 1988 · S/N E-2432N312ADAltier Daniel T · Bloomfield Twp, MIBuilt 2005 · S/N 1615N312AEN312ae LLC · Seffner, FLBuilt 2019 · S/N 4783N312APAtish LLC · Hermosa Beach, CABuilt 2025 · S/N 10726N312CPSsi Mechanical LLC · San Antonio, FLBuilt 2008 · S/N 3120N312DKline Robert H · Oley, PABuilt 2000 · S/N 29-0255N312DATspy Services Inc · Wilmington, DEBuilt 2005 · S/N 1262N312DXPowder Day Aviation LLC · Camden, DEBuilt 2020 · S/N 2113N312DYParte Tercero LLC · Irvine, CABuilt 2023 · S/N 9225N312FPEger Aviation LLC · Pittsburgh, PABuilt 2014 · S/N 4069N312GEKalsi Pritpal · Clarksburg, MDBuilt 2012 · S/N 0383N312GMSonas Aviation Inc Trustee · Wilmington, DEBuilt 2023 · S/N 9370N312GTKiser Consulting LLC · Atlanta, GABuilt 2022 · S/N 8920N312HWdc Aviation LLC · Scottsdale, AZBuilt 2020 · S/N 2193N312JBBadmia LLC · Polk City, IAFirst renewal noticeBuilt 2002 · S/N 0373N312MGMyles To Go Aviation LLC · Camden, DEBuilt 2019 · S/N 1874N312MSGulf Of America Aviation LLC · Brookshire, TXBuilt 2023 · S/N 9185N312MTP Mitchell LLC · Las Vegas, NVBuilt 2025 · S/N 10735N312NGNovember Golf LLC · Shamong, NJBuilt 2015 · S/N 4274N312PXRauschenberger Ventures LLC · Chicago, ILBuilt 2021 · S/N 5014N312REBlue Jay Family Office LLC · Wilmington, DEBuilt 2025 · S/N 11073N312RKRjk Air LLC · Syracuse, NYBuilt 2016 · S/N 1370N312SCBarker Family Investments Management Co LLC · Tyler, TXBuilt 1981 · S/N 21064474N312SRStorm Consulting Enterprises LLC · Tyler, TXBuilt 2007 · S/N 2427N312WG312wg LLC · Kenilworth, ILBuilt 2018 · S/N 1793N312XXSilver State Skies LLC · Camden, DEBuilt 2022 · S/N 8925N3131KAmazon Aero Corp · Wilmington, DEBuilt 1972 · S/N 402B0248N3136XBobbett Robert Todd · West Richland, WABuilt 1998 · S/N EA-620N313AJAspiring LLC · Royal Oak, MIBuilt 2024 · S/N 9790N313BRCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11654N313DG3dg Aviation LLC · Louisville, KYBuilt 2005 · S/N 1592N313ETImrie Aviation LLC · Jonesboro, ARBuilt 2014 · S/N 0955N313EZFlightwerks LLC · Commerce Township, MIBuilt 2022 · S/N 8957N313GCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11547N313GBBurnett Gregory C · Rogersville, MOBuilt 1977 · S/N 21061986N313GPGeiger Aviation LLC · Mount Pleasant, SCBuilt 2017 · S/N 1478N313JBConchy Joe Aviation LLC · Fort Lauderdale, FLBuilt 2017 · S/N 1631N313KGJj Aviation Holdings LLC · Raleigh, NCBuilt 2025 · S/N 10572N313LCShort Carl R · Issaquah, WABuilt 2008 · S/N 3046N313MEBasille Vision LLC · Lewes, DEBuilt 2021 · S/N 2443N313MHHarder-Diesslin Development Group LLC · Salida, COBuilt 2010 · S/N 3619N313MLAir Mer LLC · Los Altos, CABuilt 2017 · S/N 1613N313MPAlpha Bravo Charlie 1 Corp · Houston, TXBuilt 1980 · S/N P21000573
Back to AD 2012-10-13