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.

N3959POmaha Aircraft LLC · Blair, NES/N P21000075N395CDSimpson Russell · Nantucket, MABuilt 2005 · S/N 1263N395CPVallencourt Jonathan Daniel · Green Cove Springs, FLBuilt 2008 · S/N 3149N395DATriton Polaris LLC · Suwanee, GABuilt 2026 · S/N 11399N395LMMj&J LLC · Dodge City, KSBuilt 2005 · S/N 1395N395SAFmco Promotions Inc · North Little Rock, ARBuilt 2000 · S/N E-3313N3968QTundra Wings Ministries · Wasilla, AKBuilt 1975 · S/N U20603037N396BSpring Creek Financial Inc · Lewistown, MTBuilt 1992 · S/N EA-537N397AGMelmed Gavin · Dallas, TXBuilt 2026 · S/N 11493N397AWPapa Tango Aviation LLC · Kalispell, MTBuilt 1980 · S/N TJ-207N397DDDelta Delta LLC · Washington, DCBuilt 2023 · S/N 9131N3983GBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 340A0255N398DLWiley David J · Emmetsburg, IABuilt 2025 · S/N 10720N398EHayes Aero Design Group LLC · Palm Beach Gardens, FLBuilt 2024 · S/N 10390N398JTNiner18 Ventures LLC · Kingsville, MDBuilt 2023 · S/N 9238N398LJDakota Heavy Equipment · Fargo, NDBuilt 1988 · S/N EA-471N398MWJtde Aircraft Holdings LLC · Lebanon, OHBuilt 2013 · S/N 4010N398SAirscrew Aviation LLC · Youngstown, OHBuilt 2010 · S/N ESP 212-12N3992GFlat Earth LLC · Kalispell, MTS/N U2060992N3995GCutting Edge Design & Contracting-Sc Inc · Elgin, SCBuilt 1968 · S/N U206-0995N399BWCharleston Executive Aviation LLC · Johns Island, SCBuilt 2026 · S/N 11156N399CAHoman Mark A · Wake Forest, NCBuilt 1988 · S/N EA-478N399DDFly Flying Buffalo LLC · Dawson, GABuilt 2020 · S/N 4927N399DZRegistration Pending · Bettendorf, IARegistration pendingBuilt 2026 · S/N 11360N399KMCustodio Olga · San Antonio, TXBuilt 1973 · S/N 21059982N399SMShroder Partners LLC · Sarasota, FLBuilt 2018 · S/N 1820N399TABeattie Richard N Trustee · Anacortes, WABuilt 2000 · S/N E-3311N39AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 4883N39BTMidwest Aerial Photography · Galloway, OHBuilt 1974 · S/N 310Q1137N39CDTexas Wings In The Air II LLC · El Paso, TXBuilt 2016 · S/N 1466N39DDLarson Danny O · Palmer, AKBuilt 1973 · S/N 340-0246N39EETamburo Michael J · Adkins, TXBuilt 2011 · S/N 3775N39HCTherapy Air LLC · Midland, TXS/N 414-0469N39HWApple & Vine Aviation Services LLC · Reidsville, GABuilt 2000 · S/N 29-0215N39JSWestland Business Services Inc · Gallatin Gateway, MTBuilt 2023 · S/N 9163N39KCCapital Holdings 245 LLC · Newark, DEBuilt 2024 · S/N 10373N39LFFeingersh Larry · Houston, TXBuilt 2023 · S/N 9531N39TKCold Water Aviation LLC · Wabasso, MNBuilt 1983 · S/N EA-394N39VFLight Source Inc · Charlotte, NCBuilt 2020 · S/N 2231N39VPCare Flight LLC · Camden, DEBuilt 2014 · S/N 0848N39WGAerojet Solutions LLC · Sarasota, FLBuilt 2009 · S/N ES-39-AN39WVLojac Air LLC · Yukon, OKBuilt 2008 · S/N 3196N3AFAf Air LLC · Tulsa, OKBuilt 2025 · S/N 10568N3CBAk Aviation LLC · Melbourne, FLBuilt 2025 · S/N 11083N3CCN3cc LLC · Auburn, ALBuilt 2018 · S/N 1807N3CFFlying Success LLC · Apex, NCBuilt 2025 · S/N 10580N3CK3ck LLC · Bellevue, WABuilt 2018 · S/N 1805N3CYSchultz Daniel A · Tipp City, OHBuilt 1972 · S/N P3370022N3DQCrescent Aviation LLC · Rllng Hls Est, CAFirst renewal noticeBuilt 1970 · S/N 414-0056N3ELTwo If Buy LLC · Nashua, NHBuilt 1978 · S/N 340A0525
Back to AD 2012-10-13