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.

N969ARDorsey & Whitney Trust Co LLC Trustee · Seattle, WABuilt 2025 · S/N 10810N969BJ3913x LLC · Shreveport, LABuilt 2004 · S/N 1068N969BSHodges Air LLC · Provo, UTBuilt 2015 · S/N 0969N969DWDe Werd Capital Partners LLC · Los Olivos, CABuilt 2014 · S/N 0935N969JBRoesler Darrell E Jr · Monclova, OHBuilt 2005 · S/N 1280N969RJAerial Robotics Inc · Richmond, UTBuilt 2013 · S/N L2K-291N969SRivas Group LLC · Reno, NVBuilt 1975 · S/N 310R0318N969SLWojcik Bart C · Kimberly, IDBuilt 1975 · S/N 21060915N969SRHull Michael D · West Bloomfield, MIBuilt 2006 · S/N 2111N969SSPowell Aviation LLC · Cartersville, GABuilt 2006 · S/N 2157N969THMgi Proflight LLC · Las Vegas, NVBuilt 1978 · S/N 310R1379N969TMTumu Leasing LLC · Orlando, FLBuilt 2024 · S/N 10128N969TXMowata Farms LLC · Mamou, LAS/N P21000145N96ATN105kl Holdings LLC · Sarasota, FLBuilt 2018 · S/N 4647N96BBMagnolia Capital Group LLC · Santa Rosa, CABuilt 2009 · S/N 3512N96BMKm Medico LLC · Murrieta, CABuilt 1986 · S/N E-2297N96CCInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 21062787N96DFVhl Aviation LLC · Wshngtn Ct Hs, OHBuilt 2022 · S/N 8767N96ESPrist Vitaly · Ivyland, PABuilt 1999 · S/N 004N96FKStalter David James · Goshen, INS/N 1611N96FLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2008 · S/N 2899N96FUFamily Health Care Associates LLC · Manchester, KYBuilt 2022 · S/N 8672N96KJLeslie Leasing LLC · West Palm Beach, FLBuilt 2018 · S/N 1730N96LLHuck-Mag LLC · Plano, TXBuilt 1974 · S/N 21060361N96LSStabler Randall · Scottsdale, AZBuilt 2019 · S/N 1946N96PTEidson Mark C · Weatherford, TXBuilt 1976 · S/N TJ-31N96RHAtlanta Aircraft Group LLC · Atlanta, GABuilt 1981 · S/N P21000720N96SAWolff Dean E · Mesa, AZBuilt 2005 · S/N 1315N96SBBlack Pearl Aviation Inc · Sterling Heights, MIBuilt 2003 · S/N 0465N96SYChristen John C · Tampa, FLBuilt 2001 · S/N 0107N96WEChase Aviation De LLC · Dover, DEBuilt 1996 · S/N TH-1782N96WFBrockman Leland Jay · Horseshoe Bay, TXBuilt 1990 · S/N TH-1595N9700JCrux Logistics & Consulting Ltd · Las Vegas, NVBuilt 1981 · S/N T18803840TN9707JTop Hand Inc · Laurel, MTBuilt 1981 · S/N T18803842TN970GGValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 10146N970SScepter Aero LLC · Waverly, TNBuilt 2020 · S/N 2078N970WZCs2 Holdings LLC · Nashville, TNBuilt 2025 · S/N 10927N971APCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11505N971BIron Mountain Aviation LLC · Lead, SDBuilt 2023 · S/N 9362N971CDHodges Vehicle Rentals LLC · West Branch, MIBuilt 2006 · S/N 1813N971DBTrg Enterprises LLC · Mclean, VABuilt 2022 · S/N 8987N971PDSpyglass Aircraft LLC · Milford, CTBuilt 1997 · S/N TH-1808N971RBleriot LLC · East Hampton, NYBuilt 1993 · S/N E-2831N972BRArrow John · Austin, TXBuilt 2005 · S/N 1712N972CDCranford Michael Glen · Caddo, OKBuilt 2005 · S/N 1562N972CPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 3162N972EUAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2015 · S/N 0972N972JBMotley Kyle · Brentwood, TNBuilt 2006 · S/N 2267N972JHLynetha Aviation LLC · Oshkosh, WIBuilt 2014 · S/N 4059N972JMUltimate Holdco Inc · Mount Airy, NCBuilt 2002 · S/N 0212
Back to AD 2012-10-13