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.

N2691YLa Paz Holdings LLC · Wetumpka, ALBuilt 1979 · S/N 414A0414N2692LInnovative Aviators LLC · Norman, OKBuilt 1979 · S/N 414A0417N2693BDiaz Charles · Ogden, UTBuilt 1979 · S/N 414A0422N2694HRockingham Carriage Services Inc · Greenland, NHS/N 4140493N2696HSunwest Aviation Inc · Santa Ynez, CAFirst renewal noticeBuilt 1979 · S/N 340A0778N2696PBlue Wing Aviation LLC · Tulsa, OKBuilt 1979 · S/N 340A0779N2696UBlack Dragon Consulting LLC · Phoenix, AZS/N 340A0780N2699DN2699d Corp Trustee · Wilmington, DEBuilt 1979 · S/N 340A0787N269JMPatterson Larry Jay · San Angelo, TXBuilt 2008 · S/N 3231N269KTJfa Aviation Group LLC · Pompano Beach, FLBuilt 1980 · S/N TJ-324N269PCSch Aviation Inc Trustee · SporleBuilt 1979 · S/N 340A0785N269PGSovereign Souls Aviation LLC · Montecito, CABuilt 2025 · S/N 10989N269PLMerrill Mark · Ellensburg, WABuilt 2004 · S/N 269AN269R219 Air LLC · South Bend, INBuilt 1986 · S/N 8608065N269WTWillis James A · South Jordan, UTBuilt 1972 · S/N 340-0104N269ZACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11525N26BZNorthcutt Chevrolet Buick LLC · Enid, OKBuilt 2014 · S/N 4033N26CFKustatan Leasing LLC · Nikiski, AKBuilt 1975 · S/N 20700306N26CSJetswiss LLC · Overland Park, KSBuilt 1993 · S/N E-2814N26CZCzi LLC · Great Falls, MTBuilt 2019 · S/N 1962N26DPColibri Ventures LLC · Dorado, PRBuilt 2021 · S/N 5138N26FFFastfun LLC · Fort Myers, FLBuilt 2004 · S/N 29-0352N26HAEpsilon Equity Partners LLC · Houston, TXS/N TJ-486N26HDRed Sky Investments Series LLC Series 1 · Jasper, ALBuilt 2025 · S/N 10892N26KNSky King Aviation Inc · Weslaco, TXBuilt 1978 · S/N P21000085N26MCFoxtrot Squared Aviation LLC · Fairview, TXBuilt 2020 · S/N 2071N26MKCga Group LLC · Houston, TXBuilt 2018 · S/N 1768N26MRBenemily Aviation LLC · Flagstaff, AZBuilt 2026 · S/N 11522N26MWMike Whiskey LLC · Atlanta, GABuilt 2026 · S/N 11187N26MZHva N26mz LLC · Cooper City, FLBuilt 2024 · S/N 10385N26PMHill Capital Leasing LLC · Scottsdale, AZBuilt 1977 · S/N 21061791N26QRSolesbee Nathan Arthur · Anaheim, CABuilt 1979 · S/N EA-19N26RGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1987 · S/N E-2383N26RSStacey Enterprises Inc · Ogden, UTBuilt 1978 · S/N P21000153N26SKDevine Robert · Albuquerque, NMBuilt 1994 · S/N 87N26STSky Condor Aviation LLC · Flatwoods, WVBuilt 1974 · S/N 414-0536N26VSBoss Aviation LLC · Douglas, AZBuilt 2009 · S/N 3585N26WRiddle Jay Allen · Gainesville, FLBuilt 2020 · S/N 4905N26WADesert Sky Ventures LLC · Edmond, OKBuilt 2026 · S/N 11378N26WMSportcruiser LLC · Wilmington, DEBuilt 2021 · S/N 5002N26XYSabot Jay M · Naples, FLBuilt 2009 · S/N L2K-247N26YTCtd Management LLC · Easley, SCBuilt 2026 · S/N 11392N2702LE D Santos & Associates LLC · Wilmington, DEBuilt 1980 · S/N 414A0608N2702VAtx Aero LLC · Austin, TXBuilt 1979 · S/N 340A0904N2704NKimberton Corp LLC · Phoenixville, PABuilt 1979 · S/N 335-0003N2704SC&M Asset Management LLC · Owasso, OKBuilt 2005 · S/N 1265N2704UMatheson Thomas Blair · Mandan, NDS/N 335-0005N2705LLt Aviation LLC · Plattsmouth, NEBuilt 1979 · S/N 335-0010N2706AFlhs LLC · Cedar Park, TXBuilt 1979 · S/N 335-0013N2706TDodson Internarional Parts Inc · Rantoul, KSBuilt 1979 · S/N 335-0017
Back to AD 2012-10-13