AD 2012-01-11

Registered aircraft · 3,100

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-01-11')
    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-01-11')
  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.

N161JWRjss Aviation LLC · Portland, ORS/N 0762N1620BNatrix Aviation LLC · Sagaponack, NYBuilt 2026 · S/N 11275N162BFlight 19 LLC · Atlanta, GABuilt 2024 · S/N 10375N162CFGroeneveld Lisa · South Burlington, VTBuilt 2025 · S/N 10769N162JBGjm Aviation LLC · Petal, MSBuilt 2022 · S/N 8579N163SDAre You Cirrus LLC · Glasgow, MTBuilt 2013 · S/N 0662N164CPHighwings LLC · West Fargo, NDBuilt 2014 · S/N 0891N164CTBuckley Aviation LLC · Swainsboro, GABuilt 2016 · S/N 1267N164KFValiair Ltd Co Trustee · Casper, WYBuilt 2016 · S/N 1320N164KXN164kx LLC · Charlotte, NCBuilt 2015 · S/N 1064N164TBBuzza Tim · Cudjoe Key, FLBuilt 2020 · S/N 2094N165JBN165jb LLC · Dayton, OHBuilt 2024 · S/N 10237N165LMSig Cirrus LLC · Powell, OHBuilt 2014 · S/N 0960N165LRAircraft Trustee Services Inc Trustee · Dover, DES/N 0632N165MWN723 LLC · Denver, COBuilt 2016 · S/N 1420N166BGColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2023 · S/N 9505N166CAMca Aviation LLC · Cartersville, GABuilt 2026 · S/N 11117N166SMRegistered aircraftRegistration pending, pending cancellationBuilt 2023 · S/N 9461N167AJRogers Wallace III · San Antonio, TXBuilt 2017 · S/N 1515N167JCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 9410N167KMRegistered aircraftBuilt 2025 · S/N 10462N168AGN168 LLC · Irvine, CABuilt 2024 · S/N 10211N168PSBkt LLC · Leawood, KSBuilt 2023 · S/N 9173N169MRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2016 · S/N 1331N16EUCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11380N16MTAmarone LLC · Charleston, SCBuilt 2020 · S/N 2058N16MXCirrus Design Corp · Duluth, MNS/N 11881N16MYAgi Inc · La Canada Flt, CABuilt 2025 · S/N 10476N16YZBerit Merkab LLC · Monroe, NCBuilt 2020 · S/N 2075N1713HGay James · Rochester, MNBuilt 2014 · S/N 0944N171FRSilver Fox Aviation LLC · Milstone, NJBuilt 2026 · S/N 11212N171HZLt Aviation LLC · Downers Grove, ILBuilt 2019 · S/N 2022N171TXMigliorini Alexander P · Eureka, CABuilt 2011 · S/N 0203N173CKKali Equipment 2 LLC · Burlingame, CABuilt 2018 · S/N 1727N174GLAviation Services LLC · Chicago, ILS/N 10740N174MHMartins Aviation LLC · London, KYBuilt 2023 · S/N 9038N174MPCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11519N174SKSaltt Air LLC · Oakland, MDBuilt 2018 · S/N 1741N1767PSteciuk Paul B · Saratoga Springs, NYBuilt 2011 · S/N 0133N176FDCirrus Design Corp · Duluth, MNS/N 11776N176KMAssociated Packaging Inc · Gallatin, TNBuilt 2019 · S/N 1851N176QBse & Associates Inc · Sacramento, CABuilt 2019 · S/N 1898N176WEFlying D Labs LLC · Bend, ORBuilt 2016 · S/N 1283N1776XAgl Aviation LLC · Temecula, CABuilt 2023 · S/N 9492N178ATFraser Jamie A · Nokomis, FLBuilt 2024 · S/N 9813N178CATeddymax LLC · Sarasota, FLBuilt 2026 · S/N 11194N1798ZCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11602N179JDFarnborough Aircraft Inc Trustee · Wilmington, DEBuilt 2017 · S/N 1527N17DARegistration Pending · Pecos, NMRegistration pendingBuilt 2024 · S/N 10329N17DTFinney Aviation LLC · Bloomington, INBuilt 2019 · S/N 1974
Back to AD 2012-01-11