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.

N907DRWhite Warren R · Birmingham, ALBuilt 2005 · S/N 1300N907JMWright Flight Inc · Tucson, AZS/N 21063665N907WFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 2177N907WGWhisky Golf Holdings Inc · Heber City, UTBuilt 2008 · S/N 3283N9080XNoldin John · Griffith, INS/N 46-8608035N9083SRobinson Charley C · Guthrie, OKBuilt 1978 · S/N TJ-152N9083UNashville Malibu Partners LLC · Hendersonville, TNBuilt 1986 · S/N 46-8608039N9083ZCalder Brothers Corp · Greenville, SCBuilt 1986 · S/N 4608003N908ALPrincipal Aviation LLC · Palm Beach Gardens, FLBuilt 2022 · S/N 8552N908ATWegener Airlines Inc · Ridgeland, MSBuilt 1991 · S/N E2639N908DBB36 LLC · Winter Park, FLBuilt 2002 · S/N EA-694N908DTGeen Hornet LLC · Wilton Manors, FLBuilt 2019 · S/N 1943N908DUAirdu LLC · Hoschton, GABuilt 2023 · S/N 9301N908MMWilmington Island Aviators Club LLC · Savannah, GABuilt 2026 · S/N 11459N908PScott Kevin · Santa Fe, NMBuilt 2000 · S/N EA-664N908SEHarness William W Trustee · Carmel Valley, CABuilt 2006 · S/N 2135N908TATrianon Aviation LLC · Naples, FLBuilt 2024 · S/N 10199N908ZUAyers John C · Narragansett, RIBuilt 2004 · S/N 1040N9090JDieppa Pablo F · North Charleston, SCBuilt 1986 · S/N 46-8608049N9090NPmt Flyers LLC · Amarillo, TXFirst renewal noticeBuilt 1986 · S/N 46-8608050N9095SPowers Land Management Service Inc · Lyons, INBuilt 1986 · S/N 46-8608061N9098UGlobal T & E Inc · Mcallen, TXBuilt 1986 · S/N 4608025N909ATGo Consultants LLC · Wilmington, DES/N E-2647N909DCTwin Piston Aviation LLC · Salisbury, NCBuilt 1980 · S/N 340A0998N909RFPastjo Aviation LLC · Charleston, WVBuilt 1982 · S/N 414A0840N909SBLaguna Air LLC · Montecito, CABuilt 2026 · S/N 11167N909TMCaext Holdings LLC · Kalispell, MTBuilt 2022 · S/N 9028N909VBBedalou Aviation LLC · Joplin, MOBuilt 1997 · S/N E-3133N90CDCirrus Pilots Flying Group · Hillsborough, NJBuilt 2004 · S/N 0939N90CFArq Aviation LLC · Wilmington, NCBuilt 2025 · S/N 10645N90DMDel Martin Lp · Spring, TXBuilt 1972 · S/N 340-0048N90KBSancerre Inc Trustee · Wilmington, DEBuilt 2022 · S/N 8934N90MGEracare Aviation LLC · Wesley Chapel, FLBuilt 2007 · S/N 2380N90RWWallace Richard · Santa Teresa, NMBuilt 1979 · S/N 21063283N90TLColorado Aviators LLC · Gypsum, COBuilt 1979 · S/N P21000206N9100UFly Mcble LLC · Huntsville, ALBuilt 1986 · S/N 4608011N91025Arctic Aviation Leasing LLC · Anchorage, AKBuilt 1969 · S/N 20700016N91045Dakota Aircraft Specialists LLC · Hot Springs, SDBuilt 1975 · S/N 414-0623N9109MAr Malibu LLC · Gassville, ARBuilt 1985 · S/N 46-8608006N910BHb Air LLC · Arvada, COS/N 2352N910JVDunmire Properties LLC · Goldsboro, NCBuilt 2018 · S/N 32-0004N910MFly By Night Aviation LLC · San Francisco, CABuilt 1979 · S/N 310R1653N910RHDelaurentis Robert · Oak Harbor, WABuilt 1984 · S/N 46-8408066N910SAPersistent Roots LLC · Carpentersville, ILBuilt 1999 · S/N TH-1910N910SGKrs Aviation LLC · Elk Grove Village, ILBuilt 2007 · S/N 2774N910WWLundell Plastics Corp · Odebolt, IABuilt 2004 · S/N TH-2092N9111PBas Part Sales LLC · Greeley, COBuilt 1987 · S/N 4608084N9113ZKenmore Crew Leasing Inc Owner Trustee · Bellingham, WABuilt 1986 · S/N 4608045N9114NOutlier Mt LLC · Kalispell, MTBuilt 1986 · S/N 4608048N9117JBlue Skies Malibu LLC · San Diego, CABuilt 1987 · S/N 4608052
Back to AD 2012-10-13