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.

N425SWGratitude Unlimited LLC · Reno, NVBuilt 2016 · S/N 1463N425WMRegistered aircraftBuilt 2017 · S/N 1628N4264CMmc Properties LLC · Cottonwood, AZBuilt 1978 · S/N 340A0516N426AC21 Holdings LLC · Southlake, TXBuilt 2024 · S/N 10080N426BGZulu Golf LLC · Henderson, NVBuilt 2026 · S/N 11277N426BLRice Developments LLC · Walker, LABuilt 2022 · S/N 8653N426DJNehoc Leasing LLC · Marietta, GABuilt 2019 · S/N 4867N426GWNottingham Holdings LLC · Bluffton, SCBuilt 2017 · S/N 4520N426LJVenture Air Solutions Inc · Opa Locka, FLBuilt 1981 · S/N 402C0434N426MMcmahan Aviation LLC · Hattiesburg, MSBuilt 2024 · S/N 10057N426SHDesert Stellar Aviation LLC · Phoenix, AZBuilt 2019 · S/N 1882N426SRSchoeneman Michael D · Central Point, ORBuilt 2006 · S/N 2205N426TDJuliet Tango Aviation Inc Trustee · Wilmington, DEBuilt 2022 · S/N 8779N426WULucy In The Sky LLC · Los Angeles, CABuilt 2005 · S/N 29-0340N426WVAbhrdh Enterprises LLC · Bunker Hill, WVBuilt 2025 · S/N 10548N4272CKamps Air LLC · Grand Rapids, MIBuilt 1982 · S/N 414A0849N427ARDouglass Aviation LLC · Franktown, COBuilt 2015 · S/N 1109N427ATMockingbird LLC · Bloomington, INBuilt 2004 · S/N 0954N427BDNostra Aeris LLC · Gassville, ARBuilt 1991 · S/N EA528N427CEVwd Aviation LLC · Bozeman, MTBuilt 2025 · S/N 10743N427CWRural Orthopedic Care LLC · Ardmore, OKBuilt 2001 · S/N E-3400N427DWFlyin Phar LLC · Salt Lake City, UTBuilt 1979 · S/N TK-113N427JRWhite James L · Belleair, FLBuilt 2005 · S/N LIV-436N427JTCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11637N427KDRegistered aircraftBuilt 2019 · S/N 1967N427KGWhite James J IV · Conroe, TXBuilt 2008 · S/N 3068N427SRTrosclair Air LLC · Gonzales, LABuilt 2007 · S/N 2432N427TXMayfly Holdings LLC · Monticello, FLBuilt 2008 · S/N 421007N427YECavu Capital LLC · Concord, NCBuilt 2013 · S/N 0500N4282PAero Tramp Holdings LLC · Dallas, TXBuilt 1999 · S/N E-3282N4287AWilliam Dolson And Associates LLC · Santa Fe, NMBuilt 1980 · S/N 340A1010N428AJetpropmontana LLC · Cameron, MTBuilt 1986 · S/N 4608031N428AMT G Mendell Corp · New York, NYBuilt 2020 · S/N 4896N428ANPatriot Flyers LLC · Lake Havasu City, AZBuilt 2006 · S/N 2092N428APPaper Plane Aviation LLC · Sharpsburg, GABuilt 2026 · S/N 11406N428ESPbjd Aviation LLC · Henderson, NVBuilt 2017 · S/N 1572N428SRLautman Karl F Trustee · Los Angeles, CABuilt 2006 · S/N 2258N428TLight Korbin T · Midland, TXBuilt 2001 · S/N 0049N428TMBlue Jay Omni Bearing LLC · Fargo, NDS/N 0167N428WSSquires Wayne M · Corpus Christi, TXBuilt 2011 · S/N 0141N428ZZDeans List Aviation LLC · Nashville, TNBuilt 2020 · S/N 4987N4298YAir LLC · Fresno, CABuilt 2001 · S/N TH-1998N429CDQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1064N429KRK Air LLC · Indianapolis, INBuilt 2025 · S/N 10785N429PDupuy William C · Waco, TXBuilt 2000 · S/N E-3356N429PSMjk Leasing LLC · San Antonio, TXBuilt 2006 · S/N 29-0429N429RCN429rc LLC · Gladwyne, PABuilt 1979 · S/N 414A0243N429SRN205bp LLC · Sheridan, WYBuilt 2007 · S/N 2686N42ACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11618N42AAN42aa LLC · Nantucket, MABuilt 1979 · S/N 402C0238
Back to AD 2012-10-13