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.

N617VABueso Travel LLC · Gladstone, ORBuilt 2016 · S/N 1237N6180BNewton Raymond C Jr · Heath, TXBuilt 1978 · S/N 21062699N6180NMargiotta Russell A Trustee · Woodside, CABuilt 1978 · S/N 21062951N6183NLewis A Everett Jr · Chico, CAFirst renewal noticeBuilt 1978 · S/N 21062954N6184CRegistered aircraftBuilt 1979 · S/N 21063824N6185BGust William J DBA · Monument, COBuilt 1978 · S/N 21062701N6188XKorotkov Dmitry V · Rocklin, CAS/N 0629N6188YLexington Enterprises Group Inc · San Jose, CABuilt 1981 · S/N 21064287N618ABCss Enterprises Inc · Middletown, DEBuilt 2010 · S/N 3649N618AJCvm Leasing LLC · Angola, NYBuilt 2016 · S/N 4327N618ALDrifting Dirt LLC · Lewes, DEBuilt 2014 · S/N 4064N618BHTkr3 Aviation LLC · Urbandale, IABuilt 1990 · S/N E-2543N618CAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0620N618CJYou Are Too Nosey LLC · Wilmington, DES/N 41032N618JABolle Aviation LLC · Clare, MIS/N 4595N618JLAero Venture LLC · Pasadena, CABuilt 2022 · S/N 8502N618JPBrown Wings LLC · Palm Beach Gardens, FLBuilt 2023 · S/N 9264N618JRRegistered aircraftBuilt 2008 · S/N 2976N618MBSonic Boom Services Inc · Broad Channel, NYBuilt 2004 · S/N 1148N618MROshaughnessy Stephen M · Littleton, COBuilt 1979 · S/N 340A0653N618SHCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11653N618SLCirrus Design Corp · Duluth, MNBuilt 2024 · S/N 10162N618VAToorani Brian B · Irvine, CABuilt 2008 · S/N 2904N6190LPineapple Aviation LLC · Greenville, NCBuilt 2025 · S/N 10768N6192NDolezal Todd R · San Luis Obispo, CABuilt 1978 · S/N 21062963N6192UKings Nw LLC · Lakewood, WABuilt 1979 · S/N U20605377N6192XSongbird Group LLC · Andover, MNBuilt 1978 · S/N 310R1329N6193QRedstar Air Shows Inc · Discovery Bay, CAFirst renewal noticeBuilt 1968 · S/N 320F-0043N6195BBoyd Edward Ayres · Coronado, CABuilt 1978 · S/N 21062705N6196NMccarthy Sean P · Siloam Springs, ARBuilt 1978 · S/N 21062967N619ALLamc Associates LLC · Fargo, NDBuilt 2006 · S/N 1742N619AWAlpha Whiskey Holdings LLC · New York, NYBuilt 2026 · S/N 11242N619CDSimpson Walker Aviation LLC · Joplin, MOBuilt 2005 · S/N 1672N619KGLouises Properties LLC · Huntsville, ALBuilt 2022 · S/N 8974N619MCN619mc LLC · Berkeley, CABuilt 2015 · S/N 1066N619MJVision Transport LLC · West Bloomfield, MIBuilt 2023 · S/N 9494N619MTMiketango LLC · South Jordan, UTBuilt 2015 · S/N 1119N619PMDm Flying LLC · Lighthouse Point, FLBuilt 2007 · S/N 2661N619PSHp3422 Aviation LLC · Palo Alto, CABuilt 2017 · S/N 1502N619RDHunt Aviation LLC · Rochester, MNS/N E-2830N619RLPlane Addiction LLC · Hopkinton, MABuilt 2005 · S/N 1528N619SJPonderosa Aircraft LLC · Great Falls, MTS/N LIV-456N619SMRegistered aircraftBuilt 2023 · S/N 9174N619TPSkyborne LLC · Kaukauna, WIBuilt 2017 · S/N 1483N619TXTtx Air LLC · Sturgeon Bay, WIBuilt 2016 · S/N 1459N619WMKatz Aviation LLC · Riverwoods, ILBuilt 2005 · S/N 1447N61BQEle Motorsports LLC · Dover, DEBuilt 1986 · S/N 21064987N61BSKris & B Holdings LLC · Hyrum, UTBuilt 1993 · S/N EA-544N61BWWelch William Ben · Danville, ILBuilt 2000 · S/N LIV-413N61CBWellness Multiplier Inc · Osage Beach, MOBuilt 2018 · S/N 1809
Back to AD 2012-10-13