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.

N2744XAccelerated Slipstream LLC · Livermore, CABuilt 1981 · S/N 414A0812N2744YDe Vuyst Richard C · Pampa, TXBuilt 1979 · S/N 340A0943N27457Felix Margarita G · Nogales, AZBuilt 1981 · S/N 414A0813N2745FAlexander Production Co · San Antonio, TXBuilt 1979 · S/N 340A0949N2745GKj3 Air LLC · Mitchell, SDBuilt 1980 · S/N 414A0622N274ASCcp Aviation LLC · Union Grove, NCBuilt 2025 · S/N 10771N274DCMaggie 288 LLC · Quincy, WAS/N 340A0923N274EBBakhit Aviation LLC · Roanoke, VABuilt 2024 · S/N 10239N274EFFour Forces Aviation LLC · Princeton, NJBuilt 2024 · S/N 10198N274EJJab23 LLC · Grand Rapids, MIBuilt 2023 · S/N 9524N274HAPacific Rain Inc · Arroyo Grande, CABuilt 1981 · S/N 21064274N274MRAero Systems Inc · Broomfield, COBuilt 1980 · S/N 402C0274N274MTWos Holdings Vi LLC · Belgrade, MTBuilt 2019 · S/N 1955N274SLHowden Frederick M · Coronado, CAS/N E-2994N274SRTn Sr22 LLC · Farragut, TNBuilt 2007 · S/N 2732N275ABR2box LLC · Dover, DEBuilt 2021 · S/N 5112N275RCGianopoulous William · Lawrence, MAFirst renewal noticeBuilt 1979 · S/N 402C0117N275TCirrusly Flying LLC · Missoula, MTBuilt 2020 · S/N 2083N275TCQualitair LLC Trustee · MichelstadtBuilt 1994 · S/N E2914N2763Valiair Lc Trustee · Casper, WYBuilt 2007 · S/N 2859N276CDGandia Justin Kidd · Chicago, ILBuilt 2005 · S/N 1385N276CMTwo Fly Guys LLC · Orlando, FLBuilt 2006 · S/N 29-0445N276CPRothlisberger Ben · Farmington, MOBuilt 2008 · S/N 3243N276GEMaricorp U S LLC · Shell Knob, MOBuilt 2014 · S/N 4150N276GSSampson Gabriel · Huntsville, UTBuilt 2017 · S/N 1603N277CDSkywalker Stratos LLC · Palo Alto, CABuilt 2026 · S/N 11428N277CMMirasoles Produce USA LLC · Palmurst, TXBuilt 2020 · S/N 2209N277CTRoss Peter W Trustee · Lufkin, TXBuilt 1998 · S/N EA-617N277JDMeadows Construction Corp · Fort Smith, ARBuilt 2008 · S/N 3256N277LMRegistration Pending · Bend, ORRegistration pending, pending cancellationBuilt 2003 · S/N ES122N277RRossignoli Holdings LLC · Atlanta, GABuilt 2025 · S/N 11100N277WWLee Aviation Co LLC · Pensacola, FLBuilt 2023 · S/N 9632N277XSalopek Rett · Las Cruces, NMBuilt 1977 · S/N 414-0925N2786SCake Aviation LLC · Mcgregor, MNBuilt 2018 · S/N 1780N278AZLef278az LLC · San Angelo, TXBuilt 2022 · S/N 8716N278CDCirrus Aviators LLC · Elm Grove, WIBuilt 2002 · S/N 0337N278DBCt42 LLC · New York, NYS/N 29-0301N278EHE&H Aviation LLC · Kennesaw, GABuilt 2020 · S/N 2114N278GZNichols Industrial Construction Co Inc · Birmingham, ALBuilt 2023 · S/N 9535N278JAAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2021 · S/N 5037N278PBP21000318 Inc Trustee · Wilmington, DEBuilt 1979 · S/N P21000318N278SREllsworth Farm LLC · Kingsbury, NYBuilt 2007 · S/N 2419N278TCLittle Bird Air LLC · Wenatchee, WABuilt 2010 · S/N 0064N278WDSnk LLC · Reisterstown, MDBuilt 2011 · S/N 3825N279CPBarnard Henry H III · Albany, GABuilt 2008 · S/N 3221N279CWPapas Plane LLC · Ashland, NEBuilt 2019 · S/N 2004N279JLJml Aviation LLC · Berwyn, PABuilt 2025 · S/N 10729N279JPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 2259N279MTGmcm Aviation LLC · Central, SCBuilt 2007 · S/N 2470N279PSCirrus Design Corp · Duluth, MNBuilt 2023 · S/N 9215
Back to AD 2012-10-13