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.

N612KPSmith Aviation Inc · Stamps, ARBuilt 1998 · S/N TH-1857N612MCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11666N612MTBinetter Samantha Ellen · Guaynabo, PRBuilt 2015 · S/N 1058N612RCLift Aviation LLC · Loveland, OHBuilt 2014 · S/N 0810N612SBGronemeyer Jens · Deland, FLBuilt 2004 · S/N 41013N612SFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N 21061651N612SSSquishy And Squeakers Fun Flights LLC · Allen, TXBuilt 2025 · S/N 11009N612THCarolina Aviation LLC · Wilmington, DEBuilt 2025 · S/N 10473N612WInhoc Capital Holdings LLC · Dallas, TXBuilt 2024 · S/N 10008N612WPRobert A Johnson Construction Lc · High Springs, FLBuilt 1977 · S/N 21062356N612XCSkiventure Holdings LLC · Wayzata, MNBuilt 2013 · S/N 4023N6131AWigen Mary E · Porthill, IDBuilt 1979 · S/N 21063508N6131XGv Air Inc · Medford, ORS/N 310R1296N6133PEastwood LLC · Pikeville, KYBuilt 2003 · S/N 0639N6134ECf Ranch & Cattle Co LLC · Burbank, OHBuilt 1981 · S/N P21000737N6139BFelker Gary L · Odessa, TXBuilt 1973 · S/N 210-59909N613BCMcleod Properties Fontana LLC · Altadena, CABuilt 2012 · S/N 0421N613CMcb Consultants LLC · Camden, DEBuilt 2026 · S/N 11436N613DRLyons Aviation LLC · Raleigh, NCBuilt 2001 · S/N 30-0062N613HTSherman Jason L Trustee · O Fallon, MOBuilt 2023 · S/N 9151N613MKFlatlands Aviation LLC · Brooklyn, NYBuilt 2016 · S/N 4400N613MMCome Fly With US LLC · Purcellville, VABuilt 2005 · S/N 1497N613RSGreen Trees Aviation LLC · Johnson City, TNBuilt 2024 · S/N 10025N613STCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11573N613VJDt Air LLC · Picayune, MSBuilt 2025 · S/N 11034N613WTCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11640N613XLanair LLC · Monroe, GABuilt 2020 · S/N 2055N614CTailwinds LLC · Warsaw, INBuilt 2002 · S/N 0411N614CTMiles Eric · Lake Oswego, ORBuilt 2024 · S/N 9988N614CY614 Charlie Yankee Lc · Ames, IABuilt 2004 · S/N 1050N614EATop Joint LLC · Huntingburg, INBuilt 2023 · S/N 9591N614KCGbt Aviation LLC · Baton Rouge, LABuilt 2014 · S/N 0913N614KKKc Aviation LLC · Raleigh, NCBuilt 2024 · S/N 9957N614PAPafford Holdings LLC · Ridgeland, MSS/N 1981N614PCDcg Peterson Brothers Co · Sioux Rapids, IABuilt 2015 · S/N 1011N614RCMacisaac Richard · Northampton, MABuilt 2002 · S/N 0249N614RZRasmusson Timothy · Elma, NYBuilt 2004 · S/N 0897N614SRForest Restoration Inc · Philomath, ORBuilt 2006 · S/N 2166N6151UMccall John A · Grapeland, TXBuilt 1985 · S/N 21064914N6151YBulloch Troy P · Cedar City, UTS/N 21064269N6152BMohave County Board Of Supervisors · Kingman, AZBuilt 1978 · S/N 21062724N6153BCenturion Southeast Management LLC · Raleigh, NCBuilt 1978 · S/N 21062696N6154SSchreiber Stephen · Windermere, FLBuilt 2014 · S/N L2K-303N6154WBramlett LLC · Carrollton, TXBuilt 2003 · S/N 0632N6155YAl & Zal Corp · Wilmington, DEBuilt 1981 · S/N 21064271N61599Freebird Aviation LLC · Eagle, IDBuilt 1974 · S/N U20602350N6159ULaw Office Of Vincent G Rieger · Kalispell, MTBuilt 1985 · S/N 21064927N615ACManitou Aviation LLC · Camden, DEBuilt 2025 · S/N 10930N615BBBmu22 LLC · Lancaster, OHBuilt 2005 · S/N 1682N615BTEddies Legacy LLC · Clovis, CABuilt 2022 · S/N 8823
Back to AD 2012-10-13