AD 2012-24-03

Registered aircraft · 363

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-24-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-24-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.

N145SDAvera Mckennan · Sioux Falls, SDBuilt 2013 · S/N 9657N145SUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 9102N145SZU S Bank Na · Marshall, MNBuilt 2013 · S/N 9637N145THTemsco Helicopters Inc · Ketchikan, AKBuilt 2003 · S/N 9060N145TJAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 9197N145TNAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 9092N145TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 9166N145UCUniversity Of Cincinnati Medical Center LLC · Cincinnati, OHBuilt 2011 · S/N 9494N145WCUc Health LLC · Cincinnati, OHBuilt 2012 · S/N 9535N146HHHartford Hospital · Hartford, CTBuilt 2016 · S/N 9737N146THTemsco Helicopters Inc · Ketchikan, AKBuilt 2004 · S/N 9065N147THTemsco Helicopters Inc · Ketchikan, AKBuilt 2005 · S/N 9070N148THTemsco Helicopters Inc · Ketchikan, AKBuilt 2008 · S/N 4623N149AHAdventist Health System Sunbelt Inc DBA · Altamonte Springs, FLBuilt 2021 · S/N 9868N149THTemsco Helicopters Inc · Ketchikan, AKBuilt 2005 · S/N 9071N14UHLta Group Holdings LLC · Amarillo, TXBuilt 2010 · S/N 9365N153AEPhi Health LLC · Tempe, AZBuilt 2004 · S/N 3829N15NSChopper 3 LLC · Dover, DEBuilt 1997 · S/N 3014N171PDSuffolk County Police Dept · Yaphank, NYBuilt 2012 · S/N 9580N184WKFlight For Life Inc · Waukesha, WIBuilt 2008 · S/N 9171N186ARegistered aircraftN-number assigned, not yet registeredS/N 9444N187AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3846N191LLIndiana University Health Inc · Indianapolis, INBuilt 2009 · S/N 9319N192LLIndiana University Health Inc · Indianapolis, INBuilt 2009 · S/N 9288N193LLIndiana University Health Inc · Indianapolis, INBuilt 2010 · S/N 9353N194LLIndiana University Health Inc · Indianapolis, INBuilt 2010 · S/N 9357N195LLIndiana University Health Inc · Indianapolis, INBuilt 2008 · S/N 9226N198LLMetro Aviation Inc · Shreveport, LABuilt 2008 · S/N 9158N1SDPinellas County Sheriffs Office · Clearwater, FLBuilt 2015 · S/N 8024N203CHCoastal Helicopters Inc · Juneau, AKBuilt 1981 · S/N 1430N2127SEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 1989 · S/N 2213N214GHCobalt Holdings Inc · Pacoima, CABuilt 1991 · S/N 2537N216CHCoastal Helicopters Inc · Juneau, AKBuilt 2002 · S/N 3619N216EHBristow LLC · Lake Charles, LABuilt 1999 · S/N 3184N217FDBristow LLC · Lake Charles, LABuilt 2007 · S/N 4221N226PDAnaheim Police Dept · Fullerton, CABuilt 2004 · S/N 3879N234BUHeli-USA Corp · Houston, TXS/N 1210N240SFOsf Aviation LLC · Peoria, ILBuilt 2010 · S/N 9403N244TXBrenthel Industries LLC · Helena, MTBuilt 2008 · S/N 4408N249GSPau Hana Enterprises LLC Series III · Las Vegas, NVBuilt 1988 · S/N 2167N251HIsland Helicopters Kauai Inc · Lihue, HIBuilt 2005 · S/N 3975N261AWAll Wool Aviation LLC · Coral Gables, FLBuilt 2014 · S/N 7869N261MHMetrohealth System · Cleveland, OHBuilt 2009 · S/N 9250N263MHMetrohealth System · Cleveland, OHBuilt 2009 · S/N 9311N266MHMetro Aviation Inc · Shreveport, LABuilt 2023 · S/N 9877N267MHMetro Aviation Inc · Shreveport, LABuilt 2023 · S/N 9879N273AMAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0273N273NEMetro Aviation Inc · Shreveport, LABuilt 2013 · S/N 9586N27WAWings Air Helicopters LLC · West Harrison, NYBuilt 1994 · S/N 2792N282SArrow Aviation Company LLC · Broussard, LABuilt 1985 · S/N 760282
Back to AD 2012-24-03