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.

N212DSFlying Bee Aviation LLC · Delphi, INBuilt 2023 · S/N 9539N212LLLunch Mony LLC · Fort Worth, TXBuilt 2016 · S/N 1236N212RNoodlebop Inc · Provincetown, MABuilt 2026 · S/N 11176N212RRN2u Equipment Leasing LLC · Newark, DEBuilt 2021 · S/N 2357N212TXCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11523N212WVKoval John S Trustee · Marysville, OHBuilt 2022 · S/N 8950N213AGCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11548N213ARAdelle Aviation LLC · Sacramento, CABuilt 2013 · S/N 0623N213CGThomas Leasing LLC · Niota, TNBuilt 2016 · S/N 1409N213KSTenedos LLC · Tacoma, WABuilt 2017 · S/N 1490N213KTCirrus Middle East Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11576N213LMDavis Aircraft LLC · Sarasota, FLBuilt 2023 · S/N 9458N214MWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2014 · S/N 0840N214WFWathen Aviation Inc · Hilliard, OHBuilt 2014 · S/N 0918N214ZARegistered aircraftBuilt 2016 · S/N 1338N215AEN215ae LLC · Dover, DEBuilt 2026 · S/N 11463N215FJOzark Machinery Transportation LLC · West Plains, MOBuilt 2018 · S/N 1742N215GPPoint To Point LLC · Missoula, MTBuilt 2012 · S/N 0331N215JGClower Aviation LLC · Owasso, OKBuilt 2013 · S/N 0486N215TTEcho Whiskey Charlie LLC · Midland, TXBuilt 2013 · S/N 0458N216BDBoldmethod Air LLC · Boulder, COBuilt 2017 · S/N 1550N216GLDvhoops Holdings LLC · Dakota Dunes, SDBuilt 2018 · S/N 1733N216HBMorganaire LLC · Flowery Branch, GABuilt 2024 · S/N 10274N216SYWings Flights Of Hope Inc · Orchard Park, NYBuilt 2016 · S/N 1280N217CTLethalairllc · Camden, DEBuilt 2017 · S/N 1475N217JFBcd Aviation LLC · Chicopee, MABuilt 2014 · S/N 0932N217JKRamp Air LLC · Clayton, NCBuilt 2019 · S/N 1901N217SKThrust Aviation LLC · George West, TXBuilt 2014 · S/N 0817N217SYRegistration Pending · Pratt, KSRegistration pendingBuilt 2017 · S/N 1595N217YWhisper Rock LLC · San Antonio, TXBuilt 2017 · S/N 1629N218BJCatalina Sky Aviation LLC · San Diego, CABuilt 2019 · S/N 2030N218HGDesert Aviation LLC · Kingman, AZBuilt 2017 · S/N 1632N218HLCapital Flight LLC · El Paso, TXBuilt 2016 · S/N 1310N218RHRjh Capital Holdings LLC · Newark, DEBuilt 2021 · S/N 2352N218RWGba Holdings LLC · Carson City, NVBuilt 2020 · S/N 2066N218SY46u LLC · Anaconda, MTBuilt 2018 · S/N 1720N218VBCornelius Brett · Brentwood, TNBuilt 2016 · S/N 1378N219CTCp Air LLC · Omaha, NEBuilt 2019 · S/N 2021N219RSCastle Peak Leasing LLC · Soda Springs, CABuilt 2020 · S/N 2086N219SEMid-Continental Aviation LLC · Wilmington, DEBuilt 2019 · S/N 1879N219SYC9 Equipment LLC · Phoenixville, PABuilt 2019 · S/N 1890N219TWKingdom Leasing LLC · Sheridan, WYBuilt 2014 · S/N 0862N21BQSri Flying Club Inc · Menlo Park, CABuilt 2016 · S/N 1284N21EUKuppinger Aviation Services LLC · Kissimmee, FLBuilt 2021 · S/N 2242N21FKAfk Logistics Inc · Mckees Rocks, PABuilt 2024 · S/N 9811N21JZGolden Goose Air LLC · Incline Village, NVBuilt 2019 · S/N 1907N21LXMojo Aircraft LLC · Lebanon, TNBuilt 2025 · S/N 10998N21PKBreeze Air LLC · Las Vegas, NVBuilt 2020 · S/N 2121N21UBThesan Holdings LLC · Fort Worth, TXBuilt 2023 · S/N 9608N220CTCirrus Design Corp · Duluth, MNS/N 0104
Back to AD 2012-01-11