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.

N58LPPrichard Lev H · Dallas, TXBuilt 1985 · S/N TJ-481N58MARagan Edwin E III · Austin, TXBuilt 1977 · S/N 21062237N58MDLicandro Rudolph · Prospect, KYBuilt 1979 · S/N TJ-248N58MHA Pro LLC · Hernando, MSBuilt 1995 · S/N TH-1752N58MSRegistration Pending · Oklahoma City, OKRegistration pending, canceledBuilt 1994 · S/N E-2889N58PHangar Seven LLC · Penn Yan, NYBuilt 1980 · S/N TJ-303N58PADwt Air LLC · Lakeland, FLBuilt 1981 · S/N TJ-348N58PCGrooms David C · Gallatin, TNBuilt 1977 · S/N TJ-101N58PDFoley Jeffrey William · Scappoose, ORBuilt 1976 · S/N TJ-86N58PECenice LLC · Eagle, COBuilt 1982 · S/N TJ-435N58PRQuinlan John H · Claxton, GABuilt 1978 · S/N TJ-149N58PZMiller Paul David · Dallas, TXBuilt 1981 · S/N TJ-360N58QPHk Ventures LLC · Paynesville, MNBuilt 1990 · S/N TH-1612N58RAGibbs Ron · Parker, AZBuilt 1975 · S/N TJ-14N58TBTaylor Scott · Bg Bnd Ntl Pk, TXS/N TJ-113N58TCN58tc LLC · Gibsonton, FLBuilt 1984 · S/N TJ-455N58TEGtk Services LLC · Carbondale, ILBuilt 1980 · S/N TJ-326N58TFFlying Matters LLC · Cedarburg, WIBuilt 1980 · S/N TJ-292N58TKTwa Partners LLC · Billings, MTBuilt 1979 · S/N TK-107N58TTBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 21062998N58VBBeckman Donald A · Rostraver Township, PABuilt 1980 · S/N TJ-260N58WPHarrell Services Group LLC · Fort Mill, SCBuilt 2006 · S/N ES-160N59007Hang On LLC · Montrose, COBuilt 1973 · S/N 21060014N59008Davis Burton D · Jefferson, IABuilt 1973 · S/N 21060015N59011Nelson Albert N III · Baytown, TXBuilt 1973 · S/N 21060018N59041Edwards Aviation & Consulting LLC · Broken Arrow, OKBuilt 1973 · S/N 21060044N59045Air-Zancada Inc · Wilmington, DEBuilt 1973 · S/N 21060046N59049Scarry David Charles · San Luis Obispo, CABuilt 1973 · S/N 21060049N5907Summit Aviation Group LLC · Monument, COBuilt 2007 · S/N 2388N590CDInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 0957N590FMTrrek Enterprises LLC · Sunriver, ORBuilt 1966 · S/N 320D0095N590JGMark V Aviation LLC · Missoula, MTBuilt 2002 · S/N 40044N5910MCross Country Well Service LLC · Farmington, NMS/N 340-0067N5916MQuest Aviation Inc · Lake City, FLBuilt 1973 · S/N 402B0365N59173Vogelgesang Randy · Gardnerville, NVBuilt 1973 · S/N 21060141N591CDac-2020 Inc · Skaneateles, NYBuilt 2002 · S/N 0439N591GTFrench Brothers Homes LLC · Alamogordo, NMBuilt 2018 · S/N 1835N591SCSrc22 LLC · Costa Mesa, CABuilt 2017 · S/N 4511N591WATv Trucks LLC · Eufaula, ALBuilt 2006 · S/N 2110N59258Energy Roofing Technology Se LLC · Lake City, FLS/N 21060180N59286Staley Ronald L · Lebanon, ORBuilt 1974 · S/N U20602643N59294Cornucopia Investment Group LLC · South Jordan, UTBuilt 1974 · S/N U20602645N592GCFogelson Robert A · Tillamook, ORBuilt 1972 · S/N 340-0152N5931MSteven F Danz LLC · Encino, CABuilt 1972 · S/N 340-0071N5938MKarlen John R · Boring, ORS/N 340-0074N593GREji Services LLC · Cairo, GABuilt 2014 · S/N 4149N593MCChaffin Mark Bernard · Massillon, OHBuilt 2019 · S/N 4864N593MWWalsh Michael E · Cabot, PABuilt 2021 · S/N 5111N593VFVictor Foxtrot Aviation LLC · Dallas, TXBuilt 2024 · S/N 9855N594BVJmak Corp · Seymour, TNBuilt 1978 · S/N 340A0440
Back to AD 2012-10-13