AD 2012-17-03

Registered aircraft · 920

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-17-03')
    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-17-03')
  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.

N227TXTexas Department Of Public Safety · Austin, TXBuilt 2025 · S/N 9786N228LACity Of Los Angeles · Los Angeles, CABuilt 2000 · S/N 3316N229AHMiller Jason · Scottsdale, AZBuilt 2023 · S/N 9353N229LACity Of Los Angeles · Los Angeles, CABuilt 2000 · S/N 3317N229MTMed-Trans Corp · Denton, TXBuilt 2022 · S/N 9203N230AHAir Methods LLC · Greenwood Village, COBuilt 2024 · S/N 9674N230LALapd Air Support Division · Los Angeles, CABuilt 2020 · S/N 8794N232LACity Of Los Angeles · Los Angeles, CABuilt 2023 · S/N 9298N232SHJc Aircraft Leasing LLC · Wasilla, AKS/N 7850N233LACity Of Los Angeles · Los Angeles, CABuilt 2024 · S/N 9428N233PAComanche Maverick Air LLC · Houston, TXBuilt 2018 · S/N 8507N234BHBrainerd Helicopters Inc · Leesburg, FLBuilt 2012 · S/N 7398N234BUHeli-USA Corp · Houston, TXS/N 1210N2374FTexas Department Of Public Safety · Austin, TXBuilt 2020 · S/N 8817N237BSSky High Leasing LLC · Montrose, COBuilt 2013 · S/N 7542N239AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2023 · S/N 9386N23HSVertical Corp · Kalispell, MTBuilt 2013 · S/N 7550N242ADepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N 7176N243GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4617N244CPAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2010 · S/N 7036N244TXBrenthel Industries LLC · Helena, MTBuilt 2008 · S/N 4408N249AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9878N250AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 9741N251HIsland Helicopters Kauai Inc · Lihue, HIBuilt 2005 · S/N 3975N252CHCoastal Helicopters Inc · Juneau, AKBuilt 1996 · S/N 2954N253AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9973N253CHCoastal Helicopters Inc · Juneau, AKBuilt 1997 · S/N 2974N253LFAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7158N255LFAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7140N255PJArk Aviation LLC · Central City, KYBuilt 2018 · S/N 8595N257AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7203N261AWAll Wool Aviation LLC · Coral Gables, FLBuilt 2014 · S/N 7869N261NDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8916N262TWRegistered aircraftBuilt 2012 · S/N 7333N2658Department Of Homeland Security · Washington, DCBuilt 2021 · S/N 8959N267ADepartment Of Homeland Security · Washington, DCS/N 7222N267AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7215N267LALapd Air Support Division · Los Angeles, CABuilt 2017 · S/N 8267N268JAirbus Helicopters Inc · Grand Prairie, TXS/N 9916N26HXNs Air Leasing LLC · Wilmington, DEBuilt 2007 · S/N 4385N270PWTexas Parks And Wildlife Department · Austin, TXBuilt 2023 · S/N 9374N274CHWalker Kenneth E · Ford City, PABuilt 1989 · S/N 2306N275BPCity Of Burbank · Burbank, CAS/N 1930N2770KAirbus Helicopters Inc · Grand Prairie, TXNon-citizen corporation, flight hours not reportedS/N 9854N279AMAir Methods LLC · Greenwood Village, COS/N 4685N279CHCoastal Helicopters Inc · Juneau, AKBuilt 1979 · S/N 1149N27WAWings Air Helicopters LLC · West Harrison, NYBuilt 1994 · S/N 2792N288WSWorld Trade Enterprises LLC · Lucas, TXBuilt 1988 · S/N 2087N28LBCity Of Long Beach · Long Beach, CABuilt 2003 · S/N 3757N2907ADepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9216
Back to AD 2012-17-03