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.

N992PJOld Guys In The Sky LLC · Winton, CABuilt 2024 · S/N 10188N992PSProctor Gary · Wichita, KSBuilt 1978 · S/N 21063074N992RJKnight Rider LLC · Kalispell, MTBuilt 2024 · S/N 10183N992TLMulzer Timothy J · Santa Claus, INBuilt 1992 · S/N E-2715N992TSTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 10764N9934XLogue James · Fort Worth, TXBuilt 1975 · S/N 21060916N993JTGood Life Aviation LLC · San Tan Valley, AZBuilt 2006 · S/N 29-0447N993LLSherpa Aerospace LLC · Tucson, AZBuilt 2006 · S/N 2220N993MMMccormick Aviation LLC · Madisonville, LABuilt 2007 · S/N 2585N993MSMs600 Fl LLC · Miami, FLBuilt 2023 · S/N 9207N993PMMakai Royalty LLC · Spicewood, TXBuilt 2023 · S/N 9612N993SMCharden Aviation LLC · Mount Sterling, KYBuilt 2014 · S/N 4089N993SRThree S Ranch Inc · Blanca, COBuilt 1980 · S/N P21000477N9940FHarvey Air LLC · Arlington, TNBuilt 1972 · S/N 340-0173N9943COwl Ventures LLC · Portland, ORBuilt 2014 · S/N 0904N9948ZAlien Invaders LLC · Medina, WABuilt 1983 · S/N U20606767N994CERegistration Pending · Coeur D Alene, IDRegistration pendingBuilt 2024 · S/N 10311N994CTUS Framing International LLC · Louisville, KYBuilt 2008 · S/N 3020N994EFRbav LLC · Camden, DEBuilt 2023 · S/N 9240N994KDKgd Aviation LLC · Breckenridge, COBuilt 2022 · S/N 2492N994NZFrakes Stephen A · Frisco, COBuilt 1978 · S/N 21062470N994PMooney Travel LLC · Newport, RIBuilt 2009 · S/N LIV-466N994PMAlpha Dogs Aviation LLC · Powell, OHS/N 1386N994PXFlight Charter Services LLC · Missoula, MTBuilt 2011 · S/N 0080N994SBB Squared LLC · Russellville, ARBuilt 2005 · S/N 1364N9952ZMcdougall Enterprises LLC · Tualatin, ORBuilt 1983 · S/N U20606771N9953CEjj Group Inc · New York, NYBuilt 1983 · S/N T30300241N9955JMehling Robert C · Hardin, MTS/N T18803884TN9955MBell Jason W · Mount Pleasant, TXBuilt 1989 · S/N TH-1575N995EGEagle Group USA Inc · Howell, MIBuilt 1980 · S/N EA-90N995KClemmer Norman L · Green Lane, PABuilt 1995 · S/N 29-0040N995SDDarcy Aviation LLC · Scottsdale, AZBuilt 2017 · S/N 1653N995TBTravel Lecture Learn LLC · Sicklerville, NJBuilt 2016 · S/N 4430N995WASheely Holdco LLC · Chesapeake, VABuilt 2023 · S/N 9103N995WBTrue North Aviation LLC · Harrisburg, SDBuilt 2017 · S/N 4556N995WSN995ws LLC · Fairfax Station, VABuilt 2026 · S/N 11206N9963HRoni 1 LLC · Sacramento, CABuilt 2017 · S/N 1650N9963WStokair LLC · Mequon, WIBuilt 2023 · S/N 9097N9963YN9963y LLC · Provo, UTBuilt 1982 · S/N 21064649N9964YGreenspun Mark H · Washington, DCBuilt 1982 · S/N 21064650N9968JBoening Bros Dusting & Spraying Scv · Floresville, TXBuilt 1981 · S/N T18803897TN9968PFlax Brian J · Germantown, TNBuilt 1997 · S/N E-3109N996AElite Air Ventures LLC · Concord, CABuilt 2020 · S/N 2221N996CDGrace Flying Service Inc · Saint Francis, KSBuilt 2005 · S/N 1499N996FInloes Mechanical Utah LLC · Ogden, UTBuilt 1996 · S/N E-3042N996JKFletcher Flying Service 419 LLC · Labelle, FLBuilt 1996 · S/N E-3051N996SMMclay Colin Alasdair · Navasota, TXBuilt 2023 · S/N 9545N9976MBrush Wesley A · Sparks, NVBuilt 1978 · S/N U20604626N9977JBoening Bros Dusting & Spraying Inc · Floresville, TXBuilt 1982 · S/N T18803906TN997AJSky Ark LLC - Series 2 · Las Vegas, NVBuilt 2021 · S/N 2296
Back to AD 2012-10-13