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.

N197CMLester Labs LLC · Cloverdale, CABuilt 2018 · S/N 1723N1986PRegistered aircraftBuilt 2020 · S/N 2207N1993BWalton Andrew C Trustee · Rocklin, CABuilt 2020 · S/N 2111N199DVDvauction Inc · Crofton, NEBuilt 2018 · S/N 1770N199EC4af Management LLC · Huntington Beach, CABuilt 2025 · S/N 10600N199EEClk Aviation LLC · Canandaigua, NYBuilt 2015 · S/N 1091N199MGMike Goulian Airshows Inc · Plymouth, MABuilt 2024 · S/N 10265N199TBA-V-Ation LLC · Houston, TXBuilt 2020 · S/N 2109N199WFYeti Aviation LLC · Truckee, CABuilt 2014 · S/N 0720N19CGTrikay LLC · Midland, GABuilt 2017 · S/N 1568N19DWVha Aviation Inc Trustee · Wilmington, DEBuilt 2018 · S/N 1686N19DZMeyer Kennethtrustee · Chester, CABuilt 2023 · S/N 9280N19EAEa Aviation LLC · Kalispell, MTBuilt 2026 · S/N 11241N19EMAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2025 · S/N 10863N19KEPopcorn In The Clouds LLC · Farmington, NMBuilt 2020 · S/N 2194N19LJSr22t LLC · Chattanooga, TNBuilt 2023 · S/N 9116N19RWSkyrider Aviation LLC · Wilmington, DEBuilt 2022 · S/N 8656N19SYRanalli Douglas J · Naples, FLBuilt 2022 · S/N 8858N1CJSandy Air LLC · Austin, TXBuilt 2019 · S/N 1941N1PLMtma Consulting LLC · Emerald Isle, NCBuilt 2018 · S/N 1687N2007Bondair LLC · Seattle, WABuilt 2023 · S/N 9384N201AHPrje Technology Services LLC · Kalispell, MTBuilt 2013 · S/N 0498N201FDCavu 22 LLC · Stuart, FLBuilt 2025 · S/N 10391N2026ACirrus Design Corp · Duluth, MNS/N 11729N202BHarper Aviation LLC · Arlington, TXBuilt 2025 · S/N 10730N202FDPro Ag Aviation LLC · Luverne, MNBuilt 2025 · S/N 10394N202SRCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11394N203FDBiricik Cemhan · Boca Raton, FLBuilt 2025 · S/N 10395N2041CFly Frannie LLC · Scottsdale, AZBuilt 2023 · S/N 9047N204CDChmielewski David · Sevierville, TNBuilt 2026 · S/N 11182N205ASTurnbull Moak & Pendergrass LLC · Birmingham, ALBuilt 2023 · S/N 9344N205CDNuclear Speed Inc · Emerald Hills, CABuilt 2023 · S/N 9145N205SC5sc LLC · Bismarck, NDBuilt 2025 · S/N 10630N205SRCirrus Design Corp · Duluth, MNS/N 11801N205WHJp Real Estate Management Inc · Van Nuys, CABuilt 2020 · S/N 2051N206SMAugusta Aviation LLC · Madison, MSBuilt 2011 · S/N 0171N207AEAe Leasing LLC · Biddeford, MEBuilt 2024 · S/N 9820N209MEUnbound Aviation LLC · Kalispell, MTBuilt 2021 · S/N 2366N20KKChimney Pond Aviation LLC · New York, NYBuilt 2013 · S/N 0676N20MLRegistration Pending · Yorba Linda, CARegistration pendingBuilt 2019 · S/N 1945N20PYSvinth James B Trustee · Coto De Caza, CABuilt 2021 · S/N 2318N20PZBend Aviation Specialties LLC · Portland, ORBuilt 2014 · S/N 0775N210ALE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2013 · S/N 0549N210CAPennmark Air LLC · Plymouth Meeting, PABuilt 2023 · S/N 9466N210CBCampbell Terry G Trustee · San Francisco, CABuilt 2025 · S/N 10411N211ALMallory Equipment Leasing LLC · Portland, ORBuilt 2022 · S/N 8985N211CKClark Kim A · Rogers, ARBuilt 2015 · S/N 1025N211FDVuelo Seguro LLC · North Logan, UTBuilt 2025 · S/N 10396N211PFJed Air LLC · Buena Vista, COBuilt 2022 · S/N 8721N211RVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 2236
Back to AD 2012-01-11