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.

N3983AUS Department Of Homeland Security · Washington, DCBuilt 2011 · S/N 7101N3990AUS Department Of Homeland Security · Washington, DCS/N 7107N399LGAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8086N39EWTuckamore Aviation Corp · Hudson, MABuilt 2002 · S/N 3570N401RMRegional Air Medical Services Inc. · Jasper, ALBuilt 2004 · S/N 3837N4022DTemsco Helicopters Inc · Ketchikan, AKBuilt 1995 · S/N 2891N402JCJefferson County Sheriffs Office · Birmingham, ALBuilt 2006 · S/N 4184N4035WDepartment Of Homeland Security · Washington, DCBuilt 1996 · S/N 2912N403AETemsco Helicopters Inc · Ketchikan, AKBuilt 2000 · S/N 3281N4048LU S Dept Of Homeland Security · Washington, DCBuilt 1997 · S/N 3020N4055LU S Dept Of Homeland Security · Washington, DCBuilt 1996 · S/N 2916N40584Bristow LLC · Lake Charles, LABuilt 1998 · S/N 2924N405AETemsco Helicopters Inc · Ketchikan, AKBuilt 2000 · S/N 3286N405AMAris Aviation Group LLC · Henderson, NVBuilt 1995 · S/N 2833N405TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4476N4061GBristow LLC · Lake Charles, LABuilt 1997 · S/N 3051N4068WU S Dept Of Homeland Security · Washington, DCBuilt 1996 · S/N 2934N406AMAris Aviation Group LLC · Boulder City, NVBuilt 1990 · S/N 2391N4074EAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1996 · S/N 2950N4075SD&B Global Ventures LLC · Key West, FLBuilt 1997 · S/N 3043N40AKH125 Aviation LLC · Dover, DEBuilt 2021 · S/N 9116N410CKCharm City Aviation LLC · Baltimore, MDBuilt 2004 · S/N 3793N411LHApex Aeronautical · San Antonio, TXBuilt 2009 · S/N 4667N411MBVertical Corp · Kalispell, MTBuilt 2000 · S/N 3309N413EAMadprop LLC · Kalispell, MTBuilt 2022 · S/N 9182N413JMHillsborough County Sheriffs Office · Tampa, FLBuilt 2024 · S/N 9537N413LPCamape Se · Las Piedras, PRBuilt 1999 · S/N 3228N418MDMountain Air Helicopters Inc · Dover, DEBuilt 2004 · S/N 3848N418TYAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4180N4204Air Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4204N420JABristow LLC · Lake Charles, LABuilt 2007 · S/N 4212N4282Air Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4282N437AHRoberts Aircraft LLC · Cheyenne, WYBuilt 2017 · S/N 8419N438MUMarshall University · Huntington, WVBuilt 2012 · S/N 7240N43MJl Mark LLC · Missoula, MTS/N 8967N43SDPinellas County Sheriffs Office · Largo, FLBuilt 2021 · S/N 9149N43VPRoberts Aircraft LLC · Cheyenne, WYBuilt 2000 · S/N 3272N447WAWallasch Aviation LLC · Alpine, WYBuilt 2023 · S/N 9447N448AEShedhorn Construction Inc · Bozeman, MTBuilt 1999 · S/N 3210N4497YAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4497N451FMayor And City Council Of Baltimore · Baltimore, MDBuilt 2022 · S/N 9250N451HIsland Helicopters Kauai Inc · Lihue, HIBuilt 1999 · S/N 3231N452FMayor And City Council Of Baltimore · Baltimore, MDBuilt 2022 · S/N 9293N453FMayor And City Council Of Baltimore · Baltimore, MDBuilt 2023 · S/N 9317N455GFAdventaire LLC · Minot, NDBuilt 2010 · S/N 4932N456WXAirbus Helicopters Inc · Grand Prairie, TXS/N 9975N461SAAir Twinlite Inc Trustee · Wilmington, DEBuilt 2002 · S/N 3605N464RMRegional Air Medical Services Inc · Jasper, ALBuilt 2005 · S/N 3962N472LALapd Air Support Division · Los Angeles, CABuilt 2018 · S/N 8472N474RSLabell Aviation LLC · Spring Hill, FLS/N 9012
Back to AD 2012-17-03