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.

N17ECLinggi Asset Holdings LLC · Sheridan, WYBuilt 2026 · S/N 11421N17EUCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11409N17JTCirrus Design Corp · Duluth, MNS/N 11736N17KDAht Aviation LLC · Doral, FLBuilt 2020 · S/N 2065N181BCBlue Chip Aviation Services LLC · Cincinnati, OHBuilt 2026 · S/N 11143N181CCLegacy Air Services LLC · Lafayette, LABuilt 2019 · S/N 2017N181DBPleasant City Aviation LLC · Shelby, NCBuilt 2020 · S/N 2212N181MKHarlow Builders Inc · Troy, OHBuilt 2015 · S/N 1105N181SPIkway Air LLC · St Charles, ILBuilt 2023 · S/N 9121N181WRunway Group LLC · Bentonville, ARBuilt 2013 · S/N 0675N1822FFoxtrot Tango Aviaiton LLC · West Palm Beach, FLBuilt 2024 · S/N 10270N183CACloud Asset LLC · Thomasville, GABuilt 2026 · S/N 11195N183KSN183ks LLC · Houston, TXBuilt 2019 · S/N 1891N183PHVestal Aviation LLC · Thomasville, NCBuilt 2010 · S/N 0062N183SFGrand Cove Support Services LLC · Denver, COBuilt 2018 · S/N 1737N183SRRyder Aviation LLC · Tucson, AZBuilt 2025 · S/N 10401N183XIcg Aviation LLC · Ankeny, IABuilt 2017 · S/N 1479N184MCWest Houston Flippers LLC · Dallas, TXBuilt 2014 · S/N 0962N184MGClt Aviation LLC · Loxahatchee, FLBuilt 2018 · S/N 1676N184PMMccoy Michael A · Granbury, TXBuilt 2016 · S/N 1234N186CGPine Needle Air LLC · Santa Rosa Beach, FLBuilt 2016 · S/N 1443N188AJA&J Specialties LLC · Hickory, PABuilt 2025 · S/N 10762N188LSJms Small Aircraft Fl LLC · Aventura, FLBuilt 2022 · S/N 8933N188MHAndree'S Avion LLC · Santa Fe, NMBuilt 2013 · S/N 0499N189MCThree Thirty Three LLC · Wilmington, DEBuilt 2010 · S/N 0045N189PWArrivee LLC · Manhattan Beach, CABuilt 2019 · S/N 1964N189STSierra Tango Aviation LLC · Colleyville, TXBuilt 2026 · S/N 11452N18AS1607 Vistas LLC · Fort Lauderdale, FLBuilt 2023 · S/N 9059N18BCT-Air LLC · Schofield, WIBuilt 2024 · S/N 10119N18CKHatch Aviation LLC · New Braunfels, TXBuilt 2017 · S/N 1581N18CYBraylin Air LLC · Jupiter, FLBuilt 2018 · S/N 1740N18EUCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11416N18PYHeavenly Flight LLC · Cumming, GABuilt 2022 · S/N 8856N18SYWingz Wi LLC · Milwaukee, WIBuilt 2024 · S/N 10038N191AHCirrus Sr22t Athens Blue Inc Trustee · Wilmington, DEBuilt 2021 · S/N 2354N191JBGraeves Auto & Appliance Inc · Olney, MDBuilt 2016 · S/N 1396N191WLHatchery Investments LLC · Truckee, CABuilt 2015 · S/N 1098N191WTBrightpipe Air LLC · Mableton, GABuilt 2025 · S/N 11057N1924W1824 Whiskey LLC · Golf, ILBuilt 2023 · S/N 9493N192BCLeo Aviation Inc · Rogers, ARBuilt 2024 · S/N 10246N1931MAnchor Aviation LLC · Johnstown, COBuilt 2024 · S/N 10392N194DCA440 Holdings LLC · Brentwood, TNBuilt 2014 · S/N 0794N1957CJbc 514 Capital Holdings LLC · Santa Ana, CAFirst renewal noticeBuilt 2013 · S/N 0514N195CSTritten Aviation LLC · Weston, WIBuilt 2023 · S/N 9464N195MBRoom For More LLC · Salt Lake City, UTBuilt 2025 · S/N 11066N195WPWhiskey Papa Aviation LLC · Atlanta, GABuilt 2025 · S/N 10407N1971CAndrews Aviation LLC · Columbia, MOBuilt 2024 · S/N 10363N1974GAirmax LLC · London, KYS/N 1297N1975Henay Air LLC · Windermere, FLBuilt 2021 · S/N 2375N1975PBarry Aviation LLC · Boise, IDBuilt 2022 · S/N 9016
Back to AD 2012-01-11