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.

N139LCAmedeo Flight Ops Limited · Dublin 2Built 2018 · S/N 1769N13ETRp Aviation LLC · East Troy, WIBuilt 2017 · S/N 1633N13LJLs Leasing LLC · Franklin, TNBuilt 2020 · S/N 2135N13MEMoonshine High LLC · Midland, TXBuilt 2025 · S/N 10661N13QAConscient LLC · Menlo Park, CABuilt 2020 · S/N 2099N13URQualitair LLC Trustee · MichelstadtBuilt 2025 · S/N 11039N1416CSpanos Dean T · Port Matilda, PABuilt 2015 · S/N 1198N141JWGray William C · Starkville, MSBuilt 2010 · S/N 0058N141KJVelox Aegis Inc Trustee · Wilmington, DEBuilt 2014 · S/N 0832N141KTAscensis LLC · Wilmington, DEBuilt 2022 · S/N 8537N142DBN 10 Aviation LLC · Gallatin, TNBuilt 2019 · S/N 1894N142PFirelands Management LLC · Sandusky, OHBuilt 2024 · S/N 10220N142RDS-Turns LLC · Indn Hbr Bch, FLBuilt 2024 · S/N 10361N142WAWhisair LLC · Little Rock, ARBuilt 2024 · S/N 9788N1439010319 LLC · Hudson, NHBuilt 2023 · S/N 9266N143FL143fl LLC · Roseville, MIBuilt 2026 · S/N 11180N143MDEgnazia Plane LLC · Miami, FLBuilt 2025 · S/N 10440N143PMStorm Aviation LLC · Sacramento, CABuilt 2020 · S/N 2085N143RSKidwell Aviation LLC · Apopka, FLBuilt 2020 · S/N 2219N143SGPalm Tree Aloha Aviation LLC · Cameron Park, CABuilt 2026 · S/N 11514N143WWNielsen Mark Andrew Trustee · Pagosa Springs, COBuilt 2018 · S/N 1734N148BDMaroon Mountain Aviation LLC · Edwards, COS/N 0369N148CPKnepper Andrew M · Woodville, OHBuilt 2019 · S/N 1994N148LCJ W Venture Aviation LLC · Concord, NCBuilt 2010 · S/N 0048N148MDPodaddy Enterprises LLC · Acworth, GABuilt 2017 · S/N 1480N1495TRossi Aviation LLC · Mount Airy, MDBuilt 2025 · S/N 11029N14DTCirrus Design Corp · Duluth, MNS/N 11853N14PGI3 Cirrus Holding LLC · Houston, TXBuilt 2019 · S/N 1852N1508KWny Aero LLC · Orchard Park, NYBuilt 2010 · S/N 0042N150GVy Holdings LLC · Midland, GABuilt 2025 · S/N 10723N151ALCirrus Sr22t 11110 Inc Trustee · Wilmington, DEBuilt 2025 · S/N 11110N151JCFlying Scotsman Inc · Boston, MABuilt 2025 · S/N 11027N151TCCtc Aviation LLC · Toccoa, GABuilt 2020 · S/N 2120N152JTStork LLC · Winston Salem, NCBuilt 2014 · S/N 0751N15317Hold East Right Turns LLC · Austin, TXBuilt 2021 · S/N 2444N154CRPacific Avion LLC · Temecula, CABuilt 2016 · S/N 1273N154WPWhiskey Papa Air LLC · Flower Mound, TXBuilt 2019 · S/N 1954N155KMMcintyre Kristen Alison · San Jose, CABuilt 2010 · S/N 0027N155MVBernman LLC · Scarborough, MEBuilt 2015 · S/N 1101N156AKCress LLC · Dover, DEBuilt 2017 · S/N 1609N157DFair Haven Aviation LLC · San Francisco, CABuilt 2025 · S/N 10402N157PGN777sb LLC · Helena, MTBuilt 2025 · S/N 11064N157WFHelping Hands Partners II LLC · Wilmington, DEBuilt 2016 · S/N 1392N159JPCirrus Design Corp · Duluth, MNS/N 11818N15EUCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11379N15TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 8528N15VSCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11458N15ZRN822js LLC · Norcross, GABuilt 2013 · S/N 0628N1618AOne Eight Alpha LLC · Rch Palos Vrd, CABuilt 2024 · S/N 9918N161CDGreen Slip LLC · Valparaiso, INBuilt 2020 · S/N 2088
Back to AD 2012-01-11