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.

N5261JAc67333 Inc · Wilmington, DEBuilt 1976 · S/N 414-0852N5261WHodge Nicholas C · Spokane, WABuilt 2004 · S/N 0845N5263VMccullough James M · Monte Vista, COBuilt 1975 · S/N 21060883N5264CCullum Transportation LLC · North Charleston, SCBuilt 1979 · S/N 21063725N5264JBrowne Bryan C · Allen, TXBuilt 1976 · S/N 414-0854N5265JSouthern Machine And Steel Inc · Fort Myers, FLBuilt 1976 · S/N 414-0855N5267VN5267v LLC · Northbrook, ILBuilt 1975 · S/N 21060886N526CAM & M Aviation LLC · Pompano Beach, FLBuilt 2026 · S/N 11205N526CHSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N P21000662N526HDTensor Air LLC · Atlanta, GABuilt 2022 · S/N 8887N526PWSoil Technologies Inc · Mobridge, SDBuilt 2013 · S/N 0622N526SCorvo Alberto · New York, NYBuilt 2005 · S/N 1667N526SRBarrow James E Jr · Keysville, GABuilt 2006 · S/N 2253N526TBElevate Aviation LLC · Leesburg, VABuilt 2016 · S/N 1326N526TSN526ts LLC · Lake Charles, LABuilt 2018 · S/N 4675N526ZKPyng LLC · Palo Alto, CABuilt 2022 · S/N 8885N5274YMba Sales LLC · Ridgefield, WABuilt 1980 · S/N 21064147N5275VViatrans LLC · Pryor, OKBuilt 1975 · S/N 21060890N5276AOstermeier Brigitte · MaunNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 21063341N5276VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 21060891N5277PBennett Glenn D · Kingwood, TXBuilt 1977 · S/N 21061784N527AGBroken Road Aviation LLC · Kerrville, TXBuilt 2006 · S/N 1770N527CDAircraft Medical Solution LLC · Kissimmee, FLBuilt 2005 · S/N 1628N527CFCommander Aircraft Services Inc · West Palm Beach, FLBuilt 2024 · S/N 10205N527CPBimski Holdings LLC · Orem, UTS/N 3029N527CRJoe Wagner IV Construction LLC · Zebulon, NCBuilt 2010 · S/N 3577N527JHTugende LLC · Montrose, COBuilt 1979 · S/N 340A0782N527JKBeckair LLC · Ankeny, IABuilt 2008 · S/N 2950N527LQBombing Buckeyes Leasing LLC · Gallatin, TNBuilt 2015 · S/N 1110N527PSVb Orthopaedics Pa · Stephenville, TXBuilt 2015 · S/N 1034N527RSRamsey Wayne V III · Abilene, TXBuilt 1999 · S/N E3222N527TCLeonardo Paul A III · Merced, CABuilt 1991 · S/N EA-527N527THGlad Investing Partners Ltd · Saginaw, TXBuilt 2021 · S/N 2430N527TMCampbell Air Services Inc · Roseville, CABuilt 2006 · S/N 29-0451N527TRDawson Kevin · Colorado Springs, COBuilt 2002 · S/N 0265N527WMitchell Grayson · Milledgeville, GABuilt 2000 · S/N 29-0224N527WWAirtime Flying Club LLC · Richmond, VABuilt 2008 · S/N 3118N527WYUncle Phils LLC · Sheridan, WYBuilt 2022 · S/N 8851N52840N52840 LLC · New York, NYFirst renewal noticeBuilt 1988 · S/N 24-1683N5285PFrank Investments Inc · Austin, TXBuilt 1996 · S/N 29-0081N5287ATax Busters Inc · El Paso, TXBuilt 1979 · S/N 21063349N5287YMorrow Aviation LLC · Midland, TXS/N 21064152N528AWRising Sunset LLC · Hermitage, TNBuilt 2023 · S/N 9583N528BJN528bj LLC · Sandyville, WVBuilt 2022 · S/N 8884N528CAWile Frederick A · Meridian, MSBuilt 2026 · S/N 11208N528CMEmi Aviation LLC · Ventura, CABuilt 2019 · S/N 1966N528DBRegistered aircraftBuilt 2015 · S/N 4248N528DLLlt LLC · Middleton, WIBuilt 2022 · S/N 9004N528HBCbs Aviation LLC · Clovis, CABuilt 2019 · S/N 2037N528HEKingdom Airworks LLC · Las Vegas, NVBuilt 2005 · S/N 1409
Back to AD 2012-10-13